ошибка при запуске ГС

[JFS]

Сборка l2jcore 3.5
появилась собственно спустя месяц работы сервера...в КХ нечего не изменял и не добавлял.Всё загружается нормально и работает,но ошибка волнует


Exception: Auction.initNPC(): Duplicate entry 'ClanHall-47-0' for key 'PRIMARY'
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityCons traintViolationException: Dupl
icate entry 'ClanHall-47-0' for key 'PRIMARY'
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:40 9)
at com.mysql.jdbc.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1041)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3566)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3498)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:19 59)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :2113)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionIm pl.java:2568)
at com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.ja
va:2113)
at com.mysql.jdbc.PreparedStatement.execute(PreparedS tatement.java:1364)

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement .execute(NewProxyPr
eparedStatement.java:989)
at com.l2jcore.Game.database.FiltredPreparedStatement .execute(FiltredPre
paredStatement.java:38)
at com.l2jcore.Game.managers.AuctionManager.initNPC(A uctionManager.java:
222)
at com.l2jcore.Game.model.entity.ClanHall$FeeTask.run (ClanHall.java:754)

at java.util.concurrent.Executors$RunnableAdapter.cal l(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unkn own Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.
access$301(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.
run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(Unknown Source
)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (Unknown Source)
at java.lang.Thread.run(Unknown Source)

Exception: Auction.initNPC(): Duplicate entry 'ClanHall-48-0' for key 'PRIMARY'
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityCons traintViolationException: Dupl
icate entry 'ClanHall-48-0' for key 'PRIMARY'
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:40 9)
at com.mysql.jdbc.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1041)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3566)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3498)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:19 59)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :2113)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionIm pl.java:2568)
at com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.ja
va:2113)
at com.mysql.jdbc.PreparedStatement.execute(PreparedS tatement.java:1364)

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement .execute(NewProxyPr
eparedStatement.java:989)
at com.l2jcore.Game.database.FiltredPreparedStatement .execute(FiltredPre
paredStatement.java:38)
at com.l2jcore.Game.managers.AuctionManager.initNPC(A uctionManager.java:
222)
at com.l2jcore.Game.model.entity.ClanHall$FeeTask.run (ClanHall.java:754)

at java.util.concurrent.Executors$RunnableAdapter.cal l(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unkn own Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.
access$301(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.
run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(Unknown Source
)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (Unknown Source)
at java.lang.Thread.run(Unknown Source)

java.lang.NullPointerException
at com.l2jcore.Game.managers.ClanHallManager.setFree( ClanHallManager.jav
a:175)
at com.l2jcore.Game.model.entity.ClanHall$FeeTask.run (ClanHall.java:755)

at java.util.concurrent.Executors$RunnableAdapter.cal l(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unkn own Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.
access$301(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.
run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(Unknown Source
)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (Unknown Source)
at java.lang.Thread.run(Unknown Source)
java.lang.NullPointerException
at com.l2jcore.Game.managers.ClanHallManager.setFree( ClanHallManager.jav
a:175)
at com.l2jcore.Game.model.entity.ClanHall$FeeTask.run (ClanHall.java:755)

at java.util.concurrent.Executors$RunnableAdapter.cal l(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unkn own Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.
access$301(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.
run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(Unknown Source
)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (Unknown Source)
at java.lang.Thread.run(Unknown Source)

[weTr1k]

log:

Свернуть ↑
Exception: Auction.initNPC(): Duplicate entry 'ClanHall-47-0' for key 'PRIMARY'
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityCons traintViolationException: Dupl
icate entry 'ClanHall-47-0' for key 'PRIMARY'
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:40 9)
at com.mysql.jdbc.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1041)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3566)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3498)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:19 59)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :2113)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionIm pl.java:2568)
at com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.ja
va:2113)
at com.mysql.jdbc.PreparedStatement.execute(PreparedS tatement.java:1364)

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement .execute(NewProxyPr
eparedStatement.java:989)
at com.l2jcore.Game.database.FiltredPreparedStatement .execute(FiltredPre
paredStatement.java:38)
at com.l2jcore.Game.managers.AuctionManager.initNPC(A uctionManager.java:
222)
at com.l2jcore.Game.model.entity.ClanHall$FeeTask.run (ClanHall.java:754)

