L2J Server

L2J Server Discussion Board
https://l2jserver.com/forum/

Duplicate entry & Account already in use

https://l2jserver.com/forum/viewtopic.php?t=18812

Page 1 of 2

Duplicate entry & Account already in use

Posted: Tue Sep 21, 2010 1:23 pm
by achilless
If you want to receive support we need this info to help you properly.
ยป Find Revision
L2J Revision Number:
L2JDP Revision Number:

the day a player can not enter the game - Account already in use
in the login server logs all-clear
logfiles game server encountered an error
I think this is a mistake and what the player does not let the game - connected
as viewed within 3 days

Error could not store char skills: Duplicate entry '268798029-194-0' for key 'PRIMARY'
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '268798029-194-0' for key 'PRIMARY'
at sun.reflect.GeneratedConstructorAccessor94.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1960)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1367)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:989)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.storeSkill(L2PcInstance.java:8060)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.addSkill(L2PcInstance.java:7938)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.giveAvailableSkills(L2PcInstance.java:3002)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.rewardSkills(L2PcInstance.java:2915)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.setClassId(L2PcInstance.java:2690)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.restore(L2PcInstance.java:7348)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.load(L2PcInstance.java:1195)
at com.l2jserver.gameserver.network.L2GameClient.loadCharFromDisk(L2GameClient.java:507)
at com.l2jserver.gameserver.network.clientpackets.CharacterSelect.runImpl(CharacterSelect.java:87)
at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:93)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:636)

Error could not store char skills: Duplicate entry '268798029-226-0' for key 'PRIMARY'
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '268798029-226-0' for key 'PRIMARY'
at sun.reflect.GeneratedConstructorAccessor94.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1960)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1367)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:989)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.storeSkill(L2PcInstance.java:8060)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.addSkill(L2PcInstance.java:7938)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.giveAvailableSkills(L2PcInstance.java:3002)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.rewardSkills(L2PcInstance.java:2915)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.setClassId(L2PcInstance.java:2690)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.restore(L2PcInstance.java:7348)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.load(L2PcInstance.java:1195)
at com.l2jserver.gameserver.network.L2GameClient.loadCharFromDisk(L2GameClient.java:507)
at com.l2jserver.gameserver.network.clientpackets.CharacterSelect.runImpl(CharacterSelect.java:87)
at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:93)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:636)

Re: Duplicate entry & Account already in use

Posted: Tue Sep 21, 2010 1:38 pm
by Naonah
lol :D

remove one of this in DB and it will not be duplicate :)

Re: Duplicate entry & Account already in use

Posted: Tue Sep 21, 2010 6:23 pm
by achilless
Naonah wrote:lol :D

remove one of this in DB and it will not be duplicate :)

and what to delete?

charId skill_id skill_level class_index
268798029 226 1 0
268798029 226 1 1

Re: Duplicate entry & Account already in use

Posted: Tue Sep 21, 2010 8:00 pm
by Naonah
achilless wrote: charId skill_id skill_level class_index
268798029 226 1 0
268798029 226 1 1
Whatever you want :mrgreen: You will not delete a char but only a skill.

Re: Duplicate entry & Account already in use

Posted: Tue Sep 21, 2010 8:06 pm
by achilless
Naonah wrote:
achilless wrote: charId skill_id skill_level class_index
268798029 226 1 0
268798029 226 1 1
Whatever you want :mrgreen: You will not delete a char but only a skill.
You said - remove
I asked - what is the line to remove

Now you are pretending to blunt fool!

Re: Duplicate entry & Account already in use

Posted: Tue Sep 21, 2010 8:08 pm
by jurchiks
just delete those lines for fuck sake!

Re: Duplicate entry & Account already in use

Posted: Tue Sep 21, 2010 10:19 pm
by Naonah
jurchiks wrote:just delete those lines for fuck sake!
:mrgreen:

Re: Duplicate entry & Account already in use

Posted: Tue Sep 21, 2010 11:08 pm
by K4N4BS
The same happen with me...
But players are still able to connect...

Re: Duplicate entry & Account already in use

Posted: Wed Sep 22, 2010 8:55 am
by jurchiks
it's got nothing to do with connection... It's not even a problem, it's just a glitch.

Re: Duplicate entry & Account already in use

Posted: Wed Sep 22, 2010 9:52 am
by Naonah
Try a better dedicated machine.

If you have heavy laggs it is possible that sometimes a server saves duplicate values.

Re: Duplicate entry & Account already in use

Posted: Wed Sep 22, 2010 10:53 am
by babyjason
that doesent matter, it has nothing to do with connections.

Re: Duplicate entry & Account already in use

Posted: Wed Sep 22, 2010 3:25 pm
by K4N4BS
Dual Xeon Quad, 12Gb Ram (8Gb for GS), HD SCI 10.000Rpm

No, i don't have a "simple machine".

Re: Duplicate entry & Account already in use

Posted: Wed Sep 22, 2010 8:23 pm
by babyjason
K4N4BS wrote:Dual Xeon Quad, 12Gb Ram (8Gb for GS), HD SCI 10.000Rpm

No, i don't have a "simple machine".
ur machine doesent matter, u matter. the way u do stuff.u can have nasa machine if u dont read this forum and u dont understand sht.

Re: Duplicate entry & Account already in use

Posted: Wed Sep 22, 2010 8:36 pm
by K4N4BS
I have 2 years of experience wiht L2j...
Read what? How "click and start" server?

Who are you to tell me what i have to do?
If you don't have what to say, just shut up.

Re: Duplicate entry & Account already in use

Posted: Wed Sep 22, 2010 8:55 pm
by babyjason
K4N4BS wrote:I have 2 years of experience wiht L2j...
Read what? How "click and start" server?

Who are you to tell me what i have to do?
If you don't have what to say, just shut up.
was just trying to help, sry. lesson learned.
All times are UTC
Page 1 of 2

Powered by phpBB® Forum Software © phpBB Limited