L2J Server

Do not forget to add your Server and Datapack Revision numbers!
» Find Revision
L2J Revision last 2.3 from branch:
L2JDP Revision last 2.3 from branch:

ok let's go: windows server 2003 64 bit before max 2 weeks reinstalled
machine 8gb ram
mysql 5.1
java 6.18

startup settings:REM Default parameters for a basic server.
java -Djava.util.logging.manager=net.sf.l2j.util.L2LogManager -Xmx5120m -cp ./../libs/*;l2jserver.jar net.sf.l2j.gameserver.GameServer
REM
REM If you have a big server and lots of memory, you could experiment for example with
java -server -Xmx5120m -Xms2560m -Xmn1534m -XX:PermSize=1024m -XX:SurvivorRatio=8 -Xnoclassgc -XX:+AggressiveOpts
REM If you are having troubles on server shutdown (saving data),
REM add this to startup paramethers: -Djava.util.logging.manager=net.sf.l2j.L2LogManager. Example:
REM java -Djava.util.logging.manager=net.sf.l2j.util.L2LogManager -Xmx4096m -cp ./../libs/*;l2jserver.jar net.sf.l2j.gameserver.GameServer

BTW.. test it and with other configs same problem that i say below.....
server running with 300+ players no lag nothing....

now the problem is:
mass disconnect after 17+ hours before not
server freeze not error on console only disconnect abnormally error for all players


i was searching here in forum if someone have same problem and find that the solution that posted someone is
to increase the query_cache_size=0 and the tmp_table_size=256M to 550 each btw. 0 and 256 was the default settings bt me..so i increased and was fixed a little the problem from 10-12 hours that server was freeze now freeze after 17+.i increased more but same problem again mass disconnect.

so that what i want to ask is: can someone help me to set so the configs my.ini (server configs) or what else i have wrong that the problem will be fixed?

i dont want to make alone more tests in mysql and make the problem bigger as is now...
ofc i will pay for this job...

pm me

P.S.1 the problem its not from server core i try it with clean and with my custom java etc...same problem
P.S.2 server running more then 3 years now never i had this problem but now i need a config expert...
P.S.3 when i log in in server with remote and log out server stuck form 10-20 seconds nobody can move....

ty very much to all from now for any help

moved to support, is not a bug report.

energy wrote:Do not forget to add your Server and Datapack Revision numbers!
» Find Revision
L2J Revision last 2.3 from branch:
L2JDP Revision last 2.3 from branch:

ok let's go: windows server 2003 64 bit before max 2 weeks reinstalled
machine 8gb ram
mysql 5.1
java 6.18

startup settings:REM Default parameters for a basic server.
java -Djava.util.logging.manager=net.sf.l2j.util.L2LogManager -Xmx5120m -cp ./../libs/*;l2jserver.jar net.sf.l2j.gameserver.GameServer
REM
REM If you have a big server and lots of memory, you could experiment for example with
java -server -Xmx5120m -Xms2560m -Xmn1534m -XX:PermSize=1024m -XX:SurvivorRatio=8 -Xnoclassgc -XX:+AggressiveOpts
REM If you are having troubles on server shutdown (saving data),
REM add this to startup paramethers: -Djava.util.logging.manager=net.sf.l2j.L2LogManager. Example:
REM java -Djava.util.logging.manager=net.sf.l2j.util.L2LogManager -Xmx4096m -cp ./../libs/*;l2jserver.jar net.sf.l2j.gameserver.GameServer

BTW.. test it and with other configs same problem that i say below.....
server running with 300+ players no lag nothing....

now the problem is:
mass disconnect after 17+ hours before not
server freeze not error on console only disconnect abnormally error for all players


i was searching here in forum if someone have same problem and find that the solution that posted someone is
to increase the query_cache_size=0 and the tmp_table_size=256M to 550 each btw. 0 and 256 was the default settings bt me..so i increased and was fixed a little the problem from 10-12 hours that server was freeze now freeze after 17+.i increased more but same problem again mass disconnect.

so that what i want to ask is: can someone help me to set so the configs my.ini (server configs) or what else i have wrong that the problem will be fixed?

i dont want to make alone more tests in mysql and make the problem bigger as is now...
ofc i will pay for this job...

pm me

P.S.1 the problem its not from server core i try it with clean and with my custom java etc...same problem
P.S.2 server running more then 3 years now never i had this problem but now i need a config expert...
P.S.3 when i log in in server with remote and log out server stuck form 10-20 seconds nobody can move....

ty very much to all from now for any help

TvT enabled? Does this occur near TvT Participation start?

mgbhard wrote:

energy wrote:Do not forget to add your Server and Datapack Revision numbers!
» Find Revision
L2J Revision last 2.3 from branch:
L2JDP Revision last 2.3 from branch:

ok let's go: windows server 2003 64 bit before max 2 weeks reinstalled
machine 8gb ram
mysql 5.1
java 6.18

startup settings:REM Default parameters for a basic server.
java -Djava.util.logging.manager=net.sf.l2j.util.L2LogManager -Xmx5120m -cp ./../libs/*;l2jserver.jar net.sf.l2j.gameserver.GameServer
REM
REM If you have a big server and lots of memory, you could experiment for example with
java -server -Xmx5120m -Xms2560m -Xmn1534m -XX:PermSize=1024m -XX:SurvivorRatio=8 -Xnoclassgc -XX:+AggressiveOpts
REM If you are having troubles on server shutdown (saving data),
REM add this to startup paramethers: -Djava.util.logging.manager=net.sf.l2j.L2LogManager. Example:
REM java -Djava.util.logging.manager=net.sf.l2j.util.L2LogManager -Xmx4096m -cp ./../libs/*;l2jserver.jar net.sf.l2j.gameserver.GameServer

BTW.. test it and with other configs same problem that i say below.....
server running with 300+ players no lag nothing....

now the problem is:
mass disconnect after 17+ hours before not
server freeze not error on console only disconnect abnormally error for all players


i was searching here in forum if someone have same problem and find that the solution that posted someone is
to increase the query_cache_size=0 and the tmp_table_size=256M to 550 each btw. 0 and 256 was the default settings bt me..so i increased and was fixed a little the problem from 10-12 hours that server was freeze now freeze after 17+.i increased more but same problem again mass disconnect.

so that what i want to ask is: can someone help me to set so the configs my.ini (server configs) or what else i have wrong that the problem will be fixed?

i dont want to make alone more tests in mysql and make the problem bigger as is now...
ofc i will pay for this job...

pm me

P.S.1 the problem its not from server core i try it with clean and with my custom java etc...same problem
P.S.2 server running more then 3 years now never i had this problem but now i need a config expert...
P.S.3 when i log in in server with remote and log out server stuck form 10-20 seconds nobody can move....

ty very much to all from now for any help

TvT enabled? Does this occur near TvT Participation start?

i test it all.... 2-3 days without events nothing.... same problem...without geos...with clean core all i test it...
its not from core is some mysql config...think only this... when i log in with remote in server and in the log out
server stuck for 10+ seconds....tha is not normal never was stuck when i was in remote in...

energy wrote:

mgbhard wrote:

energy wrote:Do not forget to add your Server and Datapack Revision numbers!
» Find Revision
L2J Revision last 2.3 from branch:
L2JDP Revision last 2.3 from branch:

ok let's go: windows server 2003 64 bit before max 2 weeks reinstalled
machine 8gb ram
mysql 5.1
java 6.18

startup settings:REM Default parameters for a basic server.
java -Djava.util.logging.manager=net.sf.l2j.util.L2LogManager -Xmx5120m -cp ./../libs/*;l2jserver.jar net.sf.l2j.gameserver.GameServer
REM
REM If you have a big server and lots of memory, you could experiment for example with
java -server -Xmx5120m -Xms2560m -Xmn1534m -XX:PermSize=1024m -XX:SurvivorRatio=8 -Xnoclassgc -XX:+AggressiveOpts
REM If you are having troubles on server shutdown (saving data),
REM add this to startup paramethers: -Djava.util.logging.manager=net.sf.l2j.L2LogManager. Example:
REM java -Djava.util.logging.manager=net.sf.l2j.util.L2LogManager -Xmx4096m -cp ./../libs/*;l2jserver.jar net.sf.l2j.gameserver.GameServer

BTW.. test it and with other configs same problem that i say below.....
server running with 300+ players no lag nothing....

now the problem is:
mass disconnect after 17+ hours before not
server freeze not error on console only disconnect abnormally error for all players


i was searching here in forum if someone have same problem and find that the solution that posted someone is
to increase the query_cache_size=0 and the tmp_table_size=256M to 550 each btw. 0 and 256 was the default settings bt me..so i increased and was fixed a little the problem from 10-12 hours that server was freeze now freeze after 17+.i increased more but same problem again mass disconnect.

so that what i want to ask is: can someone help me to set so the configs my.ini (server configs) or what else i have wrong that the problem will be fixed?

i dont want to make alone more tests in mysql and make the problem bigger as is now...
ofc i will pay for this job...

pm me

P.S.1 the problem its not from server core i try it with clean and with my custom java etc...same problem
P.S.2 server running more then 3 years now never i had this problem but now i need a config expert...
P.S.3 when i log in in server with remote and log out server stuck form 10-20 seconds nobody can move....

ty very much to all from now for any help

TvT enabled? Does this occur near TvT Participation start?

i test it all.... 2-3 days without events nothing.... same problem...without geos...with clean core all i test it...
its not from core is some mysql config...think only this... when i log in with remote in server and in the log out
server stuck for 10+ seconds....tha is not normal never was stuck when i was in remote in...

Thats normal, if you have high hdd usage, while windows is closing the session it freeze the game server, are you running from a vps?

overquoting is evil.
try to give priority to process a bit higher, sometimes it worksforme
try to reduce color depth of connection(rdp)

denser wrote:overquoting is evil.
try to give priority to process a bit higher, sometimes it worksforme
try to reduce color depth of connection(rdp)

i dont understand nothing...
can you explain it? pm me or here
ty

i have same problem... server freeze every 12-15 hours...
i tested all windows XP,2003,7... x32\x64
PS> maybe only on linux problem will be fu*ked ?

i solve this problem with 3 restarts at day...
at 5, at 12, at 19 o'clock...

but players dont want 3 restarts at day...

Uphillyout wrote:i have same problem... server freeze every 12-15 hours...
i tested all windows XP,2003,7... x32\x64
PS> maybe only on linux problem will be fu*ked ?

i solve this problem with 3 restarts at day...
at 5, at 12, at 19 o'clock...

but players dont want 3 restarts at day...

by me stucks every 17+ hours... but its same.. i cant make rr every 15 ..i have 300+ players + 80+ shops i cant tell people make again shops from the start.....

anyway nobody pm me ......
i must found a mysql expert to see the problem with remote... and not from here with posts make this make the other..

so we make the problem only bigger

connect throught telnet and debug all and check your cpu and memory usage near the freeze

B1ggBoss wrote:connect throught telnet and debug all and check your cpu and memory usage near the freeze

yes i make it but not now....500+ online now

ty
and i past here the results

i think we can blame olimpiad system...
cause when server freeze in gameserver window i see words "olimpiad system: olimpiad game ended" or "olimpiad system: olimpiad game started"

Uphillyout wrote:i think we can blame olimpiad system...
cause when server freeze in gameserver window i see words "olimpiad system: olimpiad game ended" or "olimpiad system: olimpiad game started"

olympiad

problem solved:
in this topic viewtopic.php?f=81&t=14607&p=72521&hilit=3000#p72521

i have make mysql settings like JavierDC says.... and no more freezes! server now is running at the moment 39 hours and without problem...

ty JavierDC



* Report this post
* Reply with quote

Re: Server error and freeze!

Postby JavierDC on Fri Dec 18, 2009 3:38 am
variables to consider.

español
variables a tener en cuenta.

max_connections=300
table_cache=3000 <--------------> table_cache = (max_connections * 10)

query_cache_size=350M <------------> >increased the total size of the database (l2jdb).
query_cache_type=1
query_cache_limit=512k

tmp_table_size=0M <---------> l2j not use