OPNsense Forum

English Forums => Development and Code Review => Topic started by: gondox on July 21, 2022, 11:05:45 am

Title: build error: "sqlite error while executing INSERT"
Post by: gondox on July 21, 2022, 11:05:45 am
I keep on trying to build an image for my raspberry pi cm4 and this time I ran into an sqlite error while running "make arm DEVICE=RPI" both on a x86 machine as well as on a raspberry pi:

Code: [Select]
Nothing to do.
Installing pkg-1.17.5_1...
the most recent version of pkg-1.17.5_1 is already installed
Installing iperf3-3.11...
Extracting iperf3-3.11: 100%
Installing ruby-2.7.6_2,1...
`-- Installing libyaml-0.2.5...
`-- Extracting libyaml-0.2.5: 100%
`-- Installing libunwind-20211201_1...
`-- Extracting libunwind-20211201_1: 100%
`-- Installing libedit-3.1.20210910,1...
`-- Extracting libedit-3.1.20210910,1: 100%
Extracting ruby-2.7.6_2,1: 100%
=====
Message from ruby-2.7.6_2,1:

--
Some of the standard commands are provided as separate ports for ease
of upgrading:

        devel/ruby-gems:                gem - RubyGems package manager
        devel/rubygem-irb:              irb - Interactive Ruby
        devel/rubygem-rake:             rake - Ruby Make
        devel/rubygem-rdoc:             rdoc - Ruby Documentation System
        sysutils/rubygem-bundler:       bundler - Tool that manages gem dependencies for ruby applications

And some of the standard libraries are provided as separate ports
since they require extra dependencies:

        databases/rubygem-dbm:  DBM module
        databases/rubygem-gdbm: GDBM module

Install them as occasion demands.
--
===>   NOTICE:

This port is deprecated; you may wish to reconsider installing it:

Please migrate to newer versions. Ruby 2.7 will reach its EoL on April 12, 2023.

It is scheduled to be removed on or after 2023-04-12.
pkg: warning: database version 36 is newer than libpkg(3) version 35, but still compatible
pkg: sqlite error while executing INSERT OR IGNORE INTO mtree(content) VALUES(?1) in file pkgdb.c:115: no such table: mtree
Updating FreeBSD repository catalogue...
Fetching meta.conf: 100%    163 B   0.2kB/s    00:01   
Fetching packagesite.pkg: 100%    6 MiB   3.2MB/s    00:02   
Processing entries: 100%
FreeBSD repository update completed. 30551 packages processed.
All repositories are up to date.
pkg: warning: database version 36 is newer than libpkg(3) version 35, but still compatible
pkg: sqlite error while executing INSERT OR IGNORE INTO mtree(content) VALUES(?1) in file pkgdb.c:115: no such table: mtree
*** Error code 1

Stop.
make[1]: stopped in /usr/plugins/benchmarks/iperf
*** Error code 1

Stop.
make: stopped in /usr/tools
root@generic:/usr/tools #

Any idea how this can happen or be fixed?

EDIT: I tried to find all sqlite db files in / and tried the .selftest command on all of them as suggested here: https://forum.opnsense.org/index.php?topic=15868.msg72658#msg72658 but it found no error in any of them.
Title: Re: build error: "sqlite error while executing INSERT"
Post by: franco on July 21, 2022, 12:13:46 pm
Looks like breakage in pkg 1.18 vs 1.17? I'm NOT going to update pkg again just because they keep adding breaking changes...
Title: Re: build error: "sqlite error while executing INSERT"
Post by: gondox on July 21, 2022, 12:24:53 pm
I think the make script uses pkg 1.17.5 at least it says so in line 2:
Code: [Select]
...
Installing pkg-1.17.5_1...
...
I couldn't find a reference to a version 1.18.
Can I somehow switch to an older version that did not have these problems?
Title: Re: build error: "sqlite error while executing INSERT"
Post by: franco on July 21, 2022, 01:11:05 pm
Check pkg version on the host..


