[TRAFODION-1067] LP Bug: 1433926 - query stats are not published to METRIC_QUERY_TABLE if the query time is greater than STATISTICSLIMIT and smaller than STATISTICSINTERVAL

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 2.0-incubating
• Component/s: connectivity-mxosrvr
• External issue URL: https://bugs.launchpad.net/bugs/1433926
• Assignee: JudyZhao
• Reporter: FengQiang
• Created: 22/Jul/15 18:19
• Updated: 31/Aug/15 04:19
• Resolved: 31/Aug/15 04:04

Description

Here are the parameters.
mxosrvr -ZKHOST n007.cm.cluster:2181 -RZ n007.cm.cluster:1:6 -ZKPNODE /trafodion -CNGTO 60 -ZKSTO 180 -EADSCO 0 -TCPADD 16.235.162.84 -MAXHEAPPCT 0 -STATISTICSINTERVAL 60 -STATISTICSLIMIT 1 -STATISTICSTYPE aggregated -STATISTICSENABLE true -SQLPLAN false -PORTMAPTOSECS -1 -PORTBINDTOSECS -1

This one was published
SQL>insert into VITO_TEST.tab1 select colint, 'a' from VITO_TEST.fun f where f.colint < 100000000;

— 15625 row(s) inserted.

Start Time 2015/03/19 05:51:08.266558
End Time 2015/03/19 05:52:38.551538
Elapsed Time 00:01:30.284980
Compile Time 00:00:00.047735
Execution Time 00:01:30.236976

But this one was not in the table
SQL>insert into VITO_TEST.tab1 select colint, 'a' from VITO_TEST.fun f where f.colint < 100000;

— 3125 row(s) inserted.

Start Time 2015/03/19 05:46:21.893948
End Time 2015/03/19 05:46:27.043882
Elapsed Time 00:00:05.149934
Compile Time 00:00:00.011382
Execution Time 00:00:05.138318