1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
Server Crash on sqlite user registration
fiha4155
Little Clucker
**
Posts: 18
Threads: 8
Joined: Jun 2013
Reputation: 0
#1

30.06.2017, 11:51
Код:
----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7-R2, ©2005-2015 SA-MP Team

[06:12:38] filterscripts = ""  (string)
[06:12:38] 
[06:12:38] Server Plugins
[06:12:38] --------------
[06:12:38]  Loading plugin: crashdetect.so
[06:12:38]   CrashDetect v4.18.1 is OK.
[06:12:38]   Loaded.
[06:12:38]  Loading plugin: irc.so
[06:12:38] 

*** IRC Plugin v1.4 by Incognito loaded ***

[06:12:38]   Loaded.
[06:12:38]  Loading plugin: MapAndreas.so
[06:12:38]   Loaded.
[06:12:38]  Loading plugin: streamer.so
[06:12:38] 

*** Streamer Plugin v2.7.7 by Incognito loaded ***

[06:12:38]   Loaded.
[06:12:38]  Loading plugin: sscanf.so
[06:12:38] 

[06:12:38]  ===============================

[06:12:38]       sscanf plugin loaded.     

[06:12:38]          Version:  2.8.2        

[06:12:38]    © 2012 Alex "******" Cole  

[06:12:38]  ===============================

[06:12:38]   Loaded.
[06:12:38]  Loading plugin: whirlpool.so
[06:12:38]  
[06:12:38]  ==================
[06:12:38]  
[06:12:38]   Whirlpool loaded
[06:12:38]  
[06:12:38]  ==================
[06:12:38]  
[06:12:38]   Loaded.
[06:12:38]  Loading plugin: nativechecker.so
[06:12:38]   Loaded.
[06:12:38]  Loaded 7 plugins.

[06:12:38] 
[06:12:38] Filterscripts
[06:12:38] ---------------
[06:12:38]   Loaded 0 filterscripts.

[06:12:38]  
[06:12:38]  
[06:12:38]  
[06:12:38]  ======================================= 
[06:12:38]  |                                     | 
[06:12:38]  |        YSI version 3.09.0684        | 
[06:12:38]  |        By Alex "******" Cole        | 
[06:12:38]  |                                     | 
[06:12:38]  ======================================= 
[06:12:38]  
[06:12:38]  
[06:12:38]  
[06:12:38] Server password has been removed.
[06:12:38] +---------------------------------+
[06:12:38] +---------------------------------+
[06:12:38] +---------------------------------+
[06:12:38] DayZSA v9.1 Sucessfully Loaded!
[06:12:38] +---------------------------------+
[06:12:38] +---------------------------------+
[06:12:38] +---------------------------------+
[06:12:38] Loaded 1636 Looting areas!
[06:12:38] Loaded 182 military Looting areas!
[06:12:38] Loaded 986 farm Looting areas!
[06:12:38] Loaded 434 market Looting areas!
[06:12:38] Loaded 13 Hospitals!!
[06:12:38] 
----------------------------------
[06:12:38] DAYZ v9.1 Loaded
[06:12:38] ----------------------------------

