Форум администраторов игровых серверов › MMO › Lineage II v
Ошибки ГС и ЛАГ

Рейтинг темы:
  • 0 Голос(ов) - 0 в среднем
  • 1
  • 2
  • 3
  • 4
  • 5
Каскадный режим
Ошибки ГС и ЛАГ
lolpwnz Не в сети
Banned
Сообщений: 392
Тем: 114
Зарегистрирован: Sep 2010
#1
08-14-2011, 08:17 PM
Что за ошибка я так и не понял? и как исправить их?
и сервер почему-то лагает при онлайне 10.

REM Non Heap memory
set JAVA_OPTS=%JAVA_OPTS% -XXTongueermSize=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






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 Не в сети
Posting Freak
*****
Сообщений: 2,800
Тем: 28
Зарегистрирован: Jan 2011
Репутация: 10,639
#2
08-14-2011, 08:25 PM
Код:
Unknown column 'obj_id' in 'where clause'

Ничего не говорит?
Вебсайт Поиск
Ответ
lolpwnz Не в сети
Banned
Сообщений: 392
Тем: 114
Зарегистрирован: Sep 2010
#3
08-15-2011, 09:49 AM
NotSpecified Написал:
Код:
Unknown column 'obj_id' in 'where clause'

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

obj_id таблицы не хватает ? если да то на каком файле?
Поиск
Ответ
gorodetskiy Не в сети
Posting Freak
*****
Сообщений: 2,444
Тем: 59
Зарегистрирован: May 2010
Репутация: 13,020
#4
08-15-2011, 10:28 AM
lolpwnz Написал:obj_id таблицы не хватает ? если да то на каком файле?

http://translate.google.com/#en|ru|Unkno...0clause%27
СЕО Оптимизация сайтов
Поиск
Ответ
lolpwnz Не в сети
Banned
Сообщений: 392
Тем: 114
Зарегистрирован: Sep 2010
#5
08-15-2011, 11:26 AM
спасибо)

А насчет лаг что скажете ?
Поиск
Ответ
Azagthtot Не в сети
Posting Freak
*****
Сообщений: 1,326
Тем: 10
Зарегистрирован: Apr 2010
Репутация: 2,078
#6
08-15-2011, 11:31 AM
По поводу "лагает" - ищите "узкое" место.
Им может быть:
- работа с БД (слишком много запросов + не оптимальная стратегия хранения данных)
- сеть (слишком много пакетов пытается "пролезть" в узкий канал)
- настройки потоков (нет свободных Executor-ов для обработки задач)
Вебсайт Поиск
Ответ
lolpwnz Не в сети
Banned
Сообщений: 392
Тем: 114
Зарегистрирован: Sep 2010
#7
08-15-2011, 01:51 PM
всё равно выходит ошибка Unknown column 'obj_id' in 'where clause'
как избавиться помогите пожалуйста
Поиск
Ответ


Возможно похожие темы ...
Тема Автор Ответы Просмотры Последний пост
  Ошибки при исправлении через Diff sullen.nv 1 1,428 06-18-2018, 03:06 PM
Последний пост: 4ipolino
  Ошибки ЛС иГС Гп2 1553 Ему TFH 2 1,639 08-08-2017, 08:26 PM
Последний пост: TFH
  Ошибки при создании персонажа Zanoza 4 2,631 07-01-2016, 04:58 PM
Последний пост: Zanoza
  Ошибки при запуске сервера L2C4 smurfik 11 4,102 01-19-2016, 02:12 PM
Последний пост: smurfik
  Ошибки в GameServer Kennedy 1 2,146 10-21-2015, 06:43 PM
Последний пост: shegan
  Ошибки виртуальной машины SoniPro 0 1,501 08-20-2015, 11:47 AM
Последний пост: SoniPro
  Ошибки при компиляции исходников Lindvior sullen.nv 6 3,340 01-22-2014, 10:20 PM
Последний пост: WoWan-SM
  Ошибки и Инвентарем и Скилами. kekeIIIka 0 956 01-18-2014, 10:24 PM
Последний пост: kekeIIIka
  Фул Ошибки в гс Литион 6 2,315 11-09-2013, 11:23 PM
Последний пост: Литион
  ошибки Beast PVP TosyBosy 0 1,078 09-21-2013, 04:52 PM
Последний пост: TosyBosy

Перейти к форуму:


Пользователи, просматривающие эту тему: 1 Гость(ей)