Ничерта не понимаю. Нужна помощь, может попадало кому ?

Теги:
 
+
-
edit
 

TD_ALECS

втянувшийся
В общем происходит такое:
1.Первый раз не придали значения, сервер сам ребутнулся и накрылась таблица Итемов, всех весчей чаров.
Лана решили сделали Откат на сохранёную базу.
Главный сервер не стал запускать.
Запустили Второй тестовый на котором всё было норма, раты там 400, так от бвлды крутится вторым.
Вот он проработал часа 3 наверно и потом упал, при запуске пишет нет таблицы Итемов.
Вот лог Джавы:
code text
  1. 18.01.2006 16:23:57 net.sf.l2j.gameserver.model.quest.Quest updateQuestVarInDb
  2. WARNING: could not update char quest:
  3. java.sql.SQLException: Can't open file: 'character_quests.MYI' (errno: 145)
  4.         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2921)
  5.         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1570)
  6.         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
  7.         at com.mysql.jdbc.Connection.execSQL(Connection.java:2978)
  8.         at com.mysql.jdbc.Connection.execSQL(Connection.java:2902)
  9.         at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:930)
  10.         at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1159)
  11.         at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1076)
  12.         at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1061)
  13.         at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:131)
  14.         at net.sf.l2j.gameserver.model.quest.Quest.updateQuestVarInDb(Quest.java:439)
  15.         at net.sf.l2j.gameserver.model.quest.Quest.updateQuestInDb(Quest.java:524)
  16.         at net.sf.l2j.gameserver.model.quest.QuestState.setState(QuestState.java:205)
  17.         at sun.reflect.GeneratedMethodAccessor26.invoke(Unknown Source)
  18.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  19.         at java.lang.reflect.Method.invoke(Unknown Source)
  20.         at org.python.core.PyReflectedFunction.__call__(PyReflectedFunction.java:174)
  21.         at org.python.core.PyMethod.__call__(PyMethod.java:93)
  22.         at org.python.core.PyObject.__call__(PyObject.java:592)
  23.         at data.jscript.custom.1006_tattoos$py.onEvent$3(F:Serversl2j2023gameserverdatajscriptcustom1006_tattoos__init__.py:135)
  24.         at data.jscript.custom.1006_tattoos$py.call_function(F:Serversl2j2023gameserverdatajscriptcustom1006_tattoos__init__.py)
  25.         at org.python.core.PyTableCode.call(PyTableCode.java:213)
  26.         at org.python.core.PyTableCode.call(PyTableCode.java:426)
  27.         at org.python.core.PyTableCode.call(PyTableCode.java:322)
  28.         at org.python.core.PyFunction.__call__(PyFunction.java:193)
  29.         at org.python.core.PyMethod.__call__(PyMethod.java:93)
  30.         at org.python.core.PyObject.__call__(PyObject.java:570)
  31.         at org.python.core.PyObject._jcallexc(PyObject.java:2573)
  32.         at org.python.core.PyObject._jcall(PyObject.java:2605)
  33.         at org.python.proxies.data.jscript.custom.1006_tattoos$Quest$152.onEvent(Unknown Source)
  34.         at net.sf.l2j.gameserver.model.quest.Quest.notifyEvent(Quest.java:213)
  35.         at net.sf.l2j.gameserver.model.L2PcInstance.processQuestEvent(L2PcInstance.java:1070)
  36.         at net.sf.l2j.gameserver.clientpackets.RequestBypassToServer.runImpl(RequestBypassToServer.java:212)
  37.         at net.sf.l2j.gameserver.clientpackets.ClientBasePacket.run(ClientBasePacket.java:56)
  38.         at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
  39.         at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
  40.         at java.util.concurrent.FutureTask.run(Unknown Source)
  41.         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source)
  42.         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
  43.         at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
  44.         at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  45.         at java.lang.Thread.run(Unknown Source)
  46. 18.01.2006 16:23:57 net.sf.l2j.gameserver.model.quest.Quest deleteQuestInDb
  47. WARNING: could not delete char quest:
  48. java.sql.SQLException: Can't open file: 'character_quests.MYI' (errno: 145)
  49.         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2921)
  50.         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1570)
  51.         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
  52.         at com.mysql.jdbc.Connection.execSQL(Connection.java:2978)
  53.         at com.mysql.jdbc.Connection.execSQL(Connection.java:2902)
  54.         at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:930)
  55.         at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1159)
  56.         at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1076)
  57.         at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1061)
  58.         at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:131)
  59.         at net.sf.l2j.gameserver.model.quest.Quest.deleteQuestInDb(Quest.java:485)
  60.         at net.sf.l2j.gameserver.model.quest.QuestState.exitQuest(QuestState.java:743)
  61.         at sun.reflect.GeneratedMethodAccessor30.invoke(Unknown Source)
  62.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  63.         at java.lang.reflect.Method.invoke(Unknown Source)
  64.         at org.python.core.PyReflectedFunction.__call__(PyReflectedFunction.java:174)
  65.         at org.python.core.PyMethod.__call__(PyMethod.java:93)
  66.         at org.python.core.PyObject.__call__(PyObject.java:592)
  67.         at data.jscript.custom.1006_tattoos$py.onEvent$3(F:Serversl2j2023gameserverdatajscriptcustom1006_tattoos__init__.py:136)
  68.         at data.jscript.custom.1006_tattoos$py.call_function(F:Serversl2j2023gameserverdatajscriptcustom1006_tattoos__init__.py)
  69.         at org.python.core.PyTableCode.call(PyTableCode.java:213)
  70.         at org.python.core.PyTableCode.call(PyTableCode.java:426)
  71.         at org.python.core.PyTableCode.call(PyTableCode.java:322)
  72.         at org.python.core.PyFunction.__call__(PyFunction.java:193)
  73.         at org.python.core.PyMethod.__call__(PyMethod.java:93)
  74.         at org.python.core.PyObject.__call__(PyObject.java:570)
  75.         at org.python.core.PyObject._jcallexc(PyObject.java:2573)
  76.         at org.python.core.PyObject._jcall(PyObject.java:2605)
  77.         at org.python.proxies.data.jscript.custom.1006_tattoos$Quest$152.onEvent(Unknown Source)
  78.         at net.sf.l2j.gameserver.model.quest.Quest.notifyEvent(Quest.java:213)
  79.         at net.sf.l2j.gameserver.model.L2PcInstance.processQuestEvent(L2PcInstance.java:1070)
  80.         at net.sf.l2j.gameserver.clientpackets.RequestBypassToServer.runImpl(RequestBypassToServer.java:212)
  81.         at net.sf.l2j.gameserver.clientpackets.ClientBasePacket.run(ClientBasePacket.java:56)
  82.         at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
  83.         at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
  84.         at java.util.concurrent.FutureTask.run(Unknown Source)
  85.         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source)
  86.         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
  87.         at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
  88.         at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  89.         at java.lang.Thread.run(Unknown Source)
  90. 18.01.2006 16:23:59 net.sf.l2j.gameserver.model.quest.Quest playerEnter
  91. WARNING: could not insert char quest:
  92. java.sql.SQLException: Can't open file: 'character_quests.MYI' (errno: 145)
  93.         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2921)
  94.         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1570)
  95.         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
  96.         at com.mysql.jdbc.Connection.execSQL(Connection.java:2978)
  97.         at com.mysql.jdbc.Connection.execSQL(Connection.java:2902)
  98.         at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:930)
  99.         at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1024)
  100.         at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:102)
  101.         at net.sf.l2j.gameserver.model.quest.Quest.playerEnter(Quest.java:305)
  102.         at net.sf.l2j.gameserver.clientpackets.EnterWorld.runImpl(EnterWorld.java:197)
  103.         at net.sf.l2j.gameserver.clientpackets.ClientBasePacket.run(ClientBasePacket.java:56)
  104.         at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
  105.         at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
  106.         at java.util.concurrent.FutureTask.run(Unknown Source)
  107.         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source)
  108.         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
  109.         at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
  110.         at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  111.         at java.lang.Thread.run(Unknown Source)
  112. 18.01.2006 16:24:00 net.sf.l2j.gameserver.model.PcInventory restoreVisibleInventory
  113. WARNING: could not restore inventory:
  114. java.sql.SQLException: Can't open file: 'items.MYI' (errno: 145)
  115.         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2921)
  116.         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1570)
  117.         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
  118.         at com.mysql.jdbc.Connection.execSQL(Connection.java:2978)
  119.         at com.mysql.jdbc.Connection.execSQL(Connection.java:2902)
  120.         at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:930)
  121.         at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1024)
  122.         at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:102)
  123.         at net.sf.l2j.gameserver.model.PcInventory.restoreVisibleInventory(PcInventory.java:175)
  124.         at net.sf.l2j.gameserver.model.CharSelectInfoPackage.<init>(CharSelectInfoPackage.java:60)
  125.         at net.sf.l2j.gameserver.serverpackets.CharSelectInfo.restoreChar(CharSelectInfo.java:231)
  126.         at net.sf.l2j.gameserver.serverpackets.CharSelectInfo.loadCharacterSelectInfo(CharSelectInfo.java:201)
  127.         at net.sf.l2j.gameserver.serverpackets.CharSelectInfo.<init>(CharSelectInfo.java:58)
  128.         at net.sf.l2j.gameserver.clientpackets.RequestRestart.runImpl(RequestRestart.java:111)
  129.         at net.sf.l2j.gameserver.clientpackets.ClientBasePacket.run(ClientBasePacket.java:56)
  130.         at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
  131.         at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
  132.         at java.util.concurrent.FutureTask.run(Unknown Source)
  133.         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source)
  134.         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
  135.         at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
  136.         at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  137.         at java.lang.Thread.run(Unknown Source)

