who want's to help me....

[energy]

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

[janiii]

moved to support, is not a bug report.

[mgbhard]

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?

[energy]

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...

[mgbhard]

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?

[denser]

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

[energy]

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

[Uphillyout]

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...

[energy]

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

[BiggBoss]

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

[energy]

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

[Uphillyout]

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"

[janiii]

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

[energy]

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