id summary reporter owner description type status priority milestone component version resolution keywords cc port 48327 malformed registry RJVB macports-tickets@… "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?" defect closed Normal base invalid