at java.util.concurrent.Executors$RunnableAdapter.cal l(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unkn own Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.
access$301(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.
run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(Unknown Source
)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (Unknown Source)
at java.lang.Thread.run(Unknown Source)

Exception: Auction.initNPC(): Duplicate entry 'ClanHall-48-0' for key 'PRIMARY'
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityCons traintViolationException: Dupl
icate entry 'ClanHall-48-0' for key 'PRIMARY'
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:40 9)
at com.mysql.jdbc.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1041)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3566)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3498)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:19 59)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :2113)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionIm pl.java:2568)
at com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.ja
va:2113)
at com.mysql.jdbc.PreparedStatement.execute(PreparedS tatement.java:1364)

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement .execute(NewProxyPr
eparedStatement.java:989)
at com.l2jcore.Game.database.FiltredPreparedStatement .execute(FiltredPre
paredStatement.java:38)
at com.l2jcore.Game.managers.AuctionManager.initNPC(A uctionManager.java:
222)
at com.l2jcore.Game.model.entity.ClanHall$FeeTask.run (ClanHall.java:754)

at java.util.concurrent.Executors$RunnableAdapter.cal l(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unkn own Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.
access$301(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.
run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(Unknown Source
)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (Unknown Source)
at java.lang.Thread.run(Unknown Source)

java.lang.NullPointerException
at com.l2jcore.Game.managers.ClanHallManager.setFree( ClanHallManager.jav
a:175)
at com.l2jcore.Game.model.entity.ClanHall$FeeTask.run (ClanHall.java:755)

at java.util.concurrent.Executors$RunnableAdapter.cal l(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unkn own Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.
access$301(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.
run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(Unknown Source
)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (Unknown Source)
at java.lang.Thread.run(Unknown Source)
java.lang.NullPointerException
at com.l2jcore.Game.managers.ClanHallManager.setFree( ClanHallManager.jav
a:175)
at com.l2jcore.Game.model.entity.ClanHall$FeeTask.run (ClanHall.java:755)

at java.util.concurrent.Executors$RunnableAdapter.cal l(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unkn own Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.
access$301(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.
run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(Unknown Source
)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (Unknown Source)
at java.lang.Thread.run(Unknown Source)

Свернуть ↑Развернуть ↓

[JFS]

Client [Character: Joja - Account: wpinzestw - IP: 188.18.202.7] disconnected ab
normally.
Client [Character: Setus - Account: plakso6 - IP: 93.75.42.142] disconnected abn
ormally.
Client [Character: DarkMaster - Account: vanbojko - IP: 95.132.174.112] disconne
cted abnormally.
Client [Character: oOProEvilOo - Account: bloodka - IP: 178.93.101.161] disconne
cted abnormally.
Client [Character: Worla4ka - Account: plakso4 - IP: 93.75.42.142] disconnected
abnormally.
OMG WRITE BUT NO WRITE
Client [Character: Allex - Account: lolik812 - IP: 188.163.20.230] disconnected
abnormally.
Client [Account: oxymoron - IP: 88.135.247.4] disconnected abnormally.
Client [Character: IIapTu3aH - Account: dramani - IP: 213.138.70.38] disconnecte
d abnormally.
Client [Character: LordOfDeath - Account: nazar007 - IP: 212.1.94.186] disconnec
ted abnormally.
Client [Character: 6yxapb - Account: clan1997shurik - IP: 91.195.3.253] disconne
cted abnormally.
Character BACAA disconnection (double add to list request), oid: 268500655
Olympiad System: Data updated successfully.
java.lang.NullPointerException

А эта ошибка может быть вызванна из за плохого жесткого диска?

[ANZO]

В таблице auction у вас два разных аукциона с праймари кей id равным 47. Удалите один из них, если их содержимое индентично. Сервер выставил один и тот же аукцион два раз на торги видимо.

[JFS]

да, проблема была в кх, только не с одинаковым ID, а просто КХ забрался за неуплату и был выставлен повторно на аукцион, а в базе - осталось ID кланов владельцев.

Посмотрите мой предыдущий пост, в чём может быть проблема в данной ошибке?

[ANZO]

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

да, проблема была в кх, только не с одинаковым ID, а просто КХ забрался за неуплату и был выставлен повторно на аукцион, а в базе - осталось ID кланов владельцев.

Посмотрите мой предыдущий пост, в чём может быть проблема в данной ошибке?

Как понимаю логин сервер ложится, а серв продолжает после этого работать? Какая операционка стоит на сервере? и как часто наблюдаются такого рода вылеты?

[JFS]

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

Как понимаю логин сервер ложится, а серв продолжает после этого работать? Какая операционка стоит на сервере? и как часто наблюдаются такого рода вылеты?

Нет,просто виснет ГС,минуты на 2-3,потом разлагует,но при этом возможно когото выкидавает...

В частности просто лаг на 2-3 минуты,потом такая ошибка и всё,продолжает дальше работать. Проблема бывает раз - два на день.