Problem to load XP

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

Moderator: Forum Moderator

Post Reply
deadeye
Peon
Posts: 7
Joined: Thu Nov 22, 2007 10:39 am

Problem to load XP

Post by deadeye » Thu Nov 22, 2007 10:53 am

Hello,

im from German, my english is not the best, but i need help :wink:

When i connect on the server, i getting the fowolling error message very very often:

"Unable to retreive your XP from the database, please attempt to changerace later"




--- Please enter the following information for support ---
War3ft Version: 3.0 RC8
Amxmodx Version: 1.76d


Metamod Version:

] meta version
Metamod v1.19p28 2006/03/04 (5:13)
by Will Day
http://www.metamod.org/
Patch: Metamod-P (mm-p) v28
by Jussi Kivilinna
http://metamod-p.sourceforge.net/
compiled: Mar 1 2006, 16:50:37 EET (optimized)
ifve


amxx list:

] amxx list
AMX Mod X 1.76d
Authors:
David "BAILOPAN" Anderson, Pavol "PM OnoTo" Marko, Felix "SniperBeamer" Geyer
Jonny "Got His Gun" Bergstrom, Lukasz "SidLuke" Wlasinski
Christian "Basic-Master" Hammacher, Borja "faluco" Ferrer
Scott "Damaged Soul" Ehlert
Compiled: Mar 10 2007, 12:44:50
URL:http://www.amxmodx.org/
Core

meta list:


Currently running plugins:
[ 1] AMX Mod X, v1.76d, Mar 10 2007, by AMX Mod X Dev Team, see http://www.amxmodx.org
[ 2] Fun, v1.76, Mar 8 2007, by AMX Mod X Dev Team, see http://www.amxmodx.org
[ 3] Engine, v1.76, Mar 8 2007, by AMX Mod X Dev Team, see http://www.amxmodx.org
[ 4] CStrike, v1.76, Mar 8 2007, by AMX Mod X Dev Team, see http://www.amxmodx.org
[ 5] CSX, v1.76c, Mar 8 2007, by AMX Mod X Dev Team, see http://www.amxmodx.org/
[ 6] SQLite, v1.76b, Mar 8 2007, by AMX Mod X Dev Team, see http://www.amxmodx.org/
[ 7] MySQL, v1.76b, Mar 8 2007, by AMX Mod X Dev Team, see http://www.amxmodx.org/
[ 8] FakeMeta, v1.76d, Mar 8 2007, by AMX Mod X Dev Team, see http://www.amxmodx.org



my cfg:

Code: Select all


//	Warcraft 3 Frozen Throne Configuration File


// Saving Options

wc3_save_xp		1		// Enables saving of experience (default is 0)
wc3_save_xp_db		1		// How should we save XP? (0 = SQLite, 1 = MySQL)

wc3_save_by		0		// What should I save this as?  steam id = 0, IP = 1, name = 2 (default is 0)
wc3_save_pruning	0		// Automatically prunes the database of old users at a mapchange (default is 0)
wc3_days_before_delete	60		// However many days before deleting XP or pruning from the database (default is 31)
wc3_save_end_round	1		// Save xp at the end of each round (may cause lag, default is 1)


// SQL Database Information

wc3_sql_dbhost		"85.13.***.***"	// Host Name
wc3_sql_dbuser		"********"		// User Name
wc3_sql_dbpass		"**********"		// Password
wc3_sql_dbname		"****"		// Database Name


// Admin Options

wc3_admin_flag		"m"		// Admin flag required to give/take XP (default is m)


// Experience Options

wc3_xp_multiplier	3.0		// set the level required to gain a level as a multiple (default 1.0)
wc3_xp_weap_multiplier	1		// Award XP based on the weapon used (default is 1)
wc3_min_players		2		// Minimum amount of players needed b4 awarding XP (default is 2)
wc3_ignore_bots		0		// Should you ignore bots when calculating the minimum players required to gain xp? (default is 0)
wc3_xp_auto_average	0		// With this option set to 1, the joining players will receive the average amount of XP that all of the players have (SHORT TERM XP ONLY, default is 0)
wc3_show_objectives	1		// If enabled, will display message in chat to show XP they gain for completing certain objectives (default is 1)
wc3_show_kill_obj	1		// Shows how much XP you gain for killing someone (each kill, default is 0)
wc3_xp_radius		750		// Radius to give XP to teammates near where the special objective is completed (rescued hosties, bomb planted, killed vip, vip escaped, default is 750)


