[TRAFODION-1013] LP Bug: 1421728 - 2 rows in metric_query_stats when trafci is started

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 1.1 (pre-incubation)
• Component/s: connectivity-mxosrvr
• External issue URL: https://bugs.launchpad.net/bugs/1421728
• Assignee: Anuradha Hegde
• Reporter: Aruna Sadashiva
• Created: 22/Jul/15 18:19
• Updated: 31/Aug/15 04:19
• Resolved: 31/Aug/15 04:04

Description

In r1.0.1, we are seeing 2 rows get published in metric_query_stats table when trafci is started, even without executing any queries or sql statements.

This was not seen in r1.0.

SQL>select * from "REPOS".metric_query_table;

0 0 0 11798 11798 3 0 0 16.235.158.31 0 $Z0309M3 2015-02-11 19:56:08.416437 MXID11003011798212290403794452708000000000206U3333300_28_SQL_CUR_1 DB__ROOT NONE 1 MXID11003011798212290403794452708000000000206U3333300 n013 TrafCI SQL_CUR_1 SQL_SELECT_NON_UNIQUE 2015-02-11 19:56:08.416437 2015-02-11 19:56:08.414160 2015-02-11 19:56:08.416362 2202 0 0 0 0 0 0 0 0.0 0.0 0.0 212290403794452708031179000 10000 0 0 0 0 0 0 0 2 0 1 371752 0 0 0 0 0.0 0.0 0.0 100.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 2 0 0 0 29976 0 0 0 0 0 0 0 0 0 1515870810 <N/A> 0 0 0 0 NULL 0 2015-02-11 19:56:08.446405 5999 26096 0 0 <N/A> SHOWCONTROL DEFAULT SCHEMA, match full, no header 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 11798 11798 3 0 0 16.235.158.31 0 $Z0309M3 2015-02-11 19:56:08.741565 MXID11003011798212290403794452708000000000206U3333300_31_SQL_CUR_3 DB__ROOT NONE 1 MXID11003011798212290403794452708000000000206U3333300 n013 TrafCI SQL_CUR_3 SQL_SELECT_NON_UNIQUE 2015-02-11 19:56:08.741565 2015-02-11 19:56:08.737996 2015-02-11 19:56:08.741409 3413 0 0 0 0 0 0 0 0.0 0.0 0.0 212290403794452708031179000 20000 0 0 0 10000 10000 0 0 2 0 0 281560 0 0 0 0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 3.2503300000000003E-9 3.2503300000000003E-9 0.0 0 0 2 0 0 0 5486 8 0 0 1 480 468 7 2 470 1515870810 <N/A> 0 0 0 0 2015-02-11 19:56:08.745363 1 NONE NONE 2015-02-11 19:56:08.747043 28996 4269 0 100 <N/A> SELECT [first 1]current_timestamp as "CURRENT_TIME",'ndcs Version 1.0.0 Release 1.0.1 (Build release [1.0.1rc1-0-ga82b1a6_Bld90], date 20150210_022100)' as "NDCS_VERSION",'UTC' as "TM_ZONE",'0' as "TM_GMTOFF_SEC"FROM (values(1)) X(A); 0 0 0 0 0 0 1 0 0 0 0 480 468 0 0 0 0 0 0 0 0 0 8 0
0 0 0 21039 21039 2 0 0 16.235.158.30 0 $Z020H64 2015-02-11 20:04:08.972000 MXID11002021039212290403793824730000000000206U3333300_28_SQL_CUR_1 DB__ROOT NONE

— 2 row(s) selected.

SQL>