Bug 1868860 - Error: SQLite error on "/var/lib/dnf/history.sqlite": Reading a row failed: database disk image is malformed" [NEEDINFO]
Summary: Error: SQLite error on "/var/lib/dnf/history.sqlite": Reading a row failed: d...
Keywords:
Status: CLOSED EOL
Alias: None
Product: Fedora
Classification: Fedora
Component: dnf
Version: 35
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
Assignee: rpm-software-management
QA Contact: Fedora Extras Quality Assurance
URL:
Whiteboard:
: 2073061 (view as bug list)
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2020-08-14 03:42 UTC by D. Hugh Redelmeier
Modified: 2024-02-19 17:43 UTC (History)
24 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2022-12-13 15:15:39 UTC
Type: Bug
Embargoed:
hugh: needinfo? (nkv994)


Attachments (Terms of Use)
broken version of /var/lib/dnf/history.sqlite (4.60 MB, application/x-sqlite3)
2020-08-14 03:42 UTC, D. Hugh Redelmeier
no flags Details
SQL dump of /var/lib/dnf/history.sqlite (917.27 KB, text/plain)
2020-09-13 23:14 UTC, Noel Duffy
no flags Details

Description D. Hugh Redelmeier 2020-08-14 03:42:41 UTC
Created attachment 1711409 [details]
broken version of /var/lib/dnf/history.sqlite

Description of problem:
When I run "dnf update", I get
  Error: SQLite error on "/var/lib/dnf/history.sqlite": Reading a row failed: database disk image is malformed

Version-Release number of selected component (if applicable):
dnf-4.2.23-1.fc32.noarch

How reproducible:
Without intervention, this error persists.
It turns out that I can fix the problem with:
  sudo rm /var/lib/dnf/history.sqlite
I have no idea if this causes damage.

Steps to Reproduce:
1. sudo dnf update

Actual results:
Error: SQLite error on "/var/lib/dnf/history.sqlite": Reading a row failed: database disk image is malformed



Expected results:
a normal update.


Additional info:
- SQLite know that there's something wrong:

 echo 'PRAGMA integrity_check;' | sudo sqlite3 /var/lib/dnf/history.sqlite
*** in database main ***
Fragmentation of 5 bytes reported as 0 on page 1092
Error: near line 1: database disk image is malformed

- this is something like https://bugzilla.redhat.com/show_bug.cgi?id=1669824

- also reported a while back on the fedora-users mailing list
http://fedora.12.x6.nabble.com/DNF-Update-this-morning-tt5096957.html#none

Comment 1 Lukáš Hrázký 2020-08-17 11:28:16 UTC
Hello, unfortunately the database is corrupted (which can happen when you run out of disk space or in a crash) and there is no backup mechanism in place to restore it. As you've correctly determined, you can remove the file to get rid of the error. By removing the database, you will lose all transaction history, as well as the reasons for installed packages (meaning all your installed packages will be considered userinstalled and will not be auto-removed when cleaning dependencies) and also installed groups.

Sorry, we can't offer a better solution at the moment.

Keeping the bug around as we should eventually provide a more robust solution for this database corruption.

Comment 2 Noel Duffy 2020-09-13 23:12:56 UTC
Somehow I've reproduced this problem, or a variant thereof, without either a crash or running out of disk space. 

$ dnf remove x265
Error: SQLite error on "/var/lib/dnf/history.sqlite": Reading a row failed: database disk image is malformed

However, the ways that a database can be corrupt are legion.

$ echo 'PRAGMA integrity_check;' | sqlite3 /var/lib/dnf/history.sqlite
*** in database main ***
On tree page 236 cell 57: Rowid 4840 out of order
Multiple uses for byte 3142 of page 236

Following the dump/restore test in #1669824, sqlite complained that my problem was a duplicate transaction.

$ sqlite3 history.sqlite ".dump" |sqlite3 history-new.sqlite
Error: near line 8859: UNIQUE constraint failed: trans_item.id

And lines 8858 and 8859 from the sql are:

INSERT INTO trans_item VALUES(4840,52,2261,5,7,1,1);
INSERT INTO trans_item VALUES(4840,52,2261,5,7,1,1);

I deleted one of the rows from the sql and ran:

$ sqlite3 history2.sqlite < h.sql

Then I replaced history.sqlite with history2.sqlite, and now dnf is working again.

I can't imagine what would have caused this problem. I was running some commands to search for and install packages, some without sudo, some with, which I realise is vague, but beyond that I cannot think of anything that was even slightly untoward or unusual about what I was doing.

I'll upload the sql dump as an attachment in case it's of use. Certainly it's beyond my abilities to debug it any further.

Comment 3 Noel Duffy 2020-09-13 23:14:26 UTC
Created attachment 1714704 [details]
SQL dump of /var/lib/dnf/history.sqlite

This is a sql dump of history.sqlite showing the duplicate transaction.

Comment 4 Karim Sultan 2020-11-02 19:31:55 UTC
I also encountered this bug while attempting to upgrade from Fedora 31 to Fedora 32:

