Re: [sqlite] Fwd: signal 6 during sqlite_step in WAL mode

[Simon Slavin]

On 1 Jul 2014, at 2:50pm, Mattan Shalev  wrote:

> Valgrind only shows "
> 
> Warning: set address range perms: large range [0x7dc88040, 0x8f5d2058)
> (undefined)", which is a debug msg for developers.
> 
> 
> Also, forgot to mention that the reader threads are initiated via gSoap,
> though the signal always occur from sqlite.

It still looks like a corrupted heap.  The assumption is that something in your 
app is writing over SQLite's memory space between SQLite API calls.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Fwd: signal 6 during sqlite_step in WAL mode

[Mattan Shalev]

Valgrind only shows "

Warning: set address range perms: large range [0x7dc88040, 0x8f5d2058)
(undefined)", which is a debug msg for developers.


Also, forgot to mention that the reader threads are initiated via gSoap,
though the signal always occur from sqlite.


On Tue, Jul 1, 2014 at 11:58 AM, Dan Kennedy  wrote:

> On 07/01/2014 12:07 PM, Mattan Shalev wrote:
>
>> Hey guys,
>> I'm getting signal 6 during sqlite_step in WAL mode. Working on Ubuntu
>> 12.04, sqlite3 3.7.9.
>> One process is the writing continuously,  while other process reads from
>> the DB in a multi threaded access. I made sure that sqlite is configured
>> to
>> serialised mode.
>>
>
> Looks like a corrupted heap. If you run your app under valgrind it will
> probably point you to the problem.
>
> Dan.
>
>
>
>
>
>
>> Here is the backtrace:
>>
>> #0 0x7f4f78f0d08d in nanosleep () from /lib/x86_64-linux-gnu/libc.so.
>> 6
>> #1 0x7f4f78f0cf2c in sleep () from /lib/x86_64-linux-gnu/libc.so.6
>> #2 0x7f4f7982d881 in signal_catch (signo=6) at signal_masker.c:35
>> #3 
>> #4 0x7f4f78e83425 in raise () from /lib/x86_64-linux-gnu/libc.so.6
>> #5 0x7f4f78e86b8b in abort () from /lib/x86_64-linux-gnu/libc.so.6
>> #6 0x7f4f78ec139e in ?? () from /lib/x86_64-linux-gnu/libc.so.6
>> #7 0x7f4f78ecbb96 in ?? () from /lib/x86_64-linux-gnu/libc.so.6
>> #8 0x7f4f77661690 in sqlite3_free () from
>> /usr/lib/x86_64-linux-gnu/libsqlite3.so.0
>> #9 0x7f4f77664b96 in ?? () from
>> /usr/lib/x86_64-linux-gnu/libsqlite3.so.0
>> #10 0x7f4f77664c7c in ?? () from
>> /usr/lib/x86_64-linux-gnu/libsqlite3.so.0
>> #11 0x7f4f77664cb0 in ?? () from
>> /usr/lib/x86_64-linux-gnu/libsqlite3.so.0
>> #12 0x7f4f7768b477 in ?? () from
>> /usr/lib/x86_64-linux-gnu/libsqlite3.so.0
>> #13 0x7f4f7769a249 in ?? () from
>> /usr/lib/x86_64-linux-gnu/libsqlite3.so.0
>> #14 0x7f4f776a9689 in ?? () from
>> /usr/lib/x86_64-linux-gnu/libsqlite3.so.0
>> #15 0x7f4f776ae451 in sqlite3_step () from
>> /usr/lib/x86_64-linux-gnu/libsqlite3.so.0
>> #16 0x7f4f79416557 in get_down_intervals_size (start_time=1403711040,
>> end_time=1577836800,
>> size=0x7f3c49c68958) at stats_ext.c:202
>> #17 0x00407f80 in ns__get_stats_performance (s=0x1e4cb00,
>> start_time=1403711040, end_time=1577836800,
>> time_unit=NS_MINUTES, resource_id=0, ret=0x7f3c49c68990) at
>> msg_handlers/capi_wrappers.c:636
>> #18 0x004461c1 in soap_serve_ns__get_stats_performance
>> (soap=0x1e4cb00) at soapServer.c:1294
>> #19 0x004415ae in soap_serve_request (soap=0x1e4cb00) at
>> soapServer.c:119
>> #20 0x00440f3e in soap_serve (soap=0x1e4cb00) at soapServer.c:39
>> #21 0x00403c90 in process_request (s=0x1e4cb00) at be_server.c:111
>> #22 0x7f4f79a3de9a in start_thread () from
>> /lib/x86_64-linux-gnu/libpthread.so.0
>> #23 0x7f4f78f413fd in clone () from /lib/x86_64-linux-gnu/libc.so.6
>> #24 0x in ?? ()
>>
>> Does anyone has an idea?
>>
>>
>> Thanks!
>>
>> Mattan.
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Mattan Shalev | Software Engineer

