On 2014/04/07 16:44, Richard Hipp wrote:
On Mon, Apr 7, 2014 at 10:41 AM, Alejandro Santos <lis...@alejolp.com>wrote:
On Mon, Apr 7, 2014 at 3:32 PM, Alejandro Santos <lis...@alejolp.com>
wrote:
Changing the journal_mode does not solve my issue :(
A self contained test case:
$ LD_LIBRARY_PATH= ./sqlite3 /tmp/broken2.sqlite
SQLite version 3.8.4.3 2014-04-03 16:53:12
Enter ".help" for usage hints.
sqlite> PRAGMA page_size=65536;
Support for 64K page sizes was added in 3.7.1. Reduce the page size to 32K
and you should be fine.
Also, shouldn't the OP VACUUM or something after those pragmas for the changes
to take effect considering the file is pre-existing?
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
