Page 1 of 1

Connection and account problem

Posted: Thu Jan 07, 2010 6:44 pm
by wergy
If you want to receive support we need this info to help you properly.
ยป Find Revision
L2J Revision Number:3763
L2JDP Revision Number:6842

Hello. I have a little problem when i connec to my server. I type the login and password, then a message appears saying my login or pass are wrong( they are correct ), so i retype and it accepts(it is not creating a new account cuz already exists there), but it shows no chars. I click re-login, type my info, it accepts and this time my char appears but without any clothes or whatsoever, like a new char. If i click again re-login, enter my info, now all appears well.
I guess this happens only after a certain time the server is online. If i start the server and when it is ready, if i login everything is good...but after a while this "bug" happens.
I've checked the logs and there are some messages:


Could not restore char info: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 740,483 milliseconds ago. The last packet sent successfully to the server was 6 milliseconds ago.
Problem with checked-in Statement, discarding.
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
at com.mysql.jdbc.StatementImpl.checkClosed(StatementImpl.java:405)
at com.mysql.jdbc.PreparedStatement.clearParameters(PreparedStatement.java:1132)
at com.mchange.v2.c3p0.stmt.GooGooStatementCache.refreshStatement(GooGooStatementCache.java:604)
at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinStatement(GooGooStatementCache.java:236)
at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinAll(GooGooStatementCache.java:288)
at com.mchange.v2.c3p0.impl.NewPooledConnection.checkinAllCachedStatements(NewPooledConnection.java:664)
at com.mchange.v2.c3p0.impl.NewPooledConnection.markClosedProxyConnection(NewPooledConnection.java:347)
at com.mchange.v2.c3p0.impl.NewProxyConnection.close(NewProxyConnection.java:1246)
at com.l2jserver.gameserver.network.serverpackets.CharSelectionInfo.loadCharacterSelectInfo(CharSelectionInfo.java:229)
at com.l2jserver.gameserver.network.serverpackets.CharSelectionInfo.<init>(CharSelectionInfo.java:55)
at com.l2jserver.gameserver.LoginServerThread.run(LoginServerThread.java:323)

could not restore inventory:
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 748,059 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3052)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2938)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3481)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2077)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2228)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at com.l2jserver.gameserver.model.itemcontainer.PcInventory.restoreVisibleInventory(PcInventory.java:609)
at com.l2jserver.gameserver.model.CharSelectInfoPackage.<init>(CharSelectInfoPackage.java:67)
at com.l2jserver.gameserver.network.serverpackets.CharSelectionInfo.restoreChar(CharSelectionInfo.java:290)
at com.l2jserver.gameserver.network.serverpackets.CharSelectionInfo.loadCharacterSelectInfo(CharSelectionInfo.java:213)
at com.l2jserver.gameserver.network.serverpackets.CharSelectionInfo.<init>(CharSelectionInfo.java:55)
at com.l2jserver.gameserver.LoginServerThread.run(LoginServerThread.java:323)
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:2497)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2949)
... 14 more

Problem with checked-in Statement, discarding.
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
at com.mysql.jdbc.StatementImpl.checkClosed(StatementImpl.java:405)
at com.mysql.jdbc.PreparedStatement.clearParameters(PreparedStatement.java:1132)
at com.mchange.v2.c3p0.stmt.GooGooStatementCache.refreshStatement(GooGooStatementCache.java:604)
at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinStatement(GooGooStatementCache.java:236)
at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinAll(GooGooStatementCache.java:288)
at com.mchange.v2.c3p0.impl.NewPooledConnection.checkinAllCachedStatements(NewPooledConnection.java:664)
at com.mchange.v2.c3p0.impl.NewPooledConnection.markClosedProxyConnection(NewPooledConnection.java:347)
at com.mchange.v2.c3p0.impl.NewProxyConnection.close(NewProxyConnection.java:1246)
at com.l2jserver.gameserver.model.itemcontainer.PcInventory.restoreVisibleInventory(PcInventory.java:632)
at com.l2jserver.gameserver.model.CharSelectInfoPackage.<init>(CharSelectInfoPackage.java:67)
at com.l2jserver.gameserver.network.serverpackets.CharSelectionInfo.restoreChar(CharSelectionInfo.java:290)
at com.l2jserver.gameserver.network.serverpackets.CharSelectionInfo.loadCharacterSelectInfo(CharSelectionInfo.java:213)
at com.l2jserver.gameserver.network.serverpackets.CharSelectionInfo.<init>(CharSelectionInfo.java:55)
at com.l2jserver.gameserver.LoginServerThread.run(LoginServerThread.java:323)


Could not restore augmentation info: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 779,510 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.
Problem with checked-in Statement, discarding.
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
at com.mysql.jdbc.StatementImpl.checkClosed(StatementImpl.java:405)
at com.mysql.jdbc.PreparedStatement.clearParameters(PreparedStatement.java:1132)
at com.mchange.v2.c3p0.stmt.GooGooStatementCache.refreshStatement(GooGooStatementCache.java:604)
at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinStatement(GooGooStatementCache.java:236)
at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinAll(GooGooStatementCache.java:288)
at com.mchange.v2.c3p0.impl.NewPooledConnection.checkinAllCachedStatements(NewPooledConnection.java:664)
at com.mchange.v2.c3p0.impl.NewPooledConnection.markClosedProxyConnection(NewPooledConnection.java:347)
at com.mchange.v2.c3p0.impl.NewProxyConnection.close(NewProxyConnection.java:1246)
at com.l2jserver.gameserver.network.serverpackets.CharSelectionInfo.restoreChar(CharSelectionInfo.java:368)
at com.l2jserver.gameserver.network.serverpackets.CharSelectionInfo.loadCharacterSelectInfo(CharSelectionInfo.java:213)
at com.l2jserver.gameserver.network.serverpackets.CharSelectionInfo.<init>(CharSelectionInfo.java:55)
at com.l2jserver.gameserver.LoginServerThread.run(LoginServerThread.java:323)

Could not restore augmentation and elemental data for item 268486843 from DB: Communications link failure

The last packet successfully received from the server was 783,900 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 783,900 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3052)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2938)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3481)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2077)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2228)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at com.l2jserver.gameserver.model.L2ItemInstance.restoreAttributes(L2ItemInstance.java:902)
at com.l2jserver.gameserver.model.L2ItemInstance.restoreFromDb(L2ItemInstance.java:1401)
at com.l2jserver.gameserver.model.itemcontainer.Inventory.restore(Inventory.java:1688)
at com.l2jserver.gameserver.model.itemcontainer.PcInventory.restore(PcInventory.java:593)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.<init>(L2PcInstance.java:1131)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.restore(L2PcInstance.java:7240)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.load(L2PcInstance.java:1086)
at com.l2jserver.gameserver.network.L2GameClient.loadCharFromDisk(L2GameClient.java:496)
at com.l2jserver.gameserver.network.clientpackets.CharacterSelect.runImpl(CharacterSelect.java:92)
at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:92)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
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:2497)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2949)
... 21 more

Problem with checked-in Statement, discarding.
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
at com.mysql.jdbc.StatementImpl.checkClosed(StatementImpl.java:405)
at com.mysql.jdbc.PreparedStatement.clearParameters(PreparedStatement.java:1132)
at com.mchange.v2.c3p0.stmt.GooGooStatementCache.refreshStatement(GooGooStatementCache.java:604)
at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinStatement(GooGooStatementCache.java:236)
at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinAll(GooGooStatementCache.java:288)
at com.mchange.v2.c3p0.impl.NewPooledConnection.checkinAllCachedStatements(NewPooledConnection.java:664)
at com.mchange.v2.c3p0.impl.NewPooledConnection.markClosedProxyConnection(NewPooledConnection.java:347)
at com.mchange.v2.c3p0.impl.NewProxyConnection.close(NewProxyConnection.java:1246)
at com.l2jserver.gameserver.model.L2ItemInstance.restoreAttributes(L2ItemInstance.java:927)
at com.l2jserver.gameserver.model.L2ItemInstance.restoreFromDb(L2ItemInstance.java:1401)
at com.l2jserver.gameserver.model.itemcontainer.Inventory.restore(Inventory.java:1688)
at com.l2jserver.gameserver.model.itemcontainer.PcInventory.restore(PcInventory.java:593)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.<init>(L2PcInstance.java:1131)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.restore(L2PcInstance.java:7240)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.load(L2PcInstance.java:1086)
at com.l2jserver.gameserver.network.L2GameClient.loadCharFromDisk(L2GameClient.java:496)
at com.l2jserver.gameserver.network.clientpackets.CharacterSelect.runImpl(CharacterSelect.java:92)
at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:92)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

Could not restore augmentation and elemental data for item 268486845 from DB: Communications link failure

The last packet successfully received from the server was 802,038 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 802,038 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3052)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2938)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3481)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2077)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2228)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at com.l2jserver.gameserver.model.L2ItemInstance.restoreAttributes(L2ItemInstance.java:902)
at com.l2jserver.gameserver.model.L2ItemInstance.restoreFromDb(L2ItemInstance.java:1401)
at com.l2jserver.gameserver.model.itemcontainer.Inventory.restore(Inventory.java:1688)
at com.l2jserver.gameserver.model.itemcontainer.PcInventory.restore(PcInventory.java:593)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.<init>(L2PcInstance.java:1131)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.restore(L2PcInstance.java:7240)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.load(L2PcInstance.java:1086)
at com.l2jserver.gameserver.network.L2GameClient.loadCharFromDisk(L2GameClient.java:496)
at com.l2jserver.gameserver.network.clientpackets.CharacterSelect.runImpl(CharacterSelect.java:92)
at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:92)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
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:2497)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2949)
... 21 more

