Re: [sqlite] Corrupted database (image is malformed): always the same size

[Gianandrea Gobbo]

Max Vlasov ha scritto:
> On Fri, Dec 18, 2009 at 6:27 PM, Gianandrea Gobbo  wrote:
>
> Gianandrea, I once had an experience with fixing a modified code that led to
> database disk image malformation. If you can reproduce the bug with a
> comparatively few number of steps, I'd recommend running the program with
> checking PRAGMA integrity_check; almost on every step. It costs a little in
> terms of performance, but in my case it helped, a report about invalid Index
> entries was way ahead of this particular error so it helped to narrow it to
> several queries and finally to the invalid code fragment
> ___
>   

Unfortunately I'm not able to reproduce the error right now. The only 
informations I get are from the field, from the return boards. I will 
try to grab more data from the customers.
At this stage, I cannot think of an applicative bug that leads to this 
kind of corruption, where the database results always in the same size.
I'll try to reproduce the error, btw. I'll keep you informed.
Thanks again for the help.

g.


-- 


Gianandrea Gobbo
Sviluppo Software Prodotti
go...@solari.it
+39 0432 497 387

Solari di Udine Spa - via Gino Pieri, 29 - 33100 - Udine
Centralino: +39 0432 4971 - Fax +39 0432 480 160
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Corrupted database (image is malformed): always the same size

[Gianandrea Gobbo]

I'm using sqlite (2.8) on an embedded product, running a Linux kernel.
I'm experiencing sometimes a database corruption, and listing some 
tables contents gets me a "SQL error: database disk image is malformed".
Ok, there can be many reasons for this, but the strange thing that 
puzzles me is that the database file has always the same size: 409Kb 
(418816 bytes).
Normally, the file could grow up to 1.5 Megs, starting from 200 kb. This 
makes me thing that something may fail while sqlite expands the database 
size grows across this figure.
Any hint or suggestion what to look for?

Thanks in advance,
Gianandrea.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users