Sorry to dig up an old topic but I encounter a lot of this “database locked” error during mairlist execution with my version (the latest release update).
And the real problem is that, sometimes, this error generates a silent on air between two tracks…
Here is an extract of the today log :
|2024-07-28 17:45:20|Playlist|Start: D:\HABILLAGE\HABILLAGE 02\JINGLE COURT 13.mp3|
|---|---|---|
|2024-07-28 17:45:23|Playlist|Stop: D:\SONGS\HEAVEN-ORIGINAL\Avril Lavigne - When You-'re Gone.flac (233 seconds)|
|2024-07-28 17:45:27|Playlist|Start: D:\SONGS\HEAVEN-ORIGINAL\Jean-Jacques Goldman - Quand la musique est bonne.flac|
|2024-07-28 17:45:28|Playlist|Stop: D:\HABILLAGE\HABILLAGE 02\JINGLE COURT 13.mp3 (8 seconds)|
|2024-07-28 17:49:04|Debug|Caching playlists for Heaven REWIND / REPLAY|
|2024-07-28 17:49:04|Playlist|Start: D:\HABILLAGE\HABILLAGE 01\JINGLE COURT 4.WAV|
|2024-07-28 17:49:06|Playlist|Stop: D:\SONGS\HEAVEN-ORIGINAL\Jean-Jacques Goldman - Quand la musique est bonne.flac (219 seconds)|
|2024-07-28 17:49:14|Error|Error writing log entry into database Heaven REWIND / REPLAY: [FireDAC][Phys][SQLite] ERROR: database is locked|
|2024-07-28 17:49:15|Playlist|Stop: D:\HABILLAGE\HABILLAGE 01\JINGLE COURT 4.WAV (10 seconds)|
|2024-07-28 17:49:24|Error|Error writing log entry into database Heaven REWIND / REPLAY: [FireDAC][Phys][SQLite] ERROR: database is locked|
|2024-07-28 17:49:24|Playlist|Start: D:\SONGS\HEAVEN-ORIGINAL\Hoobastank - If I Were You.flac|
As you can see at the end, there are 2 “database is locked” errors. The problem is that at this moment, the track “Hoobastank - If I Ware You” took 9 seconds to start (at 17:49:24) after the previous track ended (jingle that ended at 17:49:15). I had a silent on air, that is not very good !!!
This kind of error occured at other moment of the day, but if I check the log time, it seems there was no silent on air…
I use Mairlist 7.3.6 build 5650.
Any idea to fix it ?
(One more question: if I upgrade to mairlist advanced server with mairlistDB server, will this issue occur again ? or will it be better ?)
Regards,
Sylvain