Problem with checked-in Statement, discarding.
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
at com.mysql.jdbc.StatementImpl.checkClosed(StatementImpl.java:405)
at com.mysql.jdbc.PreparedStatement.clearParameters(PreparedStatement.java:1132)
at com.mchange.v2.c3p0.stmt.GooGooStatementCache.refreshStatement(GooGooStatementCache.java:604)
at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinStatement(GooGooStatementCache.java:236)
at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinAll(GooGooStatementCache.java:288)
at com.mchange.v2.c3p0.impl.NewPooledConnection.checkinAllCachedStatements(NewPooledConnection.java:664)
at com.mchange.v2.c3p0.impl.NewPooledConnection.markClosedProxyConnection(NewPooledConnection.java:347)
at com.mchange.v2.c3p0.impl.NewProxyConnection.close(NewProxyConnection.java:1246)
at com.l2jserver.gameserver.model.L2ItemInstance.restoreAttributes(L2ItemInstance.java:927)
at com.l2jserver.gameserver.model.L2ItemInstance.restoreFromDb(L2ItemInstance.java:1401)
at com.l2jserver.gameserver.model.itemcontainer.Inventory.restore(Inventory.java:1688)
at com.l2jserver.gameserver.model.itemcontainer.PcInventory.restore(PcInventory.java:593)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.<init>(L2PcInstance.java:1131)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.restore(L2PcInstance.java:7240)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.load(L2PcInstance.java:1086)
at com.l2jserver.gameserver.network.L2GameClient.loadCharFromDisk(L2GameClient.java:496)
at com.l2jserver.gameserver.network.clientpackets.CharacterSelect.runImpl(CharacterSelect.java:92)
at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:92)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

Could not restore augmentation and elemental data for item 268486841 from DB: Communications link failure

The last packet successfully received from the server was 802,046 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 802,046 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3052)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2938)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3481)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2077)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2228)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at com.l2jserver.gameserver.model.L2ItemInstance.restoreAttributes(L2ItemInstance.java:902)
at com.l2jserver.gameserver.model.L2ItemInstance.restoreFromDb(L2ItemInstance.java:1401)
at com.l2jserver.gameserver.model.itemcontainer.Inventory.restore(Inventory.java:1688)
at com.l2jserver.gameserver.model.itemcontainer.PcInventory.restore(PcInventory.java:593)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.<init>(L2PcInstance.java:1131)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.restore(L2PcInstance.java:7240)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.load(L2PcInstance.java:1086)
at com.l2jserver.gameserver.network.L2GameClient.loadCharFromDisk(L2GameClient.java:496)
at com.l2jserver.gameserver.network.clientpackets.CharacterSelect.runImpl(CharacterSelect.java:92)
at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:92)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
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:2497)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2949)
... 21 more

Problem with checked-in Statement, discarding.
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
at com.mysql.jdbc.StatementImpl.checkClosed(StatementImpl.java:405)
at com.mysql.jdbc.PreparedStatement.clearParameters(PreparedStatement.java:1132)
at com.mchange.v2.c3p0.stmt.GooGooStatementCache.refreshStatement(GooGooStatementCache.java:604)
at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinStatement(GooGooStatementCache.java:236)
at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinAll(GooGooStatementCache.java:288)
at com.mchange.v2.c3p0.impl.NewPooledConnection.checkinAllCachedStatements(NewPooledConnection.java:664)
at com.mchange.v2.c3p0.impl.NewPooledConnection.markClosedProxyConnection(NewPooledConnection.java:347)
at com.mchange.v2.c3p0.impl.NewProxyConnection.close(NewProxyConnection.java:1246)
at com.l2jserver.gameserver.model.L2ItemInstance.restoreAttributes(L2ItemInstance.java:927)
at com.l2jserver.gameserver.model.L2ItemInstance.restoreFromDb(L2ItemInstance.java:1401)
at com.l2jserver.gameserver.model.itemcontainer.Inventory.restore(Inventory.java:1688)
at com.l2jserver.gameserver.model.itemcontainer.PcInventory.restore(PcInventory.java:593)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.<init>(L2PcInstance.java:1131)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.restore(L2PcInstance.java:7240)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.load(L2PcInstance.java:1086)
at com.l2jserver.gameserver.network.L2GameClient.loadCharFromDisk(L2GameClient.java:496)
at com.l2jserver.gameserver.network.clientpackets.CharacterSelect.runImpl(CharacterSelect.java:92)
at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:92)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)


Thanks

Re: Connection and account problem

Posted: Fri Jan 08, 2010 10:05 am
by janiii
local or remote server? some other network problems?

Re: Connection and account problem

Posted: Fri Jan 08, 2010 6:07 pm
by wergy
It is a remote server. Local does the same thing. I didn't notice any other problems in the network in the remote server.
Anyone has a clue? already tested it with another version and still the same. Can it be the delay between connections? or something like that?

Re: Connection and account problem

Posted: Sun Jan 10, 2010 10:01 pm
by wergy
No one? =(

Re: Connection and account problem

Posted: Mon Jan 11, 2010 9:59 am
by _DS_
Your mysql server dropping connections.

Re: Connection and account problem

Posted: Mon Jan 11, 2010 11:42 am
by denser
try to get repair tables if some of them damaged

Re: Connection and account problem

Posted: Tue Jan 12, 2010 4:27 pm
by wergy
I did a repair on the tables, everything was good. I optimize it too. Still doing the same.