My station has been running for many years. It is running now on SAM 2017.5 heavily relied on PAL. I use MySQL 5.6 as the database.
Two days ago SAM started freezing. I managed to pin point the problem, but I have no idea how to fix it.
The freeze occurs in the line "if (AQuery.BOF and AQuery.EOF) then //no request made". You need to have a requests pending in the request queue to reproduce this issue.
AQuery := Query('SELECT songlist.*, requestlist.*, requestlist.ID as requestID '
+' FROM songlist, requestlist '
+' WHERE (requestlist.ETA<:now) AND (requestlist.status=''new'') AND (songlist.ID=requestlist.songID) '
+ 'ORDER BY requestlist.ETA ASC '
+' LIMIT 1 ',[Now],True);
if (AQuery.BOF and AQuery.EOF) then //no request made
//do some stuff
For now I disabled requests so my station can continue running. I also run a check on the database and everything seem to be OK.