Sam has been acting crazy lately. It crashes from time to time and pal scripts fail to run properly. It seems as though Sams internal clock is out of sync with the system clock and pal scripts will just sit there waiting for an event time that comes and goes. The thing is that I've been running the same scripts for years so I know it's not a scripting issue.

I believe this might be a MYSQL issue. Maybe the database server is running too many queries at once and when SAM comes to the point of accessing the database it cannot so it either skips the action, crashes, or the time expires. Since i have everything programmed like this:
Pal.WaitForTime ('XX:00:00); it waits for the next hour.

Any ideas how to troubleshoot this? I know I need to check mysql logs but what should I increase? Run time on scripts? Memory? I don't know.

I am not running websites on that server but I am copying the SAM database to a back up server every 30 minutes or so.

Any thoughts would be greatly appreciated.

Are you locking your database while performing the backup or at least run the backup in a single transaction (or maybe one per table)?
That could definitely cause hiccups for SAM as it's unlikely to have been updated for MySQL transaction support in mind.

_________________
Benedikt Bauer - SVS (Spacial Volunteer Support)

Shop for readymade PAL scripts by countrywesterndj - Or get a custom script made by me (or others)

My Project:
Send "Now Playing" from SAM to Twitter and/or Facebook | Sourcecode