Raised This Month: $12 Target: $400
 3% 

Mysql Crashing Server on some plugins


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
mR_SMoking
Junior Member
Join Date: Sep 2017
Location: Portugal
Old 07-15-2018 , 12:08   Mysql Crashing Server on some plugins
Reply With Quote #1

Hi, Some of my server plugins are confgured to use mysql instead of Sqlite. For example sourcebans only works with mysql, but this is crashing my server since last update.

Crash Report:
https://crash.limetech.org/6kgv6ydvojip

databases.cfg configuration:
HTML Code:
"sourcebans"
    {
        "driver"            "default"
        "host"              "xxx.xx.x.xxx"
        "database"          "yjdmdlgo_puntpt_sourcebans"
        "user"              "yjdmdlgo_puntpt_sourcebans"
        "pass"              "hidden for security reasons"
        "port"          	"3306"
		"timeout"			"60"
}
Console output:
HTML Code:
**** WARNING: Watchdog timer exceeded, aborting!
Wrote minidump to: /home/velihost/xx.xxx.xx.xxx-50004/csgo/addons/sourcemod/data/dumps/71041a4c-3af3-4916-ba88a58a-78ab0817.dmp
Aborted (core dumped)
Add "-debug" to the ./srcds_run command line to generate a debug.log to help with solving this problem
Sun 15 Jul 17:05:30 BST 2018: Server restart in 10 seconds
Sourcemod Version: sourcemod-1.9.0-git6245-linux
Metamod Version: mmsource-1.10.7-git963-linux
SO Version: Debian 8

Edit: My databases configuration wworked before, just broken on new update.

Last edited by mR_SMoking; 07-15-2018 at 12:11.
mR_SMoking is offline
asherkin
SourceMod Developer
Join Date: Aug 2009
Location: OnGameFrame()
Old 07-15-2018 , 19:29   Re: Mysql Crashing Server on some plugins
Reply With Quote #2

You have something doing non-threaded DB access that is taking too long.
__________________
asherkin is offline
sorrybro
BANNED
Join Date: Jul 2018
Old 07-20-2018 , 03:26   Re: Mysql Crashing Server on some plugins
Reply With Quote #3

Sourcebans should be threaded so you have to go through each plugin that uses mysql. Consider hiring a web developer freelancer to help you if your website is going down, but you probably need to have somehere here make your nonthreaded plugins threaded.
sorrybro is offline
Reply


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 17:48.


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