---------------------------------------------------------------
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
Contents of migration.result
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>