Arch Linux

Please read this before reporting a bug:
https://wiki.archlinux.org/title/Bug_reporting_guidelines

Do NOT report bugs when a package is just outdated, or it is in the AUR. Use the 'flag out of date' link on the package page, or the Mailing List.

REPEAT: Do NOT report bugs for outdated packages!
Tasklist

FS#8734 - python-pysqlite causes segfault on 'CREATE TABLE IF NOT EXISTS'

Attached to Project: Arch Linux
Opened by Jeff Bailes (thepizzaking) - Thursday, 22 November 2007, 00:09 GMT
Last edited by Aaron Griffin (phrakture) - Tuesday, 04 December 2007, 05:12 GMT
Task Type Bug Report
Category Packages: Extra
Status Closed
Assigned To Jason Chu (jason)
Aaron Griffin (phrakture)
Architecture i686
Severity High
Priority Normal
Reported Version 2007.08-2
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 1
Private No

Details

I first noticed this bug when trying the SVN version of gajim (the revision which broke it was r8931: http://trac.gajim.org/changeset/8931 .
After talking to gajim's lead developer it appears the problem is caused by python-pysqlite on the CREATE TABLE IF NOT EXISTS call. He used the same versions of sqlite, python-pysqlite and python and didn't get an error.
There is a small python script which reproduces this problem attached to the following gajim ticket: http://trac.gajim.org/ticket/3515
I figure it has to be a python-pysqlite problem since running the same commands in a sqlite console works without error.
This task depends upon

Closed by  Aaron Griffin (phrakture)
Tuesday, 04 December 2007, 05:12 GMT
Reason for closing:  Not a bug
Additional comments about closing:  /shrug
Comment by Herbert Knapp (hknapp) - Sunday, 25 November 2007, 11:51 GMT
I can confirm that. Same problem here.
http://trac.gajim.org/ticket/3576
Comment by Aaron Griffin (phrakture) - Monday, 26 November 2007, 19:21 GMT
Would someone be able to check and see if this fixes things?
http://www.initd.org/tracker/pysqlite/changeset/426

It looks to be a sqlite issue that's fixed with that commit in pysqlite. Perhaps try running a svn version?
Comment by Jeff Bailes (thepizzaking) - Monday, 26 November 2007, 23:05 GMT
I did try the svn version when I first noticed the bug, but it didn't work. I just noticed on the pysqlite homepage that a new version 2.4.0 has been released, I tested on the pysqlite_crash.py from the gajim ticket and it worked without giving a Segmentation Fault. But when trying to run the latest svn version of gajim it still fails with one.
Comment by Aaron Griffin (phrakture) - Monday, 26 November 2007, 23:07 GMT
Adding Jason here, as I think he knows this stuff better than I - and uses Gajim.

I will try to reproduce at home.
Comment by Jeff Bailes (thepizzaking) - Tuesday, 04 December 2007, 04:50 GMT
I just tried gajim SVN again, and I don't get any segmantation faults (with pysqlite 2.4.0). So I suppose that pysqlite version might have fixed the issue, if no-one else is able to reproduce this bug with that version I guess it must be fixed.

Loading...