Server crashing on map change!!!

Daver · Post by **Daver** » Sun Aug 19, 2007 10:05 pm

Well here is what I have done.
I completely started my server with a fresh cstrike install.
Used the amxmodx installer to install that.
Ran server runs fine.
installed war3ft version3.0rc8 connected to database and all works great. Saves xp and it works fine. Change map and the server will change the map but everyone in it times out and loses connection. Sometime the server crashes from the map change and doesnt restart.

I investigate cuz this is the same rerason I deleted all those files and started fresh!!!

If I stop the war3 plugin everything is fine. Hmmm, my guess is there is a problem with this plugin.

I read the post about "Server crash on map change and so here is that binlog data in an attachment:

Thx for the help, I hope...

Daver

EDIT: Well here is more news about the crashing. I changed to the sqlite saving and the problem went away. Good news the server will work, bad news how do I make it stay connected to the database cuz that is where the problem is, it must be taking to long to do something with the database and all the players lose connction cuz they timeout to the server.

--- Please enter the following information for support ---
War3ft Version: 3.0rc8
Amxmodx Version: 1.76d
Metamod Version: 1.19p28
amxx list: Currently loaded plugins:
name version author file status
Admin Base (SQL) 1.75 AMXX Dev Team admin_sql.amxx running
Admin Commands 1.75 AMXX Dev Team admincmd.amxx running
Admin Help 1.75 AMXX Dev Team adminhelp.amxx running
Slots Reservation 1.75 AMXX Dev Team adminslots.amxx running
Menus Front-End 1.75 AMXX Dev Team menufront.amxx running
Commands Menu 1.75 AMXX Dev Team cmdmenu.amxx running
Players Menu 1.75 AMXX Dev Team plmenu.amxx running
Maps Menu 1.75 AMXX Dev Team mapsmenu.amxx running
Admin Chat 1.75 AMXX Dev Team adminchat.amxx running
Anti Flood 1.75 AMXX Dev Team antiflood.amxx running
Scrolling Message 1.75 AMXX Dev Team scrollmsg.amxx running
Info. Messages 1.75 AMXX Dev Team imessage.amxx running
Admin Votes 1.75 AMXX Dev Team adminvote.amxx running
Nextmap Chooser 1.75 AMXX Dev Team mapchooser.amxx running
TimeLeft 1.75 AMXX Dev Team timeleft.amxx running
Pause Plugins 1.75 AMXX Dev Team pausecfg.amxx running
Warcraft 3 Frozen 3.0 RC8 Geesu & Avanderi war3ft.amxx debug
17 plugins, 16 running

amxx modules: Currently loaded modules:
name version author
MySQL 1.75 AMX Mod X Dev Team
Fun 1.75 AMX Mod X Dev Team
Engine 1.75 AMX Mod X Dev Team
FakeMeta 1.75 AMX Mod X Dev Team
CStrike 1.75 AMX Mod X Dev Team
CSX 1.75 AMX Mod X Dev Team
SQLiteX 1.75 AMX Mod X Dev Team
7 modules

meta list: Currently loaded plugins:
description stat pend file vers src load unlod
[ 1] AMX Mod X RUN - amxmodx_bl_mm_i3 v1.76d ini ANY ANY
[ 2] MySQL RUN - mysql_amxx_i386. v1.75 pl1 ANY ANY
[ 3] Fun RUN - fun_amxx_i386.so v1.75 pl1 ANY ANY
[ 4] Engine RUN - engine_amxx_i386 v1.75 pl1 ANY ANY
[ 5] FakeMeta RUN - fakemeta_amxx_i3 v1.75 pl1 ANY ANY
[ 6] CStrike RUN - cstrike_amxx_i38 v1.75 pl1 ANY ANY
[ 7] CSX RUN - csx_amxx_i386.so v1.75 pl1 ANY ANY
[ 8] SQLiteX RUN - sqlite_amxx_i386 v1.75 pl1 ANY ANY
8 plugins, 8 running

kp_downarrow · Post by **kp_downarrow** » Mon Aug 27, 2007 12:46 pm

its mysql problem

Daver · Post by **Daver** » Mon Aug 27, 2007 9:16 pm

With all that info let me just restart my server and qall should be fine now, thx kp_downarrow...

Post by **YamiKaitou** » Mon Aug 27, 2007 9:35 pm

Try upgrading to 1.76d. I see that only the amxmodx_bl_mm_i383.so file is 1.76d, the rest are 1.75

mannisch · Post by **mannisch** » Wed Aug 29, 2007 4:36 pm

Hi,

have you found a solution jet?
I have the same problems like you, and i have amxx 1.76.

Using a remote mySQL db.
As you said, it saves the data, but on mapchange it makes something very long, it needs when i am alone on the server 30 seconds to change.

When more players connected, it seems to take extremly long.
I asked the hoster to look in servers console, he said there is nothing spezial to see, just normal messages.

Manni.

Daver · Post by **Daver** » Thu Sep 06, 2007 6:10 pm

I dont know if this is the reason but I was with Gameservers and they must be blocking something because I swithed to Counter Strike servers and with the same setup and my seperate database everything seems to be working fine now.

Daver

Post by **Geesu** » Wed Sep 12, 2007 9:20 am

where is the bin log you mentioend you had attached?