Resolved Unable to add domain/subdomain to subscription

[Christopher Cookson]

I'm running Plesk Onyx 17.5.3 Update #10 on Centos 7.3.1611 with Maria DB 10.2.6

When I attempt to add a domain or subdomain to any subscription, I'm getting an error:

DB query failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '64' for key 'PRIMARY', query was: replace DomainServices

Previously I was receiving a similar error on the Domains table.

 

[IgorG]

What about

# plesk repair db

command?

 

[Christopher Cookson]

@IgorG I already tried this but it did not resolve the issue.

 

[IgorG]

This KB article may be useful - Unable to create object in Plesk: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry for key 'PRIMARY'
Or contact Plesk Support Team for fixing this database inconsistency directly on your server.

 

[Christopher Cookson]

@IgorG Thank you. Changing the autoincrement value in the table in the error message resolved the problem. It might be worth updating the knowledge base article to make it clearer that it can apply to other situations in addition to creating customers or subscriptions.