*Reduxio Systems*


2 Granit St. | Petach Tikva 4951446, Israel

Mobile: +972 (52) 5115750

mat...@reduxio.com  | www.reduxio.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Fwd: signal 6 during sqlite_step in WAL mode

[Dan Kennedy]

On 07/01/2014 12:07 PM, Mattan Shalev wrote:

Hey guys,
I'm getting signal 6 during sqlite_step in WAL mode. Working on Ubuntu
12.04, sqlite3 3.7.9.
One process is the writing continuously,  while other process reads from
the DB in a multi threaded access. I made sure that sqlite is configured to
serialised mode.


Looks like a corrupted heap. If you run your app under valgrind it will 
probably point you to the problem.


Dan.







Here is the backtrace:

#0 0x7f4f78f0d08d in nanosleep () from /lib/x86_64-linux-gnu/libc.so.6
#1 0x7f4f78f0cf2c in sleep () from /lib/x86_64-linux-gnu/libc.so.6
#2 0x7f4f7982d881 in signal_catch (signo=6) at signal_masker.c:35
#3 
#4 0x7f4f78e83425 in raise () from /lib/x86_64-linux-gnu/libc.so.6
#5 0x7f4f78e86b8b in abort () from /lib/x86_64-linux-gnu/libc.so.6
#6 0x7f4f78ec139e in ?? () from /lib/x86_64-linux-gnu/libc.so.6
#7 0x7f4f78ecbb96 in ?? () from /lib/x86_64-linux-gnu/libc.so.6
#8 0x7f4f77661690 in sqlite3_free () from
/usr/lib/x86_64-linux-gnu/libsqlite3.so.0
#9 0x7f4f77664b96 in ?? () from
/usr/lib/x86_64-linux-gnu/libsqlite3.so.0
#10 0x7f4f77664c7c in ?? () from
/usr/lib/x86_64-linux-gnu/libsqlite3.so.0
#11 0x7f4f77664cb0 in ?? () from
/usr/lib/x86_64-linux-gnu/libsqlite3.so.0
#12 0x7f4f7768b477 in ?? () from
/usr/lib/x86_64-linux-gnu/libsqlite3.so.0
#13 0x7f4f7769a249 in ?? () from
/usr/lib/x86_64-linux-gnu/libsqlite3.so.0
#14 0x7f4f776a9689 in ?? () from
/usr/lib/x86_64-linux-gnu/libsqlite3.so.0
#15 0x7f4f776ae451 in sqlite3_step () from
/usr/lib/x86_64-linux-gnu/libsqlite3.so.0
#16 0x7f4f79416557 in get_down_intervals_size (start_time=1403711040,
end_time=1577836800,
size=0x7f3c49c68958) at stats_ext.c:202
#17 0x00407f80 in ns__get_stats_performance (s=0x1e4cb00,
start_time=1403711040, end_time=1577836800,
time_unit=NS_MINUTES, resource_id=0, ret=0x7f3c49c68990) at
msg_handlers/capi_wrappers.c:636
#18 0x004461c1 in soap_serve_ns__get_stats_performance
(soap=0x1e4cb00) at soapServer.c:1294
#19 0x004415ae in soap_serve_request (soap=0x1e4cb00) at
soapServer.c:119
#20 0x00440f3e in soap_serve (soap=0x1e4cb00) at soapServer.c:39
#21 0x00403c90 in process_request (s=0x1e4cb00) at be_server.c:111
#22 0x7f4f79a3de9a in start_thread () from
/lib/x86_64-linux-gnu/libpthread.so.0
#23 0x7f4f78f413fd in clone () from /lib/x86_64-linux-gnu/libc.so.6
#24 0x in ?? ()

