SOLVED The backup process completed, but 1 error occurred.

[nshah14285]

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]

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]

Thanks for reply.

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

 

[cPanelLauren]

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]

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

 

[cPanelLauren]

Hi @Cesar Caballero

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