Skip Menu |

This queue is for tickets about the DBD-SQLite CPAN distribution.

Report information
The Basics
Id: 104884
Status: resolved
Priority: 0/
Queue: DBD-SQLite
People
Owner: Nobody in particular
Requestors: rch [...] skynet.be
Cc:
AdminCc:
Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)

History Show all quoted text
  Tue Jun 02 14:50:03 2015 rch [...] skynet.be - Ticket created
Subject: 60647_ DBD-SQLite; Thank you - and a suggestion
Date: Tue, 02 Jun 2015 20:49:45 +0200
To: bug-DBD-SQLite [...] rt.cpan.org
From: rch <rch [...] skynet.be>
   ===============================================
                           Bruxelles
                            2015_06_02    
   
    Dear bug-DBD-SQLite
    
    Thank you for Perl module DBD-SQLite.

    I've used it several times a day for years,
    with much success and narry a problem.
    

  Little problem -
    Today I tried DBD-SQLite on a Zotero sqlite database
    and immediately started getting strange error message -
        «Can't call method "execute" on an undefined value
         at/usr/lib/perl5/DBD/SQLite.pm line 240»

  Diagnosis -
        $ fuser zotero.sqlite
    showed that there was already another process using the file
    and this provoked the error.

    Even though I had closed zotero in Mozilla Firefox,
    problem persisted till closed Mozilla Firefox
    completely. Then the problem went away and DBD-SQLite
    worked nicely.

  Suggested solution -
    Would it be possible to add a line to that error message
    so that it reads
        «Can't call method "execute" on an undefined value at
        /usr/lib/perl5/DBD/SQLite.pm line NNN
        This can happen if the SQLite database is already
        opened by another application»
    ?

     Yours sincerely / Vriendelijke groeten / Bien cordialement

     Richard Hardwick
     ===============================================

Perl script that generates the error if sqlite database is in use by a.n.other -
   my $db     = shift;
   my $dbh    = DBI->connect( "dbi:SQLite:$db" ) || die "Cannot connect: $DBI::errstr";
   # Error occurs here; next line is not invoked
   my @lots_of_names  = $dbh->tables;                  

Details my system -
   Distribution name and version :- package DBD::SQLite;use 5.006;use strict;use DBI   1.57 ();                  
   Perl version:- This is perl 5, version 14, subversion 2 (v5.14.2) built for i686-linux-gnu-thread-multi-64int
   Operating System vendor and version:- Linux Ubuntu 3.2.0-84-generic-pae #121-Ubuntu SMP Tue May 5 19:08:01 UTC 2015 i686 i686 i386 GNU/Linux


Details of me -
    I'm a just botanist, not a computer person

     ===============================================
        -------- End of Original Message --------
     Envoyé depuis Thunderbird Mail pour Linux
    Made by /home/rch/Public/Data/Sqlite/workarea/Make_email_V008.pl
    using  /home/rch/Public/Data/Sqlite/workarea/cfg_file_V002_.txt


  Tue Jun 02 22:49:48 2015 ishigaki [...] cpan.org - Correspondence added
On Wed Jun 03 03:50:03 2015, rch@skynet.be wrote: Show quoted text
> =============================================== > Bruxelles > 2015_06_02 > > Dear bug-DBD-SQLite > > Thank you for Perl module DBD-SQLite. > > I've used it several times a day for years, > with much success and narry a problem. > > > Little problem - > Today I tried DBD-SQLite on a Zotero sqlite database > and immediately started getting strange error message - > «Can't call method "execute" on an undefined value > at/usr/lib/perl5/DBD/SQLite.pm line 240»
Could you tell me 1) the version of DBD::SQLite, 2) the version of DBI, 3) and a small code snippet to show how you connected to your database (by DBI->connect or with some O/R mapper, etc) and exactly what method you have called to trigger this error (or the whole script you used), by pasting here, or by emailing to ishigaki@cpan.org? Show quoted text
> > Diagnosis - > $ fuser zotero.sqlite > showed that there was already another process using the file > and this provoked the error. > > Even though I had closed zotero in Mozilla Firefox, > problem persisted till closed Mozilla Firefox > completely. Then the problem went away and DBD-SQLite > worked nicely. > > Suggested solution - > Would it be possible to add a line to that error message > so that it reads > «Can't call method "execute" on an undefined value at > /usr/lib/perl5/DBD/SQLite.pm line NNN > This can happen if the SQLite database is already > opened by another application» > ? > > Yours sincerely / Vriendelijke groeten / Bien cordialement > > Richard Hardwick > =============================================== > > Perl script that generates the error if sqlite database is in use by > a.n.other > - > my $db = shift; > my $dbh = DBI->connect( "dbi:SQLite:$db" ) || die "Cannot connect: > $DBI::errstr"; > # Error occurs here; next line is not invoked > my @lots_of_names = $dbh->tables; > > Details my system - > Distribution name and version :- package DBD::SQLite;use 5.006;use > strict;use > DBI 1.57 (); > Perl version:- This is perl 5, version 14, subversion 2 (v5.14.2) > built for > i686-linux-gnu-thread-multi-64int > Operating System vendor and version:- Linux Ubuntu 3.2.0-84-generic- > pae > #121-Ubuntu SMP Tue May 5 19:08:01 UTC 2015 i686 i686 i386 GNU/Linux > > > Details of me - > I'm a just botanist, not a computer person > > =============================================== > -------- End of Original Message -------- > Envoyé depuis Thunderbird Mail pour Linux > Made by /home/rch/Public/Data/Sqlite/workarea/Make_email_V008.pl > using /home/rch/Public/Data/Sqlite/workarea/cfg_file_V002_.txt
  Tue Jun 02 22:49:49 2015 The RT System itself - Status changed from 'new' to 'open'
  Mon Jan 11 12:47:54 2016 ishigaki [...] cpan.org - Correspondence added
