[MacPorts] #31250: Failing to install package due to sqlite insert error

[MacPorts]

#31250: Failing to install package due to sqlite insert error
-----------------------------------+----------------------------------------
 Reporter:  anastasiosm@…          |       Owner:  macports-tickets@…                   
     Type:  defect                 |      Status:  new                                  
 Priority:  Normal                 |   Milestone:                                       
Component:  base                   |     Version:  2.0.3                                
 Keywords:                         |        Port:                                       
-----------------------------------+----------------------------------------
Changes (by ryandesign@…):

  * component:  ports => base
  * port:  port =>


Old description:

> Hello,
>
> after upgrading my ports from 1.9.x to 2.03 I am unable to install any
> package, see example below
>
> #port install ascii
> --->  Installing ascii @3.8_0
> Error: Target org.macports.install returned: sqlite error: no such table:
> registry.ports (1) while executing query: INSERT INTO registry.ports
> (name, version, revision, variants, epoch) VALUES (?, ?, ?, ?, ?)
> Log for ascii is at:
> /opt/local/var/macports/logs/_opt_local_var_macports_sources_rsync.macports.org_release_ports_textproc_ascii/ascii/main.log
> Error: Status 1 encountered during processing.
> To report a bug, see <http://guide.macports.org/#project.tickets>
>
> ''Contents of
> /opt/local/var/macports/logs/_opt_local_var_macports_sources_rsync.macports.org_release_ports_textproc_ascii/ascii/main.log'':
>
> version:1
> :debug:main Executing org.macports.main (ascii)
> :debug:main Skipping completed org.macports.archivefetch (ascii)
> :debug:main Skipping completed org.macports.fetch (ascii)
> :debug:main Skipping completed org.macports.checksum (ascii)
> :debug:main Skipping completed org.macports.extract (ascii)
> :debug:main Skipping completed org.macports.patch (ascii)
> :debug:main Skipping completed org.macports.configure (ascii)
> :debug:main Skipping completed org.macports.build (ascii)
> :debug:main Skipping completed org.macports.destroot (ascii)
> :debug:install install phase started at Wed Sep 14 01:57:06 EEST 2011
> :notice:install --->  Installing ascii @3.8_0
> :debug:install Executing org.macports.install (ascii)
> :error:install Target org.macports.install returned: sqlite error: no
> such table: registry.ports (1) while executing query: INSERT INTO
> registry.ports (name, version, revision, variants, epoch) VALUES (?, ?,
> ?, ?, ?)
> :debug:install Backtrace: sqlite error: no such table: registry.ports (1)
> while executing query: INSERT INTO registry.ports (name, version,
> revision, variants, epoch) VALUES (?, ?, ?, ?, ?)
>     while executing
> "registry::entry create $subport $version $revision $portvariants $epoch"
>     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 ascii):
> org.macports.activate org.macports.install
> :notice:install Log for ascii is at:
> /opt/local/var/macports/logs/_opt_local_var_macports_sources_rsync.macports.org_release_ports_textproc_ascii/ascii/main.log
>
> if you need more info please let me know.
> thanks in advance

New description:

 Hello,

 after upgrading my ports from 1.9.x to 2.03 I am unable to install any
 package, see example below

 {{{
 #port install ascii
 --->  Installing ascii @3.8_0
 Error: Target org.macports.install returned: sqlite error: no such table:
 registry.ports (1) while executing query: INSERT INTO registry.ports
 (name, version, revision, variants, epoch) VALUES (?, ?, ?, ?, ?)
 Log for ascii is at:
 /opt/local/var/macports/logs/_opt_local_var_macports_sources_rsync.macports.org_release_ports_textproc_ascii/ascii/main.log
 Error: Status 1 encountered during processing.
 To report a bug, see <http://guide.macports.org/#project.tickets>
 }}}

 ''Contents of
 /opt/local/var/macports/logs/_opt_local_var_macports_sources_rsync.macports.org_release_ports_textproc_ascii/ascii/main.log'':

 {{{
 version:1
 :debug:main Executing org.macports.main (ascii)
 :debug:main Skipping completed org.macports.archivefetch (ascii)
 :debug:main Skipping completed org.macports.fetch (ascii)
 :debug:main Skipping completed org.macports.checksum (ascii)
 :debug:main Skipping completed org.macports.extract (ascii)
 :debug:main Skipping completed org.macports.patch (ascii)
 :debug:main Skipping completed org.macports.configure (ascii)
 :debug:main Skipping completed org.macports.build (ascii)
 :debug:main Skipping completed org.macports.destroot (ascii)
 :debug:install install phase started at Wed Sep 14 01:57:06 EEST 2011
 :notice:install --->  Installing ascii @3.8_0
 :debug:install Executing org.macports.install (ascii)
 :error:install Target org.macports.install returned: sqlite error: no such
 table: registry.ports (1) while executing query: INSERT INTO
 registry.ports (name, version, revision, variants, epoch) VALUES (?, ?, ?,
 ?, ?)
 :debug:install Backtrace: sqlite error: no such table: registry.ports (1)
 while executing query: INSERT INTO registry.ports (name, version,
 revision, variants, epoch) VALUES (?, ?, ?, ?, ?)
     while executing
 "registry::entry create $subport $version $revision $portvariants $epoch"
     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 ascii):
 org.macports.activate org.macports.install
 :notice:install Log for ascii is at:
 /opt/local/var/macports/logs/_opt_local_var_macports_sources_rsync.macports.org_release_ports_textproc_ascii/ascii/main.log
 }}}

 if you need more info please let me know.
 thanks in advance

--

Comment:

 Please remember to use WikiFormatting.

-- 
Ticket URL: <https://trac.macports.org/ticket/31250#comment:1>
MacPorts <http://www.macports.org/>
Ports system for Mac OS