Gamefile 2089M auth server problem

[IvanSantos]

Hi EPVP community.

In my Metin2 PServer, which had around the 700 players (with 2006er files) and it now has around 500 players (with 2010er files) online, sometimes the login becames too slow. The server doesn't have any lag and the machine supports up to 2500 players without lag (according to my estimatives).

The SFiles are 2006er converted to 2010er files, with gamefile 2089M modded by me. The files are almost in portuguese and it was created from rain serverfiles. The system is modded by me. I don't use the standard configurations and the standard folder places. I have the serverfiles like this:

 Spoiler

/addictmt2/CMD

/ayks/bin/db
/ayks/bin/game
/ayks/bin/iniciar
/ayks/bin/limpar
/ayks/bin/parar
/ayks/bin/reiniciar
/ayks/bin/reiniciar_soft
/ayks/conf/CMD
/ayks/conf/PTS
/ayks/conf/VERSION.txt
/ayks/conf/check.txt
/ayks/conf/conf.txt
/ayks/conf/dump.txt
/ayks/conf/key.txt
/ayks/conf/pid
/ayks/conf/syserr
/ayks/conf/syslog
/ayks/conf/usage.txt
/ayks/data/data
/ayks/log/PTS
/ayks/log/syserr
/ayks/log/syslog
/ayks/log/usage.txt
/ayks/script/iniciar
/ayks/script/limpar
/ayks/script/parar
/ayks/script/reiniciar
/ayks/script/reiniciar_soft

/ayks/conf/auth:
CMD
CONFIG
PTS
VERSION.txt
cores
data
locale
log
p2p_packet_info.txt
packet_info.txt
pid
stdout
syserr
syslog

/ayks/conf/channel1_1:
CMD
CONFIG
PTS
VERSION.txt
cores
data
guild_mark.idx.removable
guild_mark.tga.removable
guild_symbol.tga
locale
log
mark
p2p_packet_info.txt
packet_info.txt
pid
stdout
syserr
syslog
udp_packet_info.txt

/ayks/conf/channel1_2:
CMD
CONFIG
PTS
VERSION.txt
cores
data
locale
log
mark
p2p_packet_info.txt
packet_info.txt
pid
stdout
syserr
syslog
udp_packet_info.txt

/ayks/conf/channel2_1:
CMD
CONFIG
PTS
VERSION.txt
cores
data
locale
log
mark
p2p_packet_info.txt
packet_info.txt
pid
stdout
syserr
syslog
udp_packet_info.txt

/ayks/conf/channel2_2:
CMD
CONFIG
PTS
VERSION.txt
cores
data
locale
log
mark
p2p_packet_info.txt
packet_info.txt
pid
stdout
syserr
syslog
udp_packet_info.txt

/ayks/conf/channel3_1:
CMD
CONFIG
PTS
VERSION.txt
cores
data
locale
log
mark
p2p_packet_info.txt
packet_info.txt
pid
stdout
syserr
syslog
udp_packet_info.txt

/ayks/conf/channel3_2:
CMD
CONFIG
PTS
VERSION.txt
castle_data.txt
cores
data
locale
log
mark
p2p_packet_info.txt
packet_info.txt
pid
stdout
syserr
syslog
udp_packet_info.txt

/ayks/conf/channel4_1:
CMD
CONFIG
PTS
VERSION.txt
cores
data
locale
log
mark
p2p_packet_info.txt
packet_info.txt
pid
stdout
syserr
syslog
udp_packet_info.txt

/ayks/conf/channel4_2:
CMD
CONFIG
PTS
VERSION.txt
castle_data.txt
cores
data
locale
log
mark
p2p_packet_info.txt
packet_info.txt
pid
stdout
syserr
syslog
udp_packet_info.txt

/ayks/conf/channel99_1:
CMD
CONFIG
PTS
VERSION.txt
cores
data
locale
log
mark
p2p_packet_info.txt
packet_info.txt
pid
stdout
syserr
syslog
udp_packet_info.txt

/ayks/conf/cores:

/ayks/conf/log:
20120113
20120114
20120115

/ayks/cores/auth:

/ayks/cores/channel1_1:

/ayks/cores/channel1_2:

/ayks/cores/channel2_1:

/ayks/cores/channel2_2:

