Hotbars = MySQL has gone away?
Moderators: Community Managers, Developers
-
John Adams
- Retired
- Posts: 4582
- Joined: Wed Aug 28, 2013 9:40 am
- Location: Phoenix, AZ.
- Contact:
Hotbars = MySQL has gone away?
Something dreadful just happened with what appears to be the Hotbar code. Remember the other day when I warned about a duplicate key insert attempt? Well this time I wasn't there to catch it immediately, and the MySQL connection got completely nuked. Absolutely no idea why, and I doubt a key validation failure would nuke the connection, so it has to be something else.
Players were online enjoying themselves for hours, when this happened (again):
[quote]19:00:40.100 E Database Error running MySQL query (1062): Duplicate entry '243-m_ref_right0-11' for key 'HotBarIDX'
INSERT INTO `character_hotbars` (`char_id_fk`, `bar_name`, `slot_id`, `ability_id`, `item_unique_id`, `reference`, `command_text`,
`icon_id`) VALUES
(243,'m_ref_right0',11,46163,-1,'abilities_page','',-1);
19:00:40.100 E Char Player 'Riken' (243) Update HotButton FAILED.
19:00:40.100 E Database Error running MySQL query (2013): Lost connection to MySQL server during query
INSERT INTO `character_appearances` (`char_id_fk`,`appearance_id`,`appearance_value`) VALUES ('555','0','50'),('555','1','50'),('555','2','1'),('555','3','1'),('555','4','1'),('555','5','1'),('555','6','1'),('555','7','1'),('555','8','1'),('555','9','1'),('555','10','1'),('555','11','1'),('555','12','50'),('555','13','50'),('555','14','50'),('555','15','50'),('555','16','50'),('555','17','50'),('555','18','50'),('555','19','50'),('555','20','50'),('555','21','50'),('555','22','50'),('555','23','50'),('555','24','50'),('555','25','50'),('555','26','50'),('555','27','50'),('555','28','50'),('555','29','50'),('555','30','50'),('555','31','50'),('555','32','50'),('555','33','50'),('555','34','50'),('555','35','50'),('555','36','50'),('555','37','50'),('555','38','50'),('555','39','50'),('555','40','50'),('555','41','50'),('555','42','50'),('555','43','50'),('555','44','50'),('555','45','50'),('555','46','50'),('555','47','50'),('555','48','50'),('555','49','50'),('555','50','50'),('555','51','50'),('555','52','50'),('555','53','50'),('555','54','50'),('555','55','50'),('555','56','50'),('555','57','50'),('555','58','50'),('555','59','50'),('555','60','50'),('555','61','50'),('555','62','50'),('555','63','50')
19:00:40.100 E Database Error running MySQL query (2006): MySQL server has gone away
DELETE FROM `characters` WHERE `character_id`=555
19:00:43.766 E Database Error running MySQL query (2006): MySQL server has gone away
INSERT INTO `character_hotbars` (`char_id_fk`, `bar_name`, `slot_id`, `ability_id`, `item_unique_id`, `reference`, `command_text`,
`icon_id`) VALUES
(243,'m_ref_right0',10,26777,-1,'abilities_page','',-1);
19:00:43.766 E Char Player 'Riken' (243) Update HotButton FAILED.
19:01:03.157 E Database Error running MySQL query (2006): MySQL server has gone away
DELETE FROM `character_hotbars` where char_id_fk='243' and bar_name='m_wb' and slot_id='10'
19:01:03.157 E Char Player 'Riken' (243) Delete HotButton FAILED.
19:01:03.172 E Database Error running MySQL query (2006): MySQL server has gone away
INSERT INTO `character_hotbars` (`char_id_fk`, `bar_name`, `slot_id`, `ability_id`, `item_unique_id`, `reference`, `command_text`,
`icon_id`) VALUES
(243,'m_wb',10,13829,-1,'abilities_page','',-1);
19:01:03.172 E Char Player 'Riken' (243) Update HotButton FAILED.
19:01:03.874 E Database Error running MySQL query (2006): MySQL server has gone away
INSERT INTO `character_hotbars` (`char_id_fk`, `bar_name`, `slot_id`, `ability_id`, `item_unique_id`, `reference`, `command_text`,
`icon_id`) VALUES
(243,'m_wb',9,-1,-1,'Hotkeys','',-1);
19:01:03.874 E Char Player 'Riken' (243) Update HotButton FAILED.
19:01:47.679 D Chunk Camp started for character 'Riken'
19:02:07.804 D Chunk Camping out character 'Riken'
19:02:07.819 D Char Character Riken Set to Offline
19:02:07.819 E Database Error running MySQL query (2006): MySQL server has gone away
UPDATE `characters`
SET `current_x`=37348.000000, `current_y`=-22356.000000, `current_z`=24052.000000, `current_pitch`=0, `current_yaw`=36254, `current_roll`=0, `adventure_level`=1, `adventure_xp`=0,`crafting_level`=1, `crafting_xp`=0, `diplomacy_level`=1, `diplomacy_xp`=0, `current_chunk_fk`=22, date_lastseen=UNIX_TIMESTAMP(), is_online = 0
WHERE character_id = 243
19:02:07.819 E Char SaveCharacter: Failed to save character at c:\vgoemu\src\world\worlddatabase.cpp:1509
19:02:07.819 E Database Error running MySQL query (2006): MySQL server has gone away
UPDATE `character_details` SET `title_show`=1, `title_prefix`=600, `title_suffix`=601 WHERE char_id_fk=243
19:02:07.819 E Char SaveCharacter: Failed to save character details at c:\vgoemu\src\world\worlddatabase.cpp:1516
19:02:07.819 E Database Error running MySQL query (2006): MySQL server has gone away
DELETE FROM `character_titles` WHERE char_id_fk=243
19:02:07.819 E Char SaveCharacter: Failed to save character titles at c:\vgoemu\src\world\worlddatabase.cpp:1523
19:02:07.819 E Database Error running MySQL query (2006): MySQL server has gone away
DELETE FROM `character_factions` WHERE char_id_fk=243
19:02:07.819 E Char SaveCharacter: Failed to save character factions at c:\vgoemu\src\world\worlddatabase.cpp:1530
19:02:07.819 D Char Character Riken Set to Offline
19:02:07.819 I UDP Client from 206.116.250.230:62179 set to disconnect : Application
19:02:07.866 D Account Client Created: 3
19:02:07.866 I UDP New client connected from 206.116.250.230:62179
19:02:07.882 E Unreal Could not find unreal channel list for account id 0!
19:02:08.022 I UDP Client from 206.116.250.230:62179 set to disconnect : Application
19:02:08.038 D Account Client Created: 4
19:02:08.038 I UDP New client connected from 206.116.250.230:62179
19:02:08.038 I UDP Client from 206.116.250.230:62179 set to disconnect : Application
19:02:09.301 E Database Error running MySQL query (2006): MySQL server has gone away
SELECT `character_id`,`firstname`,`lastname`,`race`,`adventure_class`,`gender`,`adventure_level`,`current_chunk_fk`
FROM `characters`
WHERE `account_id`=80
AND `is_deleted`=0
LIMIT 12[/quote]
The fact you see a HotBar update at the same time someone was creating a new character (Vurgood created "TestChar", char_id 555 at that same time), I wonder if there's a coincidental thread collision or something here?
The world did eventually crash, and it was in HandleCharSelect or something like that, but not enough stack to be worth posting - this above log was obviously the issue.
Players were online enjoying themselves for hours, when this happened (again):
[quote]19:00:40.100 E Database Error running MySQL query (1062): Duplicate entry '243-m_ref_right0-11' for key 'HotBarIDX'
INSERT INTO `character_hotbars` (`char_id_fk`, `bar_name`, `slot_id`, `ability_id`, `item_unique_id`, `reference`, `command_text`,
`icon_id`) VALUES
(243,'m_ref_right0',11,46163,-1,'abilities_page','',-1);
19:00:40.100 E Char Player 'Riken' (243) Update HotButton FAILED.
19:00:40.100 E Database Error running MySQL query (2013): Lost connection to MySQL server during query
INSERT INTO `character_appearances` (`char_id_fk`,`appearance_id`,`appearance_value`) VALUES ('555','0','50'),('555','1','50'),('555','2','1'),('555','3','1'),('555','4','1'),('555','5','1'),('555','6','1'),('555','7','1'),('555','8','1'),('555','9','1'),('555','10','1'),('555','11','1'),('555','12','50'),('555','13','50'),('555','14','50'),('555','15','50'),('555','16','50'),('555','17','50'),('555','18','50'),('555','19','50'),('555','20','50'),('555','21','50'),('555','22','50'),('555','23','50'),('555','24','50'),('555','25','50'),('555','26','50'),('555','27','50'),('555','28','50'),('555','29','50'),('555','30','50'),('555','31','50'),('555','32','50'),('555','33','50'),('555','34','50'),('555','35','50'),('555','36','50'),('555','37','50'),('555','38','50'),('555','39','50'),('555','40','50'),('555','41','50'),('555','42','50'),('555','43','50'),('555','44','50'),('555','45','50'),('555','46','50'),('555','47','50'),('555','48','50'),('555','49','50'),('555','50','50'),('555','51','50'),('555','52','50'),('555','53','50'),('555','54','50'),('555','55','50'),('555','56','50'),('555','57','50'),('555','58','50'),('555','59','50'),('555','60','50'),('555','61','50'),('555','62','50'),('555','63','50')
19:00:40.100 E Database Error running MySQL query (2006): MySQL server has gone away
DELETE FROM `characters` WHERE `character_id`=555
19:00:43.766 E Database Error running MySQL query (2006): MySQL server has gone away
INSERT INTO `character_hotbars` (`char_id_fk`, `bar_name`, `slot_id`, `ability_id`, `item_unique_id`, `reference`, `command_text`,
`icon_id`) VALUES
(243,'m_ref_right0',10,26777,-1,'abilities_page','',-1);
19:00:43.766 E Char Player 'Riken' (243) Update HotButton FAILED.
19:01:03.157 E Database Error running MySQL query (2006): MySQL server has gone away
DELETE FROM `character_hotbars` where char_id_fk='243' and bar_name='m_wb' and slot_id='10'
19:01:03.157 E Char Player 'Riken' (243) Delete HotButton FAILED.
19:01:03.172 E Database Error running MySQL query (2006): MySQL server has gone away
INSERT INTO `character_hotbars` (`char_id_fk`, `bar_name`, `slot_id`, `ability_id`, `item_unique_id`, `reference`, `command_text`,
`icon_id`) VALUES
(243,'m_wb',10,13829,-1,'abilities_page','',-1);
19:01:03.172 E Char Player 'Riken' (243) Update HotButton FAILED.
19:01:03.874 E Database Error running MySQL query (2006): MySQL server has gone away
INSERT INTO `character_hotbars` (`char_id_fk`, `bar_name`, `slot_id`, `ability_id`, `item_unique_id`, `reference`, `command_text`,
`icon_id`) VALUES
(243,'m_wb',9,-1,-1,'Hotkeys','',-1);
19:01:03.874 E Char Player 'Riken' (243) Update HotButton FAILED.
19:01:47.679 D Chunk Camp started for character 'Riken'
19:02:07.804 D Chunk Camping out character 'Riken'
19:02:07.819 D Char Character Riken Set to Offline
19:02:07.819 E Database Error running MySQL query (2006): MySQL server has gone away
UPDATE `characters`
SET `current_x`=37348.000000, `current_y`=-22356.000000, `current_z`=24052.000000, `current_pitch`=0, `current_yaw`=36254, `current_roll`=0, `adventure_level`=1, `adventure_xp`=0,`crafting_level`=1, `crafting_xp`=0, `diplomacy_level`=1, `diplomacy_xp`=0, `current_chunk_fk`=22, date_lastseen=UNIX_TIMESTAMP(), is_online = 0
WHERE character_id = 243
19:02:07.819 E Char SaveCharacter: Failed to save character at c:\vgoemu\src\world\worlddatabase.cpp:1509
19:02:07.819 E Database Error running MySQL query (2006): MySQL server has gone away
UPDATE `character_details` SET `title_show`=1, `title_prefix`=600, `title_suffix`=601 WHERE char_id_fk=243
19:02:07.819 E Char SaveCharacter: Failed to save character details at c:\vgoemu\src\world\worlddatabase.cpp:1516
19:02:07.819 E Database Error running MySQL query (2006): MySQL server has gone away
DELETE FROM `character_titles` WHERE char_id_fk=243
19:02:07.819 E Char SaveCharacter: Failed to save character titles at c:\vgoemu\src\world\worlddatabase.cpp:1523
19:02:07.819 E Database Error running MySQL query (2006): MySQL server has gone away
DELETE FROM `character_factions` WHERE char_id_fk=243
19:02:07.819 E Char SaveCharacter: Failed to save character factions at c:\vgoemu\src\world\worlddatabase.cpp:1530
19:02:07.819 D Char Character Riken Set to Offline
19:02:07.819 I UDP Client from 206.116.250.230:62179 set to disconnect : Application
19:02:07.866 D Account Client Created: 3
19:02:07.866 I UDP New client connected from 206.116.250.230:62179
19:02:07.882 E Unreal Could not find unreal channel list for account id 0!
19:02:08.022 I UDP Client from 206.116.250.230:62179 set to disconnect : Application
19:02:08.038 D Account Client Created: 4
19:02:08.038 I UDP New client connected from 206.116.250.230:62179
19:02:08.038 I UDP Client from 206.116.250.230:62179 set to disconnect : Application
19:02:09.301 E Database Error running MySQL query (2006): MySQL server has gone away
SELECT `character_id`,`firstname`,`lastname`,`race`,`adventure_class`,`gender`,`adventure_level`,`current_chunk_fk`
FROM `characters`
WHERE `account_id`=80
AND `is_deleted`=0
LIMIT 12[/quote]
The fact you see a HotBar update at the same time someone was creating a new character (Vurgood created "TestChar", char_id 555 at that same time), I wonder if there's a coincidental thread collision or something here?
The world did eventually crash, and it was in HandleCharSelect or something like that, but not enough stack to be worth posting - this above log was obviously the issue.