[sqlite] Problem when upgrading from FTS3/4 to FTS5 modules

2015-11-04 Thread a...@zator.com
Hi list: Using SQLite 3.9.1, suppose a C++ application using FTS3/4 modules with this pseudocode: 1a In config.h #define SQLITE_ENABLE_FTS3 1 #define SQLITE_ENABLE_FTS3_PARENTHESIS 1 2a.- Delete the previous table if exist DROP TABLE IF EXISTS ftsm 3a.- Then create the table

[sqlite] Problem with sqlite3_create_function

2015-11-04 Thread Bart Smissaert
Is there something wrong or is there something missing from this sequence of SQLite actions? Note that all the return values are checked and are fine: sqlite3_open_v2 sqlite3_create_function sqlite3_prepare16_v2 run in loop till SQLITE_DONE: sqlite3_step(lStatementHandle) sqlite3_step will run

[sqlite] Problem with sqlite3_create_function

2015-11-04 Thread Bart Smissaert
Yes, I didn't think there was a bug in SQLite here, but just wanted some confirmation. Thanks for that. I suppose the only way to get to the bottom of this is to run sqlite3.dll, compiled with SQLITE_DEBUG and SQLITE_MEMDEBUG enabled and look at the log/trace. RBS On Wed, Nov 4, 2015 at 7:42

[sqlite] Problem with sqlite3_create_function

2015-11-04 Thread Bart Smissaert
Been trying to get to the bottom of this, but no success. Note that with one UDF in the statement all runs perfectly fine. Could somebody confirm that they can run 2 UDF's (I have mainly tried with the 2 the same UDF's) in the same SQL and that all runs as how it should? Just to make sure there is

[sqlite] Problem when upgrading from FTS3/4 to FTS5 modules

2015-11-04 Thread Richard Hipp
On 11/4/15, ajm at zator.com wrote: > The question: do is there any method to delete the old table without > including the FTS3/4 modules to those users "in the field"? > Here is a hack. Let the name of your FTS3 table be "xyzzy" (1) Invoke "PRAGMA writable_schema=ON". (Read the documentation

[sqlite] Problem with sqlite3_create_function

2015-11-04 Thread Richard Hipp
On 11/4/15, Bart Smissaert wrote: > Been trying to get to the bottom of this, but no success. > Note that with one UDF in the statement all runs perfectly fine. > Could somebody confirm that they can run 2 UDF's (I have mainly tried with > the 2 the same UDF's) in the same SQL and that all > runs

[sqlite] MultiThread Error 10 on Windows Mobile 6.x

2015-11-04 Thread Joe Mistachkin
Jim Morris wrote: > > at line 37428: > while( cnt-->0 && (res = winLockFile(>h, SQLITE_LOCKFILE_FLAGS, > PENDING_BYTE, 0, 1, 0))==0 ){ > Are you using version 3.9.2 or some other version? > > cnt = 2 > locktype = 1//SHARED_LOCK > lastErrno = 6

[sqlite] MultiThread Error 10 on Windows Mobile 6.x

2015-11-04 Thread Jim Morris
Problem is trying to get a shared lock in sqlite.c, "static int winLock(sqlite3_file *id, int locktype)" at line 37428: while( cnt-->0 && (res = winLockFile(>h, SQLITE_LOCKFILE_FLAGS, PENDING_BYTE, 0, 1, 0))==0 ){ cnt = 2 locktype = 1//SHARED_LOCK

[sqlite] Problem with locked database

2015-11-04 Thread ALBERT Aurélien
Thanks you both. I'm already using a timeout of 1 minute. My "Database is locked" errors only happen in the following situation : - I run an import thread, which does a lot of write - this thread uses a transaction : BEGIN at import start, COMMIT/ROLLBACK at import end - during the import

[sqlite] Problem with locked database

2015-11-04 Thread Simon Slavin
On 4 Nov 2015, at 8:00am, ALBERT Aur?lien wrote: > - this thread uses a transaction : BEGIN at import start, COMMIT/ROLLBACK at > import end > - during the import (which is very long to execute, sometimes several hours), > another thread execute reads on the same database (different

[sqlite] MultiThread Error 10 on Windows Mobile 6.x

2015-11-04 Thread Jim Morris
No. The app works, however when I scroll the list there are may requests to get records from the DB and it seems to interact with the background thread to produce this error. On 11/3/2015 7:02 PM, Joe Mistachkin wrote: > Jim Morris wrote: >> Is there a graceful work around? >> >> >>