I am an idiot, need advice. (runaway sqlite3 script)
by kaz2100 from LinuxQuestions.org on (#5GJ6P)
Hya,
Situation
With a perfect Debian amd64 system, an idiot did something wrong, submitting a crazy query to sqlite3 script.
What happened
A xterm was running "top", and it shows the sqlite3 script ate up entire memory, entire swap... then mouse and keyboard stopped working. I should have stopped the script as soon as possible, but too late. Then x died, user session died. Then, keyboard is back.
It looks like things are back normal after reboot (and take care of several opened files).
What is the best way to recover, if this happens next time?
Is there anything I need to do with sqlite data file? (It looks good now)
I agree I am 100% guilty with no excuse.
regretfully
cheers
Situation
With a perfect Debian amd64 system, an idiot did something wrong, submitting a crazy query to sqlite3 script.
What happened
A xterm was running "top", and it shows the sqlite3 script ate up entire memory, entire swap... then mouse and keyboard stopped working. I should have stopped the script as soon as possible, but too late. Then x died, user session died. Then, keyboard is back.
It looks like things are back normal after reboot (and take care of several opened files).
What is the best way to recover, if this happens next time?
Is there anything I need to do with sqlite data file? (It looks good now)
I agree I am 100% guilty with no excuse.
regretfully
cheers