AnsweredAssumed Answered

CEMDB errors

Question asked by Nando68 on Mar 19, 2018
Latest reply on Mar 20, 2018 by Nando68

Postgres CEMDB on CA APM r10.5.2.15

How to do to revolve this errors?

 

-Sessions already exists

[37571-cemdb-admin-2018-03-19 11:53:26.119 ART]STATEMENT:  insert into ts_us_sessions_map_20180319_11 (version_info, ts_user_id, ts_apptype_id, ts_encrypt_session_id, ts_ageout_time, ts_last_update, ts_creation_time, ts_soft_delete, ts_app_id, ts_session_id, ts_interim_session_id) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11)
[37571-cemdb-admin-2018-03-19 11:53:26.120 ART]ERROR:  current transaction is aborted, commands ignored until end of transaction block
[37571-cemdb-admin-2018-03-19 11:53:26.120 ART]STATEMENT:  SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME,  CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema'  WHEN true THEN CASE  WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind   WHEN 'r' THEN 'SYSTEM TABLE'   WHEN 'v' THEN 'SYSTEM VIEW'   WHEN 'i' THEN 'SYSTEM INDEX'   ELSE NULL   END  WHEN n.nspname = 'pg_toast' THEN CASE c.relkind   WHEN 'r' THEN 'SYSTEM TOAST TABLE'   WHEN 'i' THEN 'SYSTEM TOAST INDEX'   ELSE NULL   END  ELSE CASE c.relkind   WHEN 'r' THEN 'TEMPORARY TABLE'   WHEN 'i' THEN 'TEMPORARY INDEX'   WHEN 'S' THEN 'TEMPORARY SEQUENCE'   WHEN 'v' THEN 'TEMPORARY VIEW'   ELSE NULL   END  END  WHEN false THEN CASE c.relkind  WHEN 'r' THEN 'TABLE'  WHEN 'i' THEN 'INDEX'  WHEN 'S' THEN 'SEQUENCE'  WHEN 'v' THEN 'VIEW'  WHEN 'c' THEN 'TYPE'  WHEN 'f' THEN 'FOREIGN TABLE'  ELSE NULL  END  ELSE NULL  END  AS TABLE_TYPE, d.description AS REMARKS  FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c  LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0)  LEFT JOIN pg_catalog.pg_class dc ON (d.classoid=dc.oid AND dc.relname='pg_class')  LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid=dc.relnamespace AND dn.nspname='pg_catalog')  WHERE c.relnamespace = n.oid  AND c.relname LIKE 'PROBABLYNOT' AND (false  OR ( c.relkind = 'r' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema' ) )  ORDER BY TABLE_TYPE,TABLE_SCHEM,TABLE_NAME
[37583-[unknown]-[unknown]-2018-03-19 11:53:26.123 ART]LOG:  connection received: host=167.28.131.184 port=42802
[37571-cemdb-admin-2018-03-19 11:53:26.125 ART]LOG:  disconnection: session time: 0:00:01.037 user=admin database=cemdb host=167.28.131.184 port=42779
[37583-cemdb-admin-2018-03-19 11:53:26.133 ART]LOG:  connection authorized: user=admin database=cemdb
[37583-cemdb-admin-2018-03-19 11:53:26.311 ART]ERROR:  duplicate key value violates unique constraint "ts_us_sessions_map_20180319_11_pkey"
[37583-cemdb-admin-2018-03-19 11:53:26.311 ART]DETAIL:  Key (ts_app_id, ts_session_id, ts_interim_session_id)=(700000000000000003, 5FDBEE3465691EACAB683B98F45FFBCF, ) already exists.
[37583-cemdb-admin-2018-03-19 11:53:26.311 ART]STATEMENT:  insert into ts_us_sessions_map_20180319_11 (version_info, ts_user_id, ts_apptype_id, ts_encrypt_session_id, ts_ageout_time, ts_last_update, ts_creation_time, ts_soft_delete, ts_app_id, ts_session_id, ts_interim_session_id) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11)
[37583-cemdb-admin-2018-03-19 11:53:26.313 ART]ERROR:  current transaction is aborted, commands ignored until end of transaction block
[37583-cemdb-admin-2018-03-19 11:53:26.313 ART]STATEMENT:  SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME,  CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema'  WHEN true THEN CASE  WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind   WHEN 'r' THEN 'SYSTEM TABLE'   WHEN 'v' THEN 'SYSTEM VIEW'   WHEN 'i' THEN 'SYSTEM INDEX'   ELSE NULL   END  WHEN n.nspname = 'pg_toast' THEN CASE c.relkind   WHEN 'r' THEN 'SYSTEM TOAST TABLE'   WHEN 'i' THEN 'SYSTEM TOAST INDEX'   ELSE NULL   END  ELSE CASE c.relkind   WHEN 'r' THEN 'TEMPORARY TABLE'   WHEN 'i' THEN 'TEMPORARY INDEX'   WHEN 'S' THEN 'TEMPORARY SEQUENCE'   WHEN 'v' THEN 'TEMPORARY VIEW'   ELSE NULL   END  END  WHEN false THEN CASE c.relkind  WHEN 'r' THEN 'TABLE'  WHEN 'i' THEN 'INDEX'  WHEN 'S' THEN 'SEQUENCE'  WHEN 'v' THEN 'VIEW'  WHEN 'c' THEN 'TYPE'  WHEN 'f' THEN 'FOREIGN TABLE'  ELSE NULL  END  ELSE NULL  END  AS TABLE_TYPE, d.description AS REMARKS  FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c  LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0)  LEFT JOIN pg_catalog.pg_class dc ON (d.classoid=dc.oid AND dc.relname='pg_class')  LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid=dc.relnamespace AND dn.nspname='pg_catalog')  WHERE c.relnamespace = n.oid  AND c.relname LIKE 'PROBABLYNOT' AND (false  OR ( c.relkind = 'r' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema' ) )  ORDER BY TABLE_TYPE,TABLE_SCHEM,TABLE_NAME
[37584-[unknown]-[unknown]-2018-03-19 11:53:26.318 ART]LOG:  connection received: host=167.28.131.184 port=42806
[37583-cemdb-admin-2018-03-19 11:53:26.325 ART]LOG:  disconnection: session time: 0:00:00.202 user=admin database=cemdb host=167.28.131.184 port=42802
[37584-cemdb-admin-2018-03-19 11:53:26.329 ART]LOG:  connection authorized: user=admin database=cemdb
[37581-cemdb-admin-2018-03-19 11:53:26.409 ART]ERROR:  duplicate key value violates unique constraint "ts_us_sessions_map_20180319_11_pkey"
[37581-cemdb-admin-2018-03-19 11:53:26.409 ART]DETAIL:  Key (ts_app_id, ts_session_id, ts_interim_session_id)=(700000000000000003, 79FCBF0A196342C56B1685194C778103, ) already exists.

 