Cheers,
Franco
Title: Re: build error: "sqlite error while executing INSERT"
Post by: gondox on July 21, 2022, 01:14:50 pm
Ah Ok,

now I can see what you mean:

Code: [Select]
freebsd@generic:~ % uname -a
FreeBSD generic 13.0-RELEASE FreeBSD 13.0-RELEASE #0 releng/13.0-n244733-ea31abc261f: Fri Apr  9 06:06:55 UTC 2021     root@releng1.nyi.freebsd.org:/usr/obj/usr/src/arm64.aarch64/sys/GENERIC  arm64
freebsd@generic:~ % pkg --version
1.18.3

If this causes the problem, shouldn't everyone get this sqlite error message from now on?
Title: Re: build error: "sqlite error while executing INSERT"
Post by: astronaut on July 22, 2022, 08:15:41 am
I am in the same place, same error on an up-to-date FreeBSD 13.1 system. Any suggestions how to switch to pkg-1.17.5_1 on my build system? I couldn't find a pkg file for manual install. (I am new to FreeBSD, so please be lenient... :-)

EDIT: Or any other suggestion how to succesfully build OPNsense, of course. I might be on the wrong track...
Title: Re: build error: "sqlite error while executing INSERT"
Post by: gondox on July 22, 2022, 10:06:38 am
@astronaut: I had used 13.1 in my first attempts as well and ran into pkg issues, then i switched to 13.0 and this "worked" for some time (although my builds failed for other reasons) and by now I seem to have pkg issues with 13.0 as well.

I assume that this needs to be fixed for OPNsense 22.7, because this is based on FreeBSD 13.1 and would then have the new pkg version automatically?

So maybe building OPNsense 22.7 on FreeBSD 13.1 might work?
Title: Re: build error: "sqlite error while executing INSERT"
Post by: franco on July 22, 2022, 11:18:07 am
Guys, this is becoming a bit ridiculous. I get that you are enthusiastic about OPNsense building but I'm asking you to read older tickets and issues and learn what the hell is going on in your build systems.

The first rule of build club is: don't mess up your build system.

The second rule of build club is: if your build system is messed up fix it.

FreeBSD package manager continues to break interoperability between versions. Their idea is that the new version can do the same crap the old version did, but the old versions have very little "forward" thinking. New features are added that don't benefit the functionality of pkg as a package manager tool itself. We could probably continue to use a version from 2-3 years ago without issue even today.

So if you want to avoid pkg messing up your build just make sure that you build pkg from OUR ports tree for YOUR build system. On a basic build system that means:

# cd /usr/ports/ports-mgmt/pkg
# make package
# make deinstall
# make install

Done...


Cheers,
Franco
Title: Re: build error: "sqlite error while executing INSERT"
Post by: astronaut on July 22, 2022, 02:25:37 pm
@franco: That helped a lot, thank you!

For reference: After building as franco describes,
Code: [Select]
# make reinstall failed. However, I manually installed the pkg file:

Code: [Select]
# cd work/pkg
# pkg install --force pkg-1.17.5_1.pkg

Then (in the correct directory, of course)
Code: [Select]
# make DVD completed flawlessly.

Disclaimer: Being a bloody beginner, I am not sure if this is the right way, so be aware.  ;)
Title: Re: build error: "sqlite error while executing INSERT"
Post by: franco on July 22, 2022, 02:29:07 pm
Ah, thanks, I changed the reinstall to deinstall/install... that one should work. :)

I will look into making the build tools complain on mismatching pkg version. Previous quick attempts didn't work for various reasons.


Cheers,
Franco
Title: Re: build error: "sqlite error while executing INSERT"
Post by: gondox on July 22, 2022, 03:20:05 pm
funnily enough, I now get the same error, when I try to install pkg version 1.17.5 from the opnsense ports  ;D