// Game Play Enhancements

wc3_races		8		// Number of races (if races are less than 5, the second shopmenu will be disabled (4 is standard war3), default is 8)
wc3_grenade_protection	0		// Only 1 HE grenade will be allowed for purchase per round (default is 0)
wc3_spec_position	0		// 0 is for left, 1 is for right (where to put the information for those spectating, default is 0)
wc3_buy_zone		0		// Restrict purchasing shopmenu items to within the buyzone? (default is 0)
wc3_buy_time		0		// Restrict purchasing shopmenu items to within the buytime? (default is 0)
wc3_buy_dead		1		// Allow users to purchause items when dead? (default is 1)
wc3_show_player		1		// Show teammate and enemy information in the center of the screen when they are on target? (not for DOD, default is 1)
wc3_query_client	0		// Check user's cl_minmodel cvar every second (default is 1)
wc3_cheats		0		// Enable cheats for wc3? (default is 0)
wc3_psychostats		1		// Print psychostats information to log files for wc3 abilities? (default is 0)
wc3_start_level		0		// What level should all players start at when joining? (default is 0)

// Icon Options (displayed above player's head)

wc3_race_icon		1		// Allow users to type /icons to show player icons above the player (default is 1)
wc3_level_icon		1		// Allow users to type /icons to see player levels above the player (default is 1)


// Chameleon Race Configuration Options - see _chameleon.txt for more information

wc3_cham_random		1		// Should the 9th race have random skills each round?, if so the next 4 option are irrelevant (default is 1)
wc3_cham_skill1		14		// What skill ID for skill 1?
wc3_cham_skill2		0		// What skill ID for skill 2?
wc3_cham_skill3		6		// What skill ID for skill 3?
wc3_cham_ultimate	7		// What skill ID for the user's ultimate?
wc3_cham_passive	20		// What skill ID for the user's passive skill?


// Skill and Ultimate configurations

wc3_ult_delay		10.0		// Amount of time (in seconds) to delay the ultimates at the start of each round (default is 15.0)
wc3_ult_cooldown	35.0		// Cooldown of all ultimates (default is 35.0)
wc3_blink_protection	1		// slays people who abuse blink on some maps (skywalking, map exploiting, default is 1)
wc3_blink_dizziness	1		// What type of diziness? (0 is flashbang effect, 1 is fading blue screen, default is 0)
wc3_entangle_drop	0		// Should the player's primary weapon be dropped when they are entangled? (default is 0)


// Item configurations

wc3_glove_timer		10		// Interval between receiving a new grenade with the Flaming Gloves of Warmth (default is 10)
wc3_glove_orc_damage	0		// When using gloves, should orcs be given the critical dmg? (Default is 0)
wc3_boots		0.10		// Percentage increase given by boots (.10 = 10%, default is 0.10)
wc3_claw		6		// Damage done by Claws of Attack (default is 6)
wc3_health		15		// Health bonus given for periapt of health (default is 15)
wc3_frost		125.0		// Speed of victim when attacked with Orb of Frost (default is 125.0)
wc3_mask		0.3		// Percentage of life gained back by mask of death (default is 0.3)
wc3_cloak		150		// Invisibility given with cloak, lower is more invisible (default is 150)
wc3_sock		0.5		// Gravity level for Sock of the Feather (default is 0.5)
wc3_tome		50		// XP given for purchasing tome of experience (default is 50)


// Bot Configuration Options

wc3_bot_buy_item	0.33		// Chance of a bot buying a shopmenu item at the beginning of the round (default is 0.33)


// DOD Options

wc3_dod_start_money	800		// Starting money for dod

[/b]

User avatar
YamiKaitou
Forum Moderator
Forum Moderator
Posts: 1925
Joined: Wed Feb 01, 2006 4:33 pm
Contact:

Post by YamiKaitou » Thu Nov 22, 2007 12:09 pm

Look in your error logs, see if there is a MySQL error being printed
Image

No support via PM or Email

deadeye
Peon
Posts: 7
Joined: Thu Nov 22, 2007 10:39 am

Post by deadeye » Thu Nov 22, 2007 12:14 pm

