db server

['oShet]

DB server ist 100% bei WCPU...
Und wenn ich mich einlogge dann dauerts ca. 5 min bis ich eingeloggt bin.
In db syserr steht:

SYSERR: May 22 05:00:42 :: Start: TABLE_POSTFIX not configured use default
SYSERR: May 22 05:00:43 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT empire,pid,name,money,windate FROM monarch a,player b where a.pid=b.id
SYSERR: May 22 05:00:43 :: LoadMonarch:  DirectQuery failed( SELECT empire,pid,name,money,windate FROM monarch a,player b where a.pid=b.id )
SYSERR: May 22 05:00:43 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT pid,name,windate FROM monarch_candidacy a,player b where a.pid = b.id
SYSERR: May 22 05:00:43 :: LoadMonarchCandidacy:  DirectQuery failed( SELECT pid,name,windate FROM monarch_candidacy a,player b where a.pid = b.id )
SYSERR: May 22 05:00:43 :: LoadMonarchElection:  DirectQuery failed( SELECT pid,selectedpid,electiondata FROM monarch_election )
SYSERR: May 22 05:02:03 :: heart_idle: losing 62 seconds. (lag occured)
SYSERR: May 22 05:03:06 :: heart_idle: losing 62 seconds. (lag occured)
SYSERR: May 22 05:04:00 :: heart_idle: losing 54 seconds. (lag occured)
SYSERR: May 22 05:04:40 :: heart_idle: losing 39 seconds. (lag occured)

Process: FDWATCH: peer null in event: ident 23
SYSERR: May 22 05:07:48 :: heart_idle: losing 33 seconds. (lag occured)
SYSERR: May 22 05:07:58 :: Process: FDWATCH: peer null in event: ident 27
SYSERR: May 22 05:07:58 :: Process: FDWATCH: peer null in event: ident 29
SYSERR: May 22 05:07:58 :: Process: FDWATCH: peer null in event: ident 26
SYSERR: May 22 05:07:58 :: Process: FDWATCH: peer null in event: ident 28
SYSERR: May 22 05:07:58 :: Process: FDWATCH: peer null in event: ident 22
SYSERR: May 22 05:07:58 :: Process: FDWATCH: peer null in event: ident 24
SYSERR: May 22 05:09:04 :: heart_idle: losing 62 seconds. (lag occured)
SYSERR: May 22 05:11:14 :: checkpointing: CHECKPOINT shutdown: tics did not updated.

syslog

May 22 05:11:14 :: reallocating buffer to 3371942, current 3371915 <-- Davon ganz viel aber immer andere zahlen!
SYSERR: May 22 05:11:14 :: checkpointing: CHECKPOINT shutdown: tics did not updated.

Und in putty erscheint:

connect: Operation timed out

ist das ALLES vllt. wegen der my.cnf?
die sieht so aus.

[mysqld]
local-infile=0
query_cache_limit=32M
query_cache_size=32M
query_cache_type=1
max_connections=5000
interactive_timeout=100
wait_timeout=100
connect_timeout=20
thread_cache_size=128
key_buffer=16M
join_buffer=1M
max_allowed_packet=16M
table_cache=1024
sort_buffer_size=2M
read_buffer_size=2M
max_connect_errors=9999
# Try number of CPU's*2 for thread_concurrency
thread_concurrency=2
myisam_sort_buffer_size=64M
server-id=1
innodb_use_sys_malloc =1

[safe_mysqld]
err-log=/var/log/mysqld.log
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash
#safe-updates

[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[mysqlhotcopy]
interactive-timeout

[alg0r!thm]

Lass mich raten diese my.cnf hast du nur von irgendwoher kopiert..
Kommentier mal alles aus und starte den mySQL-Server neu '& den Metin2 Server auch.
Und dann mal guckn obs an der my.cnf liegt, was ich eigentlich sehr schwer vermute.


So far,
Daniiel'

['oShet]

ne war nicht wegen der my.cnf

[alg0r!thm]

Originally Posted by Silfro95

ne war nicht wegen der my.cnf

Also hast du die my.cnf komplett rausgenommen und es kam das selbe?
Das kann eigentlich nicht sein.


So far,
Daniiel'

['oShet]

yap. hab komplett raus genommen, mysql restarted, server gestarted..
dann db wird sofort 100% und einloggen dauert richtig lange..


So jetztgeht alles außer, wenn ich server reboote, und dann mich einlogge dann steht da vol lange " wirst mit server verbunden"

wenn ich mich dann relogge und dann wieder einlogge dann gehts sehr schnell.

Also ist das problem, dass beim ersten einloggen es immer sehr lange dauert..

Und das kommt immer wenn ich server schließe ( sh close.sh)

/libexec/ld-elf.so.1: ./game1_1_CH1: Undefined symbol "shutdown""
/libexec/ld-elf.so.1: /libexec/ld-elf.so.1: ./game99_CH1: Undefined symbol "shutdown""./game2_CH1: Undefined symbol "shutdown""

/libexec/ld-elf.so.1: ./game61_CH1: Undefined symbol "shutdown"
/libexec/ld-elf.so.1: ./game1_3_CH1: Undefined symbol "shutdown""
/libexec/ld-elf.so.1: ./game00_CH1: Undefined symbol "shutdown""

sitze seit ca. 13 stunden dran.. Bitte hilft mir ...

in db syserr steht das

Start: TABLE_POSTFIX not configured use default

hats vllt. was damit zu tun?

... komme bis zur char auswahl fenster dann wähle ich char dann ist es so als ob spiel hängt.. und dann 3 min später wieder beim login bild..

Bin mir 100% sicher hat was mit der datenbank zu tun !!!

Wenn ich server starte kommt keine fehlermeldung ...
wieso???????????????????????

das kommt wenn ich sh close.sh mache

/libexec/ld-elf.so.1: ./game1_2_CH1: Undefined symbol "shutdown"
rm: cores/core.1: No such file or directory
mv: rename cores/core.2 to cores/core.1: No such file or directory
mv: rename cores/core.3 to cores/core.2: No such file or directory
mv: rename cores/core.4 to cores/core.3: No such file or directory
mv: rename cores/core.5 to cores/core.4: No such file or directory
mv: rename cores/core.6 to cores/core.5: No such file or directory
mv: rename ./game1_2_CH1.core to cores/core.6: No such file or directory
/libexec/ld-elf.so.1: ./game1_1_CH1: Undefined symbol "shutdown"
/libexec/ld-elf.so.1: ./game61_CH1: Undefined symbol "shutdown"
/libexec/ld-elf.so.1: ./game99_CH1: Undefined symbol "shutdown"
rm: cores/core.1: No such file or directory
mv: rename cores/core.2 to cores/core.1: No such file or directory
mv: rename cores/core.3 to cores/core.2: No such file or directory
/libexec/ld-elf.so.1: ./game2_CH1: Undefined symbol "shutdown"
/libexec/ld-elf.so.1: ./game1_3_CH1: Undefined symbol "shutdown"
mv: rename cores/core.4 to cores/core.3: No such file or directory
mv: rename cores/core.5 to cores/core.4: No such file or directory
mv: rename cores/core.6 to cores/core.5: No such file or directory
mv: rename ./auth.core to cores/core.6: No such file or directory
rm: cores/core.1: No such file or directory
mv: rename cores/core.2 to cores/core.1: No such file or directory
mv: rename cores/core.3 to cores/core.2: No such file or directory
mv: rename cores/core.4 to cores/core.3: No such file or directory
mv: rename cores/core.5 to cores/core.4: No such file or directory
mv: rename cores/core.6 to cores/core.5: No such file or directory
mv: rename ./game61_CH1.core to cores/core.6: No such file or directory
rm: cores/core.1: No such file or directory
mv: rename cores/core.2 to cores/core.1: No such file or directory
mv: rename cores/core.3 to cores/core.2: No such file or directory
mv: rename cores/core.4 to cores/core.3: No such file or directory
mv: rename cores/core.5 to cores/core.4: No such file or directory
mv: rename cores/core.6 to cores/core.5: No such file or directory
mv: rename ./game1_1_CH1.core to cores/core.6: No such file or directory
rm: cores/core.1: No such file or directory
mv: rename cores/core.2 to cores/core.1: No such file or directory
mv: rename cores/core.3 to cores/core.2: No such file or directory
mv: rename cores/core.4 to cores/core.3: No such file or directory
mv: rename cores/core.5 to cores/core.4: No such file or directory
mv: rename cores/core.6 to cores/core.5: No such file or directory
mv: rename ./game99_CH1.core to cores/core.6: No such file or directory
rm: cores/core.1: No such file or directory
mv: rename cores/core.2 to cores/core.1: No such file or directory
mv: rename cores/core.3 to cores/core.2: No such file or directory
mv: rename cores/core.4 to cores/core.3: No such file or directory
mv: rename cores/core.5 to cores/core.4: No such file or directory
mv: rename cores/core.6 to cores/core.5: No such file or directory
mv: rename ./game2_CH1.core to cores/core.6: No such file or directory
rm: cores/core.1: No such file or directory
mv: rename cores/core.2 to cores/core.1: No such file or directory
mv: rename cores/core.3 to cores/core.2: No such file or directory
/libexec/ld-elf.so.1: ./game00_CH1: Undefined symbol "shutdown"
mv: rename cores/core.4 to cores/core.3: No such file or directory
rm: cores/core.1: No such file or directory
mv: rename cores/core.5 to cores/core.4: No such file or directory
mv: rename cores/core.2 to cores/core.1: No such file or directory
mv: rename cores/core.6 to cores/core.5: No such file or directory
mv: rename cores/core.3 to cores/core.2: No such file or directory
mv: rename ./game1_3_CH1.core to cores/core.6: No such file or directory
mv: rename cores/core.4 to cores/core.3: No such file or directory
mv: rename cores/core.5 to cores/core.4: No such file or directory
mv: rename cores/core.6 to cores/core.5: No such file or directory
mv: rename ./game00_CH1.core to cores/core.6: No such file or directory
rm: cores/core.1: No such file or directory
mv: rename cores/core.2 to cores/core.1: No such file or directory
mv: rename cores/core.3 to cores/core.2: No such file or directory
mv: rename cores/core.4 to cores/core.3: No such file or directory
mv: rename cores/core.5 to cores/core.4: No such file or directory
mv: rename cores/core.6 to cores/core.5: No such file or directory
mv: rename ./db.core to cores/core.6: No such file or directory

KEINE 2010ER FILES !!

['oShet]

.#push
yes I know its not allowed... but ITS IMPORTANT !

[.Pѕєυ∂σηум]

PUSH GENAU DAS SELBE PROBLEM!

[EdwardKta]

Up, same problem!