tranfertool discontinues

D.Schmidt

• June 08, 2016 02:50

Hi, clicking "Fetch Account List" stops with this:
Failed to execute sql method do: (XID 7dzhfk) DBD::mysql::db do failed: Unknown column 'creator' in 'field list' at /usr/local/cpanel/Cpanel/DBBackend.pm line 157. Cpanel::DBBackend::_retried_sql(Whostmgr::Transfers::Session=HASH(0x7d1b648), "do", "INSERT INTO sessions (sessionid,version,creator,initiator,tar"...) called at /usr/local/cpanel/Cpanel/DBBackend.pm line 95 Cpanel::DBBackend::_retried_do(Whostmgr::Transfers::Session=HASH(0x7d1b648), "INSERT INTO sessions (sessionid,version,creator,initiator,tar"...) called at /usr/local/cpanel/Whostmgr/Transfers/Session.pm line 1460 Whostmgr::Transfers::Session::_create_new_session(Whostmgr::Transfers::Session=HASH(0x7d1b648), "1447631113copya20160608073047MgzLwLV") called at /usr/local/cpanel/Whostmgr/Transfers/Session.pm line 1126 Whostmgr::Transfers::Session::_set_session_id(Whostmgr::Transfers::Session=HASH(0x7d1b648), "1447631113copya20160608073047MgzLwLV") called at /usr/local/cpanel/Whostmgr/Transfers/Session.pm line 1016 Whostmgr::Transfers::Session::_init(Whostmgr::Transfers::Session=HASH(0x7d1b648), "session_id_template", "144.76.31.113", "initiator", "copyacct", "create", 1) called at /usr/local/cpanel/Cpanel/DBBackend.pm line 31 Cpanel::DBBackend::new("Whostmgr::Transfers::Session", "initiator", "copyacct", "create", 1, "session_id_template", "144.76.31.113") called at /usr/local/cpanel/Whostmgr/Transfers/Session/Setup.pm line 51 Whostmgr::Transfers::Session::Setup::try {...} () called at /usr/local/cpanel/3rdparty/perl/522/lib64/perl5/cpanel_lib/Try/Tiny.pm line 80 eval {...} called at /usr/local/cpanel/3rdparty/perl/522/lib64/perl5/cpanel_lib/Try/Tiny.pm line 71 Try::Tiny::try(CODE(0x7d1bfc0), Try::Tiny::Catch=REF(0x7d1c0b0)) called at /usr/local/cpanel/Whostmgr/Transfers/Session/Setup.pm line 59 Whostmgr::Transfers::Session::Setup::setup_session_obj(HASH(0x8059e60), HASH(0x804c9c8)) called at /usr/local/cpanel/Whostmgr/Transfers/Session/Preflight/RemoteRoot/Create.pm line 78 Whostmgr::Transfers::Session::Preflight::RemoteRoot::Create::_create_remote_root_transfer_session(HASH(0x20c0d78)) called at /usr/local/cpanel/Whostmgr/Transfers/Session/Preflight/RemoteRoot/Create.pm line 37 Whostmgr::Transfers::Session::Preflight::RemoteRoot::Create::__ANON__() called at /usr/local/cpanel/Cpanel/Capture.pm line 39 Cpanel::Capture::try {...} () called at /usr/local/cpanel/3rdparty/perl/522/lib64/perl5/cpanel_lib/Try/Tiny.pm line 80 eval {...} called at /usr/local/cpanel/3rdparty/perl/522/lib64/perl5/cpanel_lib/Try/Tiny.pm line 71 Try::Tiny::try(CODE(0x7f65dd8), Try::Tiny::Catch=REF(0x8047d60)) called at /usr/local/cpanel/Cpanel/Capture.pm line 43 Cpanel::Capture::trap_stdout(CODE(0x8047e20)) called at /usr/local/cpanel/Whostmgr/Transfers/Session/Preflight/RemoteRoot/Create.pm line 39 Whostmgr::Transfers::Session::Preflight::RemoteRoot::Create::create_remote_root_transfer_session(HASH(0x20c0d78)) called at /usr/local/cpanel/Whostmgr/API/1/Transfers.pm line 113 Whostmgr::API::1::Transfers::create_remote_root_transfer_session(HASH(0x20c0d78), HASH(0x6a50b78), HASH(0x20bfbf0)) called at whostmgr/bin/xml-api.pl line 2872 whostmgr::bin::xml_api::__ANON__(HASH(0x6a50b78), HASH(0x20c0d78), HASH(0x20bfbf0), CODE(0x69aa5b8)) called at /usr/local/cpanel/Whostmgr/API/1/Data/Wrapper.pm line 218 Whostmgr::API::1::Data::Wrapper::try {...} () called at /usr/local/cpanel/3rdparty/perl/522/lib64/perl5/cpanel_lib/Try/Tiny.pm line 80 eval {...} called at /usr/local/cpanel/3rdparty/perl/522/lib64/perl5/cpanel_lib/Try/Tiny.pm line 71 Try::Tiny::try(CODE(0x6f7abb0), Try::Tiny::Catch=REF(0x8047a78)) called at /usr/local/cpanel/Whostmgr/API/1/Data/Wrapper.pm line 237 Whostmgr::API::1::Data::Wrapper::execute_internal(CODE(0x77e00c0), HASH(0x20c0d78), HASH(0x20bfbf0), HASH(0x76987a8), CODE(0x69aa5b8)) called at whostmgr/bin/xml-api.pl line 3023 whostmgr::bin::xml_api::runapp(__CPANEL_HIDDEN__, HASH(0x20bfbf0), HASH(0x20d8988), 0, CODE(0x69aa5b8)) called at whostmgr/bin/xml-api.pl line 2805 whostmgr::bin::xml_api::script(CODE(0x69aa5b8), "-json", "./create_remote_root_transfer_session") called at whostmgr/bin/xml-api.pl line 2757
any ideas? cheers /etc/redhat-release:CloudLinux release 7.2 (Valeri Kubasov) /usr/local/cpanel/version:11.56.0.22 /var/cpanel/envtype:standard CPANEL=release Server version: Apache/2.4.18 (Unix) Server built: Jan 20 2016 10:21:03 Cpanel::Easy::Apache v3.32.9 rev9999 +cloudlinux PHP 5.5.31 (cli) (built: Jan 20 2016 10:22:52) Copyright (c) 1997-2015 The PHP Group Zend Engine v2.5.0, Copyright (c) 1998-2015 Zend Technologies mysql Ver 14.14 Distrib 5.5.45, for Linux (x86_64) using readline 5.1

