Symptoms
-
Plesk Backup Manager shows a warning:
CONFIG_TEXT: Unable to back up APS controller data. Error: ODBC error #23000: [ma-3.0.8][5.7.29-log-cll-lve]Duplicate entry 'admin_email-0-185' for key 'IX_aps_registry_object_setting'
-
The record for
aps_application
with _registry_object_id=185 is presented only in one table - aps_registry_object_setting:MYSQL_LIN: select * from aps_application where registry_object_id=185;
Empty set (0.00 sec)MYSQL_LIN: select * from aps_application_backup where registry_object_id=185;
Empty set (0.00 sec)MYSQL_LIN: select * from aps_package where registry_object_id=185;
Empty set (0.00 sec)MYSQL_LIN: select * from aps_registry_object_tag where registry_object_id=185;
Empty set (0.00 sec)MYSQL_LIN: select * from aps_resource where registry_object_id=185;
Empty set (0.00 sec)MYSQL_LIN: select * from aps_resource_backup where registry_object_id=185;
Empty set (0.00 sec)MYSQL_LIN: select * from aps_registry_object_setting where registry_object_id=185;
(...)
5 rows in set (0.01 sec)
Cause
Orphaned record in apsc database.
Resolution
Delete the record in the following way:
-
Create backup of apsc database
# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -u admin --databases apsc > apsc.dump.`date +%F.%s`.sql
-
Log in Plesk database
# plesk db
-
Switch to apsc database
MYSQL_LIN: use apsc
-
Find out the records with registry_object_id = 185
MYSQL_LIN: select * from aps_registry_object_setting where registry_object_id = 185;
-
Remove the record:
MYSQL_LIN: delete from aps_registry_object_setting where registry_object_id = 185;
Comments
0 comments
Please sign in to leave a comment.