My guess is you read blob data incorrectly. You get pointer to the data
from SQLite, but actually read the data when memory has been already reused
for other purposes.
Pavel
On Sunday, February 26, 2012, Patrik Nilsson <nipatriknils...@gmail.com>
wrote:
> Dear All,
>
> I have a table called page (defined below) and have noticed that the
> data-variable (blob) sometimes get corrupted. How do I set up a log to
> debug what is happening. What I want is a log file saved with my file,
> so I can backtrace the error.
>
> This is also to be able to send in a good bug report to the developers
> of SQLite.
>
> I don't know the exact steps to reproduce the error, but the following
> might give someone a clue:
>
> 1) Add rows (one by one) with data.
> 2) Update sortorder for the whole table with begin/commit
> 3) After these and maybe some other steps (i.e. updating a row's data
> with new data), I discover that a random row of the table has a
> corrupted data-blob.
>
> I have made a verify function for the whole table of the data-blobs. The
> data-blob can contain images varying in size from a few hundred bytes to
> some (about 5) megabytes of images. (Currently only png-images.)
>
> Best regards,
> Patrik
>
>
> create table if not exists page ( id integer primary key autoincrement,
> type integer, sortorder integer, width integer, height integer, size
> integer, deleted integer default 0, zoom integer default 0, modified
> datetime default (datetime('now','localtime')), comment text, data blob )
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
