On 25 Feb 2015, at 8:23pm, Dave Dyer <ddyer-sqlite at real-me.net> wrote:
> The facile explanation would be that a transaction to insert a new
> record was executed twice, but the indexes were incorrectly maintained.
>
> INSERT INTO "preference_table" VALUES('Picture Placer-707-1304b-19-Maranda
> Richardson','scrollPos','0');
Can you provide the schema (the CREATE TABLE and any CREATE INDEX commands) for
that table ?
Do you have any multi-access things going on ? Two or more computers,
applications, processes or threads trying to access the database at the same
time ?
Does your application check the result code returned from all sqlite3_ calls ?
Not just the ones inserting rows, but also those opening and closing the file,
setting PRAGMAs, or anything else it does with the sqlite3_ library ?
Simon.
