#32686: Registry DB corrupted after selfupdate -----------------------------------+---------------------------------------- Reporter: falkschramm@… | Owner: macports-tickets@… Type: defect | Status: new Priority: Normal | Milestone: Component: base | Version: 2.0.3 Keywords: | Port: -----------------------------------+---------------------------------------- Changes (by ryandesign@…): * cc: falkschramm@… (removed) * component: ports => base Old description:
Hi there, After running "port selfupdate" today the registry DB seems to be corrupted. Before "port list outdated" was running fine. After the selfupdate it fails with the following error message: Error: /opt/local/bin/port: port installed failed: sqlite error: SQL logic error or missing database (1) while executing query: SELECT name FROM registry.ports WHERE id=572
Looking into the /opt/local/var/macports/registry/registry.db file with sqlite3 the file seems to be corrupted: sqlite> SELECT id FROM ports; Fails after ID 571 with "Error: database disk image is malformed".
So far it seems that the selfupdate corrupted the registry.db file. Is there any way to rebuild/reconstruct the file?
Thanks in advance, Falk
New description: Hi there, [[br]] After running "{{{port selfupdate}}}" today the registry DB seems to be corrupted. Before "{{{port list outdated}}}" was running fine. After the selfupdate it fails with the following error message: {{{ Error: /opt/local/bin/port: port installed failed: sqlite error: SQL logic error or missing database (1) while executing query: SELECT name FROM registry.ports WHERE id=572 }}} Looking into the /opt/local/var/macports/registry/registry.db file with sqlite3 the file seems to be corrupted: {{{ sqlite> SELECT id FROM ports; }}} Fails after ID 571 with "{{{Error: database disk image is malformed}}}". So far it seems that the selfupdate corrupted the registry.db file. [[br]] Is there any way to rebuild/reconstruct the file? Thanks in advance, [[br]] Falk -- Comment: I don't know why your registry corrupted, nor how to fix it. But I do want to point out that [wiki:FAQ#portlist "port list" doesn't do what you think it does]. -- Ticket URL: <https://trac.macports.org/ticket/32686#comment:2> MacPorts <http://www.macports.org/> Ports system for Mac OS