I'll upload the sql dump as an attachment in case it's of use.
Restore sqlight db fro. bump install#
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 can't imagine what would have caused this problem. Then I replaced history.sqlite with history2.sqlite, and now dnf is working again. I deleted one of the rows from the sql and ran: $ sqlite3 history.sqlite ".dump" |sqlite3 history-new.sqliteĮrror: near line 8859: UNIQUE constraint failed: trans_item.id On tree page 236 cell 57: Rowid 4840 out of orderįollowing the dump/restore test in #1669824, sqlite complained that my problem was a duplicate transaction. $ echo 'PRAGMA integrity_check ' | sqlite3 /var/lib/dnf/history.sqlite However, the ways that a database can be corrupt are legion. Somehow I've reproduced this problem, or a variant thereof, without either a crash or running out of disk space. also reported a while back on the fedora-users mailing list SQLite know that there's something wrong:Įcho 'PRAGMA integrity_check ' | sudo sqlite3 /var/lib/dnf/history.sqliteįragmentation of 5 bytes reported as 0 on page 1092Įrror: near line 1: database disk image is malformed It turns out that I can fix the problem with: Without intervention, this error persists.
Version-Release number of selected component (if applicable): Broken version of /var/lib/dnf/history.sqliteĮrror: SQLite error on "/var/lib/dnf/history.sqlite": Reading a row failed: database disk image is malformed
0 kommentar(er)
