DNF failed first try, I ran clean metadata and re-tried, got same result:
Running transaction check Transaction check succeeded. Running transaction test Transaction test succeeded. Running transaction The downloaded packages were saved in cache until the next successful transaction. You can remove cached packages by executing 'dnf clean packages'. Error: SQLite error on "/var/lib/dnf/history.sqlite": Reading a row failed: database disk image is malformed
I have no idea why this happening, have done nothing unusual? *Bob*
On Wed, Jun 10, 2020 at 4:44 AM Bob Goodwin bobgoodwin@fastmail.us wrote:
DNF failed first try, I ran clean metadata and re-tried, got same result:
Running transaction check Transaction check succeeded. Running transaction test Transaction test succeeded. Running transaction The downloaded packages were saved in cache until the next successful transaction. You can remove cached packages by executing 'dnf clean packages'. Error: SQLite error on "/var/lib/dnf/history.sqlite": Reading a row failed: database disk image is malformed
I have no idea why this happening, have done nothing unusual? *Bob*
Does running "sudo rpm --rebuilddb" get you back to a good state?
On 2020-06-11 10:46, Jerry James wrote:
On Wed, Jun 10, 2020 at 4:44 AM Bob Goodwin bobgoodwin@fastmail.us wrote:
DNF failed first try, I ran clean metadata and re-tried, got same result:
Running transaction check Transaction check succeeded. Running transaction test Transaction test succeeded. Running transaction The downloaded packages were saved in cache until the next successful transaction. You can remove cached packages by executing 'dnf clean packages'. Error: SQLite error on "/var/lib/dnf/history.sqlite": Reading a row failed: database disk image is malformed
I have no idea why this happening, have done nothing unusual? *Bob*
Does running "sudo rpm --rebuilddb" get you back to a good state?
° No, not that I can see.
[bobg@Workstation-1 ~]$ sudo rpm --rebuilddb [sudo] password for bobg:password [bobg@Workstation-1 ~]$
Strange, no indication of any action at all?
On Thu, Jun 11, 2020 at 10:08 AM Bob Goodwin bobgoodwin@fastmail.us wrote:
No, not that I can see.
[bobg@Workstation-1 ~]$ sudo rpm --rebuilddb [sudo] password for bobg:password [bobg@Workstation-1 ~]$
Strange, no indication of any action at all?
Sorry, I wasn't paying attention. The error is on a dnf database, not an rpm database. See if this sounds like your case:
https://bugzilla.redhat.com/show_bug.cgi?id=1669824
The database dump and restore described there might help you.
On Thu, Jun 11, 2020 at 10:27:14AM -0600, Jerry James wrote:
On Thu, Jun 11, 2020 at 10:08 AM Bob Goodwin bobgoodwin@fastmail.us wrote:
No, not that I can see.
[bobg@Workstation-1 ~]$ sudo rpm --rebuilddb [sudo] password for bobg:password [bobg@Workstation-1 ~]$
Strange, no indication of any action at all?
Sorry, I wasn't paying attention. The error is on a dnf database, not an rpm database. See if this sounds like your case:
https://bugzilla.redhat.com/show_bug.cgi?id=1669824
The database dump and restore described there might help you.
I'd be interested in seeing the output of:
echo 'PRAGMA integrity_check;' | sudo sqlite3 /var/lib/dnf/history.sqlite
It should just return:
ok
On 2020-06-11 13:02, Jonathan Billings wrote:
I'd be interested in seeing the output of:
echo 'PRAGMA integrity_check;' | sudo sqlite3 /var/lib/dnf/history.sqlite
It should just return:
ok
° # echo 'PRAGMA integrity_check;' | sudo sqlite3 /var/lib/dnf/history.sqlite ok
| From: Bob Goodwin bobgoodwin@fastmail.us | Date: Wed, 10 Jun 2020 06:43:38 -0400
| Error: SQLite error on "/var/lib/dnf/history.sqlite": Reading a row failed: database disk image is malformed
I too got this SQLite error.
I was able to fix it simply: just sudo mv /var/lib/dnf/history.sqlite /var/lib/dnf/history.sqlite.hide
I have no idea if this causes other damage but dnf update now works.
I reported this https://bugzilla.redhat.com/show_bug.cgi?id=1868860
Why do all my paragraphs start with "I"? Scary.
What does this file do and what am I going to lose without it? Is there a way to reliably repair this file? Based on googling, this problem seems quite rare.
On 8/13/20 8:50 PM, D. Hugh Redelmeier wrote:
| From: Bob Goodwin bobgoodwin@fastmail.us | Date: Wed, 10 Jun 2020 06:43:38 -0400
| Error: SQLite error on "/var/lib/dnf/history.sqlite": Reading a row failed: database disk image is malformed
I too got this SQLite error.
I was able to fix it simply: just sudo mv /var/lib/dnf/history.sqlite /var/lib/dnf/history.sqlite.hide
I have no idea if this causes other damage but dnf update now works.
What does this file do and what am I going to lose without it? Is there a way to reliably repair this file? Based on googling, this problem seems quite rare.
This is the dnf history database. By removing it, you now have no way to see the history of your dnf transactions.
On Fri, 2020-08-14 at 00:34 -0700, Samuel Sieb wrote:
On 8/13/20 8:50 PM, D. Hugh Redelmeier wrote:
From: Bob Goodwin bobgoodwin@fastmail.us Date: Wed, 10 Jun 2020 06:43:38 -0400 Error: SQLite error on "/var/lib/dnf/history.sqlite": Reading a row failed: database disk image is malformed
I too got this SQLite error.
I was able to fix it simply: just sudo mv /var/lib/dnf/history.sqlite /var/lib/dnf/history.sqlite.hide
I have no idea if this causes other damage but dnf update now works.
What does this file do and what am I going to lose without it? Is there a way to reliably repair this file? Based on googling, this problem seems quite rare.
This is the dnf history database. By removing it, you now have no way to see the history of your dnf transactions.
/var/log/dnf.rpm.log contains some useful information. Not as much as the DNF log, but I find that to be more than I need a lot of the time.
poc
-
Bob Goodwin -
D. Hugh Redelmeier -
Jerry James -
Jonathan Billings -
Patrick O'Callaghan -
Samuel Sieb