1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

10.3.1 to 10.3.1 Migration Failure

Discussion in 'Plesk 10.x for Linux Issues, Fixes, How-To' started by VinnyT, Aug 20, 2011.

  1. VinnyT

    VinnyT Regular Pleskian

    22
    40%
    Joined:
    Dec 14, 2010
    Messages:
    110
    Likes Received:
    0
    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
     
  2. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,554
    Likes Received:
    1,241
    Location:
    Novosibirsk, Russia
    Looks like this problem is caused by lost connection to MySQL server. Check your MySQL server operation at least.
     
  3. VinnyT

    VinnyT Regular Pleskian

    22
    40%
    Joined:
    Dec 14, 2010
    Messages:
    110
    Likes Received:
    0
    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!
     
  4. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,554
    Likes Received:
    1,241
    Location:
    Novosibirsk, Russia
    You can enable mysql logging to file in my.cnf at least and analyse this log.
     
  5. VinnyT

    VinnyT Regular Pleskian

    22
    40%
    Joined:
    Dec 14, 2010
    Messages:
    110
    Likes Received:
    0
    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.
     
  6. VinnyT

    VinnyT Regular Pleskian

    22
    40%
    Joined:
    Dec 14, 2010
    Messages:
    110
    Likes Received:
    0
    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
     
  7. VinnyT

    VinnyT Regular Pleskian

    22
    40%
    Joined:
    Dec 14, 2010
    Messages:
    110
    Likes Received:
    0
    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...
     
Loading...