Clean 34k files db start problem

[MasterSticQ 0]

Hi..

Firstly i would thank you for opening this thread. I have problem with starting database in server files. Connect to MySQL is working. My problem is that when i use ./db then output is:

root@Tora:/usr/metin2/game/db # ./db
Test Server
Log OffAsyncSQL: connected to localhost (reconnect 1)
Success PLAYER
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
Success ACCOUNT
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
Success COMMON
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
Success HOTBACKUP
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
▒׽▒Ʈ ▒▒▒▒▒▒ ▒▒▒ϴ▒. ▒״▒▒ ▒▒▒▒▒մϴ▒.
▒׽▒Ʈ ▒▒▒▒▒▒ ▒▒▒ϴ▒. ▒״▒▒ ▒▒▒▒▒մϴ▒.
item_proto_test.txt ▒▒▒▒▒ ▒о▒▒▒▒ ▒▒▒߽▒ϴ▒
item_proto_test.txt ▒▒▒▒▒ ▒о▒▒▒▒ ▒▒▒߽▒ϴ▒
Abort (core dumped)

If i use "sh run.sh" then db tries to start over and over again and does the same thing. 

Syserr ->

SYSERR: Apr  7 19:04:30 :: pid_init: 
Start of pid: 29916

SYSERR: Apr  7 19:04:30 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Apr  7 19:04:30 :: ChildLoop: AsyncSQL: query failed: Data truncated for column 'setImmuneFlag' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (2092, "´ë¿Õ°Å¹Ì", "Spider King", 0, 5

Last lines of sysout(before loading of mobs and others):

Apr  7 19:04:31 :: SYSTEM: BINDING TCP PORT ON [15500] (fd 19)
Apr  7 19:04:31 :: ACCEPT_HANDLE: 19
Apr  7 19:04:31 :: PLAYER_DELETE_LEVEL_LIMIT set to 70
Apr  7 19:04:31 :: PLAYER_DELETE_LEVEL_LIMIT_LOWER set to 0
Apr  7 19:04:31 :: CHINA_EVENT_SERVER false
Apr  7 19:04:31 :: EventFlag Load oxevent_status 0
Apr  7 19:04:31 ::    OK
Apr  7 19:04:31 :: POWER_POLY: 
Apr  7 19:04:31 :: HANDICAP_POLY: 
Apr  7 19:04:31 :: MarriageList(size=0)
Apr  7 19:04:31 :: BLOCKED_IP : 127 - 127
Apr  7 19:04:31 :: SIGNAL: SIGSEGV

I would be really grateful if someone know how to help me with this. If someone want a better communication, then you can add me on skype: mastersticq

[JachuPL 308]

try installing gdb from ports. Then debug db with it as shown here 


and show us the console output after typing "bt full". Remember, it's important to have unstripped db file to perform this.

[MasterSticQ 0]

Thanks for some help.. Here's the the output:

#0  0x2839591b in thr_kill () from /usr/lib32/libc.so.7
No symbol table info available.
#1  0x28321b4b in raise () from /usr/lib32/libthr.so.3
No symbol table info available.
#2  0x2846f626 in abort () from /usr/lib32/libc.so.7
No symbol table info available.
#3  0x0804ea74 in emergency_sig (sig=<value optimized out>) at Main.cpp:61
No locals.
#4  0x28322507 in swapcontext () from /usr/lib32/libthr.so.3
No symbol table info available.
#5  0x28321f88 in sigaction () from /usr/lib32/libthr.so.3
No symbol table info available.
#6  0xffffe194 in ?? ()
No symbol table info available.
#7  0x0000000b in ?? ()
No symbol table info available.
#8  0x283b5830 in strdup () from /usr/lib32/libc.so.7
No symbol table info available.
#9  0x0809ab7c in CBlockCountry::Load (this=0xffffdb7c) at BlockCountry.cpp:92
        login = 0x0
        szQuery = "SELECT login FROM block_exception000E FROM iptocountry000▒▒▒metin2000▒201▒034(000]3(000]3(▒204 b▒0G(▒▒035(▒▒▒▒▒f034(t▒035(h▒▒▒▒▒▒▒001000000000000000000000h▒▒▒hotbackup000000000▒035(001000000000'f034(▒▒035(<▒▒▒▒▒▒▒▒035(h▒▒▒177022000000200▒▒(PP▒(000000000000000000000000localhost000035(200P▒("...
        pMsg = (SQLMsg *) 0x2b26e850

[Fr3zy94 59]

check start.sh

[MasterSticQ 0]

check start.sh

I am not a real dumb and this message really won't help me  

[JachuPL 308]

an error occurs at BlockCountry, so check in mysql table "iptocountry". Try to clear it and launch db again

[MasterSticQ 0]

You were right, thank for fixing this, but there's another problem. The DB starts only if i delete table "iptocountry". If i put it back in MySQL, then db won't launch.. Any ideas how to fix this? :-/ I tried to repair the table or put some lines in it and without any result. DB file always gets aborted..

[frdx64 0]

Hello in mob_proto you have this error :

 

SYSERR: Apr  7 19:04:30 :: ChildLoop: AsyncSQL: query failed: Data truncated for column 'setImmuneFlag' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (2092, "´ë¿Õ°Å¹Ì", "Spider King", 0, 5

 

change mob_proto and test.