Skip Menu |

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

Report information
The Basics
Id: 90635
Status: resolved
Worked: 20 min
Priority: 0/
Queue: CPAN-SQLite
People
Owner: Nobody in particular
Requestors: CHORNY [...] cpan.org
Cc:
AdminCc:
Bug Information
Severity: Important
Broken in: 0.203
Fixed in: 0.204

History Show all quoted text
  Fri Nov 22 13:53:18 2013 CHORNY [...] cpan.org - Ticket created
Subject: DBD::SQLite::st execute failed: database is locked
DBD::SQLite 1.40 - 1.38_01 has this problem, 1.37 does not CPAN: CPAN::SQLite loaded ok (v0.203) Database was generated on Fri, 22 Nov 2013 18:48:18 GMT DBD::SQLite::st execute failed: database is locked at C:\strawberry\perl\site\li b/CPAN/SQLite/DBI/Search.pm line 99. DBD::SQLite::st execute failed: database is locked at C:\strawberry\perl\site\li b/CPAN/SQLite/DBI/Search.pm line 99. I'm calling cpan from other program that uses CPAN.pm. If I call cpan manually, problem does not appear. -- Alexandr Ciornii, http://chorny.net
  Fri Nov 22 14:15:07 2013 CHORNY [...] cpan.org - Correspondence added
This patch makes newer DBD::SQLite behave like older. -- Alexandr Ciornii, http://chorny.net
Subject: DBI.pm.patch
--- DBI.pm.orig 2013-06-30 00:15:33.000000000 +0300 +++ DBI.pm 2013-11-22 21:14:26.140625000 +0200 @@ -89,7 +89,9 @@ my $db_dir = $args{db_dir} || $args{CPAN}; my $db = File::Spec->catfile($db_dir, $args{db_name}); $dbh ||= DBI->connect("DBI:SQLite:$db", '', '', - {RaiseError => 1, AutoCommit => 0}); + {RaiseError => 1, AutoCommit => 0, + sqlite_use_immediate_transaction => 0, #temporary fix + }); die "Cannot connect to $db" unless $dbh; $dbh->{AutoCommit} = 0;
  Fri Dec 27 18:30:53 2013 CHORNY [...] cpan.org - Correspondence added
Note: this patch does not work in some case, but it is much better than nothing. -- Alexandr Ciornii, http://chorny.net
  Mon Aug 04 15:04:52 2014 stro [...] cpan.org - Correspondence added 20 min
On Fri Dec 27 18:30:53 2013, CHORNY wrote: Show quoted text
> Note: this patch does not work in some case, but it is much better > than nothing.
Thanks for you patch, I've added it to the newly released 0.204. Sorry for the very late reply, this issue completely fell off my radar, otherwise I'd make this change sooner. -- Serguei Trouchelle
  Mon Aug 04 15:04:52 2014 The RT System itself - Status changed from 'new' to 'open'
  Mon Aug 04 15:04:53 2014 stro [...] cpan.org - Status changed from 'open' to 'resolved'
  Mon Aug 04 15:04:54 2014 stro [...] cpan.org - Fixed in 0.204 added