Re: [sqlite] sqlite3 crashes mysteriously on 3.6.20-1

2016-11-10 Thread Richard Hipp
On 11/10/16, pisymbol . wrote: > sqlite-3.6.20-1.el6_7.2.i686 > sqlite-3.6.20-1.el6_7.2.x86_64 Are you aware that SQLite 3.6.20 was published over 7 years ago on 2009-11-04 and that there have been 82 subsequent releases of SQLite and that the newer releases run more than

[sqlite] sqlite3 crashes mysteriously on 3.6.20-1

2016-11-10 Thread pisymbol .
Hi: I'm on Centos 6.8 latest, x86-84. $ uname -a Linux (stubbed out) 2.6.32-642.3.1.el6.x86_64 #1 SMP Tue Jul 12 18:30:56 UTC 2016 x86_64 x86_64 x86_64 GNU/Linux $ rpm -qa sqlite sqlite-3.6.20-1.el6_7.2.i686 sqlite-3.6.20-1.el6_7.2.x86_64 I have a strange issue that I was hoping familiar with

Re: [sqlite] import-prefixed symbols in sqlite3.obj file

2016-11-10 Thread Max Vlasov
On Thu, Nov 10, 2016 at 1:51 PM, Dominique Devienne wrote: > On Thu, Nov 10, 2016 at 11:38 AM, Max Vlasov wrote: > >> __imp_EnterCriticalSection > > > Is this post [1] related to your issue? > Maybe you're not using the 64-bit SDK too? --DD thanks for

Re: [sqlite] sqlite ext3 settings

2016-11-10 Thread Simon Slavin
On 10 Nov 2016, at 10:03am, Dan Kennedy wrote: > It seems to be that if your drive has write-caching enabled, you need > barrier=1 to avoid risking corruption. Or you can get away with barrier=0 if > write-caching is disabled. To supplement Dan's answer, having

Re: [sqlite] import-prefixed symbols in sqlite3.obj file

2016-11-10 Thread Dominique Devienne
On Thu, Nov 10, 2016 at 11:38 AM, Max Vlasov wrote: > __imp_EnterCriticalSection Is this post [1] related to your issue? Maybe you're not using the 64-bit SDK too? --DD [1] http://stackoverflow.com/questions/17840857/linker-errors-while-migrating-from-x32-to-x64

[sqlite] import-prefixed symbols in sqlite3.obj file

2016-11-10 Thread Max Vlasov
Hi, Trying to link sqlite object file generated by visual c++ command-line compiler(cl.exe sqlite3.c /c) with the Delphi 64 bit executable, I encountered that some functions by windows api used by sqlite contains "___imp_" prefix (total: 7). This happened since recent delphi 64 bit compilers

Re: [sqlite] sqlite ext3 settings

2016-11-10 Thread Dan Kennedy
On 11/10/2016 06:25 AM, Andrii Motsok wrote: Hi, I have sqlite database on top of ext3 (on ssd). Does 1) ext3 parameters (data=writeback|ordered,barrier=0|1, etc) 2) drive write-caching setting (hdparm -W) value 3) ??? There's a thread here: