10.3.1 to 10.3.1 Migration Failure

[VinnyT]

GUI Migration Fails every time (with 3 different servers). Logs are empty.

PleskX migration fails. Here are the logs:

[18757]: 19:01:31 INFO FileFinder: pwd resolved to /bin/pwd
[18757]: 19:01:31 INFO ------------------------------------------------------------
[18757]: 19:01:31 INFO FILE storage initialized.
[18757]: 19:01:31 INFO Base directory: /tmp/PMM/px
[18757]: 19:01:31 INFO Space reserved: 10485760
[18757]: 19:01:31 INFO Gzip bundles: yes
[18757]: 19:01:31 INFO Bundle split size: do not split
[18757]: 19:01:31 INFO ------------------------------------------------------------
[18757]: 19:01:31 INFO Reserve disk space at /tmp/PMM/px/.fs_NaN_0
1+0 records in
1+0 records out
10485760 bytes (10 MB) copied, 0.012246 seconds, 856 MB/s
[18757]: 19:01:31 INFO ------------------------------------------------------------
[18757]: 19:01:31 INFO Migration status reporting initialized.
[18757]: 19:01:31 INFO Status file: /tmp/PMM/px/dumping-status.xml
[18757]: 19:01:31 INFO ------------------------------------------------------------
[18757]: 19:01:31 INFO Set backup file name 'backup' (profile 'backup', id='')

[18757]: 19:01:31 INFO Archive content transport has been initialized
[18757]: 19:01:31 INFO Exec: /usr/local/psa/bin/sw-engine-pleskrun /usr/local/psa/admin/plib/api-cli/product_info.php --get-mode
[18757]: 19:01:32 INFO New connection: mysql DBI connection. db psa, user admin, host localhost
[18757]: 19:01:32 TRACE SQL: SELECT ip_address, id FROM IP_Addresses
[18757]: 19:01:32 TRACE SQL: SELECT c.id, c.login, p.ip_address, c.type, c.parent_id, pl.type, c.guid FROM clients c LEFT JOIN ip_pool pl ON c.pool_id = pl.id LEFT JOIN IP_Addresses p ON pl.ip_address_id = p.id
[18757]: 19:01:32 TRACE SQL: SELECT domains.displayName, IP_Addresses.ip_address FROM DomainServices, IpAddressesCollections, IP_Addresses, domains WHERE DomainServices.dom_id = domains.id AND DomainServices.ipCollectionId = IpAddressesCollections.ipCollectionId AND IpAddressesCollections.ipAddressId = IP_Addresses.id AND domains.webspace_id = 0
[18757]: 19:01:32 TRACE SQL: SELECT d.displayName, p.ip_address FROM domains d, IP_Addresses p, forwarding f WHERE p.id = f.ip_address_id AND f.dom_id = d.id AND d.webspace_id = 0
[18757]: 19:01:32 TRACE SQL: SELECT d.displayName FROM domains d WHERE htype = 'none' AND webspace_id = 0
[18757]: 19:01:32 TRACE SQL: SELECT d.displayName, d.name, c.login, c.id, d.id dom_id FROM clients c LEFT JOIN domains d ON d.cl_id = c.id WHERE d.webspace_id = 0
[18757]: 19:01:32 TRACE SQL: SELECT smb_users.login, clients.login FROM smb_users, clients WHERE smb_users.ownerId = clients.id
[18757]: 19:01:32 TRACE SQL: SELECT smb_roles.id, clients.login FROM smb_roles, clients WHERE smb_roles.ownerId = clients.id
[18757]: 19:01:32 TRACE SQL: SELECT val FROM misc WHERE param = 'power_user_panel'
[18757]: 19:01:32 DEBUG Unable to create dump: No objects to dump found at PleskX.pm line 583.
at PleskX.pm line 583
PleskX::dump('PleskX=HASH(0x6fbb040)') called at ./PleskX.pl line 254
eval {...} called at ./PleskX.pl line 143
main::main() called at ./PleskX.pl line 274

[18757]: 19:01:32 ERROR 6c4dc1c9-8237-4749-87f9-ba7e17d33ad2 Unable to create dump:
at Logging.pm line 84
Logging::error('Unable to create dump', 'fatal') called at ./PleskX.pl line 260
main::main() called at ./PleskX.pl line 274

 

[IgorG]

Looks like this problem is caused by lost connection to MySQL server. Check your MySQL server operation at least.

 

[VinnyT]

Hi Igor,

Can you please shed some more light on that? The MySQL server is running fine. What / where would you recommend I look? Do you know of any specific parallels processes that may interact with the mySQL server which would cause this error? A starting point would be extremely helpful.

thanks!

 

[IgorG]

You can enable mysql logging to file in my.cnf at least and analyse this log.

 

[VinnyT]

I think we're overlooking the fact that whatever PleskX is doing, can't find any objects to dump. The SQL tables have all been upgraded and tested. Everything seems fine. Tailing the error logs does not show anything unusual. the activity just stops.


THis just started happening with 10.3.1. It's worked fine before this..


[3734]: 06:47:44 TRACE SQL: SELECT val FROM misc WHERE param = 'power_user_panel'
[3734]: 06:47:44 DEBUG Unable to create dump: No objects to dump found at PleskX.pm line 583.
at PleskX.pm line 583
PleskX::dump('PleskX=HASH(0xe7bf030)') called at ./PleskX.pl line 254
eval {...} called at ./PleskX.pl line 143
main::main() called at ./PleskX.pl line 274

[3734]: 06:47:44 ERROR 06ad290c-061f-4a73-8f72-1e39a811427d Unable to create dump:
at Logging.pm line 84
Logging::error('Unable to create dump', 'fatal') called at ./PleskX.pl line 260
main::main() called at ./PleskX.pl line 274


