GS Error, OfflineTradersTable

Support for the latest build of L2J Server, get help here with installations, upgrades, problems.
Do not post bugs reports here, use viewforum.php?f=77 instead.
There is no support for other server builds than the official provided by l2jserver.com
Forum rules
READ NOW: L2j Forums Rules of Conduct
Post Reply
User avatar
Opiam
Posts: 181
Joined: Thu Jun 02, 2011 12:26 am
Location: Europe, Ukraine

GS Error, OfflineTradersTable

Post by Opiam »

If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision Number: 4737
L2JDP Revision Number: 8160

First eror...............

Code: Select all

15.07.2011 17:01:07 com.l2jserver.gameserver.datatables.OfflineTradersTable storeOfflinersWARNING: OfflineTradersTable[storeTradeItems()]: Error while saving offline traders: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet successfully received from the server was 133 127 milliseconds ago.  The last packet sent successfully to the server was 20 milliseconds ago.com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet successfully received from the server was 133 127 milliseconds ago.  The last packet sent successfully to the server was 20 milliseconds ago.    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)    at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3090)    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2979)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3520)    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)    at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:989)    at com.l2jserver.gameserver.datatables.OfflineTradersTable.storeOffliners(OfflineTradersTable.java:54)    at com.l2jserver.gameserver.Shutdown.run(Shutdown.java:215)Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.    at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2540)    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2990)    ... 10 more
Then..................

Code: Select all

15.07.2011 17:01:18 com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask runWARNING: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@2c1f9546 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (0). Last acquisition attempt exception: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.    at sun.reflect.GeneratedConstructorAccessor93.newInstance(Unknown Source)    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)    at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)    at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:344)    at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2333)    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2370)    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2154)    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)    at sun.reflect.GeneratedConstructorAccessor91.newInstance(Unknown Source)    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)    at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381)    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)    at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:152)    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1074)    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1061)    at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)    at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1796)    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:620)Caused by: java.net.ConnectException: Connection refused    at java.net.PlainSocketImpl.socketConnect(Native Method)    at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351)    at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213)    at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:200)    at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)    at java.net.Socket.connect(Socket.java:529)    at java.net.Socket.connect(Socket.java:478)    at java.net.Socket.<init>(Socket.java:375)    at java.net.Socket.<init>(Socket.java:218)    at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:257)    at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:294)    ... 20 more

Code: Select all

15.07.2011 17:01:18 com.l2jserver.L2DatabaseFactory getConnectionWARNING: L2DatabaseFactory: getConnection() failed, trying again An SQLException was provoked by the following failure: com.mchange.v2.resourcepool.ResourcePoolException: A ResourcePool cannot acquire a new resource -- the factory or source appears to be down.java.sql.SQLException: An SQLException was provoked by the following failure: com.mchange.v2.resourcepool.ResourcePoolException: A ResourcePool cannot acquire a new resource -- the factory or source appears to be down.    at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)    at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65)    at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:62)    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:617)    at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)    at com.l2jserver.L2DatabaseFactory.getConnection(L2DatabaseFactory.java:225)    at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.transformInsertInfo(L2PcInstance.java:4935)    at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.store(L2PcInstance.java:7594)    at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.store(L2PcInstance.java:7604)    at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.deleteMe(L2PcInstance.java:11493)    at com.l2jserver.gameserver.Shutdown.disconnectAllCharacters(Shutdown.java:596)    at com.l2jserver.gameserver.Shutdown.run(Shutdown.java:224)Caused by: com.mchange.v2.resourcepool.ResourcePoolException: A ResourcePool cannot acquire a new resource -- the factory or source appears to be down.    at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1366)    at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:594)    at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:514)    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:681)    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:608)    ... 8 more
Image
lion
L2j Veteran
L2j Veteran
Posts: 967
Joined: Sun Mar 11, 2007 7:49 pm
Location: Ukraine

Re: GS Error, OfflineTradersTable

Post by lion »

try read error, or use google for translate to lang what you know
User avatar
Opiam
Posts: 181
Joined: Thu Jun 02, 2011 12:26 am
Location: Europe, Ukraine

Re: GS Error, OfflineTradersTable

Post by Opiam »

lion wrote:try read error, or use google for translate to lang what you know
I now.. this is from mysql stop. but then it started... why server isn't started?
do you have any scripts for ubuntu, for autostart or auto restart?
Image
Post Reply