Arnie Posted January 26, 2011 Share Posted January 26, 2011 We occasionally get a database error once in a blue moon. We run a >3Gb database and sometimes tables like ibf_core_markers can be left locked in use by mysql. It's a simple fix to just flag a repair in phpmyadmin. When IPB gets errors and puts up the database error page saying "there appears to be an error with the database" it'd be real nice if it booted a lossless automatic check/repair routine. Here's the example error page: http://img403.imageshack.us/i/arnieserror.jpg/ Would it be possible in a future IPB release to tie the error page to a simple automated check/repair mysql system? In the case of simple errors the forum could fix things, log it and email the admins. In the case of more serious errors it could email the admins to let them know the board had a DB error. Obviously I'm talking about a lossless mysql check/repair routine here that'd clear simple things like locked tables etc. Link to comment Share on other sites More sharing options...
Kessler Posted January 29, 2011 Share Posted January 29, 2011 This would be better in the feedback forum. Also you might consider asking for a mod that would detect when the table is locked and repair it automatically. Link to comment Share on other sites More sharing options...
Arnie Posted January 29, 2011 Author Share Posted January 29, 2011 Ah sorry, any chance the topic could be moved to the right forum and correct my mistake? Link to comment Share on other sites More sharing options...
Arnie Posted January 30, 2011 Author Share Posted January 30, 2011 Thanks for moving the topic. As mentioned above it'd be nice to see an auto-repair facility and an email notification to admin for database error.s Link to comment Share on other sites More sharing options...
Arnie Posted March 11, 2011 Author Share Posted March 11, 2011 Any chance of a reply on this one? Link to comment Share on other sites More sharing options...
Arnie Posted March 14, 2011 Author Share Posted March 14, 2011 Well I've not had much luck with any input so I've added my own repair routine to the mysqlcleanup.php routine in the task scheduler. It'll now repair a specific table if needed for me. I'm probably going to write my own routine and add it to the task scheduler. Seriously though a self repairing mysql routine can't be a bad thing. Not sure why it's not already an option. Say a task schedule routine that is only kicked into being/running if a mysql error occurs. It then checks all relevant tables and runs a lossless repair if needed and emails the admin the results or if further attention is needed. Be nice if someone from the staff chimed in and said hello, if only to say "hi nice idea, but we aren't doing this". :) Link to comment Share on other sites More sharing options...
Michael Posted March 14, 2011 Share Posted March 14, 2011 Staff does not respond to every suggestion, but they do read them. If they responded to every topic like this, and then had to keep answering questions and such, they'd never get any other work done. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.