Re: [sqlite] [EXTERNAL] Error in recover sqlite3 database

2019-08-01 Thread bhandari_nikhil
This is my table, I just wanted to show the error that it is throwing. Is the error due to /tmp being full on my device ? Further debugging at our end showed that one way to replicate the problem is to remove the hot journal file in the middle of an insert transaction but we are not sure if that

[sqlite] Error in recover sqlite3 database

2019-07-31 Thread bhandari_nikhil
My sqlite3 database keeps on increasing in memory (although it is limited by memory). If I try to rebuild the database, it is giving the following error: sqlite> INSERT INTO tbllog(tbllog) VALUES('rebuild'); Error: database or disk is full Is the

Re: [sqlite] Bug in sqlite3.c

2019-06-06 Thread bhandari_nikhil
I tried "INSERT INTO ft(ft) VALUES('integrity-check')" and it also did not give any error. But the rebuild command helped solve my problem as the crashes stopped, otherwise my application was crashing at every commit operation (thanks a lot for that). Is there any command/API which can bypass

Re: [sqlite] Bug in sqlite3.c

2019-06-03 Thread bhandari_nikhil
Thanks Dan. I had checked the database integrity using the following command: sqlite3 myfile.db "PRAGMA integrity_check;" And it had reported ok. I will see if I can share the database file here. Can you let me know how to check the db file (in case I am not able to share the db file here) ? And

[sqlite] Bug in sqlite3.c

2019-06-02 Thread bhandari_nikhil
I am facing a crash in sqlite3fts5BufferAppendBlob. Following is the backtrace: #0 sqlite3Fts5BufferAppendBlob (pRc=pRc@entry=0xf54139c8, pBuf=pBuf@entry=0xf5afeb90, nData=4294967295, pData=0xf49fff76 "90246ture") at sqlite3.c:180474 #1 0xf717b6f8 in fts5WriteAppendTerm

Re: [sqlite] Crash in sqlite3fts5BufferAppendBlob

2019-05-28 Thread bhandari_nikhil
Please help as to what parameters could have gone wrong when I see the crash here: #0 sqlite3Fts5BufferAppendBlob (pRc=pRc@entry=0xf54139c8, pBuf=pBuf@entry=0xf5afeb90, nData=*4294967295*, pData=0xf49fff76 "90246ture") at sqlite3.c:180474 #1 0xf717b6f8 in fts5WriteAppendTerm