[MacPorts] #52855: 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) (was: Issue with the installation of libcxx)

MacPorts noreply at macports.org
Fri Nov 11 06:09:39 CET 2016


#52855: 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)
---------------------+--------------------------------
  Reporter:  MG62    |      Owner:  macports-tickets@…
      Type:  defect  |     Status:  new
  Priority:  Normal  |  Milestone:
 Component:  ports   |    Version:  2.3.4
Resolution:          |   Keywords:
      Port:          |
---------------------+--------------------------------

Old description:

> 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.

New description:

 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.

--

Comment (by ryandesign):

 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.

--
Ticket URL: <https://trac.macports.org/ticket/52855#comment:1>
MacPorts <https://www.macports.org/>
Ports system for macOS



More information about the macports-tickets mailing list