FK violations

[John Adams]

This is new, never seen it before. Not sure how to reproduce yet. But this looks like a player created a character, got a bad char name (Response 13), then tried again, inserted but got that ever-so-famous cannot login right after toon create. This time though, for 2 days now, World has been burping all kinds of Foreign Key violations over and over, almost stuck in a loop.

Code: Select all

00:02:32 E DBCore: #1452: Cannot add or update a child row: a foreign key constraint fails (`eq2tc`.`characters`, CONSTRAINT `FK_characters` FOREIGN KEY (`current_zone_id`) REFERENCES `zones` (`id`) ON UPDATE CASCADE)

Query:
update characters set current_zone_id=1953459299, x=-305.040009, y=-56.070000, z=73.570000, heading=332.187500, level=14,instance_id=1818584684,last_saved=1345446152, `class`=24 where id = 174

id 174 is not in my DB, so that's the first problem. But the data in red is invalid. Seems to me the character did not get created, and the player either sat at the failed to connect screen for 2 days now, or something else went wrong. Every 60 secs, World ran WorldDatabase::Save() the character, which did not have a valid zone_id, thus the FK violation.

Attaching the logs, tho I don't think we'll learn how to reproduce this. Since connecting on char-create is 90% failure, I'll try that after my vacation and see if I can make it happen.

Also had 2 crashes, but of course I was back in Release (because Alfa complained about slowness), so I could not debug the 2 player crashes. In Release now, though. Endure.