The question, is what is causing the backup to fail?

Also, if I can't get this working, is there a way to do a manual server migration? I can manually copy over the qmail folders, website files, etc, but is there a way to port the Plesk domains/accounts? Which tables within the plesk database should I love over to keep the domains, their email accounts and their passwords?

thanks again for your help.

 

[VinnyT]

You can enable mysql logging to file in my.cnf at least and analyse this log.

Hi Igor,
Here is a copy of my latest failure. Any ideas?

Same problem on my end. A 10.3.1 to 10.3.1 migration always fails. I started a different thread, but no go. Same issue with using a manual migration. My migration logs are also empty

Here is a copy of my output in case someone reads it:


[ root /var/tmp/migrate ] > ./PleskX.pl --dump-all --no-content
[15219]: 02:26:49 INFO FileFinder: pwd resolved to /bin/pwd
[15219]: 02:26:49 INFO ------------------------------------------------------------
[15219]: 02:26:49 INFO FILE storage initialized.
[15219]: 02:26:49 INFO Base directory: /var/tmp/migrate
[15219]: 02:26:49 INFO Space reserved: 10485760
[15219]: 02:26:49 INFO Gzip bundles: yes
[15219]: 02:26:49 INFO Bundle split size: do not split
[15219]: 02:26:49 INFO ------------------------------------------------------------
[15219]: 02:26:49 INFO Reserve disk space at /var/tmp/migrate/.fs_NaN_0
1+0 records in
1+0 records out
10485760 bytes (10 MB) copied, 0.011738 seconds, 893 MB/s
[15219]: 02:26:49 INFO ------------------------------------------------------------
[15219]: 02:26:49 INFO Migration status reporting initialized.
[15219]: 02:26:49 INFO Status file: /var/tmp/migrate/dumping-status.xml
[15219]: 02:26:49 INFO ------------------------------------------------------------
[15219]: 02:26:49 INFO Set backup file name 'backup' (profile 'backup', id='')

[15219]: 02:26:49 INFO Archive content transport has been initialized
[15219]: 02:26:49 INFO Exec: /usr/local/psa/bin/sw-engine-pleskrun /usr/local/psa/admin/plib/api-cli/product_info.php --get-mode
/usr/bin/sw-engine: error while loading shared libraries: /usr/lib64/mysql/libmysqlclient.so.15: file too short
[15219]: 02:26:49 ERROR 04c8f53f-59fe-4b0a-8f0c-cb804fd73d0c Cannot detect product mode
[15219]: 02:26:49 INFO New connection: mysql shell connection. db psa, user admin, host localhost
[15219]: 02:26:49 TRACE SQL: SELECT ip_address, id FROM IP_Addresses
[15219]: 02:26:49 TRACE SQL: SELECT c.id, c.login, p.ip_address, c.type, c.parent_id, pl.type, c.guid FROM clients c LEFT JOIN ip_pool pl ON c.pool_id = pl.id LEFT JOIN IP_Addresses p ON pl.ip_address_id = p.id
[15219]: 02:26:49 TRACE SQL: SELECT domains.displayName, IP_Addresses.ip_address FROM DomainServices, IpAddressesCollections, IP_Addresses, domains WHERE DomainServices.dom_id = domains.id AND DomainServices.ipCollectionId = IpAddressesCollections.ipCollectionId AND IpAddressesCollections.ipAddressId = IP_Addresses.id AND domains.webspace_id = 0
[15219]: 02:26:49 TRACE SQL: SELECT d.displayName, p.ip_address FROM domains d, IP_Addresses p, forwarding f WHERE p.id = f.ip_address_id AND f.dom_id = d.id AND d.webspace_id = 0
[15219]: 02:26:49 TRACE SQL: SELECT d.displayName FROM domains d WHERE htype = 'none' AND webspace_id = 0
[15219]: 02:26:49 TRACE SQL: SELECT d.displayName, d.name, c.login, c.id, d.id dom_id FROM clients c LEFT JOIN domains d ON d.cl_id = c.id WHERE d.webspace_id = 0
[15219]: 02:26:49 TRACE SQL: SELECT smb_users.login, clients.login FROM smb_users, clients WHERE smb_users.ownerId = clients.id
[15219]: 02:26:49 TRACE SQL: SELECT smb_roles.id, clients.login FROM smb_roles, clients WHERE smb_roles.ownerId = clients.id
[15219]: 02:26:49 DEBUG Selected all objects
[15219]: 02:26:49 TRACE SQL: SELECT val FROM misc WHERE param = 'power_user_panel'
[15219]: 02:26:49 DEBUG Unable to create dump: Cannot find client ''! at PleskStructure.pm line 201.
at PleskStructure.pm line 201
PleskStructure::getMyClients('undef') called at PleskStructure.pm line 109
PleskStructure::getAdminClients() called at PleskX.pm line 1257
PleskX::createFullDump('PleskX=HASH(0xc954250)') called at PleskX.pm line 539
PleskX::dump('PleskX=HASH(0xc954250)') called at ./PleskX.pl line 254
eval {...} called at ./PleskX.pl line 143
main::main() called at ./PleskX.pl line 274

[15219]: 02:26:49 ERROR 8be01351-083b-4da4-8d12-818e23566318 Unable to create dump:
at Logging.pm line 84
Logging::error('Unable to create dump', 'fatal') called at ./PleskX.pl line 260
main::main() called at ./PleskX.pl line 274

[15219]: 02:26:49 INFO FileFinder: pwd resolved to /bin/pwd

 

[VinnyT]

Possible Solution - upgrade to mysql 5.5 (plesk)

I think I've figured it out. I upgraded to the new Parallels Packaged MySQL 5.5 in the autoinstaller and the migration seems to be working...