database is inconsistent: name mismatch

[yochananmarqos]

After performing a sync, I attempted to update with sudo pacman -Syu:

:: Synchronizing package databases...
 core                                                                                              53.3 KiB  62.7 KiB/s 00:01 [############################################################################] 100%
 extra                                                                                              2.4 MiB  1477 KiB/s 00:02 [############################################################################] 100%
 multilib                                                                                          54.9 KiB  54.1 KiB/s 00:01 [############################################################################] 100%
:: Starting full system upgrade...
error: extra database is inconsistent: name mismatch on package autocon
resolving dependencies...
error: multilib database is inconsistent: name mismatch on package lib
warning: cannot resolve "glibc libudev.so=1-64 systemd-libs", a dependency of "device-mapper"
warning: cannot resolve "alsa-lib at-spi2-core bash cairo dbus ffmpeg fontconfig freetype2 gcc-libs gdk-pixbuf2 glib2 glibc gtk3 hicolor-icon-theme libpulse libx11 libxcb libxcomposite libxdamage libxext libxfixes libxrandr libxss libxt mime-types nspr nss pango ttf-font", a dependency of "firefox"
warning: cannot resolve "bzip2 freetype2 giflib libjpeg-turbo libpng libtiff libxext xz", a dependency of "imlib2"
warning: cannot resolve "device-mapper glibc libbpf libbpf.so=1-64 libcap libcap.so=2-64 libelf libxtables.so=12-64", a dependency of "iproute2"
warning: cannot resolve "gcc-libs glib2 glibc libgudev libgusb nss pixman", a dependency of "libfprint"
warning: cannot resolve "glibc libmnl libnfnetlink", a dependency of "libnftnl"
warning: cannot resolve "curl duktape gcc-libs glib2 glibc", a dependency of "libproxy"
warning: cannot resolve "bash glibc icu ncurses readline xz zlib", a dependency of "libxml2"
warning: cannot resolve "curl gcc-libs libedit libffi libxml2 ncurses zlib zstd", a dependency of "llvm-libs"
warning: cannot resolve "acl gzip popt", a dependency of "logrotate"
warning: cannot resolve "bash device-mapper>=2.03.25 libaio libaio.so=1-64 libblkid.so=1-64 libreadline.so=8-64 libudev.so=1-64 readline systemd-libs thin-provisioning-tools util-linux-libs", a dependency of "lvm2"
warning: cannot resolve "cups-pdf foomatic-db foomatic-db-gutenprint-ppds foomatic-db-nonfree foomatic-db-nonfree-ppds foomatic-db-ppds gsfonts gutenprint", a dependency of "manjaro-printer"
warning: cannot resolve "expat gcc-libs glibc libdrm libelf libglvnd libomxil-bellagio libx11 libxcb libxext libxfixes libxshmfence libxxf86vm llvm-libs lm_sensors wayland zlib zstd", a dependency of "mesa"
warning: cannot resolve "gcc-libs glibc iniparser json-c keyutils kmod libicui18n.so libicuuc.so libncursesw.so=6-64 libreadline.so=8-64 libtraceevent libtracefs ncurses readline systemd-libs taglib util-linux-libs", a dependency of "ndctl"
warning: cannot resolve "gmp jansson libmnl libnftnl ncurses readline", a dependency of "nftables"
warning: cannot resolve "libcap-ng libcap-ng.so=0-64 libcrypto.so=3-64 liblzo2.so=2-64 libnl libnl-3.so=200-64 libnl-genl-3.so=200-64 libpkcs11-helper.so=1-64 libssl.so=3-64 libsystemd.so=0-64 lz4 lzo openssl pkcs11-helper systemd-libs", a dependency of "openvpn"
warning: cannot resolve "db5.3 gdbm>=1.17 glibc libcrypt.so=2-64 libxcrypt", a dependency of "perl"
warning: cannot resolve "python python-cachetools python-certifi python-oauth2client python-packaging python-pyasn1-modules python-rsa", a dependency of "python-google-auth"
warning: cannot resolve "alsa-lib glibc libasound.so=2-64 qemu-common=9.0.2-1", a dependency of "qemu-audio-alsa"
warning: cannot resolve "gcc-libs glib2 glibc libgio-2.0.so=0-64 libglib-2.0.so=0-64 libgobject-2.0.so=0-64 qemu-common=9.0.2-1", a dependency of "qemu-audio-dbus"
warning: cannot resolve "gcc-libs glibc jack libjack.so=0-64 qemu-common=9.0.2-1", a dependency of "qemu-audio-jack"
warning: cannot resolve "glibc qemu-common=9.0.2-1", a dependency of "qemu-audio-oss"
warning: cannot resolve "glibc libpulse libpulse.so=0-64 qemu-common=9.0.2-1", a dependency of "qemu-audio-pa"
warning: cannot resolve "gcc-libs glibc libpipewire libpipewire-0.3.so=0-64 qemu-common=9.0.2-1", a dependency of "qemu-audio-pipewire"
warning: cannot resolve "glibc qemu-common=9.0.2-1 sdl2", a dependency of "qemu-audio-sdl"
warning: cannot resolve "glibc libspice-server.so=1-64 qemu-common=9.0.2-1 qemu-ui-spice-core=9.0.2-1 spice", a dependency of "qemu-audio-spice"
warning: cannot resolve "qemu-common=9.0.2-1 qemu-img=9.0.2-1 qemu-system-x86=9.0.2-1 virtiofsd", a dependency of "qemu-base"
warning: cannot resolve "curl gcc-libs glibc libcurl.so=4-64 qemu-common=9.0.2-1", a dependency of "qemu-block-curl"
warning: cannot resolve "bzip2 glibc libbz2.so=1.0-64 qemu-common=9.0.2-1", a dependency of "qemu-block-dmg"
warning: cannot resolve "gcc-libs glibc libnfs qemu-common=9.0.2-1", a dependency of "qemu-block-nfs"
warning: cannot resolve "gcc-libs glibc libssh libssh.so=4-64 qemu-common=9.0.2-1", a dependency of "qemu-block-ssh"
warning: cannot resolve "glibc libspice-server.so=1-64 qemu-common=9.0.2-1 qemu-ui-spice-core=9.0.2-1 spice", a dependency of "qemu-chardev-spice"
warning: cannot resolve "gcc-libs glib2 glibc hicolor-icon-theme libcap-ng libcap-ng.so=0-64 libglib-2.0.so=0-64 libgmodule-2.0.so=0-64 libnuma.so=1-64 numactl", a dependency of "qemu-common"
warning: cannot resolve "qemu-audio-alsa=9.0.2-1 qemu-audio-dbus=9.0.2-1 qemu-audio-jack=9.0.2-1 qemu-audio-oss=9.0.2-1 qemu-audio-pa=9.0.2-1 qemu-audio-pipewire=9.0.2-1 qemu-audio-sdl=9.0.2-1 qemu-audio-spice=9.0.2-1 qemu-base=9.0.2-1 qemu-block-curl=9.0.2-1 qemu-block-dmg=9.0.2-1 qemu-block-nfs=9.0.2-1 qemu-block-ssh=9.0.2-1 qemu-chardev-spice=9.0.2-1 qemu-hw-display-qxl=9.0.2-1 qemu-hw-display-virtio-gpu-gl=9.0.2-1 qemu-hw-display-virtio-gpu-pci-gl=9.0.2-1 qemu-hw-display-virtio-gpu-pci=9.0.2-1 qemu-hw-display-virtio-gpu=9.0.2-1 qemu-hw-display-virtio-vga-gl=9.0.2-1 qemu-hw-display-virtio-vga=9.0.2-1 qemu-hw-usb-host=9.0.2-1 qemu-hw-usb-redirect=9.0.2-1 qemu-hw-usb-smartcard=9.0.2-1 qemu-ui-curses=9.0.2-1 qemu-ui-dbus=9.0.2-1 qemu-ui-egl-headless=9.0.2-1 qemu-ui-gtk=9.0.2-1 qemu-ui-opengl=9.0.2-1 qemu-ui-sdl=9.0.2-1 qemu-ui-spice-app=9.0.2-1 qemu-ui-spice-core=9.0.2-1 qemu-vhost-user-gpu=9.0.2-1", a dependency of "qemu-desktop"
warning: cannot resolve "gcc-libs glib2 glibc libglib-2.0.so=0-64 libgmodule-2.0.so=0-64 libnuma.so=1-64 libudev.so=1-64 liburing liburing.so=2-64 numactl sh systemd-libs", a dependency of "qemu-guest-agent"
warning: cannot resolve "gcc-libs glibc libpixman-1.so=0-64 libspice-server.so=1-64 pixman qemu-common=9.0.2-1 qemu-ui-spice-core=9.0.2-1 spice usbredir", a dependency of "qemu-hw-display-qxl"
warning: cannot resolve "glibc libpixman-1.so=0-64 pixman qemu-common=9.0.2-1 usbredir", a dependency of "qemu-hw-display-virtio-gpu"
warning: cannot resolve "glibc qemu-common=9.0.2-1 usbredir virglrenderer", a dependency of "qemu-hw-display-virtio-gpu-gl"
warning: cannot resolve "qemu-common=9.0.2-1 usbredir", a dependency of "qemu-hw-display-virtio-gpu-pci"
warning: cannot resolve "qemu-common=9.0.2-1 usbredir", a dependency of "qemu-hw-display-virtio-gpu-pci-gl"
warning: cannot resolve "qemu-common=9.0.2-1 usbredir zstd", a dependency of "qemu-hw-display-virtio-vga"
warning: cannot resolve "qemu-common=9.0.2-1 usbredir", a dependency of "qemu-hw-display-virtio-vga-gl"
warning: cannot resolve "glibc libusb libusb-1.0.so=0-64 qemu-common=9.0.2-1 usbredir", a dependency of "qemu-hw-usb-host"
warning: cannot resolve "gcc-libs glibc qemu-common=9.0.2-1 usbredir", a dependency of "qemu-hw-usb-redirect"
warning: cannot resolve "gcc-libs glib2 glibc libcacard libglib-2.0.so=0-64 qemu-common=9.0.2-1 usbredir", a dependency of "qemu-hw-usb-smartcard"
warning: cannot resolve "fuse3 gcc-libs glib2 glibc gnutls libaio libglib-2.0.so=0-64 libgmodule-2.0.so=0-64 libnuma.so=1-64 libpam.so=0-64 liburing liburing.so=2-64 libzstd.so=1-64 numactl pam zlib zstd", a dependency of "qemu-img"
warning: cannot resolve "capstone dtc edk2-ovmf fuse3 gcc-libs glib2 glibc gnutls keyutils libaio libbpf libbpf.so=1-64 libelf libgio-2.0.so=0-64 libglib-2.0.so=0-64 libgmodule-2.0.so=0-64 libjpeg-turbo libjpeg.so=8-64 libnuma.so=1-64 libpam.so=0-64 libpixman-1.so=0-64 libpng libsasl libseccomp libseccomp.so=2-64 libslirp libslirp.so=0-64 libudev.so=1-64 liburing liburing.so=2-64 libxdp libxdp.so=1-64 libzstd.so=1-64 lzo ndctl numactl pam pixman qemu-common=9.0.2-1 qemu-system-x86-firmware=9.0.2-1 seabios snappy systemd-libs vde2 zlib zstd", a dependency of "qemu-system-x86"
warning: cannot resolve "gcc-libs glib2 glibc libglib-2.0.so=0-64 libncursesw.so=6-64 ncurses qemu-common=9.0.2-1", a dependency of "qemu-ui-curses"
warning: cannot resolve "gcc-libs glib2 glibc libepoxy libgio-2.0.so=0-64 libglib-2.0.so=0-64 libgobject-2.0.so=0-64 libpixman-1.so=0-64 pixman qemu-common=9.0.2-1", a dependency of "qemu-ui-dbus"
warning: cannot resolve "glibc libepoxy libpixman-1.so=0-64 pixman qemu-common=9.0.2-1 qemu-ui-opengl=9.0.2-1", a dependency of "qemu-ui-egl-headless"
warning: cannot resolve "cairo gdk-pixbuf2 glib2 glibc gtk3 libepoxy libgdk-3.so=0-64 libgdk_pixbuf-2.0.so=0-64 libglib-2.0.so=0-64 libgobject-2.0.so=0-64 libgtk-3.so=0-64 libpixman-1.so=0-64 libvte-2.91.so=0-64 libx11 pixman qemu-common=9.0.2-1 qemu-ui-opengl vte3", a dependency of "qemu-ui-gtk"
warning: cannot resolve "gcc-libs glibc libepoxy libpixman-1.so=0-64 mesa pixman qemu-common=9.0.2-1", a dependency of "qemu-ui-opengl"
warning: cannot resolve "glib2 glibc libglib-2.0.so=0-64 libpixman-1.so=0-64 libx11 pixman qemu-common=9.0.2-1 sdl2 sdl2_image", a dependency of "qemu-ui-sdl"
warning: cannot resolve "glib2 glibc libgio-2.0.so=0-64 libglib-2.0.so=0-64 qemu-chardev-spice=9.0.2-1 qemu-common=9.0.2-1 qemu-ui-spice-core=9.0.2-1", a dependency of "qemu-ui-spice-app"
warning: cannot resolve "gcc-libs glibc libpixman-1.so=0-64 libspice-server.so=1-64 pixman qemu-common=9.0.2-1 qemu-ui-opengl=9.0.2-1 spice", a dependency of "qemu-ui-spice-core"
warning: cannot resolve "gcc-libs glib2 glibc libepoxy libglib-2.0.so=0-64 libgmodule-2.0.so=0-64 libnuma.so=1-64 libpixman-1.so=0-64 mesa numactl pixman qemu-common=9.0.2-1 virglrenderer", a dependency of "qemu-vhost-user-gpu"
warning: cannot resolve "double-conversion fontconfig libcups libgl libinput libjpeg-turbo libproxy libxi libxkbcommon-x11 libxrender md4c mesa qt5-translations shared-mime-info sqlite tslib xcb-util-image xcb-util-keysyms xcb-util-renderutil xcb-util-wm xdg-utils", a dependency of "qt5-base"
warning: cannot resolve "gcc-libs glibc libglvnd libxkbcommon qt6-base qt6-declarative wayland", a dependency of "qt6-wayland"
warning: cannot resolve "glibc hidapi libgl libusb libx11 libxcursor libxext libxrender", a dependency of "sdl2"
warning: cannot resolve "gcc-libs python-pe%FILENAME%", a dependency of "thin-provisioning-tools"
warning: cannot resolve "gcc-libs glibc libcap-ng libseccomp", a dependency of "virtiofsd"
warning: cannot resolve "VIRTUALBOX-GUEST-MODULES glibc libx11 libxcomposite libxdamage libxext libxfixes libxmu libxt pam xf86-video-vmware xorg-xrandr", a dependency of "virtualbox-guest-utils"
:: The following packages cannot be upgraded due to unresolvable dependencies:
      device-mapper  firefox  imlib2  iproute2  libfprint  libnftnl  libproxy  libxml2  llvm-libs  logrotate  lvm2  manjaro-printer  mesa  ndctl  nftables  openvpn  perl  python-google-auth  qemu-audio-alsa
      qemu-audio-dbus  qemu-audio-jack  qemu-audio-oss  qemu-audio-pa  qemu-audio-pipewire  qemu-audio-sdl  qemu-audio-spice  qemu-base  qemu-block-curl  qemu-block-dmg  qemu-block-nfs  qemu-block-ssh
      qemu-chardev-spice  qemu-common  qemu-desktop  qemu-guest-agent  qemu-hw-display-qxl  qemu-hw-display-virtio-gpu  qemu-hw-display-virtio-gpu-gl  qemu-hw-display-virtio-gpu-pci
      qemu-hw-display-virtio-gpu-pci-gl  qemu-hw-display-virtio-vga  qemu-hw-display-virtio-vga-gl  qemu-hw-usb-host  qemu-hw-usb-redirect  qemu-hw-usb-smartcard  qemu-img  qemu-system-x86  qemu-ui-curses
      qemu-ui-dbus  qemu-ui-egl-headless  qemu-ui-gtk  qemu-ui-opengl  qemu-ui-sdl  qemu-ui-spice-app  qemu-ui-spice-core  qemu-vhost-user-gpu  qt5-base  qt6-wayland  sdl2  thin-provisioning-tools  virtiofsd
      virtualbox-guest-utils

:: Do you want to skip the above packages for this upgrade? [y/N] 

[philmmanjaro]

@LordTermor was the database created by Arch"s repo-add script or somehow exported from some SQL database and misses some entries?

[LordTermor]

@LordTermor was the database created by Arch"s repo-add script or somehow exported from some SQL database and misses some entries?

LMDB is a NoSQL key-value database but no, you can check pool folder, it also misses some entries, I'm going to dig into that and check what's wrong.

[philmmanjaro]

I mean does your solution also add so-dependencies like libudev.so=1-64.

[yochananmarqos]

Current status:

:: Synchronizing package databases...
 core is up to date
 extra                                                                                              2.0 KiB  2.34 KiB/s 00:01 [############################################################################] 100%
 multilib is up to date
:: Starting full system upgrade...
warning: 389-ds-base: unknown key '%BACKUP%' in sync database
error: multilib database is inconsistent: name mismatch on package lib
resolving dependencies...
warning: cannot resolve "glibc libudev.so=1-64 systemd-libs", a dependency of "device-mapper"
:: The following package cannot be upgraded due to unresolvable dependencies:
      device-mapper

:: Do you want to skip the above package for this upgrade? [y/N] 

[LordTermor]

error: multilib database is inconsistent: name mismatch on package lib

This part is still not obvious to me and needs further debugging...

warning: cannot resolve "glibc libudev.so=1-64 systemd-libs", a dependency of "device-mapper"

This should be fixed now, I need to regenerate mirrors.

[romangg]

warning: cannot resolve "glibc libudev.so=1-64 systemd-libs", a dependency of "device-mapper"

This should be fixed now, I need to regenerate mirrors.

@yochananmarqos with that does updating work for you now? Or is

error: multilib database is inconsistent: name mismatch on package lib

still breaking your updates?

[yochananmarqos]

@romangg

still breaking your updates?

No, this issue was resolved, however the discussion was in Matrix instead of here on GitHub.

There are two other issues that we've also discussed on Matrix. If there is not already an existing issue, I will create one later.