db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kathey Marsden (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-256) ASSERTION when attempting to execute a statement after shutdown of database with network Server
Date Fri, 15 Jul 2005 14:11:10 GMT
    [ http://issues.apache.org/jira/browse/DERBY-256?page=comments#action_12315923 ] 

Kathey Marsden commented on DERBY-256:
--------------------------------------

It is probably best to focus on why we are seeing the assertion on the server side.  I think
the  server should be throwing an SQLException instead of this assertion.
com.ibm.db2j.protocol.BasicServices.Errors.AssertFailure: 
ASSERT FAILED connection is closed
        at 
com.ibm.db2j.protocol.BasicServices.SanityService.SanityManager.
ASSERT(SanityManager.java:124)
        at 
com.ibm.db2j.impl.Connectivity.JDBC.Local.LocalConnection.prepar
eCall(LocalConnection.java:887)
        at 

If the server does the right thing the client state should take care of itself I think
 

> ASSERTION when attempting to execute a statement after shutdown of database with network
Server
> -----------------------------------------------------------------------------------------------
>
>          Key: DERBY-256
>          URL: http://issues.apache.org/jira/browse/DERBY-256
>      Project: Derby
>         Type: Bug
>   Components: Network Server
>     Reporter: Kathey Marsden

>
> java -Dij.protocol=jdbc:derby:net://localhost:1527/ -Dij.user=I -Dij.password=mine org.apache.derby.tools.ij
> -- create and connect to the databases
> ij> connect 'wombat;create=true';
> ij> connect 'myDB;create=true';
> -- shutdown database wombat
> -- ERROR 08006 expected
> ij(CONNECTION1)> connect 'wombat;shutdown=true';
> Connection number: 3.
> ERROR 08006: wombat?(server log XXXX)?atabase 'wombat' 
> shutdown.?08006.D
> com.ibm.db2.jcc.am.SqlException: wombat?(server log XXX) Database 'wombat' 
> shutdown.?08006.D
> ij(CONNECTION1)> show connections;
> CONNECTION0 -   
> jdbc:db2j:net://localhost:1527/wombat;create=true
> CONNECTION1* -  
> jdbc:db2j:net://localhost:1527/myDB;create=true
> * = current connection
> ij(CONNECTION1)> select * from sys.systables;
> -- system tables are returned
> 15 rows selected
> -- shutdown database myDB
> -- ERROR 08006 expected
> ij(CONNECTION1)> connect 'mydb;shutdown=true';
> Connection number: 4.
> ERROR 08006: mydb?(server 
> log:XXXX)Database 'mydb' 
> shutdown.?08006.D
> com.ibm.db2.jcc.am.SqlException: mydb?(server 
> log: XXX)Database 'mydb' 
> shutdown.?08006.D
> ij(CONNECTION1)> show connections;
> CONNECTION0 -   
> jdbc:db2j:net://localhost:1527/wombat;create=true
> CONNECTION1* -  
> jdbc:db2j:net://localhost:1527/myDB;create=true
> * = current connections
> ij(CONNECTION1)> select * from sys.systables;
> com.ibm.db2j.protocol.BasicServices.Errors.AssertFailure: 
> ASSERT FAILED connection is closed
>         at 
> com.ibm.db2j.protocol.BasicServices.SanityService.SanityManager.
> ASSERT(SanityManager.java:124)
>         at 
> com.ibm.db2j.impl.Connectivity.JDBC.Local.LocalConnection.prepar
> eCall(LocalConnection.java:887)
>         at 
> com.ibm.db2j.impl.Connectivity.JDBC.Local.LocalConnection.prepar
> eCall(LocalConnection.java:842)
>         at 
> com.ibm.db2j.drda.DRDAConnThread.parseSQLDTA_work(DRDAConnThread
> .java:3771)
>         at 
> com.ibm.db2j.drda.DRDAConnThread.parseSQLDTA(DRDAConnThread.java
> :3694)
>         at 
> com.ibm.db2j.drda.DRDAConnThread.parseEXCSQLSTTobjects(DRDAConnT
> hread.java:3576)
>         at 
> com.ibm.db2j.drda.DRDAConnThread.parseEXCSQLSTT(DRDAConnThread.j
> ava:3422)
>         at 
> com.ibm.db2j.drda.DRDAConnThread.processCommands(DRDAConnThread.
> java:848)
>         at 
> com.ibm.db2j.drda.DRDAConnThread.run(DRDAConnThread.java:235)
> agentThread[DRDAConnThread_4,5,main]
> ERROR 08003: DB2 SQL error: SQLCODE: -1, SQLSTATE: 08003, 
> SQLERRMC: (server log:C:\mark52\test\users\test\db2j.log)?No 
> current connection.?08003
> com.ibm.db2.jcc.am.SqlException: (server 
> log:C:\mark52\test\users\test\db2j.log)?No current 
> connection.?08003
>         at 
> com.ibm.db2.jcc.am.Statement.completeSqlca(Statement.java:1459)
>         at 
> com.ibm.db2.jcc.t4.T4StatementReply.parsePrepareError(T4Statemen
> tReply.java:594)
>         at 
> com.ibm.db2.jcc.t4.T4StatementReply.parsePRPSQLSTTreply(T4Statem
> entReply.java:141)
>         at 
> com.ibm.db2.jcc.t4.T4StatementReply.readPrepareDescribeOutput(T4
> StatementReply.java:42)
>         at 
> com.ibm.db2.jcc.t4.StatementReply.readPrepareDescribeOutput(Stat
> ementReply.java:31)
>         at 
> com.ibm.db2.jcc.t4.T4Statement.readPrepareDescribeOutput_(T4Stat
> ement.java:142)
>         at 
> com.ibm.db2.jcc.am.Statement.readPrepareDescribeOutput(Statement
> .java:1062)
>         at 
> com.ibm.db2.jcc.am.Statement.flowExecute(Statement.java:1702)
>         at 
> com.ibm.db2.jcc.am.Statement.executeX(Statement.java:666)
>         at 
> com.ibm.db2.jcc.am.Statement.execute(Statement.java:650)
>         at 
> com.ibm.db2j.tools.ijImpl.ij.executeImmediate(ij.java:261)
>         at 
> com.ibm.db2j.tools.ijImpl.utilMain.doCatch(utilMain.java:427)
>         at 
> com.ibm.db2j.tools.ijImpl.utilMain.go(utilMain.java:306)
>         at com.ibm.db2j.tools.ijImpl.Main.go(Main.java:202)
>         at 
> com.ibm.db2j.tools.ijImpl.Main.mainCore(Main.java:168)
>         at com.ibm.db2j.tools.ijImpl40.Main.main(Main.java:49)
>         at com.ibm.db2j.tools.ij.main(ij.java:51)
> ij(CONNECTION1)> 
> com.ibm.db2j.protocol.BasicServices.Errors.AssertFailure: 
> ASSERT FAILED connection is closed
>         at 
> com.ibm.db2j.protocol.BasicServices.SanityService.SanityManager.
> ASSERT(SanityManager.java:124)
>         at 
> com.ibm.db2j.impl.Connectivity.JDBC.Local.LocalConnection.prepar
> eCall(LocalConnection.java:887)
>         at 
> com.ibm.db2j.impl.Connectivity.JDBC.Local.LocalConnection.prepar
> eCall(LocalConnection.java:842)
>         at 
> com.ibm.db2j.drda.DRDAConnThread.parseSQLDTA_work(DRDAConnThread
> .java:3771)
>         at 
> com.ibm.db2j.drda.DRDAConnThread.parseSQLDTA(DRDAConnThread.java
> :3694)
>         at 
> com.ibm.db2j.drda.DRDAConnThread.parseEXCSQLSTTobjects(DRDAConnT
> hread.java:3576)
>         at 
> com.ibm.db2j.drda.DRDAConnThread.parseEXCSQLSTT(DRDAConnThread.j
> ava:3422)
>         at 
> com.ibm.db2j.drda.DRDAConnThread.processCommands(DRDAConnThread.
> java:848)
>         at 
> com.ibm.db2j.drda.DRDAConnThread.run(DRDAConnThread.java:235)

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


Mime
View raw message