Author Topic: PRC/CEP Database Issue  (Read 368 times)

Legacy_TemplarDrake

  • Newbie
  • *
  • Posts: 34
  • Karma: +0/-0
PRC/CEP Database Issue
« on: February 03, 2016, 10:06:20 am »


               

Hi guys!


 


I really hope someone will be willng to help me out.


 


My resident code monkey is going through a lot of awesome stuff right now, but that unfortunately means he doesn't have a lot of time!


 


I've been trying to get a PRC/CEP Server running for a long time.


 


The biggest issue at the moment is that it runs perfectly for about a weeks time and then somehow it crashes on itself. As far as we can tell it is a database issue, but it doesn't give us any proper information as to why this happens. A part of the PRC source code creates a bioware database and eventually gets corrupted!


 


So I either need someone who's willing to help me out hands on or some way of debugging the issue.


 


Thanks in advance!


 


Drake



               
               

               
            

Legacy_Lightfoot8

  • Hero Member
  • *****
  • Posts: 4797
  • Karma: +0/-0
PRC/CEP Database Issue
« Reply #1 on: February 04, 2016, 01:10:05 am »


               

It sounds like you are bloating you DB.   It is a common problem with the nwn DB.  Doing it in a weeks time is a bit extreme and makes it sound like you are making many redundant store calls to the data base.  You will want to look into how often you are storing stuff in it and if you are doing so more often then necessary.   That will be your long term fix.  


 


  


even after you have trimmed  down the amount of unnecessary  calls to the NWNDB it still suffers from a bloat problem and need to be deflated once in a while.   It sounds like with the way your server is currently storing information you should do it once a day.  


 


To deflate you DB goto the  \NeverwinterNights\NWN\utils folder and run the DataPack.exe program.    


               
               

               
            

Legacy_TemplarDrake

  • Newbie
  • *
  • Posts: 34
  • Karma: +0/-0
PRC/CEP Database Issue
« Reply #2 on: February 04, 2016, 11:54:35 am »


               

So it is related to the limit of the DB? I seem to remember there being a max limit or something.


 


So by removing some of these calls and setting an automated reset "once in a while" would work?


 


Thanks for your reply!


 


- Drake