Mysql R7 - The server stops at random times. - 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: Mysql R7 - The server stops at random times. (/showthread.php?tid=368396)
+- 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: Mysql R7 - The server stops at random times. (/showthread.php?tid=368396)
Mysql R7 - The server stops at random times. - im - 13.08.2012
Hello.
I use the vortex roleplay 2 gamemode and I switched from mysql R6 to R7. I've read this guide: https://sampforum.blast.hk/showthread.php?tid=337810 and I've implemented mysql R7. With caching and stuff.
After a few hours of working, everything seemed to be working just fine. Everything loads and saves as it should, except that some times I get some random stops. The server does not crash, it just 'freezes'. The commands stop working, everything stops working..
I tried on linux too. Same problem.
If I start my server 10 times, 9 times everything loads as it should, but 1 time I get this error detected by crashdetect:
Server log:
Код:
---------- Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3e, ©2005-2012 SA-MP Team [11:30:27] filterscripts = "" (string) [11:30:27] [11:30:27] Server Plugins [11:30:27] -------------- [11:30:27] Loading plugin: crashdetect [11:30:27] crashdetect v4.8.3 is OK. [11:30:27] Loaded. [11:30:27] Loading plugin: wp [11:30:27] [11:30:27] ================== [11:30:27] [11:30:27] Whirlpool loaded [11:30:27] [11:30:27] ================== [11:30:27] [11:30:27] Loaded. [11:30:27] Loading plugin: sscanf [11:30:27] [11:30:27] =============================== [11:30:27] sscanf plugin loaded. [11:30:27] © 2009 Alex "******" Cole [11:30:27] 0.3d-R2 500 Players "dnee" [11:30:27] =============================== [11:30:27] Loaded. [11:30:27] Loading plugin: streamer [11:30:27] *** Streamer Plugin v2.6.1 by Incognito loaded *** [11:30:27] Loaded. [11:30:27] Loading plugin: mysql [11:30:27] > MySQL plugin R7 successfully loaded. [11:30:27] Loaded. [11:30:27] Loading plugin: GeoIP_Plugin [11:30:27] GeoIP_Plugin got loaded. [11:30:27] Loaded. [11:30:27] Loaded 6 plugins. [11:30:27] [11:30:27] Ban list [11:30:27] -------- [11:30:27] Loaded: samp.ban [11:30:27] [11:30:27] [11:30:27] Filterscripts [11:30:27] --------------- [11:30:27] Loaded 0 filterscripts. [11:30:28] OnGameo [11:30:28] [11:30:28] ======================================= [11:30:28] | | [11:30:28] | YSI version 1.04.0000 | [11:30:28] | By Alex "******" Cole | [11:30:28] | | [11:30:28] ======================================= [11:30:28] [11:30:28] [debug] initiateConnections() 'samp_vortex|localhost|root|', 'localhost', 'root', 'samp_vortex' [11:30:28] [debug] OnGameModeInit() [11:30:28] ----------------------------------------------------------------- [11:30:28] Script: Vortex Roleplay 2 by Calgon. [11:30:28] Status: Loaded, running version V.5 [11:30:28] ----------------------------------------------------------------- [11:30:28] main() has been called. [11:30:28] Number of vehicle models: 0 [11:30:28] [OnQueryFinish (8, 0) [11:30:28] [script] 191 vehicles loaded. [11:30:28] [OnQueryFinish (9, 0) [11:30:28] [script] 1 houses loaded. [11:30:28] [OnQueryFinish (10, 0) [11:30:28] [script] 6 jobs loaded! [11:30:28] [debug] Bad heap release detected: [11:30:28] [debug] mysql.DLL [0037a112] is releasing memory at 73d77141 which is out of heap [11:30:28] [debug] System backtrace: [11:30:29] [debug] #0 73dbfe3c in ?? () from E:\SAMP\vx\plugins\crashdetect.DLL [11:30:29] [debug] #1 73dc0720 in ?? () from E:\SAMP\vx\plugins\crashdetect.DLL [11:30:29] [debug] #2 73dc3c97 in ?? () from E:\SAMP\vx\plugins\crashdetect.DLL [11:30:29] [debug] #3 0037a112 in ?? () from E:\SAMP\vx\plugins\mysql.DLL [11:30:29] [debug] #4 004693d6 in ?? () from E:\SAMP\vx\samp-server.exe [11:30:29] [debug] #5 004866ce in ?? () from E:\SAMP\vx\samp-server.exe [11:30:29] [debug] #6 00494881 in ?? () from E:\SAMP\vx\samp-server.exe [11:30:29] [debug] #7 00494891 in ?? () from E:\SAMP\vx\samp-server.exe [11:30:29] [debug] #8 ffc30000 in ?? () [11:30:29] [debug] #9 e8042474 in ?? () [11:30:29] [debug] #10 ffffffbf in ?? () [11:30:29] [debug] #11 c01bd8f7 in ?? () [11:30:29] [debug] #12 4859d8f7 in ?? () from E:\SAMP\vx\samp-server.exe [11:30:29] [debug] #13 247c83c3 in ?? () from E:\SAMP\vx\samp-server.exe [11:30:29] [debug] #14 06740008 in ?? () from E:\SAMP\vx\samp-server.exe [11:30:29] [debug] #15 412d01c6 in ?? () from E:\SAMP\vx\samp-server.exe [11:30:29] [debug] #16 8b56d8f7 in ?? () [11:30:29] [debug] #17 f7d233f1 in ?? () [11:30:29] [debug] #18 83082474 in ?? () [11:30:29] [debug] #19 057609fa in ?? () from E:\SAMP\vx\samp-server.exe [11:30:29] [debug] #20 eb57c280 in ?? () [11:30:29] [debug] #21 30c28003 in ?? () from E:\SAMP\vx\samp-server.exe [11:30:29] [debug] #22 85411188 in ?? () [11:30:29] [debug] #23 c6e677c0 in ?? () [11:30:29] [debug] #24 8a490001 in ?? () [11:30:29] [debug] #25 88018a16 in ?? () [11:30:29] [debug] #26 06884911 in ?? () from E:\SAMP\vx\samp-server.exe [11:30:29] [debug] #27 72f13b46 in ?? () from E:\SAMP\vx\samp-server.exe [11:30:29] [debug] #28 55c35ef2 in ?? () from E:\SAMP\vx\samp-server.exe [11:30:29] [debug] #29 7d83ec8b in ?? () from E:\SAMP\vx\samp-server.exe [11:30:29] [debug] #30 458b0a10 in ?? () from E:\SAMP\vx\samp-server.exe [11:30:29] [debug] #31 850a7508 in ?? () [11:30:29] [debug] #32 6a067dc0 in ?? () from E:\SAMP\vx\samp-server.exe [11:30:29] [debug] #33 eb0a6a01 in ?? () [11:30:29] [debug] #34 ff006a05 in ?? () [11:30:29] [debug] #35 4d8b1075 in ?? () from E:\SAMP\vx\samp-server.exe [11:30:29] [debug] #36 ff9fe80c in ?? () [11:30:29] [debug] #37 458bffff in ?? () from E:\SAMP\vx\samp-server.exe [11:30:29] [debug] #38 5d59590c in ?? () from E:\SAMP\vx\samp-server.exe [11:30:29] [debug] #39 244c8bc3 in ?? () from E:\SAMP\vx\samp-server.exe [11:30:29] [debug] #40 24448b08 in ?? () from E:\SAMP\vx\samp-server.exe [11:30:29] [debug] #41 ff006a04 in ?? () [11:30:29] [debug] #42 e8102474 in ?? () [11:30:29] [debug] #43 ffffff85 in ?? () [11:30:29] [debug] #44 1024448b in ?? () from E:\SAMP\vx\samp-server.exe [11:30:29] [debug] #45 a1c35959 in ?? () [11:30:29] [debug] #46 004db7f0 in ?? () from E:\SAMP\vx\samp-server.exe [11:30:29] [debug] #47 0274c085 in ?? () [11:30:30] [OnQueryFinish (11, 0) [11:30:30] [script] 12 groups loaded! [11:30:30] [OnQueryFinish (13, 0) [11:30:30] [script] 7 assets loaded! [11:30:30] [OnQueryFinish (14, 0) [11:30:30] [script] 13 businesses. [11:30:30] [OnQueryFinish (21, 0) [11:30:30] [script] 24 ATMs loaded
Mysql debug log:
Код:
[11:30:28] >> mysql_connect(localhost, root, samp_vortex, ******) on port 3306 [11:30:28] CMySQLHandler::CMySQLHandler() - constructor called. [11:30:28] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "samp_vortex" | Username: "root" [11:30:28] CMySQLHandler::Connect() - Connection was successful. [11:30:28] CMySQLHandler::Connect() - Auto-Reconnect has been enabled. [11:30:28] [11:30:28] ** MySQL Debugging enabled (08/13/12) [11:30:28] [11:30:28] >> mysql_format( Connection handle: 1 ) [11:30:28] >> mysql_query_callback( Connection handle: 1 ) [11:30:28] >> mysql_format( Connection handle: 1 ) [11:30:28] Passing query ALTER TABLE vehicles DROP vehicleID | [11:30:28] >> mysql_query_callback( Connection handle: 1 ) [11:30:28] >> mysql_query_callback( Connection handle: 1 ) [11:30:28] >> mysql_query_callback( Connection handle: 1 ) [11:30:28] >> mysql_query_callback( Connection handle: 1 ) [11:30:28] >> mysql_query_callback( Connection handle: 1 ) [11:30:28] >> mysql_query_callback( Connection handle: 1 ) [11:30:28] >> mysql_query_callback( Connection handle: 1 ) [11:30:28] >> mysql_query_callback( Connection handle: 1 ) [11:30:28] >> mysql_query_callback( Connection handle: 1 ) [11:30:28] ProcessQueryThread() - Query was successful. (ALTER TABLE vehicles DROP vehicleID) [11:30:28] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick() [11:30:28] Passing query ALTER TABLE `vehicles` ADD `vehicleID` INT( 10 ) NOT NULL AUTO_INCREMENT FIRST , ADD PRIMARY KEY ( `vehicleID` ) , ADD INDEX ( `vehicleID` ) | [11:30:28] ProcessQueryThread() - Query was successful. (ALTER TABLE `vehicles` ADD `vehicleID` INT( 10 ) NOT NULL AUTO_INCREMENT FIRST , ADD PRIMARY KEY ( `vehicleID` ) , ADD INDEX ( `vehicleID` ) ) [11:30:28] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick() [11:30:28] Passing query UPDATE playeraccounts SET playerStatus = '0' WHERE playerStatus = '1' | [11:30:28] ProcessQueryThread() - Query was successful. (UPDATE playeraccounts SET playerStatus = '0' WHERE playerStatus = '1') [11:30:28] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick() [11:30:28] Passing query SELECT * FROM vehicles | ii [11:30:28] ProcessQueryThread(OnQueryFinish) - Query was successful. (SELECT * FROM vehicles) [11:30:28] ProcessQueryThread(OnQueryFinish) - Data caching enabled. [11:30:28] CMySQLHandler::StoreResult() - Result was stored. [11:30:28] CMySQLHandler::FreeResult() - Result was successfully free'd. [11:30:28] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick() [11:30:28] OnQueryFinish(ii) - Threaded function called. [11:30:28] >> cache_get_data( Connection handle: 1 ) [11:30:28] ProcessTick() - The cache has been cleared. [11:30:28] Passing query SELECT * FROM houses | ii [11:30:28] ProcessQueryThread(OnQueryFinish) - Query was successful. (SELECT * FROM houses) [11:30:28] ProcessQueryThread(OnQueryFinish) - Data caching enabled. [11:30:28] CMySQLHandler::StoreResult() - Result was stored. [11:30:28] CMySQLHandler::FreeResult() - Result was successfully free'd. [11:30:28] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick() [11:30:28] OnQueryFinish(ii) - Threaded function called. [11:30:28] >> cache_get_data( Connection handle: 1 ) [11:30:28] ProcessTick() - The cache has been cleared. [11:30:28] Passing query SELECT * FROM jobs | ii [11:30:28] ProcessQueryThread(OnQueryFinish) - Query was successful. (SELECT * FROM jobs) [11:30:28] ProcessQueryThread(OnQueryFinish) - Data caching enabled. [11:30:28] CMySQLHandler::StoreResult() - Result was stored. [11:30:28] CMySQLHandler::FreeResult() - Result was successfully free'd. [11:30:28] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick() [11:30:28] OnQueryFinish(ii) - Threaded function called. [11:30:28] >> cache_get_data( Connection handle: 1 ) [11:30:29] ProcessTick() - The cache has been cleared. [11:30:29] Passing query SELECT * FROM groups | ii [11:30:29] ProcessQueryThread(OnQueryFinish) - Query was successful. (SELECT * FROM groups) [11:30:30] ProcessQueryThread(OnQueryFinish) - Data caching enabled. [11:30:30] CMySQLHandler::StoreResult() - Result was stored. [11:30:30] CMySQLHandler::FreeResult() - Result was successfully free'd. [11:30:30] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick() [11:30:30] OnQueryFinish(ii) - Threaded function called. [11:30:30] >> cache_get_data( Connection handle: 1 ) [11:30:30] ProcessTick() - The cache has been cleared. [11:30:30] Passing query SELECT * FROM assets | ii [11:30:30] ProcessQueryThread(OnQueryFinish) - Query was successful. (SELECT * FROM assets) [11:30:30] ProcessQueryThread(OnQueryFinish) - Data caching enabled. [11:30:30] CMySQLHandler::StoreResult() - Result was stored. [11:30:30] CMySQLHandler::FreeResult() - Result was successfully free'd. [11:30:30] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick() [11:30:30] OnQueryFinish(ii) - Threaded function called. [11:30:30] >> cache_get_data( Connection handle: 1 ) [11:30:30] ProcessTick() - The cache has been cleared. [11:30:30] Passing query SELECT * FROM businesses | ii [11:30:30] ProcessQueryThread(OnQueryFinish) - Query was successful. (SELECT * FROM businesses) [11:30:30] ProcessQueryThread(OnQueryFinish) - Data caching enabled. [11:30:30] CMySQLHandler::StoreResult() - Result was stored. [11:30:30] CMySQLHandler::FreeResult() - Result was successfully free'd. [11:30:30] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick() [11:30:30] OnQueryFinish(ii) - Threaded function called. [11:30:30] >> cache_get_data( Connection handle: 1 ) [11:30:30] ProcessTick() - The cache has been cleared. [11:30:30] Passing query SELECT * FROM atms | ii [11:30:30] ProcessQueryThread(OnQueryFinish) - Query was successful. (SELECT * FROM atms) [11:30:30] ProcessQueryThread(OnQueryFinish) - Data caching enabled. [11:30:30] CMySQLHandler::StoreResult() - Result was stored. [11:30:30] CMySQLHandler::FreeResult() - Result was successfully free'd. [11:30:30] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick() [11:30:30] OnQueryFinish(ii) - Threaded function called. [11:30:30] >> cache_get_data( Connection handle: 1 ) [11:30:30] ProcessTick() - The cache has been cleared.
Re: Mysql R7 - The server stops at random times. - im - 14.08.2012
I still have the same problem.
No stack/heap size warnings when compiling.
Could anyone please help?
Re: Mysql R7 - The server stops at random times. - nobita - 22.09.2012
I have the samp problem!please help!
Re: Mysql R7 - The server stops at random times. - Baboon - 12.04.2013
Same, I also have this, but unlike you, I do not have any backtrace errors. It just stops randomly.
Re: Mysql R7 - The server stops at random times. - MP2 - 12.04.2013
Enable debugging flags for the compiler (-d3).
Re: Mysql R7 - The server stops at random times. - Universal - 12.04.2013
It also have happened to me. The only way I managed to remove this is actually using the different mysql plugin version.
Re: Mysql R7 - The server stops at random times. - Baboon - 12.04.2013
I just heard you have to load mysql.dll / mysql.so first, but I do not know if that really works.
Re: Mysql R7 - The server stops at random times. - Edvin - 12.04.2013
Why you guys, don't update to R8?