Huge data loss after optimizing

Hey dileepp89,

Sorry to hear about your problem!

If the records are really deleted, I’m afraid you have to restore those tables from your backup.

But what I don’t understand is that you lost your ‘links’.
Do you mean records were deleted from the ‘wp_links’ table?
My plugin doesn’t do anything with that table…

Did you check in the database if the missing custom fields are really deleted (table: wp_postmeta)

Please let know.

peace,
Rolf

Ticket closed because of a lack of feedback…

You might have to take a look at what is going on, as I can confirm the plugin crashes the wp_postmeta table the moment it’s executed. Please advise on a method to provide you the error_log privately.

Hey Acroplex,

You can mail the log to info [at] cagewebdev [dot] com

thanks,
Rolf

Thanks, email sent.

Ok, got the email, thanks!

Okay, after a quick look: none of the queries in the logfile are in my plugin…
Do you know which plugin fires these queries?

Try to exclude the wp_postmeta table from optimization and see what happens.
(That’s why I built in the exclude table option)

Tricky problem… might be a plugin clash or maybe because too many plugins are updating that same table while it’s being optimized.

Interesting…

Keep me posted! I only like happy users ??

peace,
Rolf

Rolf, my method of testing is this:

1. Disabled plugin.
2. Deleted existing error_log
3. Left it alone for a couple of days: no error_log was created.
4. Enabled plugin.
5. Pressed the Optimize DB (1 click) from the Admin section.

As soon as I do this, a second later, the error_log is created and starts filling up for a while. The wp_postmeta table crashes and needs to be fixed (I use cPanel).

I will exclude the wp_postmeta and will report my findings. Thanks.

Thanks for the feedback!

I want this plugin to work without any problems for anyone…

(quite a challenge with all these different setups!)

when getting these errors, did you try a ‘check table’ (and then maybe ‘repair table’) in PHPMyAdmin?

OK, so I unchecked the wp_postmeta from being optimized and clicked the button.

The error_log produced errors, which I will email you.

Correct, I fix the table after checking, by repairing it.

Since there are over 50,000 regular (happy) users, not complaining about any corrupted tables, it must have something to do with how you set up the server, database or site. But I’ll be happy to figure it out together with you!

You table type is MyISAM? (just a question)

Yes, it’s MyISAM; InnoDB tables are skipped. Sent another log file with some stats.

next try to uncheck all the check boxes in the settings page like ‘Delete trashed items’ and so…
trying to figure out if the deletion of records or the optimization causes the problem