madmax

Talking to @H0zen the logging system can cause massive amounts of lag in-game to players. I have experience this with living world and a debug build, even with the log level set to 1 the core is still swarmed with log messages that are not seen. To smooth things out we need to move all console/log messages to their own thread. This will allow the core some room to breath and get on with actually serving the players in-game. Simple test of this is to load living world up in a debug core, even with logging disabled, you will experience a 2-3 minute wait getting onto just the character screen due to all the messages running in the background on the core taking up its process etc. h0zen has suggested that logged messages should be in their own thread and in a queue system of some kind. This issue is to investigate this further and see what can be done to improve logging stability with lots of core actions happening.

Just confirmed a crash on Covenant. NPCs that die from an AURA that causes the final blow crashes the core instantly. To test I went to .go xyz -10305.575195 2035.000977 11.129031 On a crawler there I used .npc changelevel 1 Got a level 12 player to hit the crawler with shadowword: pain No other damage done, when the crawler dies from the aura the core crashes immediately. https://gyazo.com/20edec4649df8235ff5d68ee0049b94d Crash dump in private comment below (only mangos devs will see the dump files).

Got a core crash on Covenant TBC server (Mangos ONE). Visual Studio showed it stopped on G3D Vector. Server source code and dump file is below in hidden comment (only accessible to Mangos Team members).

THIS ISSUE MAY APPLY CROSS-CORE (ONE,TWO ETC) This issue is confirmed by Antz and myself, we mass marked 1600 accounts at covenant for deletion as part of a cleanup process, only the entries in the character table were removed and no other character data was removed. Issue: After marking characters as deleted (setting a unix date under "DeletedDate" in the Characters table in the Characters database the deletion routine does not remove character data from other character tables. Data has been observed to not be removed from character_queststatus, Character_inventory Character deletion commands - server console: You can do "help character delete" to get more info. character delete list lists deleted characters character delete old deletes all characters marked for deletion, even if you have the setting at 0 to disable it, this command ignores that (use carefully). character deleted delete guid|charname Deletes a single character based on name or guid Fix should include Remove all character data from all character tables on deletion or when the core starts and runs the check A startup task should check existing character data is correct. It should check: All character tables (character data entries) matches up to a VALID GUID entry in the character table, that exists and not marked for deletion. If marked for deletion it should be kept and deleted when the normal deletion routine runs.

We are investigating reports from Covenant-Wow servers that One is crashing at random times. This appears to be while a player is IDLE and sometimes while in combat.

Currently members of the Alliance and Horde cannot get the quest: The Magical Kingdom of Dalaran This needs to be checked out and implemented.

-- Remove the current "creature" portal for both horde and alliance respectively -- DELETE FROM creature WHERE guid = '68120'; DELETE FROM creature WHERE guid = '68119'; -- Create new portal object for both horde and alliance respectively -- insert into `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `mingold`, `maxgold`) values ('500000','22','4395','Portal to Orgrimmar','','','','1735','0','2','0','0','0','0','0','0','17609','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0'); insert into `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `mingold`, `maxgold`) values('500001','22','4396','Portal to Stormwind','','','','1732','0','2','0','0','0','0','0','0','17334','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0'); -- Place new portals for both horde and alliance respectively -- insert into `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values('300000','500000','530','1','1','-161.318','965.41','54.3738','1.5708','0','0','0.00872639','0.999962','181','100','1'); insert into `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values('300001','500001','530','1','1','-337.492','962.619','54.3719','1.22173','0','0','-0.156434','0.987688','181','100','1'); Credit to @necrovoice for providing this.

@antz One needs a DB rollup asap.