AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   General (https://forums.alliedmods.net/forumdisplay.php?f=58)
-   -   Mysql Crashing Server on some plugins (https://forums.alliedmods.net/showthread.php?t=309155)

mR_SMoking 07-15-2018 12:08

Mysql Crashing Server on some plugins
 
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.

asherkin 07-15-2018 19:29

Re: Mysql Crashing Server on some plugins
 
You have something doing non-threaded DB access that is taking too long.

sorrybro 07-20-2018 03:26

Re: Mysql Crashing Server on some plugins
 
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.


All times are GMT -4. The time now is 08:27.

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