I'm trying to open the listchanges.db file located under /var/lib/apt/ with DB Browser for SQLite under Debian 9.1 with KDE and it says: "Invalid file format."
How can I open it?

  • Please edit your question and clarify. Where is this file? What does it come from? What made you think it is a SQL file?
    – terdon
    Jul 26, 2017 at 15:45

1 Answer 1


listchanges.db, as used by apt-listchanges, is a Berkeley DB database, not a SQLite database:

$ file /var/lib/apt/listchanges.db
/var/lib/apt/listchanges.db: Berkeley DB (Hash, version 8, native byte-order)

You can dump its contents (albeit not in a particularly human-readable format) using

db5.3_dump /var/lib/apt/listchanges.db | less

For human-readable output, use

apt-listchanges --dump-seen
  • Thanks. It's very short and there's nothing of interest in there. I thought it was for a file history / changelog of the sources.list file because of its name and as there's also a listchanges.conf file in the same directory as that file. (I was interested in this as I wanted to see what exactly I had in there earlier for my question here; it would be useful.)
    – mYnDstrEAm
    Jul 27, 2017 at 22:52
  • 1
    It gets bigger, at least if you use apt-listchanges ;-). If you want to keep a history of sources.list, use etckeeper; but that won’t help you find older contents (older than when you start using it). Jul 27, 2017 at 22:58

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .