Crashed my database

Hi Peter,

sorry for the issues you experienced when trying to uninstall Leaflet Maps Marker.

I just tried to reproduce the issue by uninstalling a fresh installation on our dev servers with different configurations, but failed to reproduce the issue.
This and the fact, the the code for uninstall has not really changed for months now, let me assume that this issue might not be directly related to our plugin but rather a general database issue.

FYI – on uninstall, only the following components are removed automatically:

• database table wp_leafletmapsmarker_markers
• database table wp_leafletmapsmarker_layers
• plugin specific transients from wp_options
• plugin specific options from wp_options
• plugin files in /wp-content/plugins/leaflet-maps-marker/
• marker icon files in /wp-content/uploads/leaflet-maps-marker-icons/

I would really like to help finding out what happened on your server – so that I can verify my assumption, that this was rather caused by a database issue than by our uninstall code.

Anyway in order to achieve this, I would need your help with the following questions:

• Can you please provide more information on what happened exactly after uninstalling the plugin? Was the site not accessible anymore on backend/frontend, both? How did you notice the error?
• Which environment are you using – Apache, mySQL or a special setup, which versions?
• What do you mean by database getting corrupted? Which tables were affected?
• Do you have access to PHP error log and mySQL error log for more details?
• Is there a chance to have access to a test site on your server where this issue can be reproduced?

best,

Robert

Hi Robert,

my WP installation and DB is hosted by my web space provider, so my options to provide post-mortem information is rather restricted.

Anyway:

• Both front and back end are dead: Error establishing a database connection.
• Corrupted tables are ssux_sitemeta, ssux_4_options, ssux_3_options, ssux_2_terms, ssux_2_options, ssux_options. My provider seems to like the ssux_ prefix.
• Automatic repair failed – I believe it is because I have insufficient write permissions.
• I’m using MySQL 5.5.
• I do not have access to error logs. Also, there is no test site.

Thanks, Peter

Hi Peter,

the error “error establishing a database connection” does not explicitly mean that database tables are currupted, in my experience this is often related to a general availability issue of the database server.

I would suggest to contact your hoster to verify the general status of the database server – is it up and running, are there any general known issues?

regarding the corrupted tables you mentioned: at least ssux_2_terms is not touched on uninstall by Leaflet Maps Marker, the others are but as said before I do not see an explicit relation to the uninstall here. I would like to know how you checked the corrupted status of those mentioned tables – via phpmyadmin? which errors did you see there that you say the tables are corrupted?
best,

Robert

Hi Robert,

I’m aware that “error establishing a database connection” can have a lot of reasons, but in this case it is a corrupted database for sure. WP offers to repair it when I try to reach wp-admin (“One or more database tables are unavailable. The database may need to be repaired.”). phpmyadmin reports error #114 and says:

db_330986_1.ssux_2_options 	check 	warning 	Table is marked as crashed and last repair failed
db_330986_1.ssux_2_options 	check 	warning 	1 client is using or hasn't closed the table prope...
db_330986_1.ssux_2_options 	check 	warning 	Size of datafile is: 563600       Should be: 52564...
db_330986_1.ssux_2_options 	check 	error 	Keypointers and record positions doesn't match
db_330986_1.ssux_2_options 	check 	warning 	Found 36128 deleted space.   Should be 0
db_330986_1.ssux_2_options 	check 	warning 	Found 21 deleted blocks       Should be: 0
db_330986_1.ssux_2_options 	check 	warning 	Found 368 key parts. Should be: 300
db_330986_1.ssux_2_options 	check 	error 	Corrupt

(Similar for the other corrupted tables)

Thanks, Peter

Hi Peter,

thanks for the additional infos. Anyway this still gives no clue for me why e.g. the options-table got corrupted in the first place.

I did some more tests on my dev servers, as your table names suggest you are using WordPress Multisite – anyway also on my mulitsite test installations installation and uninstallation worked as designed without any corrupt database tables.

This and no similar reports from other users ever still fosters my assumption that there is a general database server issue responsible here. I know that this does not help you, especially as your last action seems to have been uninstalling Leaflet Maps Marker before the error occured.

Anyway from my side I cannot give any additional input yet – as said before, input from your hoster about the general status of your mySQL database would be needed. So if possible please contact your hoster support to also have a look at the database and the related log files, so that we can figure out what exactly happened. You could also point him to https://chrisadams.me.uk/2010/05/16/how-to-fix-a-wordpress-site-when-the-database-corrupts-on-you/ which gives details about how to repair a WordPress database on a DB-Admin-Level.

best,

Robert

Hi Peter,
did you already receive any info/help from your hoster support?
best,
Robert

Hi Robert, sorry for not updating you, I’ve been busy with other stuff. Yes, my hoster was able to resolve the problem, my site is online again. They are inconclusive about the cause of the problem. Best, Peter

Thanks for the update Peter – glad to hear that your site is up and running again. Would you mind changing your rating as there is no clear evidence that my plugin caused this database corruption?