Skip to Content
It is currently September 15th, 2019, 12:44 am

All times are UTC - 6 hours [ DST ]




Post new topic Reply to topic  [ 1 post ] 
Author Message
PostPosted: September 12th, 2019, 9:59 am 
Offline
Senior User
Senior User

Joined: September 12th, 2012, 9:42 pm
Posts: 90
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.


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 1 post ] 

All times are UTC - 6 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group