WG: DBD::Informix Make test Problem

WG: DBD::Informix Make test Problem

am 14.02.2007 19:06:05 von Govinda.Pfister

for your pleasure...

-----Ursprüngliche Nachricht-----
Von: Pfister, Govinda=20
Gesendet: Mittwoch, 14. Februar 2007 19:05
An: 'Jonathan Leffler'
Betreff: AW: DBD::Informix Make test Problem

Hello Jonathan,

Here comes the output of esql -V


IBM Informix CSDK Version 2.90, IBM Informix-ESQL Version 2.90.UC4 =
Software Serial Number AAA#B000000

And I do only have the following sh-scripts in my DBD::Informix Install:

root@ds68001a:/.cpan/build/DBD-Informix-2005.02 # ls *.sh
test.all.sh test.c4gl.sh test.one.sh test.quiet.sh test.run.sh

Thanks for your help.

Govinda
=20

-----Ursprüngliche Nachricht-----
Von: Jonathan Leffler [mailto:jonathan.leffler@gmail.com]
Gesendet: Mittwoch, 14. Februar 2007 18:25
An: Pfister, Govinda
Cc: dbi-users@perl.org; Janssen, Johann
Betreff: Re: DBD::Informix Make test Problem

On 2/14/07, Govinda.Pfister@telekom.de =
wrote:

> I do have a problem with "make test" run for the DBD::Informix module.
> The error is shown below. What is the problem? Is it safe to proceed=20
> to "make install"?
>

Not comfortable - I wouldn't recommend the install.

uname -a
> ------------------------------
> SunOS ds68001a 5.10 Generic_118833-18 sun4u sparc SUNW,Sun-Fire-V490
>
>
> env | sort
> ---------------------------
> CMASK=3D022
> DBD_INFORMIX_DATABASE=3Darsystem_63@arsds680
> DBD_INFORMIX_NO_SBSPACE=3D1
> DBD_INFORMIX_PASSWORD=3DXXXXXXX
> DBD_INFORMIX_USERNAME=3DXXXXXXX
> [...]
> _=3D/bin/env
>
>
>
> dbaccess -V
> ----------------------------
> DB-Access Version 9.40.FC6
> Software Serial Number AAA#B000000


64-bit database server...

esql -v
> ------------


Next time, please use '-V' (capital letter, not lower case).

[Actually, please include the output of 'esql -V' if you respond.]


Reading specs from /usr/local/lib/gcc/sparc-sun-solaris2.10/3.4.6/specs
> Configured with: ../configure --with-as=3D/usr/ccs/bin/as=20
> --with-ld=3D/usr/ccs/bin/ld --enable-shared =
--enable-languages=3Dc,c++,f77=20
> Thread model: posix gcc version 3.4.6 [...]
> root@ds68001a:/.cpan/build/DBD-Informix-2005.02 # esql -v Reading=20
> specs from /usr/local/lib/gcc/sparc-sun-solaris2.10/3.4.6/specs
> [...]
>
> perl -V
> --------------
> Summary of my perl5 (revision 5 version 8 subversion 7) configuration:
> Platform:
> osname=3Dsolaris, osvers=3D2.10, archname=3Dsun4-solaris
> uname=3D'sunos ds68001a 5.10 generic_118833-18 sun4u sparc=20
> sunw,sun-fire-v490 '
> config_args=3D'-ds -e -Dprefix=3D/usr/local'
> hint=3Drecommended, useposix=3Dtrue, d_sigaction=3Ddefine
> usethreads=3Dundef use5005threads=3Dundef useithreads=3Dundef=20
> usemultiplicity=3Dundef
> useperlio=3Ddefine d_sfio=3Dundef uselargefiles=3Ddefine =
usesocks=3Dundef
> use64bitint=3Dundef use64bitall=3Dundef uselongdouble=3Dundef
> usemymalloc=3Dn, bincompat5005=3Dundef
> Compiler:
> cc=3D'gcc', ccflags =3D'-fno-strict-aliasing -pipe=20
> -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=3D64',
> optimize=3D'-O',
> cppflags=3D'-fno-strict-aliasing -pipe -I/usr/local/include'
> ccversion=3D'', gccversion=3D'3.4.6', gccosandvers=3D'solaris2.10'
> intsize=3D4, longsize=3D4, ptrsize=3D4, doublesize=3D8, =
byteorder=3D4321
> d_longlong=3Ddefine, longlongsize=3D8, d_longdbl=3Ddefine, =
longdblsize=3D16
> ivtype=3D'long', ivsize=3D4, nvtype=3D'double', nvsize=3D8, =
Off_t=3D'off_t',



32-bit Perl...

You must be using a CSDK 2.xx.UCx version, I think?


