Hi,
we are getting the following problem on a daily basis .
The setup is V3.0.9 asemon_logger running against a 16.0.03.04 ASE Sybase server.
java.sql.SQLException: JZ006: Caught IOException: **com.sybase.jdbc4.jdbc.SybConnectionDeadException: JZ0C0: Connection is already closed.
at com.sybase.jdbc4.jdbc.ErrorMessage.createIOEKilledConnEx(ErrorMessage.java:1097)
at com.sybase.jdbc4.jdbc.ErrorMessage.raiseErrorCheckDead(ErrorMessage.java:1135)
at com.sybase.jdbc4.tds.Tds.handleIOE(Tds.java:5249)
at com.sybase.jdbc4.tds.Tds.handleIOE(Tds.java:5194)
at com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:2976)
at com.sybase.jdbc4.jdbc.ResultGetter.nextResult(ResultGetter.java:78)
at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:302)
at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:284)
at com.sybase.jdbc4.jdbc.SybStatement.queryLoop(SybStatement.java:2655)
at com.sybase.jdbc4.jdbc.SybStatement.executeQuery(SybStatement.java:2641)
at com.sybase.jdbc4.jdbc.SybStatement.executeQuery(SybStatement.java:564)
at asemonlogger.CollectorMonSQL$RunningStmt.retreiveProcessObjects(CollectorMonSQL.java:684)
at asemonlogger.CollectorMonSQL$RunningStmt.access$3000(CollectorMonSQL.java:479)
at asemonlogger.CollectorMonSQL.getMetrics(CollectorMonSQL.java:1549)
at asemonlogger.Collector.run(Collector.java:387)
A stack trace is created in the the ASE when this problem occurs which shows this SQL being run
SQL causing error : if exists (select from master..monProcessStatement where KPID=584386610 and BatchID=9 and ContextID=1 and LineNumber=1) begin exec sp_asemon_showplan
Any ideas what may be causing this ?
Cheers
Piers
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi Piers
do you have any other tool or user executing "dbcc sqltext" at the same time as sp_showplan from asemon
In the past (but should be fixed since 15.0.3) this produced a signal 11 and stack trace
Can you provide the ASE stack trace to me or SAP support ?
Cheers
Jpm
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
we are getting the following problem on a daily basis .
The setup is V3.0.9 asemon_logger running against a 16.0.03.04 ASE Sybase server.
java.sql.SQLException: JZ006: Caught IOException: **com.sybase.jdbc4.jdbc.SybConnectionDeadException: JZ0C0: Connection is already closed.
at com.sybase.jdbc4.jdbc.ErrorMessage.createIOEKilledConnEx(ErrorMessage.java:1097)
at com.sybase.jdbc4.jdbc.ErrorMessage.raiseErrorCheckDead(ErrorMessage.java:1135)
at com.sybase.jdbc4.tds.Tds.handleIOE(Tds.java:5249)
at com.sybase.jdbc4.tds.Tds.handleIOE(Tds.java:5194)
at com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:2976)
at com.sybase.jdbc4.jdbc.ResultGetter.nextResult(ResultGetter.java:78)
at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:302)
at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:284)
at com.sybase.jdbc4.jdbc.SybStatement.queryLoop(SybStatement.java:2655)
at com.sybase.jdbc4.jdbc.SybStatement.executeQuery(SybStatement.java:2641)
at com.sybase.jdbc4.jdbc.SybStatement.executeQuery(SybStatement.java:564)
at asemonlogger.CollectorMonSQL$RunningStmt.retreiveProcessObjects(CollectorMonSQL.java:684)
at asemonlogger.CollectorMonSQL$RunningStmt.access$3000(CollectorMonSQL.java:479)
at asemonlogger.CollectorMonSQL.getMetrics(CollectorMonSQL.java:1549)
at asemonlogger.Collector.run(Collector.java:387)
A stack trace is created in the the ASE when this problem occurs which shows this SQL being run
SQL causing error : if exists (select from master..monProcessStatement where KPID=584386610 and BatchID=9 and ContextID=1 and LineNumber=1) begin exec sp_asemon_showplan
Any ideas what may be causing this ?
Cheers
Piers
Hi Piers
do you have any other tool or user executing "dbcc sqltext" at the same time as sp_showplan from asemon
In the past (but should be fixed since 15.0.3) this produced a signal 11 and stack trace
Can you provide the ASE stack trace to me or SAP support ?
Cheers
Jpm
Hi,
I logged a call with SAP, I'll follow it up with them.
Just wanted to know if you'd seen it before.
Cheers
Piers