Yes, that's quite strange.
Can it be a thread safety issue? Field org.h2.engine.Session#closed is not 
volatile and access to it is not synchronized. Can it happen so that one 
thread closes a session but after that another thread adds a lock? 


Are you sure there were no previous exceptions logged which indicate why it 
> closed this way?
>

I do not see any other exceptions.
There are a bunch of such exceptions in log:
W 160326 193447.825 [Resource Destroyer in BasicResourcePool.close()] 
BasicResourcePool - Failed to destroy resource: com.mchange.v2.c3p0.impl.
NewPooledConnection@2c6f911c
 java.sql.SQLException: Some resources failed to close properly while 
closing com.mchange.v2.c3p0.impl.NewPooledConnection@2c6f911c
     at com.mchange.v2.c3p0.impl.NewPooledConnection.close(
NewPooledConnection.java:664)
     at com.mchange.v2.c3p0.impl.NewPooledConnection.closeMaybeCheckedOut(
NewPooledConnection.java:255)
     at com.mchange.v2.c3p0.impl.
C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.
destroyResource(C3P0PooledConnectionPool.java:621)
     at com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask.
run(BasicResourcePool.java:1065)
     at com.mchange.v2.resourcepool.BasicResourcePool.destroyResource(
BasicResourcePool.java:1090)
     at com.mchange.v2.resourcepool.BasicResourcePool.destroyResource(
BasicResourcePool.java:1051)
     at com.mchange.v2.resourcepool.BasicResourcePool.access$100(
BasicResourcePool.java:44)
     at com.mchange.v2.resourcepool.BasicResourcePool$5.run(
BasicResourcePool.java:1305)

When I debug their cause I can see that it is caused by:
org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "SYS" [50200-191]

As I understand, it is caused by the DbException which I have mentioned in 
the previous message.

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

Reply via email to