[MacPorts] #48327: malformed registry

[MacPorts]

#48327: malformed registry
-------------------------+--------------------------------
 Reporter:  rjvbertin@…  |      Owner:  macports-tickets@…
     Type:  defect       |     Status:  new
 Priority:  Normal       |  Milestone:
Component:  base         |    Version:
 Keywords:               |       Port:
-------------------------+--------------------------------
 I have a registry malformation issue on pixilla's macports VM:

 {{{
 > sudo port -v uninstall qt5-creator-mac-devel
 Warning: port definitions are more than two weeks old, consider updating
 them by running 'port selfupdate'.
 --->  Deactivating qt5-creator-mac-devel @3.4.1_0
 Error: Failed to deactivate qt5-creator-mac-devel: sqlite error: database
 disk image is malformed (11) while executing query: UPDATE registry.files
 INDEXED BY file_actual SET active=0 WHERE actual_path=? AND id=?
 Error: See
 /opt/local/var/macports/logs/_opt_local_var_macports_registry_portfiles_qt5
 -creator-mac-
 devel-3.4.1_0_17a23cd57bf236c2cef7833fb52b5acf4d3d66ed590ad129d4c31a9c480be065-8026/qt5
 -creator-mac-devel/main.log for details.
 Warning: Failed to execute portfile from registry for qt5-creator-mac-
 devel @3.4.1_0
 --->  Deactivating qt5-creator-mac-devel @3.4.1_0
 Error: Failed to uninstall qt5-creator-mac-devel: sqlite error: database
 disk image is malformed (11) while executing query: UPDATE registry.files
 INDEXED BY file_actual SET active=0 WHERE actual_path=? AND id=?
 Error: See
 /opt/local/var/macports/logs/_opt_local_var_macports_registry_portfiles_qt5
 -creator-mac-
 devel-3.4.1_0_17a23cd57bf236c2cef7833fb52b5acf4d3d66ed590ad129d4c31a9c480be065-8026/qt5
 -creator-mac-devel/main.log for details.
 Warning: Failed to execute portfile from registry for qt5-creator-mac-
 devel @3.4.1_0
 --->  Deactivating qt5-creator-mac-devel @3.4.1_0
 Error: Failed to deactivate qt5-creator-mac-devel: sqlite error: database
 disk image is malformed (11) while executing query: UPDATE registry.files
 INDEXED BY file_actual SET active=0 WHERE actual_path=? AND id=?
 Error: See
 /opt/local/var/macports/logs/_opt_local_var_macports_registry_portfiles_qt5
 -creator-mac-
 devel-3.4.1_0_17a23cd57bf236c2cef7833fb52b5acf4d3d66ed590ad129d4c31a9c480be065-8026/qt5
 -creator-mac-devel/main.log for details.
 Warning: Failed to execute portfile from registry for qt5-creator-mac-
 devel @3.4.1_0
 --->  Deactivating qt5-creator-mac-devel @3.4.1_0
 Error: port uninstall failed: sqlite error: database disk image is
 malformed (11) while executing query: UPDATE registry.files INDEXED BY
 file_actual SET active=0 WHERE actual_path=? AND id=?
 }}}

 Curiously, I just ran `port selfupdate` twice, the 2nd of which showed

 {{{
 > sudo port -v selfupdate
 --->  Updating MacPorts base sources using rsync
 receiving file list ... done

 sent 36 bytes  received 69 bytes  70.00 bytes/sec
 total size is 27013120  speedup is 257267.81
 receiving file list ... done

 sent 36 bytes  received 76 bytes  224.00 bytes/sec
 total size is 512  speedup is 4.57
 MacPorts base version 2.3.99 installed,
 MacPorts base version 2.3.3 downloaded.
 --->  Updating the ports tree
 Synchronizing local ports tree from
 file:///opt/local/var/macports/sources/svn.macports.org/trunk/dports
 Warning: port definitions are more than two weeks old, consider updating
 them by running 'port selfupdate'.
 Creating port index in
 /opt/local/var/macports/sources/svn.macports.org/trunk/dports

 Total number of ports parsed:   0
 Ports successfully parsed:      0
 Ports failed:                   0
 Up-to-date ports skipped:       23233

 --->  MacPorts base is probably trunk or a release candidate

 The ports tree has been updated. To upgrade your installed ports, you
 should run
   port upgrade outdated
 }}}

 I've had some weird issues the other day in which commands like `port
 installed` took really long to complete, so long that I killed several
 instances before deciding that I little choice but to wait and see if the
 command didn't complete in due time. The 1st such failed command was an
 uninstall, IIRC.

 Is there any way to (auto)repair this error?

 Would it be of any help if I attach the registry.db file?

-- 
Ticket URL: <https://trac.macports.org/ticket/48327>
MacPorts <https://www.macports.org/>
Ports system for OS X