Re: [sqlite] Sometimes when my process restarts, it returns error "database is locked"

14 4:09 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Sometimes when my process restarts, it returns error "database is locked" On 24 Jul 2014, at 8:21pm, Mayank Kumar (mayankum) <mayan...@cisco.com> wrote: > Thanks Simon. I found from the code, there are times whe

Re: [sqlite] Sometimes when my process restarts, it returns error "database is locked"

On 24 Jul 2014, at 8:21pm, Mayank Kumar (mayankum) wrote: > Thanks Simon. I found from the code, there are times when our process dies > without closing the db , so I will be fixing those. > > Regarding >> Do you call have a timeout value set before you make the API call

Re: [sqlite] Sometimes when my process restarts, it returns error "database is locked"

iginal Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: Wednesday, July 23, 2014 1:24 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Sometimes when my process restarts, it returns error "databas

Re: [sqlite] Sometimes when my process restarts, it returns error "database is locked"

On 23 Jul 2014, at 8:56pm, Mayank Kumar (mayankum) wrote: > I have already enabled extended error codes but I am not seeing any extended > error codes being returned. I also enabled the error logging callback which > just prints the errorcode and the error message which I

Re: [sqlite] Sometimes when my process restarts, it returns error "database is locked"

-Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: Wednesday, July 23, 2014 11:44 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Sometimes when my process restarts, it returns error "dat

Re: [sqlite] Sometimes when my process restarts, it returns error "database is locked"

On 23 Jul 2014 at 19:43, Simon Slavin wrote: >> -what line number or when was this issue first detected > > SQLite does not know how your application is organised. One particular API > call returns the error, so you know where the error was found: it was by that > call.

Re: [sqlite] Sometimes when my process restarts, it returns error "database is locked"

On 23 Jul 2014, at 7:27pm, Mayank Kumar (mayankum) wrote: > SQLITE_LOG: sqlite errcode=26, sqlite errmsg=file is encrypted or is not a > database > > The same error code I get in the return value of sqlite3_step. Just wondering > if there is a way I can get this error

Re: [sqlite] Sometimes when my process restarts, it returns error "database is locked"

, 2014 12:26 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Sometimes when my process restarts, it returns error "database is locked" Thanks Simon. Now sqlite3_config is the first call we are making followed by sqlite3_open. I am checking the return code for all call

Re: [sqlite] Sometimes when my process restarts, it returns error "database is locked"

: [sqlite] Sometimes when my process restarts, it returns error "database is locked" Thanks Simon. Now sqlite3_config is the first call we are making followed by sqlite3_open. I am checking the return code for all calls. In one of the sqlite3_step calls later, I am getting an e

Re: [sqlite] Sometimes when my process restarts, it returns error "database is locked"

nt: Tuesday, July 15, 2014 11:13 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Sometimes when my process restarts, it returns error "database is locked" On 15 Jul 2014, at 6:58pm, Mayank Kumar (mayankum) <mayan...@cisco.com> wrote: > I was calling it after

Re: [sqlite] Sometimes when my process restarts, it returns error "database is locked"

On 15 Jul 2014, at 6:58pm, Mayank Kumar (mayankum) wrote: > I was calling it after sqlite3_open,I will try calling before sqlite3_open > and update the thread. When you call sqlite3_config() after sqlite3_open() it returns SQLITE_MISUSE to tell you you're doing it wrong.

Re: [sqlite] Sometimes when my process restarts, it returns error "database is locked"

of SQLite Database Subject: Re: [sqlite] Sometimes when my process restarts, it returns error "database is locked" -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 14/07/14 22:39, Mayank Kumar (mayankum) wrote: > The file system is ext3. I am calling this api > > sqlite3_confi

Re: [sqlite] Sometimes when my process restarts, it returns error "database is locked"

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 14/07/14 22:39, Mayank Kumar (mayankum) wrote: > The file system is ext3. I am calling this api > > sqlite3_config(SQLITE_CONFIG_LOG, errorLogCallback, NULL); [...] > Is my understanding correct since my callback is not getting called ? Did you

Re: [sqlite] Sometimes when my process restarts, it returns error "database is locked"

gt; sqlite-users-boun...@sqlite.org] On Behalf Of Richard Hipp > Sent: Tuesday, July 08, 2014 1:05 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Sometimes when my process restarts, it returns > error "database is locked" > > On Tue, Jul 8

Re: [sqlite] Sometimes when my process restarts, it returns error "database is locked"

ipp > Sent: Tuesday, July 08, 2014 1:05 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Sometimes when my process restarts, it returns error > "database is locked" > > On Tue, Jul 8, 2014 at 3:58 PM, Mayank Kumar (mayankum) < > mayan...@cisco

Re: [sqlite] Sometimes when my process restarts, it returns error "database is locked"

users-boun...@sqlite.org] On Behalf Of Richard Hipp Sent: Tuesday, July 08, 2014 1:05 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Sometimes when my process restarts, it returns error "database is locked" On Tue, Jul 8, 2014 at 3:58 PM, Mayank Kumar (mayankum) <ma

Re: [sqlite] Sometimes when my process restarts, it returns error "database is locked"

On 8 Jul 2014, at 11:25pm, Mayank Kumar (mayankum) wrote: > Our process can restart unexpectedly sometimes and sometimes we die so that > we can come up with a new version or failover. The locking may depend on how the process crashes (restarts) and how much the operating

Re: [sqlite] Sometimes when my process restarts, it returns error "database is locked"

[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: Tuesday, July 08, 2014 2:42 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Sometimes when my process restarts, it returns error "database is locked" On 8 Jul 2014, at 8:58pm, Mayank Kumar (mayank

Re: [sqlite] Sometimes when my process restarts, it returns error "database is locked"

On 8 Jul 2014, at 8:58pm, Mayank Kumar (mayankum) wrote: > We have a process with a single sqlite db and a single connection to the > database from a thread. From time to time our processs restarts Does your application close the database as part of the restart process ?

Re: [sqlite] Sometimes when my process restarts, it returns error "database is locked"

On Tue, Jul 8, 2014 at 3:58 PM, Mayank Kumar (mayankum) wrote: > Hi All > > We have a process with a single sqlite db and a single connection to the > database from a thread. From time to time our processs restarts and reopens > the database or tries to create the database if

[sqlite] Sometimes when my process restarts, it returns error "database is locked"

Hi All We have a process with a single sqlite db and a single connection to the database from a thread. From time to time our processs restarts and reopens the database or tries to create the database if it doesn't exists. Sometimes when the process restarts, we get the error "database is