- First Post
- Replies
- Stats
-
Go to
- ----- 2024 -----
- April
- March
- February
- January
- ----- 2023 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2022 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2021 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2020 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2019 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2018 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2017 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2016 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2015 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2014 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2013 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2012 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2011 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2010 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2009 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2008 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2007 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2006 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2005 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2004 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2003 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2002 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2001 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2000 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 1999 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 1998 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 1997 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 1996 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 1995 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 1994 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 1993 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 1992 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 1991 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 1990 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 1989 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 1988 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 1987 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 1986 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 1985 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 1984 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 1983 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 1982 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 1981 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 1980 -----
- December
- November
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*
--
Bob Goodwin - Zuni, Virginia, USA
http://www.qrz.com/db/W2BOD
FEDORA-32/64bit LINUX XFCE Fastmail POP3
On Wed, Jun 10, 2020 at 4:44 AM Bob Goodwin <bobgoodwin(a)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?
--
Jerry James
http://www.jamezone.org/
On 2020-06-11 10:46, Jerry James wrote:
On Wed, Jun 10, 2020 at 4:44 AM Bob Goodwin
<bobgoodwin(a)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?
--
Bob Goodwin - Zuni, Virginia, USA
http://www.qrz.com/db/W2BOD
FEDORA-32/64bit LINUX XFCE Fastmail POP3
On Thu, Jun 11, 2020 at 10:08 AM Bob Goodwin <bobgoodwin(a)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.
--
Jerry James
http://www.jamezone.org/
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(a)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
--
Jonathan Billings <billings(a)negate.org>
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
--
Bob Goodwin - Zuni, Virginia, USA
http://www.qrz.com/db/W2BOD
FEDORA-32/64bit LINUX XFCE Fastmail POP3
| From: Bob Goodwin <bobgoodwin(a)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(a)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(a)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
1343
days inactive
1408
days old
8 comments
6 participants
tags (0)
participants (6)
-
Bob Goodwin -
D. Hugh Redelmeier -
Jerry James -
Jonathan Billings -
Patrick O'Callaghan -
Samuel Sieb