Does anyone has an idea?


Thanks!

Mattan.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Fwd: signal 6 during sqlite_step in WAL mode

[Eduardo Morras]

On Tue, 1 Jul 2014 08:07:52 +0300
Mattan Shalev  wrote:

> Hey guys,
> I'm getting signal 6 during sqlite_step in WAL mode. Working on Ubuntu
> 12.04, sqlite3 3.7.9.
> One process is the writing continuously,  while other process reads
> from the DB in a multi threaded access. I made sure that sqlite is
> configured to serialised mode.
> 
> Here is the backtrace:
> 
> #0 0x7f4f78f0d08d in nanosleep ()
> #from /lib/x86_64-linux-gnu/libc.so.6 1 0x7f4f78f0cf2c in sleep
> #() from /lib/x86_64-linux-gnu/libc.so.6 2 0x7f4f7982d881 in
> #signal_catch (signo=6) at signal_masker.c:35 3  #called> 4 0x7f4f78e83425 in raise ()
> #called> from /lib/x86_64-linux-gnu/libc.so.6
> #5 0x7f4f78e86b8b in abort () from /lib/x86_64-linux-gnu/libc.so.6
> #6 0x7f4f78ec139e in ?? () from /lib/x86_64-linux-gnu/libc.so.6
> #7 0x7f4f78ecbb96 in ?? () from /lib/x86_64-linux-gnu/libc.so.6
> #8 0x7f4f77661690 in sqlite3_free () from
> /usr/lib/x86_64-linux-gnu/libsqlite3.so.0
> #9 0x7f4f77664b96 in ?? () from
> /usr/lib/x86_64-linux-gnu/libsqlite3.so.0
> #10 0x7f4f77664c7c in ?? () from
> /usr/lib/x86_64-linux-gnu/libsqlite3.so.0
> #11 0x7f4f77664cb0 in ?? () from
> /usr/lib/x86_64-linux-gnu/libsqlite3.so.0
> #12 0x7f4f7768b477 in ?? () from
> /usr/lib/x86_64-linux-gnu/libsqlite3.so.0
> #13 0x7f4f7769a249 in ?? () from
> /usr/lib/x86_64-linux-gnu/libsqlite3.so.0
> #14 0x7f4f776a9689 in ?? () from
> /usr/lib/x86_64-linux-gnu/libsqlite3.so.0
> #15 0x7f4f776ae451 in sqlite3_step () from
> /usr/lib/x86_64-linux-gnu/libsqlite3.so.0
> #16 0x7f4f79416557 in get_down_intervals_size
> #(start_time=1403711040,
> end_time=1577836800,
> size=0x7f3c49c68958) at stats_ext.c:202
> #17 0x00407f80 in ns__get_stats_performance (s=0x1e4cb00,
> start_time=1403711040, end_time=1577836800,
> time_unit=NS_MINUTES, resource_id=0, ret=0x7f3c49c68990) at
> msg_handlers/capi_wrappers.c:636
> #18 0x004461c1 in soap_serve_ns__get_stats_performance
> (soap=0x1e4cb00) at soapServer.c:1294
> #19 0x004415ae in soap_serve_request (soap=0x1e4cb00) at
> soapServer.c:119
> #20 0x00440f3e in soap_serve (soap=0x1e4cb00) at
> #soapServer.c:39 21 0x00403c90 in process_request
> #(s=0x1e4cb00) at be_server.c:111 22 0x7f4f79a3de9a in
> #start_thread () from
> /lib/x86_64-linux-gnu/libpthread.so.0
> #23 0x7f4f78f413fd in clone ()
> #from /lib/x86_64-linux-gnu/libc.so.6 24 0x in ?? ()
> 
> Does anyone has an idea?

