Error moving accounts from one server to another

[maksol]

I'm trying to move accounts from one server to another via whm root, using the Copy multiple accounts / packages from another server but I can not, it follows that the error appears, this occurs when trying to copy any account in server

pkgacct started.
pkgacct -- attempting to use daily backup to create a account package
pkgacct -- could not use daily backup because it is missing (/backup/cpbackup/daily/youvitae)
pkgacct version 10 - user : youvitae - tarball: 1 - target mysql : 5.1 - split: 1 - incremental: 0 - homedir: 0 - archive version: 3 - running with uid 0
pkgacct working dir : /home/cpmove-youvitae
Copying Reseller Config...Done
Copying Suspension Info (if needed)...Done
Copying SSL Certificates, CSRS, and Keys...Done
Copying Domain Keys....Done
Copying Counter Data....Done
Copying Bandwidth Data......youvitae-http-rate.rrd....youvitae-imap-rate.rrd....youvitae-smtp-peak.rrd....youvitae-all-rate.rrd....youvitae-http-peak.rrd....youvitae....youvitae.net.br-http-peak.rrd....youvitae-pop3-peak.rrd....youvitae-pop3-rate.rrd....youvitae.net.br-all-peak.rrd....youvitae-smtp-rate.rrd....youvitae-imap-peak.rrd....youvitae.net.br-http-rate.rrd....youvitae-all-peak.rrd....youvitae-ftp-peak.rrd....youvitae-ftp-rate.rrd....youvitae.net.br-all-rate.rrd....youvitae.net.br..Done
Copying Dns Zones.......youvitae.net.br...Done
Copying Mail files....Done
Copying frontpage files....Done
Copying proftpd file....Done
Copying www logs.......log file sizes [4 byte(s)]......ftp.youvitae.net.br-ftp_log.offsetftpbytes......ftp.youvitae.net.br-ftp_log......ftp.youvitae.net.br-ftp_log.offset......youvitae.net.br-bytes_log......youvitae.net.br-bytes_log.offset......youvitae.net.br...Done
Copy userdata...Done
Copy custom virtualhost templates...Done
Copying mailman lists and archives....
Done
Determining mysql dbs......mysql version: 5.5......mysqldump version: 5.5...Saving mysql privs...Done

Skipping Logaholic Backup. Logaholic is globally disabled on this system.

Storing mysql dbs...horde.turba_objects.........
horde.turba_objects OK
(1108 bytes) horde.horde_prefshorde.horde_prefs OK
(1100 bytes) horde.kronolith_shareshorde.kronolith_shares OK
(1126 bytes) horde.kronolith_storagehorde.kronolith_storage OK
(1126 bytes) horde.mnemo_memoshorde.mnemo_memos OK
(1104 bytes) horde.nag_taskshorde.nag_tasks OK
(1096 bytes)





ERROR: Failed to dump one or more databases

Trace Output
Password: ==sshcontroloutput== stdin: is not a tty pkgacct started. pkgacct -- attempting to use daily backup to create a account package pkgacct -- could not use daily backup because it is missing (/backup/cpbackup/daily/youvitae) pkgacct version 10 - user : youvitae - tarball: 1 - target mysql : 5.1 - split: 1 - incremental: 0 - homedir: 0 - archive version: 3 - running with uid 0 pkgacct working dir : /home/cpmove-youvitae Copying Reseller Config...Done Copying Suspension Info (if needed)...Done Copying SSL Certificates, CSRS, and Keys...Done Copying Domain Keys....Done Copying Counter Data....Done Copying Bandwidth Data......youvitae-http-rate.rrd....youvitae-imap-rate.rrd....youvitae-smtp-peak.rrd....youvitae-all-rate.rrd....youvitae-http-peak.rrd....youvitae....youvitae.net.br-http-peak.rrd....youvitae-pop3-peak.rrd....youvitae-pop3-rate.rrd....youvitae.net.br-all-peak.rrd....youvitae-smtp-rate.rrd....youvitae-imap-peak.rrd....youvitae.net.br-http-rate.rrd....youvitae-all-peak.rrd....youvitae-ftp-peak.rrd....youvitae-ftp-rate.rrd....youvitae.net.br-all-rate.rrd....youvitae.net.br..Done Copying Dns Zones.......youvitae.net.br...Done Copying Mail files....Done Copying frontpage files....Done Copying proftpd file....Done Copying www logs.......log file sizes [4 byte(s)]......ftp.youvitae.net.br-ftp_log.offsetftpbytes......ftp.youvitae.net.br-ftp_log......ftp.youvitae.net.br-ftp_log.offset......youvitae.net.br-bytes_log......youvitae.net.br-bytes_log.offset......youvitae.net.br...Done Copy userdata...Done Copy custom virtualhost templates...Done Copying mailman lists and archives.... Done ......... Determining mysql dbs......mysql version: 5.5......mysqldump version: 5.5...Saving mysql privs...Done ...Done Skipping Logaholic Backup. Logaholic is globally disabled on this system. Storing mysql dbs...horde.turba_objects......... horde.turba_objects OK (1108 bytes) horde.horde_prefshorde.horde_prefs OK (1100 bytes) horde.kronolith_shareshorde.kronolith_shares OK (1126 bytes) horde.kronolith_storagehorde.kronolith_storage OK (1126 bytes) horde.mnemo_memoshorde.mnemo_memos OK (1104 bytes) horde.nag_taskshorde.nag_tasks OK (1096 bytes) ERROR: Failed to dump one or more databases


