"Omg!! The db has gone down, man" , was our first reaction. We have been preparing for our first Project demo and finalizing things when thing go haywire. "Did someone fire any 'nasty' queries" asked our project lead hurriedly. We had no clue about it. All is fine and what why the heck is the db down? Our lead received an e-mail instantly notifying that one our project members had fired a very complicated sql query that almost killed the host server at Austin and brought the whole db down leaving all dependent developers around the world in murky waters.
Our lead asked us to ensure that it was not us who fired any such queries. We were confident that it was not fomr our side since things were working pretty fine until a few minutes back nad noone had made any alterations to cause this havoc. Taking our words, our lead mailed the server control team, our reply. Few minutes later there is a huge gush of ppl rusing towards the guide,s monitor. There was the reply from the Austin centre. It ran like this. Hi XXX, I would not call the next snetence as simple and appended to the single sentence was a 25-page extract of the query that killed the host box. The query finished with these lines, ' Physical query sent to the database at 11:25 hrs user: sisridha. Thats my Global Id ;). 'Gosh!!', All heads made a sudden turn towards me. I gave a vague smile unsure for a second that why it was me. Breaking out of the cynosure, i exclaimed, ' Yup , It would show my global is beacuse i hosted the application and other team members were accessing the appln through my url. So any screwing up would always reference my name. Later after few minutes of investigation of the query, we figured it out that it was another collegue of mine who had run the query behind a seemingly simple request. Man, one should learn a lesson from a disaster. But that wasnt the case with me. I ran into trouble again a couple of days which was far more complicated. I will blog about it later. Nothing wrong in citing professional happenings to cite some learnings in life, Or is it?
We made history here..
Subscribe to:
Post Comments (Atom)

No comments:
Post a Comment