• Hi, Pleskians! We are running a UX testing of our upcoming product intended for server management and monitoring.
    We would like to invite you to have a call with us and have some fun checking our prototype. The agenda is pretty simple - we bring new design and some scenarios that you need to walk through and succeed. We will be watching and taking insights for further development of the design.
    If you would like to participate, please use this link to book a meeting. We will sent the link to the clickable prototype at the meeting.
  • (Plesk for Windows):
    MySQL Connector/ODBC 3.51, 5.1, and 5.3 are no longer shipped with Plesk because they have reached end of life. MariaDB Connector/ODBC 64-bit 3.2.4 is now used instead.
  • The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.

Issue Plesk migrator problem

Pascal_Netenvie

Pascal_Netenvie

Regular Pleskian
Server operating system version
Debian 11.7
Plesk version and microupdate number
18.0.54
Hello,
i use migrator to move multiple sites from plesk 18.0.44 (under Deb 9) to plesk 18.0.54 (under Deb 11.7).

For most of the websites it work ok.
But for 2 sites i have this error :
Code: 
Attempt #1 failed with the following error:
Unable to create subscription 'domain1.com'.
Command execution failed on the local server with non-zero exit code.
command: /opt/psa/bin/subscription --create domain1.com -hosting true -hst_type phys -login mylogin999 -passwd '' -ip 99.99.99.99 -do-not-apply-skeleton -notify false -guid 8fde6337-b3df-45b7-a725-a1e43636a60d -creation-date 2017-12-13 -mail_service false -ignore-nonexistent-options
exit code: 1
stdout:
stderr: [2023-09-05 16:28:09.578] 3175932:64f73af86b46f ERR [panel] Unable to load object of type PhDomain with id=29: Unable to update domain data: DB query failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '8fde6337-b3df-45b7-a725-a1e43636a60d' for key 'guid', query was: UPDATE `domains` SET `id` = ?, `cr_date` = ?, `name` = ?, `displayName` = ?, `dns_zone_id` = ?, `status` = ?, `htype` = ?, `real_size` = ?, `cl_id` = ?, `cert_rep_id` = ?, `limits_id` = ?, `params_id` = ?, `guid` = ?, `overuse` = ?, `vendor_id` = ?, `webspace_id` = ?, `parentDomainId` = ?, `webspace_status` = ?, `permissions_id` = ?, `external_id` = ?, `adminDescription` = ?, `resellerDescription` = ?, `description` = ?, `gl_filter` = ?, `icpStatus` = ?, `icpPermit` = ?, `monthlyTraffic` = ? WHERE (id = 29)
Unable to load object of type PhDomain with id=29: Unable to update domain data: DB query failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '8fde6337-b3df-45b7-a725-a1e43636a60d' for key 'guid', query was: UPDATE `domains` SET `id` = ?, `cr_date` = ?, `name` = ?, `displayName` = ?, `dns_zone_id` = ?, `status` = ?, `htype` = ?, `real_size` = ?, `cl_id` = ?, `cert_rep_id` = ?, `limits_id` = ?, `params_id` = ?, `guid` = ?, `overuse` = ?, `vendor_id` = ?, `webspace_id` = ?, `parentDomainId` = ?, `webspace_status` = ?, `permissions_id` = ?, `external_id` = ?, `adminDescription` = ?, `resellerDescription` = ?, `description` = ?, `gl_filter` = ?, `icpStatus` = ?, `icpPermit` = ?, `monthlyTraffic` = ? WHERE (id = 29)
Unable to load object of type BsDomain with id=29: Unable to update domain data: DB query failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '8fde6337-b3df-45b7-a725-a1e43636a60d' for key 'guid', query was: UPDATE `domains` SET `id` = ?, `cr_date` = ?, `name` = ?, `displayName` = ?, `dns_zone_id` = ?, `status` = ?, `htype` = ?, `real_size` = ?, `cl_id` = ?, `cert_rep_id` = ?, `limits_id` = ?, `params_id` = ?, `guid` = ?, `overuse` = ?, `vendor_id` = ?, `webspace_id` = ?, `parentDomainId` = ?, `webspace_status` = ?, `permissions_id` = ?, `external_id` = ?, `adminDescription` = ?, `resellerDescription` = ?, `description` = ?, `gl_filter` = ?, `icpStatus` = ?, `icpPermit` = ?, `monthlyTraffic` = ? WHERE (id = 29)
An error occurred during domain creation: An error occurred while updating domain settings: Unable to update domain data: DB query failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '8fde6337-b3df-45b7-a725-a1e43636a60d' for key 'guid', query was: UPDATE `domains` SET `id` = ?, `cr_date` = ?, `name` = ?, `displayName` = ?, `dns_zone_id` = ?, `status` = ?, `htype` = ?, `real_size` = ?, `cl_id` = ?, `cert_rep_id` = ?, `limits_id` = ?, `params_id` = ?, `guid` = ?, `overuse` = ?, `vendor_id` = ?, `webspace_id` = ?, `parentDomainId` = ?, `webspace_status` = ?, `permissions_id` = ?, `external_id` = ?, `adminDescription` = ?, `resellerDescription` = ?, `description` = ?, `gl_filter` = ?, `icpStatus` = ?, `icpPermit` = ?, `monthlyTraffic` = ? WHERE (id = 29)

Do you have a solution to fix this ?
 
