Repos - METRIC_QUERY_TABLE - submit time is after exec start time for some queries
Bug #1409227 reported by
Aruna Sadashiva
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Trafodion |
Fix Committed
|
High
|
Judy Zhao |
Bug Description
METRIC_QUERY_TABLE : SUBMIT_UTC_TS > EXEC_START_UTC_TS for some queries like 'insert into BATCHTBL values(?,?,?,?)' - Should submit ts be prior to exec start ts?
According to Rao, SUBMIT SHOULD BE SAME AS EXEC_START
Changed in trafodion: | |
milestone: | none → r1.0 |
Changed in trafodion: | |
assignee: | nobody → Judy (hongxia-zhao) |
Changed in trafodion: | |
status: | New → In Progress |
Changed in trafodion: | |
milestone: | r1.0 → r1.0.1 |
Changed in trafodion: | |
milestone: | r1.0.1 → r1.1 |
Changed in trafodion: | |
status: | Fix Committed → Fix Released |
Changed in trafodion: | |
status: | Fix Released → Fix Committed |
To post a comment you must log in.
I got following result by trafci :
SQL>select SUBMIT_ UTC_TS- EXEC_START_ UTC_TS as "SUB-START" ,SUBMIT_ UTC_TS, EXEC_START_ UTC_TS from TRAFODION. "_REPOS_ ".METRIC_ QUERY_TABLE;
SUB-START SUBMIT_UTC_TS EXEC_START_UTC_TS ------- ------ ------- ------- ------- ----- ------- ------- ------- -----
-------
0.012160 2015-01-15 06:37:16.516158 2015-01-15 06:37:16.503998
0.002414 2015-01-15 06:37:17.108331 2015-01-15 06:37:17.105917
… …
0.000000 2015-01-16 06:56:36.063327 2015-01-16 06:56:36.063327
0.000000 2015-01-16 06:57:02.699691 2015-01-16 06:57:02.699691
… …
Here SUBMIT_UTC_TS is always larger or equal to EXEC_START_UTC_TS .
Then I checked the source and found that: info->m_ submit_ utc_ts = statementStartTime tTime = JULIANTIMESTAMP(); which is set at ResStatisticsSt atement: :start.
1.pQuery_
2.statementStar
So this is the reason why the submit_utc is different with exec_start_utc.
My question is : The submit_utc should equal to exec_start_utc or not ? Is this a bug ?