Password: ==sshcontroloutput==
stdin: is not a tty
pkgacct started.
pkgacct -- attempting to use daily backup to create a account package
pkgacct -- could not use daily backup because it is missing (/backup/cpbackup/daily/youvitae)
pkgacct version 10 - user : youvitae - tarball: 1 - target mysql : 5.1 - split: 1 - incremental: 0 - homedir: 0 - archive version: 3 - running with uid 0
pkgacct working dir : /home/cpmove-youvitae
Copying Reseller Config...Done
Copying Suspension Info (if needed)...Done
Copying SSL Certificates, CSRS, and Keys...Done
Copying Domain Keys....Done
Copying Counter Data....Done
Copying Bandwidth Data......youvitae-http-rate.rrd....youvitae-imap-rate.rrd....youvitae-smtp-peak.rrd....youvitae-all-rate.rrd....youvitae-http-peak.rrd....youvitae....youvitae.net.br-http-peak.rrd....youvitae-pop3-peak.rrd....youvitae-pop3-rate.rrd....youvitae.net.br-all-peak.rrd....youvitae-smtp-rate.rrd....youvitae-imap-peak.rrd....youvitae.net.br-http-rate.rrd....youvitae-all-peak.rrd....youvitae-ftp-peak.rrd....youvitae-ftp-rate.rrd....youvitae.net.br-all-rate.rrd....youvitae.net.br..Done
Copying Dns Zones.......youvitae.net.br...Done
Copying Mail files....Done
Copying frontpage files....Done
Copying proftpd file....Done
Copying www logs.......log file sizes [4 byte(s)]......ftp.youvitae.net.br-ftp_log.offsetftpbytes......ftp.youvitae.net.br-ftp_log......ftp.youvitae.net.br-ftp_log.offset......youvitae.net.br-bytes_log......youvitae.net.br-bytes_log.offset......youvitae.net.br...Done
Copy userdata...Done
Copy custom virtualhost templates...Done
Copying mailman lists and archives....
Done
.........
Determining mysql dbs......mysql version: 5.5......mysqldump version: 5.5...Saving mysql privs...Done
...Done

Skipping Logaholic Backup. Logaholic is globally disabled on this system.

Storing mysql dbs...horde.turba_objects.........
horde.turba_objects OK
(1108 bytes) horde.horde_prefshorde.horde_prefs OK
(1100 bytes) horde.kronolith_shareshorde.kronolith_shares OK
(1126 bytes) horde.kronolith_storagehorde.kronolith_storage OK
(1126 bytes) horde.mnemo_memoshorde.mnemo_memos OK
(1104 bytes) horde.nag_taskshorde.nag_tasks OK
(1096 bytes)
ERROR: Failed to dump one or more databases

Done
Transfer Error
Unable to package account

 

[Brian]

That potentially looks like something may be killing or otherwise impeding the mysqldump processes that pkgacct would be forking at that time. If you have any automated scripts/tools that are designed to kill high resource consumption processes, that could be a cause. But, the origin cause isn't necessarily clear based on the information you've posted. Corrupt databases and other factors could cause a mysqldump to fail (and thus that error).

Your best bet is going to be to open up a ticket with our support analysts and have them review the situation and identify the true origin cause of the errors. Links are in my signature to open such a ticket.

 

[tarik916]

I had this issue and it turned out to be a full /tmp disk on the originating server.