Search Engine: Elastic

Article ID: 131348, created on Aug 24, 2017, last review on Jan 27, 2018

  • Applies to:
  • Operations Automation 7.0
  • Operations Automation 7.2
  • Operations Automation 6.0

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.

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 0871c0b47b3b86ae3b1af4c2942cd0ce 1941880841f714e458ae4dc3d9f3062d 31987597efff5a3a9ce779cc203bbe5e 956c448bddc7e1f3585373687602379f 6f1456866eed87488c0f02b298a741c0

Email subscription for changes to this article
Save as PDF