Opened 8 years ago

Last modified 8 years ago

#52855 closed defect

sqlite error: table registry.files has no column named mtime (1) while executing query: INSERT INTO registry.files (id, path, mtime, active) VALUES (?, ?, 0, 0) — at Version 1

Reported by: MG62 Owned by: macports-tickets@…
Priority: Normal Milestone:
Component: base Version: 2.3.4
Keywords: Cc:
Port:

Description (last modified by ryandesign (Ryan Carsten Schmidt))

When I am trying to install libcxx, I obtain:

version:1
:debug:main libcxx has no conflicts
:debug:main Executing org.macports.main (libcxx)
:debug:main Attempting ln -sf /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_lang_libcxx/libcxx/work /opt/local/var/macports/sources/rsync.macports.org/release/tarballs/ports/lang/libcxx/work
: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 (libcxx)
:debug:main Privilege de-escalation not attempted as not running as root.
:debug:main Skipping completed org.macports.fetch (libcxx)
:debug:main Privilege de-escalation not attempted as not running as root.
:debug:main Skipping completed org.macports.checksum (libcxx)
:debug:main Privilege de-escalation not attempted as not running as root.
:debug:main Skipping completed org.macports.extract (libcxx)
:debug:main Privilege de-escalation not attempted as not running as root.
:debug:main Skipping completed org.macports.patch (libcxx)
:debug:main Privilege de-escalation not attempted as not running as root.
:debug:main Skipping completed org.macports.configure (libcxx)
:debug:main Privilege de-escalation not attempted as not running as root.
:debug:main Skipping completed org.macports.build (libcxx)
:debug:main Privilege de-escalation not attempted as not running as root.
:debug:main Skipping completed org.macports.destroot (libcxx)
:debug:main Privilege de-escalation not attempted as not running as root.
:debug:install install phase started at Thu Nov 10 23:29:41 CET 2016
:notice:install --->  Installing libcxx @3.9.0_0+universal
: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 (libcxx)
:debug:install Using /usr/bin/tar
:debug:install Using /usr/bin/bzip2
:debug:install Creating libcxx-3.9.0_0+universal.darwin_14.i386-x86_64.tbz2
:debug:install Environment: 
CC_PRINT_OPTIONS='YES'
CC_PRINT_OPTIONS_FILE='/opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_lang_libcxx/libcxx/work/.CC_PRINT_OPTIONS'
CPATH='/opt/local/include'
LIBRARY_PATH='/opt/local/lib'
MACOSX_DEPLOYMENT_TARGET='10.10'
:debug:install Assembled command: 'cd "/opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_lang_libcxx/libcxx/work/destroot" && /usr/bin/tar -cvf - . | /usr/bin/bzip2 -c9 > /opt/local/var/macports/software/libcxx/libcxx-3.9.0_0+universal.darwin_14.i386-x86_64.tbz2'
:debug:install Executing command line:  cd "/opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_lang_libcxx/libcxx/work/destroot" && /usr/bin/tar -cvf - . | /usr/bin/bzip2 -c9 > /opt/local/var/macports/software/libcxx/libcxx-3.9.0_0+universal.darwin_14.i386-x86_64.tbz2 
:info:install a .
:info:install a ./+COMMENT
:info:install a ./+CONTENTS
:info:install a ./+DESC
:info:install a ./+PORTFILE
:info:install a ./+STATE
:debug:install Archive libcxx-3.9.0_0+universal.darwin_14.i386-x86_64.tbz2 packaged
:debug:install removing file: /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_lang_libcxx/libcxx/work/destroot/+COMMENT
:debug:install removing file: /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_lang_libcxx/libcxx/work/destroot/+CONTENTS
:debug:install removing file: /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_lang_libcxx/libcxx/work/destroot/+DESC
:debug:install removing file: /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_lang_libcxx/libcxx/work/destroot/+PORTFILE
:debug:install removing file: /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_lang_libcxx/libcxx/work/destroot/+STATE
:error:install org.macports.install for port libcxx returned: sqlite error: table registry.files has no column named mtime (1) while executing query: INSERT INTO registry.files (id, path, mtime, active) VALUES (?, ?, 0, 0)
:debug:install Error code: registry::sqlite-error
:debug:install Backtrace: sqlite error: table registry.files has no column named mtime (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 38)
    invoked from within
"portinstall::install_main org.macports.install"
    ("eval" body line 1)
    invoked from within
"eval $procedure $targetname"
:info:install Warning: targets not executed for libcxx: org.macports.activate org.macports.install
:notice:install Please see the log file for port libcxx for details:
    /opt/local/var/macports/logs/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_lang_libcxx/libcxx/main.log

At first, it could not access to destroot so I created the directory. The issue stayed. I tried to clean libcxx, to update the outdated ports, selfupdate, re-install MacPorts from scratch. Nothing works. I am on OS Yosemite (10.10.5).

Thanks for your help.

Change History (1)

comment:1 Changed 8 years ago by ryandesign (Ryan Carsten Schmidt)

Description: modified (diff)
Summary: Issue with the installation of libcxxsqlite error: table registry.files has no column named mtime (1) while executing query: INSERT INTO registry.files (id, path, mtime, active) VALUES (?, ?, 0, 0)

The error:

sqlite error: table registry.files has no column named mtime (1) while executing query: INSERT INTO registry.files (id, path, mtime, active) VALUES (?, ?, 0, 0)

sounds like a problem with the registry, not specific to any particular port.

Note: See TracTickets for help on using tickets.