Code: [Select]
root@generic:/usr/ports/ports-mgmt/pkg # make package
...
====> Compressing man pages (compress-man)
===>   Installing ldconfig configuration file
===>  Building package for pkg-1.17.5_1
root@generic:/usr/ports/ports-mgmt/pkg # make deinstall
===>  Deinstalling for pkg
pkg-static: warning: database version 36 is newer than libpkg(3) version 35, but still compatible
pkg-static: sqlite error while executing INSERT OR IGNORE INTO mtree(content) VALUES(?1) in file pkgdb.c:115: no such table: mtree
===>   pkg not installed, skipping
root@generic:/usr/ports/ports-mgmt/pkg # make install
===>  Installing for pkg-1.17.5_1
===>  Checking if pkg is already installed
pkg-static: warning: database version 36 is newer than libpkg(3) version 35, but still compatible
pkg-static: sqlite error while executing INSERT OR IGNORE INTO mtree(content) VALUES(?1) in file pkgdb.c:115: no such table: mtree
*** Error code 1

Stop.
make[2]: stopped in /usr/ports/ports-mgmt/pkg
*** Error code 1

Stop.
make[1]: stopped in /usr/ports/ports-mgmt/pkg
*** Error code 1

Stop.
make: stopped in /usr/ports/ports-mgmt/pkg
root@generic:/usr/ports/ports-mgmt/pkg #

Are there any other packages I might want to build from the OPNsense ports manually instead of using the ones that come with Freebsd 13.0?
Title: Re: build error: "sqlite error while executing INSERT"
Post by: franco on July 22, 2022, 03:40:52 pm
No, just pkg doing this weird thing.

And, yep, it doesn't like going back as I said...

If you delete all packages and the database /var/db/pkg it should be back to normal after install.


Cheers,
Franco
Title: Re: build error: "sqlite error while executing INSERT"
Post by: gondox on July 22, 2022, 03:53:43 pm
I opted to set it all up anew, just to make sure.

While doing "make update" to get the ports directory in /usr/ports/ (so that I can reinstall pkg), I found out, that 22.7 is now the current stable branch?

Code: [Select]
>>> Fetching /usr/core:
>>> Updating branch stable/22.7 of /usr/core:
branch 'stable/22.7' set up to track 'origin/stable/22.7'.
Switched to a new branch 'stable/22.7'
Already up to date.

Does this mean I should switch to Freebsd 13.1 as host system?
Title: Re: build error: "sqlite error while executing INSERT"
Post by: franco on July 22, 2022, 03:58:48 pm
I've successfully built 22.7 on 13.0 as well with OS=13.0 setting, but I recommend

a) upgrading to FreeBSD 13.1 to build 22.7, or
b) checking out 22.1.10 tags to build 22.1 on there for the time being.


Cheers,
Franco
Title: Re: build error: "sqlite error while executing INSERT"
Post by: gondox on July 22, 2022, 07:08:36 pm
I set it all up from scratch, this time with freebsd 13.1
and the first thing I did was to install git, because I need it to download the tools:
"pkg install git" (just as in the README)
And I guess this messes up the sqlite database, because although I do the steps described by astronaut as well as franco (I tested both)

I will get something like this:
Code: [Select]
root@generic:/usr/ports/ports-mgmt/pkg # make package
...
===>  Building package for pkg-1.17.5_1
root@generic:/usr/ports/ports-mgmt/pkg # cd work/pkg
root@generic:/usr/ports/ports-mgmt/pkg/work/pkg # pkg install --force pkg-1.17.5_1.pkg
Updating FreeBSD repository catalogue...
FreeBSD repository is up to date.
All repositories are up to date.
Updating database digests format: 100%
Checking integrity... done (0 conflicting)
The following 1 package(s) will be affected (of 0 checked):

Installed packages to be DOWNGRADED:
pkg: 1.18.3 -> 1.17.5_1

Number of packages to be downgraded: 1

