SA-MP Forums Archive
Server crashing when unloading MySQL. - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Server crashing when unloading MySQL. (/showthread.php?tid=452173)



Server crashing when unloading MySQL. - BigGroter - 20.07.2013

Why is this happening? When I close the server and it's unloading MySQL, the server stops responding and crashes.
While we're on it, when I connect to the server nothing happens, it just says "Connected to xx" or whatever the default message is, any ideas are welcome.


Re: Server crashing when unloading MySQL. - MP2 - 20.07.2013

Which mySQL plugin are you using (and which version)?


Re: Server crashing when unloading MySQL. - Tingesport - 20.07.2013

Are you using any other plugins like streamer, sscanf etc?


Re: Server crashing when unloading MySQL. - BigGroter - 20.07.2013

I'm using R26.
I am using Incognito's streamer, sscanf, whirlpool and crashdetect.


Re: Server crashing when unloading MySQL. - Tingesport - 20.07.2013

And crashdetect doesn't show anything?
btw, please show us the 'plugins' line in configs, the order you load the plugins can mess up some shit aswell.


Re: Server crashing when unloading MySQL. - BigGroter - 20.07.2013

Quote:
Originally Posted by Tingesport
View Post
And crashdetect doesn't show anything?
btw, please show us the 'plugins' line in configs, the order you load the plugins can mess up some shit aswell.
Unfortunately it doesn't.

Code:
plugins sscanf Whirlpool streamer crashdetect mysql



Re: Server crashing when unloading MySQL. - BigGroter - 21.07.2013

Bump.


Re: Server crashing when unloading MySQL. - iggy1 - 21.07.2013

Make sure you close all connections before restarting the server. Not doing so causes a crash. I'm not %100 sure if this happens with R26, but it does on earlier (none ****** code) versions.

pawn Code:
new con_handle;
con_handle = mysql_connect(...);

mysql_close( con_handle );//always close the connection when done with it.
EDIT: IDK why the plugin doesn't close all open connections automatically when it is unloaded. It should do IMO.


Re: Server crashing when unloading MySQL. - BigGroter - 21.07.2013

I am closing MySQL. This is very annoying, I haven't been able to try anything out for weeks. When I join I see the sea and nothing really happens, I don't know why MySQL is acting up tbh.
Thank you for trying at least.


Re: Server crashing when unloading MySQL. - BigGroter - 22.07.2013

Bump, I need this solved.