Anuradha Hegde created TRAFODION-2122:
-----------------------------------------
Summary: daily build master executor logs contain update statement
exception
Key: TRAFODION-2122
URL: https://issues.apache.org/jira/browse/TRAFODION-2122
Project: Apache Trafodion
Issue Type: Bug
Components: connectivity-mxosrvr
Affects Versions: 2.1-incubating
Reporter: Anuradha Hegde
Assignee: Anuradha Hegde
Fix For: 2.1-incubating
During analysis of master exec logs of daily build, the following message is
reported.. The update statement of metric query table is missing a comma
2016-07-20 17:49:26,044, ERROR, MXOSRVR, Node Number: 0, CPU: 0, PIN:19960,
Process Name:$Z000GAA , , ,A NonStop Process Service error Failed to write
statistics: update Trafodion."_REPOS_".metric_query_table set STATEMENT_TYPE=
'SQL_OTHER',STATEMENT_SUBTYPE= '',AGGREGATE_TOTAL= 0,STATS_ERROR_CODE=
0,QUERY_ELAPSED_TIME= 104993409,SQL_PROCESS_BUSY_TIME=
5257702,DISK_PROCESS_BUSY_TIME= 0,DISK_IOS= 0,NUM_SQL_PROCESSES=
1,SQL_SPACE_ALLOCATED= 32,SQL_SPACE_USED= 5,SQL_HEAP_ALLOCATED=
7,SQL_HEAP_USED= 2,TOTAL_MEM_ALLOC= 7,MAX_MEM_USED= 32756,NUM_REQUEST_MSGS=
0,NUM_REQUEST_MSG_BYTES= 0,NUM_REPLY_MSGS= 0,NUM_REPLY_MSG_BYTES=
0,ROWS_RETURNED_TO_MASTER= 0,EXEC_END_UTC_TS=
CONVERTTIMESTAMP(212335796966036136),MASTER_EXECUTION_TIME=
6950943,MASTER_ELAPSED_TIME= 104993357,QUERY_STATUS=
'COMPLETED',QUERY_SUB_STATUS= 'N/A',ERROR_CODE= 0,SQL_ERROR_CODE= 0,ERROR_TEXT=
'<N/A>',LAST_ERROR_BEFORE_AQR= 0,DELAY_TIME_BEFORE_AQR_SEC=
0,TOTAL_NUM_AQR_RETRIES= 0,MSG_BYTES_TO_DISK= 0,MSGS_TO_DISK= 0,ROWS_ACCESSED=
0,ROWS_RETRIEVED= 0,NUM_ROWS_IUD= 0,PROCESSES_CREATED=
0,PROCESS_CREATE_BUSY_TIME= 0,OVF_FILE_COUNT= 0,OVF_SPACE_ALLOCATED=
32,OVF_SPACE_USED= 5,OVF_BLOCK_SIZE= 0,OVF_WRITE_READ_COUNT= 0,OVF_WRITE_COUNT=
0,OVF_BUFFER_BLOCKS_WRITTEN= 0,OVF_BUFFER_BYTES_WRITTEN= 0,OVF_READ_COUNT=
0,OVF_BUFFER_BLOCKS_READ= 0,OVF_BUFFER_BYTES_READ= 0,NUM_NODES=
0,UDR_PROCESS_BUSY_TIME= 5257702,PERTABLE_STATS= 0LAST_UPDATED_TIME=
CONVERTTIMESTAMP(212335796966036168) where QUERY_ID =
'MXID11000019960212335796129352462000000001006U3333409jdbc_test_2385_SQL_CUR_9'
and EXEC_START_UTC_TS = CONVERTTIMESTAMP(212335796861042732)----Error detail -
*** ERROR[15001] A syntax error occurred at or before:
...D_TO_MASTER= 0,EXEC_END_UTC_TS= CONVERTTIMESTAMP(212335796966036136),MASTER_
EXECUTION_TIME= 6950943,MASTER_ELAPSED_TIME= 104993357,QUERY_STATUS= 'COMPLETED
',QUERY_SUB_STATUS= 'N/A',ERROR_CODE= 0,SQL_ERROR_CODE= 0,ERROR_TEXT= '<N/A>',L
AST_ERROR_BEFORE_AQR= 0,DELAY_TIME_BEFORE_AQR_SEC= 0,TOTAL_NUM_AQR_RETRIES= 0,M
SG_BYTES_TO_DISK= 0,MSGS_TO_DISK= 0,ROWS_ACCESSED= 0,ROWS_RETRIEVED= 0,NUM_ROWS
_IUD= 0,PROCESSES_CREATED= 0,PROCESS_CREATE_BUSY_TIME= 0,OVF_FILE_COUNT= 0,OVF_
SPACE_ALLOCATED= 32,OVF_SPACE_USED= 5,OVF_BLOCK_SIZE= 0,OVF_WRITE_READ_COUNT= 0
,OVF_WRITE_COUNT= 0,OVF_BUFFER_BLOCKS_WRITTEN= 0,OVF_BUFFER_BYTES_WRITTEN= 0,OV
F_READ_COUNT= 0,OVF_BUFFER_BLOCKS_READ= 0,OVF_BUFFER_BYTES_READ= 0,NUM_NODES= 0
,UDR_PROCESS_BUSY_TIME= 5257702,PERTABLE_STATS= 0LAST_UPDATED_TIME= CONVERTTIME
^ (1251
characters from start of SQL statement) [2016-07-20 17:49:26] has occurred.
2016-07-20 17:49:26,044, ERROR, MXOSRVR, Node Number: 0, CPU: 0, PIN:19960,
Process Name:$Z000GAA , , ,A NonStop Process Service error Failed to write
statistics: update Trafodion."_REPOS_".metric_query_table set STATEMENT_TYPE=
'SQL_OTHER',STATEMENT_SUBTYPE= '',AGGREGATE_TOTAL= 0,STATS_ERROR_CODE=
0,QUERY_ELAPSED_TIME= 104993409,SQL_PROCESS_BUSY_TIME=
5257702,DISK_PROCESS_BUSY_TIME= 0,DISK_IOS= 0,NUM_SQL_PROCESSES=
1,SQL_SPACE_ALLOCATED= 32,SQL_SPACE_USED= 5,SQL_HEAP_ALLOCATED=
7,SQL_HEAP_USED= 2,TOTAL_MEM_ALLOC= 7,MAX_MEM_USED= 32756,NUM_REQUEST_MSGS=
0,NUM_REQUEST_MSG_BYTES= 0,NUM_REPLY_MSGS= 0,NUM_REPLY_MSG_BYTES=
0,ROWS_RETURNED_TO_MASTER= 0,EXEC_END_UTC_TS=
CONVERTTIMESTAMP(212335796966036136),MASTER_EXECUTION_TIME=
6950943,MASTER_ELAPSED_TIME= 104993357,QUERY_STATUS=
'COMPLETED',QUERY_SUB_STATUS= 'N/A',ERROR_CODE= 0,SQL_ERROR_CODE= 0,ERROR_TEXT=
'<N/A>',LAST_ERROR_BEFORE_AQR= 0,DELAY_TIME_BEFORE_AQR_SEC=
0,TOTAL_NUM_AQR_RETRIES= 0,MSG_BYTES_TO_DISK= 0,MSGS_TO_DISK= 0,ROWS_ACCESSED=
0,ROWS_RETRIEVED= 0,NUM_ROWS_IUD= 0,PROCESSES_CREATED=
0,PROCESS_CREATE_BUSY_TIME= 0,OVF_FILE_COUNT= 0,OVF_SPACE_ALLOCATED=
32,OVF_SPACE_USED= 5,OVF_BLOCK_SIZE= 0,OVF_WRITE_READ_COUNT= 0,OVF_WRITE_COUNT=
0,OVF_BUFFER_BLOCKS_WRITTEN= 0,OVF_BUFFER_BYTES_WRITTEN= 0,OVF_READ_COUNT=
0,OVF_BUFFER_BLOCKS_READ= 0,OVF_BUFFER_BYTES_READ= 0,NUM_NODES=
0,UDR_PROCESS_BUSY_TIME= 5257702,PERTABLE_STATS= 0LAST_UPDATED_TIME=
CONVERTTIMESTAMP(212335796966036168) where QUERY_ID =
'MXID11000019960212335796129352462000000001006U3333409jdbc_test_2385_SQL_CUR_9'
and EXEC_START_UTC_TS = CONVERTTIMESTAMP(212335796861042732)----Error detail -
*** ERROR[15001] A syntax error occurred at or before:
...D_TO_MASTER= 0,EXEC_END_UTC_TS= CONVERTTIMESTAMP(212335796966036136),MASTER_
EXECUTION_TIME= 6950943,MASTER_ELAPSED_TIME= 104993357,QUERY_STATUS= 'COMPLETED
',QUERY_SUB_STATUS= 'N/A',ERROR_CODE= 0,SQL_ERROR_CODE= 0,ERROR_TEXT= '<N/A>',L
AST_ERROR_BEFORE_AQR= 0,DELAY_TIME_BEFORE_AQR_SEC= 0,TOTAL_NUM_AQR_RETRIES= 0,M
SG_BYTES_TO_DISK= 0,MSGS_TO_DISK= 0,ROWS_ACCESSED= 0,ROWS_RETRIEVED= 0,NUM_ROWS
_IUD= 0,PROCESSES_CREATED= 0,PROCESS_CREATE_BUSY_TIME= 0,OVF_FILE_COUNT= 0,OVF_
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
