On Mon, Nov 14, 2016 at 5:13 PM, Stephen Chrzanowski <pontia...@gmail.com>
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
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to