DX Application Performance Management

 View Only
  • 1.  CEMDB errors

    Posted Mar 19, 2018 11:18 AM

    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)



  • 2.  Re: CEMDB errors
    Best Answer

    Broadcom Employee
    Posted Mar 19, 2018 06:09 PM

    Hi Fernando,

    The "duplicate key value violates unique constraint" ERRORs for ts_us_sessions_map & ts_defects_reaggr_int_intidx could be impacting at least the defects aggregation. Have you noticed any CEM functionality that is broken e.g. Analysis Graphs/ CEM Reports for Defects?

    The errors really need to be investigated in more detail along with a health check of your APM DB so I would suggest to raise a support case: https://comm.support.ca.com/csupport/CaseManagement/cases/new 

     

    Thanks

     

    Lynn



  • 3.  Re: CEMDB errors

    Posted Mar 19, 2018 10:58 PM

    Hello Lynn, thanks