[06:12:38] Number of vehicle models: 22
[06:13:54] [connection] XX.XX.XX.XX:40650 requests connection cookie.
[06:13:55] [connection] incoming connection: XX.XX.XX.XX:40650 id: 0
[06:13:56] [join] KaraSimsek55 has joined the server (0:XX.XX.XX.XX)
[06:14:02] INSERT INTO `users` (`Username`,`Password`,`IP`) VALUES ('KaraSimsek55', '8FF1EF8029A4F74553CDFD50EF98A398BE7EAD7271BBE07B64E57816C9D61847044FB31BAF3A19B0937CB08E7C6DF31DAE7A71833837F306A14903D2C24A0997','XX.XX.XX.XX')
[06:14:02] [debug] Server crashed while executing dayzsqlite.amx
[06:14:02] [debug] AMX backtrace:
[06:14:02] [debug] #0 native fclose () from samp03svr
[06:14:02] [debug] #1 0022a29c in ?? (0) from dayzsqlite.amx
[06:14:02] [debug] #2 0021c92c in ?? (0) from dayzsqlite.amx
[06:14:02] [debug] #3 001e6fe0 in public OnPlayerRegister (0, 72960296) from dayzsqlite.amx
[06:14:02] [debug] #4 001f50a0 in ?? (0, 0, 1, -1, 72946672) from dayzsqlite.amx
[06:14:02] [debug] #5 0000b050 in public OnDialogResponse (0, 0, 1, -1, 72946672) from dayzsqlite.amx
[06:14:02] [debug] Native backtrace:
[06:14:02] [debug] #0 f7482180 in _Z13GetStackTraceRSt6vectorI10StackFrameSaIS0_EEPv () from plugins/crashdetect.so
[06:14:02] [debug] #1 f747a064 in _ZN11CrashDetect20PrintNativeBacktraceERSoRKN2os7ContextE () from plugins/crashdetect.so
[06:14:02] [debug] #2 f747ad64 in _ZN11CrashDetect20PrintNativeBacktraceERKN2os7ContextE () from plugins/crashdetect.so
[06:14:02] [debug] #3 f747ccdb in _ZN11CrashDetect7OnCrashERKN2os7ContextE () from plugins/crashdetect.so
[06:14:02] [debug] #4 f74814d5 in ?? () from plugins/crashdetect.so
[06:14:02] [debug] #5 f77db410 in ?? ()
[06:14:02] [debug] #6 f750e3e6 in fclose () from /lib/libc.so.6
[06:14:02] [debug] #7 0809bd64 in ?? () from ./samp03svr
[06:14:02] [debug] #8 080950e4 in ?? () from ./samp03svr
[06:14:02] [debug] #9 f747bad3 in _ZN11CrashDetect17HandleAMXCallbackEiPiS0_ () from plugins/crashdetect.so
[06:14:02] [debug] #10 045913f0 in ?? () from *™zчH—zчDµı
[06:14:02] [debug] Dµı
[06:14:02] [debug] E·ı
[06:14:02] [debug] Dµı
[06:14:02] [debug] ёı
[06:14:02] [debug] D№ı
[06:14:02] [debug] ґ1{ч
[06:14:02] [debug] Registers:
[06:14:02] [debug] EAX: 00000000 EBX: f7665000 ECX: 0809bd50 EDX: 000000b0
[06:14:02] [debug] ESI: 00000000 EDI: 0a796168 EBP: ffa1f0f8 ESP: ffa1f0c0
[06:14:02] [debug] EIP: f750e3e6 EFLAGS: 00010286
[06:14:02] [debug] Stack:
[06:14:02] [debug] ESP+00000000: 00000000 0a796168 ffa1f0f8 0809bda8
[06:14:02] [debug] ESP+00000020: 00000b68 0a796168 ffa1f0f8 0809bd64
[06:14:02] [debug] ESP+00000040: 0a796168 f552b7a4 ffa1f1cc f747314a
[06:14:02] [debug] ESP+00000060: 0a796168 08db5f58 ffa1f4c0 f747bad3
[06:14:02] [debug] ESP+00000080: 0022a29c 000000b0 f77f6dae f77f6dae
[06:14:02] [debug] ESP+000000a0: 00000002 00000033 00659eca f7665000
[06:14:02] [debug] ESP+000000c0: 08c87cd0 00000000 00000000 00000002
[06:14:02] [debug] ESP+000000e0: 00000000 00000000 00000000 00000000
[06:14:02] [debug] ESP+00000100: f7665420 00000033 ffa1f6c0 00000000
[06:14:02] [debug] ESP+00000120: f77fcfb8 ffa1f868 08c86f58 f77eb7f4
[06:14:02] [debug] ESP+00000140: ffa1f360 f77fcca0 ffa1f228 f75ddf8a
[06:14:02] [debug] ESP+00000160: 0a796168 00000000 04593070 0022a29c
[06:14:02] [debug] ESP+00000180: 0022a278 000000af 00000000 f75230f8
[06:14:02] [debug] ESP+000001a0: 00000016 00000000 0afd2e7b f74a6ff4
[06:14:02] [debug] ESP+000001c0: 08db5f58 000000b0 ffa1f31c f552b7a4
[06:14:02] [debug] ESP+000001e0: 08d9a858 08c84170 ffa1f458 0a796168
[06:14:02] [debug] ESP+00000200: 0a796168 000000b0 ffa1f31c f552b7a4
[06:14:02] [debug] ESP+00000220: f0f98840 04592f64 04591418 04592f60
[06:14:02] [debug] ESP+00000240: 00284b94 04591518 00000000 f0f3c33c
[06:14:02] [debug] ESP+00000260: ffa1f398 00000001 0a796168 f74a6ff4
[06:14:02] [debug] ESP+00000280: 0a796168 ffa1f4c0 0000006a 00000000
[06:14:02] [debug] ESP+000002a0: 08c87b00 08c8abb0 f6b5171f f74daba5
[06:14:02] [debug] ESP+000002c0: 00000000 0a797c08 ffa1f458 f6b5171f
[06:14:02] [debug] ESP+000002e0: 00000000 00000000 0000006a 00000007
[06:14:02] [debug] ESP+00000300: 0afd2dc0 00000007 00000014 00000000
[06:14:02] [debug] ESP+00000320: ffa1f430 f0d11c47 ffa1f420 f751fd25
[06:14:02] [debug] ESP+00000340: 0a796168 08db5f58 0000006a f7480384
[06:14:02] [debug] ESP+00000360: 0afd2dcc 00000000 00000000 f6be9aac
[06:14:02] [debug] ESP+00000380: ffa1f510 00000000 f6b5160d f6be9aac
[06:14:02] [debug] ESP+000003a0: 0a796168 ffa1f4c0 0000006a ffa1f4c0
[06:14:02] [debug] ESP+000003c0: 7fffffff 00000005 01529c30 0a796168
[06:14:02] [debug] ESP+000003e0: 0a796168 ffa1f4c0 0000006a ffa1f510
[06:14:02] [debug] Loaded modules:
[06:14:02] [debug] 00000000 - 00187dc3 samp03svr
[06:14:02] [debug] f77dd000 - f77dd530 
[06:14:02] [debug] f77cf000 - f77d16ec /lib/libdl.so.2
[06:14:02] [debug] f77b4000 - f77cd64b /lib/libpthread.so.0
[06:14:02] [debug] f76c8000 - f77bbd9c /lib/libstdc++.so.6
[06:14:02] [debug] f7685000 - f76c65bc /lib/libm.so.6
[06:14:02] [debug] f7669000 - f7682718 /lib/libgcc_s.so.1
[06:14:02] [debug] f74ab000 - f767020f /lib/libc.so.6
[06:14:02] [debug] f77dc000 - f77fcf7c /lib/ld-linux.so.2
[06:14:02] [debug] f7464000 - f74a6ac4 plugins/crashdetect.so
[06:14:02] [debug] f73f2000 - f7463411 plugins/irc.so
[06:14:02] [debug] f6beb000 - f6bee5d8 plugins/MapAndreas.so
[06:14:02] [debug] f6b4b000 - f6beae20 plugins/streamer.so
[06:14:02] [debug] f6b3c000 - f6b42c0c /lib/librt.so.1
[06:14:02] [debug] f6b2c000 - f6b3b1d4 plugins/sscanf.so
[06:14:02] [debug] f6b22000 - f6b2ad1c plugins/whirlpool.so
[06:14:02] [debug] f77d5000 - f77d6f70 plugins/nativechecker.so
[06:14:02] [debug] f6807000 - f6818680 /lib/libnss_files.so.2
[06:14:02] [debug] f6800000 - f6804cb8 /lib/libnss_dns.so.2
[06:14:02] [debug] f03e6000 - f03fe704 /lib/libresolv.so.2
It prepares Database.db file successfully but when I try to register, server gets crashed. It works on my windows computer though.
Find
Reply
Beryllium
Banned
Posts: 70
Threads: 1
Joined: May 2017
#2

30.06.2017, 12:06
Does the database file saves successfully?
Find
Reply
fiha4155
Little Clucker
**
Posts: 18
Threads: 8
Joined: Jun 2013
Reputation: 0
#3

30.06.2017, 12:56
Quote:
Originally Posted by Beryllium
Посмотреть сообщение
Does the database file saves successfully?
Yes it does. I delete database.db file and restart the server, it saves successfully. But it can not insert my user info's into it.
Find
Reply
Beryllium
Banned
Posts: 70
Threads: 1
Joined: May 2017
#4

30.06.2017, 12:57
Show us your source.
Find
Reply
fiha4155
Little Clucker
**
Posts: 18
Threads: 8
Joined: Jun 2013
Reputation: 0
#5

30.06.2017, 13:31
Quote:
Originally Posted by Beryllium
Посмотреть сообщение
Show us your source.
Source of?
Find
Reply
Konstantinos
Spam Machine
*****
Posts: 11,827
Threads: 33
Joined: Dec 2011
Reputation: 0
#6

01.07.2017, 09:39
The problem is not related to SQLite, but file systems. fclose function crashed your server and it is known that invalid file handle causes this.

For now the logs are not detailed (OnPlayerRegister->??->??->fclose), 2 unknown functions so compile with debug info: https://github.com/Zeex/samp-plugin-...ith-debug-info
and try again.
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help