Thats my second Problem, if got no Logs.

User avatar
YamiKaitou
Forum Moderator
Forum Moderator
Posts: 1925
Joined: Wed Feb 01, 2006 4:33 pm
Contact:

Post by YamiKaitou » Thu Nov 22, 2007 2:11 pm

Lies. Check either in the addons/amxmodx/logs folder or the addons/amxmodx/configs/war3ft/wc3_error.log file
Image

No support via PM or Email

deadeye
Peon
Posts: 7
Joined: Thu Nov 22, 2007 10:39 am

Post by deadeye » Fri Nov 23, 2007 2:49 pm

Sorry, but in no folder are a error log. maybe i must add manual in error log file?

User avatar
YamiKaitou
Forum Moderator
Forum Moderator
Posts: 1925
Joined: Wed Feb 01, 2006 4:33 pm
Contact:

Post by YamiKaitou » Fri Nov 23, 2007 5:06 pm

If the wc3_error.log file does not exist, then wc3ft is not being loaded.


Please provide the outputs of the following commands when typed into the SERVER console or RCON

amxx plugins
Image

No support via PM or Email

deadeye
Peon
Posts: 7
Joined: Thu Nov 22, 2007 10:39 am

Post by deadeye » Sat Nov 24, 2007 4:13 am

[AMXX] Loaded 1 admin from file

Executing AMX Mod X Configuration File
couldn't exec listip.cfg
couldn't exec banned.cfg
Adding master server 68.142.72.250:27010
Adding master server 72.165.61.190:27010
Connection to Steam servers successful.
VAC secure mode is activated.
[WAR3FT] MySQL X database connection successful

amxx plugins

Currently loaded plugins:
name version author file status
[ 1] Admin Base 1.76d AMXX Dev Team admin.amxx running
[ 2] Admin Commands 1.76d AMXX Dev Team admincmd.amxx running
[ 3] Admin Help 1.76d AMXX Dev Team adminhelp.amxx running
[ 4] Slots Reservation 1.76d AMXX Dev Team adminslots.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] Maps Menu 1.76d AMXX Dev Team mapsmenu.amxx running
[ 10] Admin Chat 1.76d AMXX Dev Team adminchat.amxx running
[ 11] Anti Flood 1.76d AMXX Dev Team antiflood.amxx running
[ 12] Scrolling Message 1.76d AMXX Dev Team scrollmsg.amxx running
[ 13] Info. Messages 1.76d AMXX Dev Team imessage.amxx running
[ 14] Admin Votes 1.76d AMXX Dev Team adminvote.amxx running
[ 15] NextMap 1.76d AMXX Dev Team nextmap.amxx running
[ 16] Nextmap Chooser 1.76d AMXX Dev Team mapchooser.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] StatsX 1.76d AMXX Dev Team statsx.amxx running
[ 21] Warcraft 3 Frozen Thro 3.0 RC8 Geesu & Avanderi war3ft.amxx debug
21 plugins, 21 running

User avatar
YamiKaitou
Forum Moderator
Forum Moderator
Posts: 1925
Joined: Wed Feb 01, 2006 4:33 pm
Contact:

Post by YamiKaitou » Sat Nov 24, 2007 4:25 pm

Then the cstrike/addons/amxmodx/configs/war3ft/wc3_error.log file DOES exist. Look in there. If it is a MySQL issue, also look in the cstrike/addons/amxmodx/logs folder for some logs
Image

No support via PM or Email

deadeye
Peon
Posts: 7
Joined: Thu Nov 22, 2007 10:39 am

Post by deadeye » Sun Nov 25, 2007 5:58 am

here 2 screenshots of the folders
Attachments
sc1.gif
sc1.gif (49.59 KiB) Viewed 24629 times
sc2.gif
sc2.gif (18.87 KiB) Viewed 24629 times

User avatar
Geesu
<b>King of the world!</b>
Posts: 3159
Joined: Tue Jul 05, 2005 9:24 pm
Contact:

Post by Geesu » Tue Nov 27, 2007 3:38 pm

so basically whatever user is running the hlds program doesn't have write permissions to those folder...

chmod 777 those 2 folders so error logs can be written...

war3ft ALWAYS writes to a log file on a map load/change, so clearly it has to be a permission issue
No Support via PM

