You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Anuradha Hegde (JIRA)" <ji...@apache.org> on 2016/05/12 23:31:12 UTC
[jira] [Updated] (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 ]
Anuradha Hegde updated TRAFODION-1208:
--------------------------------------
Fix Version/s: (was: 2.0-incubating)
> 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
>
> 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)