search

pBlueG / SA-MP-MySQL

MySQL plugin for San Andreas Multiplayer
BSD 3-Clause "New" or "Revised" License
196 stars 80 forks source link

[MySQL] Crash. #159

Closed SAMPmysql closed 6 years ago

SAMPmysql commented 7 years ago
  1. I am not sure.
  2. MySQL R39-6. Win and Linux. I am just testing mode with mysql and I have dynamic IP. When mode is running and my IP(dynamic) changes, server crashes. Also my DB has restriction by IP and it can't connect to DB due to IP changed(maybe it's related somehow), but server crashes(not sure). Check.
  3. Autoconnect is true.
  4. Functions: mysql_connect, mysql_close, mysql_tquery, mysql_escape_string, cache_get_row_count, cache_get_field_content, cache_get_field_content_int, cache_affected_rows.
  5. Logs: the same 6 messages: [19:12:14 06/27/17] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'userblabla'@'IP Here' (using password: YES)
  6. After nothing, crashed.
seanny commented 7 years ago

I'm getting a similar bug with the MySQL plugin too. (It seems to only happen on the Windows server)

[17:14:57] [debug] Server crashed due to an unknown error [17:14:57] [debug] Native backtrace: [17:14:57] [debug] #0 004016eb in ?? () from samp-server.exe [17:14:57] [debug] #1 544c6cc9 in ?? () from plugins\mysql.DLL [17:14:57] [debug] #2 544c9712 in ?? () from plugins\mysql.DLL [17:14:57] [debug] #3 544adb57 in ?? () from plugins\mysql.DLL [17:14:57] [debug] #4 544aecf4 in ?? () from plugins\mysql.DLL [17:14:57] [debug] #5 544af47e in ?? () from plugins\mysql.DLL [17:14:57] [debug] #6 00469a66 in ?? () from samp-server.exe [17:14:57] [debug] #7 0048d4db in ?? () from samp-server.exe [17:14:57] [debug] #8 0049b4a1 in ?? () from samp-server.exe [17:14:57] [debug] #9 0049b4b1 in ?? () from samp-server.exe [17:14:57] [debug] Registers: [17:14:57] [debug] EAX: 038ca6c0 EBX: 00740ab4 ECX: 038de020 EDX: 00000008 [17:14:57] [debug] ESI: 000000a8 EDI: ffffd8bf EBP: 0049b4a1 ESP: 0019fe98 [17:14:57] [debug] EIP: 0049b4b1 EFLAGS: 00010246 [17:14:57] [debug] Stack: [17:14:57] [debug] ESP+00000000: 004ab4a0 0019ff70 004ab0e1 ffffffff [17:14:57] [debug] ESP+00000020: 00000094 00000006 00000002 000023f0 [17:14:57] [debug] ESP+00000040: 00000000 00000000 00000000 00000000 [17:14:57] [debug] ESP+00000060: 00000000 00000000 00000000 00000000 [17:14:57] [debug] ESP+00000080: 00000000 00000000 00000000 00000000 [17:14:57] [debug] ESP+000000a0: 00000000 00000000 00000000 00000000 [17:14:57] [debug] ESP+000000c0: 00000000 00000000 c0000005 00000000 [17:14:57] [debug] ESP+000000e0: 004ba530 00000000 0019ff94 75b462c4 [17:14:57] [debug] ESP+00000100: 77000fd9 0033b000 3034b5fa 00000000 [17:14:57] [debug] ESP+00000120: 00000000 00000000 3034b5fa 0019ffa0 [17:14:57] [debug] ESP+00000140: 00000000 0019ffec 77000fa4 ffffffff [17:14:57] [debug] ESP+00000160: 0033b000 00000000 78746341 00000020 [17:14:57] [debug] ESP+00000180: 00000020 00000000 00000014 00000001 [17:14:57] [debug] ESP+000001a0: 00000000 00000000 00000000 00000000 [17:14:57] [debug] ESP+000001c0: 00000044 000002e0 00000254 00000000 [17:14:57] [debug] ESP+000001e0: 00000336 00000000 2d59495b 000008b8 [17:14:57] [debug] ESP+00000200: 32ceeacd 00000be8 00000042 00000c2c [17:14:57] [debug] ESP+00000220: 0000005e 00000fbc 00000356 00000000 [17:14:57] [debug] ESP+00000240: 00000392 00000010 00000009 000000ec [17:14:57] [debug] ESP+00000260: 00000001 00000002 00001738 000007a0 [17:14:57] [debug] ESP+00000280: 00000001 00000004 00002d64 00000314 [17:14:57] [debug] ESP+000002a0: 00000002 00000006 00003110 000000cc [17:14:57] [debug] ESP+000002c0: 00000001 00000009 000032cc 00000028 [17:14:57] [debug] ESP+000002e0: 00000001 64487353 0000002c 00000001 [17:14:57] [debug] ESP+00000300: 00000001 00001584 0000002c 0000005e [17:14:57] [debug] ESP+00000320: 00000000 00000000 00000000 00000000 [17:14:57] [debug] ESP+00000340: 00000038 00000000 003a0043 0057005c [17:14:57] [debug] ESP+00000360: 006e0069 00780053 005c0073 00000000 [17:14:57] [debug] ESP+00000380: 00000254 00000001 f33271ba 000003b8 [17:14:57] [debug] ESP+000003a0: 2d59495b 0000073c 00000032 00000770 [17:14:57] [debug] ESP+000003c0: 00000042 00000ab0 00000330 00000004 [17:14:57] [debug] ESP+000003e0: 00000356 00000005 b1280544 00001198 [17:14:57] [debug] Loaded modules: [17:14:57] [debug] 00400000 - 00519000 samp-server.exe [17:14:57] [debug] 76fa0000 - 77123000 ntdll.dll [17:14:57] [debug] 75b30000 - 75c10000 KERNEL32.DLL [17:14:57] [debug] 75d90000 - 75f31000 KERNELBASE.dll [17:14:57] [debug] 74690000 - 75a68000 SHELL32.dll [17:14:57] [debug] 76730000 - 767ee000 msvcrt.dll [17:14:57] [debug] 745c0000 - 745f6000 cfgmgr32.dll [17:14:57] [debug] 76a30000 - 76f9e000 windows.storage.dll [17:14:57] [debug] 73ee0000 - 740f1000 combase.dll [17:14:57] [debug] 76650000 - 76730000 ucrtbase.dll [17:14:57] [debug] 73a80000 - 73b41000 RPCRT4.dll [17:14:57] [debug] 73a60000 - 73a7e000 SspiCli.dll [17:14:57] [debug] 73a50000 - 73a5a000 CRYPTBASE.dll [17:14:57] [debug] 75a70000 - 75aca000 bcryptPrimitives.dll [17:14:57] [debug] 760e0000 - 76121000 sechost.dll [17:14:57] [debug] 73bb0000 - 73bf5000 powrprof.dll [17:14:57] [debug] 75f40000 - 75fb7000 advapi32.dll [17:14:57] [debug] 764b0000 - 764f6000 shlwapi.dll [17:14:57] [debug] 767f0000 - 7681b000 GDI32.dll [17:14:57] [debug] 73c00000 - 73d5a000 gdi32full.dll [17:14:57] [debug] 768d0000 - 76a2f000 USER32.dll [17:14:57] [debug] 768b0000 - 768c5000 win32u.dll [17:14:57] [debug] 74520000 - 7452d000 kernel.appcore.dll [17:14:58] [debug] 74530000 - 745b8000 shcore.dll [17:14:58] [debug] 768a0000 - 768af000 profapi.dll [17:14:58] [debug] 71cb0000 - 71cd4000 WINMM.dll [17:14:58] [debug] 71bf0000 - 71bf8000 WSOCK32.dll [17:14:58] [debug] 76300000 - 76363000 WS2_32.dll [17:14:58] [debug] 71c80000 - 71ca3000 WINMMBASE.dll [17:14:58] [debug] 760b0000 - 760d5000 IMM32.DLL [17:14:58] [debug] 54500000 - 54550000 crashdetect.DLL [17:14:58] [debug] 77f90000 - 77ff9000 MSVCP100.dll [17:14:58] [debug] 788d0000 - 7898f000 MSVCR100.dll [17:14:58] [debug] 544a0000 - 544f5000 mysql.DLL [17:14:58] [debug] 537e0000 - 538be000 libmariadb.dll [17:14:58] [debug] 597d0000 - 597ee000 log-core.dll [17:14:58] [debug] 54430000 - 5449d000 MSVCP140.dll [17:14:58] [debug] 537c0000 - 537d5000 VCRUNTIME140.dll [17:14:58] [debug] 72ca0000 - 72cb2000 napinsp.dll [17:14:58] [debug] 72c80000 - 72c96000 pnrpnsp.dll [17:14:58] [debug] 72c60000 - 72c74000 NLAapi.dll [17:14:58] [debug] 70b60000 - 70bae000 mswsock.dll [17:14:58] [debug] 72500000 - 7257d000 DNSAPI.dll [17:14:58] [debug] 761d0000 - 761d7000 NSI.dll [17:14:58] [debug] 724d0000 - 724ff000 IPHLPAPI.DLL [17:14:58] [debug] 72c40000 - 72c4c000 winrnr.dll [17:14:58] [debug] 72c20000 - 72c31000 wshbth.dll [17:14:58] [debug] 70ad0000 - 70af1000 mdnsNSP.dll [17:14:58] [debug] 70a70000 - 70a78000 rasadhlp.dll [17:14:58] [debug] 10000000 - 1000f000 sscanf.DLL [17:14:58] [debug] 53760000 - 537ba000 streamer.DLL [17:14:58] [debug] 70a80000 - 70ac9000 fwpuclnt.dll [17:14:58] [debug] 715a0000 - 715bb000 bcrypt.dll

maddinat0r commented 7 years ago

@SAMPmysql Running a server bound to an IP address that will change eventually will obviously result in a crash.

@seanny I'll need more info on that one. Which version are you using? Is it reproducible? Can you share your debug logs?