Random Server Crashing

Read log files for errors! If this fails, come here for help

Moderator: Forum Moderator

Post Reply
slmclarengt
Militia
Posts: 68
Joined: Thu Mar 09, 2006 7:30 pm

Random Server Crashing

Post by slmclarengt » 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:

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
"I am become Death destroyer of worlds" - Hindu God Krishna speaking with Soldier about battle (Later quoted by Robert Oppenheimer, head of the Manhattan Project in Los Alamos Laboratories.)

Mayhem
Peon
Posts: 26
Joined: Mon Jun 09, 2008 9:41 pm
Location: California, USA
Contact:

Re: Random Server Crashing

Post by Mayhem » Wed Aug 27, 2008 10:04 pm

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

Post Reply