Skip Menu |

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

Report information
The Basics
Id: 95898
Status: open
Priority: 0/
Queue: DBD-Firebird

People
Owner: Nobody in particular
Requestors: dwheeler [...] cpan.org
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



CC: Slaven Rezic <slaven [...] rezic.de>
Subject: create_database() Hangs on Perl 5.20-RC1
Date: Fri, 23 May 2014 10:17:09 -0400
To: bug-DBD-Firebird [...] rt.cpan.org
From: "David E. Wheeler" <dwheeler [...] cpan.org>
For a set of Sqitch test failures, Slaven Rezic sends this analysis: Begin forwarded message: Show quoted text
> From: Slaven Rezic <slaven@rezic.de> > Subject: Re: FAIL App-Sqitch-0.992 v5.18.2 FreeBSD > Date: May 23, 2014 at 1:32:02 AM EDT > To: "David E. Wheeler" <david@justatheory.com> > Reply-To: slaven@rezic.de > > "David E. Wheeler" <david@justatheory.com> writes: >
>> Hi Slaven, >> >> Might there be something funky with the Firebird install on your FreeBSD boxes? >> >> http://www.cpantesters.org/cpan/report/ad50ad40-cf55-11e3-873f-e2daeda79835 >> http://www.cpantesters.org/cpan/report/625bb928-cf56-11e3-a55f-89e0eda79835 >>
> > Hi David, > > the firebird test simply hangs. I tried to run the test manually with > the perl debugger, and these are the last lines: > > DBD::Firebird::create_database(/usr/perl5.20.0-RC1/lib/site_perl/5.20.0/amd64-freebsd/DBD/Firebird.pm:117): > 117: DBD::Firebird::db::_create_database($params); > DB<6> x $params > 0 HASH(0x80a81dc00) > 'character_set' => 'UTF8' > 'db_path' => '/tmp/__sqitchtest__' > 'page_size' => 16384 > 'password' => 'masterkey' > 'user' => 'SYSDBA' > DB<7> s > > ... and here it hangs. > > Simply running create_database also hangs: > > $ perl5.20.0-RC1 -MDBD::Firebird -e 'DBD::Firebird->create_database({db_path => "/tmp/__sqitchtest__"})' > > The following versions are installed on my system: > > DBD::Firebird 1.17 > > Name : firebird25-client > Version : 2.5.2_2 > > Name : firebird25-server > Version : 2.5.2_4 > > Regards, > Slaven > > -- > Slaven Rezic - slaven <at> rezic <dot> de > BBBike - route planner for cyclists in Berlin > WWW version: http://www.bbbike.de > Perl/Tk version for Unix and Windows: http://bbbike.sourceforge.net
Download signature.asc
application/pgp-signature 842b

Message body not shown because it is not plain text.

