Page 1 of 1

Random Server Crashing

Posted: Wed Aug 27, 2008 12:50 am
by slmclarengt
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:

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'
In my AMXX log (some discretion is advised; swearing, racism and stupidity are all present here if not more):

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 --------
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.

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
Slmclarengt

Re: Random Server Crashing

Posted: Wed Aug 27, 2008 10:04 pm
by Mayhem
I think they're going to want more information to troubleshoot your problem. That log doesn't say much at all.

viewtopic.php?f=21&t=2868