[root@circus ~]# dnf system-upgrade download --releasever=32
Before you continuee ensure that your system is fully upgraded by running "dnf --refresh upgrade". Do you want to continue [y/N]: y
Fedora 32 - x86_64 - Updates [...]
[...]
Error: SQLite error on "var/lib/dnf/history.sqlite": Reading a row failed: database disk image is malformed

Running the integrity check did not report duplicate rows.
My only way around this was to delete the database, which is not a good solution.
Once deleted, the system upgrade completed.

NOTE: No disk crashes or space issues on Circus; over 1 TB space available on root partition.

Comment 5 Jan Škrle 2020-12-06 18:17:58 UTC
I also encountered problem today. Also no crash and plenty space on disk.

Comment 6 Mirko Predosin 2020-12-13 20:51:35 UTC
I encountered the same issue when attempting a system upgrade from FC32 -> FC33.

sudo dnf system-upgrade download --refresh --releasever=33

I was able to resolve it by identifying the problem with the database and repairing it.  I strongly recommend backing up the database before attempting any repair operation.

# backup db
cp /var/lib/dnf/history.sqlite ~/tmp/

# load db as root
sudo sqlite3 /var/lib/dnf/history.sqlite
SQLite version 3.34.0 2020-12-01 16:14:00
Enter ".help" for usage hints.

# check db
sqlite> PRAGMA integrity_check;
row 4768 missing from index trans_item_item_id

# repair index
sqlite> reindex trans_item_item_id;

# check db
sqlite> PRAGMA integrity_check;
ok
sqlite>

Comment 7 Jan ONDREJ 2021-01-30 16:48:34 UTC
Same problem here and I didn't do any system-upgrade, just normal dnf update on my f32 system.

dnf in versbose mode outputs:

SQL statement being executed:                                                   
        SELECT                                                                  
            ti.action as action,                                                
            ti.reason as reason                                                 
        FROM                                                                    
            trans_item ti                                                       
        JOIN                                                                    
            trans t ON ti.trans_id = t.id                                       
        JOIN                                                                    
            rpm i USING (item_id)                                               
        WHERE                                                                   
            t.state = 1                                                         
            /* see comment in TransactionItem.hpp - TransactionItemAction */    
            AND ti.action not in (3, 5, 7, 10)                                 
            AND i.name = 'vim-minimal'
            AND i.arch = 'x86_64'
        ORDER BY
            ti.trans_id DESC
        LIMIT 1
     
Error: SQLite error on "/var/lib/dnf/history.sqlite": Reading a row failed: data
base disk image is malformed

I am trying to run this SELECT partially in sqlite with curious results (passes, returns some rows without error):

SELECT 1 FROM trans_item ti JOIN trans t ON ti.trans_id = t.id JOIN rpm i USING (item_id);
SELECT rpm.name FROM rpm;
SELECT * FROM rpm;
SELECT * FROM trans;

This fails:

SELECT i.name FROM trans_item ti JOIN trans t ON ti.trans_id = t.id JOIN rpm i USING (item_id);

