Transfer Failing SQL Restore Error 255

HELP!

I am trying to transfer a site from one Cpanel Server to another using Remote User Account Transfer and I keep running into this issue...

Both servers have the same OS (AlmaLinux 8) Same PHP 8.2, Same MariaDB server, and the configuration in cpanel is exactly the same between machines (except for the hostnames of course)

I run the transfer and all runs good until the transfer of the database. portion and then I am hit with the following error.

[code]Transfer complete. Awaiting subprocess completion …

Cpanel::Exception::Database::Error/(XID 8q9edj) The system received an error from the “MySQL” database “satellit_xenforo3”: ER_PARSE_ERROR (You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1)\x0A at /usr/local/cpanel/Cpanel/DBI.pm line 200, <$rfh> line 9585.\x0A\x09Cpanel::DBI::_create_exception(Cpanel::DBI::Mysql::db=HASH(0x2a88c68), "DBD::mysql::db do failed: You have an error in your SQL synta"..., undef) called at /usr/local/cpanel/Cpanel/DBI.pm line 188\x0A\x09Cpanel::DBI::_error_handler("DBD::mysql::db do failed: You have an error in your SQL synta"..., Cpanel::DBI::Mysql::db=HASH(0x2a88c68), undef) called at /usr/local/cpanel/Cpanel/Mysql/Restore/Client.pm line 456\x0A\x09Cpanel::Mysql::Restore::Client::_handle_one_delimited_mysql_statement(Cpanel::Mysql::Restore::Client=HASH(0x273ea40), SCALAR(0xdfc888), Cpanel::DBI::Mysql::db=HASH(0x2a88c68)) called at /usr/local/cpanel/Cpanel/Mysql/Restore/Client.pm line 234\x0A\x09Cpanel::Mysql::Restore::Client::__ANON__() called at /usr/local/cpanel/Cpanel/Mysql/Restore/Client.pm line 283\x0A\x09Cpanel::Mysql::Restore::Client::run(__CPANEL_HIDDEN__, Cpanel::Output::Callback=HASH(0x271f018), __CPANEL_HIDDEN__, GLOB(0x2704398), __CPANEL_HIDDEN__, __CPANEL_HIDDEN__, __CPANEL_HIDDEN__, HASH(0x2713c58), ...) called at bin/restore_mysql_for_account_restore.pl line 106\x0A\x09bin::restore_mysql_for_account_restore::__ANON__() called at /usr/local/cpanel/3rdparty/perl/536/cpanel-lib/Try/Tiny.pm line 100\x0A\x09eval {...} called at /usr/local/cpanel/3rdparty/perl/536/cpanel-lib/Try/Tiny.pm line 91\x0A\x09Try::Tiny::try(CODE(0x271ee68), Try::Tiny::Catch=REF(0xda0bd8)) called at bin/restore_mysql_for_account_restore.pl line 119\x0A\x09bin::restore_mysql_for_account_restore::run(bin::restore_mysql_for_account_restore=HASH(0x2715d98)) called at bin/restore_mysql_for_account_restore.pl line 62\x0A at bin/restore_mysql_for_account_restore.pl line 118, <$rfh> line 9585.

Connecting to SQL server (/var/lib/mysql/mysql.sock) as “satelliteguys” in order to restore “satellit_xenforo3” …

Disabling InnoDB strict mode for database restore for “satellit_xenforo3” …

Restoring database data for “satellit_xenforo3” …

Processing SQL statements …

The database restoration subprocess for “satellit_xenforo3” has ended.

The MySQL restore process exited with the error “255”.

Removed empty DB for failed restore of “satellit_xenforo3”.

The system has saved the database archive data in the directory “/home/satelliteguys/cpmove_failed_mysql_dbs.1712071766”. You may use this directory’s contents to restore your data manually.

The system failed to restore the “satellit_xenforo3” database because of an error: The system encountered an unknown error while restoring MySQL statements: The subprocess reported error number 255 when it ended.[/code]

And then the summary shows the following...

[code]TRANSFER: 1 completed, 0 had warnings, and 0 failed.

RESTORE: 1 completed, 1 had warnings, and 0 failed.

RESTORE: Account “satelliteguys”: Warnings