The operation will free 2 MiB.

Proceed with this action? [y/N]: y
[1/1] Downgrading pkg from 1.18.3 to 1.17.5_1...
Extracting pkg-1.17.5_1: 100%
root@generic:/usr/ports/ports-mgmt/pkg/work/pkg #
root@generic:/usr/tools # make arm DEVICE=RPI
...
WITHOUT_MODULES=cloudabi32
>>> Running build step: base
>>> Passing arguments: (none)
pkg: warning: database version 36 is newer than libpkg(3) version 35, but still compatible
pkg: sqlite error while executing INSERT OR IGNORE INTO mtree(content) VALUES(?1) in file pkgdb.c:115: no such table: mtree
>>> Required package 'u-boot-rpi4' is not installed.
*** Error code 1

Stop.
make: stopped in /usr/tools
root@generic:/usr/tools #

So I am in a bit of a catch 22: I need the tools to install pkg 17.5, and to do that I need git, but as soon as I install git: I mess up the sqlite db
Title: Re: build error: "sqlite error while executing INSERT"
Post by: franco on July 22, 2022, 08:33:55 pm
I think you can bootstrap from FreeBSD against https://pkg.opnsense.org/FreeBSD:13:amd64/22.7/latest/Latest/pkg.pkg before installing git, but I don't have a system to check at this moment.


Cheers,
Franco
Title: Re: build error: "sqlite error while executing INSERT"
Post by: gondox on July 22, 2022, 11:50:57 pm
Thanks for the link, I tried to curl it but curl isn't installed in the beginning. So I thought about moving it over with a usb thumb drive.
But then I saw that there is only a amd64 version and not an aarch64 version in https://pkg.opnsense.org/ . And I am building on a raspberry pi, . . . so no idea how to figure this out.
Title: Re: build error: "sqlite error while executing INSERT"
Post by: gondox on July 23, 2022, 12:54:09 pm
Ok, so I did some more testing yesterday:
1. I set a new install of Freebsd 13.1
2. I used git and make update to get the OPNsense sources
3. I created the 1.17.5 package from the OPNsense sources
4. Transfered the created package to my PC via scp
5. Formated the whole raspberry pi sdcard and set up a fresh Freebsd 13.1 installation
6. Transfered the 1.17.5 package to the fresh install
7. Forced the installation of 1.17.5 pkg
and the result was: pkg 1.18 was invoked to downgrade pkg and thereby modified the sqlite database => back to square one

Code: [Select]
root@generic:/home/freebsd # ls
.cshrc .login_conf .mailrc .shrc pkg-1.17.5_1.pkg
.login .mail_aliases .profile .ssh
root@generic:/home/freebsd # pkg install --force pkg-1.17.5_1.pkg
The package management tool is not yet installed on your system.
Do you want to fetch and install it now? [y/N]: y
Bootstrapping pkg from pkg+http://pkg.FreeBSD.org/FreeBSD:13:aarch64/quarterly, please wait...
Verifying signature with trusted certificate pkg.freebsd.org.2013102301... done
Installing pkg-1.18.3...
Extracting pkg-1.18.3: 100%
Updating FreeBSD repository catalogue...
Fetching meta.conf: 100%    163 B   0.2kB/s    00:01   
Fetching packagesite.pkg: 100%    6 MiB   6.3MB/s    00:01   
Processing entries: 100%
FreeBSD repository update completed. 30551 packages processed.
All repositories are up to date.
Updating database digests format: 100%
Checking integrity... done (0 conflicting)
The following 1 package(s) will be affected (of 0 checked):

Installed packages to be DOWNGRADED:
pkg: 1.18.3 -> 1.17.5_1

Number of packages to be downgraded: 1

The operation will free 2 MiB.

