Skip Menu |

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

Report information
The Basics
Id: 88865
Status: resolved
Priority: 0/
Queue: DBD-Pg
People
Owner: greg [...] turnstep.com
Requestors: boris.malensek [...] gmail.com
gregoa [...] debian.org
Cc:
AdminCc:
Bug Information
Severity: Normal
Broken in: (no value)
Fixed in: 3.0.0

History Show all quoted text
  Wed Sep 18 03:26:42 2013 boris.malensek [...] gmail.com - Ticket #88772: Ticket created
Subject: Bug: Failed test 'DB handle attribute "PrintWarn" shows warnings when on'
Date: Wed, 18 Sep 2013 09:26:32 +0200
To: bug-DBD-Pg [...] rt.cpan.org
From: Boris Malenšek <boris.malensek [...] gmail.com>
Hello! I'm using PostgreSQL 9.2.4 and perl v5.14.2. When I try to install DBD::Pg with cpan I'm getting following error: t/02attribs.t ....... 8/249 # Failed test 'DB handle attribute "PrintWarn" shows warnings when on' # at t/02attribs.t line 263. # '' # doesn't match '(?^:dbd_pg_test_temp)' t/02attribs.t ....... 231/249 # Looks like you failed 1 test of 249. t/02attribs.t ....... Dubious, test returned 1 (wstat 256, 0x100) Failed 1/249 subtests And DBD::Pg cannot be installed. Known issue? Best, Boris
  Sat Sep 21 13:36:14 2013 gregoa [...] cpan.org - Ticket created
