a timestamp that seems to have changed.
Greg
-Original Message-
From: sqlite-users-boun...@sqlite.org on behalf of Max Vlasov
Sent: Thu 1/6/2011 9:55 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Corrupted database file.
On Thu, Jan 6, 2011 at 4:34 PM, Greg Morehea
e: [sqlite] Corrupted database file.
On Wed, Jan 5, 2011 at 10:05 PM, Greg Morehead
wrote:
> I seem to have a corrupted DB which I was able to fix with a vacuum
> command. Any insights on how this could occur would be greatly
appreciated.
>
>
>
Greg, can you post full or partial (
I seem to have a corrupted DB which I was able to fix with a vacuum command.
Any insights on how this could occur would be greatly appreciated.
Before the vacuum command:
- sql: select rowid, timestamp from DCDCs order by rowid asc limit 1;
- Result: 7513686 1284840120682
- sql: select
Thanks Eric, you nailed it on the head!
With this parameter I am able to configure the page usage and stop the memory
growth where I want it!
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Eric Minbiole
Sent: Monday, June
qlite] Memory leak with sqlite3_exec on qnx 6.4.1
On Fri, Jun 26, 2009 at 05:07:16PM -0400, Greg Morehead scratched on the wall:
>
> If I close then reopen the database all my memory is recovered.
>
> Is this by design??? I was intending on keeping a connection open most of
> t
: [sqlite] Memory leak with sqlite3_exec on qnx 6.4.1
On Fri, 26 Jun 2009 17:07:16 -0400, "Greg Morehead"
wrote:
>
>If I close then reopen the database all my memory is recovered.
>
>Is this by design???
Yes, what you see is probably the page cache.
>I was intendin
If I close then reopen the database all my memory is recovered.
Is this by design??? I was intending on keeping a connection open most of time.
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Greg Morehead
Sent: Friday
FYI. I replaced the sqlite3_exec call with sqlite3_prepare_v2, sqlite3_step,
sqlite3_finalize.
Same results.
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Greg Morehead
Sent: Friday, June 26, 2009 4:21 PM
To: General
sqlite3_free is only
being called if there is an error.
See http://sqlite.org/c3ref/exec.html
g
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Greg Morehead
Sent: Friday, June 26, 2009 2:49 PM
To: sqlite-users@sqlite.org
emory leak with sqlite3_exec on qnx 6.4.1
On Jun 26, 2009, at 3:49 PM, Greg Morehead wrote:
> The extremely simple app below leaks. What am I doing wrong??
> Please help.
How do you know it is leaking memory? How are you measuring?
>
>
> #include
> #include
> #include "s
The extremely simple app below leaks. What am I doing wrong?? Please help.
#include
#include
#include "stdio.h"
#include "sqlite3.h"
#include
#define TFQ_SQL_DB_NAME "/powerblock/datalog/TFQ-test.db"
#define _TABLE_NAME "sqltest"
int main(int argc, char *argv[])
{
char sql[1024];
11 matches
Mail list logo