deadeye
Peon
Posts: 7
Joined: Thu Nov 22, 2007 10:39 am

Post by deadeye » Wed Nov 28, 2007 7:31 am

Thats it, thanks.

Here the LOG. the database runs on in extern server (very god server). but it seems that it nit work perfect.

Code: Select all


L 11/28/2007 - 14:28:03: Log file started (file "cstrike/addons/amxmodx/configs/war3ft/wc3_error.log") (game "cstrike") (amx "1.76d")
L 11/28/2007 - 14:28:03: ** Map 'de_dust2' started
L 11/28/2007 - 14:28:03: ** Plugin version: '3.0 RC8' 
L 11/28/2007 - 14:29:14: [MYSQLX] Error in querying database, location: 2
L 11/28/2007 - 14:29:14: [MYSQLX] Message: MySQL server has gone away (2006)
L 11/28/2007 - 14:29:14: [MYSQLX] Query statement: SELECT `player_id` FROM `wc3_player` WHERE `player_steamid` = 'STEAM_0:1:13719215'; 
L 11/28/2007 - 14:29:14: [ERROR] Unable to retreive user's (1) Unique ID, trying again...
L 11/28/2007 - 14:29:15: [MYSQLX] Error in querying database, location: 2
L 11/28/2007 - 14:29:15: [MYSQLX] Message: MySQL server has gone away (2006)
L 11/28/2007 - 14:29:15: [MYSQLX] Query statement: SELECT `player_id` FROM `wc3_player` WHERE `player_steamid` = 'STEAM_0:1:13719215'; 
L 11/28/2007 - 14:29:15: [ERROR] Unable to retreive user's (1) Unique ID, trying again...
L 11/28/2007 - 14:29:16: [MYSQLX] Error in querying database, location: 2
L 11/28/2007 - 14:29:16: [MYSQLX] Message: MySQL server has gone away (2006)
L 11/28/2007 - 14:29:16: [MYSQLX] Query statement: SELECT `player_id` FROM `wc3_player` WHERE `player_steamid` = 'STEAM_0:1:13719215'; 
L 11/28/2007 - 14:29:16: [ERROR] Unable to retreive user's (1) Unique ID, trying again...
L 11/28/2007 - 14:29:17: [MYSQLX] Error in querying database, location: 2
L 11/28/2007 - 14:29:17: [MYSQLX] Message: MySQL server has gone away (2006)
L 11/28/2007 - 14:29:17: [MYSQLX] Query statement: SELECT `player_id` FROM `wc3_player` WHERE `player_steamid` = 'STEAM_0:1:13719215'; 
L 11/28/2007 - 14:29:17: [ERROR] Unable to retreive user's (1) Unique ID, trying again...
L 11/28/2007 - 14:29:17: [ERROR] Unable to retreive user's Unique ID
L 11/28/2007 - 14:29:17: [MYSQLX] Error in querying database, location: 2
L 11/28/2007 - 14:29:17: [MYSQLX] Message: MySQL server has gone away (2006)
L 11/28/2007 - 14:29:17: [MYSQLX] Query statement: SELECT `player_id` FROM `wc3_player` WHERE `player_steamid` = 'STEAM_0:1:13719215'; 
L 11/28/2007 - 14:29:17: [ERROR] Unable to retreive user's (1) Unique ID, trying again...
L 11/28/2007 - 14:29:18: [MYSQLX] Error in querying database, location: 2
L 11/28/2007 - 14:29:18: [MYSQLX] Message: MySQL server has gone away (2006)
L 11/28/2007 - 14:29:18: [MYSQLX] Query statement: SELECT `player_id` FROM `wc3_player` WHERE `player_steamid` = 'STEAM_0:1:13719215'; 
L 11/28/2007 - 14:29:18: [ERROR] Unable to retreive user's (1) Unique ID, trying again...
L 11/28/2007 - 14:29:18: [MYSQLX] Error in querying database, location: 2
L 11/28/2007 - 14:29:18: [MYSQLX] Message: MySQL server has gone away (2006)
L 11/28/2007 - 14:29:18: [MYSQLX] Query statement: SELECT `player_id` FROM `wc3_player` WHERE `player_steamid` = 'STEAM_0:1:13719215'; 
L 11/28/2007 - 14:29:18: [ERROR] Unable to retreive user's (1) Unique ID, trying again...
L 11/28/2007 - 14:29:19: [MYSQLX] Error in querying database, location: 2
L 11/28/2007 - 14:29:19: [MYSQLX] Message: MySQL server has gone away (2006)
L 11/28/2007 - 14:29:19: [MYSQLX] Query statement: SELECT `player_id` FROM `wc3_player` WHERE `player_steamid` = 'STEAM_0:1:13719215'; 
L 11/28/2007 - 14:29:19: [ERROR] Unable to retreive user's (1) Unique ID, trying again...
L 11/28/2007 - 14:29:19: [MYSQLX] Error in querying database, location: 2
L 11/28/2007 - 14:29:19: [MYSQLX] Message: MySQL server has gone away (2006)
L 11/28/2007 - 14:29:19: [MYSQLX] Query statement: SELECT `player_id` FROM `wc3_player` WHERE `player_steamid` = 'STEAM_0:1:13719215'; 
L 11/28/2007 - 14:29:19: [ERROR] Unable to retreive user's (1) Unique ID, trying again...
L 11/28/2007 - 14:29:20: [MYSQLX] Error in querying database, location: 2
L 11/28/2007 - 14:29:20: [MYSQLX] Message: MySQL server has gone away (2006)
L 11/28/2007 - 14:29:20: [MYSQLX] Query statement: SELECT `player_id` FROM `wc3_player` WHERE `player_steamid` = 'STEAM_0:1:13719215'; 
L 11/28/2007 - 14:29:20: [ERROR] Unable to retreive user's (1) Unique ID, trying again...
L 11/28/2007 - 14:29:20: [MYSQLX] Error in querying database, location: 2
L 11/28/2007 - 14:29:20: [MYSQLX] Message: MySQL server has gone away (2006)
L 11/28/2007 - 14:29:20: [MYSQLX] Query statement: SELECT `player_id` FROM `wc3_player` WHERE `player_steamid` = 'STEAM_0:1:13719215'; 
L 11/28/2007 - 14:29:20: [ERROR] Unable to retreive user's (1) Unique ID, trying again...
L 11/28/2007 - 14:29:21: [MYSQLX] Error in querying database, location: 2
L 11/28/2007 - 14:29:21: [MYSQLX] Message: MySQL server has gone away (2006)
L 11/28/2007 - 14:29:21: [MYSQLX] Query statement: SELECT `player_id` FROM `wc3_player` WHERE `player_steamid` = 'STEAM_0:1:13719215'; 
L 11/28/2007 - 14:29:21: [ERROR] Unable to retreive user's (1) Unique ID, trying again...
L 11/28/2007 - 14:29:21: [MYSQLX] Error in querying database, location: 2
L 11/28/2007 - 14:29:21: [MYSQLX] Message: MySQL server has gone away (2006)
L 11/28/2007 - 14:29:21: [MYSQLX] Query statement: SELECT `player_id` FROM `wc3_player` WHERE `player_steamid` = 'STEAM_0:1:13719215'; 
L 11/28/2007 - 14:29:21: [ERROR] Unable to retreive user's (1) Unique ID, trying again...
L 11/28/2007 - 14:29:22: [MYSQLX] Error in querying database, location: 2
L 11/28/2007 - 14:29:22: [MYSQLX] Message: MySQL server has gone away (2006)
L 11/28/2007 - 14:29:22: [MYSQLX] Query statement: SELECT `player_id` FROM `wc3_player` WHERE `player_steamid` = 'STEAM_0:1:13719215'; 
L 11/28/2007 - 14:29:22: [ERROR] Unable to retreive user's (1) Unique ID, trying again...
L 11/28/2007 - 14:29:23: [MYSQLX] Error in querying database, location: 2
L 11/28/2007 - 14:29:23: [MYSQLX] Message: MySQL server has gone away (2006)
L 11/28/2007 - 14:29:23: [MYSQLX] Query statement: SELECT `player_id` FROM `wc3_player` WHERE `player_steamid` = 'STEAM_0:1:13719215'; 
L 11/28/2007 - 14:29:23: [ERROR] Unable to retreive user's (1) Unique ID, trying again...
L 11/28/2007 - 14:29:23: [MYSQLX] Error in querying database, location: 2
L 11/28/2007 - 14:29:23: [MYSQLX] Message: MySQL server has gone away (2006)
L 11/28/2007 - 14:29:23: [MYSQLX] Query statement: SELECT `player_id` FROM `wc3_player` WHERE `player_steamid` = 'STEAM_0:1:13719215'; 
L 11/28/2007 - 14:29:23: [ERROR] Unable to retreive user's (1) Unique ID, trying again...
L 11/28/2007 - 14:29:24: [MYSQLX] Error in querying database, location: 2
L 11/28/2007 - 14:29:24: [MYSQLX] Message: MySQL server has gone away (2006)
L 11/28/2007 - 14:29:24: [MYSQLX] Query statement: SELECT `player_id` FROM `wc3_player` WHERE `player_steamid` = 'STEAM_0:1:13719215'; 
L 11/28/2007 - 14:29:24: [ERROR] Unable to retreive user's (1) Unique ID, trying again...
L 11/28/2007 - 14:29:24: [MYSQLX] Error in querying database, location: 2
L 11/28/2007 - 14:29:24: [MYSQLX] Message: MySQL server has gone away (2006)
L 11/28/2007 - 14:29:24: [MYSQLX] Query statement: SELECT `player_id` FROM `wc3_player` WHERE `player_steamid` = 'STEAM_0:1:13719215'; 
L 11/28/2007 - 14:29:24: [ERROR] Unable to retreive user's (1) Unique ID, trying again...
L 11/28/2007 - 14:29:25: [MYSQLX] Error in querying database, location: 2
L 11/28/2007 - 14:29:25: [MYSQLX] Message: MySQL server has gone away (2006)
L 11/28/2007 - 14:29:25: [MYSQLX] Query statement: SELECT `player_id` FROM `wc3_player` WHERE `player_steamid` = 'STEAM_0:1:13719215'; 
L 11/28/2007 - 14:29:25: [ERROR] Unable to retreive user's (1) Unique ID, trying again...
L 11/28/2007 - 14:29:25: [MYSQLX] Error in querying database, location: 2
L 11/28/2007 - 14:29:25: [MYSQLX] Message: MySQL server has gone away (2006)
L 11/28/2007 - 14:29:25: [MYSQLX] Query statement: SELECT `player_id` FROM `wc3_player` WHERE `player_steamid` = 'STEAM_0:1:13719215'; 
L 11/28/2007 - 14:29:25: [ERROR] Unable to retreive user's (1) Unique ID, trying again...
L 11/28/2007 - 14:29:26: [MYSQLX] Error in querying database, location: 2
L 11/28/2007 - 14:29:26: [MYSQLX] Message: MySQL server has gone away (2006)
L 11/28/2007 - 14:29:26: [MYSQLX] Query statement: SELECT `player_id` FROM `wc3_player` WHERE `player_steamid` = 'STEAM_0:1:13719215'; 
L 11/28/2007 - 14:29:26: [ERROR] Unable to retreive user's (1) Unique ID, trying again...
L 11/28/2007 - 14:29:26: [MYSQLX] Error in querying database, location: 2
L 11/28/2007 - 14:29:26: [MYSQLX] Message: MySQL server has gone away (2006)
L 11/28/2007 - 14:29:26: [MYSQLX] Query statement: SELECT `player_id` FROM `wc3_player` WHERE `player_steamid` = 'STEAM_0:1:13719215'; 
L 11/28/2007 - 14:29:26: [ERROR] Unable to retreive user's (1) Unique ID, trying again...
L 11/28/2007 - 14:29:27: [MYSQLX] Error in querying database, location: 2
L 11/28/2007 - 14:29:27: [MYSQLX] Message: MySQL server has gone away (2006)
L 11/28/2007 - 14:29:27: [MYSQLX] Query statement: SELECT `player_id` FROM `wc3_player` WHERE `player_steamid` = 'STEAM_0:1:13719215'; 
L 11/28/2007 - 14:29:27: [ERROR] Unable to retreive user's (1) Unique ID, trying again...


