While trying to do a world update I recived the following in the portage list of packages to be emerged. [Blocks B ] <dev-perl/DBD-SQLite-1* (is blocking dev-perl/DBD-SQLite-1.07) Reproducible: Always Steps to Reproduce: 1.emerge -uD --ask world 2. 3. Actual Results: Emerge is stopped by the self refrencing block. Expected Results: Install the software. Portage 2.0.51.19 (default-linux/x86/2005.0, gcc-3.4.3-20050110, glibc-2.3.4.20041102-r1, 2.6.11-gentoo-r4 i686) ================================================================= System uname: 2.6.11-gentoo-r4 i686 AMD Duron(tm) Processor Gentoo Base System version 1.4.16 Python: dev-lang/python-2.3.5 [2.3.5 (#1, Apr 30 2005, 13:45:29)] distcc 2.16 i686-pc-linux-gnu (protocols 1 and 2) (default port 3632) [enabled] dev-lang/python: 2.3.5 sys-apps/sandbox: [Not Present] sys-devel/autoconf: 2.59-r6, 2.13 sys-devel/automake: 1.7.9-r1, 1.8.5-r3, 1.5, 1.4_p6, 1.6.3, 1.9.4 sys-devel/binutils: 2.15.92.0.2-r7 sys-devel/libtool: 1.5.16 virtual/os-headers: 2.6.11 ACCEPT_KEYWORDS="x86" AUTOCLEAN="yes" CFLAGS="-march=athlon -O2 -pipe" CHOST="i686-pc-linux-gnu" CONFIG_PROTECT="/etc /usr/kde/2/share/config /usr/kde/3.3/env /usr/kde/3.3/share/config /usr/kde/3.3/shutdown /usr/kde/3.4/env /usr/kde/3.4/share/config /usr/kde/3.4/shutdown /usr/kde/3/share/config /usr/lib/X11/xkb /usr/lib/mozilla/defaults/pref /usr/share/config /usr/share/texmf/dvipdfm/config/ /usr/share/texmf/dvips/config/ /usr/share/texmf/tex/generic/config/ /usr/share/texmf/tex/platex/config/ /usr/share/texmf/xdvi/ /var/qmail/control" CONFIG_PROTECT_MASK="/etc/gconf /etc/terminfo /etc/env.d" CXXFLAGS="-march=athlon -O2 -pipe" DISTDIR="/usr/portage/distfiles" FEATURES="autoaddcvs autoconfig ccache distcc distlocks fixpackages sandbox sfperms strict" GENTOO_MIRRORS="http://gentoo.oregonstate.edu/ ftp://ftp.gtlib.cc.gatech.edu/pub/gentoo http://csociety-ftp.ecn.purdue.edu/pub/gentoo/ ftp://csociety-ftp.ecn.purdue.edu/pub/gentoo/ http://gentoo.mirror.sdv.fr" MAKEOPTS="-j4" PKGDIR="/usr/portage/packages" PORTAGE_TMPDIR="/var/tmp" PORTDIR="/usr/portage" PORTDIR_OVERLAY="/usr/local/portage" SYNC="rsync://rsync.namerica.gentoo.org/gentoo-portage" USE="x86 3dnow 3dnowex X Xaw3d aalib acpi adns alsa amd apache2 apm arts artswrappersuid authdaemond avi berkdb bitmap-fonts blender-game bonobo bootspla c cdparanoia cdr cdrom cjk clamav codecs crypt cups curl dga directfb divx4linux dmx dnd dv dvd dvdread eds emboss emoticon encode erandom esd fam fbcon ffmpeg fftw flac fmod foomaticdb foreign-package foreign-sysvinit fortran freetds freetype fs gb gd gdbm gif gimpprint glade glut gnome gnomedb gpm gsl gstreamer gtk gtk2 gtkhtml guile icq imagemagick imap imlib imlib2 innodb ipv6 ithreads jabber java javascript jikes joystick jpeg junit jython kde kerberos lcms ldap libclamav libg++ libgda libwww lzo mad maildir mailwrapper mbox mcal md5sum memlimit mikmod mmx mmx2 motif mozcalendar mozdomi mozilla mozp3p mozsvg mp3 mpeg mpeg4 mpi mplayer msn music mysql mysqli native ncurses net nls nntp nptl nvidia oav offensive ogg oggvorbis openal opengl opens oscar oss pam pdf pdflib pear-db perl php png ppds prelude pthreads python qt quicktime readline regexp samba sasl scanner sdl slang slp snmp soap sockets socks5 softmmu speedo speex spell spl sqlite ssl svg svga tcltk tcpd tetex threads tiff tools transcode truetype truetype-fonts type1 type1-fonts unicode unsafe usb vhosts videos virus-scan vorbis wifi wmf wxwin wxwindows xine xinetd xml xml2 xmms xpm xscreensaver xsl xv xvid yahoo zeo zlib userland_GNU kernel_linux libc_glibc" Unset: ASFLAGS, CBUILD, CTARGET, LANG, LC_ALL, LDFLAGS, LINGUAS
The indexes that >1 creates and reads are incompatible and cause corruption with indexes create <1. Simple. Read the Changelog. Or the Changes file.
I have read the changelog. Questions 1) How to go about locating all the databases created by DBD-SQLite. 2) Is there a way to convert said databases to the new format. 3) If said DB's cannot be converted what then? 4) I assume that I have to remove the old DBD-SQLite-0.31 in order to install DBD-SQLite-1.07. Any suggestions would be appreciated.
After thinking about this for a bit I did come up with some answers for some of my questions. Namely how to identify said db's I am lucky in that it seems that the only thing I have installed that depends on DBD-SQLite is popfile. It would be nice if there was a program that would fix or update my database in popfile from the old format to the new format. I am going to hit the DBD-SQLite page and see what I can find. My worst case scenario is that I have to retrain my popfile spam filters. Shouldn't take to long see as to how much spam I am getting. I used qpkg to identify what packages depeneded on DBD-SQLite. At least I am learning the different reasons that things get blocked. In some cases there is nothing that one can do about it except wait unless your able to hack the code and submit patches to fix the reason something is being blocked. In other cases like this I do have some options available to me. I just didn't realize what they were. Anyway thanks for you pointing me to the changelog. I know I should have looked there first but I didn't. As they say live and learn, and I am learning.
Trent, Sorry that I came off so rough the other day. The databases that the older DBD-SQLite produce are incompatible (believe me, I've tried). One solution you might try is dumping the data from the old db to a text file, then importing it in after upgrading. You are correct that you will need to completely unmerge the old install before upgrading - it was actually the reason that I made it a blocker, so that users wouldn't accidently upgrade without realizing it and then have their apps suddenly break on them. Depending on how poplite access the sqlite db, there's a few options code-wise that might work for you. I can help you with a conversion script if you need it - no guarantees that it will be perfect, but I can try :) DBISH isn't in the tree, though I could be persuaded to add it, but I find it very useful for accessing SQLite db's on the command line.
Well since popfile was the only one I decided to just clear the data files and retrain popfile. It doesn't take it very long to reach 90%+ accuracy. But thanks anyway.
Michael, One additional note, in upgrading from version 0.21.1 to version 0.22.2 of popfile you need DBD-SQLite2. This is a continuation of DBD-SQLite after version 0.31 renamed to keep backwards compatability with the sqlite-2.x api. DBD-SQLite version 1.0 and on uses the sqlite-3.x api.
Closing this since the block's been explained and we have a separate bug for the dep on sqlite2 :)
