Hello! I am currently integrating sqlite 3.7.3 into my application running on an embedded PowerPC-based Linux 2.6.
I have the reproducable situation that I get the database file gets corrupted. Here is the list of operations: sqlite3_open (new database file is created) sqlite3_exec: create tables, indices, ... sqlite3_exec: a few inserts sqlite3_prepare_v2, sqlite3_step, sqlite_column_*, ...: to read data Until I close the database I can successfully insert/delete/select rows sqlite3_close sqlite3_open (existing file is opened) The only operation which works is reading data sqlite3_prepare_v2, sqlite3_step, sqlite_column_*, ...: to read data All insert or delete operations result in the "database disk image is malformed" message and I can not open the file with sqlite3 either (reports "Error: unsupported file format"). At this time it is also not possible to do a "pragma integrity_check". If I try to reproduce this sequence using sqlite3 the problem does not occur (qed). journal mode is default and there is no other file (journal, ...) than the specified databasefile. Using the same code under Windows 7 (VS2008) everything works fine. I have no idea where to look Do you have any ideas? Thanks in advance Michael Steiger _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