/ayks/cores/channel3_1:

/ayks/cores/channel3_2:

/ayks/cores/channel4_1:

/ayks/cores/channel4_2:

/ayks/cores/channel99_1:

/ayks/cores/db:

/ayks/data:
dungeon
monster
pc
pc2

/ayks/locale:
germany

/ayks/log/auth:
PTS
data
p2p_packet_info.txt
packet_info.txt
stdout
syserr
syslog

/ayks/log/channel1_1:
PTS
VERSION.txt
data
p2p_packet_info.txt
packet_info.txt
stdout
syserr
syslog
udp_packet_info.txt

/ayks/log/channel1_2:
PTS
VERSION.txt
data
p2p_packet_info.txt
packet_info.txt
stdout
syserr
syslog

/ayks/log/channel2_1:
PTS
VERSION.txt
data
p2p_packet_info.txt
packet_info.txt
stdout
syserr
syslog
udp_packet_info.txt

/ayks/log/channel2_2:
PTS
VERSION.txt
data
p2p_packet_info.txt
packet_info.txt
stdout
syserr
syslog

/ayks/log/channel3_1:
PTS
VERSION.txt
data
p2p_packet_info.txt
packet_info.txt
stdout
syserr
syslog
udp_packet_info.txt

/ayks/log/channel3_2:
PTS
VERSION.txt
data
p2p_packet_info.txt
packet_info.txt
stdout
syserr
syslog

/ayks/log/channel4_1:
PTS
VERSION.txt
data
p2p_packet_info.txt
packet_info.txt
stdout
syserr
syslog
udp_packet_info.txt

/ayks/log/channel4_2:
PTS
VERSION.txt
data
p2p_packet_info.txt
packet_info.txt
stdout
syserr
syslog

/ayks/log/channel99_1:
PTS
VERSION.txt
data
p2p_packet_info.txt
packet_info.txt
stdout
syserr
syslog

/ayks/log/data:

/ayks/script/auth:
keepalive.sh
off
on

/ayks/script/channel1_1:
off
on

/ayks/script/channel1_2:
off
on

/ayks/script/channel2_1:
off
on

/ayks/script/channel2_2:
off
on

/ayks/script/channel3_1:
off
on

/ayks/script/channel3_2:
off
on

/ayks/script/channel4_1:
off
on

/ayks/script/channel4_2:
off
on

/ayks/script/channel99_1:
off
on

/ayks/script/db:
keepalive.sh
off
on

/nikie/bin/db
/nikie/bin/game
/nikie/bin/iniciar
/nikie/bin/limpar
/nikie/bin/parar
/nikie/bin/reiniciar
/nikie/bin/reiniciar_soft
/nikie/conf/CMD
/nikie/conf/PTS
/nikie/conf/VERSION.txt
/nikie/conf/check.txt
/nikie/conf/conf.txt
/nikie/conf/dump.txt
/nikie/conf/key.txt
/nikie/conf/pid
/nikie/conf/syserr
/nikie/conf/syslog
/nikie/conf/usage.txt
/nikie/data/data
/nikie/log/PTS
/nikie/log/syserr
/nikie/log/syslog
/nikie/log/usage.txt
/nikie/script/iniciar
/nikie/script/limpar
/nikie/script/parar
/nikie/script/reiniciar
/nikie/script/reiniciar_soft

/nikie/conf/auth:
CMD
CONFIG
PTS
VERSION.txt
cores
data
locale
log
p2p_packet_info.txt
packet_info.txt
pid
stdout
syserr
syslog

/nikie/conf/channel1_1:
CMD
CONFIG
PTS
VERSION.txt
cores
data
guild_mark.idx.removable
guild_mark.tga.removable
guild_symbol.tga
locale
log
mark
p2p_packet_info.txt
packet_info.txt
pid
stdout
syserr
syslog
udp_packet_info.txt

/nikie/conf/channel1_2:
CMD
CONFIG
PTS
VERSION.txt
cores
data
locale
log
mark
p2p_packet_info.txt
packet_info.txt
pid
stdout
syserr
syslog
udp_packet_info.txt

/nikie/conf/channel2_1:
CMD
CONFIG
PTS
VERSION.txt
cores
data
locale
log
mark
p2p_packet_info.txt
packet_info.txt
pid
stdout
syserr
syslog
udp_packet_info.txt

