Re: [sqlite] I'm getting a compiler error on a SQLIte build on Ubuntu 16.04 (which surprises me)
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 waiting for the next batch of data from the disk. There will be no noticeable difference. Regards, Clemens ___ 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)
> 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)
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 (12.1ubuntu2). build-essential set to manually installed. The following package was automatically installed and is no longer required: libllvm5.0 Use 'apt autoremove' to remove it. 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. Indeed we have the same gcc version gcc (Ubuntu 5.4.0-6ubuntu1~16.04.10) 5.4.0 20160609 It works without -O2, do you have optimisations left on? Rob On 10 Jul 2018, at 2:18, David Burgess wrote: 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: 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 . ./libtool --mode=compile --tag=CC gcc -g -O2 -DSQLITE_OS_UNIX=1 -I. -I/jambuster/src/sqlite-src-324/src -I/jambuster/src/sqlite-src-324/ext/rtree -I/jambuster/src/sqlite-src-324/ext/icu -I/jambuster/src/sqlite-src-324/ext/fts3 -I/jambuster/src/sqlite-src-324/ext/async -I/jambuster/src/sqlite-src-324/ext/session -D_HAVE_SQLITE_CONFIG_H -DBUILD_sqlite -DNDEBUG -I/usr/include/tcl8.6 -DSQLITE_THREADSAFE=1 -DSQLITE_HAVE_ZLIB=1 -DSQLITE_TEMP_STORE=1 -c sqlite3.c libtool: compile: gcc -g -O2 -DSQLITE_OS_UNIX=1 -I. -I/jambuster/src/sqlite-src-324/src -I/jambuster/src/sqlite-src-324/ext/rtree -I/jambuster/src/sqlite-src-324/ext/icu -I/jambuster/src/sqlite-src-324/ext/fts3 -I/jambuster/src/sqlite-src-324/ext/async -I/jambuster/src/sqlite-src-324/ext/session -D_HAVE_SQLITE_CONFIG_H -DBUILD_sqlite -DNDEBUG -I/usr/include/tcl8.6 -DSQLITE_THREADSAFE=1 -DSQLITE_HAVE_ZLIB=1 -DSQLITE_TEMP_STORE=1 -c sqlite3.c -fPIC -DPIC -o .libs/sqlite3.o gcc: internal compiler error: Killed (program cc1) Please submit a full bug report, with preprocessed source if appropriate. See for instructions. Makefile:715: recipe for target 'sqlite3.lo' failed ./configure seems OK, tcl looks OK (which was our worry), we think there is a genuine bug in the compiler. . We still need the sql_analyzer program as well :) Its one of those days, I have bad compilers and the UK government could fall. After running [./configure], open the generated Makefile and remove all the "-O2" switches you can find. Then run [make sqlite3_analyzer]. You'll get an un-optimized binary of course, but there's a good chance this will bypass the compiler bug. And it won't make much difference unless your databases are really big. Dan. Rob On 9 Jul 2018, at 15:02, Dan Kennedy wrote: 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 Ubuntu 16.04 and as far as we can see, there are no other downloadable binaries that don't come from China. For some reason, I don't really want to download something from Beijing The Linux binaries on sqlite.org are for 32-bit systems. For them to work on Ubuntu 16.04, you probably need to install multiarch support. Or, to build sqlite3_analyzer from source you need the full source distribution: https://www.sqlite.org/2018/sqlite-src-324.zip Dan. The full steps I followed are at the very bottom of this e-mail. They are a direct copy from my terminal output. **TLDR Summary** 1. OS is a reasonably fresh (< 4 weeks old) Ubuntu 16.04 LTS Server running under OpenVZ on a commercial ISP. It's patched to the current levels. I don't think this is a problem as we don't have any other issues but... 2. SQLite3 is already installed as the normal (and older) SQLIte that is distributed with Ubuntu 16.04 LTS 3. gcc is installed. I have created a small C program to test that it can compile (Hello World) and it's fine. (gcc (Ubuntu 5.4.0-6ubuntu1~16.04.10) 5.4.0 20160609) 4. Downloaded https://www.sqlite.org/2018/sqlite-autoconf-324.tar.gz through wget. 5. Checked the sha1sum and it matches the sqlite page. 6. Untarred the file into it's own directory 7. cd'ed to directory and ran ./configure. 8. Checked output of configure and nothing seemed wrong. Details are below. 9. Ran make and get a compiler failure! (see below). I'm gobsmacked that the compiler has failed to be honest.
Re: [sqlite] I'm getting a compiler error on a SQLIte build on Ubuntu 16.04 (which surprises me)
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 On 9 Jul 2018, at 16:05, Dan Kennedy wrote: 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 /jambuster/src/sqlite-src-324/ext/session/sqlite3session.h . ./libtool --mode=compile --tag=CC gcc -g -O2 -DSQLITE_OS_UNIX=1 -I. -I/jambuster/src/sqlite-src-324/src -I/jambuster/src/sqlite-src-324/ext/rtree -I/jambuster/src/sqlite-src-324/ext/icu -I/jambuster/src/sqlite-src-324/ext/fts3 -I/jambuster/src/sqlite-src-324/ext/async -I/jambuster/src/sqlite-src-324/ext/session -D_HAVE_SQLITE_CONFIG_H -DBUILD_sqlite -DNDEBUG -I/usr/include/tcl8.6 -DSQLITE_THREADSAFE=1 -DSQLITE_HAVE_ZLIB=1 -DSQLITE_TEMP_STORE=1 -c sqlite3.c libtool: compile: gcc -g -O2 -DSQLITE_OS_UNIX=1 -I. -I/jambuster/src/sqlite-src-324/src -I/jambuster/src/sqlite-src-324/ext/rtree -I/jambuster/src/sqlite-src-324/ext/icu -I/jambuster/src/sqlite-src-324/ext/fts3 -I/jambuster/src/sqlite-src-324/ext/async -I/jambuster/src/sqlite-src-324/ext/session -D_HAVE_SQLITE_CONFIG_H -DBUILD_sqlite -DNDEBUG -I/usr/include/tcl8.6 -DSQLITE_THREADSAFE=1 -DSQLITE_HAVE_ZLIB=1 -DSQLITE_TEMP_STORE=1 -c sqlite3.c -fPIC -DPIC -o .libs/sqlite3.o gcc: internal compiler error: Killed (program cc1) Please submit a full bug report, with preprocessed source if appropriate. See for instructions. Makefile:715: recipe for target 'sqlite3.lo' failed ./configure seems OK, tcl looks OK (which was our worry), we think there is a genuine bug in the compiler. . We still need the sql_analyzer program as well :) Its one of those days, I have bad compilers and the UK government could fall. After running [./configure], open the generated Makefile and remove all the "-O2" switches you can find. Then run [make sqlite3_analyzer]. You'll get an un-optimized binary of course, but there's a good chance this will bypass the compiler bug. And it won't make much difference unless your databases are really big. Dan. Rob On 9 Jul 2018, at 15:02, Dan Kennedy wrote: 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 Ubuntu 16.04 and as far as we can see, there are no other downloadable binaries that don't come from China. For some reason, I don't really want to download something from Beijing The Linux binaries on sqlite.org are for 32-bit systems. For them to work on Ubuntu 16.04, you probably need to install multiarch support. Or, to build sqlite3_analyzer from source you need the full source distribution: https://www.sqlite.org/2018/sqlite-src-324.zip Dan. The full steps I followed are at the very bottom of this e-mail. They are a direct copy from my terminal output. **TLDR Summary** 1. OS is a reasonably fresh (< 4 weeks old) Ubuntu 16.04 LTS Server running under OpenVZ on a commercial ISP. It's patched to the current levels. I don't think this is a problem as we don't have any other issues but... 2. SQLite3 is already installed as the normal (and older) SQLIte that is distributed with Ubuntu 16.04 LTS 3. gcc is installed. I have created a small C program to test that it can compile (Hello World) and it's fine. (gcc (Ubuntu 5.4.0-6ubuntu1~16.04.10) 5.4.0 20160609) 4. Downloaded https://www.sqlite.org/2018/sqlite-autoconf-324.tar.gz through wget. 5. Checked the sha1sum and it matches the sqlite page. 6. Untarred the file into it's own directory 7. cd'ed to directory and ran ./configure. 8. Checked output of configure and nothing seemed wrong. Details are below. 9. Ran make and get a compiler failure! (see below). I'm gobsmacked that the compiler has failed to be honest. So my first assumption is that we have cocked up something. However we've googled and checked and can't see anybody with a similar issue. I suspect that one of the Define statements is not playing nicely but not wholly sure which one OR we are missing a package that needs to be installed, e.g. TCL x,y or z. root@preprod1:/jambuster/src/sqlite/sqlite-autoconf-324# make /bin/bash ./libtool --tag=CC --mode=compile gcc -DPACKAGE_NAME=\"sqlite\" -DPACKAGE_TARNAME=\"sqlite\" -DPACKAGE_VERSION=\"3.24.0\" -DPACKAGE_STRING=\"sqlite\ 3.24.0\" -DPACKAGE_BUGREPORT=\"http://www.sqlite.org\"; -DPACKAGE_URL=\"\" -DPACK
Re: [sqlite] I'm getting a compiler error on a SQLIte build on Ubuntu 16.04 (which surprises me)
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: >> >> 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 . >> ./libtool --mode=compile --tag=CC gcc -g -O2 -DSQLITE_OS_UNIX=1 -I. >> -I/jambuster/src/sqlite-src-324/src >> -I/jambuster/src/sqlite-src-324/ext/rtree >> -I/jambuster/src/sqlite-src-324/ext/icu >> -I/jambuster/src/sqlite-src-324/ext/fts3 >> -I/jambuster/src/sqlite-src-324/ext/async >> -I/jambuster/src/sqlite-src-324/ext/session -D_HAVE_SQLITE_CONFIG_H >> -DBUILD_sqlite -DNDEBUG -I/usr/include/tcl8.6 -DSQLITE_THREADSAFE=1 >> -DSQLITE_HAVE_ZLIB=1 -DSQLITE_TEMP_STORE=1 -c sqlite3.c >> libtool: compile: gcc -g -O2 -DSQLITE_OS_UNIX=1 -I. >> -I/jambuster/src/sqlite-src-324/src >> -I/jambuster/src/sqlite-src-324/ext/rtree >> -I/jambuster/src/sqlite-src-324/ext/icu >> -I/jambuster/src/sqlite-src-324/ext/fts3 >> -I/jambuster/src/sqlite-src-324/ext/async >> -I/jambuster/src/sqlite-src-324/ext/session -D_HAVE_SQLITE_CONFIG_H >> -DBUILD_sqlite -DNDEBUG -I/usr/include/tcl8.6 -DSQLITE_THREADSAFE=1 >> -DSQLITE_HAVE_ZLIB=1 -DSQLITE_TEMP_STORE=1 -c sqlite3.c -fPIC -DPIC -o >> .libs/sqlite3.o >> gcc: internal compiler error: Killed (program cc1) >> Please submit a full bug report, >> with preprocessed source if appropriate. >> See for instructions. >> Makefile:715: recipe for target 'sqlite3.lo' failed >> >> ./configure seems OK, tcl looks OK (which was our worry), we think there >> is a genuine bug in the compiler. . We still need the sql_analyzer >> program as well :) Its one of those days, I have bad compilers and the UK >> government could fall. > > > > After running [./configure], open the generated Makefile and remove all the > "-O2" switches you can find. Then run [make sqlite3_analyzer]. > > You'll get an un-optimized binary of course, but there's a good chance this > will bypass the compiler bug. And it won't make much difference unless your > databases are really big. > > Dan. > > > > > > > >> >> Rob >> >> On 9 Jul 2018, at 15:02, Dan Kennedy wrote: >> >>> 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 Ubuntu 16.04 and as far as we can see, there are no other downloadable binaries that don't come from China. For some reason, I don't really want to download something from Beijing >>> >>> >>> The Linux binaries on sqlite.org are for 32-bit systems. For them to work >>> on Ubuntu 16.04, you probably need to install multiarch support. >>> >>> Or, to build sqlite3_analyzer from source you need the full source >>> distribution: >>> >>> https://www.sqlite.org/2018/sqlite-src-324.zip >>> >>> Dan. >>> >>> >>> The full steps I followed are at the very bottom of this e-mail. They are a direct copy from my terminal output. **TLDR Summary** 1. OS is a reasonably fresh (< 4 weeks old) Ubuntu 16.04 LTS Server running under OpenVZ on a commercial ISP. It's patched to the current levels. I don't think this is a problem as we don't have any other issues but... 2. SQLite3 is already installed as the normal (and older) SQLIte that is distributed with Ubuntu 16.04 LTS 3. gcc is installed. I have created a small C program to test that it can compile (Hello World) and it's fine. (gcc (Ubuntu 5.4.0-6ubuntu1~16.04.10) 5.4.0 20160609) 4. Downloaded https://www.sqlite.org/2018/sqlite-autoconf-324.tar.gz through wget. 5. Checked the sha1sum and it matches the sqlite page. 6. Untarred the file into it's own directory 7. cd'ed to directory and ran ./configure. 8. Checked output of configure and nothing seemed wrong. Details are below. 9. Ran make and get a compiler failure! (see below). I'm gobsmacked that the compiler has failed to be honest. So my first assumption is that we have cocked up something. However we've googled and checked and can't see anybody with a similar issue. I suspect that one of the Define statements is not playing nicely but not wholly sure which one OR we are missing a package that needs to be installed, e.g. TCL x,y or z. root@preprod1:/jambuster/src/sqlite
Re: [sqlite] I'm getting a compiler error on a SQLIte build on Ubuntu 16.04 (which surprises me)
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 /jambuster/src/sqlite-src-324/ext/session/sqlite3session.h . ./libtool --mode=compile --tag=CC gcc -g -O2 -DSQLITE_OS_UNIX=1 -I. -I/jambuster/src/sqlite-src-324/src -I/jambuster/src/sqlite-src-324/ext/rtree -I/jambuster/src/sqlite-src-324/ext/icu -I/jambuster/src/sqlite-src-324/ext/fts3 -I/jambuster/src/sqlite-src-324/ext/async -I/jambuster/src/sqlite-src-324/ext/session -D_HAVE_SQLITE_CONFIG_H -DBUILD_sqlite -DNDEBUG -I/usr/include/tcl8.6 -DSQLITE_THREADSAFE=1 -DSQLITE_HAVE_ZLIB=1 -DSQLITE_TEMP_STORE=1 -c sqlite3.c libtool: compile: gcc -g -O2 -DSQLITE_OS_UNIX=1 -I. -I/jambuster/src/sqlite-src-324/src -I/jambuster/src/sqlite-src-324/ext/rtree -I/jambuster/src/sqlite-src-324/ext/icu -I/jambuster/src/sqlite-src-324/ext/fts3 -I/jambuster/src/sqlite-src-324/ext/async -I/jambuster/src/sqlite-src-324/ext/session -D_HAVE_SQLITE_CONFIG_H -DBUILD_sqlite -DNDEBUG -I/usr/include/tcl8.6 -DSQLITE_THREADSAFE=1 -DSQLITE_HAVE_ZLIB=1 -DSQLITE_TEMP_STORE=1 -c sqlite3.c -fPIC -DPIC -o .libs/sqlite3.o gcc: internal compiler error: Killed (program cc1) Please submit a full bug report, with preprocessed source if appropriate. See for instructions. Makefile:715: recipe for target 'sqlite3.lo' failed ./configure seems OK, tcl looks OK (which was our worry), we think there is a genuine bug in the compiler. . We still need the sql_analyzer program as well :) Its one of those days, I have bad compilers and the UK government could fall. After running [./configure], open the generated Makefile and remove all the "-O2" switches you can find. Then run [make sqlite3_analyzer]. You'll get an un-optimized binary of course, but there's a good chance this will bypass the compiler bug. And it won't make much difference unless your databases are really big. Dan. Rob On 9 Jul 2018, at 15:02, Dan Kennedy wrote: 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 Ubuntu 16.04 and as far as we can see, there are no other downloadable binaries that don't come from China. For some reason, I don't really want to download something from Beijing The Linux binaries on sqlite.org are for 32-bit systems. For them to work on Ubuntu 16.04, you probably need to install multiarch support. Or, to build sqlite3_analyzer from source you need the full source distribution: https://www.sqlite.org/2018/sqlite-src-324.zip Dan. The full steps I followed are at the very bottom of this e-mail. They are a direct copy from my terminal output. **TLDR Summary** 1. OS is a reasonably fresh (< 4 weeks old) Ubuntu 16.04 LTS Server running under OpenVZ on a commercial ISP. It's patched to the current levels. I don't think this is a problem as we don't have any other issues but... 2. SQLite3 is already installed as the normal (and older) SQLIte that is distributed with Ubuntu 16.04 LTS 3. gcc is installed. I have created a small C program to test that it can compile (Hello World) and it's fine. (gcc (Ubuntu 5.4.0-6ubuntu1~16.04.10) 5.4.0 20160609) 4. Downloaded https://www.sqlite.org/2018/sqlite-autoconf-324.tar.gz through wget. 5. Checked the sha1sum and it matches the sqlite page. 6. Untarred the file into it's own directory 7. cd'ed to directory and ran ./configure. 8. Checked output of configure and nothing seemed wrong. Details are below. 9. Ran make and get a compiler failure! (see below). I'm gobsmacked that the compiler has failed to be honest. So my first assumption is that we have cocked up something. However we've googled and checked and can't see anybody with a similar issue. I suspect that one of the Define statements is not playing nicely but not wholly sure which one OR we are missing a package that needs to be installed, e.g. TCL x,y or z. root@preprod1:/jambuster/src/sqlite/sqlite-autoconf-324# make /bin/bash ./libtool --tag=CC --mode=compile gcc -DPACKAGE_NAME=\"sqlite\" -DPACKAGE_TARNAME=\"sqlite\" -DPACKAGE_VERSION=\"3.24.0\" -DPACKAGE_STRING=\"sqlite\ 3.24.0\" -DPACKAGE_BUGREPORT=\"http://www.sqlite.org\"; -DPACKAGE_URL=\"\" -DPACKAGE=\"sqlite\" -DVERSION=\"3.24.0\" -DSTDC_HEADERS=1 -DHAVE_SYS_TYPES_H=1 -DHAVE_SYS_STAT_H=1 -DHAVE_STDLIB_H=1 -DHAVE_STRING_H=1 -DHAVE_MEMORY_H=1 -DHAVE_STRINGS_H=1 -DHAVE_INTTYPES_H=1 -DHAVE_STDINT_H=1 -DHAVE_UNISTD_H=1 -DHAVE_DLFCN_H=1 -DLT_OBJDIR=\".libs/\" -DHAVE_FDATASYNC=1 -DHAVE_USLEEP=1 -DHAVE_LOCALTIME_R=1 -DHAVE_GMTIME_R=1 -DH
Re: [sqlite] I'm getting a compiler error on a SQLIte build on Ubuntu 16.04 (which surprises me)
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 . ./libtool --mode=compile --tag=CC gcc -g -O2 -DSQLITE_OS_UNIX=1 -I. -I/jambuster/src/sqlite-src-324/src -I/jambuster/src/sqlite-src-324/ext/rtree -I/jambuster/src/sqlite-src-324/ext/icu -I/jambuster/src/sqlite-src-324/ext/fts3 -I/jambuster/src/sqlite-src-324/ext/async -I/jambuster/src/sqlite-src-324/ext/session -D_HAVE_SQLITE_CONFIG_H -DBUILD_sqlite -DNDEBUG -I/usr/include/tcl8.6 -DSQLITE_THREADSAFE=1 -DSQLITE_HAVE_ZLIB=1 -DSQLITE_TEMP_STORE=1 -c sqlite3.c libtool: compile: gcc -g -O2 -DSQLITE_OS_UNIX=1 -I. -I/jambuster/src/sqlite-src-324/src -I/jambuster/src/sqlite-src-324/ext/rtree -I/jambuster/src/sqlite-src-324/ext/icu -I/jambuster/src/sqlite-src-324/ext/fts3 -I/jambuster/src/sqlite-src-324/ext/async -I/jambuster/src/sqlite-src-324/ext/session -D_HAVE_SQLITE_CONFIG_H -DBUILD_sqlite -DNDEBUG -I/usr/include/tcl8.6 -DSQLITE_THREADSAFE=1 -DSQLITE_HAVE_ZLIB=1 -DSQLITE_TEMP_STORE=1 -c sqlite3.c -fPIC -DPIC -o .libs/sqlite3.o gcc: internal compiler error: Killed (program cc1) Please submit a full bug report, with preprocessed source if appropriate. See for instructions. Makefile:715: recipe for target 'sqlite3.lo' failed ./configure seems OK, tcl looks OK (which was our worry), we think there is a genuine bug in the compiler. . We still need the sql_analyzer program as well :) Its one of those days, I have bad compilers and the UK government could fall. Rob On 9 Jul 2018, at 15:02, Dan Kennedy wrote: 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 Ubuntu 16.04 and as far as we can see, there are no other downloadable binaries that don't come from China. For some reason, I don't really want to download something from Beijing The Linux binaries on sqlite.org are for 32-bit systems. For them to work on Ubuntu 16.04, you probably need to install multiarch support. Or, to build sqlite3_analyzer from source you need the full source distribution: https://www.sqlite.org/2018/sqlite-src-324.zip Dan. The full steps I followed are at the very bottom of this e-mail. They are a direct copy from my terminal output. **TLDR Summary** 1. OS is a reasonably fresh (< 4 weeks old) Ubuntu 16.04 LTS Server running under OpenVZ on a commercial ISP. It's patched to the current levels. I don't think this is a problem as we don't have any other issues but... 2. SQLite3 is already installed as the normal (and older) SQLIte that is distributed with Ubuntu 16.04 LTS 3. gcc is installed. I have created a small C program to test that it can compile (Hello World) and it's fine. (gcc (Ubuntu 5.4.0-6ubuntu1~16.04.10) 5.4.0 20160609) 4. Downloaded https://www.sqlite.org/2018/sqlite-autoconf-324.tar.gz through wget. 5. Checked the sha1sum and it matches the sqlite page. 6. Untarred the file into it's own directory 7. cd'ed to directory and ran ./configure. 8. Checked output of configure and nothing seemed wrong. Details are below. 9. Ran make and get a compiler failure! (see below). I'm gobsmacked that the compiler has failed to be honest. So my first assumption is that we have cocked up something. However we've googled and checked and can't see anybody with a similar issue. I suspect that one of the Define statements is not playing nicely but not wholly sure which one OR we are missing a package that needs to be installed, e.g. TCL x,y or z. root@preprod1:/jambuster/src/sqlite/sqlite-autoconf-324# make /bin/bash ./libtool --tag=CC --mode=compile gcc -DPACKAGE_NAME=\"sqlite\" -DPACKAGE_TARNAME=\"sqlite\" -DPACKAGE_VERSION=\"3.24.0\" -DPACKAGE_STRING=\"sqlite\ 3.24.0\" -DPACKAGE_BUGREPORT=\"http://www.sqlite.org\"; -DPACKAGE_URL=\"\" -DPACKAGE=\"sqlite\" -DVERSION=\"3.24.0\" -DSTDC_HEADERS=1 -DHAVE_SYS_TYPES_H=1 -DHAVE_SYS_STAT_H=1 -DHAVE_STDLIB_H=1 -DHAVE_STRING_H=1 -DHAVE_MEMORY_H=1 -DHAVE_STRINGS_H=1 -DHAVE_INTTYPES_H=1 -DHAVE_STDINT_H=1 -DHAVE_UNISTD_H=1 -DHAVE_DLFCN_H=1 -DLT_OBJDIR=\".libs/\" -DHAVE_FDATASYNC=1 -DHAVE_USLEEP=1 -DHAVE_LOCALTIME_R=1 -DHAVE_GMTIME_R=1 -DHAVE_DECL_STRERROR_R=1 -DHAVE_STRERROR_R=1 -DHAVE_POSIX_FALLOCATE=1 -DHAVE_ZLIB_H=1 -I.-D_REENTRANT=1 -DSQLITE_THREADSAFE=1 -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_JSON1 -DSQLITE_HAVE_ZLIB -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_RTREE -g -O2 -MT sqlite3.lo -MD -MP -MF .deps/sqlite3.Tpo -c -o sqlite3.lo sqlite3.c libtool: compile: gcc -DPACKAGE_NAME=\"sqlite\" -DPACKAGE_TAR
Re: [sqlite] I'm getting a compiler error on a SQLIte build on Ubuntu 16.04 (which surprises me)
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 Ubuntu 16.04 and as far as we can see, there are no other downloadable binaries that don't come from China. For some reason, I don't really want to download something from Beijing The Linux binaries on sqlite.org are for 32-bit systems. For them to work on Ubuntu 16.04, you probably need to install multiarch support. Or, to build sqlite3_analyzer from source you need the full source distribution: https://www.sqlite.org/2018/sqlite-src-324.zip Dan. The full steps I followed are at the very bottom of this e-mail. They are a direct copy from my terminal output. **TLDR Summary** 1. OS is a reasonably fresh (< 4 weeks old) Ubuntu 16.04 LTS Server running under OpenVZ on a commercial ISP. It's patched to the current levels. I don't think this is a problem as we don't have any other issues but... 2. SQLite3 is already installed as the normal (and older) SQLIte that is distributed with Ubuntu 16.04 LTS 3. gcc is installed. I have created a small C program to test that it can compile (Hello World) and it's fine. (gcc (Ubuntu 5.4.0-6ubuntu1~16.04.10) 5.4.0 20160609) 4. Downloaded https://www.sqlite.org/2018/sqlite-autoconf-324.tar.gz through wget. 5. Checked the sha1sum and it matches the sqlite page. 6. Untarred the file into it's own directory 7. cd'ed to directory and ran ./configure. 8. Checked output of configure and nothing seemed wrong. Details are below. 9. Ran make and get a compiler failure! (see below). I'm gobsmacked that the compiler has failed to be honest. So my first assumption is that we have cocked up something. However we've googled and checked and can't see anybody with a similar issue. I suspect that one of the Define statements is not playing nicely but not wholly sure which one OR we are missing a package that needs to be installed, e.g. TCL x,y or z. root@preprod1:/jambuster/src/sqlite/sqlite-autoconf-324# make /bin/bash ./libtool --tag=CC --mode=compile gcc -DPACKAGE_NAME=\"sqlite\" -DPACKAGE_TARNAME=\"sqlite\" -DPACKAGE_VERSION=\"3.24.0\" -DPACKAGE_STRING=\"sqlite\ 3.24.0\" -DPACKAGE_BUGREPORT=\"http://www.sqlite.org\"; -DPACKAGE_URL=\"\" -DPACKAGE=\"sqlite\" -DVERSION=\"3.24.0\" -DSTDC_HEADERS=1 -DHAVE_SYS_TYPES_H=1 -DHAVE_SYS_STAT_H=1 -DHAVE_STDLIB_H=1 -DHAVE_STRING_H=1 -DHAVE_MEMORY_H=1 -DHAVE_STRINGS_H=1 -DHAVE_INTTYPES_H=1 -DHAVE_STDINT_H=1 -DHAVE_UNISTD_H=1 -DHAVE_DLFCN_H=1 -DLT_OBJDIR=\".libs/\" -DHAVE_FDATASYNC=1 -DHAVE_USLEEP=1 -DHAVE_LOCALTIME_R=1 -DHAVE_GMTIME_R=1 -DHAVE_DECL_STRERROR_R=1 -DHAVE_STRERROR_R=1 -DHAVE_POSIX_FALLOCATE=1 -DHAVE_ZLIB_H=1 -I.-D_REENTRANT=1 -DSQLITE_THREADSAFE=1 -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_JSON1 -DSQLITE_HAVE_ZLIB -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_RTREE -g -O2 -MT sqlite3.lo -MD -MP -MF .deps/sqlite3.Tpo -c -o sqlite3.lo sqlite3.c libtool: compile: gcc -DPACKAGE_NAME=\"sqlite\" -DPACKAGE_TARNAME=\"sqlite\" -DPACKAGE_VERSION=\"3.24.0\" "-DPACKAGE_STRING=\"sqlite 3.24.0\"" -DPACKAGE_BUGREPORT=\"http://www.sqlite.org\"; -DPACKAGE_URL=\"\" -DPACKAGE=\"sqlite\" -DVERSION=\"3.24.0\" -DSTDC_HEADERS=1 -DHAVE_SYS_TYPES_H=1 -DHAVE_SYS_STAT_H=1 -DHAVE_STDLIB_H=1 -DHAVE_STRING_H=1 -DHAVE_MEMORY_H=1 -DHAVE_STRINGS_H=1 -DHAVE_INTTYPES_H=1 -DHAVE_STDINT_H=1 -DHAVE_UNISTD_H=1 -DHAVE_DLFCN_H=1 -DLT_OBJDIR=\".libs/\" -DHAVE_FDATASYNC=1 -DHAVE_USLEEP=1 -DHAVE_LOCALTIME_R=1 -DHAVE_GMTIME_R=1 -DHAVE_DECL_STRERROR_R=1 -DHAVE_STRERROR_R=1 -DHAVE_POSIX_FALLOCATE=1 -DHAVE_ZLIB_H=1 -I. -D_REENTRANT=1 -DSQLITE_THREADSAFE=1 -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_JSON1 -DSQLITE_HAVE_ZLIB -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_RTREE -g -O2 -MT sqlite3.lo -MD -MP -MF .deps/sqlite3.Tpo -c sqlite3.c -fPIC -DPIC -o .libs/sqlite3.o gcc: internal compiler error: Killed (program cc1) Please submit a full bug report, with preprocessed source if appropriate. See for instructions. Makefile:539: recipe for target 'sqlite3.lo' failed make: *** [sqlite3.lo] Error 1 10. I checked the Makefile but there's no obvious issue 11. We've done this three times now with the same result. 12. The fact the compiler barfs is worrying, we know how many people use SQLite so for this sort of error to occur is a little surprising and we still thinksqlite-us...@mailinglists.sqlite.org its our fault, but we cannot see what we have done wrong. Any help or suggestions welcomed. I have to say I am sick to the back teeth of reading websites that purport to tell you how to compile SQLite to find that it simply consists of apt-get install sqlite3 (or whatever). The signal to noise ration here is very, very low. We need a clickbait filter. Thanks Rob - **Detaile
Re: [sqlite] I'm getting a compiler error on a SQLIte build on Ubuntu 16.04 (which surprises me)
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. We'll work out how to report it. I still have the same problem of trying to get hold of a copy of SQLite_analyze though :( Which is what I wanted to do in the first place. Rob On 9 Jul 2018, at 11:24, Clemens Ladisch wrote: 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. Regards, Clemens ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___ 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)
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. Regards, Clemens ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
