Create Web hosting fails: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2-3' for key 'PRIMARY'

Refers to:

  • Plesk 12.5 for Linux
  • Plesk 12.0 for Windows

Created:

2016-11-16 13:18:06 UTC

Modified:

2017-01-31 16:09:19 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Create Web hosting fails: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2-3' for key 'PRIMARY'

Symptoms

Attempt to create a subscription/domain or add web hosting to existing domain failed with the following error message:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2-3' for key 'PRIMARY'

Cause

Database inconsistency

Resolution

mysql> select IpAddressesCollections.*, IpCollections.id as Collection_ID from psa.IpAddressesCollections left join psa.IpCollections on psa.IpAddressesCollections.ipCollectionId=IpCollections.id where psa.IpCollections.id is null;
+----------------+-------------+---------------+
| ipCollectionId | ipAddressId | Collection_ID |
+----------------+-------------+---------------+
| 4 | 3 | NULL |
+----------------+-------------+---------------+
1 row in set (0.00 sec)

mysql> insert into IpCollections values (4);
Have more questions? Submit a request
Please sign in to leave a comment.