Proceed with this action? [y/N]: y
[1/1] Downgrading pkg from 1.18.3 to 1.17.5_1...
Extracting pkg-1.17.5_1: 100%
root@generic:/home/freebsd # pkg install git
Updating FreeBSD repository catalogue...
FreeBSD repository is up to date.
All repositories are up to date.
pkg: warning: database version 36 is newer than libpkg(3) version 35, but still compatible
pkg: sqlite error while executing INSERT OR IGNORE INTO mtree(content) VALUES(?1) in file pkgdb.c:115: no such table: mtree
root@generic:/home/freebsd #

@astronaut: I have no idea how you did it, if you tried again, would you be able to fix it on a new install? If so, can you tell me?
Title: Re: build error: "sqlite error while executing INSERT"
Post by: gondox on July 23, 2022, 06:57:08 pm
I think I figured out how to work around this problem, but it is incredibly clunky:

1. I set a new install of Freebsd 13.1
2. I used git and make update to get the OPNsense sources
3. I copied the /usr/ports/ directory to a remote PC via scp
5. Formated the whole raspberry pi sdcard and set up a fresh Freebsd 13.1 installation
6. Transfered the the copied sources back to the new install
7. went to the copy directory and did the following steps:
    # cd /pathtofolder/ports-mgmt/pkg
    # make package
    # make deinstall
    # make install
8. locked pkg with "pkg lock pkg"

and the proceeded with the steps in the README.

The RPI config asks for qemu-user-static, but there is none in the packages (pkg search qemu-user-static) and when I try to build it from the OPNsense sources via "make package" it tells me aarch64 is not supported. As I am compiling on a raspberry pi with aarch64, I think I shouldn't need an emulator, but who knows.

It is compiling "make arm DEVICE="RPI"" at the moment, we will see how it works out.
Title: Re: build error: "sqlite error while executing INSERT"
Post by: astronaut on July 23, 2022, 11:47:49 pm
Huh, that's weird. The only thing that I can think of is the following: While trying different stuff out, I did a
Code: [Select]
#pkg search pkg This listed (among others) pkg-devel-1.17.99.1. As the version number1.17.99.1 was lower than the official pkg one (1.18.something), I simply tried it out with pkg install --force. It didn't work, the error while building OPNsense remained, but maybe this was the intermediate step that allowed me to install the pkg in the way that franco describes?
Title: Re: build error: "sqlite error while executing INSERT"
Post by: nabrog87 on September 03, 2022, 10:21:48 am
Hello,
What am I missing ? I followed the steps mentioned above but I receive the attached error, while trying to make the packages.
TY
Title: Re: build error: "sqlite error while executing INSERT"
Post by: astronaut on September 13, 2022, 08:38:05 am
@nabrog87: Did you look into the log file as stated in the error message? However, this looks like something different enough that it might be better to open a new topic.
Title: Re: build error: "sqlite error while executing INSERT"
Post by: nabrog87 on October 17, 2022, 08:52:28 pm
hello, here is the log, thank you

Quote
Invoked as: ./configure
Tclsh: /usr/obj/usr/tools/config/22.7/OpenSSL:aarch64/usr/obj/usr/ports/ports-mgmt/pkg/work/pkg-1.17.5/jimsh0
Failed: cc -g -O2 -c conftest__.c -o conftest__.o
conftest__.c:4:7: error: use of undeclared identifier 'F_CLOSEM'
(void)F_CLOSEM;
      ^