Ok i compared domains table in both psa base and yes there is already 2 websites on target server with same guid.
The fact is, in past, i created a migration for this 2 websites and used it to create 2 new websites from these copies on target server.

So now how to fix this ? In which way can i change guid without causing problems ?
Do i have to change guid for sites on source server or change guid for 2 copies i did on target ?
Last choice sounds more logic to me as they have updated/new domains ...
But how to do this without causing problem ? Is there a way to calculate guid from domain ? Do i have to change it also in some other tables ?
 
The guid is random generated string. I don't think changing the guid of a domain can cause any (major) issue. You could alter the guid by just changing one of the charters to a (different) number. So for example if the domain guid is 8fde6337-b3df-45b7-a725-a1e43636a60d, change the last charter, in this case d to a 1. If it causes any issue, you can always change it back.
 
Alternative approach:

1) Backup the psa database
Code: 
# plesk db dump psa > psa.backup`date +%F-%s`.sql

2)
Code: 
# plesk db -Ne "SELECT guid, count(guid) FROM domains GROUP BY guid HAVING COUNT(guid) > 1" | while read G C; do echo "> DUPLICATED GUID: $G"; for ((i=0;i<(C-1);i++)); do plesk db -Ne "SELECT id, name FROM domains WHERE guid = '$G' limit 1" | while read I D; do plesk db -Ne "UPDATE domains SET guid = UUID() WHERE id = '$I'"; echo "- FIXED: $D"; done; done; done; echo "> COMPLETED"
 
And one more, similar to Kaspar's:

1) Backup the psa database
Code: 
# plesk db dump psa > psa.backup`date +%F-%s`.sql

2) Find ID of the domains that have the same GUID:
Code: 
# plesk db "select id from domains where guid='3ebe939b-c58c-4a56-a3e4-98750d90b157'\G;"
outputs something like
Code: 
*************************** 1. row ***************************
id: 137

*************************** 2. row ***************************
id: 338
3) Manually generate a new GUID by changing several symbols of the GUID from the error, for example from:
3ebe939b-c58c-4a56-a3e4-98750d90b157
to
3ebe939b-c58c-4a56-a3e4-98750d90b378

4) Verify that the newly generated GUID is not assigned to any domain:
Code: 
# plesk db "select guid,id from domains where guid='3ebe939b-c58c-4a56-a3e4-98750d90b378'\G;"

5) set newly generated GUID to one of the domains ID from step №3:
Code: 
# plesk db "update domains set guid='3ebe939b-c58c-4a56-a3e4-98750d90b378' where id=137;"
 
Root cause according to docs here can be that a migrated domain on the target server was renamed to another, and then it was attempted to migrate the renamed domain again.
 
Peter Debik said:
Alternative approach:

1) Backup the psa database
Code: 
# plesk db dump psa > psa.backup`date +%F-%s`.sql

2)
Code: 
# plesk db -Ne "SELECT guid, count(guid) FROM domains GROUP BY guid HAVING COUNT(guid) > 1" | while read G C; do echo "> DUPLICATED GUID: $G"; for ((i=0;i<(C-1);i++)); do plesk db -Ne "SELECT id, name FROM domains WHERE guid = '$G' limit 1" | while read I D; do plesk db -Ne "UPDATE domains SET guid = UUID() WHERE id = '$I'"; echo "- FIXED: $D"; done; done; done; echo "> COMPLETED"
Click to expand...
Hi Peter,
This approach can't work cause there can't be duplicate GUID in base, and that's why migrator fail ...
Thx for anwsers.
 
Peter Debik said:
And one more, similar to Kaspar's:

1) Backup the psa database
Code: 
# plesk db dump psa > psa.backup`date +%F-%s`.sql

2) Find ID of the domains that have the same GUID:
Code: 
# plesk db "select id from domains where guid='3ebe939b-c58c-4a56-a3e4-98750d90b157'\G;"
outputs something like
Code: 
*************************** 1. row ***************************
id: 137

*************************** 2. row ***************************
id: 338
3) Manually generate a new GUID by changing several symbols of the GUID from the error, for example from:
3ebe939b-c58c-4a56-a3e4-98750d90b157
to
3ebe939b-c58c-4a56-a3e4-98750d90b378

4) Verify that the newly generated GUID is not assigned to any domain:
Code: 
# plesk db "select guid,id from domains where guid='3ebe939b-c58c-4a56-a3e4-98750d90b378'\G;"

5) set newly generated GUID to one of the domains ID from step №3:
Code: 
# plesk db "update domains set guid='3ebe939b-c58c-4a56-a3e4-98750d90b378' where id=137;"
Click to expand...
Yes i will test this one (thx Kaspar).
One last question : This GUID is not used as key elsewhere ?
 
You must log in or register to reply here.

Similar threads

D
Websites and Domain tab doesn't load
Replies
1
Views
1K
InderS
I
F
Plesk 12 full of bugs / migration problem / database inconsistency
Replies
7
Views
3K
Aleksey Filatev
Aleksey Filatev
F
Error during removal of client/domain "Unable to set local cert chain file"
Replies
0
Views
4K
F.Mueller
F
matt.simpson
Unable to "complete switching to the Panel 10 business model"
Replies
15
Views
4K
abdi
abdi
C
Upgrade from 9.5.4 to 10.0.0 went bad, no sites, no plesk
Replies
2
Views
3K
ShalB
S
Back
Top