On Mon, Nov 14, 2016 at 5:13 PM, Stephen Chrzanowski <[email protected]>
wrote:
> Can you move project to different hardware?
>
Nope.
Here's at least one stack trace:
#0 sqlite3VdbeUsesBtree (yyp=0x7fffec013a28, yymajor=1, yyminor=...,
pParse=<value optimized out>) at sqlite3.c:71844
#1 sqlite3FinishCoding (yyp=0x7fffec013a28, yymajor=1, yyminor=...,
pParse=<value optimized out>) at sqlite3.c:32928
#2 yy_reduce (yyp=0x7fffec013a28, yymajor=1, yyminor=..., pParse=<value
optimized out>) at sqlite3.c:3993
#3 sqlite3Parser (yyp=0x7fffec013a28, yymajor=1, yyminor=...,
pParse=<value optimized out>) at sqlite3.c:5356
#4 0x0000000000540b87 in sqlite3RunParser (pParse=0x7ffff62c9fe0,
zSql=0x58cf28 "SELECT jobid, jobfile, jobtype, jobstate, jobcid FROM
jobs;", pzErrMsg=0x7ffff62ca240) at sqlite3.c:137375
#5 0x0000000000542d76 in sqlite3Prepare (db=0x7fffec013238, zSql=0x58cf28
"SELECT jobid, jobfile, jobtype, jobstate, jobcid FROM jobs;", nBytes=-1,
saveSqlFlag=1, pReprepare=<value optimized out>, ppStmt=0x7ffff62ca350,
pzTail=0x0) at sqlite3.c:114110
#6 0x0000000000542f8c in sqlite3LockAndPrepare (db=0x7fffec013238,
zSql=0x58cf28 "SELECT jobid, jobfile, jobtype, jobstate, jobcid FROM
jobs;", nBytes=-1, saveSqlFlag=1, pOld=0x0, ppStmt=0x7ffff62ca350,
pzTail=0x0) at sqlite3.c:114201
#7 0x0000000000543258 in sqlite3_prepare_v2 (db=<value optimized out>,
zSql=<value optimized out>, nBytes=<value optimized out>, ppStmt=<value
optimized out>, pzTail=<value optimized out>) at sqlite3.c:114277
Here is the line
71844 if( i!=1 && sqlite3BtreeSharable(p->db->aDb[i].pBt) ){
(gdb) p p->db->aDb[i]
$4 = {
zDbSName = 0x7fffec00cbb0 "",
pBt = 0x0,
safety_level = 200 '\310',
bSyncSet = 203 '\313',
pSchema = 0x7ffff62c9fe0
}
This is statically linked with 3.1.5. Obviously, I must be doing something
wrong but I don't have the slightest.
It is triggered by this line again.
1777 if (sqlite3_prepare_v2(db, SELECT_JOBS_QUERY, -1, &stmt, NULL)
!= 0) {
I tried using FULLMUTEX thinking that my issue was two threads accessing
the database through the same handle (which I didn't think was a big deal,
I just have a cached handle used by threads to fetch things).
Any ideas?
-aps
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
