View previous topic :: View next topic |
Author |
Message |
Extreme
Joined: 28 Nov 2007 Posts: 135
|
Posted: Tue Apr 08, 2008 2:29 Post subject: My database keeps going away |
|
|
Now i did find the thread that is already here concerning this and i made those edits but i still have the issue and am not fully sure what the problem is.
this is the section of the shh in question
Code: | [nwntrego@dedicated97 modules]$ screen -r nwserver
1207613330 o ERROR: DB went away
1207613330 o ERROR: DB went away
1207613337 o ERROR: DB went away
1207613337 o ERROR: DB went away
1207613337 o ERROR: DB went away
1207613338 o ERROR: DB went away
1207613338 o ERROR: DB went away
1207613356 o ERROR: DB went away
1207613356 o ERROR: DB went away
1207613374 o ERROR: DB went away
1207613374 o ERROR: DB went away
1207613374 o ERROR: DB went away
1207613374 o ERROR: DB went away
1207613374 o ERROR: DB went away
1207613374 o ERROR: DB went away
1207613374 o ERROR: DB went away
1207613374 o ERROR: DB went away
1207613374 o ERROR: DB went away
1207613374 o ERROR: DB went away
1207613471 o ERROR: DB went away
1207613771 o ERROR: DB went away
1207614071 o ERROR: DB went away
1207614371 o ERROR: DB went away
|
not i have put these script in the mod
this is OnModLoad
Code: | ExecuteScript("db_keepalive", OBJECT_SELF); |
and the script in question
Code: | //:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::://
//:: Script to keep the database from going away. Leave this ALONE!!!! :://
//:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::://
#include "aps_include"
void main()
{
SQLExecDirect("SELECT 1");
DelayCommand(300.0, ExecuteScript("db_keepalive", GetModule()));
} |
is there something wrong? |
|
Back to top |
|
|
Extreme
Joined: 28 Nov 2007 Posts: 135
|
Posted: Tue Apr 08, 2008 7:57 Post subject: |
|
|
I realized that I am so used to looking in this particular forum that I posted this thread in the wrong forum.
Could a moderator by chance be so kind as to move this to the database forum and not tar and feather me toooo bad |
|
Back to top |
|
|
TroveLord
Joined: 22 Nov 2006 Posts: 136 Location: Italy
|
Posted: Tue Apr 08, 2008 23:50 Post subject: |
|
|
Reduce the delay. |
|
Back to top |
|
|
Extreme
Joined: 28 Nov 2007 Posts: 135
|
Posted: Wed Apr 09, 2008 8:39 Post subject: |
|
|
The db goes away within minutes. its set to 5 now. won't cuting it down to 1 minute cause lag?
I can't help but think something is causing it in first place. And the server (to my knowledge) can still save & pull from db tho. |
|
Back to top |
|
|
TroveLord
Joined: 22 Nov 2006 Posts: 136 Location: Italy
|
Posted: Wed Apr 09, 2008 13:31 Post subject: |
|
|
I have a 300 seconds timer and works, try with 150 or better, use the 1.09 release which has an automatic reconnect feature. |
|
Back to top |
|
|
Extreme
Joined: 28 Nov 2007 Posts: 135
|
Posted: Wed Apr 09, 2008 15:56 Post subject: |
|
|
1.09? o.O
I will admit to not being up to date...but is this nwnx? is it the new 1.69 update to nwnx? |
|
Back to top |
|
|
TroveLord
Joined: 22 Nov 2006 Posts: 136 Location: Italy
|
|
Back to top |
|
|
Extreme
Joined: 28 Nov 2007 Posts: 135
|
Posted: Wed Apr 09, 2008 19:12 Post subject: |
|
|
yeah when i got home i seen it. its hard to search when on a phone |
|
Back to top |
|
|
Extreme
Joined: 28 Nov 2007 Posts: 135
|
Posted: Wed Apr 09, 2008 19:15 Post subject: |
|
|
it sounds as if the ping doesnt work with a low time frame, i will ahve to wait on 1.09 |
|
Back to top |
|
|
TroveLord
Joined: 22 Nov 2006 Posts: 136 Location: Italy
|
|
Back to top |
|
|
virusman
Joined: 30 Jan 2005 Posts: 1020 Location: Russia
|
Posted: Wed Apr 09, 2008 21:59 Post subject: |
|
|
Seems like you're talking about different versions of NWNX. Extreme is running NWN1 and NWNX2. |
|
Back to top |
|
|
Extreme
Joined: 28 Nov 2007 Posts: 135
|
Posted: Thu Apr 10, 2008 1:19 Post subject: |
|
|
Talk about totally missing that point
meh...square one |
|
Back to top |
|
|
|