Hi,
I have developed an application which is using sqlite database for querying
data from the database which ships with it. Several days ago the database
somehow got corrupted.
The application is only issuing select statements (no insert/update/delete
or vacuum) so I cannot understand what could
Thanks.
I have found that the select statement was issued inside a transaction.
Could this cause sqlite to make changes to the database? I also observed
that if I mark the database as readonly and issue a select statement inside
a transaction (what the application was doing) I get "attempt to writ
On 9 Apr 2011, at 02:47 PM, giorgi giorgi wrote:
> The application is only issuing select statements (no insert/update/delete
> or vacuum) so I cannot understand what could have caused database
> corruption.
Almost definitely a problem with your hardware, or possibly an operating-system
glitch.
Thanks.
I have found that the select statement was issued inside a transaction.
Could this cause sqlite to make changes to the database? I also observed
that if I mark the database as readonly and issue a select statement inside
a transaction (what the application was doing) I get "attempt to
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 04/10/2011 07:58 AM, mcnamaragio wrote:
> Could this have caused database corruption?
SQLite does not have ordinary commands that will corrupt the database. How
to corrupt the database is listed in the doc:
http://www.sqlite.org/lockingv3.html
5 matches
Mail list logo