Stream failed: Cpanel::Exception/(XID ajr9tt) rsync streaming failed: The “/usr/bin/rsync --progress --human-readable --archive --verbose --exclude=/lscache --rsh /usr/local/cpanel/bin/rsync-user-homedir --insecure --cpanel --apitoken-fd=20 vps.satelliteguys.us satelliteguys: /home/satelliteguys” command (process 3392) reported error number 12 when it ended. at /usr/local/cpanel/Cpanel/Rsync.pm line 82. Cpanel::Rsync::run("Cpanel::Rsync", "setuid", ARRAY(0x748b218), "args", ARRAY(0x748fc28)) called at /usr/local/cpanel/Cpanel/Homedir/Stream.pm line 116 Cpanel::Homedir::Stream::rsync_from_cpanel("api_token", "AVFMHIJCP5KRHICP0VWYVXTA0HTU0YG2", "api_token_username", "satelliteguys", "host", "vps.satelliteguys.us", "destination", "/home/satelliteguys", ...) called at /usr/local/cpanel/Whostmgr/Transfers/Systems/Homedir.pm line 304 Whostmgr::Transfers::Systems::Homedir::__ANON__() called at /usr/local/cpanel/3rdparty/perl/536/cpanel-lib/Try/Tiny.pm line 100 eval {...} called at /usr/local/cpanel/3rdparty…s::Session::Processor::_process_child_with_output_redirection(Whostmgr::Transfers::Session::Processor=HASH(0x3646e30), Whostmgr::Transfers::Session=HASH(0x358dd70), 0, "vpssatellitegunoroo20240402151155ZIp") called at /usr/local/cpanel/Whostmgr/Transfers/Session/Processor.pm line 205 Whostmgr::Transfers::Session::Processor::__ANON__() called at /usr/local/cpanel/Cpanel/ForkAsync.pm line 72 eval {...} called at /usr/local/cpanel/Cpanel/ForkAsync.pm line 72 Cpanel::ForkAsync::do_in_child(CODE(0x361f6e8)) called at /usr/local/cpanel/Whostmgr/Transfers/Session/Processor.pm line 207 Whostmgr::Transfers::Session::Processor::start(Whostmgr::Transfers::Session::Processor=HASH(0x3646e30)) called at bin/start_transfer.pl line 57 main::__ANON__() called at /usr/local/cpanel/3rdparty/perl/536/cpanel-lib/Try/Tiny.pm line 100 eval {...} called at /usr/local/cpanel/3rdparty/perl/536/cpanel-lib/Try/Tiny.pm line 91 Try::Tiny::try(CODE(0x358dbd8), Try::Tiny::Catch=REF(0x27ec6f0)) called at bin/start_transfer.pl line 72

The MySQL restore process exited with the error “255”.

Removed empty DB for failed restore of “satellit_xenforo3”.

The system has saved the database archive data in the directory “/home/satelliteguys/cpmove_failed_mysql_dbs.1712071766”. You may use this directory’s contents to restore your data manually.

The MySQL restore process exited with the error “255”.

Removed empty DB for failed restore of “satellit_xenforo3”.

The remote MySQL dump failed because of an error (WebSocket 1011, ttkp2e).

CLAMAVSCANS: The key “CLAMAVSCANS” is unknown, so the system will not restore this key.

FEATURE-AUTOSSL: The domain value 'AUTOSSL' is invalid.[/code]

I need to get this site moved. Any ideas? Please help. :) Thank you!

cPRex Jurassic Moderator

April 02, 2024 17:07

Hey there! It definitely seems like an issue with the database on the Source machine. Do you have root access to the Source server? If not, you'll likely need to contact the hosting provider or datacenter to have them check the database itself.

If you do have root access, you can try running this to see if it exports properly:

cd /var/lib/mysql/
mysqldump db_name > test_dump.sql

If not, it should give you more specific details about where the database is running into problems.

Scott Greczkows

April 02, 2024 17:19

I do have root access, but I think I found the cause of the issue and fixed it.

I had to add the following to the my.cnf

net_read_timeout = 300
net_write_timeout = 500

The transfer just finished without errors, but I haven't checked it yet. But I am assuming it worked. :)

April 02, 2024 17:59

Oh nice, much easier than anything I was headed toward!

Transfer Failing SQL Restore Error 255

[code]TRANSFER: 1 completed, 0 had warnings, and 0 failed.

RESTORE: 1 completed, 1 had warnings, and 0 failed.

Comments

Didn't find what you were looking for?