07.04.2013, 22:23
Hello. Lately we've been crashing alot and one thing only crashes the server...
Im not so good with MySQL debugging and all, so you would can please point some things out. Thanks.
We are using MySQL plugin R5
Код:
[18:45:43] [debug] Server crashed while executing hbgrp.amx [18:45:43] [debug] AMX backtrace: [18:45:43] [debug] #0 native mysql_ping () [009065b0] from mysql.DLL [18:45:43] [debug] #1 0014e11c in public checkMySQLConnection () from hbgrp.amx [18:45:43] [debug] System backtrace: [18:45:43] [debug] #0 73314951 in ?? () from C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.6871_none_50944e7cbcb706e5\MSVCR90.dll [18:45:43] [debug] #1 73314996 in ?? () from C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.6871_none_50944e7cbcb706e5\MSVCR90.dll [18:45:43] [debug] #2 00905b41 in ?? () from C:\Users\Administrator\Desktop\HBG\plugins\mysql.DLL [18:45:43] [debug] #3 00905d6d in ?? () from C:\Users\Administrator\Desktop\HBG\plugins\mysql.DLL [18:45:43] [debug] #4 0090897a in ?? () from C:\Users\Administrator\Desktop\HBG\plugins\mysql.DLL [18:45:43] [debug] #5 00906667 in ?? () from C:\Users\Administrator\Desktop\HBG\plugins\mysql.DLL [18:45:43] [debug] #6 004010b6 in ?? () from C:\Users\Administrator\Desktop\HBG\samp-server.exe [18:45:43] [debug] #7 72af340a in ?? () from C:\Users\Administrator\Desktop\HBG\plugins\crashdetect.DLL [18:45:43] [debug] #8 72af5aa6 in ?? () from C:\Users\Administrator\Desktop\HBG\plugins\crashdetect.DLL [18:45:43] [debug] #9 72aed621 in ?? () from C:\Users\Administrator\Desktop\HBG\plugins\crashdetect.DLL [18:45:43] [debug] #10 72af345a in ?? () from C:\Users\Administrator\Desktop\HBG\plugins\crashdetect.DLL [18:45:43] [debug] #11 0047e3c8 in ?? () from C:\Users\Administrator\Desktop\HBG\samp-server.exe [18:45:43] [debug] #12 0048c51a in ?? () from C:\Users\Administrator\Desktop\HBG\samp-server.exe [18:45:43] [debug] #13 00488afd in ?? () from C:\Users\Administrator\Desktop\HBG\samp-server.exe [18:45:43] [debug] #14 00495151 in ?? () from C:\Users\Administrator\Desktop\HBG\samp-server.exe [18:45:43] [debug] #15 00495161 in ?? () from C:\Users\Administrator\Desktop\HBG\samp-server.exe [18:45:43] [debug] #16 ffc30000 in ?? () [18:45:43] [debug] #17 e8042474 in ?? () [18:45:43] [debug] #18 ffffffbf in ?? () [18:45:43] [debug] #19 c01bd8f7 in ?? () [18:45:43] [debug] #20 4859d8f7 in ?? () from C:\Users\Administrator\Desktop\HBG\samp-server.exe [18:45:43] [debug] #21 247c83c3 in ?? () from C:\Users\Administrator\Desktop\HBG\samp-server.exe [18:45:43] [debug] #22 06740008 in ?? () from C:\Users\Administrator\Desktop\HBG\samp-server.exe [18:45:43] [debug] #23 412d01c6 in ?? () from C:\Users\Administrator\Desktop\HBG\samp-server.exe [18:45:43] [debug] #24 8b56d8f7 in ?? () [18:45:43] [debug] #25 f7d233f1 in ?? () [18:45:43] [debug] #26 83082474 in ?? () [18:45:43] [debug] #27 057609fa in ?? () [18:45:43] [debug] #28 eb57c280 in ?? () [18:45:43] [debug] #29 30c28003 in ?? () from C:\Users\Administrator\Desktop\HBG\samp-server.exe [18:45:43] [debug] #30 85411188 in ?? () [18:45:43] [debug] #31 c6e677c0 in ?? () [18:45:43] [debug] #32 8a490001 in ?? () [18:45:43] [debug] #33 88018a16 in ?? () [18:45:43] [debug] #34 06884911 in ?? () [18:45:43] [debug] #35 72f13b46 in ?? () from C:\Users\Administrator\Desktop\HBG\samp-server.exe [18:45:43] [debug] #36 55c35ef2 in ?? () from C:\Users\Administrator\Desktop\HBG\samp-server.exe [18:45:43] [debug] #37 7d83ec8b in ?? () from C:\Users\Administrator\Desktop\HBG\samp-server.exe [18:45:43] [debug] #38 458b0a10 in ?? () from C:\Users\Administrator\Desktop\HBG\samp-server.exe [18:45:43] [debug] #39 850a7508 in ?? () [18:45:43] [debug] #40 6a067dc0 in ?? () from C:\Users\Administrator\Desktop\HBG\samp-server.exe [18:45:43] [debug] #41 eb0a6a01 in ?? () [18:45:43] [debug] #42 ff006a05 in ?? () [18:45:43] [debug] #43 4d8b1075 in ?? () from C:\Users\Administrator\Desktop\HBG\samp-server.exe [18:45:43] [debug] #44 ff9fe80c in ?? () [18:45:43] [debug] #45 458bffff in ?? () from C:\Users\Administrator\Desktop\HBG\samp-server.exe [18:45:43] [debug] #46 5d59590c in ?? () from C:\Users\Administrator\Desktop\HBG\samp-server.exe [18:45:43] [debug] #47 244c8bc3 in ?? () from C:\Users\Administrator\Desktop\HBG\samp-server.exe [18:45:43] [debug] #48 24448b08 in ?? () from C:\Users\Administrator\Desktop\HBG\samp-server.exe [18:45:43] [debug] #49 ff006a04 in ?? () [18:45:43] [debug] #50 e8102474 in ?? () [18:45:43] [debug] #51 ffffff85 in ?? () [18:45:43] [debug] #52 1024448b in ?? () from C:\Users\Administrator\Desktop\HBG\samp-server.exe [18:45:43] [debug] #53 e8c35959 in ?? ()
pawn Код:
public checkMySQLConnection() {
pingTick++;
if(pingTick >= 120) {
if(mysql_ping() == -1) {
printf("[MySQL]: Reconnecting to database '%s'", DB_);
mysql_reconnect(); // After 120 seconds (2 minutes), we need to ensure the connection is still alive. MySQL sometimes plays up and forces the connection to timeout.
}
pingTick = 0;
}
}
We are using MySQL plugin R5
