Support forum

Advanced Search

— Forum Scope —

— Match —

— Forum Options —

Minimum search word length is 3 characters - maximum search word length is 84 characters

Database File is locked
sp_NewPost Add Reply sp_NewTopic Add Topic
June 21, 2021
4:01 pm
Henk Helmantel
Forum Posts: 1502
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

Hello Itai,

This error means that one of the internal database files in Diafaan SMS Server has a problem. Usually the problem is in the log database of Diafaan SMS Server because this file is used by both the service and the console program. The database is self-repairing but if the log database file gets too big it may take a long time to repair and in the mean time the console program cannot open the database file.

It is important to keep the log database file small to prevent database corruption, by default Diafaan SMS Server limits the number of records in the log to 10,000 records per log and I recommend to keep it at that value. If the error does not resolve itself you might have to remove the database file manually. The log database files are located at: 'C:\ProgramData\Diafaan\Diafaan Message Server\MessageLog.sqlite' and 'C:\ProgramData\Diafaan\Diafaan Message Server\MessageLog.sqlite-journal'. The files can only be removed if both the service and the console program are closed.

Regards, Henk

June 21, 2021
1:57 pm
Itai Manyere

I am seeing this error in my Diafaan application. What could be the issue and how can i resolve it?

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
2 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 677

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1149

Posts: 3928

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1502