Channels dying when attacking mobs on Yongbi Desert

[iderx 0]

This is what im gettin in ch12 SysErr after i get kicked out after attacking mobs\spiders and i cant reconnect to that map
(i tried entering the desert with another character but it also just kicked me out and i couldnt log in with that character, the only temporery solution i found is to after every channel dies when i try to farm stuff , i restart the server and i do it just like this over and over )

Quote

SYSERR: Jul  9 04:33:04 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'what' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 0, 1657420384, 0, 2160000281, 'SET_SOCKET', '', '', 30270) errno: 1264)
SYSERR: Jul  9 04:33:04 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'what' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 0, 1657420384, 0, 2160000277, 'SET_SOCKET', '', '', 30270) errno: 1264)
SYSERR: Jul  9 04:33:08 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'what' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 0, 0, 2180001756, 'SET_SOCKET', '', '', 164040) errno: 1264)
SYSERR: Jul  9 04:33:08 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'what' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 58856, 280654, 618133, 2180001756, 'DS_ACTIVATE', 'LEFT TIME(5760)', '25.50.94.43', 164040) errno: 1264)
SYSERR: Jul  9 04:33:08 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'what' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 1, 0, 2180001756, 'SET_SOCKET', '', '', 164040) errno: 1264)
SYSERR: Jul  9 04:34:08 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'what' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 0, 5700, 0, 2180001756, 'SET_SOCKET', '', '', 164040) errno: 1264)
SYSERR: Jul  9 04:35:08 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'what' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 0, 5640, 0, 2180001756, 'SET_SOCKET', '', '', 164040) errno: 1264)
 

This is what im getting in Ch99 SysErr
 

Quote

SYSERR: Jul  9 04:32:18 :: regen_load: No mob data by vnum 20400
SYSERR: Jul  9 04:32:18 :: SpawnMob: SpawnMob: no mob data for vnum 20400
SYSERR: Jul  9 04:33:41 :: SpawnMob: SpawnMob: no mob data for vnum 20400
SYSERR: Jul  9 04:35:11 :: SpawnMob: SpawnMob: no mob data for vnum 20400
SYSERR: Jul  9 04:36:41 :: SpawnMob: SpawnMob: no mob data for vnum 20400
 

and this is what im getting in Db SysErr
 

Quote

SYSERR: Jul  9 04:35:35 :: Process: FDWATCH: peer null in event: ident 21

And this is what i found in SysLog inside Ch12 folder 
 

Quote

SYSERR: Jul  9 04:35:08 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'what' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 0, 5640, 0, 2180001756, 'SET_SOCKET', '', '', 164040) errno: 1264)
Jul  9 04:35:14 :: SpawnMob: cannot create monster at non-exist sectree 405100 x 656600 (map 61)
 

And after i get kicked out of the server i checked the Server\Machine and typed ps 
Before i got kicked out, all channels were working and i could see them on when i typed ps,
but after i got kicked out 
Ch12 wasn't on the list when i typed ps
(later after i got kicked out on other channels i also checked and ch22 ch32 and ch42 also died\turned off\Crashed and had the same error that ch12 had)

I dont really know what is wrong with this 
Im playing on Terenzo files
 

[m2Ciaran 285]

Debug the core and show results

How To Use GDB for your game.core for Debug - Guides & HowTo - Metin2 Dev

Edited July 9, 2022 by m2Ciaran

[WeedHex 627]

CH12? Maybe you are in overflow. Needed gdb!

#ps afxu  Would be better however

[thax 4]

2 hours ago, iderx said:

Im playing on Terenzo files

 

mob_proto > 2001 (young spider) > set hp more than 0

 

 

 

 

[iderx 0]

1 hour ago, thax said:

set hp more than 0

Earlier, i was farming for about 15 seconds max and bam it crashed

Set hp for 2002 (Poison Spider had 0 ) in mob_proto in navicat
and it looks like the problem has been fixed for now. 
I was farming spiders for about 5 min and it didnt crash once. 
Thanks a lot 

 

[Syreldar 1830]

SELECT `locale_name`, `max_hp` FROM `player`.`mob_proto` WHERE `max_hp` = 0 AND (`type` = 0 OR `type` = 2);

This makes you see all the monsters and metins that have a bugged max_hp value in your proto, so you can fix them manually.

but, If you want to temporarily fix them all automatically, you can run this:
 

UPDATE `player`.`mob_proto` SET `max_hp` = 100 WHERE `max_hp` = 0 AND (`type` = 0 OR `type` = 2);

 

Edited July 9, 2022 by Syreldar

[iderx 0]

thanks 
I checked and i do not have any more bugged values 
Looks like everything is working as it should

1 hour ago, Syreldar said:

SELECT `locale_name`, `max_hp` FROM `player`.`mob_proto` WHERE `max_hp` = 0 AND (`type` = 0 OR `type` = 2);

This makes you see all the monsters and metins that have a bugged max_hp value in your proto, so you can fix them manually.

but, If you want to temporarily fix them all automatically, you can run this:
 

UPDATE `player`.`mob_proto` SET `max_hp` = 100 WHERE `max_hp` = 0 AND (`type` = 0 OR `type` = 2);