Hello, On Fri, Jun 3, 2011 at 00:08, Rense Corten <rcor...@gmail.com> wrote: [...] > So I searched the archives of this list and found two threads on this: > > http://www.mail-archive.com/sqlite-users@sqlite.org/msg51574.html > http://www.mail-archive.com/sqlite-users@sqlite.org/msg48649.html > > The first thread got no answers, but the second suggest to either > split the file or recompile sqlite3 with the option for large file > support . Now I had understood that since version 3.5.9 large file > support is switched on by default so that should not be the problem > (http://www.sqlite.org/changes.html). Splitting the file, however, > seems to solve the problem. I would prefer not to have to split the > file first. > > Any ideas on what causes this problem?
It's what the thread says. The SQLite shell on Ubuntu (on 11.04) isn't compiled with large file support on 32-bit systems, so while the SQLite library does work with 64-bit database, the shell doesn't. The easy solution is to either use a 64-bit Ubuntu system or compile the shell yourself with large file support. To compile it, download the sqlite amalgamation files and run: gcc -o sqli -O3 -DNDEBUG=1 -D_FILE_OFFSET_BITS=64 sqlite3.c shell.c -ldl -pthread The resulting binary (sqli) will be compiled with large file support (I verified it was using strace). Regards, ~Nuno Lucas P.S.- While this could be considered an Ubuntu bug, the truth is that the linux shell binary on the sqlite site also isn't compiled with large file support, so I would consider this an SQLite bug. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
