Skip Menu |

This queue is for tickets about the DBIx-Class CPAN distribution.

Report information
The Basics
Id: 123494
Status: new
Priority: 0/
Queue: DBIx-Class

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

Bug Information
Severity: Normal
Broken in: 0.082899_15
Fixed in: (no value)



Subject: t/72pg.t - found warning: WARNING: SET CONSTRAINTS can only be used in transaction blocks
I encountered two test failures in t/72pg.t using DBIC 0.082899_15. not ok 300 - No warnings on deferred rollback # Failed test 'No warnings on deferred rollback' # at t/72pg.t line 512. # found warning: WARNING: SET CONSTRAINTS can only be used in transaction blocks # didn't expect to find a warning not ok 592 - No warnings on deferred rollback # Failed test 'No warnings on deferred rollback' # at t/72pg.t line 512. # found warning: WARNING: SET CONSTRAINTS can only be used in transaction blocks # didn't expect to find a warning I'm using DBI 1.637 and DBD::Pg 3.5.1. Since I'm apparently using a really version of DBD::Pg I'll try upgrading to the latest and rerun the tests.
On Thu Nov 02 18:48:36 2017, MMUSGROVE wrote: Show quoted text
> I encountered two test failures in t/72pg.t using DBIC 0.082899_15. > > not ok 300 - No warnings on deferred rollback > # Failed test 'No warnings on deferred rollback' > # at t/72pg.t line 512. > # found warning: WARNING: SET CONSTRAINTS can only be used in > transaction blocks > # didn't expect to find a warning > > not ok 592 - No warnings on deferred rollback > # Failed test 'No warnings on deferred rollback' > # at t/72pg.t line 512. > # found warning: WARNING: SET CONSTRAINTS can only be used in > transaction blocks > # didn't expect to find a warning > > I'm using DBI 1.637 and DBD::Pg 3.5.1. > > Since I'm apparently using a really version of DBD::Pg I'll try > upgrading to the latest and rerun the tests.
I upgraded DBD::Pg to 3.7.0 and I still get the test failures. $ perl -V Summary of my perl5 (revision 5 version 16 subversion 3) configuration: Platform: osname=linux, osvers=2.6.32-358.2.1.el6.x86_64, archname=x86_64-linux uname='linux ln6dev-mbx-w-1.mindbrix.com 2.6.32-358.2.1.el6.x86_64 #1 smp wed feb 20 12:17:37 est 2013 x86_64 x86_64 x86_64 gnulinux ' config_args='-Dprefix=/local/bin/unified-app-0.1/perl -Dcc=gcc -des -Dotherlibdirs=/local/bin/unified-app-0.1/perl/lib/perl5:/local/bin/unified-app-0.1/lib -Dloclibpth=/local/bin/unified-app-0.1/lib -Dlocincpth=/local/bin/unified-app-0.1/include -Accflags=-fPIC' hint=recommended, useposix=true, d_sigaction=define useithreads=undef, usemultiplicity=undef useperlio=define, d_sfio=undef, uselargefiles=define, usesocks=undef use64bitint=define, use64bitall=define, uselongdouble=undef usemymalloc=n, bincompat5005=undef Compiler: cc='gcc', ccflags ='-fPIC -fno-strict-aliasing -pipe -fstack-protector -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64', optimize='-O2', cppflags='-fPIC -fno-strict-aliasing -pipe -fstack-protector' ccversion='', gccversion='4.4.7 20120313 (Red Hat 4.4.7-4)', gccosandvers='' intsize=4, longsize=8, ptrsize=8, doublesize=8, byteorder=12345678 d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16 ivtype='long', ivsize=8, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8 alignbytes=8, prototype=define Linker and Libraries: ld='gcc', ldflags =' -fstack-protector' libpth=/lib/../lib64 /usr/lib/../lib64 /lib /usr/lib /usr/local/lib /lib64 /usr/lib64 /usr/local/lib64 libs=-lnsl -lgdbm -ldb -ldl -lm -lcrypt -lutil -lc perllibs=-lnsl -ldl -lm -lcrypt -lutil -lc libc=/lib/libc-2.12.so, so=so, useshrplib=false, libperl=libperl.a gnulibc_version='2.12' Dynamic Linking: dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E' cccdlflags='-fPIC', lddlflags='-shared -O2 -fstack-protector' Characteristics of this binary (from libperl): Compile-time options: HAS_TIMES PERLIO_LAYERS PERL_DONT_CREATE_GVSV PERL_MALLOC_WRAP PERL_PRESERVE_IVUV USE_64_BIT_ALL USE_64_BIT_INT USE_LARGE_FILES USE_LOCALE USE_LOCALE_COLLATE USE_LOCALE_CTYPE USE_LOCALE_NUMERIC USE_PERLIO USE_PERL_ATOF Built under linux Compiled at Dec 12 2013 12:29:53 @INC: /local/bin/unified-app-0.1/perl/lib/site_perl/5.16.3/x86_64-linux /local/bin/unified-app-0.1/perl/lib/site_perl/5.16.3 /local/bin/unified-app-0.1/perl/lib/5.16.3/x86_64-linux /local/bin/unified-app-0.1/perl/lib/5.16.3 /local/bin/unified-app-0.1/perl/lib/perl5/x86_64-linux /local/bin/unified-app-0.1/perl/lib/perl5 /local/bin/unified-app-0.1/lib .
I wonder how many people set the environment variables before running `make test` because the line in question (512) was last changed 2015-11-03.
On Thu Nov 02 18:48:36 2017, MMUSGROVE wrote: Show quoted text
> I encountered two test failures in t/72pg.t using DBIC 0.082899_15. > > not ok 300 - No warnings on deferred rollback > # Failed test 'No warnings on deferred rollback' > # at t/72pg.t line 512. > # found warning: WARNING: SET CONSTRAINTS can only be used in > transaction blocks > # didn't expect to find a warning > > not ok 592 - No warnings on deferred rollback > # Failed test 'No warnings on deferred rollback' > # at t/72pg.t line 512. > # found warning: WARNING: SET CONSTRAINTS can only be used in > transaction blocks > # didn't expect to find a warning > > I'm using DBI 1.637 and DBD::Pg 3.5.1. > > Since I'm apparently using a really version of DBD::Pg I'll try > upgrading to the latest and rerun the tests.
The warnings should be expected since that has been the PostgreSQL behavior for quite some time now. I'll submit a patch shortly.
Opened https://github.com/dbsrgits/dbix-class/pull/119 against the devrel branch.