Subject: Re: [rt.cpan.org #95898] create_database() Hangs on Perl 5.20-RC1
Date: Sat, 24 May 2014 09:10:54 +0300
To: David Wheeler via RT <bug-DBD-Firebird [...] rt.cpan.org>
From: Damyan Ivanov <dam [...] cpan.org>
-=| David Wheeler via RT, 23.05.2014 10:17:26 -0400 |=- Show quoted text
> For a set of Sqitch test failures, Slaven Rezic sends this analysis: > > Begin forwarded message:
> >> > >> Might there be something funky with the Firebird install on your FreeBSD boxes? > >> > >> http://www.cpantesters.org/cpan/report/ad50ad40-cf55-11e3-873f-e2daeda79835 > >> http://www.cpantesters.org/cpan/report/625bb928-cf56-11e3-a55f-89e0eda79835 > >>
> > > > Hi David, > > > > the firebird test simply hangs. I tried to run the test manually with > > the perl debugger, and these are the last lines: > > > > DBD::Firebird::create_database(/usr/perl5.20.0-RC1/lib/site_perl/5.20.0/amd64-freebsd/DBD/Firebird.pm:117): > > 117: DBD::Firebird::db::_create_database($params); > > DB<6> x $params > > 0 HASH(0x80a81dc00) > > 'character_set' => 'UTF8' > > 'db_path' => '/tmp/__sqitchtest__' > > 'page_size' => 16384 > > 'password' => 'masterkey' > > 'user' => 'SYSDBA' > > DB<7> s > > > > ... and here it hangs. > > > > Simply running create_database also hangs: > > > > $ perl5.20.0-RC1 -MDBD::Firebird -e 'DBD::Firebird->create_database({db_path => "/tmp/__sqitchtest__"})'
Does creating the above database with firebird's isql work? echo "create database '/tmp/__sqitchtest__' page size 16384;" \ | isql -user sysdba -pass masterkey Show quoted text
> > The following versions are installed on my system: > > > > DBD::Firebird 1.17 > > > > Name : firebird25-client > > Version : 2.5.2_2 > > > > Name : firebird25-server > > Version : 2.5.2_4
Is this superserver or classic server? stracing (not sure how it's called on FreeBSD) the server process may give some clues. Cheers, dam
On 2014-05-24 02:11:12, DAM wrote: Show quoted text
> -=| David Wheeler via RT, 23.05.2014 10:17:26 -0400 |=-
> > For a set of Sqitch test failures, Slaven Rezic sends this analysis: > > > > Begin forwarded message:
> > >> > > >> Might there be something funky with the Firebird install on your > > >> FreeBSD boxes? > > >> > > >> http://www.cpantesters.org/cpan/report/ad50ad40-cf55-11e3-873f- > > >> e2daeda79835 > > >> http://www.cpantesters.org/cpan/report/625bb928-cf56-11e3-a55f- > > >> 89e0eda79835 > > >>
> > > > > > Hi David, > > > > > > the firebird test simply hangs. I tried to run the test manually > > > with > > > the perl debugger, and these are the last lines: > > > > > > DBD::Firebird::create_database(/usr/perl5.20.0- > > > RC1/lib/site_perl/5.20.0/amd64-freebsd/DBD/Firebird.pm:117): > > > 117: DBD::Firebird::db::_create_database($params); > > > DB<6> x $params > > > 0 HASH(0x80a81dc00) > > > 'character_set' => 'UTF8' > > > 'db_path' => '/tmp/__sqitchtest__' > > > 'page_size' => 16384 > > > 'password' => 'masterkey' > > > 'user' => 'SYSDBA' > > > DB<7> s > > > > > > ... and here it hangs. > > > > > > Simply running create_database also hangs: > > > > > > $ perl5.20.0-RC1 -MDBD::Firebird -e 'DBD::Firebird-
> > > >create_database({db_path => "/tmp/__sqitchtest__"})'
> > Does creating the above database with firebird's isql work? > > echo "create database '/tmp/__sqitchtest__' page size 16384;" \ > | isql -user sysdba -pass masterkey >
$ echo "create database '/tmp/__sqitchtest__' page size 16384;" | isql-fb -user sysdba -pass masterkey Use CONNECT or CREATE DATABASE to specify a database Statement failed, SQLSTATE = 28000 cannot attach to password database Show quoted text
>
> > > The following versions are installed on my system: > > > > > > DBD::Firebird 1.17 > > > > > > Name : firebird25-client > > > Version : 2.5.2_2 > > > > > > Name : firebird25-server > > > Version : 2.5.2_4
> > Is this superserver or classic server?
The port description seems to enable the superserver: $ grep superserver /usr/ports/databases/firebird25-server/Makefile CONFIGURE_ARGS+=--enable-superserver Show quoted text
> > stracing (not sure how it's called on FreeBSD) the server process may > give some clues. >
Here's the last lines of a ktrace dump, before hitting CTRL-C: 76026 perl5.18.2 1403549402.422951 CALL __sysctl(0x7fffffffc0f0,0x2,0x7fffffffc0ec,0x7fffffffc0f8,0,0) 76026 perl5.18.2 1403549402.423002 SCTL "p1003_1b.pagesize" 76026 perl5.18.2 1403549402.423035 RET __sysctl 0 76026 perl5.18.2 1403549402.423069 CALL mmap(0,0x10000,0x3<PROT_READ|PROT_WRITE>,0x1002<MAP_PRIVATE|MAP_ANON>,0xffffffff,0) 76026 perl5.18.2 1403549402.423107 RET mmap 34367680512/0x800793000 76026 perl5.18.2 1403549402.423936 CALL close(0x3) 76026 perl5.18.2 1403549402.423992 RET close 0 76026 perl5.18.2 1403549402.424320 CALL _umtx_op(0x80304b330,0x11,0,0,0) 76026 perl5.18.2 1403549409.667403 RET _umtx_op RESTART 76026 perl5.18.2 1403549409.667579 PSIG SIGINT SIG_DFL code=SI_KERNEL Regards, Slaven