Created attachment 737056 [details] dev-db/sqlite build log Greetings, I am getting `disk I/O error` when using sqlite3 (with both compiled on my machine and binary release getting the same error). Steps to replicate: > sqlite3 test.sqlite sqlite> .log stderr sqlite> CREATE TABLE IF NOT EXISTS History (url NOT NULL, title NOT NULL, atime NOT NULL, redirect NOT NULL); sqlite> CREATE TABLE IF NOT EXISTS History1 (url NOT NULL, title NOT NULL, atime NOT NULL, redirect NOT NULL); (1034) os_unix.c:37620: (5) full_fsync(/home/nekohacker/history.sqlite-journal) - Error: disk I/O error sqlite> .quit I will an sqlite.strace that was obtained by running `strace -o sqlite.strace sqlite3 test.sqlite` --- Output of emerge --info dev-db/sqlite Portage 3.0.22 (python 3.9.7-final-0, default/linux/amd64/17.1, gcc-11.2.0, glibc-2.33-r7, 5.13.13-gentoo x86_64) ================================================================= System Settings ================================================================= System uname: Linux-5.13.13-gentoo-x86_64-Intel-R-_Core-TM-_i5-6400_CPU_@_2.70GHz-with-glibc2.33 KiB Mem: 24587828 total, 21516584 free KiB Swap: 10485756 total, 10485756 free Timestamp of repository gentoo: Tue, 31 Aug 2021 20:30:01 +0000 Head commit of repository gentoo: 0b3db12de27dadd506593aa492466269cfbf0138 sh bash 5.1_p8 ld GNU ld (Gentoo 2.37_p1 p0) 2.37 ccache version 4.4 [disabled] app-shells/bash: 5.1_p8::gentoo dev-lang/perl: 5.34.0-r2::gentoo dev-lang/python: 2.7.18_p13::gentoo, 3.8.12::gentoo, 3.9.7::gentoo, 3.10.0_rc1_p2::gentoo dev-lang/rust: 1.54.0::gentoo dev-util/ccache: 4.4::gentoo dev-util/cmake: 3.21.2::gentoo sys-apps/baselayout: 2.7-r3::gentoo sys-apps/openrc: 0.43.5::gentoo sys-apps/sandbox: 2.24::gentoo sys-devel/autoconf: 2.71-r1::gentoo sys-devel/automake: 1.16.4::gentoo sys-devel/binutils: 2.37_p1::gentoo sys-devel/gcc: 11.2.0::gentoo sys-devel/gcc-config: 2.4::gentoo sys-devel/libtool: 2.4.6-r6::gentoo sys-devel/make: 4.3::gentoo sys-kernel/linux-headers: 5.13::gentoo (virtual/os-headers) sys-libs/glibc: 2.33-r7::gentoo Repositories: gentoo location: /var/db/repos/gentoo sync-type: rsync sync-uri: rsync://rsync.gentoo.org/gentoo-portage priority: -1000 sync-rsync-verify-jobs: 1 sync-rsync-extra-opts: sync-rsync-verify-metamanifest: yes sync-rsync-verify-max-age: 24 lto-overlay location: /var/lib/layman/lto-overlay sync-type: laymansync sync-uri: https://github.com/InBetweenNames/gentooLTO.git masters: gentoo mv priority: 50 mv location: /var/lib/layman/mv sync-type: laymansync sync-uri: https://anongit.gentoo.org/git/user/mv.git masters: gentoo priority: 50 nest location: /var/lib/layman/nest sync-type: laymansync sync-uri: https://github.com/SpiderX/portage-overlay.git masters: gentoo priority: 50 raiagent location: /var/lib/layman/raiagent sync-type: laymansync sync-uri: https://github.com/leycec/raiagent masters: gentoo priority: 50 ACCEPT_KEYWORDS="amd64 ~amd64" ACCEPT_LICENSE="@FREE NPSL linux-fw-redistributable no-source-code Vivaldi" CBUILD="x86_64-pc-linux-gnu" CFLAGS="-march=skylake -O3 -fgraphite-identity -floop-nest-optimize -fdevirtualize-at-ltrans -fipa-pta -fno-semantic-interposition -flto=auto -fuse-linker-plugin -pipe -falign-functions=32" CHOST="x86_64-pc-linux-gnu" CONFIG_PROTECT="/etc /usr/share/gnupg/qualified.txt" CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/dconf /etc/env.d /etc/fonts/fonts.conf /etc/gconf /etc/gentoo-release /etc/revdep-rebuild /etc/sandbox.d /etc/terminfo /etc/texmf/language.dat.d /etc/texmf/language.def.d /etc/texmf/updmap.d /etc/texmf/web2c" CXXFLAGS="-march=skylake -O3 -fgraphite-identity -floop-nest-optimize -fdevirtualize-at-ltrans -fipa-pta -fno-semantic-interposition -flto=auto -fuse-linker-plugin -pipe -falign-functions=32" DISTDIR="/var/cache/distfiles" EMERGE_DEFAULT_OPTS="--jobs=4 --load-average=3.6" ENV_UNSET="CARGO_HOME DBUS_SESSION_BUS_ADDRESS DISPLAY GOBIN GOPATH PERL5LIB PERL5OPT PERLPREFIX PERL_CORE PERL_MB_OPT PERL_MM_OPT XAUTHORITY XDG_CACHE_HOME XDG_CONFIG_HOME XDG_DATA_HOME XDG_RUNTIME_DIR" FCFLAGS="-march=skylake -O2 -pipe" FEATURES="assume-digests binpkg-docompress binpkg-dostrip binpkg-logs config-protect-if-modified distlocks ebuild-locks fixlafiles ipc-sandbox merge-sync multilib-strict network-sandbox news parallel-fetch pid-sandbox preserve-libs protect-owned qa-unresolved-soname-deps sandbox sfperms strict unknown-features-warn unmerge-logs unmerge-orphans userfetch userpriv usersandbox usersync xattr" FFLAGS="-march=skylake -O2 -pipe" GENTOO_MIRRORS="https://mirror.yandex.ru/gentoo-distfiles https://gentoo-mirror.alexxy.name" LANG="en_US.utf8" LC_ALL="en_US.utf8" LDFLAGS="-Wl,-O1 -Wl,--as-needed" MAKEOPTS="-j5" PKGDIR="/var/cache/binpkgs" PORTAGE_CONFIGROOT="/" PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --omit-dir-times --compress --force --whole-file --delete --stats --human-readable --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages --exclude=/.git" PORTAGE_TMPDIR="/var/tmp" USE="X acl alsa amd64 bzip2 cli crypt dbus dri elogind fortran gdbm graphite iconv icu ipv6 libglvnd libtirpc lto multilib ncurses nls nptl openmp pam pcre readline seccomp split-usr ssl tcpd udev unicode wacom xattr xinerama zlib" ABI_X86="64" ADA_TARGET="gnat_2018" ALSA_CARDS="ali5451 als4000 atiixp atiixp-modem bt87x ca0106 cmipci emu10k1x ens1370 ens1371 es1938 es1968 fm801 hda-intel intel8x0 intel8x0m maestro3 trident usb-audio via82xx via82xx-modem ymfpci" APACHE2_MODULES="authn_core authz_core socache_shmcb unixd actions alias auth_basic authn_alias authn_anon authn_dbm authn_default authn_file authz_dbm authz_default authz_groupfile authz_host authz_owner authz_user autoindex cache cgi cgid dav dav_fs dav_lock deflate dir disk_cache env expires ext_filter file_cache filter headers include info log_config logio mem_cache mime mime_magic negotiation rewrite setenvif speling status unique_id userdir usertrack vhost_alias" CALLIGRA_FEATURES="karbon sheets words" COLLECTD_PLUGINS="df interface irq load memory rrdtool swap syslog" CPU_FLAGS_X86="aes avx avx2 f16c fma3 mmx mmxext pclmul popcnt rdrand sse sse2 sse3 sse4_1 sse4_2 ssse3" ELIBC="glibc" GPSD_PROTOCOLS="ashtech aivdm earthmate evermore fv18 garmin garmintxt gpsclock greis isync itrax mtk3301 nmea ntrip navcom oceanserver oldstyle oncore rtcm104v2 rtcm104v3 sirf skytraq superstar2 timing tsip tripmate tnt ublox ubx" GRUB_PLATFORMS="efi-64" INPUT_DEVICES="wacom" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LIBREOFFICE_EXTENSIONS="presenter-console presenter-minimizer" LUA_SINGLE_TARGET="lua5-1" LUA_TARGETS="lua5-1" OFFICE_IMPLEMENTATION="libreoffice" PHP_TARGETS="php7-3 php7-4" POSTGRES_TARGETS="postgres12 postgres13" PYTHON_SINGLE_TARGET="python3_9" PYTHON_TARGETS="python3_9" RUBY_TARGETS="ruby26" USERLAND="GNU" VIDEO_CARDS="nvidia nouveau" XTABLES_ADDONS="quota2 psd pknock lscan length2 ipv4options ipset ipp2p iface geoip fuzzy condition tee tarpit sysrq proto steal rawnat logmark ipmark dhcpmac delude chaos account" Unset: CC, CPPFLAGS, CTARGET, CXX, INSTALL_MASK, LINGUAS, PORTAGE_BINHOST, PORTAGE_BUNZIP2_COMMAND, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS, RUSTFLAGS ================================================================= Package Settings ================================================================= dev-db/sqlite-3.35.5::gentoo was built with the following: USE="debug icu readline tools -doc -secure-delete -static-libs -tcl -test" ABI_X86="(64) -32 (-x32)" CFLAGS="-O1" CXXFLAGS="-O1 -Wl,-O1 -Wl,--as-needed" FEATURES="multilib-strict ebuild-locks unmerge-logs binpkg-docompress strict unknown-features-warn xattr userfetch sfperms binpkg-logs usersync parallel-fetch ipc-sandbox fixlafiles news distlocks assume-digests usersandbox qa-unresolved-soname-deps protect-owned userpriv preserve-libs binpkg-dostrip pid-sandbox sandbox network-sandbox merge-sync unmerge-orphans config-protect-if-modified"
Created attachment 737059 [details] strace of `strace -o sqlite.strace sqlite3 test.sqlite`
Comment on attachment 737059 [details] strace of `strace -o sqlite.strace sqlite3 test.sqlite` SQLite version 3.35.5 2021-04-19 18:32:05 Enter ".help" for usage hints. sqlite> .log stderr sqlite> CREATE TABLE IF NOT EXISTS History (url NOT NULL, title NOT NULL, atime NOT NULL, redirect NOT NULL); sqlite> CREATE TABLE IF NOT EXISTS History1 (url NOT NULL, title NOT NULL, atime NOT NULL, redirect NOT NULL); (1034) os_unix.c:37620: (5) full_fsync(/home/nekohacker/test.sqlite-journal) - Error: disk I/O error sqlite> .quit
works for me. sqlite3 test.sqlite SQLite version 3.35.5 2021-04-19 18:32:05 Enter ".help" for usage hints. sqlite> It is sad to read that you have problems with sqlite. The situation seems to be a bit more complicate and requires some analysis. We can not help you efficiently via bug tracker. The bug tracker aims rather on specific problems in .ebuilds and less on individual systems. I have had very good experience on the gentoo IRC [1] with questions like this. Of course there are also forums and mailing lists [2,3]. I hope you understand, that I will close the bug here therefore and wish you good luck on one of the mentioned channels [4]. Please reopen the ticket in order to provide an indication for an specific error in an ebuild or any gentoo related product. [1] https://www.gentoo.org/get-involved/irc-channels/ [2] https://forums.gentoo.org/ [3] https://www.gentoo.org/get-involved/mailing-lists/all-lists.html [4] https://www.gentoo.org/support/