User avatar
Geesu
<b>King of the world!</b>
Posts: 3159
Joined: Tue Jul 05, 2005 9:24 pm
Contact:

Post by Geesu » Wed Nov 28, 2007 10:35 am

That's crazy - literally one minute later the server goes away.... must be a connection limit...

Is there a way you can get the MySQL configuration information? Like the maximum amount of connections or requests allowed for your username? (should be available in phpmyadmin)
No Support via PM

deadeye
Peon
Posts: 7
Joined: Thu Nov 22, 2007 10:39 am

Post by deadeye » Wed Nov 28, 2007 11:22 am

At the extern server not. but now im configure a dedicated server with sql support. hop it will work then ;)

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

Post by slmclarengt » Thu Nov 29, 2007 3:33 am

I have this exact same issue and my "max connections" = 1,500

These errors fill my logs to over 200MB/day usually if not worse :-)

I hope Geesu (or someone) can find a fix to this. Perhaps revert to the old querying system instead of threaded queries, but I doubt Geesu wants to recode the whole storage include. So hopefully someone can provide insight to fixing the threaded query issue.

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

User avatar
Geesu
<b>King of the world!</b>
Posts: 3159
Joined: Tue Jul 05, 2005 9:24 pm
Contact:

Post by Geesu » Fri Nov 30, 2007 8:41 am