• 

  dswimr615

  • June 28, 2016 15:28

  Hello, I don't know if your issue has been fixed, but this is the first result on google so I wanted to post the answer cPanel gave which resolved the problem: The issue was a missing column in the 'whmxfer' database on the destination server. For some reason, the 'creator' column did not exist on the destination server in the whmxfer database. I created it as it exists on your source server and a test server, via WHM's phpMyAdmin.
  mysql> show columns in sessions; +-------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+------------+------+-----+---------+-------+ | sessionid | char(255) | NO | PRI | NULL | | | initiator | char(255) | YES | | unknown | | | pid | bigint(20) | YES | | 0 | | | version | double | YES | | 0 | | | target_host | char(255) | YES | | NULL | | | source_host | char(255) | YES | | NULL | | | state | bigint(20) | YES | | 0 | | | starttime | datetime | YES | | NULL | | | endtime | datetime | YES | | NULL | | | creator | char(255) | YES | | root | | +-------------+------------+------+-----+---------+-------+
  After doing this, the Transfer Tool is connecting without error.

  0
• 

  cPanelMichael

  • June 28, 2016 18:37

  Hello, CPANEL-6878 is open to track reports of this issue. There's currently no update to provide on the cause of this problem, but I'll update this thread with more information as it becomes available. Note that in cPanel 58, transfers now use the SQLite database. Here's a quote from the interface (Home >> Transfers >> Transfer Tool) allows system administrators to transfer MySQL configuration information between servers. This might cause corruption in a transfer session's session data. Each transfer session stores its data in a separate SQLite database. If the system corrupts the data, it will delete the session. This will remove the session from the session history in WHM's

  0
• 

  D.Schmidt

  • July 07, 2016 08:11

  ok, thank you. I reinstalled the whole server and the problem was gone.

  0

Please sign in to leave a comment.