MySQL errors/problems

slmclarengt · Post by **slmclarengt** » Sat Nov 10, 2007 8:35 pm

L 11/10/2007 - 16:20:34: [war3ft.amxx] [ERROR] Unable to retreive user's (2) Unique ID, trying again...
L 11/10/2007 - 16:20:34: [war3ft.amxx] [MYSQLX] Error in querying database, location: 2
L 11/10/2007 - 16:20:34: [war3ft.amxx] [MYSQLX] Message: MySQL server has gone away (2006)
L 11/10/2007 - 16:20:34: [war3ft.amxx] [MYSQLX] Query statement: SELECT `player_id` FROM `wc3_player` WHERE `player_steamid` = '';

I get errors such as that in my AMXX logs, some with the steamid there and plenty without any steamid to be searched for. This just prevents my SQL server from sending the data and WC3FT returns this error whenever it cannot get the data so a fix for this would be awesome! MySQL client version: 4.1.10

Server Version (both as reported by Phpmyadmin): 5.0.27-standard

Funny thing is, I was using Nuclearfallout's provided SQL server but after their upgrade to Client Version 5.0.44, my logs failed miserably and generated about 150MB size logs. So I switched over to my lunarpage's SQL server, which for the most part, performs well but since it is not meant for constant retrieval, it may cause problems.

I am considering switching my server back to Linux rather than Windows but I am still weary of it in case that's of any constellation to troubleshooting.

I believe this may be the memory leak problem that is causing my server to crash. This is probably not related to SQL but nonetheless it is probably a bigger problem than XP not retrieving.

Code: Select all

L 11/10/2007 - 18:25:41: Team "TERRORIST" triggered "Terrorists_Win" (CT "0") (T "7")
L 11/10/2007 - 18:25:41: World triggered "Round_End"
L 11/10/2007 - 18:25:44: "Dirty[@

That is how my logs always end when it crashes and I am sure it must be WC3FT.

--- Please enter the following information for support ---
War3ft Version: 3.0RC8
Amxmodx Version: 1.76d
Metamod Version: 1.19p38
amxx list:

Code: Select all

Currently loaded plugins:
name version author file status
[ 1] AMXBans 5.0 YoMama/Lux & lan amxbans.amxx debug
[ 2] AmxBans Admin Base 1.76 AMXX Dev Team admin_amxbans.a running
[ 3] Admin Commands 1.76d AMXX Dev Team admincmd.amxx running
[ 4] Admin Help 1.76d AMXX Dev Team adminhelp.amxx running
[ 5] Multi-Lingual System 1.76d AMXX Dev Team multilingual.am running
[ 6] Menus Front-End 1.76d AMXX Dev Team menufront.amxx running
[ 7] Commands Menu 1.76d AMXX Dev Team cmdmenu.amxx running
[ 8] Players Menu 1.76d AMXX Dev Team plmenu.amxx running
[ 9] Teleport Menu 1.76d AMXX Dev Team telemenu.amxx running
[ 10] Maps Menu 1.76d AMXX Dev Team mapsmenu.amxx running
[ 11] Admin Chat 1.76d AMXX Dev Team adminchat.amxx running
[ 12] Anti Flood 1.76d AMXX Dev Team antiflood.amxx running
[ 13] Scrolling Message 1.76d AMXX Dev Team scrollmsg.amxx running
[ 14] Info. Messages 1.76d AMXX Dev Team imessage.amxx running
[ 15] Admin Votes 1.76d AMXX Dev Team adminvote.amxx running
[ 16] NextMap 1.76d AMXX Dev Team nextmap.amxx running
[ 17] TimeLeft 1.76d AMXX Dev Team timeleft.amxx running
[ 18] Pause Plugins 1.76d AMXX Dev Team pausecfg.amxx running
[ 19] Stats Configuration 1.76d AMXX Dev Team statscfg.amxx running
[ 20] Restrict Weapons 1.76d AMXX Dev Team restmenu.amxx running
[ 21] StatsX 1.76d AMXX Dev Team statsx.amxx running
[ 22] CS Misc. Stats 1.76d AMXX Dev Team miscstats.amxx running
[ 23] Warcraft 3 Frozen Thro 3.0 RC8 Geesu & Avanderi war3ft.amxx debug
[ 24] AMX Super 3.1 Bmann_420 & Bo0m amx_super.amxx running
[ 25] Bad Camper 1.3b Brad Jones bad_camper.amxx running
[ 26] Grenade Spam Punish 1.3 [gOf]-Soul grenspampunish. running
[ 27] Admin Spectator ESP 1.3 KoST admin_spec_esp. running
[ 28] AMX Toggle Immunity 3.12 slmclarengt amx_toggleimmun running
[ 29] DeagsMapManager 2.40 Deags/JTP10181 deagsmapmanager running
[ 30] ChickenMod: Rebirth 1.0a T(+)rget amx_chicken.amx running
[ 31] AMX Llama 1.4 SniperBeamer admin_llama.amx running
[ 32] Advanced Roll The Dice v2.5 RC Striker roll_the_dice.a running
[ 33] Spawn Protection 7.0 Peli spawnprotection running
[ 34] AdThemes 1.6 Vet(3TT3V) adthemes.amxx running
[ 35] FakeFull Original 1.7.6 JTP10181/Freecod fakefull_origin running
[ 36] Server redirect 0.9.1 x0R serverredirect. running
[ 37] Map Spawns Editor 1.0.16 iG_os Map_Spawns_Edit running
[ 38] Clan Vs. All 1.0 GHW_Chronic clanvsall.amxx running
[ 39] High Ping Kicker 0.17 OLO/Shadow amx_hpk.amxx running
[ 40] Knife Only on Bridge i 1.0 xx_sirhc_xx amx_deagle5_kni running
40 plugins, 40 running

amxx modules:

Code: Select all

Currently loaded modules:
name version author status
[ 1] MySQL 1.76b AMX Mod X Dev Team running
[ 2] Fun 1.76 AMX Mod X Dev Team running
[ 3] Engine 1.76 AMX Mod X Dev Team running
[ 4] FakeMeta 1.76d AMX Mod X Dev Team running
[ 5] Sockets 1.76 HLSW Dev Team running
[ 6] CStrike 1.76 AMX Mod X Dev Team running
[ 7] CSX 1.76c AMX Mod X Dev Team running
[ 8] SQLite 1.76b AMX Mod X Dev Team running
8 modules, 8 correct

meta list:

Code: Select all

Currently loaded plugins:
description stat pend file vers src load unlod
[ 1] AMX Mod X RUN - amxmodx_mm.dll v1.76d ini ANY ANY
[ 2] SBSRV RUN - sbsrv_mm.dll v3.5.2 ini Start Never
[ 3] MySQL RUN - mysql_amxx.dll v1.76b pl1 ANY ANY
[ 4] Fun RUN - fun_amxx.dll v1.76 pl1 ANY ANY
[ 5] Engine RUN - engine_amxx.dll v1.76 pl1 ANY ANY
[ 6] FakeMeta RUN - fakemeta_amxx.dl v1.76d pl1 ANY ANY
[ 7] CStrike RUN - cstrike_amxx.dll v1.76 pl1 ANY ANY
[ 8] CSX RUN - csx_amxx.dll v1.76c pl1 ANY ANY
[ 9] SQLite RUN - sqlite_amxx.dll v1.76b pl1 ANY ANY
9 plugins, 9 running

Slmclarengt

Post by **Geesu** » Sun Nov 11, 2007 11:28 pm

This is very odd - I would ask on amxmodx.org if anyone has seen issues of get_player_auth() returning a blank string... B/c clearly that is what is happening.