Bug#317453: marked as done (libdbd-sqlite2-perl seg faults Perl interpreter)

Debian Bug Tracking System owner at bugs.debian.org
Mon Jan 16 10:04:20 UTC 2006


Your message dated Mon, 16 Jan 2006 01:47:09 -0800
with message-id <E1EyQxB-0000RE-6Y at spohr.debian.org>
and subject line Bug#317453: fixed in libdbd-sqlite2-perl 2:0.33-6
has caused the attached Bug report to be marked as done.

This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.

(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere.  Please contact me immediately.)

Debian bug tracking system administrator
(administrator, Debian Bugs database)

--------------------------------------
Received: (at submit) by bugs.debian.org; 8 Jul 2005 17:01:21 +0000
>From steve at moonglade.com Fri Jul 08 10:01:21 2005
Return-path: <steve at moonglade.com>
Received: from adsl-67-113-229-161.dsl.snfc21.pacbell.net (calvin.moonglade.com) [67.113.229.161] 
	by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
	id 1DqwE5-0006i1-00; Fri, 08 Jul 2005 10:01:21 -0700
Received: from [65.192.41.225] (helo=[172.16.0.45])
	by calvin.moonglade.com with esmtpsa (TLS-1.0:DHE_RSA_AES_256_CBC_SHA:32)
	(Exim 4.50)
	id 1DqwE4-0003Tq-J4
	for submit at bugs.debian.org; Fri, 08 Jul 2005 10:01:20 -0700