/nikie/conf/channel2_2:
CMD
CONFIG
PTS
VERSION.txt
cores
data
locale
log
mark
p2p_packet_info.txt
packet_info.txt
pid
stdout
syserr
syslog
udp_packet_info.txt

/nikie/conf/channel3_1:
CMD
CONFIG
PTS
VERSION.txt
cores
data
locale
log
mark
p2p_packet_info.txt
packet_info.txt
pid
stdout
syserr
syslog
udp_packet_info.txt

/nikie/conf/channel3_2:
CMD
CONFIG
PTS
VERSION.txt
castle_data.txt
cores
data
locale
log
mark
p2p_packet_info.txt
packet_info.txt
pid
stdout
syserr
syslog
udp_packet_info.txt

/nikie/conf/channel4_1:
CMD
CONFIG
PTS
VERSION.txt
cores
data
locale
log
mark
p2p_packet_info.txt
packet_info.txt
pid
stdout
syserr
syslog
udp_packet_info.txt

/nikie/conf/channel4_2:
CMD
CONFIG
PTS
VERSION.txt
castle_data.txt
cores
data
locale
log
mark
p2p_packet_info.txt
packet_info.txt
pid
stdout
syserr
syslog
udp_packet_info.txt

/nikie/conf/channel99_1:
CMD
CONFIG
PTS
VERSION.txt
cores
data
locale
log
mark
p2p_packet_info.txt
packet_info.txt
pid
stdout
syserr
syslog
udp_packet_info.txt

/nikie/conf/cores:

/nikie/conf/log:
20120113
20120114
20120115

/nikie/cores/auth:

/nikie/cores/channel1_1:

/nikie/cores/channel1_2:

/nikie/cores/channel2_1:

/nikie/cores/channel2_2:

/nikie/cores/channel3_1:

/nikie/cores/channel3_2:

/nikie/cores/channel4_1:

/nikie/cores/channel4_2:

/nikie/cores/channel99_1:

/nikie/cores/db:

/nikie/data:
dungeon
monster
pc
pc2

/nikie/locale:
germany

/nikie/log/auth:
PTS
data
p2p_packet_info.txt
packet_info.txt
stdout
syserr
syslog

/nikie/log/channel1_1:
PTS
VERSION.txt
data
p2p_packet_info.txt
packet_info.txt
stdout
syserr
syslog
udp_packet_info.txt

/nikie/log/channel1_2:
PTS
VERSION.txt
data
p2p_packet_info.txt
packet_info.txt
stdout
syserr
syslog

/nikie/log/channel2_1:
PTS
VERSION.txt
data
p2p_packet_info.txt
packet_info.txt
stdout
syserr
syslog
udp_packet_info.txt

/nikie/log/channel2_2:
PTS
VERSION.txt
data
p2p_packet_info.txt
packet_info.txt
stdout
syserr
syslog

/nikie/log/channel3_1:
PTS
VERSION.txt
data
p2p_packet_info.txt
packet_info.txt
stdout
syserr
syslog
udp_packet_info.txt

/nikie/log/channel3_2:
PTS
VERSION.txt
data
p2p_packet_info.txt
packet_info.txt
stdout
syserr
syslog

/nikie/log/channel4_1:
PTS
VERSION.txt
data
p2p_packet_info.txt
packet_info.txt
stdout
syserr
syslog
udp_packet_info.txt

/nikie/log/channel4_2:
PTS
VERSION.txt
data
p2p_packet_info.txt
packet_info.txt
stdout
syserr
syslog

/nikie/log/channel99_1:
PTS
VERSION.txt
data
p2p_packet_info.txt
packet_info.txt
stdout
syserr
syslog

/nikie/log/data:

/nikie/script/auth:
keepalive.sh
off
on

/nikie/script/channel1_1:
off
on

/nikie/script/channel1_2:
off
on

/nikie/script/channel2_1:
off
on

/nikie/script/channel2_2:
off
on

/nikie/script/channel3_1:
off
on

/nikie/script/channel3_2:
off
on

/nikie/script/channel4_1:
off
on

/nikie/script/channel4_2:
off
on

/nikie/script/channel99_1:
off
on

/nikie/script/db:
keepalive.sh
off
on

/zeus/bin/db
/zeus/bin/game
/zeus/bin/iniciar
/zeus/bin/limpar
/zeus/bin/parar
/zeus/bin/reiniciar
/zeus/bin/reiniciar_soft
/zeus/conf/CMD
/zeus/conf/PTS
/zeus/conf/VERSION.txt
/zeus/conf/check.txt
/zeus/conf/conf.txt
/zeus/conf/dump.txt
/zeus/conf/key.txt
/zeus/conf/pid
/zeus/conf/syserr
/zeus/conf/syslog
/zeus/conf/usage.txt
/zeus/data/data
/zeus/log/PTS
/zeus/log/syserr
/zeus/log/syslog
/zeus/log/usage.txt
/zeus/script/iniciar
/zeus/script/limpar
/zeus/script/parar
/zeus/script/reiniciar
/zeus/script/reiniciar_soft

/zeus/conf/auth:
CMD
CONFIG
PTS
VERSION.txt
cores
data
locale
log
p2p_packet_info.txt
packet_info.txt
pid
stdout
syserr
syslog

/zeus/conf/channel1_1:
CMD
CONFIG
PTS
VERSION.txt
cores
data
guild_mark.idx.removable
guild_mark.tga.removable
guild_symbol.tga
locale
log
mark
p2p_packet_info.txt
packet_info.txt
pid
stdout
syserr
syslog
udp_packet_info.txt

/zeus/conf/channel1_2:
CMD
CONFIG
PTS
VERSION.txt
cores
data
locale
log
mark
p2p_packet_info.txt
packet_info.txt
pid
stdout
syserr
syslog
udp_packet_info.txt

/zeus/conf/channel2_1:
CMD
CONFIG
PTS
VERSION.txt
cores
data
locale
log
mark
p2p_packet_info.txt
packet_info.txt
pid
stdout
syserr
syslog
udp_packet_info.txt

/zeus/conf/channel2_2:
CMD
CONFIG
PTS
VERSION.txt
cores
data
locale
log
mark
p2p_packet_info.txt
packet_info.txt
pid
stdout
syserr
syslog
udp_packet_info.txt

/zeus/conf/channel3_1:
CMD
CONFIG
PTS
VERSION.txt
cores
data
locale
log
mark
p2p_packet_info.txt
packet_info.txt
pid
stdout
syserr
syslog
udp_packet_info.txt

/zeus/conf/channel3_2:
CMD
CONFIG
PTS
VERSION.txt
castle_data.txt
cores
data
locale
log
mark
p2p_packet_info.txt
packet_info.txt
pid
stdout
syserr
syslog
udp_packet_info.txt

/zeus/conf/channel4_1:
CMD
CONFIG
PTS
VERSION.txt
cores
data
locale
log
mark
p2p_packet_info.txt
packet_info.txt
pid
stdout
syserr
syslog
udp_packet_info.txt

/zeus/conf/channel4_2:
CMD
CONFIG
PTS
VERSION.txt
castle_data.txt
cores
data
locale
log
mark
p2p_packet_info.txt
packet_info.txt
pid
stdout
syserr
syslog
udp_packet_info.txt

/zeus/conf/channel99_1:
CMD
CONFIG
PTS
VERSION.txt
cores
data
locale
log
mark
p2p_packet_info.txt
packet_info.txt
pid
stdout
syserr
syslog
udp_packet_info.txt

/zeus/conf/cores:

/zeus/conf/log:
20120113
20120114
20120115

/zeus/cores/auth:

/zeus/cores/channel1_1:

/zeus/cores/channel1_2:

/zeus/cores/channel2_1:

/zeus/cores/channel2_2:

/zeus/cores/channel3_1:

/zeus/cores/channel3_2:

/zeus/cores/channel4_1:

/zeus/cores/channel4_2:

/zeus/cores/channel99_1:

/zeus/cores/db:

/zeus/data:
dungeon
monster
pc
pc2

/zeus/locale:
germany

/zeus/log/auth:
PTS
data
p2p_packet_info.txt
packet_info.txt
stdout
syserr
syslog

/zeus/log/channel1_1:
PTS
VERSION.txt
data
p2p_packet_info.txt
packet_info.txt
stdout
syserr
syslog
udp_packet_info.txt

