Database file gets corrupted after 1-2 weeks

Started by Tim Dimi

Tim Dimi

Database file gets corrupted after 1-2 weeks   28 January 2020, 08:51

Hi,
Been using the newest version for a while and I've noticed that from about 1-2 weeks randomly after a reset, my db file prevents the service starting.
I have tried to re-install and reload my rules.
Would keeping storage records for only 1 day prevent this?
SoftPerfect Support forum - Andrew avatar image

Re: Database file gets corrupted after 1-2 weeks   28 January 2020, 14:26

Do you mean a hardware reset with the button that forces the computer to restart? If so, it is not recommended.

While the SQLite database engine we are using is corruption-resistant, it may still be damaged in certain conditions. Here is a technical article describing how a corruption can occur in SQLite.

Reply to this topic

Sometimes you can find a solution faster if you try the forum search, have a look at the knowledge base, or check the software user manual to see if your question has already been answered.

Our forum rules are simple:

  • Be polite.
  • Do not spam.
  • Write in English. If possible, check your spelling and grammar.

Author:

Email:

Subject

A brief and informative title for your message, approximately 4–8 words:

     

Spam prevention: please enter the following code in the input field below.

 ********   ********  **      **  ********  ********  
 **     **     **     **  **  **  **    **  **     ** 
 **     **     **     **  **  **      **    **     ** 
 ********      **     **  **  **     **     **     ** 
 **            **     **  **  **    **      **     ** 
 **            **     **  **  **    **      **     ** 
 **            **      ***  ***     **      ********  

Message: