Re: [sqlite] I'm getting a compiler error on a SQLIte build on Ubuntu 16.04 (which surprises me)

2018-07-10 Thread Clemens Ladisch
Rob Willett wrote: > I removed two instances of -O2 from the Makefile and, lo and behold, it > compiles. > > Sadly my database to check is approx 80GB which could be interesting. The bottleneck is I/O speed; it does not matter whether sqlite3_analyzer uses ten or twenty microseconds before

Re: [sqlite] I'm getting a compiler error on a SQLIte build on Ubuntu 16.04 (which surprises me)

2018-07-10 Thread David Burgess
> It works without -O2, do you have optimisations left on? -fPIC -O2 -Wall -Wextra -pedantic ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] I'm getting a compiler error on a SQLIte build on Ubuntu 16.04 (which surprises me)

2018-07-10 Thread Rob Willett
David, Thanks for the reply. We have the latest build-essential root@preprod1:/jambuster/src/sqlite-src-324/tool# apt-get install build-essential Reading package lists... Done Building dependency tree Reading state information... Done build-essential is already the newest version

Re: [sqlite] I'm getting a compiler error on a SQLIte build on Ubuntu 16.04 (which surprises me)

2018-07-10 Thread Rob Willett
Dan, Many thanks for this. I removed two instances of -O2 from the Makefile and, lo and behold, it compiles. Sadly my database to check is approx 80GB which could be interesting. However I'll take a working (but slower) program over a faster (but not working) application every time :) Rob

Re: [sqlite] I'm getting a compiler error on a SQLIte build on Ubuntu 16.04 (which surprises me)

2018-07-09 Thread David Burgess
I'm using gcc (Ubuntu 5.4.0-6ubuntu1~16.04.10) 5.4.0 20160609 on 64 bit. I have built both 64 and 32 bit versions from sqlite-src-324 No problems. Check your build-essential install? On Tue, Jul 10, 2018 at 1:05 AM, Dan Kennedy wrote: > On 07/09/2018 09:26 PM, Rob Willett wrote: >> >>

Re: [sqlite] I'm getting a compiler error on a SQLIte build on Ubuntu 16.04 (which surprises me)

2018-07-09 Thread Dan Kennedy
On 07/09/2018 09:26 PM, Rob Willett wrote: Dan, Thanks for the information. We did try that first, failed and just assumed we were idiots and went to the the other download. Just downloaded it again, so we can check and be on the safe side, and we get the same issue. cp

Re: [sqlite] I'm getting a compiler error on a SQLIte build on Ubuntu 16.04 (which surprises me)

2018-07-09 Thread Rob Willett
Dan, Thanks for the information. We did try that first, failed and just assumed we were idiots and went to the the other download. Just downloaded it again, so we can check and be on the safe side, and we get the same issue. cp /jambuster/src/sqlite-src-324/ext/session/sqlite3session.h

Re: [sqlite] I'm getting a compiler error on a SQLIte build on Ubuntu 16.04 (which surprises me)

2018-07-09 Thread Dan Kennedy
On 07/09/2018 03:56 PM, rob.sql...@robertwillett.com wrote: Hi I'm trying to build the SQLite packages from the source. I **only** want it to get a copy of sqlite_analyse which for some reason doesn't appear to be easily available as a compiled option. The download package doesn't work on

Re: [sqlite] I'm getting a compiler error on a SQLIte build on Ubuntu 16.04 (which surprises me)

2018-07-09 Thread Rob Willett
Clemens, Thanks. We were up to date anyway, but we did check and we still get the same error. It does look like a compiler bug, also nobody else seems to have reported it, which I think is very odd. I cannot be the first person to compile this version of SQLite on Ubuntu 16.04 server.

Re: [sqlite] I'm getting a compiler error on a SQLIte build on Ubuntu 16.04 (which surprises me)

2018-07-09 Thread Clemens Ladisch
rob.sql...@robertwillett.com wrote: > gcc: internal compiler error: Killed (program cc1) This is a compiler bug. Check if updating gcc to a current version helps. > Please submit a full bug report, > with preprocessed source if appropriate. > See for instructions. Otherwise, do this.