[TRAFODION-2122] daily build master executor logs contain update statement exception

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.1-incubating
• Fix Version/s: 2.1-incubating
• Component/s: connectivity-mxosrvr
• Assignee: Anuradha Hegde
• Reporter: Anuradha Hegde
• Created: 21/Jul/16 18:18
• Updated: 15/Sep/18 07:32
• Resolved: 24/Oct/16 17:45

Description

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

Issue Links

• links to: GitHub Pull Request #613