Ошибки ГС и ЛАГ

~~lolpwnz~~ · 14.08.2011, 20:17

Что за ошибка я так и не понял? и как исправить их?
и сервер почему-то лагает при онлайне 10.

REM Non Heap memory
set JAVA_OPTS=%JAVA_OPTS% -XX:PermSize=256m
set JAVA_OPTS=%JAVA_OPTS% -XX:MaxPermSize=512m

REM Set heap min/max to same size for consistent results
set JAVA_OPTS=%JAVA_OPTS% -Xms2048m
set JAVA_OPTS=%JAVA_OPTS% -Xmx2048m

Код HTML:

e)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
        at java.lang.reflect.Constructor.newInstance(Unknown Source)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
        at com.mysql.jdbc.Util.getInstance(Util.java:382)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
        at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1476)
        at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingSt
atement.java:208)
        at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingSt
atement.java:208)
        at l2n.database.FiltredStatement.executeQuery(Unknown Source)
        at l2n.game.A.A.M.M(Unknown Source)
        at l2n.game.A.A.M.C(Unknown Source)
        at l2n.game.A.A.M.C(Unknown Source)
        at l2n.game.A.A.M.B(Unknown Source)
        at l2n.game.A.A.A(Unknown Source)
        at l2n.game.network.clientpackets.RequestBypassToServer.runImpl(Unknown
Source)
        at l2n.game.network.clientpackets.L2GameClientPacket.run(Unknown Source)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.
java:1081)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
.java:574)
        at java.lang.Thread.run(Unknown Source)
19:18:00.585  couldnt load mail for AmeriCano
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'obj_i
d' in 'where clause'
        at sun.reflect.GeneratedConstructorAccessor181.newInstance(Unknown Sourc
e)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
        at java.lang.reflect.Constructor.newInstance(Unknown Source)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
        at com.mysql.jdbc.Util.getInstance(Util.java:382)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
        at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1476)
        at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingSt
atement.java:208)
        at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingSt
atement.java:208)
        at l2n.database.FiltredStatement.executeQuery(Unknown Source)
        at l2n.game.A.A.M.M(Unknown Source)
        at l2n.game.A.A.M.C(Unknown Source)
        at l2n.game.A.A.M.C(Unknown Source)
        at l2n.game.A.A.M.B(Unknown Source)
        at l2n.game.A.A.A(Unknown Source)
        at l2n.game.network.clientpackets.RequestBypassToServer.runImpl(Unknown
Source)
        at l2n.game.network.clientpackets.L2GameClientPacket.run(Unknown Source)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.
java:1081)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
.java:574)
        at java.lang.Thread.run(Unknown Source)
19:18:00.588  couldnt load mail for AmeriCano
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'obj_i
d' in 'where clause'
        at sun.reflect.GeneratedConstructorAccessor181.newInstance(Unknown Sourc
e)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
        at java.lang.reflect.Constructor.newInstance(Unknown Source)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
        at com.mysql.jdbc.Util.getInstance(Util.java:382)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
        at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1476)
        at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingSt
atement.java:208)
        at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingSt
atement.java:208)
        at l2n.database.FiltredStatement.executeQuery(Unknown Source)
        at l2n.game.A.A.M.M(Unknown Source)
        at l2n.game.A.A.M.C(Unknown Source)
        at l2n.game.A.A.M.C(Unknown Source)
        at l2n.game.A.A.M.B(Unknown Source)
        at l2n.game.A.A.A(Unknown Source)
        at l2n.game.network.clientpackets.RequestBypassToServer.runImpl(Unknown
Source)
        at l2n.game.network.clientpackets.L2GameClientPacket.run(Unknown Source)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.
java:1081)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
.java:574)
        at java.lang.Thread.run(Unknown Source)
19:18:31.821  couldnt load mail for AmeriCano
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'obj_i
d' in 'where clause'
        at sun.reflect.GeneratedConstructorAccessor181.newInstance(Unknown Sourc
e)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
        at java.lang.reflect.Constructor.newInstance(Unknown Source)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
        at com.mysql.jdbc.Util.getInstance(Util.java:382)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
        at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1476)
        at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingSt
atement.java:208)
        at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingSt
atement.java:208)
        at l2n.database.FiltredStatement.executeQuery(Unknown Source)
        at l2n.game.A.A.M.M(Unknown Source)
        at l2n.game.A.A.M.C(Unknown Source)
        at l2n.game.A.A.M.C(Unknown Source)
        at l2n.game.A.A.M.B(Unknown Source)
        at l2n.game.A.A.A(Unknown Source)
        at l2n.game.network.clientpackets.RequestBypassToServer.runImpl(Unknown
Source)
        at l2n.game.network.clientpackets.L2GameClientPacket.run(Unknown Source)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.
java:1081)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
.java:574)
        at java.lang.Thread.run(Unknown Source)
19:18:31.824  couldnt load mail for AmeriCano
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'obj_i
d' in 'where clause'
        at sun.reflect.GeneratedConstructorAccessor181.newInstance(Unknown Sourc
e)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
        at java.lang.reflect.Constructor.newInstance(Unknown Source)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
        at com.mysql.jdbc.Util.getInstance(Util.java:382)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
        at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1476)
        at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingSt
atement.java:208)
        at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingSt
atement.java:208)
        at l2n.database.FiltredStatement.executeQuery(Unknown Source)
        at l2n.game.A.A.M.M(Unknown Source)
        at l2n.game.A.A.M.C(Unknown Source)
        at l2n.game.A.A.M.C(Unknown Source)
        at l2n.game.A.A.M.B(Unknown Source)
        at l2n.game.A.A.A(Unknown Source)
        at l2n.game.network.clientpackets.RequestBypassToServer.runImpl(Unknown
Source)
        at l2n.game.network.clientpackets.L2GameClientPacket.run(Unknown Source)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.
java:1081)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
.java:574)
        at java.lang.Thread.run(Unknown Source)
19:18:31.827  couldnt load mail for AmeriCano
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'obj_i
d' in 'where clause'
        at sun.reflect.GeneratedConstructorAccessor181.newInstance(Unknown Sourc
e)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
        at java.lang.reflect.Constructor.newInstance(Unknown Source)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
        at com.mysql.jdbc.Util.getInstance(Util.java:382)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
        at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1476)
        at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingSt
atement.java:208)
        at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingSt
atement.java:208)
        at l2n.database.FiltredStatement.executeQuery(Unknown Source)
        at l2n.game.A.A.M.M(Unknown Source)
        at l2n.game.A.A.M.C(Unknown Source)
        at l2n.game.A.A.M.C(Unknown Source)
        at l2n.game.A.A.M.B(Unknown Source)
        at l2n.game.A.A.A(Unknown Source)
        at l2n.game.network.clientpackets.RequestBypassToServer.runImpl(Unknown
Source)
        at l2n.game.network.clientpackets.L2GameClientPacket.run(Unknown Source)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.
java:1081)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
.java:574)
        at java.lang.Thread.run(Unknown Source)
19:18:31.829  couldnt load mail for AmeriCano
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'obj_i
d' in 'where clause'
        at sun.reflect.GeneratedConstructorAccessor181.newInstance(Unknown Sourc
e)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
        at java.lang.reflect.Constructor.newInstance(Unknown Source)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
        at com.mysql.jdbc.Util.getInstance(Util.java:382)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
        at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1476)
        at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingSt
atement.java:208)
        at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingSt
atement.java:208)
        at l2n.database.FiltredStatement.executeQuery(Unknown Source)
        at l2n.game.A.A.M.M(Unknown Source)
        at l2n.game.A.A.M.C(Unknown Source)
        at l2n.game.A.A.M.C(Unknown Source)
        at l2n.game.A.A.M.B(Unknown Source)
        at l2n.game.A.A.A(Unknown Source)
        at l2n.game.network.clientpackets.RequestBypassToServer.runImpl(Unknown
Source)
        at l2n.game.network.clientpackets.L2GameClientPacket.run(Unknown Source)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.
java:1081)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
.java:574)
        at java.lang.Thread.run(Unknown Source)
19:18:31.832  couldnt load mail for AmeriCano
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'obj_i
d' in 'where clause'
        at sun.reflect.GeneratedConstructorAccessor181.newInstance(Unknown Sourc
e)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
        at java.lang.reflect.Constructor.newInstance(Unknown Source)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
        at com.mysql.jdbc.Util.getInstance(Util.java:382)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
        at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1476)
        at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingSt
atement.java:208)
        at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingSt
atement.java:208)
        at l2n.database.FiltredStatement.executeQuery(Unknown Source)
        at l2n.game.A.A.M.M(Unknown Source)
        at l2n.game.A.A.M.C(Unknown Source)
        at l2n.game.A.A.M.C(Unknown Source)
        at l2n.game.A.A.M.B(Unknown Source)
        at l2n.game.A.A.A(Unknown Source)
        at l2n.game.network.clientpackets.RequestBypassToServer.runImpl(Unknown
Source)
        at l2n.game.network.clientpackets.L2GameClientPacket.run(Unknown Source)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.
java:1081)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
.java:574)
        at java.lang.Thread.run(Unknown Source)
19:22:31.397  TvT: next start event will be at 14.08.2011 22:00:31
19:50:48.769  FourSepulchersManager: Entry time: 19:55:48
20:00:59.369  Manor System: Under maintenance mode started
20:06:59.347  Manor System: Next period started
20:34:45.728  Character (UnknownPerson) has dropped (500000000) Adena 43787,-477
49,-823,0
20:50:48.568  FourSepulchersManager: Entry time: 20:55:48

***NotSpecified*** · 14.08.2011, 20:25

Код:

Unknown column 'obj_id' in 'where clause'

Ничего не говорит?

~~lolpwnz~~ · 15.08.2011, 09:49

Цитата:

Сообщение от NotSpecified

Код:

Unknown column 'obj_id' in 'where clause'

Ничего не говорит?

obj_id таблицы не хватает ? если да то на каком файле?

***gorodetskiy*** · 15.08.2011, 10:28

Цитата:

Сообщение от lolpwnz

obj_id таблицы не хватает ? если да то на каком файле?

http://translate.google.com/#en|ru|U...re%20clause%27

~~lolpwnz~~ · 15.08.2011, 11:26

спасибо)

А насчет лаг что скажете ?

Azagthtot · 15.08.2011, 11:31

По поводу "лагает" - ищите "узкое" место.
Им может быть:
- работа с БД (слишком много запросов + не оптимальная стратегия хранения данных)
- сеть (слишком много пакетов пытается "пролезть" в узкий канал)
- настройки потоков (нет свободных Executor-ов для обработки задач)

~~lolpwnz~~ · 15.08.2011, 13:51

всё равно выходит ошибка Unknown column 'obj_id' in 'where clause'
как избавиться помогите пожалуйста

14.08.2011, 20:25	#2
*NotSpecified* Олдфаг Регистрация: 30.01.2011 Адрес: Europe Сообщений: 2,800 Отблагодарили 1,263 раз(а) Рейтинг мнений: 46	Re: Ошибки ГС и ЛАГ Код: Unknown column 'obj_id' in 'where clause' Ничего не говорит?

15.08.2011, 11:26	#5
~~lolpwnz~~ Изгнанные Регистрация: 01.09.2010 Сообщений: 392 Отблагодарили 8 раз(а) Рейтинг мнений:	Re: Ошибки ГС и ЛАГ спасибо) А насчет лаг что скажете ?

15.08.2011, 11:31	#6
Azagthtot Эксперт Регистрация: 21.04.2010 Возраст: 52 Сообщений: 1,324 Отблагодарили 931 раз(а) Рейтинг мнений:	Re: Ошибки ГС и ЛАГ По поводу "лагает" - ищите "узкое" место. Им может быть: - работа с БД (слишком много запросов + не оптимальная стратегия хранения данных) - сеть (слишком много пакетов пытается "пролезть" в узкий канал) - настройки потоков (нет свободных Executor-ов для обработки задач)

15.08.2011, 13:51	#7
~~lolpwnz~~ Изгнанные Регистрация: 01.09.2010 Сообщений: 392 Отблагодарили 8 раз(а) Рейтинг мнений:	Re: Ошибки ГС и ЛАГ всё равно выходит ошибка Unknown column 'obj_id' in 'where clause' как избавиться помогите пожалуйста

Похожие темы
Тема	Автор	Раздел	Ответов	Последнее сообщение
Ошибки ГС	SWnet	Lineage II	2	07.04.2011 22:55
Ошибки в сборках	aspalt	Серверная часть	59	23.06.2010 14:59
Ошибки ГС	Machine	Lineage II	0	21.05.2010 00:11
Ошибки	energy	Lineage II	4	07.08.2009 15:22
Ошибки ГС'a	lifepark	Lineage II	3	29.01.2009 13:28

Здесь присутствуют: 1 (пользователей: 0 , гостей: 1)