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

[hostdonner]

Hello,

I'm trying to transfer 40 cPanel accounts (or more), from a server working with Cloudlinux 7.9 to Cloudlinux 8.7.

I'm using MySQL 5.7 on both servers, but I keep getting this error with all the websites:
--------------------------------------
Cpanel::Exception::Database::Error/(XID gacbcw) The system received an error from the “MySQL” database “bbb_db1”: ER_PARSE_ERROR (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''{\\"id\\":290,\\"asset_id\\":\\"685\\",\\"title\\":\\"\\\\u0628\\\\u064a\\\\u0627\\\\u0646\\\\u062' at line 1)\x0A at /usr/local/cpanel/Cpanel/DBI.pm line 200, <$rfh> line 6667.\x0A\x09Cpanel::DBI::_create_exception(Cpanel::DBI::Mysql::db=HASH(0x128a950), "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(0x128a950), undef) called at /usr/local/cpanel/Cpanel/Mysql/Restore/Client.pm line 451\x0A\x09Cpanel::Mysql::Restore::Client::_handle_one_delimited_mysql_statement(Cpanel::Mysql::Restore::Client=HASH(0xfc3898), SCALAR(0xd0df38), Cpanel::DBI::Mysql::db=HASH(0x128a950)) called at /usr/local/cpanel/Cpanel/Mysql/Restore/Client.pm line 231\x0A\x09Cpanel::Mysql::Restore::Client::__ANON__() called at /usr/local/cpanel/Cpanel/Mysql/Restore/Client.pm line 280\x0A\x09Cpanel::Mysql::Restore::Client::run("output_obj", Cpanel::Output::Callback=HASH(0xfa3da8), "sql_fh", GLOB(0xf882a0), "new_dbname", "bbb_db1", "mysql_host", "/var/lib/mysql/mysql.sock", ...) 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(0xf98a90), Try::Tiny::Catch=REF(0xce01b8)) 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(0xf9ab40)) called at bin/restore_mysql_for_account_restore.pl line 62\x0A at bin/restore_mysql_for_account_restore.pl line 118, <$rfh> line 6667.

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

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

Restoring database data for “bbb_db1” …

Processing SQL statements …

The database restoration subprocess for “bbb_db1” has ended.

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

Removed empty DB for failed restore of “bbb_db1”.

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

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


Any advice on this?

 

[cPRex]

Hey there! Are you able to manually dump the database on the remote server? That would be the first thing I would try, because it seems the dump process itself is where the errors begin.

 

[hostdonner]

Thanks very much for your reply, cPRex.

Yes, I was able to dumb the databases manually, but when transferring so many accounts, some of which were more than 1GB, that was not an option for me.

I've contacted the cPanel Tech support, and they were very helpful.

For future visitors of this topic, the problem was with the low limits of 'net_read_timeout' and 'net_write_timeout', and by editing them on the source server, the transfer of the databases finished successfully without any errors.

 

[cPRex]

I'm glad we could help with that issue!

 

[rafael.martinez]

Hello,

I am having the same problem I am trying to transfer a user to a new server but I am getting the error:
The MySQL restore process exited with the error “255”.

What would be the values for net_read_timeout ' and ' net_write_timeout and be able to transfer those users with their respective databases.

 

[cPRex]

@rafael.martinez - those values aren't specified in /etc/my.cnf by default. However, they are set internall in MySQL to 30 and 60, respectively:

[root@host ~]# mysql -e "show variables;" | grep net_read
net_read_timeout 30
[root@host ~]# mysql -e "show variables;" | grep net_write
net_write_timeout 60

You can add those values to the /etc/my.cnf file to change those settings. Just make sure to restart the MySQL service after making that change.