Bug 183530

Summary: DBD::SQLite broken on devel
Product: [Fedora] Fedora Reporter: Ville Skyttä <scop>
Component: perl-DBD-SQLiteAssignee: Jose Pedro Oliveira <jose.p.oliveira.oss>
Status: CLOSED CURRENTRELEASE QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: medium Docs Contact:
Priority: medium    
Version: 5CC: extras-qa, nigel, rc040203
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: perl-DBD-SQLite-1.12-1 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2006-04-12 15:09:03 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 162161    
Attachments:
Description Flags
Fix for SQLite 3.3 compatibility none

Description Ville Skyttä 2006-03-01 19:51:58 UTC
I guess you knew it already, but let's note it here for others: DBD::SQLite is
broken on devel (both the old one and the new unsuccessful build):

http://buildsys.fedoraproject.org/logs/fedora-development-extras/4873-perl-DBD-SQLite-1.11-2.fc5/
https://www.redhat.com/archives/fedora-perl-devel-list/2006-March/msg00000.html

Comment 1 Jose Pedro Oliveira 2006-03-06 18:23:40 UTC
Sorry for the delay.

Do you mind if I just build DBD::SQLite using the included sqlite library
(USE_LOCAL_SQLITE=1) ?

Right now I don't have much time to look into it; I don't even have a FC-5 test
system available - I'm trying to find an available machine to install it, but
will take a few days.

jpo

Comment 2 Ville Skyttä 2006-03-06 20:34:57 UTC
As usual, it would be better to use the system one.  There's at least one
database corruption bug fixed in SQLite 3.2.x series since the version bundled
in DBD-SQLite, I haven't checked whether it could bite or not.

Comment 3 Jose Pedro Oliveira 2006-03-09 19:46:35 UTC
As a short term solution I building perl-DBD-SQLite with the included version of
sqlite (3.2.7). Right now the FC-4 build is also using the internal sqlite version.

The specfile patch is basically:

-CFLAGS="$RPM_OPT_FLAGS" %{__perl} Makefile.PL INSTALLDIRS=vendor
+CFLAGS="$RPM_OPT_FLAGS" %{__perl} Makefile.PL INSTALLDIRS=vendor USE_LOCAL_SQLITE=1

/jpo


Comment 4 Nigel Metheringham 2006-04-04 07:52:53 UTC
Created attachment 127277 [details]
Fix for SQLite 3.3 compatibility

Comment 5 Nigel Metheringham 2006-04-04 07:53:56 UTC
The CPAN reference for this bug, with fix is
   http://rt.cpan.org/Public/Bug/Display.html?id=18328

I have attached the patch I am using in my rpm (taken from that bug report) to
this entry too.

Comment 6 Jose Pedro Oliveira 2006-04-05 17:13:32 UTC
Package just built for devel with the above patch and the one for bug 187873.

SRPM and build logs available here:
http://buildsys.fedoraproject.org/logs/fedora-development-extras/7258-perl-DBD-SQLite-1.11-4.fc6/

Could someone help test it before I sync the FC-5 branch?  

Thanks in advance,

Comment 7 Jose Pedro Oliveira 2006-04-12 15:09:03 UTC
Updated the devel and FC-5 branch to DBD::SQLite 1.12.
Built using the system sqlite.

SQLite 1.12 internal sqlite version -> 3.3.5
System SQLite version -> 3.3.3

The script
----------
#!/usr/bin/perl -w
use strict;
use DBI;

my $dbh = DBI->connect("dbi:SQLite:dbname=foo", "", "");
print "# sqlite_version = $dbh->{sqlite_version}\n";
$dbh->disconnect;
----------
outputs the following

   # sqlite_version = 3.3.3