sqlite3.DatabaseError: database disk image is malformed

Ask Fedora
,
1

When i update using sudo dnf upgrade i m getting some database error

  File "/usr/lib/python3.9/site-packages/dnf/plugin.py", line 104, in _caller
    getattr(plugin, method)()
  File "/usr/lib/python3.9/site-packages/dnf-plugins/generate_completion_cache.py", line 62, in sack
    cur.execute("delete from available")
sqlite3.DatabaseError: database disk image is malformed

I can reproduce error using sudo dnf upgrade --refresh command

2

You can rebuild the rpm database with

sudo rpm --rebuilddb

That should clean up any database corruption and allow you to start over.

3

didnt work

4

Try (generic suggestion similar to your post)

sudo dnf clean all
sudo rpm --rebuilddb

If there is corrupted data in the cache it may bleed over to an error in the database. The dnf clean command will wipe out the cache so the database may be built new.

When you give a reply such as “didnt work” we have no clue what information you may have received on the screen and no way to know what actually may have interfered.

Please post the command that failed and all related following text so we can see the actual error and might possibly be able to give an answer that is directed to the error instead of a general “try this” type answer.

5

sudo dnf upgrade

94805ea553d32241955593d8856b2bd5655193e0.png
94805ea553d32241955593d8856b2bd5655193e0.png1920Ă—1048 282 KB

6

Fix the database first. It obviously is causing the dnf upgrade error.

7

Here is the rpm way to fix that error.
https://rpm.org/user_doc/db_recovery.html

1 Like