Somehow I missed your reply Lex, much appreciated ! And yes that was causing one of the zone crashes, I source in quests and copied my custom quest over on top of those and it fixed those errors.
Now I have one more regarding bots. Players can use old bots just fine, but if we create new bots and spawn them right after they spawn they cause the zone to crash.
And first glance I would say it was something to do with the new bot timer table but I sourced that in again and all of my SQL is up to date. I wonder if this could be a linux only issue ? I know Linux is more picky on upper / lower case on the tables.
BT dump.....
Code:
#0 0x00007f379a4426d2 in ?? () from /lib/libc.so.6
#1 0x00007f379a43fdc0 in atoi () from /lib/libc.so.6
#2 0x00000000009f1732 in Bot::LoadTimers (this=0x2841300) at bot.cpp:4272
#3 0x00000000009e5114 in Bot (this=0x2841300, botID=905,
botOwnerCharacterID=525, botSpellsID=0, totalPlayTime=0, lastZoneId=189,
npcTypeData=...) at bot.cpp:159
#4 0x00000000009f9b68 in Bot::LoadBot (botID=905, errorMessage=0x7fff06e2d5a0)
at bot.cpp:6019
#5 0x0000000000a14702 in Bot::ProcessBotCommands (c=0x7f378812db20,
sep=0x7fff06e2dbf0) at bot.cpp:12742
#6 0x000000000072389b in command_bot (c=0x7f378812db20, sep=0x7fff06e2dbf0)
at command.cpp:10977
#7 0x00000000006ef85b in command_realdispatch (c=0x7f378812db20,
message=0x2814094 "#bot spawn bot") at command.cpp:681
#8 0x00000000005d4ac1 in Client::ChannelMessageReceived (this=0x7f378812db20,
chan_num=8 '\b', language=0 '\000', lang_skill=100 'd',
message=0x2814094 "#bot spawn bot", targetname=0x2814000 "")
at client.cpp:975
#9 0x0000000000747268 in Client::Handle_OP_ChannelMessage (
this=0x7f378812db20, app=0x241a390) at client_packet.cpp:3522
#10 0x000000000073a720 in Client::HandlePacket (this=0x7f378812db20,
app=0x241a390) at client_packet.cpp:460
#11 0x00000000005ff8c6 in Client::Process (this=0x7f378812db20)
---Type <return> to continue, or q <return> to quit---
at client_process.cpp:681
#12 0x000000000059a831 in EntityList::MobProcess (this=0xd81ca0)
at entity.cpp:488
#13 0x00000000006174bb in main (argc=3, argv=0x7fff06e2e2f8) at net.cpp:479
BT FULL
Code:
Core was generated by `./zone dynamic_25 zone'.
Program terminated with signal 11, Segmentation fault.
#0 0x00007f379a4426d2 in ?? () from /lib/libc.so.6
(gdb) bt full
#0 0x00007f379a4426d2 in ?? () from /lib/libc.so.6
No symbol table info available.
#1 0x00007f379a43fdc0 in atoi () from /lib/libc.so.6
No symbol table info available.
#2 0x00000000009f1732 in Bot::LoadTimers (this=0x2841300) at bot.cpp:4272
TimerID = 0
Value = 0
MaxValue = 0
DatasetResult = 0x2801de0
errorMessage = {static npos = 18446744073709551615,
_M_dataplus = {<std::allocator<char>> = {<__gnu_cxx::new_allocator<cha r>> = {<No data fields>}, <No data fields>}, _M_p = 0x7f379b899138 ""}}
Query = 0x281e950 "SELECT bt.TimerID, bt.Value, MAX(sn.recast_time) AS M axTimer FROM bottimers bt, spells_new sn WHERE bt.BotID = 905 AND sn.EndurTimerI ndex = (SELECT case WHEN TimerID > 15 THEN TimerID - 1 ELSE TimerID"...
TempErrorMessageBuffer = "\000\000\000\000\000\000\000\000K\000\000\000\ 000\000\000\000\006\000\000\000\000\000\000\000\n\000\000\000\000\000\000\000X<\ 204\002\000\000\000\000\000\304\342\006\377\177\000\000X<\204\002\000\000\000\00 0\000\304\342\006\377\177\000\000\020\304\342\006\377\177\000\000\352\335m", '\0 00' <repeats 13 times>, "P<\204\002\000\000\000\000X<\204\002\000\000\000\000@\3 04\342\006\377\177\000\000`\304\342\006\377\177\000\000\265\335m\000\000\000\000 \000X<\204\002\000\000\000\000P\304\342\006\377\177\000\000`\304\342\006\377\177 \000\000\352\335m\000\000\000\000\000X<\204\002\000\000\000\000P<\204\002\000\00 ---Type <return> to continue, or q <return> to quit---^CQuit
(gdb)
#0 0x00007f379a4426d2 in ?? () from /lib/libc.so.6
No symbol table info available.
#1 0x00007f379a43fdc0 in atoi () from /lib/libc.so.6
No symbol table info available.
#2 0x00000000009f1732 in Bot::LoadTimers (this=0x2841300) at bot.cpp:4272
TimerID = 0
Value = 0
MaxValue = 0
DatasetResult = 0x2801de0
errorMessage = {static npos = 18446744073709551615,
_M_dataplus = {<std::allocator<char>> = {<__gnu_cxx::new_allocator<char>> = {<No data fields>}, <No data fields>}, _M_p = 0x7f379b899138 ""}}
Query = 0x281e950 "SELECT bt.TimerID, bt.Value, MAX(sn.recast_time) AS MaxTimer FROM bottimers bt, spells_new sn WHERE bt.BotID = 905 AND sn.EndurTimerIndex = (SELECT case WHEN TimerID > 15 THEN TimerID - 1 ELSE TimerID"...
TempErrorMessageBuffer = "\000\000\000\000\000\000\000\000K\000\000\000\000\000\000\000\006\000\000\000\000\000\000\000\n\000\000\000\000\000\000\000X<\204\002\000\000\000\000\000\304\342\006\377\177\000\000X<\204\002\000\000\000\000\000\304\342\006\377\177\000\000\020\304\342\006\377\177\000\000\352\335m", '\000' <repeats 13 times>, "P<\204\002\000\000\000\000X<\204\002\000\000\000\000@\304\342\006\377\177\000\000`\304\342\006\377\177\000\000\265\335m\000\000\000\000\000X<\204\002\000\000\000\000P\304\342\006\377\177\000\000`\304\342\006\377\177\000\000\352\335m\000\000\000\000\000X<\204\002\000\000\000\000P<\204\002\000\00---Type <return> to continue, or q <return> to quit---
0\000\000X<\204\002", '\000' <repeats 12 times>"\200, \304\342\006\377\177\000\000Z\323m\000\000\000\000\000\260\304\342\006\377\177\000\000\300\304\342\006\377\177\000\000\320\304\342\006\377\177\000\000\006\216m", '\000' <repeats 13 times>, "8\035\330\000\025\000\000\000P<\204\002\000\000\000\000"...
DataRow = 0x2843ef8
#3 0x00000000009e5114 in Bot (this=0x2841300, botID=905,
botOwnerCharacterID=525, botSpellsID=0, totalPlayTime=0, lastZoneId=189,
npcTypeData=...) at bot.cpp:159
TempErrorMessage = {static npos = 18446744073709551615,
_M_dataplus = {<std::allocator<char>> = {<__gnu_cxx::new_allocator<char>> = {<No data fields>}, <No data fields>}, _M_p = 0x7f379b899138 ""}}
#4 0x00000000009f9b68 in Bot::LoadBot (botID=905, errorMessage=0x7fff06e2d5a0)
at bot.cpp:6019
DefaultNPCTypeStruct = {
name = "bot\000\067\177\000\000\314\321\342\006\377\177\000\000\204lÔ7\177", '\000' <repeats 26 times>, "P\315\342\006\377\177\000\000\060\325\305\001\000\000\000",
lastname = "\000\321\342\006\377\177\000\000 \000\000\000\000\000\000\000\300\321\342\006\377\177\000\000\260\315\342\006\377\177\000\000\260\314\342\006\377\177\000\000\300F[\000\000\000\000\000\060\325\305\001\002\000\000\000\260\315\342\006\377\177\000\000\320\314\342\006\377\177", cur_hp = 0,
max_hp = 2147419874, size = 6, runspeed = 1.25, gender = 0 '\000',
race = 1, class_ = 1 '\001', bodytype = 1 '\001', deity = 0 '\000',
---Type <return> to continue, or q <return> to quit---
level = 1 '\001', npc_id = 0, texture = 0 '\000',
helmtexture = 226 '\342', loottable_id = 8388358, npc_spells_id = 0,
npc_faction_id = 8388358, merchanttype = 3805130752,
alt_currency_type = 8388358, adventure_template = 2730867456,
trap_template = 0, light = 0 '\000', AC = 12, Mana = 2147419874,
ATK = 75, STR = 75, STA = 75, DEX = 75, AGI = 75, INT = 75,
WIS = 75, CHA = 75, MR = 25, FR = 25, CR = 25, PR = 15, DR = 15,
Corrup = 15, haircolor = 226 '\342', beardcolor = 6 '\006',
eyecolor1 = 255 '\377', eyecolor2 = 127 '\177',
hairstyle = 0 '\000', luclinface = 0 '\000', beard = 176 '\260',
drakkin_heritage = 0, drakkin_tattoo = 0, drakkin_details = 0,
armor_tint = {436207743, 23221, 2952790016, 4278641357, 2952790143,
4278641357, 1879048319, 4278641357, 1677721727}, min_dmg = 23221,
max_dmg = 2952790016, attack_count = -7475,
npc_attacks = "\006\377\177\000\000\260\315\342\006\377\177\000\000\r\002\000\000\000\000\000\000\030'\300\001\000\000\000\000\220",
d_meele_texture1 = 0, d_meele_texture2 = 0,
prim_melee_type = 127 '\177', sec_melee_type = 0 '\000',
hp_regen = 1, mana_regen = 1, aggroradius = -1071179776,
see_invis = 1 '\001', see_invis_undead = false, see_hide = false,
see_improved_hide = false, qglobal = false, npc_aggro = 176,
spawn_limit = 205 '\315', mount_color = 226 '\342',
attack_speed = 0, accuracy_rating = -489824256, findable = false,
---Type <return> to continue, or q <return> to quit---
trackable = 255, slow_mitigation = -7.4506934e-09,
maxlevel = 1 '\001', scalerate = 159, private_corpse = false,
unique_spawn_by_name = false, underwater = 160, emoteid = 4278641365}
TempNPCStruct = {
name = "bot\000\377\177\000\000\335ri", '\000' <repeats 13 times>, "@~v\232\067\177\000\000\000\000\000\000\000\000\000\000@~v\232\067\177\000\000\000\000\000\000\000\000\000\000\030'\300\001\000\000\000",
lastname = "\000'\300\001\000\000\000\000\352\f", '\000' <repeats 14 times>, "L\030H\232\067\177\000\000\b\023\200\002\000\000\000\000@~v\232\067\177\000\000\340\315\342\006\377\177\000\000\030'\300\001\000\000\000\000H'\300\001\000", cur_hp = 37, max_hp = 0, size = 6, runspeed = 1.25, gender = 0 '\000',
race = 1, class_ = 1 '\001', bodytype = 1 '\001',
deity = 154 '\232', level = 1 '\001', npc_id = 0,
texture = 0 '\000', helmtexture = 226 '\342',
loottable_id = 8388358, npc_spells_id = 0, npc_faction_id = 0,
merchanttype = 0, alt_currency_type = 0, adventure_template = 0,
trap_template = 0, light = 0 '\000', AC = 12, Mana = 0, ATK = 75,
STR = 75, STA = 75, DEX = 75, AGI = 75, INT = 75, WIS = 75,
CHA = 75, MR = 25, FR = 25, CR = 25, PR = 15, DR = 15, Corrup = 15,
haircolor = 6 '\006', beardcolor = 10 '\n', eyecolor1 = 7 '\a',
eyecolor2 = 7 '\a', hairstyle = 0 '\000', luclinface = 3 '\003',
beard = 2 '\002', drakkin_heritage = 0, drakkin_tattoo = 0,
drakkin_details = 0, armor_tint = {3221225472, 163858, 0, 0,
---Type <return> to continue, or q <return> to quit---
218103808, 4278190082, 127, 0, 3758096384}, min_dmg = 4278641363,
max_dmg = 1660944511, attack_count = -10970,
npc_attacks = "\232\067\177\000\000H\322D\232\067\177\000\000\001\000\000\000\000\000\000\000d&Õ7\177\000\000d", d_meele_texture1 = 0,
d_meele_texture2 = 0, prim_melee_type = 127 '\177',
sec_melee_type = 0 '\000', hp_regen = 1, mana_regen = 1,
aggroradius = 24576, see_invis = 0 '\000', see_invis_undead = false,
see_hide = false, see_improved_hide = false, qglobal = false,
npc_aggro = 19, spawn_limit = 36 '$', mount_color = 72 'H',
attack_speed = 0, accuracy_rating = -489594880, findable = false,
trackable = 255, slow_mitigation = 2.00003028, maxlevel = 1 '\001',
scalerate = 0, private_corpse = false, unique_spawn_by_name = false,
underwater = 8, emoteid = 4278641362}
Query = 0x28151d0 "SELECT BotOwnerCharacterID, BotSpellsID, Name, LastName, BotLevel, Race, Class, Gender, Size, Face, LuclinHairStyle, LuclinHairColor, LuclinEyeColor, LuclinEyeColor2, LuclinBeardColor, LuclinBeard, Dr"...
TempErrorMessageBuffer = "\000\000\000\000\000\000\000\000T\362G\232\067\177\000\000\020 \000\000\000\000\000\000\345r\000\233\067\177\000\000\060i\201\002j\000\000\000\005\000\000\000\000\000\000\000\200M7\002\000\000\000\000\310\305.\001", '\000' <repeats 12 times>"\257, \200\000\233\067\177\000\000\000\000\000\000j\000\000\000\200\311\342\006\377\177\000\000/\311\342\006\377\177\000\000p\000\000\001\002\000\000\000\310\310.\001\000\000\000\000\030\000\000\000\000\000\000\000@~v\232\067\177\000\000\310\305.\001\000\000\000\000\377\377\377\377\3---Type <return> to continue, or q <return> to quit---
77\377\377\377\200\311\342\006\377\177\000\000\000\000\000\000\000\000\000\000\020Ô\002\000\000\000\000\240\263\200\002\000\000\000\000\255\214\000\233\067\177\000\000\240E\201\002\000\000\000\000\340\037", '\000' <repeats 14 times>"\262, \231\375\232\067\177\000\000\000\000\000\000\000\000\000\000\310\305.\001\000\000\000\000\377\377\377\377\377\377\377\377", '\000' <repeats 16 times>, "\020Ô\002\000\000\000\000\240"...
DatasetResult = 0x24965d0
DataRow = 0x280b3b8
Result = 0x0
#5 0x0000000000a14702 in Bot::ProcessBotCommands (c=0x7f378812db20,
sep=0x7fff06e2dbf0) at bot.cpp:12742
botId = 905
TempBotMob = 0x0
spawnedBotCount = 0
TempBot = 0x101c5d530
TempErrorMessage = {static npos = 18446744073709551615,
_M_dataplus = {<std::allocator<char>> = {<__gnu_cxx::new_allocator<char>> = {<No data fields>}, <No data fields>}, _M_p = 0x7f379b899138 ""}}
#6 0x000000000072389b in command_bot (c=0x7f378812db20, sep=0x7fff06e2dbf0)
at command.cpp:10977
No locals.
#7 0x00000000006ef85b in command_realdispatch (c=0x7f378812db20,
message=0x2814094 "#bot spawn bot") at command.cpp:681
---Type <return> to continue, or q <return> to quit---
sep = {argnum = 2, arg = 0x28216b0, argplus = 0x24d2490,
msg = 0x258d5a0 "#bot spawn bot", maxargnum = 10}
cstr = {static npos = 18446744073709551615,
_M_dataplus = {<std::allocator<char>> = {<__gnu_cxx::new_allocator<char>> = {<No data fields>}, <No data fields>}, _M_p = 0x23b9788 "bot"}}
cur = 0x1c3ec90
#8 0x00000000005d4ac1 in Client::ChannelMessageReceived (this=0x7f378812db20,
chan_num=8 '\b', language=0 '\000', lang_skill=100 'd',
message=0x2814094 "#bot spawn bot", targetname=0x2814000 "")
at client.cpp:975
sender = 0x7f379a767e40
#9 0x0000000000747268 in Client::Handle_OP_ChannelMessage (
this=0x7f378812db20, app=0x241a390) at client_packet.cpp:3522
cm = 0x2814000
#10 0x000000000073a720 in Client::HandlePacket (this=0x7f378812db20,
app=0x241a390) at client_packet.cpp:460
p = 0x7470f2 <Client::Handle_OP_ChannelMessage(EQApplicationPacket const*)>
opcode = OP_ChannelMessage
#11 0x00000000005ff8c6 in Client::Process (this=0x7f378812db20)
at client_process.cpp:681
ret = true
app = 0x241a390
---Type <return> to continue, or q <return> to quit---
#12 0x000000000059a831 in EntityList::MobProcess (this=0xd81ca0)
at entity.cpp:488
iterator = {list = @0xd81d08, current_element = 0x7f37880008f0,
dir = FORWARD}
#13 0x00000000006174bb in main (argc=3, argv=0x7fff06e2e2f8) at net.cpp:479
error2 = 95 '_'
dbaw = 0x0
zone_name = 0xa4556d "."
retval = 252
pxs = 0x1c5ced0
stream_identifier = {
m_patches = {<std::_Vector_base<EQStreamIdentifier::Patch*, std::allocator<EQStreamIdentifier::Patch*> >> = {
_M_impl = {<std::allocator<EQStreamIdentifier::Patch*>> = {<__gnu_cxx::new_allocator<EQStreamIdentifier::Patch*>> = {<No data fields>}, <No data fields>}, _M_start = 0x7f3788042f50, _M_finish = 0x7f3788042fa0,
_M_end_of_storage = 0x7f3788042fd0}}, <No data fields>},
m_streams = {<std::_Vector_base<EQStreamIdentifier::Record*, std::allocator<EQStreamIdentifier::Record*> >> = {
_M_impl = {<std::allocator<EQStreamIdentifier::Record*>> = {<__gnu_cxx::new_allocator<EQStreamIdentifier::Record*>> = {<No data fields>}, <No data fields>}, _M_start = 0x7f37880a59b0, _M_finish = 0x7f37880a59b0,
_M_end_of_storage = 0x7f37880a59b8}}, <No data fields>},
---Type <return> to continue, or q <return> to quit---
m_identified = {
c = {<std::_Deque_base<EQStreamInterface*, std::allocator<EQStreamInterface*> >> = {
_M_impl = {<std::allocator<EQStreamInterface*>> = {<__gnu_cxx::new_allocator<EQStreamInterface*>> = {<No data fields>}, <No data fields>},
_M_map = 0x1d141f0, _M_map_size = 8, _M_start = {
_M_cur = 0x20c0898, _M_first = 0x20c0890,
_M_last = 0x20c0a90, _M_node = 0x1d14208}, _M_finish = {
_M_cur = 0x20c0898, _M_first = 0x20c0890,
_M_last = 0x20c0a90,
_M_node = 0x1d14208}}}, <No data fields>}}}
worldwasconnected = true
Config = 0x1c01900
InterserverTimer = {start_time = 10002, timer_time = 10000,
enabled = true, set_at_trigger = 10000, pUseAcurateTiming = false}
quest_timers = {start_time = 19339, timer_time = 100, enabled = true,
set_at_trigger = 100, pUseAcurateTiming = false}
eqsi = 0x0
temp_timer = {start_time = 19377, timer_time = 10, enabled = true,
set_at_trigger = 10, pUseAcurateTiming = false}
ps = 0x1c5aee0
eqss = 0x0
|