-boun...@mailinglists.sqlite.org] On Behalf Of Clemens
Ladisch
Sent: Wednesday, July 15, 2015 5:43 AM
To: sqlite-users at mailinglists.sqlite.org
Subject: Re: [sqlite] journal file and its size
Mayank Kumar (mayankum) wrote:
> Sometimes we see the journal file not present on the system although
> active t
Our application uses the following pragma with sqlite 3.7.7.1
PRAGMA synchronous=FULL;
PRAGMA locking_mode=EXCLUSIVE";
I understand from the documentation that with exclusive mode the journal file
is always created and never deleted until the exclusive mode is exited.
Now my questions are:-
-my
read/write cycles it is possible that the
memory is near the end of its life and needs to be replaced.
Scott Doctor
scott at scottdoctor.com
On 6/23/2015 1:09 AM, Simon Slavin wrote:
> On 23 Jun 2015, at 6:01am, Mayank Kumar (mayankum)
> wrote:
>
>> Do you thin
users-boun...@mailinglists.sqlite.org] On Behalf Of Simon Slavin
Sent: Monday, June 22, 2015 6:11 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] sqlite error code 1034
On 23 Jun 2015, at 1:33am, Mayank Kumar (mayankum)
wrote:
> We once in a while see the following errors returns by
Hi Sqlite users
We once in a while see the following errors returns by sqlite for a database
created on nvram. I am trying to understand, how are other users handling this
error ? if fsync fails and sqlite api fails because of this issue, does sqlite
internally retry before declaring it cannot c
Hi All
I am thinking about measuring the performance of sqlite3 write transactions
after lot of delete transactions have been performance but vacuum has not been
performed versus when vacuum is performed. Wanted to get some ideas here on
what people think theoretically should happen. I know it r
Hipp
Sent: Monday, March 09, 2015 3:27 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] sqlite3_exec ROLLBACK command
On 3/9/15, Mayank Kumar (mayankum) wrote:
> Hi All
>
> We have some legacy code which calls sqlite3_exec with ROLLBACk every
> time sqlite3_step fails
Hi All
We have some legacy code which calls sqlite3_exec with ROLLBACk every time
sqlite3_step fails irrespective what specific error occurred. I am wondering if
this is a safe behavior or should I change this. Can it cause any sideeffects
or memory leak or any other issues ?
What is the righ
for a fully functional demo licence
>
>
> On 13 February 2015 at 02:47, Richard Hipp wrote:
>> On 2/12/15, Mayank Kumar (mayankum) wrote:
>>> Hi All
>>>
>>> We have two systems which are running in active/standby
>>> configuration. The active machin
Hi All
We have two systems which are running in active/standby configuration. The
active machine, is actively writing sqlite transactions to a file abcd.db. The
standby is syncing the abcd.db file from the active machine on a
communication channel and writing the delta records to the abcd.db
does gperftools shows sqlite3_memory_used as using
the largest amount of memory
Mayank Kumar (mayankum) wrote:
> -my application sqlite based runs for months before it might get
> restarted -while its running there are places we need to execute the
> following series :-
> - sqlite3_bind
SQLite Database
Subject: Re: [sqlite] why does gperftools shows sqlite3_memory_used as using
the largest amount of memory
On Thu, Oct 2, 2014 at 2:21 PM, Mayank Kumar (mayankum)
wrote:
> Hi All
> I am using sqlite 3.7.7.1
>
> When profiling my application using gperftools-2.0, the pr
Hi All
I am using sqlite 3.7.7.1
When profiling my application using gperftools-2.0, the profile always shows
sqlite3_memory_used as the top user of memory. Why would sqlite3_memory_used
use so much memory as it just reports the status of sqlite3_malloc/free. Are
there known memory leaks in th
24, 2014 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) wrote:
> Thanks Simon. I found from the code, there are times when our process di
ocked"
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 wh
atabase 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
corrupted -what line number or
when was this issue first detected -what is the extended error code in this
scenarios ?
-mayank
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Mayank Kumar (mayankum)
Sent: Friday, July 18
-what is the extended error code in this scenarios ?
-mayank
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Mayank Kumar (mayankum)
Sent: Friday, July 18, 2014 12:26 PM
To: General Discussion of SQLite Database
Subject: Re
in
Sent: 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) wrote:
> I was calling it after sqlite3_open,I will
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
s restarts, it returns error
"database is locked"
what's your file system? looks like not related at all to sqlite but your code
On Fri, Jul 11, 2014 at 4:31 PM, Mayank Kumar (mayankum) wrote:
> Hi Richard
> I have enabled error logging as suggested. Is there a way to test
to: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, 2014 at 3:58 PM, Mayank Kumar (maya
e.org [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 (m
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 lock
Behalf Of Richard Hipp
Sent: Tuesday, June 10, 2014 4:21 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] What is the recommended size we should keep aside for
sqlite journal
On Tue, Jun 10, 2014 at 6:43 PM, Mayank Kumar (mayankum) wrote:
> We have limited flash space and
We have limited flash space and we would like to know what is the recommended
allocation for the sqlite db vs sqlite journal file. Should it be 50-50 or it
doesn't matter. If there is no very less space remaining to write the complete
journal file, what will happen.
Any help is appreciated.
Th
Hi
This is a follow up questions related to the db corruption question I asked a
few days earlier. Our architecture is such that we have two roles primary and
secondary and the secondary syncs(rsyncs) the sqlite db from the primary from
time to time. Also the primary sometime sends records to s
power outage scenarios
On 7 Nov 2013, at 11:50pm, Mayank Kumar (mayankum) wrote:
> Are there known tools which tell us what data corrupted the db or some way of
> removing only the corrupted section of the db ?
Download the SQLite shell tool for your platform.
Use .dump to dump the databas
scenarios
On Thu, Nov 7, 2013 at 6:50 PM, Mayank Kumar (mayankum)
wrote:
>
> I also saw some references to corruption being caused when the same db
> is written to by 3.6 and then being written to by 3.7. Is that true,
> because we have similar scenario where the db was originally w
getting corrupt on power outage scenarios
On Wed, Nov 6, 2013 at 2:10 PM, Mayank Kumar (mayankum)
wrote:
> Hi Sqlite Users
> I am running into a situation where sometimes after the power is
> restored my sqlite db running on linux is corrupted. Here is what I
> see with
> integrity_che
Hi Sqlite Users
I am running into a situation where sometimes after the power is restored my
sqlite db running on linux is corrupted. Here is what I see with
integrity_check:-
*** in database main ***
Page 895: btreeInitPage() returns error code 11
On tree page 2 cell 765: Child page depth diffe
31 matches
Mail list logo