Don't know with the information you show. But I suggest you to not use 
sqlite3.so from system and add sqlite3.c and sqlite3.h to your project. 
Therefore you can, among other improvements, build a newer and more error free 
sqlite3 version with debug information on and see what happens between the #8 
sqlite3_free() call and #14 sqlite3_step(). Increase in compile time is minimal 
(less than 2 seconds) in my laptop in a fresh rebuild.

> 
> Thanks!
> 
> Mattan.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


---   ---
Eduardo Morras 
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Fwd: signal 6 during sqlite_step in WAL mode

[Mattan Shalev]

Hey guys,
I'm getting signal 6 during sqlite_step in WAL mode. Working on Ubuntu
12.04, sqlite3 3.7.9.
One process is the writing continuously,  while other process reads from
the DB in a multi threaded access. I made sure that sqlite is configured to
serialised mode.

Here is the backtrace:

#0 0x7f4f78f0d08d in nanosleep () from /lib/x86_64-linux-gnu/libc.so.6
#1 0x7f4f78f0cf2c in sleep () from /lib/x86_64-linux-gnu/libc.so.6
#2 0x7f4f7982d881 in signal_catch (signo=6) at signal_masker.c:35
#3 
#4 0x7f4f78e83425 in raise () from /lib/x86_64-linux-gnu/libc.so.6
#5 0x7f4f78e86b8b in abort () from /lib/x86_64-linux-gnu/libc.so.6
#6 0x7f4f78ec139e in ?? () from /lib/x86_64-linux-gnu/libc.so.6
#7 0x7f4f78ecbb96 in ?? () from /lib/x86_64-linux-gnu/libc.so.6
#8 0x7f4f77661690 in sqlite3_free () from
/usr/lib/x86_64-linux-gnu/libsqlite3.so.0
#9 0x7f4f77664b96 in ?? () from
/usr/lib/x86_64-linux-gnu/libsqlite3.so.0
#10 0x7f4f77664c7c in ?? () from
/usr/lib/x86_64-linux-gnu/libsqlite3.so.0
#11 0x7f4f77664cb0 in ?? () from
/usr/lib/x86_64-linux-gnu/libsqlite3.so.0
#12 0x7f4f7768b477 in ?? () from
/usr/lib/x86_64-linux-gnu/libsqlite3.so.0
#13 0x7f4f7769a249 in ?? () from
/usr/lib/x86_64-linux-gnu/libsqlite3.so.0
#14 0x7f4f776a9689 in ?? () from
/usr/lib/x86_64-linux-gnu/libsqlite3.so.0
#15 0x7f4f776ae451 in sqlite3_step () from
/usr/lib/x86_64-linux-gnu/libsqlite3.so.0
#16 0x7f4f79416557 in get_down_intervals_size (start_time=1403711040,
end_time=1577836800,
size=0x7f3c49c68958) at stats_ext.c:202
#17 0x00407f80 in ns__get_stats_performance (s=0x1e4cb00,
start_time=1403711040, end_time=1577836800,
time_unit=NS_MINUTES, resource_id=0, ret=0x7f3c49c68990) at
msg_handlers/capi_wrappers.c:636
#18 0x004461c1 in soap_serve_ns__get_stats_performance
(soap=0x1e4cb00) at soapServer.c:1294
#19 0x004415ae in soap_serve_request (soap=0x1e4cb00) at
soapServer.c:119
#20 0x00440f3e in soap_serve (soap=0x1e4cb00) at soapServer.c:39
#21 0x00403c90 in process_request (s=0x1e4cb00) at be_server.c:111
#22 0x7f4f79a3de9a in start_thread () from
/lib/x86_64-linux-gnu/libpthread.so.0
#23 0x7f4f78f413fd in clone () from /lib/x86_64-linux-gnu/libc.so.6
#24 0x in ?? ()

Does anyone has an idea?


Thanks!

Mattan.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users