For stabilizing >=dev-db/sqlite-3.3 a stable verision of pysqlite with support for this sqlite version is needed. Can you please give advise? Is there a new version that can be stabilized without breaking anything? <http://initd.org/tracker/pysqlite/wiki/2.0.7_Changelog>: | Fixed an API misuse that made pysqlite 2.0.x | unusable with SQLite versions 3.3.3 or later. And a new version (currently not in the tree) is available: <http://initd.org/tracker/pysqlite/wiki/2.3.1_Changelog>: | Implemented a workaround for SQLite versions < 3.3.3: | they are buggy and cannot use sqlite3_result_error from | certain callbacks. So we cannot abort queries from callbacks. | For these SQLite versions we set the Python exception and | catch it later on when sqlite3_step is finished. [...]
I was under the (apparently incorrect) impression that pysqlite moved to an even/odd stable/unstable version scheme (so 2.3 would be "unstable"). 2.1 was "unstable", but since they just fixed a bug in 2.3.1 that apparently still affects 2.2.1 and 2.2.2 (latest 2.2 releases) this assumption is apparently incorrect. Judging from the ChangeLogs the main options are: - Stabilize 2.0.7, and also stabilize its dependency dev-python/setuptools. I do not like this option very much because I do not think setuptools is quite ready for stable yet (I'd prefer it to leave "beta" upstream first, there were a couple of significant changes while it was labeled "alpha" and I am not convinced there won't be any significant changes while it is "beta"). - Create a 2.0.7-r1 with the setuptools dependency removed. This is not hard (should be a straightforward setup.py patch, and other pysqlite versions do not use setuptools either). If you want a pysqlite that works with sqlite 3.3 stable as quickly as possible this would be my preferred option. - Stabilize 2.3.1. Downside: I just added it to the tree seconds ago :) so this could really do with a bit more testing. If you are not in a hurry I would prefer to get this one tested and stabilized (this code is also in python 2.5b1, it *should* work, but it is quite "new") Or we could do both (2.0.7-r1 now, 2.3.1 soon). If you want that 2.0.7-r1 without setuptools please let me know. Other python team members or others who use pysqlite more than I do: please comment :)
It's been 3 weeks since pysqlite-2.3.1 was put into portage, so I went ahead and marked it stable on ia64 for the sake of sqlite-3.3.5-r1
As i can't find a new bugreport, i think the other arches with a stable version >=pysqlite-2 can follow ia64 and ppc and mark =dev-python/pysqlite-2.3.1 stable. (This is needed to for bug #118429 which is needed for bug #13381.) Thanks
As i can't find a new bugreport, i think the other arches with a stable version >=pysqlite-2 can follow ia64 and ppc and mark =dev-python/pysqlite-2.3.1 stable. (This is needed to for bug #118429 which is needed for bug #133817.) Thanks
apart from pysqlite, I had to emerge sqlite: 1) "Tests do not work as root" nice to know, but when emerging I will be root...so maybe tests should be disabled. 2) file collision for /usr/bin/lemon: # equery belongs /usr/bin/lemon [ Searching for file(s) /usr/bin/lemon in *... ] dev-db/sqlite-2.8.16-r1 (/usr/bin/lemon) But back to pysqlite: 1) emerges fine 2) passes test suite (really fast: Ran 166 tests in 1.193s) 3) passes collision test 4) net-im/gajim 0.10.1 emerges fine on it Portage 2.1-r1 (default-linux/x86/2006.0, gcc-3.4.6, glibc-2.3.6-r4, 2.6.17-gentoo-r4 i686) ================================================================= System uname: 2.6.17-gentoo-r4 i686 AMD Athlon(tm) XP 2500+ Gentoo Base System version 1.6.15 app-admin/eselect-compiler: [Not Present] dev-lang/python: 2.4.3-r1 dev-python/pycrypto: 2.0.1-r5 dev-util/ccache: [Not Present] dev-util/confcache: [Not Present] sys-apps/sandbox: 1.2.17 sys-devel/autoconf: 2.13, 2.59-r7 sys-devel/automake: 1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2 sys-devel/binutils: 2.16.1-r3 sys-devel/gcc-config: 1.3.13-r3 sys-devel/libtool: 1.5.22 virtual/os-headers: 2.6.11-r2 ACCEPT_KEYWORDS="x86" AUTOCLEAN="yes" CBUILD="i686-pc-linux-gnu" CFLAGS="-O2" CHOST="i686-pc-linux-gnu" CONFIG_PROTECT="/etc /usr/share/X11/xkb" CONFIG_PROTECT_MASK="/etc/env.d /etc/gconf /etc/revdep-rebuild /etc/splash /etc/terminfo" CXXFLAGS="-O2" DISTDIR="/usr/portage/distfiles" FEATURES="autoconfig ccache collision-protect distlocks metadata-transfer parallel-fetch sandbox sfperms strict test" GENTOO_MIRRORS="ftp://sunsite.informatik.rwth-aachen.de/pub/Linux/gentoo/" LANG="de_DE@euro" LC_ALL="de_DE@euro" LINGUAS="de" MAKEOPTS="-j2" PKGDIR="/usr/portage/packages" PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --delete-after --stats --timeout=180 --exclude='/distfiles' --exclude='/local' --exclude='/packages'" PORTAGE_TMPDIR="/var/tmp" PORTDIR="/usr/portage" PORTDIR_OVERLAY="/usr/local/portage" SYNC="rsync://rsync.informatik.rwth-aachen.de/gentoo-portage" USE="x86 3dnow 3dnowext X Xaw3d a52 alsa arts artworkextra asf audiofile avi bash-completion beagle berkdb bidi bitmap-fonts bootsplash branding bzip2 cairo cdda cddb cdparanoia cdr cli cracklib crypt css cups curl custom-cflags dbus dga directfb divx4linux dlloader dri dts dvd dvdr dvdread dvi eds emacs emboss encode esd evo exif expat fam fat fbcon fdftk ffmpeg firefox foomaticdb fortran ftp gb gcj gdbm gif gnome gpm gstreamer gtk gtk2 gtkhtml hal icq idn imagemagick imap imlib ipv6 isdnlog java javascript jikes jpeg jpeg2k ldap leim libg++ libwww lm_sensors mad maildir matroska mbox mikmod mime mmx mmxext mng mono motif mp3 mpeg mpeg2 mule nautilus ncurses nforce2 nls nocardbus nptl nptlonly nsplugin nvidia objc ogg opengl pam pcre pdf pdflib perl plotutils pmu png ppds pppd preview-latex print python qt qt3 qt4 quicktime readline reflection reiserfs samba sdk session slang spell spl sse ssl svg svga t1lib tcltk tcpd theora thunderbird tiff truetype truetype-fonts type1-fonts udev usb vcd videos vorbis win32codecs wmf wxwindows xine xml xorg xosd xv xvid zlib elibc_glibc input_devices_mouse input_devices_keyboard kernel_linux linguas_de userland_GNU video_cards_radeon video_cards_vesa video_cards_fbdev" Unset: CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LDFLAGS, PORTAGE_RSYNC_EXTRA_OPTS
(In reply to comment #5) > apart from pysqlite, I had to emerge sqlite: > 1) "Tests do not work as root" nice to know, but when emerging I will be > root...so maybe tests should be disabled. Set FEATURES=userpriv (well, there was a typo in src_test that i've just fixed) and tests will be run as user portage. But... which version of sqlite prints "Tests do not work as root"? > 2) file collision for /usr/bin/lemon: > # equery belongs /usr/bin/lemon > [ Searching for file(s) /usr/bin/lemon in *... ] > dev-db/sqlite-2.8.16-r1 (/usr/bin/lemon) This is related and should go to bug 118429. Again, which sqlite versions are involved? > But back to pysqlite: > > 1) emerges fine > 2) passes test suite (really fast: Ran 166 tests in 1.193s) > 3) passes collision test > 4) net-im/gajim 0.10.1 emerges fine on it Thanks.
(In reply to comment #6) > > 2) file collision for /usr/bin/lemon: > > # equery belongs /usr/bin/lemon > > [ Searching for file(s) /usr/bin/lemon in *... ] > > dev-db/sqlite-2.8.16-r1 (/usr/bin/lemon) > > This is related and should go to bug 118429. Again, which sqlite versions are > involved? 3.2.1-r3 I'll test 118429, but later...
emerges fine on the sqlite versions from bug #118429 gajim emerges fine too Portage 2.1-r1 (default-linux/x86/2006.0, gcc-3.4.6, glibc-2.3.6-r4, 2.6.17-gentoo-r4 i686) ================================================================= System uname: 2.6.17-gentoo-r4 i686 AMD Athlon(tm) XP 2500+ Gentoo Base System version 1.6.15 app-admin/eselect-compiler: [Not Present] dev-lang/python: 2.4.3-r1 dev-python/pycrypto: 2.0.1-r5 dev-util/ccache: [Not Present] dev-util/confcache: [Not Present] sys-apps/sandbox: 1.2.17 sys-devel/autoconf: 2.13, 2.59-r7 sys-devel/automake: 1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2 sys-devel/binutils: 2.16.1-r3 sys-devel/gcc-config: 1.3.13-r3 sys-devel/libtool: 1.5.22 virtual/os-headers: 2.6.11-r2 ACCEPT_KEYWORDS="x86" AUTOCLEAN="yes" CBUILD="i686-pc-linux-gnu" CFLAGS="-O2" CHOST="i686-pc-linux-gnu" CONFIG_PROTECT="/etc /usr/share/X11/xkb" CONFIG_PROTECT_MASK="/etc/env.d /etc/gconf /etc/revdep-rebuild /etc/splash /etc/terminfo" CXXFLAGS="-O2" DISTDIR="/usr/portage/distfiles" FEATURES="autoconfig ccache collision-protect distlocks metadata-transfer parallel-fetch sandbox sfperms strict test" GENTOO_MIRRORS="ftp://sunsite.informatik.rwth-aachen.de/pub/Linux/gentoo/" LANG="de_DE@euro" LC_ALL="de_DE@euro" LINGUAS="de" MAKEOPTS="-j2" PKGDIR="/usr/portage/packages" PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --delete-after --stats --timeout=180 --exclude='/distfiles' --exclude='/local' --exclude='/packages'" PORTAGE_TMPDIR="/var/tmp" PORTDIR="/usr/portage" PORTDIR_OVERLAY="/usr/local/portage" SYNC="rsync://rsync.informatik.rwth-aachen.de/gentoo-portage" USE="x86 3dnow 3dnowext X Xaw3d a52 alsa arts artworkextra asf audiofile avi bash-completion beagle berkdb bidi bitmap-fonts bootsplash branding bzip2 cairo cdda cddb cdparanoia cdr cli cracklib crypt css cups curl custom-cflags dbus dga directfb divx4linux dlloader dri dts dvd dvdr dvdread dvi eds emacs emboss encode esd evo exif expat fam fat fbcon fdftk ffmpeg firefox foomaticdb fortran ftp gb gcj gdbm gif gnome gpm gstreamer gtk gtk2 gtkhtml hal icq idn imagemagick imap imlib ipv6 isdnlog java javascript jikes jpeg jpeg2k ldap leim libg++ libwww lm_sensors mad maildir matroska mbox mikmod mime mmx mmxext mng mono motif mp3 mpeg mpeg2 mule nautilus ncurses nforce2 nls nocardbus nptl nptlonly nsplugin nvidia objc ogg opengl pam pcre pdf pdflib perl plotutils pmu png ppds pppd preview-latex print python qt qt3 qt4 quicktime readline reflection reiserfs samba sdk session slang spell spl sse ssl svg svga t1lib tcltk tcpd theora thunderbird tiff truetype truetype-fonts type1-fonts udev usb vcd videos vorbis win32codecs wmf wxwindows xine xml xorg xosd xv xvid zlib elibc_glibc input_devices_mouse input_devices_keyboard kernel_linux linguas_de userland_GNU video_cards_radeon video_cards_vesa video_cards_fbdev" Unset: CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LDFLAGS, PORTAGE_RSYNC_EXTRA_OPTS
x86 done
sparc stable.
alpha has already stabilized it.
