You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Alice Chen (JIRA)" <ji...@apache.org> on 2015/07/22 20:20:25 UTC
[jira] [Created] (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
Alice Chen created TRAFODION-1208:
-------------------------------------
Summary: 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: JudyZhao
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)