[
https://issues.apache.org/jira/browse/TRAFODION-2122?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15389716#comment-15389716
]
ASF GitHub Bot commented on TRAFODION-2122:
-------------------------------------------
Github user asfgit closed the pull request at:
https://github.com/apache/incubator-trafodion/pull/613
> 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)
