Cant connect to database error

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

Moderator: Forum Moderator

Post Reply
Senne
Rifleman
Posts: 164
Joined: Wed Feb 21, 2007 9:22 am

Cant connect to database error

Post by Senne » Mon Aug 20, 2007 3:50 pm

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

User avatar
*ZhG*RasterMan
Militia
Posts: 66
Joined: Fri Sep 23, 2005 7:58 am
Location: Luton, UK
Contact:

Post by *ZhG*RasterMan » Wed Sep 05, 2007 10:19 am

Im in the same situation :roll:
Image

kp_downarrow
Rifleman
Posts: 162
Joined: Thu Dec 21, 2006 2:12 am

Post by kp_downarrow » Wed Sep 05, 2007 10:57 pm

it just randomly does that

Senne
Rifleman
Posts: 164
Joined: Wed Feb 21, 2007 9:22 am

Post by Senne » Mon Sep 10, 2007 2:05 pm

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 .

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

Post by YamiKaitou » Mon Sep 10, 2007 3:12 pm

What is the version of the MySQL server?
Image

No support via PM or Email

Senne
Rifleman
Posts: 164
Joined: Wed Feb 21, 2007 9:22 am

Post by Senne » Tue Sep 11, 2007 1:43 am

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.

Senne
Rifleman
Posts: 164
Joined: Wed Feb 21, 2007 9:22 am

Post by Senne » Tue Sep 11, 2007 2:55 pm

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

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

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

Yea I'm not sure what to do here - can you tell me what the ping is between the servers?
No Support via PM

Senne
Rifleman
Posts: 164
Joined: Wed Feb 21, 2007 9:22 am

Post by Senne » Wed Sep 12, 2007 7:46 pm

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

User avatar
*ZhG*RasterMan
Militia
Posts: 66
Joined: Fri Sep 23, 2005 7:58 am
Location: Luton, UK
Contact:

Post by *ZhG*RasterMan » Thu Sep 13, 2007 11:55 am

My map change is 20 mins
Image

Senne
Rifleman
Posts: 164
Joined: Wed Feb 21, 2007 9:22 am

Post by Senne » Thu Sep 13, 2007 12:08 pm

*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?

TheEagle
Peon
Posts: 1
Joined: Sat Sep 29, 2007 2:51 pm

Post by TheEagle » Sat Sep 29, 2007 4:23 pm

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.

Senne
Rifleman
Posts: 164
Joined: Wed Feb 21, 2007 9:22 am

Post by Senne » Mon Oct 01, 2007 9:04 am

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

Post Reply