Re: [sqlite] Autoincrement failure

2011-08-26 Thread Black, Michael (IS)
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: [

Re: [sqlite] Autoincrement failure

2011-08-24 Thread Simon Slavin
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

Re: [sqlite] Autoincrement failure

2011-08-24 Thread A . Azzolini
: 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

Re: [sqlite] Autoincrement failure

2011-08-23 Thread Simon Slavin
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

Re: [sqlite] Autoincrement failure

2011-08-23 Thread Black, Michael (IS)
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

Re: [sqlite] Autoincrement failure

2011-08-23 Thread A . Azzolini
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

Re: [sqlite] Autoincrement failure

2011-08-23 Thread Black, Michael (IS)
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

Re: [sqlite] Autoincrement failure

2011-08-23 Thread A . Azzolini
; 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

Re: [sqlite] Autoincrement failure

2011-08-23 Thread Simon Slavin
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

Re: [sqlite] Autoincrement failure

2011-08-23 Thread Black, Michael (IS)
...@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

Re: [sqlite] Autoincrement failure

2011-08-23 Thread A . Azzolini
..@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

Re: [sqlite] Autoincrement failure

2011-08-23 Thread Richard Hipp
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

Re: [sqlite] Autoincrement failure

2011-08-23 Thread A . Azzolini
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

Re: [sqlite] Autoincrement failure

2011-08-23 Thread Black, Michael (IS)
: 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

Re: [sqlite] Autoincrement failure

2011-08-23 Thread A . Azzolini
, 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

Re: [sqlite] Autoincrement failure

2011-08-22 Thread Richard Hipp
t; > > 37 identical rows(!) where Rowid = 1 > > > > What is your schema? > > If you run "PRAGMA integrity_check"? > > > > > > > > > > Alessandro > > > > > > > > > > From: > > a.azzol...@custom

Re: [sqlite] Autoincrement failure

2011-08-22 Thread A . Azzolini
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

Re: [sqlite] Autoincrement failure

2011-08-22 Thread Richard Hipp
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

Re: [sqlite] Autoincrement failure

2011-08-22 Thread A . Azzolini
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

Re: [sqlite] Autoincrement failure

2011-08-22 Thread A . Azzolini
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

Re: [sqlite] Autoincrement failure

2011-08-22 Thread Richard Hipp
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

[sqlite] Autoincrement failure

2011-08-22 Thread A . Azzolini
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