yesterday it happened again. the second time in only two months one of the tables was suddenly corrupt. and every time it happens to be "cake_sessions" anyone else who had similar issues? its a nginx / mysql system.
the result was that the whole DB was down again. But even after restarting everything the corrupt table made it impossible to login etc. and the worst about it all is that the page doesnt even throw warnings/ errors for the user. it should return a 50x HTTP response if the DB is down (mysql connect fails etc). instead, the static content is still displayed. only the dynamic data (coming from the DB) is missing. this is BAD for the crawlers/searchengines (with a 200 why should they know the page is screwed up and they better come back later?), this is even WORSE for the users. I got hundrets of emails again why they cannot log in. why they have be deleted and so on and so on. Without proper 503 response (AppError of some kind) it is highly confusable for all visitors. I already filed a ticket for this very urgent matter: http://cakephp.lighthouseapp.com/projects/42648/tickets/1780-proper-apperror-on-mysql-errors#ticket-1780-3 unfortunetely it might go into 2.0. Anybody an idea how this could be integrated in 1.3 as a quick fix? Its really a huge pain in the butt! Of course i could always make a random DB call in my AppController which always gets one record. If it comes back empty, I could trigger an AppError. But that is messy. I was hoping on a more elegant solution here... And maybe we could integrate it in 1.3 as an important fix of a terrible situation. -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php