Random Server Crashing
Posted: Wed Aug 27, 2008 12:50 am
I have always have some instability on my server and I am looking to finally seek some closure. WC3:FT usually does not directly indicate an error for me.
Crash occurred at 11:07PM-11:20PM or so before my auto-restart kicked in.
In my wc3_error log, some pre-crash stuff with no information seeming useful:
In my AMXX log (some discretion is advised; swearing, racism and stupidity are all present here if not more):
This is in my regular log; this is the LAST line and exactly as stated in the quote. It does not end normally, it ends with an unfinished statement as if it just shutdown without any pre-emptive notion.
Slmclarengt
Crash occurred at 11:07PM-11:20PM or so before my auto-restart kicked in.
In my wc3_error log, some pre-crash stuff with no information seeming useful:
Code: Select all
L 08/26/2008 - 22:22:06: ** Map 'de_aztec' ended
L 08/26/2008 - 22:22:06: DELETE FROM wc3_player_race WHERE player_id IN ( SELECT `player_id` FROM `wc3_player` WHERE ( DATE_SUB(CURDATE(), INTERVAL 120 DAY) > time ) )
L 08/26/2008 - 22:22:06: DELETE FROM wc3_player_skill WHERE player_id IN ( SELECT `player_id` FROM `wc3_player` WHERE ( DATE_SUB(CURDATE(), INTERVAL 120 DAY) > time ) );
L 08/26/2008 - 22:22:12: ** Map cs_office started, version: '3.0 RC11b'
L 08/26/2008 - 22:35:08: ** Map 'cs_office' ended
L 08/26/2008 - 22:35:08: DELETE FROM wc3_player_race WHERE player_id IN ( SELECT `player_id` FROM `wc3_player` WHERE ( DATE_SUB(CURDATE(), INTERVAL 120 DAY) > time ) )
L 08/26/2008 - 22:35:09: DELETE FROM wc3_player_skill WHERE player_id IN ( SELECT `player_id` FROM `wc3_player` WHERE ( DATE_SUB(CURDATE(), INTERVAL 120 DAY) > time ) );
L 08/26/2008 - 22:35:16: ** Map scoutzknivez started, version: '3.0 RC11b'
L 08/26/2008 - 22:35:17: MENU_Shopmenu Buy
L 08/26/2008 - 22:54:40: ** Map 'scoutzknivez' ended
L 08/26/2008 - 22:54:40: DELETE FROM wc3_player_race WHERE player_id IN ( SELECT `player_id` FROM `wc3_player` WHERE ( DATE_SUB(CURDATE(), INTERVAL 120 DAY) > time ) )
L 08/26/2008 - 22:54:40: DELETE FROM wc3_player_skill WHERE player_id IN ( SELECT `player_id` FROM `wc3_player` WHERE ( DATE_SUB(CURDATE(), INTERVAL 120 DAY) > time ) );
L 08/26/2008 - 22:54:50: ** Map de_dust started, version: '3.0 RC11b'
L 08/26/2008 - 23:07:07: ** Map 'de_dust' ended
L 08/26/2008 - 23:07:07: DELETE FROM wc3_player_race WHERE player_id IN ( SELECT `player_id` FROM `wc3_player` WHERE ( DATE_SUB(CURDATE(), INTERVAL 120 DAY) > time ) )
L 08/26/2008 - 23:07:07: DELETE FROM wc3_player_skill WHERE player_id IN ( SELECT `player_id` FROM `wc3_player` WHERE ( DATE_SUB(CURDATE(), INTERVAL 120 DAY) > time ) );
L 08/26/2008 - 23:20:44: ** Map de_dust2 started, version: '3.0 RC11b'
Code: Select all
L 08/26/2008 - 22:55:00: [admin_amxbans.amxx] Login: "BnD | dealface<1872><STEAM_0:0:736400><>" became an admin (account "STEAM_0:0:736400") (access "cdefijntu") (address "216.165.231.27")
L 08/26/2008 - 22:55:00: [admin_amxbans.amxx] Login: "BnD [s] Para<1914><STEAM_0:0:4198114><>" became an admin (account "STEAM_0:0:4198114") (access "cefiju") (address "98.218.136.73")
L 08/26/2008 - 22:55:05: [amxbans.amxx] [AMXBANS] No reasons found in data base. Static reasons was loaded instead
L 08/26/2008 - 22:56:09: [adminchat.amxx] Chat: "WC3FT Fast DL @ WWW.BNDCLAN.COM<0><><>" chat "[AMXBANS]<2nd> STEAM_0:1:3835552 banned 2 time(s) before."
L 08/26/2008 - 22:56:17: [adminchat.amxx] Chat: "WC3FT Fast DL @ WWW.BNDCLAN.COM<0><><>" chat "[AMXBANS]<BnD [s] Para> STEAM_0:0:4198114 banned 3 time(s) before."
L 08/26/2008 - 22:56:36: [amxbans.amxx] [Amxbans] Connection failed!
L 08/26/2008 - 22:56:36: [amxbans.amxx] [Amxbans] Threaded query error, location: 17
L 08/26/2008 - 22:56:36: [amxbans.amxx] [Amxbans] Message: Lost connection to MySQL server during query (2013)
L 08/26/2008 - 22:56:36: [amxbans.amxx] [Amxbans] Query statement:
L 08/26/2008 - 22:57:46: [admincmd.amxx] Cmd: "BnD [s] Para<1914><STEAM_0:0:4198114><>" ask for players list
L 08/26/2008 - 22:58:08: [adminchat.amxx] Chat: "BnD [s] Para<1914><STEAM_0:0:4198114><>" tsay "look"
L 08/26/2008 - 22:58:09: [admin_amxbans.amxx] Login: "BnD | Para<1914><STEAM_0:0:4198114><>" became an admin (account "STEAM_0:0:4198114") (access "cefiju") (address "98.218.136.73")
L 08/26/2008 - 22:59:26: [adminchat.amxx] Chat: "BnD | dealface<1872><STEAM_0:0:736400><>" tsay "ill screw you over by not banning you so you fail that class bitch"
L 08/26/2008 - 23:01:27: [adminchat.amxx] Chat: "BnD | dealface<1872><STEAM_0:0:736400><>" tsay "that time i mother fucking proed you lol"
L 08/26/2008 - 23:02:08: [adminvote.amxx] Vote: "BnD | dealface<1872><STEAM_0:0:736400><>" vote custom (question "newmap?") (option#1 "yes") (option#2 "no")
L 08/26/2008 - 23:02:20: [adminvote.amxx] Vote: Voting successful (got "10") (needed "8") (result "newmap? - no")
L 08/26/2008 - 23:02:40: [adminchat.amxx] Chat: "BnD | Para<1914><STEAM_0:0:4198114><>" tsay "why it gotta be nigger?"
L 08/26/2008 - 23:02:50: [adminchat.amxx] Chat: "BnD | Para<1914><STEAM_0:0:4198114><>" tsay "why not trailertrash?"
L 08/26/2008 - 23:03:00: [adminchat.amxx] Chat: "BnD | Para<1914><STEAM_0:0:4198114><>" tsay "Everything has to be nigger with you"
L 08/26/2008 - 23:04:17: [adminvote.amxx] Vote: "BnD | Para<1914><STEAM_0:0:4198114><>" vote map (map "cs_assault_noc")
L 08/26/2008 - 23:04:29: [adminvote.amxx] Vote: Voting failed (got "5") (needed "8")
L 08/26/2008 - 23:04:40: [adminvote.amxx] Vote: "BnD | dealface<1872><STEAM_0:0:736400><>" vote custom (question "whoshouldchoosemap?") (option#1 "mobo") (option#2 "alba")
L 08/26/2008 - 23:04:52: [adminvote.amxx] Vote: Voting successful (got "9") (needed "8") (result "whoshouldchoosemap? - mobo")
L 08/26/2008 - 23:05:18: [adminchat.amxx] Chat: "BnD | Para<1914><STEAM_0:0:4198114><>" tsay "not pokemon bitch"
L 08/26/2008 - 23:05:28: [adminchat.amxx] Chat: "BnD | Para<1914><STEAM_0:0:4198114><>" tsay "and dealface is the weakest pokeman ever"
L 08/26/2008 - 23:05:38: [adminchat.amxx] Chat: "BnD | Para<1914><STEAM_0:0:4198114><>" tsay "abra kicks his ass with teleport"
L 08/26/2008 - 23:05:58: [adminvote.amxx] Vote: "BnD | dealface<1872><STEAM_0:0:736400><>" vote map (map "de_dust2")
L 08/26/2008 - 23:06:10: [adminvote.amxx] Vote: Voting successful (got "14") (needed "10") (result "changelevel de_dust2")
L 08/26/2008 - 23:06:20: [adminvote.amxx] Vote: Result refused
L 08/26/2008 - 23:06:37: [adminvote.amxx] Vote: "BnD | dealface<1872><STEAM_0:0:736400><>" vote maps (map#1 "de_inferno") (map#2 "de_dust2") (map#3 "") (map#4 "")
L 08/26/2008 - 23:06:49: [adminvote.amxx] Vote: Voting successful (got "10") (needed "9") (result "changelevel de_inferno")
L 08/26/2008 - 23:06:59: [adminvote.amxx] Vote: Result refused
L 08/26/2008 - 23:07:05: [admincmd.amxx] Cmd: "BnD | dealface<1872><STEAM_0:0:736400><>" changelevel "de_inferno"
L 08/26/2008 - 23:07:07: [war3ft.amxx] DELETE FROM wc3_player_race WHERE player_id IN ( SELECT `player_id` FROM `wc3_player` WHERE ( DATE_SUB(CURDATE(), INTERVAL 120 DAY) > time ) )
L 08/26/2008 - 23:07:07: [war3ft.amxx] DELETE FROM wc3_player_skill WHERE player_id IN ( SELECT `player_id` FROM `wc3_player` WHERE ( DATE_SUB(CURDATE(), INTERVAL 120 DAY) > time ) );
L 08/26/2008 - 23:20:44: -------- Mapchange to de_dust2 --------
Code: Select all
L 08/26/2008 - 23:07:07: "Ballistic<1875><STEAM_0:0:5736875><TERRORIST>" triggered "weaponstats" (weapon "Orb_of Annihilation") (shots "20") (hits "1") (kills "0") (he