[MacPorts] #36126: Registry DB error - update failure
#36126: Registry DB error - update failure ----------------------------+-------------------------------- Reporter: meng.uom@… | Owner: macports-tickets@… Type: update | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.1.2 Keywords: update failure | Port: registry DB ----------------------------+-------------------------------- Hi, I wanted to update macports today, but got the following error message: { sqlite error: database disk image is malformed (11) while executing query: ATTACH DATABASE '/opt/local/var/macports/registry/registry.db' AS registry while executing "registry::open $db_path" (procedure "mportinit" line 633) invoked from within "mportinit ui_options global_options global_variations" Error: /opt/local/bin/port: Failed to initialize MacPorts, sqlite error: database disk image is malformed (11) while executing query: ATTACH DATABASE '/opt/local/var/macports/registry/registry.db' AS registry } Is there any way to fix this issue? Many thanks. :D Sofia. -- Ticket URL: <https://trac.macports.org/ticket/36126> MacPorts <http://www.macports.org/> Ports system for Mac OS
#36126: Registry DB error - update failure -------------------------+-------------------------------- Reporter: meng.uom@… | Owner: macports-tickets@… Type: update | Status: new Priority: Normal | Milestone: Component: base | Version: 2.1.2 Resolution: | Keywords: Port: | -------------------------+-------------------------------- Changes (by ryandesign@…): * keywords: update failure => * component: ports => base * port: registry DB => Old description:
Hi, I wanted to update macports today, but got the following error message: { sqlite error: database disk image is malformed (11) while executing query: ATTACH DATABASE '/opt/local/var/macports/registry/registry.db' AS registry while executing "registry::open $db_path" (procedure "mportinit" line 633) invoked from within "mportinit ui_options global_options global_variations" Error: /opt/local/bin/port: Failed to initialize MacPorts, sqlite error: database disk image is malformed (11) while executing query: ATTACH DATABASE '/opt/local/var/macports/registry/registry.db' AS registry }
Is there any way to fix this issue?
Many thanks. :D
Sofia.
New description: Hi, I wanted to update macports today, but got the following error message: {{{ sqlite error: database disk image is malformed (11) while executing query: ATTACH DATABASE '/opt/local/var/macports/registry/registry.db' AS registry while executing "registry::open $db_path" (procedure "mportinit" line 633) invoked from within "mportinit ui_options global_options global_variations" Error: /opt/local/bin/port: Failed to initialize MacPorts, sqlite error: database disk image is malformed (11) while executing query: ATTACH DATABASE '/opt/local/var/macports/registry/registry.db' AS registry }}} Is there any way to fix this issue? Many thanks. :D Sofia. -- -- Ticket URL: <https://trac.macports.org/ticket/36126#comment:1> MacPorts <http://www.macports.org/> Ports system for Mac OS
#36126: Registry DB error - update failure -------------------------+-------------------------------- Reporter: meng.uom@… | Owner: macports-tickets@… Type: defect | Status: new Priority: Normal | Milestone: Component: base | Version: 2.1.2 Resolution: | Keywords: Port: | -------------------------+-------------------------------- Changes (by ryandesign@…): * type: update => defect -- Ticket URL: <https://trac.macports.org/ticket/36126#comment:2> MacPorts <http://www.macports.org/> Ports system for Mac OS
#36126: Registry DB error - update failure -------------------------+-------------------------------- Reporter: meng.uom@… | Owner: macports-tickets@… Type: defect | Status: new Priority: Normal | Milestone: Component: base | Version: 2.1.2 Resolution: | Keywords: Port: | -------------------------+-------------------------------- Comment (by cal@…): I'm afraid there's probably no way to fix this. If you have a backup, try restoring `/opt/local/var/macports/registry/registry.db`. If you don't have a backup you'll probably need a re-install. -- Ticket URL: <https://trac.macports.org/ticket/36126#comment:3> MacPorts <http://www.macports.org/> Ports system for Mac OS
#36126: Registry DB error - update failure -------------------------+-------------------------------- Reporter: meng.uom@… | Owner: macports-tickets@… Type: defect | Status: new Priority: Normal | Milestone: Component: base | Version: 2.1.2 Resolution: | Keywords: Port: | -------------------------+-------------------------------- Comment (by pixilla@…): I have had some luck in the past open the db with sqlite and letting it repair what it knows how to repair. This has worked for me in the past: {{{ $ sudo sqlite3 /opt/local/var/macports/registry/registry.db SQLite version 3.7.14 2012-09-03 15:42:36 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .quit $ }}} -- Ticket URL: <https://trac.macports.org/ticket/36126#comment:4> MacPorts <http://www.macports.org/> Ports system for Mac OS
#36126: Registry DB error - update failure -------------------------+-------------------------------- Reporter: meng.uom@… | Owner: macports-tickets@… Type: defect | Status: closed Priority: Normal | Milestone: Component: base | Version: 2.1.2 Resolution: worksforme | Keywords: Port: | -------------------------+-------------------------------- Changes (by cal@…): * status: new => closed * resolution: => worksforme Comment: There's nothing we can do about this, unfortunately. -- Ticket URL: <https://trac.macports.org/ticket/36126#comment:5> MacPorts <http://www.macports.org/> Ports system for OS X
participants (1)
-
MacPorts