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

Migration from Plesk 7.5.4 fails

Discussion in 'Plesk 9.x for Linux Issues, Fixes, How-To' started by William Rex, Sep 6, 2011.

  1. William Rex

    William Rex New Pleskian

    19
     
    Joined:
    Nov 20, 2009
    Messages:
    4
    Likes Received:
    0
    I recently updated my Plesk 9.5.4 installation and now all migrations from my older 7.5.4 server fail.

    Here are the last few lines from the log file:
    01:26:52 INFO Dumping domain statistics
    01:26:52 TRACE SQL: SELECT http_in, http_out, ftp_in, ftp_out, smtp_in, smtp_out, pop3_imap_in, pop3_imap_out, date FROM DomainsTraffic WHERE dom_id=43
    01:26:52 TRACE SQL: SELECT c.id FROM certificates c, Repository r WHERE c.id=r.component_id AND r.rep_id='26' ORDER BY c.id
    01:26:52 TRACE SQL: SELECT * FROM certificates WHERE id=23
    01:26:52 TRACE SQL: SELECT * FROM certificates WHERE id=27
    01:26:52 TRACE SQL: SELECT status FROM DomainServices WHERE dom_id=43 AND type='tomcat'
    01:26:52 TRACE SQL: SELECT * FROM dom_level_usrs WHERE dom_id=43
    01:26:52 TRACE SQL: SELECT id, password, type FROM accounts
    01:26:52 TRACE SQL: SELECT val FROM dom_param WHERE dom_id = 43 AND param = 'locale'
    Can't use an undefined value as a HASH reference at Packer.pm line 2270.
    [./actions.cpp:310]

    I did countless searches but cannot find a solution. Any help would be appreciated.
     
  2. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,556
    Likes Received:
    1,241
    Location:
    Novosibirsk, Russia
    The problem in database inconsistency and caused by Card_id=0 on the destination server. You can check it with following example:

    This domain has been created recently - on 06 Sep. The issue is that newly created domains' administrators are not updated for some reason and this influences migration.

    Meanwhile as a workaround please run manually:

    I hope it will help.
     
  3. William Rex

    William Rex New Pleskian

    19
     
    Joined:
    Nov 20, 2009
    Messages:
    4
    Likes Received:
    0
    IgorG: Thanks for the reply.

    I tried the select you listed, but it didn't return any results. I also looked at the databases on both servers and neither of them have any entries with card_id = 0.

    The domain doesn't exist on the new server at all, and has never existed on the new server, nor has the client.
    Also, all migrations seems to fail at this point. Migrations were working fine when I was running 9.5.2 on the new server.

    Any other suggestions?
     
    Last edited: Sep 7, 2011
  4. William Rex

    William Rex New Pleskian

    19
     
    Joined:
    Nov 20, 2009
    Messages:
    4
    Likes Received:
    0
    Just wanted to post a follow up in case any one else runs into this issue and comes across this thread. After running into this problem a second time, I decided to take another look into it. It appears that the domains that were failing had card_id = NULL, rather than 0. Also, on the old server which is running Plesk Reloaded 7.5.4, domadmin didn't exist, but domuser.sh did. Double checking with my server running Plesk 9.5, both domadmin and domuser.sh pointed to the same file. So I modifed IgorG's original code to:

    After running this command, migrations were working properly for the previously failed domains.
     
Loading...