MySQL Backup Error After Update
I updated my cpanel/whm server to 11.50.0 (build 30) version release (and with that php to 5.5.29 and mysql to 5.5.42). All is working fine except for the backup logs that are filled with the error bellow sending an email log of 2mb all nights when it was of 400kb before the update.
Roundcube is not installed in the server, is deactivated at Tweak Settings, so I dont understand why is trying to backup a roundcoube database in every account.
This notice is the result of a request from "Legacy cPanel Backup System" How can I remove this error from the logs? Thank you!
The backup process on "server.domain.com" completed.
Please review the attached log for further details.
Cpanel::DBI::_error_handler("DBD::mysql::db selectall_arrayref failed: Table 'roundcube.us"..., Cpanel::DBI::Mysql::db=HASH(0x9670928), undef) called at bin/admin/Cpanel/cpmysql.pl line 219
[2015-09-26 04:01:25 -0300] ...mysqldump version: 5.5.42...[2015-09-26 04:01:25 -0300] ...mysql version: 5.5...[2015-09-26 04:01:25 -0300] Saving mysql privs...[2015-09-26 04:01:25 -0300] Done
ERROR 1146 (42S02) at line 1: Table 'roundcube.users' doesn't exist
This notice is the result of a request from "Legacy cPanel Backup System" How can I remove this error from the logs? Thank you!
-
Hello :) Does the "roundcube" database exist at all on this system? If so, are there any issues when running the "mysqlcheck roundcube" command? Thank you. 0 -
The database roundcube exits. When I run mysqlcheck roundcube I get this: roundcube.cache_shared OK roundcube.contactgroupmembers OK roundcube.contactgroups OK roundcube.cp_schema_version OK roundcube.system OK 0 -
Seems that some cpanel script is calling to backup that database in the new update. 0 -
Ok, I changed the legacy backup to the new backup system. The error now doesnt appears in the servers backup log but YES appears in each account log when it is compressed. This error repeats in all accounts at the backup log, how can I get rid of it????????????? [2015-10-21 01:11:28 -0300] Determining mysql dbs...DBD::mysql::db selectall_arrayref failed: Table 'roundcube.users' doesn't exist at /usr/local/cpanel/Cpanel/Exception.pm line 151. Cpanel::Exception::new("Cpanel::Exception::Database::Error", Cpanel::ExceptionMessage::Raw=SCALAR(0x8c37958), HASH(0xa64bc20)) called at /usr/local/cpanel/Cpanel/Exception.pm line 57 Cpanel::Exception::create("Database::Error", Cpanel::ExceptionMessage::Raw=SCALAR(0x8c37958), HASH(0xa64bc20)) called at /usr/local/cpanel/Cpanel/Exception.pm line 72 Cpanel::Exception::create_raw("Database::Error", "DBD::mysql::db selectall_arrayref failed: Table 'roundcube.us"..., HASH(0xa64bc20)) called at /usr/local/cpanel/Cpanel/DBI.pm line 105 Cpanel::DBI::_create_exception(Cpanel::DBI::Mysql::db=HASH(0xa617928), "DBD::mysql::db selectall_arrayref failed: Table 'roundcube.us"..., undef) called at /usr/local/cpanel/Cpanel/DBI.pm line 93 Cpanel::DBI::_error_handler("DBD::mysql::db selectall_arrayref failed: Table 'roundcube.us"..., Cpanel::DBI::Mysql::db=HASH(0xa617928), undef) called at bin/admin/Cpanel/cpmysql.pl line 219 [2015-10-21 01:11:29 -0300] ...mysqldump version: 5.5.42...[2015-10-21 01:11:29 -0300] ...mysql version: 5.5...[2015-10-21 01:11:29 -0300] Saving mysql privs...[2015-10-21 01:11:29 -0300] Done ERROR 1146 (42S02) at line 1: Table 'roundcube.users' doesn't exist0 -
Hello :) It looks like there's an issue with the roundcube database that needs to be addressed. Try running this command: mysqldump roundcube > /root/roundcube-cp.sql
Does it execute without error? Thank you.0 -
I did what you said and execute it without error. The error says that table roundcube.users is missing. I suppose that the error will stop if I create that table, copying it from other roundcube fresh install. My question is why is trying to backup roundcube if roundcube is disabled for all users and never was installed. Shouldnt skip this the backup? 0 -
New I did what you said and execute it without error. The error says that table roundcube.users is missing. I suppose that the error will stop if I create that table, copying it from other roundcube fresh install.
Yes, please correct this issue to ensure backups complete successfully. The database check is completed in-case accounts added Roundcube data before it was disabled. Thank you.0
Please sign in to leave a comment.
Comments
7 comments