/spawn combine save Crash

[John Adams]

Not completely sure why this crashed, been /spawn combining all night. I did a /spawn combine add on 3 spawns, then I think I mistakenly de-selected my target and got an warning in the client about how to use /spawn combine.

Re-targeted my primary combine NPC and did /spawn combine save, and crashed the world.

Code: Select all

Unhandled command: clearallqueuedabilities
   0: 01 00 07 00 64 65 74 61 - 69 6C 73                 | ....details
   0: B3 01 00 00                                        | ....
Unhandled command: clearallqueuedabilities
   0: 01 00 07 00 64 65 74 61 - 69 6C 73                 | ....details
   0: 41 00 06 00 73 70 61 77 - 6E 73                    | A...spawns
[Status] Loaded 525 entity command lists.
[Status] Loaded 7152 NPC(s).
[Status] Loaded 1440 Object(s).
[Status] Loaded 124 GroundSpawn(s).
[Status] Loaded 796 Widget(s).
[Status] Loaded 1111 Sign(s).
[Status] Loading ground spawn items..
[Status] Loading loot data..
[Status]        Loaded 6 loot tables.
[Status]        Loaded 8 loot drops.
[Status]        Loaded 4 spawn loot lists.
[Status] Loading Transporter Information..
[Status]        Loaded 25 Teleporter(s)
Loaded 1183 NPC(s), 167 Object(s), 1 Widget(s), 41 Sign(s), 386 GroundSpawn(s)
        Also loaded 12 Spawn Group(s), 3 Spawn Group Association(s), and 0 Spawn                                                                                                                                Group Chances.
   0: B3 01 00 00                                        | ....
Unhandled command: clearallqueuedabilities
   0: 25 00 01 00 30                                     | %...0
   0: B3 01 00 00                                        | ....
Unhandled command: clearallqueuedabilities
   0: 01 00 0B 00 63 6F 6D 62 - 69 6E 65 20 61 64 64     | ....combine add
   0: B3 01 00 00                                        | ....
Unhandled command: clearallqueuedabilities
   0: 25 00 01 00 30                                     | %...0
   0: B3 01 00 00                                        | ....
Unhandled command: clearallqueuedabilities
   0: 01 00 0B 00 63 6F 6D 62 - 69 6E 65 20 61 64 64     | ....combine add
   0: B3 01 00 00                                        | ....
Unhandled command: clearallqueuedabilities
   0: 25 00 01 00 30                                     | %...0
   0: B3 01 00 00                                        | ....
Unhandled command: clearallqueuedabilities
   0: 01 00 0B 00 63 6F 6D 62 - 69 6E 65 20 61 64 64     | ....combine add
   0: B3 01 00 00                                        | ....
Unhandled command: clearallqueuedabilities
   0: 25 00 01 00 30                                     | %...0
   0: 01 00 0C 00 63 6F 6D 62 - 69 6E 65 20 73 61 76 65  | ....combine save
   0: B3 01 00 00                                        | ....
Unhandled command: clearallqueuedabilities
   0: 01 00 0C 00 63 6F 6D 62 - 69 6E 65 20 73 61 76 65  | ....combine save

Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 0xb3ca2b90 (LWP 29182)]
strlen () at ../sysdeps/i386/i486/strlen.S:69
69      L(1):   movl (%eax), %ecx       /* get word (= 4 bytes) in question */
Current language:  auto; currently asm
(gdb) bt
#0  strlen () at ../sysdeps/i386/i486/strlen.S:69
#1  0x002ea4e0 in _IO_vfprintf_internal (s=0x4174c0,
    format=0x81f56b0 "Error in SaveSpawnEntry query '%s': %s",
    ap=0xb3ca0f04 "(") at vfprintf.c:1581
#2  0x0810547d in EQEMuLog::write (this=0x82452c0, id=EQEMuLog::Error,
    fmt=0x81f56b0 "Error in SaveSpawnEntry query '%s': %s")
    at ../common/debug.cpp:149
#3  0x08120560 in WorldDatabase::SaveSpawnEntry (this=0x822c720,
    spawn=0xee1d960,
    spawn_location_name=0x81f0b87 "Combine SpawnGroup Generated",
    percent=40 '(', save_zonespawn=true, create_spawnlocation=false)
    at WorldDatabase.cpp:2219
#4  0x08120975 in WorldDatabase::SaveCombinedSpawnLocation (this=0x822c720,
    zone=0xeb44408, in_spawn=0xee1d960, name=0x0) at WorldDatabase.cpp:2187
#5  0x080dbce9 in Client::SaveCombineSpawns (this=0xfb9aad0, name=0x0)
    at client.cpp:2847
#6  0x080a7644 in Commands::Process (this=0x822c65c, index=1,
    command_parms=0xb3ca20f4, client=0xfb9aad0) at Commands.cpp:1902
#7  0x080eb584 in Client::HandlePacket (this=0xfb9aad0, app=0x15f314e0)
    at client.cpp:1022
#8  0x080ebb5f in Client::Process (this=0xfb9aad0, zone_process=true)
    at client.cpp:1406
#9  0x081675ff in ZoneServer::ClientProcess (this=0xeb44408)
---Type <return> to continue, or q <return> to quit---
    at zoneserver.cpp:1630
#10 0x0816ef15 in ZoneServer::Process (this=0xeb44408) at zoneserver.cpp:802
#11 0x0816f3b2 in ZoneLoop (tmp=0xeb44408) at zoneserver.cpp:3332
#12 0x0042a51f in start_thread (arg=0xb3ca2b90) at pthread_create.c:297
#13 0x0038b04e in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130
(gdb)

When I went back into the world, the 3 spawns I had been working with did not spawn I think it crashed after deleting the original spawn_location* info?

[LethalEncounter]

There was an sql error when it was trying to insert into spawn_location_entry. World tried to print it out but the line should have been:
LogFile->write(EQEMuLog::Error, "Error in SaveSpawnEntry query '%s': %s", query.GetQuery(), query.GetError());

instead it was:
LogFile->write(EQEMuLog::Error, "Error in SaveSpawnEntry query '%s': %s", query.GetQuery());

[John Adams]

Hmm... sql error? I changed no tables on my end. I guess we'll watch for it, if you're printing the error now it shouldn't be hard to find.

You sure it wasn't related to me /spawn combine'ing a bunch of stuff, then de-targetting, then trying to /spawn combine save (on nothing)? I'll try it again just to see.

[LethalEncounter]

You sure it wasn't related to me /spawn combine'ing a bunch of stuff, then de-targetting, then trying to /spawn combine save (on nothing)? I'll try it again just to see.

I'm positive, look at the stacktrace you posted. It crashed when it was printing the error because it was missing the error text.

[John Adams]

Ohhh, now I gotcha. Bad LE, bad! ~rolls up newspaper~