Page 1 of 1
Cant connect to database error
Posted: Mon Aug 20, 2007 3:50 pm
by Senne
RC8.0 v3.0
Mysql is up, warcraft always worked well,
but after updating to this newer version ( a week ago) , the server started losing connection to the mysql in the middle of a map.
I checked and double checked if the mysql is up, and yep its up, since my amxban list also uses the same mysql server and is up and running, and the war3ft stats are also up.
The error logs are getting large as well, never seen that before, but now im getting 120 mb error logs after 1 day with this newer version.
Code: Select all
L 08/20/2007 - 16:48:26: [war3ft.amxx] [MYSQLX] Error in querying database, location: 2
L 08/20/2007 - 16:48:26: [war3ft.amxx] [MYSQLX] Message: MySQL server has gone away (2006)
L 08/20/2007 - 16:48:26: [war3ft.amxx] [MYSQLX] Query statement: SELECT `player_id` FROM `wc3_player` WHERE `player_steamid` = 'STEAM_0:1:15803779';
L 08/20/2007 - 16:48:26: [war3ft.amxx] [ERROR] Unable to retreive user's (3) Unique ID, trying again...
L 08/20/2007 - 16:48:26: [war3ft.amxx] [MYSQLX] Error in querying database, location: 2
L 08/20/2007 - 16:48:26: [war3ft.amxx] [MYSQLX] Message: MySQL server has
edit: after a mapchange everything was back fine, players reported me that this happens a few times a day
Posted: Wed Sep 05, 2007 10:19 am
by *ZhG*RasterMan
Im in the same situation
Posted: Wed Sep 05, 2007 10:57 pm
by kp_downarrow
it just randomly does that
Posted: Mon Sep 10, 2007 2:05 pm
by Senne
seems like a bug, i posted in the bugs section but i guess it was moved over here...
to bad tho it really happens a lot and has nothing to do with the setup or mysql server .
Posted: Mon Sep 10, 2007 3:12 pm
by YamiKaitou
What is the version of the MySQL server?
Posted: Tue Sep 11, 2007 1:43 am
by Senne
MySQL version 4.1.22-standard
never had any mysql issues before i updated to the newer version : wc3ft v3.0 RC8.0
its not like it happens always, but it does happens one map a day orso, and auto fixes it self at mapchange.
Posted: Tue Sep 11, 2007 2:55 pm
by Senne
it seems to happen more when there are more players in the server.
The mysql servers is in the same building as my gameserver and has normally no delays, and everything was fine untill i updated from RC5.0 to RC8.0.
My xp database is currently 460kb (is that to big?)
Posted: Wed Sep 12, 2007 9:14 am
by Geesu
Yea I'm not sure what to do here - can you tell me what the ping is between the servers?
Posted: Wed Sep 12, 2007 7:46 pm
by Senne
no ping , its like 1 meter from each other
I just wish to know if its just me-servers or if any on is experience the same thing with this new version?
I currently changed maptime to 15 minutes since it always happens to the end of a map (it was set to 25 before). I hope this helps
Posted: Thu Sep 13, 2007 11:55 am
by *ZhG*RasterMan
My map change is 20 mins
Posted: Thu Sep 13, 2007 12:08 pm
by Senne
*ZhG*RasterMan wrote:My map change is 20 mins
and you have the exact same issues as mine?
updated to Rc8.0
no mysql problems before update
lost connection to mysql to the end of a map sometimes?
Posted: Sat Sep 29, 2007 4:23 pm
by TheEagle
Took me a while to figure out it was the recent WC3 update that made my own sql-ban plugin not work anymore.
Thought I'd share my solution: My plugin was using <dbi>, rewrote it to <SQLx>, then it worked. Might work with dbi too, if you start a new connection in every function that has SQL calls.
Still there something fishy with RC8(or some version > RC3 which I used before), since I never had problems before.
Posted: Mon Oct 01, 2007 9:04 am
by Senne
TheEagle wrote:
Still there something fishy with RC8(or some version > RC3 which I used before), since I never had problems before.
yea there is.. i hope it gets solved in the end