Форум администраторов игровых серверов

- Lineage II (https://forum.zone-game.info/forumdisplay.php?f=34)

- - 2 Ошибки GS (https://forum.zone-game.info/showthread.php?t=28620)

2 Ошибки GS

Люди добрые,помогите разобраться с данными ошибками.
В чем может быть проблема?
1-Тут кажется что то с таблицами db

Код:

F:\Server\game\data\scripts\other\9011_KamalokaAch\__init__.py

Traceback (innermost last):

  (no code object) at line 0

        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)



        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)



        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou

rce)

        at java.lang.reflect.Constructor.newInstance(Unknown Source)

        at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

        at com.mysql.jdbc.Util.getInstance(Util.java:386)

        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)

        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)

        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)

        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624)

        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja

va:2127)

        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java

:2427)

        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java

:2345)

        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java

:2330)

        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewP

roxyPreparedStatement.java:105)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

        at java.lang.reflect.Method.invoke(Unknown Source)



com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: com.mysql.jdbc.except

ions.jdbc4.MySQLSyntaxErrorException: Table '123.kamaloka_results' doesn't exist





        at org.python.core.Py.JavaError(Unknown Source)

        at org.python.core.PyObject._jthrow(Unknown Source)

        at org.python.core.PyObject._jcall(Unknown Source)

        at org.python.proxies.main$Quest$14.onAdvEvent(Unknown Source)

        at l2.brick.gameserver.model.quest.Quest.notifyEvent(Quest.java:468)

        at l2.brick.gameserver.model.quest.QuestTimer$ScheduleTimerTask.run(Ques

tTimer.java:43)

        at l2.brick.gameserver.ThreadPoolManager$RunnableWrapper.run(ThreadPoolM

anager.java:86)

        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

        at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

        at java.util.concurrent.FutureTask.run(Unknown Source)

        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.

access$201(Unknown Source)

        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.

run(Unknown Source)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

        at java.lang.Thread.run(Unknown Source)



Traceback (innermost last):

  (no code object) at line 0

        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)



        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)



        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou

rce)

        at java.lang.reflect.Constructor.newInstance(Unknown Source)

        at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

        at com.mysql.jdbc.Util.getInstance(Util.java:386)

        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)

        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)

        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)

        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624)

        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja

va:2127)

        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java

:2427)

        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java

:2345)

        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java

:2330)

        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewP

roxyPreparedStatement.java:105)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

        at java.lang.reflect.Method.invoke(Unknown Source)



com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: com.mysql.jdbc.except

ions.jdbc4.MySQLSyntaxErrorException: Table '123.kamaloka_results' doesn't exist

Код:

Unclosed connection! Trace: sun.reflect.NativeMethodAccessorImpl.invoke0(Native

Method)

java.lang.RuntimeException

        at l2.brick.L2DatabaseFactory.getConnection(L2DatabaseFactory.java:218)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

        at java.lang.reflect.Method.invoke(Unknown Source)

        at org.python.core.PyReflectedFunction.__call__(Unknown Source)

        at org.python.core.PyMethod.__call__(Unknown Source)

        at org.python.core.PyObject.__call__(Unknown Source)

        at org.python.core.PyInstance.invoke(Unknown Source)

        at org.python.pycode.serializable._pyx1367749173109.onAdvEvent$3(__init_

_.py:29)

        at org.python.pycode.serializable._pyx1367749173109.call_function(__init

__.py)

        at org.python.core.PyTableCode.call(Unknown Source)

        at org.python.core.PyTableCode.call(Unknown Source)

        at org.python.core.PyTableCode.call(Unknown Source)

        at org.python.core.PyFunction.__call__(Unknown Source)

        at org.python.core.PyMethod.__call__(Unknown Source)

        at org.python.core.PyObject.__call__(Unknown Source)

        at org.python.core.PyObject._jcallexc(Unknown Source)

        at org.python.core.PyObject._jcall(Unknown Source)

        at org.python.proxies.main$Quest$14.onAdvEvent(Unknown Source)

        at l2.brick.gameserver.model.quest.Quest.notifyEvent(Quest.java:468)

        at l2.brick.gameserver.model.quest.QuestTimer$ScheduleTimerTask.run(Ques

tTimer.java:43)

        at l2.brick.gameserver.ThreadPoolManager$RunnableWrapper.run(ThreadPoolM

anager.java:86)

        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

        at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

        at java.util.concurrent.FutureTask.run(Unknown Source)

        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.

access$201(Unknown Source)

        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.

run(Unknown Source)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

        at java.lang.Thread.run(Unknown Source)

Re: 2 Ошибки GS

Цитата:

Сообщение от gorodetskiy (Сообщение 296397)

http://www.ibm.com/developerworks/ru...python_part_1/
http://www.google.ru/webhp?hl=ru&tab...iw=896&bih=463

_.py:29)

Можно по подробнее,у меня нет эдакаво навыка что б понять с пол пинка о чем идет речь:)

Re: 2 Ошибки GS

я тоже не могу угадать что во второй вырезке кода, но видно что указывает на 29 строку.

Откуда скрипт скачали, я не знаю, работает ли он вообще - тоже не известно.
Нужно больше информации

Re: 2 Ошибки GS

Щас гляну
А в 1 в чем дело обстоит ?

Re: 2 Ошибки GS

Вы научитесь отвечать на вопросы, а не отвечать вопросом на вопрос.
Я приводил 2 ссылки, могли бы открыть и прочитать хотя бы.
Начнём с самого начала, то что сборка л2брик понятно уже
Когда появилась ошибка ?
Покажите полный лог а не огрызки
http://www.google.ru/search?ie=UTF-8...0at%20line%200 почитайте

