| View previous topic :: View next topic |
| Author |
Message |
Dracos
Joined: 16 Oct 2006
Posts: 21
|
 Posted: Tue Feb 06, 2007 0:38 Post subject: MySQL server has gone away |
 |
|
Today happened something really strange.
xp-mysql log reported at every query "Mysql server has gone away" but the module was up and running and so was the MySQL instance. I noticed that NWN_GUI had restarted the server once (which was running for 35 hours).
My login script couldn't function because the connection DB-module was cut off for real.
What's up?  |
|
| Back to top |
|
 |
Papillon
x-man
Joined: 28 Dec 2004
Posts: 1060
Location: Germany
|
|
| Back to top |
|
|
Dracos
Joined: 16 Oct 2006
Posts: 21
|
| Posted: Tue Feb 06, 2007 17:49 Post subject: |
|
|
DAMN YES! THANKS Papillon!!!  |
|
| Back to top |
|
|
Larnak
Joined: 25 Sep 2006
Posts: 7
Location: Southern California
|
| Posted: Sun Feb 11, 2007 18:17 Post subject: |
|
|
I was having this issue as well when I first implemented NWNX4 on the server. It would just stop pulling the data after a period of inactivity, so I figured it was a timeout issue.
Not being very familiar with MySQL and not being patient enough to solve it on the MySQL side, I just wote a function in the module heartbeat script that pulls and updates a number every minute.
This gave me two things: 1. It kept the server connection alive, and 2. it gave me a rough count in minutes of how long the server has been up.
I guess I will look at the MySQL side of things as well now that I have a link to read. 
_________________
Adventures in the Shining South PW |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
