[MacPorts] #31250: Failing to install package due to sqlite insert error
#31250: Failing to install package due to sqlite insert error -----------------------------------+---------------------------------------- Reporter: anastasiosm@… | Owner: macports-tickets@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.0.3 Keywords: | Port: port -----------------------------------+---------------------------------------- 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 -- Ticket URL: <https://trac.macports.org/ticket/31250> MacPorts <http://www.macports.org/> Ports system for Mac OS
#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
#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: -----------------------------------+---------------------------------------- Comment(by macports.org@…): Hi there, +1: {{{ $ sudo port -d selfupdate DEBUG: MacPorts sources location: /opt/local/var/macports/sources/rsync.macports.org/release/base ---> Updating MacPorts base sources using rsync receiving file list ... done [snip] sent 36 bytes received 6813 bytes 805.76 bytes/sec total size is 2966591 speedup is 433.14 MacPorts base version 2.0.3 installed, Total number of ports parsed: 3 Ports successfully parsed: 3 Ports failed: 0 Up-to-date ports skipped: 12345 ---> MacPorts base is already the latest version DEBUG: Setting MacPorts sources ownership to root The ports tree has been updated. To upgrade your installed ports, you should run port upgrade outdated $ sudo port upgrade outdated Error: /opt/local/bin/port: port installed failed: sqlite error: no such table: ports (1) while executing query: SELECT id FROM ports WHERE (state='imaged' OR state='installed') }}} MacOS 10.5.8 just when I decided to rm -rf /sw/ and totally switch from fink to ports because of all the inconsistencies in my install... :-( -- Ticket URL: <https://trac.macports.org/ticket/31250#comment:3> MacPorts <http://www.macports.org/> Ports system for Mac OS
#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@…): * cc: macports.org@… (added) Comment: I don't know why this is happening. Something wrong with your registry. Maybe it can be repaired but I don't know how. A certain fix would be to completely uninstall MacPorts, then reinstall, but of course that's rather inconvenient. -- Ticket URL: <https://trac.macports.org/ticket/31250#comment:4> MacPorts <http://www.macports.org/> Ports system for Mac OS
#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: -----------------------------------+---------------------------------------- Comment(by macports.org@…): Well, an rm -rf /opt/local allowed me to reinstall macports (because the reinstall without that didn't work). Now it's compiling for hours on... -- Ticket URL: <https://trac.macports.org/ticket/31250#comment:5> MacPorts <http://www.macports.org/> Ports system for Mac OS
#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: -----------------------------------+---------------------------------------- Comment(by jmr@…): It would probably be helpful to see a dump of the registry.db. -- Ticket URL: <https://trac.macports.org/ticket/31250#comment:6> MacPorts <http://www.macports.org/> Ports system for Mac OS
participants (1)
-
MacPorts