Re: 2 Ошибки GS

Цитата:

Сообщение от gorodetskiy (Сообщение 296407)

Я ваши ссылки читал и не раз.
Появилась,как запустил саму сборку.

1.Вот полный лог Камолоки

Код:

Handlers Loaded...

Handy's Block Checker Event is enabled

F:\Server\game\data\scripts\other\9011_KamalokaAch\__init__.py

Traceback (innermost last):

  (no code object) at line 0

        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)



        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)



        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou

rce)

        at java.lang.reflect.Constructor.newInstance(Unknown Source)

        at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

        at com.mysql.jdbc.Util.getInstance(Util.java:386)

        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)

        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)

        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)

        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624)

        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja

va:2127)

        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java

:2427)

        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java

:2345)

        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java

:2330)

        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewP

roxyPreparedStatement.java:105)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

        at java.lang.reflect.Method.invoke(Unknown Source)



com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: com.mysql.jdbc.except

ions.jdbc4.MySQLSyntaxErrorException: Table '123.kamaloka_results' doesn't exist





        at org.python.core.Py.JavaError(Unknown Source)

        at org.python.core.PyObject._jthrow(Unknown Source)

        at org.python.core.PyObject._jcall(Unknown Source)

        at org.python.proxies.main$Quest$14.onAdvEvent(Unknown Source)

        at l2.brick.gameserver.model.quest.Quest.notifyEvent(Quest.java:468)

        at l2.brick.gameserver.model.quest.QuestTimer$ScheduleTimerTask.run(Ques

tTimer.java:43)

        at l2.brick.gameserver.ThreadPoolManager$RunnableWrapper.run(ThreadPoolM

anager.java:86)

        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

        at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

        at java.util.concurrent.FutureTask.run(Unknown Source)

        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.

access$201(Unknown Source)

        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.

run(Unknown Source)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

        at java.lang.Thread.run(Unknown Source)



Traceback (innermost last):

  (no code object) at line 0

        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)



        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)



        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou

rce)

        at java.lang.reflect.Constructor.newInstance(Unknown Source)

        at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

        at com.mysql.jdbc.Util.getInstance(Util.java:386)

        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)

        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)

        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)

        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624)

        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja

va:2127)

        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java

:2427)

        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java

:2345)

        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java

:2330)

        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewP

roxyPreparedStatement.java:105)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

        at java.lang.reflect.Method.invoke(Unknown Source)



com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: com.mysql.jdbc.except

ions.jdbc4.MySQLSyntaxErrorException: Table '123.kamaloka_results' doesn't exist

2.А вторая ошибка появляется после полного включения сервера

Код:

Connecting to login on 127.0.0.1:9014

CommunityServerThread: Deactivated by config.

Maximum Numbers of Connected Players: 1000

Server Loaded in 135 seconds

AutoAnnoucements: Loaded 0 Auto Annoucement Data.

Telnet StatusServer started successfully, listening on Port: 12345

Registered on login as Server 2 : Sieghardt

Unclosed connection! Trace: sun.reflect.NativeMethodAccessorImpl.invoke0(Native

Method)

java.lang.RuntimeException

        at l2.brick.L2DatabaseFactory.getConnection(L2DatabaseFactory.java:218)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

        at java.lang.reflect.Method.invoke(Unknown Source)

        at org.python.core.PyReflectedFunction.__call__(Unknown Source)

        at org.python.core.PyMethod.__call__(Unknown Source)

        at org.python.core.PyObject.__call__(Unknown Source)

        at org.python.core.PyInstance.invoke(Unknown Source)

        at org.python.pycode.serializable._pyx1367755685668.onAdvEvent$3(__init_

_.py:29)

        at org.python.pycode.serializable._pyx1367755685668.call_function(__init

__.py)

        at org.python.core.PyTableCode.call(Unknown Source)

        at org.python.core.PyTableCode.call(Unknown Source)

        at org.python.core.PyTableCode.call(Unknown Source)

        at org.python.core.PyFunction.__call__(Unknown Source)

        at org.python.core.PyMethod.__call__(Unknown Source)

        at org.python.core.PyObject.__call__(Unknown Source)

        at org.python.core.PyObject._jcallexc(Unknown Source)

        at org.python.core.PyObject._jcall(Unknown Source)

        at org.python.proxies.main$Quest$14.onAdvEvent(Unknown Source)

        at l2.brick.gameserver.model.quest.Quest.notifyEvent(Quest.java:468)

        at l2.brick.gameserver.model.quest.QuestTimer$ScheduleTimerTask.run(Ques

tTimer.java:43)

        at l2.brick.gameserver.ThreadPoolManager$RunnableWrapper.run(ThreadPoolM

anager.java:86)

        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

        at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

        at java.util.concurrent.FutureTask.run(Unknown Source)

        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.

access$201(Unknown Source)

        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.

run(Unknown Source)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

        at java.lang.Thread.run(Unknown Source)

Re: 2 Ошибки GS

ions.jdbc4.MySQLSyntaxErrorException: Table '123.kamaloka_results' doesn't exist

http://forum.zone-game.info/showthread.php?t=22376 - похожая тема

Re: 2 Ошибки GS

1. Table '123.kamaloka_results' doesn't exist. с английским то не все так плохо?
2. скрипт нашел "незакрытый" коннект к бд, после его использования. проверьте

Re: 2 Ошибки GS

Спасибо разобрался вот теперь другая проблемка
http://forum.zone-game.info/showthre...167#post297167