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

Report information
The Basics
Id:
123494
Status:
new
Priority:
Low/Low
Queue:

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

BugTracker
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.


This service runs on Request Tracker, is sponsored by The Perl Foundation, and maintained by Best Practical Solutions.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.