1 error generated.
============
The failed code was:
#include <fcntl.h>
int main(void) {
#ifndef F_CLOSEM
(void)F_CLOSEM;
#endif
return 0;
}
============
Failed: cc -g -O2 conftest__.c -o conftest__
ld: error: undefined symbol: arc4random_stir
>>> referenced by conftest__.c:3
>>>               /tmp/conftest__-1765d9.o:(main)
>>> did you mean: arc4random_stir@FBSD_1.0
>>> defined in: /lib/libc.so.7
cc: error: linker command failed with exit code 1 (use -v to see invocation)
============
The failed code was:
extern void arc4random_stir(void);
int main(void) {
arc4random_stir();
return 0;
}
============
Failed: cc -g -O2 conftest__.c -o conftest__
ld: error: undefined symbol: basename_r
>>> referenced by conftest__.c:3
>>>               /tmp/conftest__-813738.o:(main)
>>> did you mean: basename_r@FBSD_1.2
>>> defined in: /lib/libc.so.7
cc: error: linker command failed with exit code 1 (use -v to see invocation)
============
The failed code was:
extern void basename_r(void);
int main(void) {
basename_r();
return 0;
}
============
Failed: cc -g -O2 -c conftest__.c -o conftest__.o
conftest__.c:1:10: fatal error: 'sys/statfs.h' file not found
#include <sys/statfs.h>
         ^~~~~~~~~~~~~~
1 error generated.
============
The failed code was:
#include <sys/statfs.h>
int main(void) {

return 0;
}
============
Failed: cc -g -O2 -c conftest__.c -o conftest__.o
conftest__.c:1:10: fatal error: 'endian.h' file not found
#include <endian.h>
         ^~~~~~~~~~
1 error generated.
============
The failed code was:
#include <endian.h>
int main(void) {

return 0;
}
============
Failed: cc -g -O2 -c conftest__.c -o conftest__.o -lelf
cc: warning: -lelf: 'linker' input unused [-Wunused-command-line-argument]
conftest__.c:2:1: error: use of undeclared identifier 'Elf_Note'
Elf_Note _x;
^
1 error generated.
============
The failed code was:
int main(void) {
Elf_Note _x;
return 0;
}
============
Failed: cc -g -O2 -c conftest__.c -o conftest__.o
conftest__.c:1:10: fatal error: 'bsd/err.h' file not found
#include <bsd/err.h>
         ^~~~~~~~~~~
1 error generated.
============
The failed code was:
#include <bsd/err.h>
int main(void) {

return 0;
}
============
Failed: cc -g -O2 -c conftest__.c -o conftest__.o
conftest__.c:1:10: fatal error: 'bsd/libutil.h' file not found
#include <bsd/libutil.h>
         ^~~~~~~~~~~~~~~
1 error generated.
============
The failed code was:
#include <bsd/libutil.h>
int main(void) {

return 0;
}
============
Failed: cc -g -O2 -c conftest__.c -o conftest__.o
conftest__.c:1:10: fatal error: 'bsd/readpassphrase.h' file not found
#include <bsd/readpassphrase.h>
         ^~~~~~~~~~~~~~~~~~~~~~
1 error generated.
============
The failed code was:
#include <bsd/readpassphrase.h>
int main(void) {

return 0;
}
============
Failed: cc -g -O2 -c conftest__.c -o conftest__.o
conftest__.c:1:10: fatal error: 'bsd/stdio.h' file not found
#include <bsd/stdio.h>
         ^~~~~~~~~~~~~
1 error generated.
============
The failed code was:
#include <bsd/stdio.h>
int main(void) {

return 0;
}
============
Failed: cc -g -O2 -c conftest__.c -o conftest__.o
conftest__.c:1:10: fatal error: 'bsd/stdlib.h' file not found
#include <bsd/stdlib.h>
         ^~~~~~~~~~~~~~
1 error generated.
============
The failed code was:
#include <bsd/stdlib.h>
int main(void) {

return 0;
}
============
Failed: cc -g -O2 -c conftest__.c -o conftest__.o
conftest__.c:1:10: fatal error: 'bsd/strlib.h' file not found
#include <bsd/strlib.h>
         ^~~~~~~~~~~~~~
1 error generated.
============
The failed code was:
#include <bsd/strlib.h>
int main(void) {

return 0;
}
============
Failed: cc -g -O2 -c conftest__.c -o conftest__.o
conftest__.c:1:10: fatal error: 'bsd/string.h' file not found
#include <bsd/string.h>
         ^~~~~~~~~~~~~~
