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. > sqlite> PRAGMA legacy_file_format=ON; > sqlite> PRAGMA synchronous = OFF; > sqlite> PRAGMA journal_mode=DELETE; > delete > sqlite> CREATE TABLE IF NOT EXISTS mytable ( > ...> my_id INTEGER PRIMARY KEY, > ...> my_name TEXT, > ...> CONSTRAINT part_name_idx UNIQUE (my_name)); > sqlite> > > $ LD_LIBRARY_PATH= sqlite3 /tmp/broken2.sqlite > SQLite version 3.6.20 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> .schema > Error: file is encrypted or is not a database > > And here it is the gziped+base64ed broken2.sqlite file: > > http://pastebin.com/Tk6Nvxv7 > > Thank you, > > -- > Alejandro Santos > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
