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