MySQL server has gone away
1. April 2009
comments feedToday we had a database crisis due to a powercut. Apart from corrupted tables (because of the immediate "shutdown") we also had another problem: CLI scripts/cronjobs suddenly threw a MySQL server has gone away Exception after a really short amount of time (maybe 30 seconds)
I found this useful list, the only problem was: all the points didn't match for my case. So we came up with an own list that we worked through:
- Flush privileges
- Restore the User grants/privileges
- Restart the MySQL server
- dpkg-reconfigure mysql-server-5.0 (or similar)
In our case restarting the MySQL server fixed the problem.
5 comments
Dominik Jungowski
02.04.2009, 17:06 o'clock
Since the server had the power cut off few hours before that option didn't really come into our minds ;o)
ahmedhazem_1330
13.04.2009, 21:50 o'clock
أنا مشترك فى هذا الموقع وعضويتى مفعلة لاننى سددت الاشتراك لمدة ثلاث شهور واسم الدخول وكلمة المرور صحيحة ورغم ذلك يصلنى رسائل من الموقع بتأكيد معلوماتى المسجلة به وبرغم ذلك لاأستطيع الدخول ارجو مساعدتى من فضلكم فى حل المشكلة واشكرتعاونكم
recent posts
Joey Rivera
02.04.2009, 16:24 o'clock
When in doubt reboot :p