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:
<sqlite-users@sqlite.org>
Date:
22/08/2011 16.26
Subject:
Re: [
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
:
General Discussion of SQLite Database <sqlite-users@sqlite.org>
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
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
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 sqlite3
IS)" <michael.bla...@ngc.com>
To:
General Discussion of SQLite Database <sqlite-users@sqlite.org>
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
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, Time TIME, Item BLOB, PRIMARY KEY(ClosureNum,
TicketNum, ItemNum))"
example inser
;
To:
General Discussion of SQLite Database <sqlite-users@sqlite.org>
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 Scientis
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
...@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 INSERT
..@sqlite.org>
To:
General Discussion of SQLite Database <sqlite-users@sqlite.org>
Date:
23/08/2011 15.42
Subject:
Re: [sqlite] Autoincrement failure
On Tue, Aug 23, 2011 at 9:35 AM, <a.azzol...@custom.it> wrote:
> IMy table has three primary key, autoincrement active and o
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
cussion of SQLite Database <sqlite-users@sqlite.org>
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?
Michae
: 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'
but rowid
,
Alessandro
From:
Richard Hipp <d...@sqlite.org>
To:
General Discussion of SQLite Database <sqlite-users@sqlite.org>
Date:
22/08/2011 17.40
Subject:
Re: [sqlite] Autoincrement failure
On Mon, Aug 22, 2011 at 11:25 AM, <a.azzol...@custom.it> wrote:
> schema 3
>
> PRAGM
t;
> > 37 identical rows(!) where Rowid = 1
> >
>
> What is your schema?
>
> If you run "PRAGMA integrity_check"?
>
>
> >
> >
> >
> > Alessandro
> >
> >
> >
> >
> > From:
> > a.azzol...@custom
t;d...@sqlite.org>
To:
General Discussion of SQLite Database <sqlite-users@sqlite.org>
Date:
22/08/2011 17.21
Subject:
Re: [sqlite] Autoincrement failure
On Mon, Aug 22, 2011 at 11:17 AM, <a.azzol...@custom.it> wrote:
> SELECT rowid FROM (mytable) WHERE (mystuff)
>
> re
ssandro
>
>
>
>
> From:
> a.azzol...@custom.it
> To:
> <sqlite-users@sqlite.org>
> Date:
> 22/08/2011 16.26
> Subject:
> Re: [sqlite] Autoincrement failure
>
>
>
> sqlite> .dump sqlite_sequence
> PRAGMA foreign_keys=OFF;
> BEGIN TRANSACTI
SELECT rowid FROM (mytable) WHERE (mystuff)
returns
37 identical rows(!) where Rowid = 1
Alessandro
From:
a.azzol...@custom.it
To:
<sqlite-users@sqlite.org>
Date:
22/08/2011 16.26
Subject:
Re: [sqlite] Autoincrement failure
sqlite> .dump sqlite_sequence
PRAGMA foreign
sqlite> .dump sqlite_sequence
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
COMMIT;
sqlite>
Any idea?
Thanks
Alessandro
From:
Richard Hipp <d...@sqlite.org>
To:
General Discussion of SQLite Database <sqlite-users@sqlite.org>
Date:
22/08/2011 16.11
Subject:
Re: [sqlite] Aut
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
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