logo logo

 Back to main page

The NWNX Community Forum

 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
My database keeps going away

 
Post new topic   Reply to topic    nwnx.org Forum Index -> Database related
View previous topic :: View next topic  
Author Message
Extreme



Joined: 28 Nov 2007
Posts: 135

PostPosted: Tue Apr 08, 2008 2:29    Post subject: My database keeps going away Reply with quote

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
View user's profile Send private message
Extreme



Joined: 28 Nov 2007
Posts: 135

PostPosted: Tue Apr 08, 2008 7:57    Post subject: Reply with quote

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 Embarassed
Back to top
View user's profile Send private message
TroveLord



Joined: 22 Nov 2006
Posts: 136
Location: Italy

PostPosted: Tue Apr 08, 2008 23:50    Post subject: Reply with quote

Reduce the delay.
Back to top
View user's profile Send private message
Extreme



Joined: 28 Nov 2007
Posts: 135

PostPosted: Wed Apr 09, 2008 8:39    Post subject: Reply with quote

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
View user's profile Send private message
TroveLord



Joined: 22 Nov 2006
Posts: 136
Location: Italy

PostPosted: Wed Apr 09, 2008 13:31    Post subject: Reply with quote

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
View user's profile Send private message
Extreme



Joined: 28 Nov 2007
Posts: 135

PostPosted: Wed Apr 09, 2008 15:56    Post subject: Reply with quote

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
View user's profile Send private message
TroveLord



Joined: 22 Nov 2006
Posts: 136
Location: Italy

PostPosted: Wed Apr 09, 2008 19:11    Post subject: Reply with quote

http://nwnx.org/phpBB2/viewtopic.php?t=1054
Back to top
View user's profile Send private message
Extreme



Joined: 28 Nov 2007
Posts: 135

PostPosted: Wed Apr 09, 2008 19:12    Post subject: Reply with quote

yeah when i got home i seen it. its hard to search when on a phone
Back to top
View user's profile Send private message
Extreme



Joined: 28 Nov 2007
Posts: 135

PostPosted: Wed Apr 09, 2008 19:15    Post subject: Reply with quote

it sounds as if the ping doesnt work with a low time frame, i will ahve to wait on 1.09
Back to top
View user's profile Send private message
TroveLord



Joined: 22 Nov 2006
Posts: 136
Location: Italy

PostPosted: Wed Apr 09, 2008 20:04    Post subject: Reply with quote

Nothing to wait, use the preview, it's stable enough.
http://nwnx.org/fileadmin/download/nwnx4_109_preview1.zip
Back to top
View user's profile Send private message
virusman



Joined: 30 Jan 2005
Posts: 1020
Location: Russia

PostPosted: Wed Apr 09, 2008 21:59    Post subject: Reply with quote

Seems like you're talking about different versions of NWNX. Extreme is running NWN1 and NWNX2.
Back to top
View user's profile Send private message Visit poster's website Yahoo Messenger
Extreme



Joined: 28 Nov 2007
Posts: 135

PostPosted: Thu Apr 10, 2008 1:19    Post subject: Reply with quote

Shocked

Talk about totally missing that point Embarassed

meh...square one
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    nwnx.org Forum Index -> Database related All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group