I don't know, what's wrong on this i.name column. :-(
I have a copy of this broken sqlite file, if someone needs more testing.


As a workaround, I can recover my history.sqlite file with these commands:

# sqlite3 /var/lib/dnf/history.sqlite 
SQLite version 3.34.0 2020-12-01 16:14:00
Enter ".help" for usage hints.
sqlite> .output /tmp/history.sql
sqlite> .dump
sqlite> .quit
# mv /var/lib/dnf/history.sqlite /tmp/
# sqlite3 /var/lib/dnf/history.sqlite < /tmp/history.sql

After this, dnf history works with older items and my database was repaired.

Comment 8 customercare 2021-03-08 15:26:33 UTC
[dnf]# echo 'PRAGMA integrity_check;' | sqlite3 /var/lib/dnf/history.sqlite
*** in database main ***
On tree page 359 cell 170: invalid page number 34889508
Multiple uses for byte 2104 of page 359
Error: near line 1: database disk image is malformed


Export and Import of the entire db and replacing the defective sqlite file, solved it for me.

this server never had a full disk, so something got wrong, somewhere else.

Comment 9 John Apple II 2021-04-29 01:56:32 UTC
(In reply to customercare from comment #8)
> [dnf]# echo 'PRAGMA integrity_check;' | sqlite3 /var/lib/dnf/history.sqlite
> *** in database main ***
> On tree page 359 cell 170: invalid page number 34889508
> Multiple uses for byte 2104 of page 359
> Error: near line 1: database disk image is malformed
> 
> 
> Export and Import of the entire db and replacing the defective sqlite file,
> solved it for me.
> 
> this server never had a full disk, so something got wrong, somewhere else.

Same here - just hit this upgrading an F32 box today. 

Exporting and importing the sqlitedb using the commands from Comment 7 worked perfectly! now the upgrade is running without issues!

Comment 10 Fedora Program Management 2021-04-29 16:35:45 UTC
This message is a reminder that Fedora 32 is nearing its end of life.
Fedora will stop maintaining and issuing updates for Fedora 32 on 2021-05-25.
It is Fedora's policy to close all bug reports from releases that are no longer
maintained. At that time this bug will be closed as EOL if it remains open with a
Fedora 'version' of '32'.

Package Maintainer: If you wish for this bug to remain open because you
plan to fix it in a currently maintained version, simply change the 'version' 
to a later Fedora version.

Thank you for reporting this issue and we are sorry that we were not 
able to fix it before Fedora 32 is end of life. If you would still like 
to see this bug fixed and are able to reproduce it against a later version 
of Fedora, you are encouraged  change the 'version' to a later Fedora 
version prior this bug is closed as described in the policy above.

Although we aim to fix as many bugs as possible during every release's 
lifetime, sometimes those efforts are overtaken by events. Often a 
more recent Fedora release includes newer upstream software that fixes 
bugs or makes them obsolete.

Comment 11 Ben Cotton 2021-05-25 16:38:57 UTC
Fedora 32 changed to end-of-life (EOL) status on 2021-05-25. Fedora 32 is
no longer maintained, which means that it will not receive any further
security or bug fix updates. As a result we are closing this bug.

If you can reproduce this bug against a currently maintained version of
Fedora please feel free to reopen this bug against that version. If you
are unable to reopen this bug, please file a new report against the
current release. If you experience problems, please add a comment to this
bug.

Thank you for reporting this bug and we are sorry it could not be fixed.

Comment 12 Parag Nemade 2021-10-28 04:03:23 UTC
I am getting this error since 2 weeks now on Fedora 35.

Comment 13 Jeff 2021-12-09 02:37:32 UTC
I just encountered the same error

SQLite error on "/var/lib/dnf/history.sqlite": Reading a row failed: FOREIGN KEY constraint failed

This was a new vanilla install of Fedora 35 on a VM.
The only thing done after the install was "sudo dnf upgrade -y" and it fails at the running transaction step with the above error.

As noted above, I removed /var/lib/dnf/history.sqlite and it then continued with the transaction.

To me this appears an error in the installation of dnf (or rpm) in creating the database without properly defining the constraints.  The FOREIGN KEY error tells me there is another table that is referenced but one of the two is not properly defined and initially created..

Comment 14 Ben 2022-02-06 11:19:38 UTC
Today I have encountered this error on Fedora 35.

I ran `dnf mc && dnf up`. Later when I tried to `dnf rm` a package I got the follwing:

Error: SQLite error on "/var/lib/dnf/history.sqlite": Reading a row failed: database disk image is malformed

Comment 15 Lukáš Hrázký 2022-04-26 09:27:32 UTC
*** Bug 2073061 has been marked as a duplicate of this bug. ***

Comment 16 Lukáš Hrázký 2022-04-26 09:29:53 UTC
As a last resort, steps for attempting a manual repair of a corrupted sqlite database (under root, you may need to install the sqlite3 binary via `dnf install -y sqlite`):
# cd /var/lib/dnf
# ls
history.sqlite  history.sqlite-shm  history.sqlite-wal  repos
# mkdir db-backup
# mv history.sqlite* db-backup
# echo .recover | sqlite3 db-backup/history.sqlite > recover.sql
# sqlite3 history.sqlite < recover.sql

Comment 17 Ben Cotton 2022-11-29 16:49:19 UTC
This message is a reminder that Fedora Linux 35 is nearing its end of life.
Fedora will stop maintaining and issuing updates for Fedora Linux 35 on 2022-12-13.
It is Fedora's policy to close all bug reports from releases that are no longer
maintained. At that time this bug will be closed as EOL if it remains open with a
'version' of '35'.

Package Maintainer: If you wish for this bug to remain open because you
plan to fix it in a currently maintained version, change the 'version' 
to a later Fedora Linux version.

Thank you for reporting this issue and we are sorry that we were not 
able to fix it before Fedora Linux 35 is end of life. If you would still like 
to see this bug fixed and are able to reproduce it against a later version 
of Fedora Linux, you are encouraged to change the 'version' to a later version
prior to this bug being closed.

Comment 18 Ben Cotton 2022-12-13 15:15:39 UTC
Fedora Linux 35 entered end-of-life (EOL) status on 2022-12-13.

Fedora Linux 35 is no longer maintained, which means that it
will not receive any further security or bug fix updates. As a result we
are closing this bug.

If you can reproduce this bug against a currently maintained version of Fedora Linux
please feel free to reopen this bug against that version. Note that the version
field may be hidden. Click the "Show advanced fields" button if you do not see
the version field.

If you are unable to reopen this bug, please file a new report against an
active release.

Thank you for reporting this bug and we are sorry it could not be fixed.

Comment 19 nkv994 2024-02-19 13:49:04 UTC
This is replication of a similar error if not the same error in Fedora Workstation 39.






<Console>

nikhil@fedora:~$ su -
Password: 
root@fedora:~# cd /var/lib/yum/yumdb
-bash: cd: /var/lib/yum/yumdb: No such file or directory
root@fedora:~# cd /var/lib/yum/
-bash: cd: /var/lib/yum/: No such file or directory
root@fedora:~# cd /var/lib/dnf
root@fedora:/var/lib/dnf# ls
history.sqlite  history.sqlite-shm  history.sqlite-wal  repos
root@fedora:/var/lib/dnf# mkdir db-backup
root@fedora:/var/lib/dnf# ls
db-backup  history.sqlite  history.sqlite-shm  history.sqlite-wal  repos
root@fedora:/var/lib/dnf# echo .recover | sqlite3 db-backup/history.sqlite > recover.sql
root@fedora:/var/lib/dnf# sqlite3 history.sqlite < recover.sql
root@fedora:/var/lib/dnf# ls
db-backup  history.sqlite  recover.sql  repos
root@fedora:/var/lib/dnf# dfm --help
bash: dfm: command not found...
root@fedora:/var/lib/dnf# dnf --help
usage: dnf [options] COMMAND

List of Main Commands:

alias                     List or create command aliases
autoremove                remove all unneeded packages that were originally installed as dependencies
check                     check for problems in the packagedb
check-update              check for available package upgrades
clean                     remove cached data
deplist                   [deprecated, use repoquery --deplist] List package's dependencies and what packages provide them
distro-sync               synchronize installed packages to the latest available versions
downgrade                 Downgrade a package
group                     display, or use, the groups information
help                      display a helpful usage message
history                   display, or use, the transaction history
info                      display details about a package or group of packages
install                   install a package or packages on your system
list                      list a package or groups of packages
makecache                 generate the metadata cache
mark                      mark or unmark installed packages as installed by user.
module                    Interact with Modules.
provides                  find what package provides the given value
reinstall                 reinstall a package
remove                    remove a package or packages from your system
repolist                  display the configured software repositories
repoquery                 search for packages matching keyword
repository-packages       run commands on top of all packages in given repository
search                    search package details for the given string
shell                     run an interactive DNF shell
swap                      run an interactive DNF mod for remove and install one spec
updateinfo                display advisories about packages
upgrade                   upgrade a package or packages on your system
upgrade-minimal           upgrade, but only 'newest' package match which fixes a problem that affects your system

List of Plugin Commands:

builddep                  Install build dependencies for package or spec file
changelog                 Show changelog data of packages
config-manager            manage dnf configuration options and repositories
copr                      Interact with Copr repositories.
debug-dump                dump information about installed rpm packages to file
debug-restore             restore packages recorded in debug-dump file
debuginfo-install         install debuginfo packages
download                  Download package to current directory
groups-manager            create and edit groups metadata file
needs-restarting          determine updated binaries that need restarting
offline-distrosync        Prepare offline distrosync of the system
offline-upgrade           Prepare offline upgrade of the system
playground                Interact with Playground repository.
repoclosure               Display a list of unresolved dependencies for repositories
repodiff                  List differences between two sets of repositories
repograph                 Output a full package dependency graph in dot format
repomanage                Manage a directory of rpm packages
reposync                  download all packages from remote repo
system-upgrade            Prepare system for upgrade to a new release

General DNF options:
  -c [config file], --config [config file]
                        config file location
  -q, --quiet           quiet operation
  -v, --verbose         verbose operation
  --version             show DNF version and exit
  --installroot [path]  set install root
  --nodocs              do not install documentations
  --noplugins           disable all plugins
  --enableplugin [plugin]
                        enable plugins by name
  --disableplugin [plugin]
                        disable plugins by name
  --releasever RELEASEVER
                        override the value of $releasever in config and repo files
  --setopt SETOPTS      set arbitrary config and repo options
  --skip-broken         resolve depsolve problems by skipping packages
  -h, --help, --help-cmd
                        show command help
  --allowerasing        allow erasing of installed packages to resolve dependencies
  -b, --best            try the best available package versions in transactions.
  --nobest              do not limit the transaction to the best candidate
  -C, --cacheonly       run entirely from system cache, don't update cache
  -R [minutes], --randomwait [minutes]
                        maximum command wait time
  -d [debug level], --debuglevel [debug level]
                        debugging output level
  --debugsolver         dumps detailed solving results into files
  --showduplicates      show duplicates, in repos, in list/search commands
  -e ERRORLEVEL, --errorlevel ERRORLEVEL
                        error output level
  --obsoletes           enables dnf's obsoletes processing logic for upgrade or display capabilities that the
                        package obsoletes for info, list and repoquery
  --rpmverbosity [debug level name]
                        debugging output level for rpm
  -y, --assumeyes       automatically answer yes for all questions
  --assumeno            automatically answer no for all questions
  --enablerepo [repo]   Temporarily enable repositories for the purpose of the current dnf command. Accepts an
                        id, a comma-separated list of ids, or a glob of ids. This option can be specified
                        multiple times.
  --disablerepo [repo]  Temporarily disable active repositories for the purpose of the current dnf command.
                        Accepts an id, a comma-separated list of ids, or a glob of ids. This option can be
                        specified multiple times, but is mutually exclusive with `--repo`.
  --repo [repo], --repoid [repo]
                        enable just specific repositories by an id or a glob, can be specified multiple times
  --enable              enable repos with config-manager command (automatically saves)
  --disable             disable repos with config-manager command (automatically saves)
  -x [package], --exclude [package], --excludepkgs [package]
                        exclude packages by name or glob
  --disableexcludes [repo], --disableexcludepkgs [repo]
                        disable excludepkgs
  --repofrompath [repo,path]
                        label and path to an additional repository to use (same path as in a baseurl), can be
                        specified multiple times.
  --noautoremove        disable removal of dependencies that are no longer used
  --nogpgcheck          disable gpg signature checking (if RPM policy allows)
  --color COLOR         control whether color is used
  --refresh             set metadata as expired before running the command
  -4                    resolve to IPv4 addresses only
  -6                    resolve to IPv6 addresses only
  --destdir DESTDIR, --downloaddir DESTDIR
                        set directory to copy packages to
  --downloadonly        only download packages
  --comment COMMENT     add a comment to transaction
  --bugfix              Include bugfix relevant packages, in updates
  --enhancement         Include enhancement relevant packages, in updates
  --newpackage          Include newpackage relevant packages, in updates
  --security            Include security relevant packages, in updates
  --advisory ADVISORY, --advisories ADVISORY
                        Include packages needed to fix the given advisory, in updates
  --bz BUGZILLA, --bzs BUGZILLA
                        Include packages needed to fix the given BZ, in updates
  --cve CVES, --cves CVES
                        Include packages needed to fix the given CVE, in updates
  --sec-severity {Critical,Important,Moderate,Low}, --secseverity {Critical,Important,Moderate,Low}
                        Include security relevant packages matching the severity, in updates
  --forcearch ARCH      Force the use of an architecture
root@fedora:/var/lib/dnf# dnf info okular
Last metadata expiration check: 0:46:29 ago on Mon 19 Feb 2024 06:08:44 PM IST.
Available Packages
Name         : okular
Version      : 23.08.4
Release      : 1.fc39
Architecture : x86_64
Size         : 5.0 M
Source       : okular-23.08.4-1.fc39.src.rpm
Repository   : updates
Summary      : A document viewer
URL          : https://www.kde.org/applications/graphics/okular/
License      : GPL-2.0-only
Description  : A document viewer.

root@fedora:/var/lib/dnf# dnf install okular
Last metadata expiration check: 0:46:40 ago on Mon 19 Feb 2024 06:08:44 PM IST.
Dependencies resolved.
==================================================================================================================
 Package                                 Architecture      Version                       Repository          Size
==================================================================================================================
Installing:
 okular                                  x86_64            23.08.4-1.fc39                updates            5.0 M
Installing dependencies:
 accounts-qml-module                     x86_64            0.7-10.fc39                   fedora              83 k
 chmlib                                  x86_64            0.40-30.fc39                  fedora              51 k
 ebook-tools-libs                        x86_64            0.2.2-25.fc39                 fedora              30 k
 kaccounts-integration                   x86_64            23.08.4-1.fc39                updates            177 k
 kdegraphics-mobipocket                  x86_64            23.08.4-1.fc39                updates             32 k
 kf5-bluez-qt                            x86_64            5.113.0-1.fc39                updates            243 k
 kf5-khtml                               x86_64            5.113.0-1.fc39                updates            2.5 M
 kf5-kjs                                 x86_64            5.113.0-1.fc39                updates            330 k
 kf5-libkexiv2                           x86_64            23.08.4-1.fc39                updates            145 k
 kf5-purpose                             x86_64            5.113.0-1.fc39                updates            566 k
 kf5-threadweaver                        x86_64            5.113.0-1.fc39                updates             75 k
 libaccounts-glib                        x86_64            1.25-13.fc39                  fedora              84 k
 libaccounts-qt5                         x86_64            1.16-8.fc39                   fedora              61 k
 libmarkdown                             x86_64            2.2.7-5.fc39                  fedora              46 k
 okular-libs                             x86_64            23.08.4-1.fc39                updates            370 k
 okular-part                             x86_64            23.08.4-1.fc39                updates            2.3 M
 phonon-qt5                              x86_64            4.11.1-12.fc39                fedora             304 k
 poppler-qt5                             x86_64            23.08.0-1.fc39                fedora             218 k
 qt5-qttools-common                      noarch            5.15.12-1.fc39                updates             11 k
 qt5-qttools-libs-designer               x86_64            5.15.12-1.fc39                updates            2.7 M
 signon                                  x86_64            8.60-13.fc39                  fedora             325 k
 signon-plugin-oauth2                    x86_64            0.24-7.fc39                   fedora              80 k
Installing weak dependencies:
 phonon-qt5-backend-gstreamer            x86_64            2:4.10.0-10.fc39              fedora             173 k

Transaction Summary
==================================================================================================================
Install  24 Packages

Total download size: 16 M
Installed size: 42 M
Is this ok [y/N]: y
Downloading Packages:
(1/24): chmlib-0.40-30.fc39.x86_64.rpm                                             13 kB/s |  51 kB     00:04    
(2/24): accounts-qml-module-0.7-10.fc39.x86_64.rpm                                 20 kB/s |  83 kB     00:04    
(3/24): ebook-tools-libs-0.2.2-25.fc39.x86_64.rpm                                 7.3 kB/s |  30 kB     00:04    
(4/24): libaccounts-glib-1.25-13.fc39.x86_64.rpm                                  235 kB/s |  84 kB     00:00    
(5/24): libaccounts-qt5-1.16-8.fc39.x86_64.rpm                                    187 kB/s |  61 kB     00:00    
(6/24): libmarkdown-2.2.7-5.fc39.x86_64.rpm                                       119 kB/s |  46 kB     00:00    
(7/24): phonon-qt5-4.11.1-12.fc39.x86_64.rpm                                      730 kB/s | 304 kB     00:00    
(8/24): phonon-qt5-backend-gstreamer-4.10.0-10.fc39.x86_64.rpm                    483 kB/s | 173 kB     00:00    
(9/24): poppler-qt5-23.08.0-1.fc39.x86_64.rpm                                     596 kB/s | 218 kB     00:00    
(10/24): signon-8.60-13.fc39.x86_64.rpm                                           1.1 MB/s | 325 kB     00:00    
(11/24): signon-plugin-oauth2-0.24-7.fc39.x86_64.rpm                              279 kB/s |  80 kB     00:00    
(12/24): kdegraphics-mobipocket-23.08.4-1.fc39.x86_64.rpm                          21 kB/s |  32 kB     00:01    
(13/24): kaccounts-integration-23.08.4-1.fc39.x86_64.rpm                           71 kB/s | 177 kB     00:02    
(14/24): kf5-bluez-qt-5.113.0-1.fc39.x86_64.rpm                                   103 kB/s | 243 kB     00:02    
(15/24): kf5-khtml-5.113.0-1.fc39.x86_64.rpm                                      891 kB/s | 2.5 MB     00:02    
(16/24): kf5-kjs-5.113.0-1.fc39.x86_64.rpm                                        145 kB/s | 330 kB     00:02    
(17/24): kf5-libkexiv2-23.08.4-1.fc39.x86_64.rpm                                   64 kB/s | 145 kB     00:02    
(18/24): kf5-purpose-5.113.0-1.fc39.x86_64.rpm                                    2.0 MB/s | 566 kB     00:00    
(19/24): kf5-threadweaver-5.113.0-1.fc39.x86_64.rpm                               294 kB/s |  75 kB     00:00    
(20/24): okular-23.08.4-1.fc39.x86_64.rpm                                         2.8 MB/s | 5.0 MB     00:01    
(21/24): okular-libs-23.08.4-1.fc39.x86_64.rpm                                    206 kB/s | 370 kB     00:01    
(22/24): okular-part-23.08.4-1.fc39.x86_64.rpm                                    1.1 MB/s | 2.3 MB     00:02    
(23/24): qt5-qttools-common-5.15.12-1.fc39.noarch.rpm                              22 kB/s |  11 kB     00:00    
(24/24): qt5-qttools-libs-designer-5.15.12-1.fc39.x86_64.rpm                      3.1 MB/s | 2.7 MB     00:00    
------------------------------------------------------------------------------------------------------------------
Total                                                                             1.1 MB/s |  16 MB     00:14     
Running transaction check
error: SELECT DISTINCT key FROM 'Requirename' ORDER BY key: 11: database disk image is malformed
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                                                          1/1 
  Installing       : signon-8.60-13.fc39.x86_64                                                              1/24 
  Installing       : signon-plugin-oauth2-0.24-7.fc39.x86_64                                                 2/24 
error: INSERT INTO 'Requirename' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Requirename' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Requirename' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Requirename' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Requirename' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Requirename' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Requirename' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Providename' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Providename' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Providename' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Providename' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Providename' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Providename' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Providename' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Providename' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Providename' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Providename' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Providename' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Providename' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Providename' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Providename' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Providename' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Providename' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Providename' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Providename' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Providename' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Providename' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Providename' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Providename' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Providename' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Providename' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Providename' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Conflictname' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Obsoletename' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Dirnames' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Dirnames' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Dirnames' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Dirnames' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Dirnames' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Dirnames' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Dirnames' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Dirnames' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Dirnames' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Dirnames' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Dirnames' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Dirnames' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Dirnames' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Dirnames' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Dirnames' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Dirnames' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Dirnames' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Dirnames' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Dirnames' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Dirnames' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Dirnames' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Dirnames' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Dirnames' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Dirnames' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Dirnames' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Dirnames' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Dirnames' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Dirnames' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Dirnames' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Dirnames' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Dirnames' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Dirnames' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Dirnames' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Dirnames' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Dirnames' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Dirnames' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Dirnames' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Installtid' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Sigmd5' VALUES(?, ?, ?): 11: database disk image is malformed
error: INSERT INTO 'Sha1header' VALUES(?, ?, ?): 11: database disk image is malformed
error: sqlite failure: RELEASE 'rwlock': database disk image is malformed
error: signon-8.60-13.fc39.x86_64: install failed

  Installing       : qt5-qttools-common-5.15.12-1.fc39.noarch                                                3/24 
error: INSERT OR REPLACE INTO 'Packages' VALUES(?, ?): 11: database disk image is malformed
error: signon-plugin-oauth2-0.24-7.fc39.x86_64: install failed

  Installing       : qt5-qttools-libs-designer-5.15.12-1.fc39.x86_64                                         4/24 
error: INSERT OR REPLACE INTO 'Packages' VALUES(?, ?): 11: database disk image is malformed
error: qt5-qttools-common-5.15.12-1.fc39.noarch: install failed

  Installing       : phonon-qt5-backend-gstreamer-2:4.10.0-10.fc39.x86_64                                    5/24 
error: INSERT OR REPLACE INTO 'Packages' VALUES(?, ?): 11: database disk image is malformed
error: qt5-qttools-libs-designer-5.15.12-1.fc39.x86_64: install failed

  Installing       : phonon-qt5-4.11.1-12.fc39.x86_64                                                        6/24 
error: INSERT OR REPLACE INTO 'Packages' VALUES(?, ?): 11: database disk image is malformed
error: phonon-qt5-backend-gstreamer-2:4.10.0-10.fc39.x86_64: install failed

  Installing       : kf5-threadweaver-5.113.0-1.fc39.x86_64                                                  7/24 
error: INSERT OR REPLACE INTO 'Packages' VALUES(?, ?): 11: database disk image is malformed
error: phonon-qt5-4.11.1-12.fc39.x86_64: install failed

  Installing       : okular-libs-23.08.4-1.fc39.x86_64                                                       8/24 
error: INSERT OR REPLACE INTO 'Packages' VALUES(?, ?): 11: database disk image is malformed
error: kf5-threadweaver-5.113.0-1.fc39.x86_64: install failed

  Installing       : kf5-libkexiv2-23.08.4-1.fc39.x86_64                                                     9/24 
error: INSERT OR REPLACE INTO 'Packages' VALUES(?, ?): 11: database disk image is malformed
error: okular-libs-23.08.4-1.fc39.x86_64: install failed

  Installing       : kf5-kjs-5.113.0-1.fc39.x86_64                                                          10/24 
error: INSERT OR REPLACE INTO 'Packages' VALUES(?, ?): 11: database disk image is malformed
error: kf5-libkexiv2-23.08.4-1.fc39.x86_64: install failed

  Installing       : kf5-khtml-5.113.0-1.fc39.x86_64                                                        11/24 
error: INSERT OR REPLACE INTO 'Packages' VALUES(?, ?): 11: database disk image is malformed
error: kf5-kjs-5.113.0-1.fc39.x86_64: install failed

  Installing       : kf5-bluez-qt-5.113.0-1.fc39.x86_64                                                     12/24 
error: INSERT OR REPLACE INTO 'Packages' VALUES(?, ?): 11: database disk image is malformed
error: kf5-khtml-5.113.0-1.fc39.x86_64: install failed

  Installing       : kdegraphics-mobipocket-23.08.4-1.fc39.x86_64                                           13/24 
error: INSERT OR REPLACE INTO 'Packages' VALUES(?, ?): 11: database disk image is malformed
error: kf5-bluez-qt-5.113.0-1.fc39.x86_64: install failed

  Installing       : poppler-qt5-23.08.0-1.fc39.x86_64                                                      14/24 
error: INSERT OR REPLACE INTO 'Packages' VALUES(?, ?): 11: database disk image is malformed
error: kdegraphics-mobipocket-23.08.4-1.fc39.x86_64: install failed

  Installing       : libmarkdown-2.2.7-5.fc39.x86_64                                                        15/24 
error: INSERT OR REPLACE INTO 'Packages' VALUES(?, ?): 11: database disk image is malformed
error: poppler-qt5-23.08.0-1.fc39.x86_64: install failed

  Installing       : libaccounts-glib-1.25-13.fc39.x86_64                                                   16/24 
error: INSERT OR REPLACE INTO 'Packages' VALUES(?, ?): 11: database disk image is malformed
error: libmarkdown-2.2.7-5.fc39.x86_64: install failed

  Installing       : libaccounts-qt5-1.16-8.fc39.x86_64                                                     17/24 
error: INSERT OR REPLACE INTO 'Packages' VALUES(?, ?): 11: database disk image is malformed
error: libaccounts-glib-1.25-13.fc39.x86_64: install failed

  Installing       : accounts-qml-module-0.7-10.fc39.x86_64                                                 18/24 
error: INSERT OR REPLACE INTO 'Packages' VALUES(?, ?): 11: database disk image is malformed
error: libaccounts-qt5-1.16-8.fc39.x86_64: install failed

  Installing       : kaccounts-integration-23.08.4-1.fc39.x86_64                                            19/24 
error: INSERT OR REPLACE INTO 'Packages' VALUES(?, ?): 11: database disk image is malformed
error: accounts-qml-module-0.7-10.fc39.x86_64: install failed

  Installing       : kf5-purpose-5.113.0-1.fc39.x86_64                                                      20/24 
error: INSERT OR REPLACE INTO 'Packages' VALUES(?, ?): 11: database disk image is malformed
error: kaccounts-integration-23.08.4-1.fc39.x86_64: install failed

  Installing       : ebook-tools-libs-0.2.2-25.fc39.x86_64                                                  21/24 
error: INSERT OR REPLACE INTO 'Packages' VALUES(?, ?): 11: database disk image is malformed
error: kf5-purpose-5.113.0-1.fc39.x86_64: install failed

  Installing       : chmlib-0.40-30.fc39.x86_64                                                             22/24 
error: INSERT OR REPLACE INTO 'Packages' VALUES(?, ?): 11: database disk image is malformed
error: ebook-tools-libs-0.2.2-25.fc39.x86_64: install failed

  Installing       : okular-part-23.08.4-1.fc39.x86_64                                                      23/24 
error: INSERT OR REPLACE INTO 'Packages' VALUES(?, ?): 11: database disk image is malformed
error: chmlib-0.40-30.fc39.x86_64: install failed

  Installing       : okular-23.08.4-1.fc39.x86_64                                                           24/24 
error: INSERT OR REPLACE INTO 'Packages' VALUES(?, ?): 11: database disk image is malformed
error: okular-part-23.08.4-1.fc39.x86_64: install failed

  Verifying        : accounts-qml-module-0.7-10.fc39.x86_64                                                  1/24 
  Verifying        : chmlib-0.40-30.fc39.x86_64                                                              2/24 
  Verifying        : ebook-tools-libs-0.2.2-25.fc39.x86_64                                                   3/24 
  Verifying        : libaccounts-glib-1.25-13.fc39.x86_64                                                    4/24 
  Verifying        : libaccounts-qt5-1.16-8.fc39.x86_64                                                      5/24 
  Verifying        : libmarkdown-2.2.7-5.fc39.x86_64                                                         6/24 
  Verifying        : phonon-qt5-4.11.1-12.fc39.x86_64                                                        7/24 
  Verifying        : phonon-qt5-backend-gstreamer-2:4.10.0-10.fc39.x86_64                                    8/24 
  Verifying        : poppler-qt5-23.08.0-1.fc39.x86_64                                                       9/24 
  Verifying        : signon-8.60-13.fc39.x86_64                                                             10/24 
  Verifying        : signon-plugin-oauth2-0.24-7.fc39.x86_64                                                11/24 
  Verifying        : kaccounts-integration-23.08.4-1.fc39.x86_64                                            12/24 
  Verifying        : kdegraphics-mobipocket-23.08.4-1.fc39.x86_64                                           13/24 
  Verifying        : kf5-bluez-qt-5.113.0-1.fc39.x86_64                                                     14/24 
  Verifying        : kf5-khtml-5.113.0-1.fc39.x86_64                                                        15/24 
  Verifying        : kf5-kjs-5.113.0-1.fc39.x86_64                                                          16/24 
  Verifying        : kf5-libkexiv2-23.08.4-1.fc39.x86_64                                                    17/24 
  Verifying        : kf5-purpose-5.113.0-1.fc39.x86_64                                                      18/24 
  Verifying        : kf5-threadweaver-5.113.0-1.fc39.x86_64                                                 19/24 
  Verifying        : okular-23.08.4-1.fc39.x86_64                                                           20/24 
  Verifying        : okular-libs-23.08.4-1.fc39.x86_64                                                      21/24 
  Verifying        : okular-part-23.08.4-1.fc39.x86_64                                                      22/24 
  Verifying        : qt5-qttools-common-5.15.12-1.fc39.noarch                                               23/24 
  Verifying        : qt5-qttools-libs-designer-5.15.12-1.fc39.x86_64                                        24/24 

Failed:
  accounts-qml-module-0.7-10.fc39.x86_64                     chmlib-0.40-30.fc39.x86_64                           
  ebook-tools-libs-0.2.2-25.fc39.x86_64                      kaccounts-integration-23.08.4-1.fc39.x86_64          
  kdegraphics-mobipocket-23.08.4-1.fc39.x86_64               kf5-bluez-qt-5.113.0-1.fc39.x86_64                   
  kf5-khtml-5.113.0-1.fc39.x86_64                            kf5-kjs-5.113.0-1.fc39.x86_64                        
  kf5-libkexiv2-23.08.4-1.fc39.x86_64                        kf5-purpose-5.113.0-1.fc39.x86_64                    
  kf5-threadweaver-5.113.0-1.fc39.x86_64                     libaccounts-glib-1.25-13.fc39.x86_64                 
  libaccounts-qt5-1.16-8.fc39.x86_64                         libmarkdown-2.2.7-5.fc39.x86_64                      
  okular-23.08.4-1.fc39.x86_64                               okular-libs-23.08.4-1.fc39.x86_64                    
  okular-part-23.08.4-1.fc39.x86_64                          phonon-qt5-4.11.1-12.fc39.x86_64                     
  phonon-qt5-backend-gstreamer-2:4.10.0-10.fc39.x86_64       poppler-qt5-23.08.0-1.fc39.x86_64                    
  qt5-qttools-common-5.15.12-1.fc39.noarch                   qt5-qttools-libs-designer-5.15.12-1.fc39.x86_64      
  signon-8.60-13.fc39.x86_64                                 signon-plugin-oauth2-0.24-7.fc39.x86_64              

error: sqlite failure: PRAGMA synchronous = FULL: Safety level may not be changed inside a transaction
error: sqlite failure: PRAGMA wal_checkpoint = TRUNCATE: database table is locked
Error: Transaction failed
root@fedora:/var/lib/dnf# ^C
root@fedora:/var/lib/dnf#

Comment 20 D. Hugh Redelmeier 2024-02-19 17:43:00 UTC
This is marked "need info" from me.  What information from me would be useful?
This BZ was closed due to old age.  I haven't experienced it recently.

@nkv994: maybe you have to open a new bug to get attention.


Note You need to log in before you can comment on or make changes to this bug.