Page 1 of 1

C4: java.sql.SQLException: Connection is invalid

Posted: Wed May 04, 2011 5:12 pm
by touma04
If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision Number: 1844
L2JDP Revision Number: 1845

Extra info:

Chronicle: C4
Build: Banished 1.2.6 although this error happened to me with clean builds of C4.

Error:

This message pops up in the loginserver cmd window when I try to log in from the C4 Client. During the first seconds the client and the login server stand still and don't show anything as I push enter once written both user and pass (on the client window).

Then the following error appears on the gameserver window:

error.0.log

Code: Select all

 04/05/2011 12:26:41 com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask runADVERTENCIA: BasicResourcePool: An idle resource is broken and will be purged.java.sql.SQLException: Connection is invalid    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.testPooledConnection(C3P0PooledConnectionPool.java:224)    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.refurbishIdleResource(C3P0PooledConnectionPool.java:147)    at com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask.run(BasicResourcePool.java:1396)    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:368)04/05/2011 12:26:41 com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask runADVERTENCIA: BasicResourcePool: An idle resource is broken and will be purged.java.sql.SQLException: Connection is invalid    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.testPooledConnection(C3P0PooledConnectionPool.java:224)    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.refurbishIdleResource(C3P0PooledConnectionPool.java:147)    at com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask.run(BasicResourcePool.java:1396)    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:368)04/05/2011 12:26:41 com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask runADVERTENCIA: BasicResourcePool: An idle resource is broken and will be purged.java.sql.SQLException: Connection is invalid    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.testPooledConnection(C3P0PooledConnectionPool.java:224)    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.refurbishIdleResource(C3P0PooledConnectionPool.java:147)    at com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask.run(BasicResourcePool.java:1396)    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:368)04/05/2011 12:26:41 com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask runADVERTENCIA: BasicResourcePool: An idle resource is broken and will be purged.java.sql.SQLException: Connection is invalid    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.testPooledConnection(C3P0PooledConnectionPool.java:224)    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.refurbishIdleResource(C3P0PooledConnectionPool.java:147)    at com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask.run(BasicResourcePool.java:1396)    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:368)04/05/2011 12:26:41 com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask runADVERTENCIA: BasicResourcePool: An idle resource is broken and will be purged.java.sql.SQLException: Connection is invalid    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.testPooledConnection(C3P0PooledConnectionPool.java:224)    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.refurbishIdleResource(C3P0PooledConnectionPool.java:147)    at com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask.run(BasicResourcePool.java:1396)    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:368)04/05/2011 12:26:41 com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask runADVERTENCIA: BasicResourcePool: An idle resource is broken and will be purged.java.sql.SQLException: Connection is invalid    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.testPooledConnection(C3P0PooledConnectionPool.java:224)    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.refurbishIdleResource(C3P0PooledConnectionPool.java:147)    at com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask.run(BasicResourcePool.java:1396)    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:368)04/05/2011 12:26:41 com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask runADVERTENCIA: BasicResourcePool: An idle resource is broken and will be purged.java.sql.SQLException: Connection is invalid    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.testPooledConnection(C3P0PooledConnectionPool.java:224)    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.refurbishIdleResource(C3P0PooledConnectionPool.java:147)    at com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask.run(BasicResourcePool.java:1396)    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:368)04/05/2011 12:26:41 com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask runADVERTENCIA: BasicResourcePool: An idle resource is broken and will be purged.java.sql.SQLException: Connection is invalid    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.testPooledConnection(C3P0PooledConnectionPool.java:224)    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.refurbishIdleResource(C3P0PooledConnectionPool.java:147)    at com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask.run(BasicResourcePool.java:1396)    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:368)04/05/2011 12:26:41 com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask runADVERTENCIA: BasicResourcePool: An idle resource is broken and will be purged.java.sql.SQLException: Connection is invalid    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.testPooledConnection(C3P0PooledConnectionPool.java:224)    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.refurbishIdleResource(C3P0PooledConnectionPool.java:147)    at com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask.run(BasicResourcePool.java:1396)    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:368)  
Right after the error pops up in the login server command window it pops up in the game server command window, and, eventually, the cliente crashes with gameguard error 1002 and 660.

This is weird since I've been able to host any server from CT 1.5 onwards, and the only server chronicle I've tried older than CT 1.5 is C4, which is this case.

Thank you very much for your time.

Re: C4: java.sql.SQLException: Connection is invalid

Posted: Wed May 04, 2011 6:38 pm
by jurchiks
does your client have gameguard disabled/are you running client and server from the same PC?
It seems something is stopping c3p0 from making the database connections, and it could be gameguard.

Re: C4: java.sql.SQLException: Connection is invalid

Posted: Thu May 05, 2011 2:55 am
by touma04
jurchiks wrote:does your client have gameguard disabled/are you running client and server from the same PC?
It seems something is stopping c3p0 from making the database connections, and it could be gameguard.
I don't know how to disable gameguard on the C4 chronicle, and yes, the server and the client are being run from the same pc.

Re: C4: java.sql.SQLException: Connection is invalid

Posted: Thu May 05, 2011 6:25 am
by jurchiks
well, to be sure you can try running the client from another PC. If the problem stops then it's most probably gameguard.