Discussion of SQLite Database
Subject: EXT :Re: [sqlite] Autoincrement failure
SELECT rowid FROM (mytable) WHERE (mystuff)
returns
37 identical rows(!) where Rowid = 1
Alessandro
From:
a.azzol...@custom.it
To:
Date:
22/08/2011 16.26
Subject:
Re: [sqlite] Autoincrement failure
sqlite
On 24 Aug 2011, at 1:13pm, a.azzol...@custom.it wrote:
> On my laptop integrity_check fail
>
>> PRAGMA integrity_check
>> returns
>>
>> *** in database main ***
>> rowid 0 missing from index JournalDateIndex
>> rowid 0 missing from index sqlite_autoindex_Journal_1
>> wrong # of entries in index
on of SQLite Database
Date:
23/08/2011 18.44
Subject:
Re: [sqlite] Autoincrement failure
On 23 Aug 2011, at 4:28pm, a.azzol...@custom.it wrote:
> I cannot run a shell sqlite3 on my embedded system. I will explain it
> using your example.
At some point your database file is
On 23 Aug 2011, at 4:28pm, a.azzol...@custom.it wrote:
> I cannot run a shell sqlite3 on my embedded system. I will explain it
> using your example.
At some point your database file is becoming corrupt.
> It happen that sometime autoincrement begin to fail
> and new records overwrite the one a
orate
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of a.azzol...@custom.it [a.azzol...@custom.it]
Sent: Tuesday, August 23, 2011 10:28 AM
To: General Discussion of SQLite Database
Subject: EXT :Re: [sqlite] Autoincrement failure
Sorry,
I cannot run a shell sqlit
From:
"Black, Michael (IS)"
To:
General Discussion of SQLite Database
Date:
23/08/2011 17.07
Subject:
Re: [sqlite] Autoincrement failure
Your insert looks OK...can you run sqlite3 on your embedded system?
Try this and see what you get...I ran this on an MMC I had and it worked
O
n
behalf of a.azzol...@custom.it [a.azzol...@custom.it]
Sent: Tuesday, August 23, 2011 8:55 AM
To: General Discussion of SQLite Database
Subject: EXT :Re: [sqlite] Autoincrement failure
table definition:
"CREATE TABLE Journal (ClosureNum INTEGER, TicketNum INTEGER, ItemNum
INTEGER, Date DATE, Tim
l (IS)"
To:
General Discussion of SQLite Database
Date:
23/08/2011 15.50
Subject:
Re: [sqlite] Autoincrement failure
Could you please show us your table definition and an example insert
statement that your generating?
Michael D. Black
Senior Scientist
NG Information Systems
Advanced An
On 23 Aug 2011, at 2:35pm, a.azzol...@custom.it wrote:
> Normally INSERT operations of new records works fine. Perhaps,
> autoincrement failure is due to electrical pbm and is present only on few
> devices
> but I'm looking for a way to protect DB file against this pbm.
>
> This failure is a D
...@sqlite.org] on
behalf of a.azzol...@custom.it [a.azzol...@custom.it]
Sent: Tuesday, August 23, 2011 8:35 AM
To: General Discussion of SQLite Database
Subject: EXT :Re: [sqlite] Autoincrement failure
I'm using SQLite on embedded system (ARM processor)
and DB file is on MMC memory.
Normally I
o:
General Discussion of SQLite Database
Date:
23/08/2011 15.42
Subject:
Re: [sqlite] Autoincrement failure
On Tue, Aug 23, 2011 at 9:35 AM, wrote:
> IMy table has three primary key, autoincrement active and other
description
> column like
>
The AUTOINCREMENT feature of SQLite only works i
On Tue, Aug 23, 2011 at 9:35 AM, wrote:
> IMy table has three primary key, autoincrement active and other description
> column like
>
The AUTOINCREMENT feature of SQLite only works if there is a single INTEGER
PRIMARY KEY.
Please send us the text of the CREATE TABLE statement for your table so
on of SQLite Database
Date:
23/08/2011 14.10
Subject:
Re: [sqlite] Autoincrement failure
Give the recent notice of a bug in gcc-4.1 what compiler are you using and
how are you compiling?
And can you reproduce this with a small example table?
Michael D. Black
Senior Scientist
NG Inform
: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of a.azzol...@custom.it [a.azzol...@custom.it]
Sent: Tuesday, August 23, 2011 7:01 AM
To: General Discussion of SQLite Database
Subject: EXT :Re: [sqlite] Autoincrement failure
Reindex procedure returns 'no_error'
1)
Many thanks,
Alessandro
From:
Richard Hipp
To:
General Discussion of SQLite Database
Date:
22/08/2011 17.40
Subject:
Re: [sqlite] Autoincrement failure
On Mon, Aug 22, 2011 at 11:25 AM, wrote:
> schema 3
>
> PRAGMA integrity_check
> returns
>
> *** in database main
t; wrong # of entries in index sqlite_autoindex_Journal_1
>
Try running "REINDEX" and see if that clears up the problem.
>
>
>
>
>
> From:
> Richard Hipp
> To:
> General Discussion of SQLite Database
> Date:
> 22/08/2011 17.21
> Subject:
> R
:
General Discussion of SQLite Database
Date:
22/08/2011 17.21
Subject:
Re: [sqlite] Autoincrement failure
On Mon, Aug 22, 2011 at 11:17 AM, wrote:
> SELECT rowid FROM (mytable) WHERE (mystuff)
>
> returns
>
> 37 identical rows(!) where Rowid = 1
>
What is your schema?
m:
> a.azzol...@custom.it
> To:
>
> Date:
> 22/08/2011 16.26
> Subject:
> Re: [sqlite] Autoincrement failure
>
>
>
> sqlite> .dump sqlite_sequence
> PRAGMA foreign_keys=OFF;
> BEGIN TRANSACTION;
> COMMIT;
> sqlite>
>
>
> Any idea?
>
&
SELECT rowid FROM (mytable) WHERE (mystuff)
returns
37 identical rows(!) where Rowid = 1
Alessandro
From:
a.azzol...@custom.it
To:
Date:
22/08/2011 16.26
Subject:
Re: [sqlite] Autoincrement failure
sqlite> .dump sqlite_sequence
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
COM
sqlite> .dump sqlite_sequence
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
COMMIT;
sqlite>
Any idea?
Thanks
Alessandro
From:
Richard Hipp
To:
General Discussion of SQLite Database
Date:
22/08/2011 16.11
Subject:
Re: [sqlite] Autoincrement failure
On Mon, Aug 22, 2011 at 9:56 AM,
On Mon, Aug 22, 2011 at 9:56 AM, wrote:
> Hallo,
>
> Have you ever seen a SQLite3 DB file with autoincrement algoritm broken?
> Every new record seems to be added with rowid=1 overwriting existing
> info...
>
> Any idea about the causes of this issue
> and about extracting lost data (if present)?
Hallo,
Have you ever seen a SQLite3 DB file with autoincrement algoritm broken?
Every new record seems to be added with rowid=1 overwriting existing
info...
Any idea about the causes of this issue
and about extracting lost data (if present)?
Many thanks
Alessandro
__
22 matches
Mail list logo
