Skip to content

Game Server New Error

Featured Replies

Greetings friends MXC

I come to you to bring a new problem.

My server made automatic restart, but after the restart it does not get online.

I get the following error in Game Server.

 

BitSet ID Factory could not be initialized correctly

com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for colu

mn 'object_id' at row 85099

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

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

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

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

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

       at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1564)

       at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1485)

       at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStat

ement.java:64)

       at net.sf.l2j.gameserver.idfactory.IdFactory.extractUsedObjectIDTable(Id

Factory.java:198)

       at net.sf.l2j.gameserver.idfactory.BitSetIDFactory.initialize(BitSetIDFa

ctory.java:76)

       at net.sf.l2j.gameserver.idfactory.BitSetIDFactory.<init>(BitSetIDFactor

y.java:65)

       at net.sf.l2j.gameserver.idfactory.IdFactory.<clinit>(IdFactory.java:68)

 

       at net.sf.l2j.gameserver.GameServer.<init>(GameServer.java:180)

       at net.sf.l2j.gameserver.GameServer.main(GameServer.java:563)

IDFactory: 102912 id's available.

=====================================================================-[ World ]

L2World: Setting up World Regions

L2World: (87 by 128) World Region Grid set up.

Initializing Script Engine Manager

Script Engine: jython 2.2.1 - Language: python - Language Version: 2.2.1

Script Engine: Mozilla Rhino 1.6 release 2 - Language: ECMAScript - Language Ver

sion: 1.6

Script Engine: java 1.6 - Language: java - Language Version: 1.6

Script Engine: BeanShell Engine 1.1 - Language: BeanShell - Language Version: 2.

0b5

================================================================-[ ID Factory ]

Could not read object IDs from DB. Please Check Your Data.

Exception in thread "main" java.lang.Exception: Could not initialize the ID fact

ory

       at net.sf.l2j.gameserver.GameServer.<init>(GameServer.java:195)

       at net.sf.l2j.gameserver.GameServer.main(GameServer.java:563)

 

Out of range value for colu

 

It should be self explanatory.

  • Author

85099 already deleted the line ...

After he asks for 85098 ... 85097 ... 85096 ... until arriving at line 1

And the error continues.

 

Your SQLs are corrupted/focked up.

 

There is no table name cited, so I can't really be usefull.

 

Try to search tables "with object_id" column.

 

Basically, "items" table can be the problem (well I won't be surprised it comes from it).

 

 

Design your table and post a screen, or correct if you know what to correct.

 

----

 

As the error is too much generic, and doesn't come on the sql load but before, it can comes from IDFactory itself.

This is the only table using this column name ?

 

Search for others, it seems it's not related to items.

 

And as I said your problem is perhaps more boring. It can comes from IdFactory or even BitSet.

 

-----

 

Btw row 85099... What is it supposed to be ? What table did you tried to remove those lines ?

 

And after removing all (do a backup of it), does the error continue on another table ?

 

If yes, you're really in bad position. Consider ask help to the dev team which support your project or change of project.

  • Author

The error is related to Characters table .

but do not know how to solve it.

Deleted all the characters of the table "characters" and the error disappeared ..

but is not a viable solution.

anyone have any suggestions?

Create an account or sign in to comment

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.