Plesk Backup Manager shows warning: 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'

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:

1. Create backup of apsc database

   # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -u admin --databases apsc > apsc.dump.`date +%F.%s`.sql

2. Log in Plesk database

   # plesk db

3. Switch to apsc database

   MYSQL_LIN: use apsc

4. Find out the records with registry_object_id = 185

   MYSQL_LIN: select * from aps_registry_object_setting where registry_object_id = 185;

5. Remove the record:

   MYSQL_LIN: delete from aps_registry_object_setting where registry_object_id = 185;