corrupted database

[mikie mike]

Hi,

As my Lion freezes very often
(https://discussions.apple.com/message/15676049#15676049) my MacPorts
database got corrupted somehow during installation of gtk2 i guess.
Now I can't continue to install any ports (log from installation of
gtk2 below). This is obviously what is described here:
https://svn.macports.org/ticket/24858 but I can't find any instruction
how to recovery.

Please help,
MikieMike



$ tail -n 100 /opt/local/var/macports/logs/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_gnome_gtk2/gtk2/main.log
:debug:main Merging existing variants '' into variants
:debug:main new fully merged portvariants:
:debug:main Changing to port directory:
/opt/local/var/macports/sources/rsync.macports.org/release/tarballs/ports/x11/xorg-libXcomposite
:debug:main OS darwin/11.0.0 (Mac OS X 10.7) arch i386
:debug:main org.macports.load registered provides 'load', a
pre-existing procedure. Target override will not be provided
:debug:main org.macports.unload registered provides 'unload', a
pre-existing procedure. Target override will not be provided
:debug:main org.macports.distfiles registered provides 'distfiles', a
pre-existing procedure. Target override will not be provided
:debug:main adding the default universal variant
:debug:main Reading variant descriptions from
/opt/local/var/macports/sources/rsync.macports.org/release/tarballs/ports/_resources/port1.0/variant_descriptions.conf
:debug:main No need to upgrade! xorg-libXcomposite 0.4.3_0 >=
xorg-libXcomposite 0.4.3_0
:debug:main epoch: in tree: 0 installed: 0
:debug:main xorg-compositeproto 0.4.2_0 exists in the ports tree
:debug:main xorg-compositeproto 0.4.2_0  is the latest installed
:debug:main xorg-compositeproto 0.4.2_0  is active
:debug:main Merging existing variants '' into variants
:debug:main new fully merged portvariants:
:debug:main Changing to port directory:
/opt/local/var/macports/sources/rsync.macports.org/release/tarballs/ports/x11/xorg-compositeproto
:debug:main OS darwin/11.0.0 (Mac OS X 10.7) arch i386
:debug:main org.macports.load registered provides 'load', a
pre-existing procedure. Target override will not be provided
:debug:main org.macports.unload registered provides 'unload', a
pre-existing procedure. Target override will not be provided
:debug:main org.macports.distfiles registered provides 'distfiles', a
pre-existing procedure. Target override will not be provided
:debug:main only one arch supported, so not adding the default universal variant
:debug:main No need to upgrade! xorg-compositeproto 0.4.2_0 >=
xorg-compositeproto 0.4.2_0
:debug:main epoch: in tree: 0 installed: 0
:debug:main shared-mime-info 0.90_0 exists in the ports tree
:debug:main shared-mime-info 0.90_0  is the latest installed
:debug:main shared-mime-info 0.90_0  is active
:debug:main Merging existing variants '' into variants
:debug:main new fully merged portvariants:
:debug:main Changing to port directory:
/opt/local/var/macports/sources/rsync.macports.org/release/tarballs/ports/devel/shared-mime-info
:debug:main OS darwin/11.0.0 (Mac OS X 10.7) arch i386
:debug:main org.macports.load registered provides 'load', a
pre-existing procedure. Target override will not be provided
:debug:main org.macports.unload registered provides 'unload', a
pre-existing procedure. Target override will not be provided
:debug:main org.macports.distfiles registered provides 'distfiles', a
pre-existing procedure. Target override will not be provided
:debug:main adding the default universal variant
:debug:main Reading variant descriptions from
/opt/local/var/macports/sources/rsync.macports.org/release/tarballs/ports/_resources/port1.0/variant_descriptions.conf
:debug:main No need to upgrade! shared-mime-info 0.90_0 >=
shared-mime-info 0.90_0
:msg:main --->  Computing dependencies for gtk2:info:main .:debug:main
Searching for dependency: atk
:debug:main Found Dependency: receipt exists for atk
:debug:main Searching for dependency: pango
:debug:main Found Dependency: receipt exists for pango
:debug:main Searching for dependency: gdk-pixbuf2
:debug:main Found Dependency: receipt exists for gdk-pixbuf2
:debug:main Searching for dependency: xorg-libXi
:debug:main Found Dependency: receipt exists for xorg-libXi
:debug:main Searching for dependency: xorg-libXrandr
:debug:main Found Dependency: receipt exists for xorg-libXrandr
:debug:main Searching for dependency: xorg-libXcursor
:debug:main Found Dependency: receipt exists for xorg-libXcursor
:debug:main Searching for dependency: xorg-libXinerama
:debug:main Found Dependency: receipt exists for xorg-libXinerama
:debug:main Searching for dependency: xorg-libXdamage
:debug:main Found Dependency: receipt exists for xorg-libXdamage
:debug:main Searching for dependency: xorg-libXcomposite
:debug:main Found Dependency: receipt exists for xorg-libXcomposite
:debug:main Searching for dependency: xorg-libXfixes
:debug:main Found Dependency: receipt exists for xorg-libXfixes
:debug:main Searching for dependency: shared-mime-info
:debug:main Found Dependency: receipt exists for shared-mime-info
:msg:main
:debug:main Executing org.macports.main (gtk2)
:debug:main changing euid/egid - current euid: 0 - current egid: 0
:debug:main egid changed to: 501
:debug:main euid changed to: 502
:debug:main Skipping completed org.macports.archivefetch (gtk2)
:debug:main Privilege de-escalation not attempted as not running as root.
:debug:main Skipping completed org.macports.fetch (gtk2)
:debug:main Privilege de-escalation not attempted as not running as root.
:debug:main Skipping completed org.macports.checksum (gtk2)
:debug:main Privilege de-escalation not attempted as not running as root.
:debug:main Skipping completed org.macports.extract (gtk2)
:debug:main Privilege de-escalation not attempted as not running as root.
:debug:main Skipping completed org.macports.patch (gtk2)
:debug:main Privilege de-escalation not attempted as not running as root.
:debug:main Skipping completed org.macports.configure (gtk2)
:debug:main Privilege de-escalation not attempted as not running as root.
:debug:main Skipping completed org.macports.build (gtk2)
:debug:main Privilege de-escalation not attempted as not running as root.
:debug:main Skipping completed org.macports.destroot (gtk2)
:debug:main Privilege de-escalation not attempted as not running as root.
:debug:install install phase started at Mon Aug  8 16:09:34 CEST 2011
:notice:install --->  Installing gtk2 @2.24.4_0+x11
:debug:install Can't run install on this port without elevated
privileges. Escalating privileges back to root.
:debug:install euid changed to: 0. egid changed to: 0.
:debug:install Executing org.macports.install (gtk2)
:error:install Target org.macports.install returned: sqlite error: SQL
logic error or missing database (1) while executing query: INSERT INTO
registry.files (id, path, mtime, active) VALUES (?, ?, 0, 0)
:debug:install Backtrace: sqlite error: SQL logic error or missing
database (1) while executing query: INSERT INTO registry.files (id,
path, mtime, active) VALUES (?, ?, 0, 0)
    while executing
"$regref map $installPlist"
    invoked from within
"registry::write {

        set regref [registry::entry create $subport $version $revision
$portvariants $epoch]

        if {[info exists user_options..."
    (procedure "portinstall::install_main" line 35)
    invoked from within
"$procedure $targetname"
:info:install Warning: the following items did not execute (for gtk2):
org.macports.activate org.macports.install
:notice:install Log for gtk2 is at:
/opt/local/var/macports/logs/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_gnome_gtk2/gtk2/main.log