lseeksize=3D8
> alignbytes=3D8, prototype=3Ddefine
> Linker and Libraries:
> ld=3D'gcc', ldflags =3D' -L/usr/local/lib '
> libpth=3D/usr/local/lib /usr/lib /usr/ccs/lib
> libs=3D-lsocket -lnsl -lgdbm -ldl -lm -lc
> perllibs=3D-lsocket -lnsl -ldl -lm -lc
> libc=3D/lib/libc.so, so=3Dso, useshrplib=3Dfalse, =
libperl=3Dlibperl.a
> gnulibc_version=3D''
> Dynamic Linking:
> dlsrc=3Ddl_dlopen.xs, dlext=3Dso, d_dlsymun=3Dundef, ccdlflags=3D' =
'
> cccdlflags=3D'-fPIC', lddlflags=3D'-G -L/usr/local/lib'
>
>
> Characteristics of this binary (from libperl):
> Compile-time options: USE_LARGE_FILES
> Built under solaris
> Compiled at Jan 26 2007 14:13:46
> @INC:
> /usr/local/lib/perl5/5.8.7/sun4-solaris
> /usr/local/lib/perl5/5.8.7
> /usr/local/lib/perl5/site_perl/5.8.7/sun4-solaris
> /usr/local/lib/perl5/site_perl/5.8.7
> /usr/local/lib/perl5/site_perl
>
>
> make test
> ---------------
>
> PERL_DL_NONLAZY=3D1 /bin/perl5.8.7 "-MExtUtils::Command::MM" "-e"
> "test_harness(0, 'blib/lib', 'blib/arch')" t/t00basic.t t/t01stproc.t=20
> t/t02ixtype.t t/t05dbase.t t/t07dblist.t t/t08fork.t t/t09exec.t=20
> t/t10sqlca.t t/t12bindval.t t/t13bindref.t t/t14bindcol.t=20
> t/t15bindtyp.t t/t20error.t t/t21mconn.t t/t22mconn.t t/t23mconn.t=20
> t/t24mcurs.t t/t25dratt.t t/t28dtlit.t t/t29update.t t/t30update.t=20
> t/t31nulls.t t/t32nulls.t t/t33holdcurs.t t/t35cursor.t t/t40rows.t=20
> t/t41txacoff.t t/t42txacon.t t/t43trans.t t/t44txansi.t t/t46chpblk.t=20
> t/t50update.t t/t51getinfo.t t/t53types.t t/t54native.t t/t55mdata.t=20
> t/t56tabinfo.t t/t57tables.t t/t58typeinfoall.t t/t60unlog.t=20
> t/t65updcur.t t/t66insert.t t/t72blob.t t/t73blobupd.t t/t74blob.t=20
> t/t75blob.t t/t76blob.t t/t90ius.t t/t91udts.t t/t92rows.t=20
> t/t93lvarchar.t t/t94bool.t t/t95int8.t t/t98pod.t t/t99clean.t=20
> t/t00basic..........ok t/t01stproc.........ok t/t02ixtype.........ok=20
> t/t05dbase..........ok t/t07dblist.........ok t/t08fork...........ok=20
> t/t09exec...........ok t/t10sqlca..........ok t/t12bindval........ok=20
> t/t13bindref........skipped
> all skipped: bind_param_inout not supported by DBD::Informix=20
> t/t14bindcol........ok t/t15bindtyp........ok t/t20error..........ok=20
> t/t21mconn..........ok t/t22mconn..........ok t/t23mconn..........ok=20
> t/t24mcurs..........ok t/t25dratt..........ok t/t28dtlit..........ok=20
> t/t29update.........ok t/t30update.........ok t/t31nulls..........ok=20
> t/t32nulls..........ok t/t33holdcurs.......ok t/t35cursor.........ok=20
> t/t40rows...........ok t/t41txacoff........dubious
> Test returned status 1 (wstat 256, 0x100) DIED. FAILED tests=20
> 10, 14-15, 18
> Failed 4/19 tests, 78.95% okay t/t42txacon.........ok



txacoff - Transactions with autocommit off.
txacon - Transactions with autocommit on.

I don't recall failures in txacoff - I would expect it pass. Please =
send the verbose output of the test.


t/t43trans..........dubious
> Test returned status 1 (wstat 256, 0x100) DIED. FAILED tests=20
> 6, 11, 15-16, 19
> Failed 5/20 tests, 75.00% okay



Another set of transaction tests - please send the verbose output of the =
test.

t/t44txansi.........skipped
> all skipped: MODE ANSI test - database 'arsystem_63@arsds680'=20
> is not MODE ANSI t/t46chpblk.........ok t/t50update.........skipped
> all skipped: MODE ANSI test - database 'arsystem_63@arsds680'=20
> is not MODE ANSI t/t51getinfo........ok t/t53types..........ok=20
> t/t54native.........ok t/t55mdata..........ok t/t56tabinfo........ok=20
> t/t57tables.........ok t/t58typeinfoall....ok t/t60unlog..........ok=20
> t/t65updcur.........dubious
> Test returned status 1 (wstat 256, 0x100) DIED. FAILED tests=20
> 7, 15
> Failed 2/16 tests, 87.50% okay



updcur - Update with the WHERE CURRENT OF clause - again, please send =
verbose test output.

t/t66insert.........ok
> t/t72blob...........ok
> t/t73blobupd........ok
> t/t74blob...........ok
> t/t75blob...........ok
> t/t76blob...........ok
> t/t90ius............ok
> t/t91udts...........ok
> t/t92rows...........ok
> t/t93lvarchar.......ok
> t/t94bool...........ok
> t/t95int8...........ok
> t/t98pod............ok
> t/t99clean..........ok
> Failed Test Stat Wstat Total Fail List of Failed
> ------------------------------------------------------------ ----------
> --
> -------
> t/t41txacoff.t 1 256 19 4 10 14-15 18
> t/t43trans.t 1 256 20 5 6 11 15-16 19
> t/t65updcur.t 1 256 16 2 7 15
> 3 tests skipped.
> Failed 3/55 test scripts. 11/834 subtests failed.
> Files=3D55, Tests=3D834, 17 wallclock secs ( 9.53 cusr + 0.71 csys =
=3D
> 10.24
> CPU)
> Failed 3/55 test programs. 11/834 subtests failed.
> *** Error code 29
> make: Fatal error: Command failed for target `test_dynamic'
>

To get verbose test output of the three tests:

sh test.verbose.sh t/t4[13]* t/t65*

--
Jonathan Leffler #include =
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org "I don't =
suffer from insanity - I enjoy every minute of it."