Skip to Content
It is currently November 17th, 2019, 4:39 am

All times are UTC - 6 hours [ DST ]




Post new topic Reply to topic  [ 2 posts ] 
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  
PostPosted: September 16th, 2019, 10:29 am 
Offline
SVS Member
SVS Member

Joined: December 6th, 2004, 9:00 am
Posts: 7882
Location: Aachen (Germany)
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)

We're offering custom PAL / PHP code and general SAM assistance at palscripts.com

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


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

All times are UTC - 6 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 5 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:  
Powered by phpBB® Forum Software © phpBB Group