Bug#479315: clive throws stack trace
Twas brillig at 06:18:20 06.05.2008 UTC+03 when Toni Gundogdu did gyre and gimble: TG Is the python2.5 package installed with the sqlite3 module? Yes, and as python2.5 is now default python version in unstable, dependencies are correct. TG Is not the reason. There must be something wrong in src/clive/cache.py: TG Cache::_upgrade_if_needed method. TG Unfortunately I haven't been able to reproduce this bug yet, so TG until the culprit is found, the quick fix is to remove the cache TG file manually or disable the caching altogether. Won't you object if I temporarily add a kludge to Debian package which removes cache file instead of upgrading it? However, it depends whether upgrading cache went wrong or detecting that upgrade is necessary. -- pgpn1nF2DX5Et.pgp Description: PGP signature
Bug#479315: clive throws stack trace
Mikhail Gusarov wrote: Won't you object if I temporarily add a kludge to Debian package which removes cache file instead of upgrading it? I see no harm in doing that. However, it depends whether upgrading cache went wrong or detecting that upgrade is necessary. Remove the cache file if the error is raised? Sounds good to me. Less hassle, too. -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Bug#479315: clive throws stack trace
Just a follow up. I tried to reproduce this bug on systems with: * sqlite-3.5.6; python-2.5.2 * sqlite-3.4.2; python-2.5.2 I used: * clive-0.4.7 * clive-0.4.9 To create a database (~/.clive/cache) without the cache_lowq column which was added in clive-0.4.10. I then tried to get Python to raise the OperationalError with: * clive-0.4.11 Which did not occur. clive-0.4.11 upgraded the database everytime as it was supposed to. I'll look into adding a safeguard for the OperationalError in clive-0.4.12 which will cause clive to reset the cache automagically. -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Bug#479315: clive throws stack trace
Hi! Stumbled into the same problem as Rainer, so I hope my feedback is valueable, too. On Sun, May 04, 2008 at 07:56:21PM +0700, Mikhail Gusarov wrote: Twas brillig at 11:24:44 04.05.2008 UTC+02 when Rainer Dorsch did gyre and gimble: RD I installed the new clive version on my lenny system, but I was RD unable to run it. Is a depencency missing? Seems so. Does problem disapper after installing python-pysqlite2? No, but that dependency is indeed missing. On Sun, May 04, 2008 at 08:13:21PM +0300, Toni Gundogdu wrote: Rainer Dorsch wrote: OperationalError: no such column: cache_lowq Try removing the ~/.clive/cache file. That column was added recently. Removing that file makes it indeed work again. clive should have upgraded the cache file automagically, though. Doesn't seem to have happened, at least for Rainer and me. What version of sqlite3 do you have installed? python-pysqlite2 2.4.1-1 Python interface to SQLite 3 Hope that helps to find the problem! Rhonda -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Bug#479315: clive throws stack trace
Mikhail Gusarov wrote: Seems so. Does problem disapper after installing python-pysqlite2? Gerfried Fuchs wrote: No, but that dependency is indeed missing. Is the python2.5 package installed with the sqlite3 module? That module was not previously (= 2.4) distributed with Python but had to be installed separately (python-pysqlite2?). Apart from the difference how these modules are being distributed, the only other difference that I am aware of is how they are imported: * import sqlite3 # This is what clive uses * from pysqlite2 import dbapi2 as sqlite So with this in mind I don't think that the python-pysqlite2 is required. Perhaps someone who's more familiar with Debian Python packages could give a better answer. Gerfried Fuchs wrote: python-pysqlite2 2.4.1-1 Python interface to SQLite 3 I think that package depends on libsqlite3-0 (= 3.4.2) so it's probably safe to assume: After ADD COLUMN has been run on a database, that database will not be readable by SQLite version 3.1.3 and earlier. -- http://www.sqlite.org/lang_altertable.html Is not the reason. There must be something wrong in src/clive/cache.py: Cache::_upgrade_if_needed method. Unfortunately I haven't been able to reproduce this bug yet, so until the culprit is found, the quick fix is to remove the cache file manually or disable the caching altogether. -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Bug#479315: clive throws stack trace
Package: clive Version: 0.4.11-1 Severity: normal I installed the new clive version on my lenny system, but I was unable to run it. Is a depencency missing? Many thanks, Rainer blackbox:~# aptitude install clive=0.4.11-1 Reading package lists... Done Building dependency tree Reading state information... Done Reading extended state information Initializing package states... Done Reading task descriptions... Done The following NEW packages will be installed: clive python-chardet{a} python-ctypes{a} python-feedparser{a} python-libxml2{a} python-urlgrabber{a} python-utidylib{a} 0 packages upgraded, 7 newly installed, 0 to remove and 3 not upgraded. Need to get 772kB/829kB of archives. After unpacking 4229kB will be used. Do you want to continue? [Y/n/?] Writing extended state information... Done Get:1 http://ftp-stud.fht-esslingen.de lenny/main python-feedparser 4.1-10 [125kB] Get:2 http://ftp-stud.fht-esslingen.de sid/main clive 0.4.11-1 [45.5kB] Get:3 http://ftp-stud.fht-esslingen.de lenny/main python-chardet 1.0.1-1 [171kB] Get:4 http://ftp-stud.fht-esslingen.de lenny/main python-ctypes 1.0.2-4 [159kB] Get:5 http://ftp-stud.fht-esslingen.de lenny/main python-libxml2 2.6.32.dfsg-2 [263kB] Get:6 http://ftp-stud.fht-esslingen.de lenny/main python-utidylib 0.2-3.1 [8060B] Fetched 772kB in 3s (216kB/s) Selecting previously deselected package python-urlgrabber. (Reading database ... 235251 files and directories currently installed.) Unpacking python-urlgrabber (from .../python-urlgrabber_3.1.0-4_all.deb) ... Selecting previously deselected package python-feedparser. Unpacking python-feedparser (from .../python-feedparser_4.1-10_all.deb) ... Selecting previously deselected package clive. Unpacking clive (from .../clive_0.4.11-1_all.deb) ... Selecting previously deselected package python-chardet. Unpacking python-chardet (from .../python-chardet_1.0.1-1_all.deb) ... Selecting previously deselected package python-ctypes. Unpacking python-ctypes (from .../python-ctypes_1.0.2-4_i386.deb) ... Selecting previously deselected package python-libxml2. Unpacking python-libxml2 (from .../python-libxml2_2.6.32.dfsg-2_i386.deb) ... Selecting previously deselected package python-utidylib. Unpacking python-utidylib (from .../python-utidylib_0.2-3.1_all.deb) ... Setting up python-urlgrabber (3.1.0-4) ... Setting up python-feedparser (4.1-10) ... Setting up clive (0.4.11-1) ... Setting up python-chardet (1.0.1-1) ... Setting up python-ctypes (1.0.2-4) ... Setting up python-libxml2 (2.6.32.dfsg-2) ... Setting up python-utidylib (0.2-3.1) ... Reading package lists... Done Building dependency tree Reading state information... Done Reading extended state information Initializing package states... Done Writing extended state information... Done Reading task descriptions... Done blackbox:~# logout [EMAIL PROTECTED]:~$ clive http://www.youtube.com/watch?v=4XpnKHJAok8 clive/0.4.11 (linux/2.6.24; py/2.5.2; urlg/3.1.0; fparser/4.1) cache:yes; paste:off; play:off; encode:off; rate:off; exist:rename error: Traceback (most recent call last): File /usr/bin/clive, line 28, in module Clive().main() File /usr/lib/python2.5/site-packages/clive/main.py, line 51, in main Nomad().run(self.opts, self.args, self._say) File /usr/lib/python2.5/site-packages/clive/nomad.py, line 94, in run self._check_raw_urls(raw_urls) File /usr/lib/python2.5/site-packages/clive/nomad.py, line 254, in _check_raw_urls self._check_url(url, (index,len(raw_urls))) File /usr/lib/python2.5/site-packages/clive/nomad.py, line 297, in _check_url cache_row = self._cache.read(url) File /usr/lib/python2.5/site-packages/clive/cache.py, line 112, in read 'from cache where cache_hash=?', (hash,)) OperationalError: no such column: cache_lowq [EMAIL PROTECTED]:~$ -- System Information: Debian Release: lenny/sid APT prefers testing APT policy: (400, 'testing'), (300, 'unstable'), (200, 'experimental') Architecture: i386 (i686) Kernel: Linux 2.6.24-1-686 (SMP w/2 CPU cores) Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/bash Versions of packages clive depends on: ii python 2.5.2-1 An interactive high-level object-o ii python-central 0.6.6 register and build utility for Pyt ii python-feedparser4.1-10 Universal Feed Parser for Python ii python-newt 0.52.2-11.2 A NEWT module for Python ii python-urlgrabber3.1.0-4 A high-level cross-protocol url-gr clive recommends no packages. -- no debconf information -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Bug#479315: clive throws stack trace
Twas brillig at 11:24:44 04.05.2008 UTC+02 when Rainer Dorsch did gyre and gimble: RD I installed the new clive version on my lenny system, but I was RD unable to run it. Is a depencency missing? Seems so. Does problem disapper after installing python-pysqlite2? -- pgpoHO0UiSdcj.pgp Description: PGP signature
Bug#479315: clive throws stack trace
Rainer Dorsch wrote: OperationalError: no such column: cache_lowq Try removing the ~/.clive/cache file. That column was added recently. clive should have upgraded the cache file automagically, though. What version of sqlite3 do you have installed? -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]