Что За Ошибки?

[djimbo 3]

Сервер на vds, онлайн 5 человек. Сборка Pw.

После авторестарта вылезло:

setHero(int days) error: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
Could not update item 268515263 in DB: Reason: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:973)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:918)
at com.mysql.jdbc.ConnectionImpl.throwConnectionClosedException(ConnectionImpl.java:1321)
at com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1313)
at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4532)
at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4497)
at com.jolbox.bonecp.ConnectionHandle.prepareStatement(ConnectionHandle.java:1024)
at net.sf.l2j.mysql.Connect.prepareStatement(Connect.java:44)
at net.sf.l2j.gameserver.model.L2ItemInstance.updateInDb(L2ItemInstance.java:1476)
at net.sf.l2j.gameserver.model.L2ItemInstance.access$000(L2ItemInstance.java:37)
at net.sf.l2j.gameserver.model.L2ItemInstance$LazyUpdateInDb.updateInDb(L2ItemInstance.java:175)
at net.sf.l2j.gameserver.model.L2ItemInstance$LazyUpdateInDb.run(L2ItemInstance.java:167)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Could not insert item 268516656 into DB: Reason: java.sql.SQLException: Connection is closed!
Could not update item 268516654 in DB: Reason: java.sql.SQLException: Connection is closed!
java.sql.SQLException: Connection is closed!
at com.jolbox.bonecp.ConnectionHandle.checkClosed(ConnectionHandle.java:459)
at com.jolbox.bonecp.ConnectionHandle.prepareStatement(ConnectionHandle.java:1011)
at net.sf.l2j.mysql.Connect.prepareStatement(Connect.java:44)
at net.sf.l2j.gameserver.model.L2ItemInstance.updateInDb(L2ItemInstance.java:1476)
at net.sf.l2j.gameserver.model.L2ItemInstance.updateDatabase(L2ItemInstance.java:1235)
at net.sf.l2j.gameserver.model.L2ItemInstance.updateDatabase(L2ItemInstance.java:1208)
at net.sf.l2j.gameserver.model.Inventory.setPaperdollItem(Inventory.java:733)
at net.sf.l2j.gameserver.model.Inventory.equipItem(Inventory.java:1142)
at net.sf.l2j.gameserver.model.Inventory.equipItemAndRecord(Inventory.java:951)
at net.sf.l2j.gameserver.model.actor.instance.L2PcInstance.useEquippableItem(L2PcInstance.java:1989)
at net.sf.l2j.gameserver.network.clientpackets.UseItem.runImpl(UseItem.java:125)
at net.sf.l2j.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:51)
at org.jboss.netty.handler.execution.MemoryAwareThreadPoolExecutor$MemoryAwareRunnable.run(MemoryAwareThreadPoolExecutor.java:622)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Error could not store char skills: java.sql.SQLException: Connection is closed!
Error could not store char skills: java.sql.SQLException: Connection is closed!
Error could not store char skills: java.sql.SQLException: Connection is closed!
Error could not store char skills: java.sql.SQLException: Connection is closed!
Error could not store char skills: java.sql.SQLException: Connection is closed!
Error could not store char skills: java.sql.SQLException: Connection is closed!
Error could not store char skills: java.sql.SQLException: Connection is closed!
Error could not store char skills: java.sql.SQLException: Connection is closed!
Error could not store char skills: java.sql.SQLException: Connection is closed!
Error could not store char skills: java.sql.SQLException: Connection is closed!
Error could not store char skills: java.sql.SQLException: Connection is closed!
Error could not store char skills: java.sql.SQLException: Connection is closed!
Error could not store char skills: java.sql.SQLException: Connection is closed!
Error could not store char skills: java.sql.SQLException: Connection is closed!
Error could not store char skills: java.sql.SQLException: Connection is closed!
Error could not store char skills: java.sql.SQLException: Connection is closed!
Error could not store char skills: java.sql.SQLException: Connection is closed!
Error could not store char skills: java.sql.SQLException: Connection is closed!
Error could not store char skills: java.sql.SQLException: Connection is closed!
Error could not store char skills: java.sql.SQLException: Connection is closed!
Error could not store char skills: java.sql.SQLException: Connection is closed!
Error could not store char skills: java.sql.SQLException: Connection is closed!
Error could not store char skills: java.sql.SQLException: Connection is closed!
Error could not store char skills: java.sql.SQLException: Connection is closed!
Error could not store char skills: java.sql.SQLException: Connection is closed!

 

В чем проблема, кто знает?

в мускуле max_connections=90000

с меня +

[djimbo 3]

Could not insert item 268528880 into DB: Reason: java.sql.SQLException: Connection is closed!
Could not insert item 268528887 into DB: Reason: java.sql.SQLException: Connection is closed!
Could not insert item 268529561 into DB: Reason: java.sql.SQLException: Connection is closed!
Could not insert item 268529563 into DB: Reason: java.sql.SQLException: Connection is closed!
Could not insert item 268529596 into DB: Reason: java.sql.SQLException: Connection is closed!

[gigilo1968 46]

Could not update item 268515263 in DB: Reason: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.

 

удалите итемы с базы у котороих эти ID 268515263 ..... посмотрите на результат, ГС не может обновить эти итемы

Изменено 9 августа, 2014 пользователем gigilo1968

[djimbo 3]

Could not update item 268515263 in DB: Reason: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.

 

удалите итемы с базы у котороих эти ID 268515263 ..... посмотрите на результат, ГС не может обновить эти итемы

Это я понимаю что не может обновить, мне бы узнать в чем причина.

Через некоторое время ошибки уже из-за других итемов.

[Emerald 55]

была такая трабла! я избавлялся от неё брал базу делал бекап, удалял старую полностью и заливал бекап и всё было гуд!

[djimbo 3]

была такая трабла! я избавлялся от неё брал базу делал бекап, удалял старую полностью и заливал бекап и всё было гуд!

Хорошо, попробуем. Базу не обязательно переустанавливать?

[Emerald 55]

Хорошо, попробуем. Базу не обязательно переустанавливать?

 

сделай бекап своей на выключенном сервере! и потом заного его установи!