The backup process completed, but 1 error occurred.

Suddenly, backup process is throwing an error "roundcube: mysqldump failed -- database may be corrupt" from 6th October 2018. I have run mysql check query on all databases and not found any database as corrupt. Even I exported roundcude table without any error. Please find attached file "error.txt" for more details. Any idea, how to fix it? - Removed -

roundcube.users
note     : The storage engine for the table doesn't support repair
roundcube.identities
note     : The storage engine for the table doesn't support repair
roundcube.contacts
note     : The storage engine for the table doesn't support repair
roundcube.contactgroups
note     : The storage engine for the table doesn't support repair

Any way to fix the above issue.

cPanelLauren

October 22, 2018 17:08

Hi @nshah14285 We do have a case open for this behavior but it's typically only occurring when you have a large number of email accounts - CPANEL-22818. A fix for this is being worked on for v76 of cPanel. The workaround for this is to convert to mysqlite you can do this by running: /scripts/convert_roundcube_mysql2sqlite

nshah14285

October 25, 2018 04:41

Thanks for reply. Is it safe to run on live server? I hope there is no loss of data by converting roundcube to sqlite.

October 25, 2018 12:54

Hi @nshah14285 it should be fine to run on a live server but if you have concerns about it feel free to open a ticket with us so we can help. Thanks!

Cesar Caballero

November 09, 2018 10:32

Hi, I have executed the script in a server in production with approximately 20.000 mailbox, it took more or less 3 hours, but solved the error "roundcube: mysqldump failed - database may be corrupt" Now everything is ok. Thank you

November 09, 2018 12:40

Hi @Cesar Caballero I'm really happy to hear that the issue is now resolved. Thanks for letting us know!

The backup process completed, but 1 error occurred.

Comments

Didn't find what you were looking for?