Arch Linux

Piggered

Member

Registered: 2024-05-05

Posts: 2

[SOLVED] error: failed to commit transaction (could not find or ...)

I've been having this problem every time I upgrade a significant number of packages (>10) for about 2 years. My workaround thus far has been to repeatedly run sudo pacman -Syu until the error does not occur anymore (usually 4-5 times) and it's pretty annoying to do.

Here's the pacman debug log: https://pigge.red/random/2025-07-22-17- … -debug.txt
(This is happening with other packages as well, not just sqlite.)

I've tried—when attempting to troubleshoot this issue—clearing the Pacman cache using sudo pacman -Scc and updating my mirrors using both reflector and Pacman Mirrorlist Generator. I'm also on Ethernet with a Gigabit plan. My terrible laptop with a terrible Wi-Fi card does not have this issue.

The reflector command I use is:

sudo reflector --verbose --sort rate -l 20 -c Canada --save /etc/pacman.d/mirrorlist

Here's my current and latest mirrorlist:

##
## Arch Linux repository mirrorlist
## Filtered by mirror score from mirror status page
## Generated on 2025-07-22
##

# Canada
Server = http://mirror.scd31.com/arch/$repo/os/$arch
# Canada
Server = http://muug.ca/mirror/archlinux/$repo/os/$arch
# Canada
Server = http://mirror.its.dal.ca/archlinux/$repo/os/$arch
# Canada
Server = https://mirror.cpsc.ucalgary.ca/mirror/archlinux.org/$repo/os/$arch
# Canada
Server = https://mirror.quantum5.ca/archlinux/$repo/os/$arch
# Canada
Server = http://mirror.xenyth.net/archlinux/$repo/os/$arch
# Canada
Server = https://mirror.xenyth.net/archlinux/$repo/os/$arch
# Canada
Server = https://muug.ca/mirror/archlinux/$repo/os/$arch
# Canada
Server = https://mirror.scd31.com/arch/$repo/os/$arch
# Canada
Server = http://mirror.quantum5.ca/archlinux/$repo/os/$arch
# Canada
Server = http://mirror.0xem.ma/arch/$repo/os/$arch
# Canada
Server = http://archlinux.mirror.rafal.ca/$repo/os/$arch
# Canada
Server = http://mirrors.pablonara.com/archlinux/$repo/os/$arch
# Canada
Server = https://mirror.franscorack.com/archlinux/$repo/os/$arch
# Canada
Server = https://arch.mirror.winslow.cloud/$repo/os/$arch
# Canada
Server = https://upstream-1.pablonara.com/archlinux/$repo/os/$arch
# Canada
Server = https://mirrors.pablonara.com/archlinux/$repo/os/$arch
# Canada
Server = https://mirror.acadielinux.ca/mirror/arch/$repo/os/$arch
# Canada
Server = https://mirror2.evolution-host.com/archlinux/$repo/os/$arch
# Canada
Server = https://ca.mirrors.cicku.me/archlinux/$repo/os/$arch
# Canada
Server = https://mirror.csclub.uwaterloo.ca/archlinux/$repo/os/$arch
# Canada
Server = http://ca.mirrors.cicku.me/archlinux/$repo/os/$arch
# Canada
Server = http://mirror2.evolution-host.com/archlinux/$repo/os/$arch
# Canada
Server = https://mirror.0xem.ma/arch/$repo/os/$arch
# Canada
Server = http://mirror.cpsc.ucalgary.ca/mirror/archlinux.org/$repo/os/$arch
# Canada
Server = http://mirror.csclub.uwaterloo.ca/archlinux/$repo/os/$arch

Here's my pacman.conf file:

#
# /etc/pacman.conf
#
# See the pacman.conf(5) manpage for option and repository directives

#
# GENERAL OPTIONS
#
[options]
# The following paths are commented out with their default values listed.
# If you wish to use different paths, uncomment and update the paths.
#RootDir     = /
#DBPath      = /var/lib/pacman/
#CacheDir    = /var/cache/pacman/pkg/
#LogFile     = /var/log/pacman.log
#GPGDir      = /etc/pacman.d/gnupg/
#HookDir     = /etc/pacman.d/hooks/
HoldPkg     = pacman-git glibc
#XferCommand = /usr/bin/curl -L -C - -f -o %o %u
#XferCommand = /usr/bin/wget --passive-ftp -c -O %o %u
#CleanMethod = KeepInstalled
Architecture = auto

# Pacman won't upgrade packages listed in IgnorePkg and members of IgnoreGroup
#IgnorePkg   =
#IgnoreGroup =

#NoUpgrade   =
#NoExtract   =

# Misc options
#UseSyslog
Color
#NoProgressBar
CheckSpace
#VerbosePkgLists
ParallelDownloads = 10

# By default, pacman accepts packages signed by keys that its local keyring
# trusts (see pacman-key and its man page), as well as unsigned packages.
SigLevel    = Required DatabaseOptional
LocalFileSigLevel = Optional
#RemoteFileSigLevel = Required

# NOTE: You must run `pacman-key --init` before first using pacman; the local
# keyring can then be populated with the keys of all official Arch Linux
# packagers with `pacman-key --populate archlinux`.

#
# REPOSITORIES
#   - can be defined here or included from another file
#   - pacman will search repositories in the order defined here
#   - local/custom mirrors can be added here or in separate files
#   - repositories listed first will take precedence when packages
#     have identical names, regardless of version number
#   - URLs will have $repo replaced by the name of the current repo
#   - URLs will have $arch replaced by the name of the architecture
#
# Repository entries are of the format:
#       [repo-name]
#       Server = ServerName
#       Include = IncludePath
#
# The header [repo-name] is crucial - it must be present and
# uncommented to enable the repo.
#

# The testing repositories are disabled by default. To enable, uncomment the
# repo name header and Include lines. You can add preferred servers immediately
# after the header, and they will be used before the default mirrors.

#[testing]
#Include = /etc/pacman.d/mirrorlist

[core]
Include = /etc/pacman.d/mirrorlist

[extra]
Include = /etc/pacman.d/mirrorlist

#[community-testing]
#Include = /etc/pacman.d/mirrorlist

#[community]
#Include = /etc/pacman.d/mirrorlist

# If you want to run 32 bit applications on your x86_64 system,
# enable the multilib repositories as required here.

#[multilib-testing]
#Include = /etc/pacman.d/mirrorlist

[multilib]
Include = /etc/pacman.d/mirrorlist

# An example of a custom package repository.  See the pacman manpage for
# tips on creating your own repositories.
#[custom]
#SigLevel = Optional TrustAll
#Server = file:///home/custompkgs

Last edited by Piggered (2025-07-22 23:02:42)

Scimmia

Fellow

Registered: 2012-09-01

Posts: 13,354

Re: [SOLVED] error: failed to commit transaction (could not find or ...)

Well first thing, you are running a very old pacman-git package, you need to either update it manually or switch back to the normal pacman package.

Piggered

Member

Registered: 2024-05-05

Posts: 2

Re: [SOLVED] error: failed to commit transaction (could not find or ...)

Well first thing, you are running a very old pacman-git package, you need to either update it manually or switch back to the normal pacman package.

Just switched to the normal pacman package, and I've successfully upgraded my system without any errors this time.

It has never occurred to me that I've been running some old pacman-git version. If that's the actual cause of this issue, I'm going to feel really stupid now.