You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Suresh Subbiah (JIRA)" <ji...@apache.org> on 2015/10/08 07:11:26 UTC
[jira] [Assigned] (TRAFODION-1208) 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
[ https://issues.apache.org/jira/browse/TRAFODION-1208?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Suresh Subbiah reassigned TRAFODION-1208:
-----------------------------------------
Assignee: Anuradha Hegde (was: JudyZhao)
> 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.0-incubating
>
>
> 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
(v6.3.4#6332)