1 error generated.
============
The failed code was:
#include <bsd/string.h>
int main(void) {

return 0;
}
============
Failed: cc -g -O2 -c conftest__.c -o conftest__.o
conftest__.c:1:10: fatal error: 'bsd/sys/cdefs.h' file not found
#include <bsd/sys/cdefs.h>
         ^~~~~~~~~~~~~~~~~
1 error generated.
============
The failed code was:
#include <bsd/sys/cdefs.h>
int main(void) {

return 0;
}
============
Failed: cc -g -O2 -c conftest__.c -o conftest__.o
conftest__.c:1:10: fatal error: 'bsd/unistd.h' file not found
#include <bsd/unistd.h>
         ^~~~~~~~~~~~~~
1 error generated.
============
The failed code was:
#include <bsd/unistd.h>
int main(void) {

return 0;
}
============
pkg-config --modversion atf-c : Package atf-c was not found in the pkg-config search path.
Perhaps you should add the directory containing `atf-c.pc'
to the PKG_CONFIG_PATH environment variable
Package 'atf-c', required by 'virtual:world', not found
root@freebsd:/usr/tools #
root@freebsd:/usr/tools #
root@freebsd:/usr/tools #
root@freebsd:/usr/tools # cat /usr/obj/usr/tools/config/22.7/OpenSSL:aarch64/usr/obj/usr/ports/ports-mgmt/pkg/work/pkg-1.17.5/config.log
Invoked as: ./configure
Tclsh: /usr/obj/usr/tools/config/22.7/OpenSSL:aarch64/usr/obj/usr/ports/ports-mgmt/pkg/work/pkg-1.17.5/jimsh0
Failed: cc -g -O2 -c conftest__.c -o conftest__.o
conftest__.c:4:7: error: use of undeclared identifier 'F_CLOSEM'
(void)F_CLOSEM;
      ^
1 error generated.
============
The failed code was:
#include <fcntl.h>
int main(void) {
#ifndef F_CLOSEM
(void)F_CLOSEM;
#endif
return 0;
}
============
Failed: cc -g -O2 conftest__.c -o conftest__
ld: error: undefined symbol: arc4random_stir
>>> referenced by conftest__.c:3
>>>               /tmp/conftest__-1765d9.o:(main)
>>> did you mean: arc4random_stir@FBSD_1.0
>>> defined in: /lib/libc.so.7
cc: error: linker command failed with exit code 1 (use -v to see invocation)
============
The failed code was:
extern void arc4random_stir(void);
int main(void) {
arc4random_stir();
return 0;
}
============
Failed: cc -g -O2 conftest__.c -o conftest__
ld: error: undefined symbol: basename_r
>>> referenced by conftest__.c:3
>>>               /tmp/conftest__-813738.o:(main)
>>> did you mean: basename_r@FBSD_1.2
>>> defined in: /lib/libc.so.7
cc: error: linker command failed with exit code 1 (use -v to see invocation)
============
The failed code was:
extern void basename_r(void);
int main(void) {
basename_r();
return 0;
}
============
Failed: cc -g -O2 -c conftest__.c -o conftest__.o
conftest__.c:1:10: fatal error: 'sys/statfs.h' file not found
#include <sys/statfs.h>
         ^~~~~~~~~~~~~~
1 error generated.
============
The failed code was:
#include <sys/statfs.h>
int main(void) {

return 0;
}
============
Failed: cc -g -O2 -c conftest__.c -o conftest__.o
conftest__.c:1:10: fatal error: 'endian.h' file not found
#include <endian.h>
         ^~~~~~~~~~
1 error generated.
============
The failed code was:
#include <endian.h>
int main(void) {

return 0;
}
============
Failed: cc -g -O2 -c conftest__.c -o conftest__.o -lelf
cc: warning: -lelf: 'linker' input unused [-Wunused-command-line-argument]
conftest__.c:2:1: error: use of undeclared identifier 'Elf_Note'
Elf_Note _x;
^
1 error generated.
============
The failed code was:
int main(void) {
Elf_Note _x;
return 0;
}
============
Failed: cc -g -O2 -c conftest__.c -o conftest__.o
conftest__.c:1:10: fatal error: 'bsd/err.h' file not found
#include <bsd/err.h>
         ^~~~~~~~~~~
1 error generated.
============
The failed code was:
#include <bsd/err.h>
int main(void) {

return 0;
}
============
Failed: cc -g -O2 -c conftest__.c -o conftest__.o
conftest__.c:1:10: fatal error: 'bsd/libutil.h' file not found
#include <bsd/libutil.h>
         ^~~~~~~~~~~~~~~
1 error generated.
============
The failed code was:
#include <bsd/libutil.h>
int main(void) {

return 0;
}
============
Failed: cc -g -O2 -c conftest__.c -o conftest__.o
conftest__.c:1:10: fatal error: 'bsd/readpassphrase.h' file not found
#include <bsd/readpassphrase.h>
         ^~~~~~~~~~~~~~~~~~~~~~
1 error generated.
============
The failed code was:
#include <bsd/readpassphrase.h>
int main(void) {

return 0;
}
============
Failed: cc -g -O2 -c conftest__.c -o conftest__.o
conftest__.c:1:10: fatal error: 'bsd/stdio.h' file not found
#include <bsd/stdio.h>
         ^~~~~~~~~~~~~
1 error generated.
============
The failed code was:
#include <bsd/stdio.h>
int main(void) {

return 0;
}
============
Failed: cc -g -O2 -c conftest__.c -o conftest__.o
conftest__.c:1:10: fatal error: 'bsd/stdlib.h' file not found
#include <bsd/stdlib.h>
         ^~~~~~~~~~~~~~
1 error generated.
============
The failed code was:
#include <bsd/stdlib.h>
int main(void) {

return 0;
}
============
Failed: cc -g -O2 -c conftest__.c -o conftest__.o
conftest__.c:1:10: fatal error: 'bsd/strlib.h' file not found
#include <bsd/strlib.h>
         ^~~~~~~~~~~~~~
1 error generated.
============
The failed code was:
#include <bsd/strlib.h>
int main(void) {

return 0;
}
============
Failed: cc -g -O2 -c conftest__.c -o conftest__.o
conftest__.c:1:10: fatal error: 'bsd/string.h' file not found
#include <bsd/string.h>
         ^~~~~~~~~~~~~~
1 error generated.
============
The failed code was:
#include <bsd/string.h>
int main(void) {

return 0;
}
============
Failed: cc -g -O2 -c conftest__.c -o conftest__.o
conftest__.c:1:10: fatal error: 'bsd/sys/cdefs.h' file not found
#include <bsd/sys/cdefs.h>
         ^~~~~~~~~~~~~~~~~
1 error generated.
============
The failed code was:
#include <bsd/sys/cdefs.h>
int main(void) {

return 0;
}
============
Failed: cc -g -O2 -c conftest__.c -o conftest__.o
conftest__.c:1:10: fatal error: 'bsd/unistd.h' file not found
#include <bsd/unistd.h>
         ^~~~~~~~~~~~~~
1 error generated.
============
The failed code was:
#include <bsd/unistd.h>
int main(void) {

return 0;
}
============
pkg-config --modversion atf-c : Package atf-c was not found in the pkg-config search path.
Perhaps you should add the directory containing `atf-c.pc'
to the PKG_CONFIG_PATH environment variable
Package 'atf-c', required by 'virtual:world', not found
Title: Re: build error: "sqlite error while executing INSERT"
Post by: astronaut on October 17, 2022, 11:16:33 pm
@nabrog87: Unfortunately, I can't help you with your error. But I suspect that it is not the same error that has been discussed in this thread. The error message is different.