I was reading this topic with passing interest the other day. But events of the last 12 hours, has me searching this thread and other threads referenced here without any real insights as to what could be wrong.
The event in question is this. I live in Delhi, and have a Santro Xing AT 2003 model - I am the first and only owner, and the car has been sparingly but lovingly driven. For last several weeks, the car was not driven (since about 3rd January). It was parked under a tree, with a car-cover on.
Today, I decided to try taking the car out but it would not start (around 7AM). I toyed with the idea of jump-starting it, but gave up and ended up calling Exide Batmobile. They diagnosed the battery needed charging after so many days of non-use, jump-started the car and left. I took the car out for some errands and returned after one hour. Car was continuously running during this time. On return, I turned off the ignition , and tried to start again. Click-click-click but engine would not fire up.
I called up the battery shop , and they sent over a stand-by battery and took away mine for charging (around 10 am). I started the car with this stand-by and took it to the main dealer (MGF-Okhla) for a much needed service (60000 kms) - this was anyway overdue for last 2 months. Anyhow, once I reached the dealership, I turned off the ignition. Within minutes the service technician showed up. When he tried to turn on the car , it would not start. I explained to him, that this is a stand-by battery, it is possible it has become weak. However he should test if the car starts with his own battery.
Later he reported that the car did not appear to have any electrical faults. He fitted the stand-by battery and arranged for the car to be sent back with his driver- who reached me in about 30 minutes (again 30 mins of continuous running). When this person reached he turned off the ignition, and again the car would not start.
Anyhow, the dealer's driver left, leaving my car stranded in the middle of the narrow lanes of our neighbourhood.
Now, I called the battery shop guy, and he sent over my original battery (now charged up). Now, the battery shop guy showed me a little spark when he connected the positive terminal (negative was previously connected) - car keys were in my pocket at the time.
Once my own battery was installed the car started up without any trouble.
I called up the main dealer service technician, and told him, how is it possible for a spark to come at the terminals, without the key turned in the ignition -his point was that it could be because the music system or central locking system could be in an always "on" state. The battery guy insisted, it must be a short in the wiring draining the battery. He told me, if I wanted to , he could disconnect the battery's positive terminal -so that at least the car could be started tomorrow morning. The upshot of this conversation, was that the service technician told me to leave the connections as is.... and if indeed the battery was being drained due to a short circuit, he would send someone over to jump-start the car and bring it back to the workshop in the morning.
Anyhow, the battery shop guy left, and I parked the car properly. Then I turned off the ignition. And my fears were indeed confirmed, the car would not start again.
I left the scene, sms'ed the service technician to send an electrician and a jumper cable in the morning.
Out of curiosity, I returned back to the spot after an hour. The car was cold by this time. I turned the key, and the engine roared to life without any hiccup.
I am confused

. The only pattern I can figure out, is that the motor won't turn-over when warm, but will when relatively colder (on the same battery). Also , when warm, and fitted with a fully charged battery it does indeed turn-over. Thoughts running through my mind:
a) As the main dealer suggests, is it possible that my battery (bought 24th Jan 2011) and the stand-by battery are/were well-past their prime and it's time for a new battery?
b) Or - a) is not true. The battery is fine. but it is getting drained.
c) Or - a) and b) are both not true. There is a problem elsewhere - where?