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: