• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Manual run of migration smb-to-plesk-migration.sh agent failing

DRYALLS

Basic Pleskian
---------------------------------------------------------------
PRODUCT, VERSION, MICROUPDATE, OPERATING SYSTEM, ARCHITECTURE = PLESK 8.6, up to date, 32-bit Centos 5

PROBLEM DESCRIPTION = Manual run of migration agent is failing - SQL syntax errors and MySQL timeout

STEPS TO REPRODUCE = Download and run the smb-to-plesk-migration.sh script on 26-May-2012

ACTUAL RESULT = xml file with errors, psadump.log file containing error messages
EXPECTED RESULT = No errors!

ANY ADDITIONAL INFORMATION Small server with only 2 clients and 19 domains
--------------------------------------------------------------

Few lines of psadump.log where error occurs

Code:
[8552]: 17:53:53 INFO Executing bundle producer: '/bin/tar -f - -c -T '/tmp/filexhDS4S'' in /etc/psa/
[27218]: 17:53:53 TRACE SQL: SELECT domain FROM badmailfrom
[27218]: 17:53:53 TRACE SQL: SELECT ip_address, ip_mask FROM smtp_poplocks
[27218]: 17:53:53 TRACE SQL: SELECT * FROM dns_recs_t
[27218]: 17:53:53 TRACE SQL: SELECT c.id FROM certificates c, Repository r WHERE c.id=r.component_id AND r.rep_id='1' ORDER BY c.id
[27218]: 17:53:53 TRACE SQL: SELECT * FROM certificates WHERE id=1
[27218]: 17:53:53 TRACE SQL: SELECT id FROM custom_buttons WHERE level='1' AND level_id='0'
[27218]: 17:53:53 TRACE SQL: SELECT t.id, t.name, t.note_id FROM Templates t, Repository r WHERE r.rep_id= AND r.component_id = t.id
[27218]: 17:53:53 ERROR 0753f67b-b056-4d94-84b5-fc4e9f8e0b22 Unable to execute SQL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax t
o use near 'AND r.component_id = t.id' at line 1
[27218]: 17:53:53 WARN 8a4c2248-a58d-474a-85ee-5f7634dbd4fa Timeout occured during mysql query. Reconnecting.
[27218]: 17:53:53 ERROR 865b762a-08ce-48f3-8013-82b96ec297a6 Unable to execute SQL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax t
o use near 'AND r.component_id = t.id' at line 1
[27218]: 17:53:53 TRACE SQL: SELECT `name`, `version`, `release` FROM SiteAppPackages

Contents of migration.result

Code:
<?xml version="1.0" encoding="UTF-8"?>
  <execution-result status="error" log-location="/backup/migration.result">
    <message id="865b762a-08ce-48f3-8013-82b96ec297a6" severity="error" code="msgtext">
      <description>Unable to execute SQL: 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 'AND r.component_id = t.id&
#39; at line 1</description>
    </message>
    <message id="8a4c2248-a58d-474a-85ee-5f7634dbd4fa" severity="warning" code="msgtext">
      <description>Timeout occured during mysql query. Reconnecting.</description>
    </message>
    <message id="0753f67b-b056-4d94-84b5-fc4e9f8e0b22" severity="error" code="msgtext">
      <description>Unable to execute SQL: 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 'AND r.component_id = t.id&
#39; at line 1</description>
    </message>
  </execution-result>
 
Back
Top