Just to report back on this issue: recompiling as per Nuno's instructions indeed solved the problem. Still, if anyone can explain to me why the original executable would work without problems on a different machine, I would be grateful.
> > On Fri, Jun 3, 2011 at 10:28 AM, Rense Corten <rcor...@gmail.com> wrote: >> Thanks for your answer, Nuno. >> However, the system I am using is already 64-bit (I should have >> mentioned that) , and the same binary can do the job on another Ubuntu >> 64-bit system. I'll try your suggestion nevertheless, but can there >> be other causes? >> Rense >> >>> 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