Strange error

[kama3a]

If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision Number:
L2JDP Revision Number:

Code: Select all

Oct 22, 2010 11:53:19 PM com.l2jserver.L2DatabaseFactory$ConnectionCloser runWARNING: Unclosed connection! Trace: com.l2jserver.gameserver.datatables.ClanTable.<init>(ClanTable.java:83)java.lang.RuntimeException    at com.l2jserver.L2DatabaseFactory.getConnection(L2DatabaseFactory.java:227)    at com.l2jserver.gameserver.datatables.ClanTable.<init>(ClanTable.java:83)    at com.l2jserver.gameserver.datatables.ClanTable.<init>(ClanTable.java:56)    at com.l2jserver.gameserver.datatables.ClanTable$SingletonHolder.<clinit>(ClanTable.java:521)    at com.l2jserver.gameserver.datatables.ClanTable.getInstance(ClanTable.java:64)    at com.l2jserver.gameserver.GameServer.<init>(GameServer.java:275)    at com.l2jserver.gameserver.GameServer.main(GameServer.java:537)

i had contributed clan hall siege system, and tough its from it but after removed... continue made this error
i check sql tables, scripts everything is fine...
any ideas what can cause it ?

[_DS_]

During server start ? Ignore it.

[hope]

You have unclosed connections remove bad java file and redownload it again see if that fixes the problem

[JIV]

your server is too slow or your db is very huge, consider cleanup

[kama3a]

During server start ? Ignore it.

server dont want start after this error...

also sql and machine are ok...
after the patch of contributed clan halls start make that problem, also in 10 min of waiting dont show this error.

[_DS_]

Then post it in the corresponding contribution topic.

[kama3a]

Then post it in the corresponding contribution topic.

system for clan halls is removed, but continue make problems,
i dont have other system related with clans or etc,
so dunno from what can make that problem and ask here.
ty

[kama3a]

this problem is so anoying, and dunno where can be the problem.
i remove ch sieges coz they are not full implemented, and messed up with sql and core etc..
machine is with 8 gb ddr 3 ram
and 8 cores
sql is same as before i made the transfer mybe 3-4-5 mb more...

any ideas why stuck aways on server start ? i check almost all custom modes and there have nothing related with clan or clan etc tables.

any ideas ?

[Naonah]

works for me.

replace a proper java files with clean ones (took form repo) and check again.

[kama3a]

after week of checking , i didnt find anything strange.
Sql isnt so big machine can handle it.
All java files related with clan are OK w/o changes.
sql related with clan data - clean no null points or strange line.

And still have the problem on every start...
help with suggestions

and 1 more forget to add it
website script can cause it ?
im not so sure...

[Naonah]

remember - you have something custom on your server and we dont know what it is so noone can help you.

once again - on clean core (and DP) you will not get these errors. I run Freya server from its begining and my GS console is clean like elf's pussy.

[_DS_]

Clan list contain too many clans and their load take too much time. This happens on my home pc when i use live server db with hundreds of clans.

[Naonah]

Clan list contain too many clans and their load take too much time. This happens on my home pc when i use live server db with hundreds of clans.

..so kama3a you "dedicated machine" is not like you wrote Maybe you run home machine?

[_DS_]

Depends on the number of clans and their wh contents.

[kama3a]

enough ram 8g
it start do that after contributed clan hall patch made by bigboss, i remove it but continue make errors.
i check like 100 times whole patch is removed and sql is as default one.
machine is dedicated no lack of ram cpu or etc...

mybe optimize mysql for better work ?
other option is sql to be too slow and ...

p.s. on my laptop with 4g ram - no error
on dedicated machine - error.

i think the problem is hiden somewhere in sql...
can some 1 confirm ?