SOLVED The backup process completed, but 1 error occurred.

nshah14285

Member
May 26, 2011
7
0
53
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 -

Code:
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.
 
Last edited by a moderator:

cPanelLauren

Product Owner
Staff member
Nov 14, 2017
13,295
1,255
313
Houston
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:

Code:
/scripts/convert_roundcube_mysql2sqlite
 

nshah14285

Member
May 26, 2011
7
0
53
Thanks for reply.

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

Cesar Caballero

Registered
Dec 20, 2017
1
0
1
Paraguay
cPanel Access Level
Root Administrator
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