Raised This Month: $10 Target: $400
 2% 

Solved [CS:GO] SQL_TQuery, script execution timed out


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Author Message
kadet.89
Veteran Member
Join Date: Nov 2012
Old 05-13-2021 , 14:15   [CS:GO] SQL_TQuery, script execution timed out
Reply With Quote #1

I experience "Script execution timed out" on my server every day. Most often it ends up in a sequence of server crashes with "SIGABRT" reason (usually about 3-5 crashes in a row).

Here is an example of console messages right before a crash:
Code:
L 05/13/2021 - 17:41:37: [plugin.smx] ALTER TABLE table1 CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
L 05/13/2021 - 17:41:37: [SM] Exception reported: Script execution timed out
L 05/13/2021 - 17:41:37: [SM] Blaming: plugin.smx
L 05/13/2021 - 17:41:37: [SM] Call stack trace:
L 05/13/2021 - 17:41:37: [SM]   [0] SQL_TQuery
L 05/13/2021 - 17:41:37: [SM]   [1] Line 14, plugin::GotDatabase
L 05/13/2021 - 17:41:37: [plugin.smx] SQL ERROR
L 05/13/2021 - 17:41:37: [plugin.smx] Multiple primary key defined
#
#Console initialized.
#Using breakpad minidump system 740/13790.1272.DC
#Loading VPK file hashes for pure server operation.
#Loading VPK file hashes for pure server operation.
#Loading VPK file hashes for pure server operation.
#Loading VPK file hashes for pure server operation.
This query is executed on every map change and sometimes I get such exceptions. Sometimes the server crashes after printing the ALTER TABLE message without printing anything else.
It seems that some blocking situation happens there from time to time. Usually execution of this query takes much less than 1 second. But sometimes much more time is requried.
Is there a way to avoid server crashes when execution takes a lot of time? Is there a way to make execution of the query non-blocking? The plugin is in the attachment.
Also there is a crashstack, which has little data though. I think the reason for the crash might be the server's watchdog.
Attached Files
File Type: sp Get Plugin or Get Source (test.sp - 19 views - 6.0 KB)
File Type: txt dmp.txt (108.5 KB, 13 views)

Last edited by kadet.89; 05-21-2021 at 17:41.
kadet.89 is offline
Send a message via Skype™ to kadet.89
 


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 12:07.


Powered by vBulletin®
Copyright ©2000 - 2021, vBulletin Solutions, Inc.
Theme made by Freecode