[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
Support Forum • View topic - Sam is acting crazy. I think I know why. Not sure how to fix - spacial.com
Skip to Content
It is currently September 27th, 2023, 8:19 pm

All times are UTC - 6 hours [ DST ]

 [ 2 posts ] 
Author Message
PostPosted: September 12th, 2019, 9:59 am 
Senior User
Senior User

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

PostPosted: September 16th, 2019, 10:29 am 
SVS Member
SVS Member

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

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

Display posts from previous:  Sort by  
 [ 2 posts ] 

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:  
Powered by phpBB® Forum Software © phpBB Group