The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL Backup Error After Update

Discussion in 'Database Discussions' started by Un Area, Oct 7, 2015.

  1. Un Area

    Un Area Well-Known Member

    Joined:
    Nov 16, 2006
    Messages:
    78
    Likes Received:
    0
    Trophy Points:
    6
    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.


    Code:
    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!
     
    #1 Un Area, Oct 7, 2015
    Last edited by a moderator: Oct 8, 2015
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    651
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  3. Un Area

    Un Area Well-Known Member

    Joined:
    Nov 16, 2006
    Messages:
    78
    Likes Received:
    0
    Trophy Points:
    6
    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
     
  4. Un Area

    Un Area Well-Known Member

    Joined:
    Nov 16, 2006
    Messages:
    78
    Likes Received:
    0
    Trophy Points:
    6
    Seems that some cpanel script is calling to backup that database in the new update.
     
  5. Un Area

    Un Area Well-Known Member

    Joined:
    Nov 16, 2006
    Messages:
    78
    Likes Received:
    0
    Trophy Points:
    6
    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?????????????

    Code:
    [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 exist
    
    
     
    #5 Un Area, Oct 21, 2015
    Last edited by a moderator: Oct 21, 2015
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    651
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    It looks like there's an issue with the roundcube database that needs to be addressed. Try running this command:

    Code:
    mysqldump roundcube > /root/roundcube-cp.sql
    Does it execute without error?

    Thank you.
     
  7. Un Area

    Un Area Well-Known Member

    Joined:
    Nov 16, 2006
    Messages:
    78
    Likes Received:
    0
    Trophy Points:
    6
    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?
     
  8. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    651
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
Loading...

Share This Page