Duplicate entry & Account already in use

Support for the latest build of L2J Server, get help here with installations, upgrades, problems.
Do not post bugs reports here, use viewforum.php?f=77 instead.
There is no support for other server builds than the official provided by l2jserver.com
Forum rules
READ NOW: L2j Forums Rules of Conduct
Post Reply
User avatar
achilless
Posts: 153
Joined: Thu Oct 02, 2008 7:40 pm
Location: Russia & Ukraine

Duplicate entry & Account already in use

Post 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)
Top
User avatar
Naonah
Posts: 357
Joined: Sun Apr 04, 2010 11:12 pm

Re: Duplicate entry & Account already in use

Post by Naonah »

lol :D

remove one of this in DB and it will not be duplicate :)
public void l2jserver ()
{
if (you want l2j server == no problems)
use Linux;
else
use Windows;
}
Top
User avatar
achilless
Posts: 153
Joined: Thu Oct 02, 2008 7:40 pm
Location: Russia & Ukraine

Re: Duplicate entry & Account already in use

Post 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
Top
User avatar
Naonah
Posts: 357
Joined: Sun Apr 04, 2010 11:12 pm

Re: Duplicate entry & Account already in use

Post 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.
public void l2jserver ()
{
if (you want l2j server == no problems)
use Linux;
else
use Windows;
}
Top
User avatar
achilless
Posts: 153
Joined: Thu Oct 02, 2008 7:40 pm
Location: Russia & Ukraine

Re: Duplicate entry & Account already in use

Post 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!
Top
User avatar
jurchiks
Posts: 6769
Joined: Sat Sep 19, 2009 4:16 pm
Location: Eastern Europe

Re: Duplicate entry & Account already in use

Post by jurchiks »

just delete those lines for fuck sake!
If you have problems, FIRST TRY SOLVING THEM YOURSELF, and if you get errors, TRY TO ANALYZE THEM, and ONLY if you can't help it, THEN ask here.
Otherwise you will never learn anything if all you do is copy-paste!
Discussion breeds innovation.
Top
User avatar
Naonah
Posts: 357
Joined: Sun Apr 04, 2010 11:12 pm

Re: Duplicate entry & Account already in use

Post by Naonah »

jurchiks wrote:just delete those lines for fuck sake!
:mrgreen:
public void l2jserver ()
{
if (you want l2j server == no problems)
use Linux;
else
use Windows;
}
Top
K4N4BS
Posts: 94
Joined: Mon Jul 06, 2009 3:45 pm

Re: Duplicate entry & Account already in use

Post by K4N4BS »

The same happen with me...
But players are still able to connect...
Top
User avatar
jurchiks
Posts: 6769
Joined: Sat Sep 19, 2009 4:16 pm
Location: Eastern Europe

Re: Duplicate entry & Account already in use

Post by jurchiks »

it's got nothing to do with connection... It's not even a problem, it's just a glitch.
If you have problems, FIRST TRY SOLVING THEM YOURSELF, and if you get errors, TRY TO ANALYZE THEM, and ONLY if you can't help it, THEN ask here.
Otherwise you will never learn anything if all you do is copy-paste!
Discussion breeds innovation.
Top
User avatar
Naonah
Posts: 357
Joined: Sun Apr 04, 2010 11:12 pm

Re: Duplicate entry & Account already in use

Post by Naonah »

Try a better dedicated machine.

If you have heavy laggs it is possible that sometimes a server saves duplicate values.
public void l2jserver ()
{
if (you want l2j server == no problems)
use Linux;
else
use Windows;
}
Top
babyjason
Posts: 575
Joined: Wed Dec 02, 2009 7:59 pm

Re: Duplicate entry & Account already in use

Post by babyjason »

that doesent matter, it has nothing to do with connections.
Top
K4N4BS
Posts: 94
Joined: Mon Jul 06, 2009 3:45 pm

Re: Duplicate entry & Account already in use

Post by K4N4BS »

Dual Xeon Quad, 12Gb Ram (8Gb for GS), HD SCI 10.000Rpm

No, i don't have a "simple machine".
Top
babyjason
Posts: 575
Joined: Wed Dec 02, 2009 7:59 pm

Re: Duplicate entry & Account already in use

Post 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.
Top
K4N4BS
Posts: 94
Joined: Mon Jul 06, 2009 3:45 pm

Re: Duplicate entry & Account already in use

Post 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.
Top
babyjason
Posts: 575
Joined: Wed Dec 02, 2009 7:59 pm

Re: Duplicate entry & Account already in use

Post 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.
Last edited by babyjason on Thu Sep 23, 2010 6:13 am, edited 1 time in total.
Top
Post Reply

Return to “High Five Support”