/zeus/log/channel1_2:
PTS
VERSION.txt
data
p2p_packet_info.txt
packet_info.txt
stdout
syserr
syslog

/zeus/log/channel2_1:
PTS
VERSION.txt
data
p2p_packet_info.txt
packet_info.txt
stdout
syserr
syslog
udp_packet_info.txt

/zeus/log/channel2_2:
PTS
VERSION.txt
data
p2p_packet_info.txt
packet_info.txt
stdout
syserr
syslog

/zeus/log/channel3_1:
PTS
VERSION.txt
data
p2p_packet_info.txt
packet_info.txt
stdout
syserr
syslog
udp_packet_info.txt

/zeus/log/channel3_2:
PTS
VERSION.txt
data
p2p_packet_info.txt
packet_info.txt
stdout
syserr
syslog

/zeus/log/channel4_1:
PTS
VERSION.txt
data
p2p_packet_info.txt
packet_info.txt
stdout
syserr
syslog
udp_packet_info.txt

/zeus/log/channel4_2:
PTS
VERSION.txt
data
p2p_packet_info.txt
packet_info.txt
stdout
syserr
syslog

/zeus/log/channel99_1:
PTS
VERSION.txt
data
p2p_packet_info.txt
packet_info.txt
stdout
syserr
syslog

/zeus/log/data:
20120113
20120114
20120115

/zeus/script/auth:
keepalive.sh
off
on

/zeus/script/channel1_1:
off
on

/zeus/script/channel1_2:
off
on

/zeus/script/channel2_1:
off
on

/zeus/script/channel2_2:
off
on

/zeus/script/channel3_1:
off
on

/zeus/script/channel3_2:
off
on

/zeus/script/channel4_1:
off
on

/zeus/script/channel4_2:
off
on

/zeus/script/channel99_1:
off
on

/zeus/script/db:
keepalive.sh
off
on

I tryed to do

• kill -1 `cat conf/auth/pid`

But it keeps slow. It only remains stable when I restart the server, and I don't restart the server at some days.

A line which appears several times in auth syserr:

 Spoiler

SYSERR: Jan 15 12:59:31 :: SetBilling: cannot find login key 500412402

Auth CONFIG:

 Spoiler

HOSTNAME: auth
CHANNEL: 1
PORT: 30000
P2P_PORT: 30100
DB_PORT: 39999
DB_ADDR: localhost
TABLE_POSTFIX:
ITEM_ID_RANGE: 000000001 000000002
PASSES_PER_SEC: 25
SAVE_EVENT_SECOND_CYCLE: 180
PING_EVENT_SECOND_CYCLE: 180
AUTH_SERVER: master
PLAYER_SQL: localhost USERNAME PASSWORD account
LOG_SQL: localhost USERNAME PASSWORD zeus_log
COMMON_SQL: localhost USERNAME PASSWORD zeus_common
LOCALE_SERVICE: GERMANY
adminpage_ip1: localhost
adminpage_ip2: localhost
adminpage_ip3: localhost

The tables are in InnoDB instead of MyISAM. The only tables which are in MyISAM are the XXX_log.command_log , the XXX_log.log and the XXX_player.item .

I think that is all information I have to someone help me.


EDIT: FreeBSD uname -aimnoprsv output:
FreeBSD srv01.addictmt2.com.pt 8.2-RELEASE-p5 FreeBSD 8.2-RELEASE-p5 #1: Sun Dec 25 12:20:58 WET 2011 :/usr/obj/usr/src/sys/ADDICTMT2 amd64 amd64 ADDICTMT2

Best regards,
Ivan Santos.

[Structurix]

SetBilling: cannot find login key 500412402

problem

[IvanSantos]

Originally Posted by Structurix

SetBilling: cannot find login key 500412402

problem

I know that is a problem, but you know what it is about?

In DB syserr appears the following line several times:
SYSERR: Jan 15 19:59:49 :: Process: FDWATCH: peer null in event: ident 20

Maybe it could have something about this.

[IvanSantos]

The problem was solved.
I need to use the MyISAM system on the tables. In 2006er serverfiles, the InnoDB speeds up a lot but in the 2010er files causes some problems on gamefile related to INSERT DELAYED command support.

Best regards,
Ivan Santos.