Max connections wuoldn't be an issue....

Is there a maximum queries variable or something?
No Support via PM

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

Post by slmclarengt » Sun Dec 02, 2007 9:10 pm

Geesu wrote:Max connections wuoldn't be an issue....

Is there a maximum queries variable or something?
Long query time = 10 (presumably seconds)

Screw it, here's my ENTIRE variable output list:

Code: Select all

 auto increment increment  	1
auto increment offset 	1
automatic sp privileges 	ON
back log 	50
basedir 	/
binlog cache size 	32,768
bulk insert buffer size 	8,388,608
character set client 	utf8
(Global value) 	latin1
character set connection 	utf8
(Global value) 	latin1
character set database 	latin1
character set filesystem 	binary
character set results 	utf8
(Global value) 	latin1
character set server 	latin1
character set system 	utf8
character sets dir 	/usr/share/mysql/charsets/
collation connection 	utf8_unicode_ci
(Global value) 	latin1_swedish_ci
collation database 	latin1_swedish_ci
collation server 	latin1_swedish_ci
completion type 	0
concurrent insert 	1
connect timeout 	5
datadir 	/var/lib/mysql/
date format 	%Y-%m-%d
datetime format 	%Y-%m-%d %H:%i:%s
default week format 	0
delay key write 	ON
delayed insert limit 	100
delayed insert timeout 	300
delayed queue size 	1,000
div precision increment 	4
engine condition pushdown 	OFF
expire logs days 	0
flush 	OFF
flush time 	0
ft boolean syntax 	+ -><()~*:""&|
ft max word len 	84
ft min word len 	4
ft query expansion limit 	20
ft stopword file 	(built-in)
group concat max len 	1,024
have archive 	YES
have bdb 	NO
have blackhole engine 	NO
have compress 	YES
have crypt 	YES
have csv 	NO
have dynamic loading 	YES
have example engine 	NO
have federated engine 	NO
have geometry 	YES
have innodb 	DISABLED
have isam 	NO
have merge engine 	YES
have ndbcluster 	NO
have openssl 	NO
have query cache 	YES
have raid 	NO
have rtree keys 	YES
have symlink 	YES
init connect 	
init file 	
init slave 	
innodb additional mem pool size 	1,048,576
innodb autoextend increment 	8
innodb buffer pool awe mem mb 	0
innodb buffer pool size 	8,388,608
innodb checksums 	ON
innodb commit concurrency 	0
innodb concurrency tickets 	500
innodb data file path 	
innodb data home dir 	
innodb doublewrite 	ON
innodb fast shutdown 	1
innodb file io threads 	4
innodb file per table 	OFF
innodb flush log at trx commit 	1
innodb flush method 	
innodb force recovery 	0
innodb lock wait timeout 	50
innodb locks unsafe for binlog 	OFF
innodb log arch dir 	
innodb log archive 	OFF
innodb log buffer size 	1,048,576
innodb log file size 	5,242,880
innodb log files in group 	2
innodb log group home dir 	
innodb max dirty pages pct 	90
innodb max purge lag 	0
innodb mirrored log groups 	1
innodb open files 	300
innodb support xa 	ON
innodb sync spin loops 	20
innodb table locks 	ON
innodb thread concurrency 	8
innodb thread sleep delay 	10,000
interactive timeout 	28,800
join buffer size 	131,072
key buffer size 	67,108,864
key cache age threshold 	300
key cache block size 	1,024
key cache division limit 	100
language 	/usr/share/mysql/english/
large files support 	ON
large page size 	0
large pages 	OFF
lc time names 	en_US
license 	GPL
local infile 	ON
locked in memory 	OFF
log 	OFF
log bin 	OFF
log bin trust function creators 	OFF
log error 	
log queries not using indexes 	OFF
log slave updates 	OFF
log slow queries 	OFF
log warnings 	1
long query time 	10
low priority updates 	OFF
lower case file system 	OFF
lower case table names 	0
max allowed packet 	15,727,616
max binlog cache size 	4,294,967,295
max binlog size 	1,073,741,824
max connect errors 	100,000
max connections 	1,500
max delayed threads 	20
max error count 	64
max heap table size 	16,777,216
max insert delayed threads 	20
max join size 	18446744073709551615
max length for sort data 	1,024
max prepared stmt count 	16,382
max relay log size 	0
max seeks for key 	4,294,967,295
max sort length 	1,024
max sp recursion depth 	0
max tmp tables 	32
max user connections 	50
max write lock count 	4,294,967,295
multi range count 	256
myisam data pointer size 	6
myisam max sort file size 	2,147,483,647
myisam recover options 	OFF
myisam repair threads 	1
myisam sort buffer size 	8,388,608
myisam stats method 	nulls_unequal
net buffer length 	16,384
net read timeout 	30
net retry count 	10
net write timeout 	60
new 	OFF
old passwords 	ON
open files limit 	10,000
optimizer prune level 	1
optimizer search depth 	62
pid file 	/var/lib/mysql/elara.lunarservers.com.pid
port 	3,306
preload buffer size 	32,768
prepared stmt count 	0
protocol version 	10
query alloc block size 	8,192
query cache limit 	1,048,576
query cache min res unit 	4,096
query cache size 	33,554,432
query cache type 	ON
query cache wlock invalidate 	OFF
query prealloc size 	8,192
range alloc block size 	2,048
read buffer size 	1,044,480
read only 	OFF
read rnd buffer size 	262,144
relay log purge 	ON
relay log space limit 	0
rpl recovery rank 	0
secure auth 	OFF
server id 	0
skip external locking 	ON
skip networking 	OFF
skip show database 	OFF
slave compressed protocol 	OFF
slave load tmpdir 	/tmp/
slave net timeout 	3,600
slave skip errors 	OFF
slave transaction retries 	10
slow launch time 	2
socket 	/var/lib/mysql/mysql.sock
sort buffer size 	4,194,296
sql big selects 	ON
sql mode 	
sql notes 	ON
sql warnings 	OFF
ssl ca 	
ssl capath 	
ssl cert 	
ssl cipher 	
ssl key 	
storage engine 	MyISAM
sync binlog 	0
sync frm 	ON
system time zone 	PST
table cache 	256
table lock wait timeout 	50
table type 	MyISAM
thread cache size 	0
thread stack 	196,608
time format 	%H:%i:%s
time zone 	SYSTEM
timed mutexes 	OFF
tmp table size 	33,554,432
tmpdir 	/tmp/
transaction alloc block size 	8,192
transaction prealloc size 	4,096
tx isolation 	REPEATABLE-READ
updatable views with limit 	YES
version 	5.0.27-standard
version comment 	MySQL Community Edition - Standard (GPL)
version compile machine 	i686
version compile os 	pc-linux-gnu
wait timeout 	200
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.)

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

Post by slmclarengt » Mon Dec 03, 2007 11:13 pm

To add on, I really would like a functioning Pruning feature for MySQL because even with the proper configuration, it doesn't prune anything and I've got over 80,000 rows in my tables.

New error:

Code: Select all

L 12/04/2007 - 00:59:06: [war3ft.amxx] [ERROR] Unable to retreive user's (18) Unique ID, trying again...
L 12/04/2007 - 00:59:06: [war3ft.amxx] [ERROR] Unable to retreive user's (7) Unique ID, trying again...
I am desperate for any type of SQL script to "prune" my database, any scripts you could conjure up to at least manually prune the DB because I can make it a cron job anyways... Loading so much information/retrieving/writing to it so much is intense on it and causes lag/crashes due to timeouts.

Thank you in advance,

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

Post Reply