Re: Is there a procedure to rebuild /var/lib/dnf/history.sqlite? (Chris Murphy)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Sun, Mar 14, 2021 at 4:05 PM George R Goffe via test
<test@xxxxxxxxxxxxxxxxxxxxxxx> wrote:
>
> Chris,
>
> The inode is NOT the same one. I tried a sqlite dump | restore operation but it didn't work...
>
> With your journalctl -f and trying dnf history, dnf reported I/O errors but no kernel or /var/log/messages appeared to contain I/O error messages.
>
> fc35-bash 5.1 /var/lib/dnf# sqlite3 history.sqlite 'VACUUM;'
> Error: file is encrypted or is not a database

I don't have an explanation. I haven't ever seen a sqlite database go
bad. And I know that file is a database and it's not encrypted,
because the command works on the test VM's I've got. Pretty strange...

> I guess it's time to rebuild from scratch?
>
> I wonder why dnf reported I/O errors?

There's something about that history database file it doesn't like. I
don't know what the instigator is, but often the problem happened
earlier, but how much earlier is a bug hunt. Regression testing is
tedious and time consuming. You can opt to just delete that history
database, dnf should just start a new one. And then you'll have to see
if it happens again.

Anyway, Btrfs reporting checksum errors is not normal. I mean, it's
normal for it to complain anytime it detects even a single block
that's corrupt. But routine corruptions are not normal, it suggests
there's a hardware problem: memory, drive cable or connector or
DRAM...

smartctl -x will report quite a lot more information about a drive,
including internal read/write errors that don't always get reported to
the kernel, as well as UDMA errors, which are common with
connector+cable issues.


--
Chris Murphy
_______________________________________________
test mailing list -- test@xxxxxxxxxxxxxxxxxxxxxxx
To unsubscribe send an email to test-leave@xxxxxxxxxxxxxxxxxxxxxxx
Fedora Code of Conduct: https://docs.fedoraproject.org/en-US/project/code-of-conduct/
List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines
List Archives: https://lists.fedoraproject.org/archives/list/test@xxxxxxxxxxxxxxxxxxxxxxx
Do not reply to spam on the list, report it: https://pagure.io/fedora-infrastructure




[Index of Archives]     [Fedora Desktop]     [Fedora SELinux]     [Photo Sharing]     [Yosemite Forum]     [KDE Users]

  Powered by Linux