Jump to content
×
×
  • Create New...
  • 0

Clean 34k files db start problem


MasterSticQ

Question

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:

[email protected]:/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

Link to comment
Share on other sites

  • Answers 7
  • Created
  • Last Reply

Top Posters For This Question

Popular Days

Top Posters For This Question

7 answers to this question

Recommended Posts

  • 0

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.

Link to comment
Share on other sites

  • 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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • 0
  • Premium

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.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.