On 10/6/09 15:47 , Simon Slavin slav...@hearsay.demon.co.uk wrote:
On 5 Oct 2009, at 2:59pm, Reusche, Andrew wrote:
There are very many problems associated with synchronising two copies
of the same database. I'm serious: entire books are written about
just this one subject.
I am
When I run pragma synchronous I receive a 2. Documentation says this
is the value for Full synchronous mode. I've checked this using the
routine through our application, and also using sqlite3.exe. This is on
a w32 system, if it matters.
We experienced another corruption issue with the DB.
On 6 Oct 2009, at 6:19pm, Reusche, Andrew wrote:
We experienced another corruption issue with the DB. Details below.
When we tried to write to this DB, we received the malformed image
error. Sorry I don't have the exact text. We have now received 4
problems with the database in 1000
Thanks. We are beyond the point of recovering data at this point, we
will just start over with a fresh db. Two questions pertaining to what
may have caused this:
1) We are trying to programmatically update the primary keys on this
table, in order to sync it up with a remote database. In the
On Oct 5, 2009, at 9:59 AM, Reusche, Andrew wrote:
Thanks. We are beyond the point of recovering data at this point, we
will just start over with a fresh db. Two questions pertaining to
what
may have caused this:
1) We are trying to programmatically update the primary keys on this
On Oct 6, 2009, at 1:19 PM, Reusche, Andrew wrote:
When I run pragma synchronous I receive a 2. Documentation says this
is the value for Full synchronous mode. I've checked this using the
routine through our application, and also using sqlite3.exe. This
is on
a w32 system, if it
On 5 Oct 2009, at 2:59pm, Reusche, Andrew wrote:
We are trying to programmatically update the primary keys on this
table, in order to sync it up with a remote database. In the event
that
this needs to occur, we typically need to take a chunk of records in
this table, and increment all
On Oct 5, 2009, at 9:01 AM, Reusche, Andrew wrote:
The sales table is the table in question. Sorry it took so long to
respond, apparently sqlite.org gets flagged as spam.
On Oct 2, 2009, at 9:13 AM, Reusche, Andrew wrote:
I run reindex. Then another integrity_check:
sqlite pragma