Message-ID: <42CEB159.2080306 at moonglade.com>
Date: Fri, 08 Jul 2005 10:01:13 -0700
From: Steve Madsen <steve at moonglade.com>
User-Agent: Mozilla Thunderbird 1.0.2 (Macintosh/20050317)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: submit at bugs.debian.org
Subject: libdbd-sqlite2-perl seg faults Perl interpreter
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Delivered-To: submit at bugs.debian.org
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02 
	(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Status: No, hits=-8.0 required=4.0 tests=BAYES_00,HAS_PACKAGE 
	autolearn=no version=2.60-bugs.debian.org_2005_01_02
X-Spam-Level: 

Package: libdbd-sqlite2-perl
Version: 2:0.33-3

Running two concurrent queries with DBD::SQLite2 crashes the Perl 
interpreter with a segmentation fault.  Here is a sample script and 
database that reproduces the problem:

#!/usr/bin/perl

use strict;
use warnings;
use DBI;

my($dbh,$q1,$q2);
$dbh = DBI->connect("dbi:SQLite2:test.db");

$q1 = $dbh->prepare("SELECT * FROM test WHERE col1 = ?");
$q1->execute(0);
$q2 = $dbh->prepare("SELECT * FROM test WHERE col1 = ?");
$q2->execute(1);

my (@row);
while (1) {
     if (@row = $q1->fetchrow()) {
         print "q1 fetch, id=$row[0], col1=$row[1], col2=$row[2]\n";
     } elsif (@row = $q2->fetchrow()) {
         print "q2 fetch, id=$row[0], col1=$row[1], col2=$row[2]\n";
     } else {
         last;
     }
}

$q1->finish();
$q2->finish();

$dbh->disconnect();

exit 0; 


Create "test.db" using the following SQL:

create table test (id INTEGER PRIMARY KEY, col1 INTEGER, col2 INTEGER);
insert into test (id, col1, col2) values (1, 0, 0);
insert into test (id, col1, col2) values (2, 0, 1);
insert into test (id, col1, col2) values (3, 1, 0);
insert into test (id, col1, col2) values (4, 1, 1); 


The output of the script with this database is:

q1 fetch, id=1, col1=0, col2=0
q1 fetch, id=2, col1=0, col2=1
q2 fetch, id=3, col1=1, col2=0
Segmentation fault

I expect that the final line should be "q2 fetch, id=4, col1=1, col2=1". 


Debian 3.1, kernel 2.4.30, libc 2.3.2.ds1-22, Perl 5.8.4.  All the 
expected dependencies are current with sarge and any released security 
updates.

-- 
Steve Madsen <steve at moonglade.com>

---------------------------------------
Received: (at 317453-close) by bugs.debian.org; 16 Jan 2006 09:50:32 +0000
>From katie at ftp-master.debian.org Mon Jan 16 01:50:32 2006
Return-path: <katie at ftp-master.debian.org>
Received: from katie by spohr.debian.org with local (Exim 4.50)
	id 1EyQxB-0000RE-6Y; Mon, 16 Jan 2006 01:47:09 -0800
From: Niko Tyni <ntyni at iki.fi>
To: 317453-close at bugs.debian.org
X-Katie: $Revision: 1.65 $
Subject: Bug#317453: fixed in libdbd-sqlite2-perl 2:0.33-6
Message-Id: <E1EyQxB-0000RE-6Y at spohr.debian.org>
Sender: Archive Administrator <katie at ftp-master.debian.org>
Date: Mon, 16 Jan 2006 01:47:09 -0800
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02 
	(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Level: 
X-Spam-Status: No, hits=-6.0 required=4.0 tests=BAYES_00,HAS_BUG_NUMBER 
	autolearn=no version=2.60-bugs.debian.org_2005_01_02

Source: libdbd-sqlite2-perl
Source-Version: 2:0.33-6

We believe that the bug you reported is fixed in the latest version of
libdbd-sqlite2-perl, which is due to be installed in the Debian FTP archive:

libdbd-sqlite2-perl_0.33-6.diff.gz
  to pool/main/libd/libdbd-sqlite2-perl/libdbd-sqlite2-perl_0.33-6.diff.gz
libdbd-sqlite2-perl_0.33-6.dsc
  to pool/main/libd/libdbd-sqlite2-perl/libdbd-sqlite2-perl_0.33-6.dsc
libdbd-sqlite2-perl_0.33-6_i386.deb
  to pool/main/libd/libdbd-sqlite2-perl/libdbd-sqlite2-perl_0.33-6_i386.deb



A summary of the changes between this version and the previous one is
attached.

Thank you for reporting the bug, which will now be closed.  If you
have further comments please address them to 317453 at bugs.debian.org,
and the maintainer will reopen the bug report if appropriate.

Debian distribution maintenance software
pp.
Niko Tyni <ntyni at iki.fi> (supplier of updated libdbd-sqlite2-perl package)

(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing ftpmaster at debian.org)


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Format: 1.7
Date: Sun, 15 Jan 2006 22:29:25 +0200
Source: libdbd-sqlite2-perl
Binary: libdbd-sqlite2-perl
Architecture: source i386
Version: 2:0.33-6
Distribution: unstable
Urgency: low
Maintainer: Debian Perl Group <pkg-perl-maintainers at lists.alioth.debian.org>
Changed-By: Niko Tyni <ntyni at iki.fi>
Description: 
 libdbd-sqlite2-perl - Perl DBI driver with a self-contained RDBMS (SQLite2 version)
Closes: 317453
Changes: 
 libdbd-sqlite2-perl (2:0.33-6) unstable; urgency=low
 .
   * Use dpatch for managing patches.
   * Add myself to Uploaders.
   * debian/patches/10fetchrow:
     + Fix segmentation fault when fetchrow() is called again after
       it has returned an empty list once. (Closes: #317453)
   * Add debian/watch.
Files: 
 9ee671c4696088b88c42d78536d51bc8 820 perl optional libdbd-sqlite2-perl_0.33-6.dsc
 aacf63fd5dad2b216c8e74cf2d2d74ee 4181 perl optional libdbd-sqlite2-perl_0.33-6.diff.gz
 f01eae0347954d0705e61f02a4a3d5c1 187154 perl optional libdbd-sqlite2-perl_0.33-6_i386.deb

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)

iD8DBQFDy2bq+NMfSd6w7DERAgPuAJ9CeiDmSzwTbhniOrjR9mGhVNJIdgCgjcOl
Ws+BtCV+uB9fMqkRsn4ITPY=
=giyZ
-----END PGP SIGNATURE-----




More information about the pkg-perl-maintainers mailing list