Обьясните что не так, или Игру криворукий хочет ламануть и вот такая байда вылазит.
В джаве васче не секу.
Server L2j- 1=> http://lineage.cybernet.by Server L2j- 2=> http://game.iptel.by [img]http://total-disconnect.at.tut.by/logoiptel.jpg[/img]  
+
-
edit
 
Проблема с SQL скорее всего. Проверь поверхньсть диска и установи последнюю версию MySQL.
Пытаясь понять рекурсию, следи за тем, чтобы она не поняла тебя первой...  
+
-
edit
 

TD_ALECS

втянувшийся
Ок спасибо сча смотрим, так и есть Мускул всё ломает к чёрту.
Ок, будем разбиратся.
Server L2j- 1=> http://lineage.cybernet.by Server L2j- 2=> http://game.iptel.by [img]http://total-disconnect.at.tut.by/logoiptel.jpg[/img]  
AD Реклама Google — средство выживания форумов :)
+
-
edit
 

EAst26

новичок
А главный сервер и тестовый случем не на одной машине стоят? или используют одну и ту же базу ?

Хотя дело действительно с SQL т.к java.sql.SQLException: Can't open file: 'items.MYI'
Видимо глюканул сам MySQL что помешало открыть яве файл или нехватило одновременных подключений сервера к MySQL но это маловероятно.
 

в начало страницы | новое
 
Поиск
Настройки
Твиттер сайта
Статистика
Рейтинг@Mail.ru