From: gregoa [...] cpan.org
Subject: FTBFS: Failed test 'DB handle attribute "PrintWarn" shows warnings when on'
This bug has been forwarded from http://bugs.debian.org/723928 -->-->-->-->-->-->-->-->-->-->-->-->-->-->-->-->-->-->-->--> Package: src:libdbd-pg-perl Version: 2.19.3-1 Severity: serious Justification: FTBFS libdbd-pg-perl fails to build in a clean sid pbuilder chroot: t/01constants.t ..... ok # Failed test 'DB handle attribute "PrintWarn" shows warnings when on' # at t/02attribs.t line 263. # '' # doesn't match '(?^:dbd_pg_test_temp)' # Looks like you failed 1 test of 249. t/02attribs.t ....... Dubious, test returned 1 (wstat 256, 0x100) Failed 1/249 subtests -- dam <--<--<--<--<--<--<--<--<--<--<--<--<--<--<--<--<--<--<--<-- Please note that this is against PostgreSQL 9.3.0. More complete log: I: Running cd tmp/buildd/*/ && env PATH="/usr/lib/ccache:/usr/sbin:/usr/bin:/sbin:/bin" dpkg-buildpackage -us -uc -rfakeroot dpkg-buildpackage: source package libdbd-pg-perl dpkg-buildpackage: source version 2.19.3-1 dpkg-buildpackage: source distribution unstable dpkg-buildpackage: source changed by Xavier Guimard <x.guimard@free.fr> dpkg-source --before-build libdbd-pg-perl-2.19.3 dpkg-buildpackage: host architecture amd64 fakeroot debian/rules clean dh clean --with perl_dbi dh_testdir dh_auto_clean dh_clean dpkg-source -b libdbd-pg-perl-2.19.3 dpkg-source: info: using source format `3.0 (quilt)' dpkg-source: info: building libdbd-pg-perl using existing ./libdbd-pg-perl_2.19.3.orig.tar.gz dpkg-source: info: building libdbd-pg-perl in libdbd-pg-perl_2.19.3-1.debian.tar.gz dpkg-source: info: building libdbd-pg-perl in libdbd-pg-perl_2.19.3-1.dsc debian/rules build dh build --with perl_dbi dh_testdir dh_auto_configure Configuring DBD::Pg 2.19.3 PostgreSQL version: 90300 (default port: 5432) POSTGRES_HOME: (not set) POSTGRES_INCLUDE: /usr/include/postgresql POSTGRES_LIB: /usr/lib OS: linux Checking if your kit is complete... Looks good Using DBI 1.628 (for perl 5.018001 on x86_64-linux-gnu-thread-multi) installed in /usr/lib/perl5/auto/DBI/ Writing Makefile for DBD::Pg Writing MYMETA.yml and MYMETA.json dh_auto_build make[1]: Entering directory `/tmp/buildd/libdbd-pg-perl-2.19.3' cp testme.tmp.pl blib/lib/DBD/testme.tmp.pl cp lib/Bundle/DBD/Pg.pm blib/lib/Bundle/DBD/Pg.pm cp Pg.pm blib/lib/DBD/Pg.pm /usr/bin/perl -p -e "s/~DRIVER~/Pg/g; s/^do\(/dontdo\(/" /usr/lib/perl5/auto/DBI/Driver.xst > Pg.xsi /usr/bin/perl /usr/share/perl/5.18/ExtUtils/xsubpp -typemap /usr/share/perl/5.18/ExtUtils/typemap Pg.xs > Pg.xsc && mv Pg.xsc Pg.c cc -c -I/usr/include/postgresql -I/usr/lib/perl5/auto/DBI -D_REENTRANT -D_GNU_SOURCE -DDEBIAN -fstack-protector -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DPGLIBVERSION=90300 -DPGDEFPORT=5432 -g -O2 -fstack-protector --param=ssp-buffer-size=4 -Wformat -Werror=format-security -D_FORTIFY_SOURCE=2 -DPERL_EXTMALLOC_DEF -Dmalloc=Perl_malloc -Dfree=Perl_mfree -Drealloc=Perl_realloc -Dcalloc=Perl_calloc -DVERSION=\"2.19.3\" -DXS_VERSION=\"2.19.3\" -fPIC "-I/usr/lib/perl/5.18/CORE" Pg.c cc -c -I/usr/include/postgresql -I/usr/lib/perl5/auto/DBI -D_REENTRANT -D_GNU_SOURCE -DDEBIAN -fstack-protector -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DPGLIBVERSION=90300 -DPGDEFPORT=5432 -g -O2 -fstack-protector --param=ssp-buffer-size=4 -Wformat -Werror=format-security -D_FORTIFY_SOURCE=2 -DPERL_EXTMALLOC_DEF -Dmalloc=Perl_malloc -Dfree=Perl_mfree -Drealloc=Perl_realloc -Dcalloc=Perl_calloc -DVERSION=\"2.19.3\" -DXS_VERSION=\"2.19.3\" -fPIC "-I/usr/lib/perl/5.18/CORE" dbdimp.c cc -c -I/usr/include/postgresql -I/usr/lib/perl5/auto/DBI -D_REENTRANT -D_GNU_SOURCE -DDEBIAN -fstack-protector -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DPGLIBVERSION=90300 -DPGDEFPORT=5432 -g -O2 -fstack-protector --param=ssp-buffer-size=4 -Wformat -Werror=format-security -D_FORTIFY_SOURCE=2 -DPERL_EXTMALLOC_DEF -Dmalloc=Perl_malloc -Dfree=Perl_mfree -Drealloc=Perl_realloc -Dcalloc=Perl_calloc -DVERSION=\"2.19.3\" -DXS_VERSION=\"2.19.3\" -fPIC "-I/usr/lib/perl/5.18/CORE" quote.c cc -c -I/usr/include/postgresql -I/usr/lib/perl5/auto/DBI -D_REENTRANT -D_GNU_SOURCE -DDEBIAN -fstack-protector -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DPGLIBVERSION=90300 -DPGDEFPORT=5432 -g -O2 -fstack-protector --param=ssp-buffer-size=4 -Wformat -Werror=format-security -D_FORTIFY_SOURCE=2 -DPERL_EXTMALLOC_DEF -Dmalloc=Perl_malloc -Dfree=Perl_mfree -Drealloc=Perl_realloc -Dcalloc=Perl_calloc -DVERSION=\"2.19.3\" -DXS_VERSION=\"2.19.3\" -fPIC "-I/usr/lib/perl/5.18/CORE" types.c Running Mkbootstrap for DBD::Pg () chmod 644 Pg.bs rm -f blib/arch/auto/DBD/Pg/Pg.so cc -g -O2 -fstack-protector --param=ssp-buffer-size=4 -Wformat -Werror=format-security -Wl,-z,relro -shared -L/usr/local/lib -fstack-protector Pg.o dbdimp.o quote.o types.o -o blib/arch/auto/DBD/Pg/Pg.so \ -L/usr/lib -lpq -lm \ chmod 755 blib/arch/auto/DBD/Pg/Pg.so cp Pg.bs blib/arch/auto/DBD/Pg/Pg.bs chmod 644 blib/arch/auto/DBD/Pg/Pg.bs Manifying blib/man3/DBD::Pg.3pm Manifying blib/man3/Bundle::DBD::Pg.3pm make[1]: Leaving directory `/tmp/buildd/libdbd-pg-perl-2.19.3' dh_auto_test make[1]: Entering directory `/tmp/buildd/libdbd-pg-perl-2.19.3' PGINITDB="/usr/lib/postgresql/9.3/bin/initdb" PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t t/00_signature.t .... skipped: Set the environment variable TEST_SIGNATURE to enable this test t/00basic.t ......... ok Please wait, creating new database for testing Use of uninitialized value $info in pattern match (m//) at t/dbdpg_test_setup.pl line 418. Use of uninitialized value $info in pattern match (m//) at t/dbdpg_test_setup.pl line 418. # # DBI Version 1.628 # DBD::Pg Version 2.19.3 # Perl Version 5.18.1 # OS linux # PostgreSQL (compiled) 90300 # PostgreSQL (target) 90300 # PostgreSQL (reported) PostgreSQL 9.3.0 on x86_64-unknown-linux-gnu, compiled by gcc-4.8.real (Debian 4.8.1-10) 4.8.1, 64-bit # Default port 5432 # DBI_DSN dbi:Pg:db="postgres";port=5440;host=/tmp/dbdpg_testdatabase_Jdsmdr/data/socket # DBI_USER pbuilder # Test schema dbd_pg_testschema # LANG C # array_nulls on # backslash_quote safe_encoding # client_encoding UTF8 # server_encoding UTF8 # standard_conforming_strings on # Adjusted: initdb t/01connect.t ....... ok t/01constants.t ..... ok # Failed test 'DB handle attribute "PrintWarn" shows warnings when on' # at t/02attribs.t line 263. # '' # doesn't match '(?^:dbd_pg_test_temp)' # Looks like you failed 1 test of 249. t/02attribs.t ....... Dubious, test returned 1 (wstat 256, 0x100) Failed 1/249 subtests t/03dbmethod.t ...... ok t/03smethod.t ....... ok # Checking pg_st_split_statement. This may take a while... t/04misc.t .......... ok t/06bytea.t ......... ok t/07copy.t .......... ok t/08async.t ......... ok t/09arrays.t ........ ok t/12placeholders.t .. ok t/20savepoints.t .... ok Removing test database directory t/99cleanup.t ....... ok Test Summary Report ------------------- t/02attribs.t (Wstat: 256 Tests: 249 Failed: 1) Failed test: 23 Non-zero exit status: 1 Files=15, Tests=1691, 25 wallclock secs ( 0.21 usr 0.03 sys + 3.68 cusr 0.84 csys = 4.76 CPU) Result: FAIL Failed 1/15 test programs. 1/1691 subtests failed. make[1]: *** [test_dynamic] Error 255 make[1]: Leaving directory `/tmp/buildd/libdbd-pg-perl-2.19.3' dh_auto_test: make -j1 test returned exit code 2 make: *** [build] Error 2 dpkg-buildpackage: error: debian/rules build gave error exit status 2 Thanks in advance, gregor herrmann, Debian Perl Group
  Sat Sep 21 22:39:54 2013 greg [...] turnstep.com - Status changed from 'new' to 'open'
  Sun Sep 22 14:59:48 2013 greg [...] turnstep.com - Correspondence added
