Server Crashing - 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 (
/showthread.php?tid=562979)
Server Crashing -
JeaSon - 13.02.2015
server logs
Код:
[09:31:53] [debug] Server crashed while executing Opticalx.amx
[09:31:53] [debug] Backtrace:
[09:31:53] [debug] #0 native mysql_tquery () from mysql.DLL
[09:31:53] [debug] #1 000cb558 in public ReportUpdateTimer001 (playerid=0) at E:\OrigalX\gamemodes\Opticalx.pwn:12344
[09:31:53] [debug] Thread backtrace:
[09:31:53] [debug] #0 0049E676 in ?? () from E:\OrigalX\samp-server.exe
[09:31:53] [debug] #1 00497AB1 in ?? () from E:\OrigalX\samp-server.exe
[09:31:53] [debug] #2 7604EE1C in BaseThreadInitThunk () from C:\Windows\system32\kernel32.dll
[09:31:53] [debug] #3 76EC37EB in RtlInitializeExceptionChain () from C:\Windows\SYSTEM32\ntdll.dll
[09:31:53] [debug] #4 76EC37BE in RtlInitializeExceptionChain () from C:\Windows\SYSTEM32\ntdll.dll
code
pawn Код:
// under OnGameModeInit()
SetTimer("ReportUpdateTimer001", 3000, true);
//
public ReportUpdateTimer001(playerid)
{
new Query[100];
format(Query,sizeof(Query),"SELECT * FROM `reports` ORDER BY `ID` DESC LIMIT 1, 1 ");
mysql_tquery(mysql, Query, "DisplayReportsx", "i", playerid);
new Queryz[100];
format(Queryz,sizeof(Queryz),"SELECT * FROM `reports` ORDER BY `ID` DESC LIMIT 2, 2 ");
mysql_tquery(mysql, Queryz, "DisplayReportsz", "i", playerid);
return 1;
}
crashinfo
Код:
SA-MP Server: 0.3z
Exception At Address: 0x692A226A Module: (mysql.DLL)
Registers:
EAX: 0x00000000 EBX: 0x00000000 ECX: 0x0012FA70 EDX: 0x0313F2FC
ESI: 0x6735DD10 EDI: 0x002EBF44 EBP: 0x0012FB38 ESP: 0x0012FA54
EFLAGS: 0x00010212
Stack:
+0000: 0xF8A482F6 0x002EBF58 0x002EBF20 0x00000004
+0010: 0x000365CC 0xFFFFFFFE 0x77B52FE7 0x00000000
+0020: 0x01619270 0x035B2740 0x002EBF44 0x002C0000
+0030: 0x0012FC28 0x00000000 0x000365CC 0xFFFFFFFE
+0040: 0x00000002 0x00000000 0x00000048 0x00000058
+0050: 0x0012FAC4 0x6735DCFF 0x002C0000 0x00000000
+0060: 0x00000040 0x0000003F 0x0000000F 0x0012FBF4
+0070: 0x0012FAE0 0x6735DDA7 0x00000040 0x00000002
+0080: 0x00000000 0x00000010 0x00000068 0x0012FB14
+0090: 0x692A1757 0x00000040 0xF8A482DA 0x00000036
+00A0: 0x0012FBF4 0x0012FB70 0x0012FBF4 0x002E0A98
+00B0: 0x0012FAEC 0x0012FC28 0x0012FBF4 0x0000000F
+00C0: 0x692A148D 0x0012FBF4 0x0012FB60 0x0000000F
+00D0: 0x0012FBF4 0xF8A482F6 0x0012FC28 0x692C8D04
+00E0: 0xFFFFFFFF 0x0012FC34 0x692BF628 0x0012FB50
+00F0: 0x01619270 0x035B272C 0x00000004 0x00120069
+0100: 0x01619270 0x0012FBC8 0x692BF286 0x70736944
+0110: 0x5279616C 0x726F7065 0x00787374 0x454C4553
+0120: 0x2A205443 0x4F524620 0x7260204D 0x726F7065
+0130: 0x20607374 0x4544524F 0x59422052 0x44496020
--------------------------
Loaded Modules:
samp-server.exe A: 0x00400000 - 0x004F5000 (E:\OrigalX\samp-server.exe)
ntdll.dll A: 0x77B00000 - 0x77C3C000 (C:\Windows\SYSTEM32\ntdll.dll)
kernel32.dll A: 0x77C40000 - 0x77D14000 (C:\Windows\system32\kernel32.dll)
KERNELBASE.dll A: 0x75DA0000 - 0x75DEB000 (C:\Windows\system32\KERNELBASE.dll)
SHELL32.dll A: 0x76290000 - 0x76EDA000 (C:\Windows\system32\SHELL32.dll)
msvcrt.dll A: 0x77060000 - 0x7710C000 (C:\Windows\system32\msvcrt.dll)
SHLWAPI.dll A: 0x76190000 - 0x761E7000 (C:\Windows\system32\SHLWAPI.dll)
GDI32.dll A: 0x77010000 - 0x7705E000 (C:\Windows\system32\GDI32.dll)
USER32.dll A: 0x77230000 - 0x772F9000 (C:\Windows\system32\USER32.dll)
LPK.dll A: 0x77520000 - 0x7752A000 (C:\Windows\system32\LPK.dll)
USP10.dll A: 0x77300000 - 0x7739D000 (C:\Windows\system32\USP10.dll)
WSOCK32.dll A: 0x705A0000 - 0x705A7000 (C:\Windows\system32\WSOCK32.dll)
WS2_32.dll A: 0x76EE0000 - 0x76F15000 (C:\Windows\system32\WS2_32.dll)
RPCRT4.dll A: 0x77110000 - 0x771B2000 (C:\Windows\system32\RPCRT4.dll)
NSI.dll A: 0x77D20000 - 0x77D26000 (C:\Windows\system32\NSI.dll)
WINMM.dll A: 0x73890000 - 0x738C2000 (C:\Windows\system32\WINMM.dll)
IMM32.DLL A: 0x77500000 - 0x7751F000 (C:\Windows\system32\IMM32.DLL)
MSCTF.dll A: 0x760C0000 - 0x7618C000 (C:\Windows\system32\MSCTF.dll)
sscanf.DLL A: 0x10000000 - 0x1000D000 (E:\OrigalX\plugins\sscanf.DLL)
MSVCR100.dll A: 0x68080000 - 0x6813F000 (C:\Windows\system32\MSVCR100.dll)
whirlpool.DLL A: 0x003E0000 - 0x003EC000 (E:\OrigalX\plugins\whirlpool.DLL)
MSVCR80.dll A: 0x6F670000 - 0x6F70B000 (C:\Windows\WinSxS\x86_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.4940_none_d08cc06a442b34fc\MSVCR80.dll)
mysql.DLL A: 0x692A0000 - 0x692E4000 (E:\OrigalX\plugins\mysql.DLL)
LIBMYSQL.dll A: 0x66E90000 - 0x6715A000 (E:\OrigalX\LIBMYSQL.dll)
ADVAPI32.dll A: 0x761F0000 - 0x76290000 (C:\Windows\system32\ADVAPI32.dll)
sechost.dll A: 0x77210000 - 0x77229000 (C:\Windows\SYSTEM32\sechost.dll)
MSVCR110.dll A: 0x67350000 - 0x67426000 (E:\OrigalX\MSVCR110.dll)
MSVCP110.dll A: 0x69210000 - 0x69295000 (E:\OrigalX\MSVCP110.dll)
NLAapi.dll A: 0x73880000 - 0x73890000 (C:\Windows\system32\NLAapi.dll)
napinsp.dll A: 0x704D0000 - 0x704E0000 (C:\Windows\system32\napinsp.dll)
pnrpnsp.dll A: 0x704B0000 - 0x704C2000 (C:\Windows\system32\pnrpnsp.dll)
mswsock.dll A: 0x754D0000 - 0x7550C000 (C:\Windows\System32\mswsock.dll)
DNSAPI.dll A: 0x75390000 - 0x753D4000 (C:\Windows\system32\DNSAPI.dll)
winrnr.dll A: 0x6FF00000 - 0x6FF08000 (C:\Windows\System32\winrnr.dll)
rasadhlp.dll A: 0x707B0000 - 0x707B6000 (C:\Windows\system32\rasadhlp.dll)
MSVCP100.dll A: 0x68010000 - 0x68079000 (C:\Windows\system32\MSVCP100.dll)
irc.DLL A: 0x67300000 - 0x67348000 (E:\OrigalX\plugins\irc.DLL)
MSVCP120.dll A: 0x67280000 - 0x672F1000 (E:\OrigalX\MSVCP120.dll)
MSVCR120.dll A: 0x67190000 - 0x6727E000 (E:\OrigalX\MSVCR120.dll)
streamer.DLL A: 0x66E40000 - 0x66E81000 (E:\OrigalX\plugins\streamer.DLL)
iTD.DLL A: 0x74000000 - 0x74006000 (E:\OrigalX\plugins\iTD.DLL)
YSF.DLL A: 0x020E0000 - 0x0219A000 (E:\OrigalX\plugins\YSF.DLL)
wshtcpip.dll A: 0x75040000 - 0x75045000 (C:\Windows\System32\wshtcpip.dll)
IPHLPAPI.DLL A: 0x73460000 - 0x7347C000 (C:\Windows\system32\IPHLPAPI.DLL)
WINNSI.DLL A: 0x73440000 - 0x73447000 (C:\Windows\system32\WINNSI.DLL)
wship6.dll A: 0x754C0000 - 0x754C6000 (C:\Windows\System32\wship6.dll)
Re: Server Crashing -
IndependentGaming - 13.02.2015
What version of mysql plugin are you using?
Re: Server Crashing -
iZN - 13.02.2015
What are you even doing? Placing two queries in a 3 second REPEATING timer is one of the idiotic thing you could ever do.