[
https://issues.apache.org/jira/browse/TRAFODION-1208?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pierre Smits updated TRAFODION-1208:
------------------------------------
Fix Version/s: (was: 2.1-incubating)
2.2.0
> LP Bug: 1449195 - mxosrvr failing to write to repos session and aggr metric
> table when we test connection from odbc administrator, errors in master log
> --------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: TRAFODION-1208
> URL: https://issues.apache.org/jira/browse/TRAFODION-1208
> Project: Apache Trafodion
> Issue Type: Bug
> Components: connectivity-mxosrvr
> Reporter: Aruna Sadashiva
> Assignee: Anuradha Hegde
> Priority: Critical
> Fix For: 2.2.0
>
>
> After trying etst connection from odbc administrator on Windows, the
> following errors are logged in the master log file and there are no rows
> inserted into the metric session and aggr tables. The test connection
> succeeds.
> 2015-04-27 17:54:28,169, ERROR, SQL, Node Number: 0, CPU: 3, PIN: 20885,
> Process Name: $Z030H1Q, SQLCODE: 15001, QID:
> MXID11003020885212296917167849521000000000306U3333300_483_STMT_PUBLICATION,
> *** ERROR[15001] A syntax error occurred at or before:
> insert into Trafodion."_REPOS_".metric_query_aggr_table
> values(0,0,0,20885,2088
> 5,3,0,0,'16.235.158.28',0,'$Z030H1Q','MXID1100302088521229691716784952100000000
> 0406U3333300',CONVERTTIMESTAMP(212296917268168600),CONVERTTIMESTAMP(21229691726
> 8168603),60000,33333,'DB__ROOT','NONE','SARUNA2','saruna','Trafodion ODBC
> Data
> Source 'amethyst'
> Configuration',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,
> ^ (332 characters from start of SQL statement)
> 2015-04-27 17:54:28,169, ERROR, MXOSRVR, Node Number: 3, CPU: 3, PIN:20885,
> Process Name:$Z030H1Q , , ,A NonStop Process Service error Failed to write
> statistics: insert into Trafodion."_REPOS_".metric_query_aggr_table
> values(0,0,0,20885,20885,3,0,0,'16.235.158.28',0,'$Z030H1Q','MXID11003020885212296917167849521000000000406U3333300',CONVERTTIMESTAMP(212296917268168600),CONVERTTIMESTAMP(212296917268168603),60000,33333,'DB__ROOT','NONE','SARUNA2','saruna','Trafodion
> ODBC Data Source 'amethyst'
> Configuration',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)----Error
> detail - *** ERROR[15001] A syntax error occurred at or before:
> insert into Trafodion."_REPOS_".metric_query_aggr_table
> values(0,0,0,20885,2088
> 5,3,0,0,'16.235.158.28',0,'$Z030H1Q','MXID1100302088521229691716784952100000000
> 0406U3333300',CONVERTTIMESTAMP(212296917268168600),CONVERTTIMESTAMP(21229691726
> 8168603),60000,33333,'DB__ROOT','NONE','SARUNA2','saruna','Trafodion ODBC
> Data
> Source 'amethyst'
> Configuration',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,
> ^ (332 characters from start of SQL statement) [2015-04-27
> 17:54:28] has occurred.
> 2015-04-27 17:54:33,241, ERROR, SQL, Node Number: 0, CPU: 3, PIN: 20885,
> Process Name: $Z030H1Q, SQLCODE: 15001, QID:
> MXID11003020885212296917167849521000000000306U3333300_487_STMT_PUBLICATION,
> *** ERROR[15001] A syntax error occurred at or before:
> insert into Trafodion."_REPOS_".metric_session_table
> values(0,0,0,20885,20885,3
> ,0,0,'16.235.158.28',0,'$Z030H1Q','MXID1100302088521229691716784952100000000040
> 6U3333300','END',CONVERTTIMESTAMP(212296917268168600),CONVERTTIMESTAMP(21229691
> 7273198784),33333,'DB__ROOT','NONE','SARUNA2','saruna','Trafodion ODBC Data
> Sou
> rce 'amethyst' Configuration',0,0,0,0,0,0,0,0,0,0,0,0,0,0,5827,29,0,0,0,0,0);
> ^ (329 characters from start of SQL statement)
> 2015-04-27 17:54:33,241, ERROR, MXOSRVR, Node Number: 3, CPU: 3, PIN:20885,
> Process Name:$Z030H1Q , , ,A NonStop Process Service error Failed to write
> statistics: insert into Trafodion."_REPOS_".metric_session_table
> values(0,0,0,20885,20885,3,0,0,'16.235.158.28',0,'$Z030H1Q','MXID11003020885212296917167849521000000000406U3333300','END',CONVERTTIMESTAMP(212296917268168600),CONVERTTIMESTAMP(212296917273198784),33333,'DB__ROOT','NONE','SARUNA2','saruna','Trafodion
> ODBC Data Source 'amethyst'
> Configuration',0,0,0,0,0,0,0,0,0,0,0,0,0,0,5827,29,0,0,0,0,0)----Error detail
> - *** ERROR[15001] A syntax error occurred at or before:
> insert into Trafodion."_REPOS_".metric_session_table
> values(0,0,0,20885,20885,3
> ,0,0,'16.235.158.28',0,'$Z030H1Q','MXID1100302088521229691716784952100000000040
> 6U3333300','END',CONVERTTIMESTAMP(212296917268168600),CONVERTTIMESTAMP(21229691
> 7273198784),33333,'DB__ROOT','NONE','SARUNA2','saruna','Trafodion ODBC Data
> Sou
> rce 'amethyst' Configuration',0,0,0,0,0,0,0,0,0,0,0,0,0,0,5827,29,0,0,0,0,0);
> ^ (329 characters from start of SQL statement) [2015-04-27
> 17:54:33] has occurred.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