---DUPLICATED KEY

[1632-cemdb-admin-2018-03-19 12:05:31.262 ART]LOG:  connection authorized: user=admin database=cemdb
[1631-cemdb-admin-2018-03-19 12:05:31.264 ART]ERROR:  current transaction is aborted, commands ignored until end of transaction block
[1631-cemdb-admin-2018-03-19 12:05:31.264 ART]STATEMENT:  SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME,  CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema'  WHEN true THEN CASE  WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind   WHEN 'r' THEN 'SYSTEM TABLE'   WHEN 'v' THEN 'SYSTEM VIEW'   WHEN 'i' THEN 'SYSTEM INDEX'   ELSE NULL   END  WHEN n.nspname = 'pg_toast' THEN CASE c.relkind   WHEN 'r' THEN 'SYSTEM TOAST TABLE'   WHEN 'i' THEN 'SYSTEM TOAST INDEX'   ELSE NULL   END  ELSE CASE c.relkind   WHEN 'r' THEN 'TEMPORARY TABLE'   WHEN 'i' THEN 'TEMPORARY INDEX'   WHEN 'S' THEN 'TEMPORARY SEQUENCE'   WHEN 'v' THEN 'TEMPORARY VIEW'   ELSE NULL   END  END  WHEN false THEN CASE c.relkind  WHEN 'r' THEN 'TABLE'  WHEN 'i' THEN 'INDEX'  WHEN 'S' THEN 'SEQUENCE'  WHEN 'v' THEN 'VIEW'  WHEN 'c' THEN 'TYPE'  WHEN 'f' THEN 'FOREIGN TABLE'  ELSE NULL  END  ELSE NULL  END  AS TABLE_TYPE, d.description AS REMARKS  FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c  LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0)  LEFT JOIN pg_catalog.pg_class dc ON (d.classoid=dc.oid AND dc.relname='pg_class')  LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid=dc.relnamespace AND dn.nspname='pg_catalog')  WHERE c.relnamespace = n.oid  AND c.relname LIKE 'PROBABLYNOT' AND (false  OR ( c.relkind = 'r' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema' ) )  ORDER BY TABLE_TYPE,TABLE_SCHEM,TABLE_NAME
[1633-[unknown]-[unknown]-2018-03-19 12:05:31.267 ART]LOG:  connection received: host=167.28.131.184 port=48320
[1631-cemdb-admin-2018-03-19 12:05:31.268 ART]LOG:  disconnection: session time: 0:00:00.022 user=admin database=cemdb host=167.28.131.184 port=48318
[1630-cemdb-admin-2018-03-19 12:05:31.271 ART]ERROR:  duplicate key value violates unique constraint "ts_defects_reaggr_int_intidx"
[1630-cemdb-admin-2018-03-19 12:05:31.271 ART]DETAIL:  Key (ts_interval)=(2018-03-19 10:00:00) already exists.
[1630-cemdb-admin-2018-03-19 12:05:31.271 ART]STATEMENT:  insert into ts_defects_reaggr_intervals (version_info, ts_interval, ts_processed_time, ts_soft_delete, ts_id) values ($1, $2, $3, $4, $5)

Outcomes