I cannot seem to duplicate this, even with same version of Perl, DBI, and Postgres. Anyone have ideas on what might be triggering this?
  Wed Sep 25 10:41:58 2013 cb [...] df7cb.de - Correspondence added
From: cb [...] df7cb.de
Am So 22. Sep 2013, 14:59:48, TURNSTEP schrieb: Show quoted text
> I cannot seem to duplicate this, even with same version of Perl, DBI, > and Postgres. Anyone have ideas on what might be triggering this?
I can reproduce it with 2.19.3 (7d1c8019cec23ef3fd4cf1273cee3252a2312356), but not with HEAD (fddb9a9c945297e793a5d7ceeaf87ec868b145e9). The fixing commit is: commit accf9a11bab7de2d11a36bdaa01e2e438dd33104 Author: Erik Rijkers <er@xs4all.nl> Date: Fri May 17 22:09:41 2013 -0400 Use DEBUG1 for the PrintWarn test, as Postgres got less chatty in 9.3 diff --git a/Changes b/Changes index 76632dd..20395a7 100644 --- a/Changes +++ b/Changes @@ -16,6 +16,9 @@ Version ??? - Better wording for the AutoCommit docs (CPAN bug #82536) + - Change NOTICE to DEBUG1 in t/02attribs.t test for handle attribute "PrintWarn": + implicit index creation is now quieter in Postgres [Erik Rijkers] + Version 2.19.3 Released August 21, 2012 (git commit be018f10fdaf4163f98affcb7244046e8f47420d) - Fix bug in pg_st_split_statement causing segfaults diff --git a/t/02attribs.t b/t/02attribs.t index e98add9..197d962 100644 --- a/t/02attribs.t +++ b/t/02attribs.t @@ -251,7 +251,7 @@ is ($value, 1, $t); local $SIG{__WARN__} = sub { $warning = shift; }; -$dbh->do(q{SET client_min_messages = 'NOTICE'}); +$dbh->do(q{SET client_min_messages = 'DEBUG1'}); $t='DB handle attribute "PrintWarn" works when on'; $warning = q{}; eval { So it seems just doing a release would fix the bug.
  Mon Sep 30 17:09:27 2013 dwheeler [...] cpan.org - Status changed from 'open' to 'patched'
  Mon Sep 30 17:10:16 2013 dwheeler [...] cpan.org - Ticket #88772: Merged into ticket #88865
  Mon Sep 30 17:10:16 2013 dwheeler [...] cpan.org - Merged into ticket #88865
  Wed Feb 05 21:50:20 2014 greg [...] turnstep.com - Status changed from 'patched' to 'resolved'
  Wed Feb 05 21:50:21 2014 greg [...] turnstep.com - Taken
  Wed Feb 05 21:50:22 2014 greg [...] turnstep.com - Severity Normal added
  Wed Feb 05 21:50:22 2014 greg [...] turnstep.com - Fixed in 3.0.0 added