I hope this is fixed in 1.49_05. Thanks. On Wed Jun 03 11:49:48 2015, ISHIGAKI wrote: Show quoted text
> On Wed Jun 03 03:50:03 2015, rch@skynet.be wrote:
> > =============================================== > > Bruxelles > > 2015_06_02 > > > > Dear bug-DBD-SQLite > > > > Thank you for Perl module DBD-SQLite. > > > > I've used it several times a day for years, > > with much success and narry a problem. > > > > > > Little problem - > > Today I tried DBD-SQLite on a Zotero sqlite database > > and immediately started getting strange error message - > > «Can't call method "execute" on an undefined value > > at/usr/lib/perl5/DBD/SQLite.pm line 240»
> > Could you tell me 1) the version of DBD::SQLite, 2) the version of > DBI, 3) and a small code snippet to show how you connected to your > database (by DBI->connect or with some O/R mapper, etc) and exactly > what method you have called to trigger this error (or the whole script > you used), by pasting here, or by emailing to ishigaki@cpan.org? >
> > > > Diagnosis - > > $ fuser zotero.sqlite > > showed that there was already another process using the file > > and this provoked the error. > > > > Even though I had closed zotero in Mozilla Firefox, > > problem persisted till closed Mozilla Firefox > > completely. Then the problem went away and DBD-SQLite > > worked nicely. > > > > Suggested solution - > > Would it be possible to add a line to that error message > > so that it reads > > «Can't call method "execute" on an undefined value at > > /usr/lib/perl5/DBD/SQLite.pm line NNN > > This can happen if the SQLite database is already > > opened by another application» > > ? > > > > Yours sincerely / Vriendelijke groeten / Bien cordialement > > > > Richard Hardwick > > =============================================== > > > > Perl script that generates the error if sqlite database is in use by > > a.n.other > > - > > my $db = shift; > > my $dbh = DBI->connect( "dbi:SQLite:$db" ) || die "Cannot connect: > > $DBI::errstr"; > > # Error occurs here; next line is not invoked > > my @lots_of_names = $dbh->tables; > > > > Details my system - > > Distribution name and version :- package DBD::SQLite;use 5.006;use > > strict;use > > DBI 1.57 (); > > Perl version:- This is perl 5, version 14, subversion 2 (v5.14.2) > > built for > > i686-linux-gnu-thread-multi-64int > > Operating System vendor and version:- Linux Ubuntu 3.2.0-84-generic- > > pae > > #121-Ubuntu SMP Tue May 5 19:08:01 UTC 2015 i686 i686 i386 GNU/Linux > > > > > > Details of me - > > I'm a just botanist, not a computer person > > > > =============================================== > > -------- End of Original Message -------- > > Envoyé depuis Thunderbird Mail pour Linux > > Made by /home/rch/Public/Data/Sqlite/workarea/Make_email_V008.pl > > using /home/rch/Public/Data/Sqlite/workarea/cfg_file_V002_.txt
  Mon Jan 11 12:47:55 2016 ishigaki [...] cpan.org - Status changed from 'open' to 'patched'
  Wed Feb 10 10:06:25 2016 ishigaki [...] cpan.org - Correspondence added
Closed as 1.50 was shipped. Thanks.
  Wed Feb 10 10:06:27 2016 ishigaki [...] cpan.org - Status changed from 'patched' to 'resolved'