Symptoms
Task Add access host 192.0.2.2 for database database_name on database server on host 192.168.1.104 fails with the following error message:
MySQL API error:Duplicate entry '192.0.2.2-db1234_dbname-u1231_name' for key 'PRIMARY'.
The same can be observed in /var/log/pa/core.log on the Management Node:
Aug 17 12:34:56.991 : DBG [task:91812341:3597984 1:25545:af4ffb70 MySQL ]: [ db::mysql::connection::exec] 192.0.2.2:mysql INSERT INTO db(Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv,Drop_priv,Grant_priv,References_priv,Index_priv,Alter_priv,Create_tmp_table_priv,Lock_tables_priv,Create_view_priv,Show_view_priv,Create_routine_priv,Alter_routine_priv,Execute_priv,Event_priv,Trigger_priv) VALUES('192.0.2.2', 'db1234_dbname', 'u1231_name','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y')
Aug 17 12:34:56.992 : DBG [task:91812341:3597984 1:25545:af4ffb70 lib ]: [ MySQL] {module_id="Databases"; code="610"} MySQL API error: Duplicate entry '192.0.2.2-db1234_dbname-u1231_name' for key 'PRIMARY'.
Cause
The task tries to insert the same records as which were added by the Create database task which can be found in Processed tasks tab.
Issue is acknowledged as #POA-114479.
Resolution
The task may be safely canceled.
Contact your Technical Account Manager to trace the current status of #POA-114479.