Re: [sqlite] Noticed crash on windows

[dd]

Thank you all for your inputs. Let me check.

On Wed, Mar 26, 2014 at 2:05 PM, Oliver Schneider
 wrote:
> On 2014-03-25 18:52, Larry Brasfield wrote:
>> Going in, it is best to not read too much into your code running
>> "pretty well" on a Unix platform.  Have you run your code with
>> Valgrind (or equivalent) on that platform?  If not, doing so may help
>> you uncover a bug which affects behavior more badly on Windows with
>> your present build.
> DrMemory also exists for Windows and can be used there, it uses the
> DynamoRIO instrumentation framework. I am not sure about the state of
> affairs of AddressSanitizer with GCC on Windows, but that could be
> another option with a smaller performance penalty.
>
> // Oliver
> ___
> 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] Noticed crash on windows

[Oliver Schneider]

On 2014-03-25 18:52, Larry Brasfield wrote:
> Going in, it is best to not read too much into your code running
> "pretty well" on a Unix platform.  Have you run your code with
> Valgrind (or equivalent) on that platform?  If not, doing so may help
> you uncover a bug which affects behavior more badly on Windows with
> your present build.
DrMemory also exists for Windows and can be used there, it uses the
DynamoRIO instrumentation framework. I am not sure about the state of
affairs of AddressSanitizer with GCC on Windows, but that could be
another option with a smaller performance penalty.

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

Re: [sqlite] Noticed crash on windows

[Teg]

>>Quite unlikely is the prospect for somebody here to say "Yes, we
>>routinely see crashes on Windows in the sqlite3_mutex_enter code."
>>You are going to have to debug this.

This. I run the hell out of Sqlite under 32 and 64 bit windows with no
issues. 20-40 GB databases are common with multi-thread access.
Typically only one writer though but, multiple threaded readers.

Try running your code in debug build mode. I've run into cases where
the release would crash and the debug version wouldn't. Typically,
it's caused by a variable I forgot to initialize, which is zero'd in
debug mode and not in release.

I've  not  had any luck with "Full Program Optimization" either. Might
try not using that if you currently do. 

C


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

Re: [sqlite] Noticed crash on windows

[Larry Brasfield]

durga.disc wrote:
> We have an application on unix platform with sqlite database which
> is running from last 2 years. pretty well.
>
>   We recently ported on Windows too. Crashed at inserting record in a
> small database(less than 20 records, record has 10 columns). It's not
> reproducible.
>
>   call stack:
>
>   ntdll!RtlEnterCriticalSection+0x12
>   !winMutexEnter+0x13
>   !sqlite3_mutex_enter+0x19
>   !sqlite3_step+0x5e
>
>   Is it known issue with 3.7.11 on Windows.  Any idea?

That call stack shows (attempted) execution of some code which is hit
very frequently by most any Windows-hosted SQLite app.  This fact,
together with the extensive testing of SQLite on Windows, suggests
that your problem lies within code you have not shown, and most likely
within your own code.

If it is not reproducible, it may prove worthwhile to eliminate
threading issues, if you can, and to check for heap corruption and
buffer over-writes.

Going in, it is best to not read too much into your code running
"pretty well" on a Unix platform.  Have you run your code with
Valgrind (or equivalent) on that platform?  If not, doing so may help
you uncover a bug which affects behavior more badly on Windows with
your present build.

On Windows, you can use debugging aids built into the debug version of
the MS C runtime.  (See
http://msdn.microsoft.com/en-us/library/zh712wwf.aspx .)

Quite unlikely is the prospect for somebody here to say "Yes, we
routinely see crashes on Windows in the sqlite3_mutex_enter code."
You are going to have to debug this.

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

[sqlite] Noticed crash on windows

[dd]

Hi all,

  We have an application on unix platform with sqlite database which
is running from last 2 years. pretty well.

  We recently ported on Windows too. Crashed at inserting record in a
small database(less than 20 records, record has 10 columns). It's not
reproducible.

  call stack:

  ntdll!RtlEnterCriticalSection+0x12
  !winMutexEnter+0x13
  !sqlite3_mutex_enter+0x19
  !sqlite3_step+0x5e


  Is it known issue with 3.7.11 on Windows.  Any idea?

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