RE: :Informix 2005.01-> t91udts.t fails
- From: darryl.priest@xxxxxxxxxxxx (Darryl Priest)
- Date: Mon, 25 Apr 2005 15:32:46 -0400
It appears that you either need a smart blob space named sbspace, or set
either DBD_INFORMIX_SBSPACE or DBD_INFORMIX_NO_SBSPACE.
>From the README:
Note that the tests that create tables with BLOB or CLOB columns will
place them in the smart blob space designated by DBD_INFORMIX_SBSPACE,
and will use the default value 'sbspace' if you do not specify an
alternative. If you do not have any smart blob spaces, the tests will
fail unless you set DBD_INFORMIX_NO_SBSPACE.
HTH,
-Darryl
> -----Original Message-----
> From: ODELL, TODD E (SWBT) [mailto:to2958@xxxxxxx]
> Sent: Monday, April 25, 2005 12:31 PM
> To: dbi-users@xxxxxxxx
> Subject: DBD::Informix 2005.01-> t91udts.t fails
>
> Hello.
> I ran the BugReport for D t91udts.t. Everything seems ok
> except for that
> one test for udts. From the error I wonder if it has anything
> to do with
> the DBD::Informix or simply with this version of Informix (
> 9.21.UC4 ).
> ? In the past I was able to install DBD::Informix 1.00 with some
> complaining about the udts test but it was able to recognize
> the sbspace
> correctly.
>
> BugReport:
> Command: BugReport D t/t91udts.t
> Date: Mon Apr 25 11:13:56 CDT 2005
> Machine: sbctss2 (AIX 3)
> User: uid=0(root) gid=0(system)
> groups=10(audit),8(cron),7(security),3(sys),2(bin),0(system)
> Directory: /usr/opt/perl5.8.6/.cpan/build/DBD-Informix-2005.01
> Umask: 026
> Terminal: /dev/pts/5
>
> #
> # Perl Version
> Summary of my perl5 (revision 5 version 8 subversion 6) configuration:
> Platform:
> osname=aix, osvers=4.3.3.0, archname=aix-thread-multi
> uname='aix sbctss2 3 4 000186704c00 '
> config_args=''
> hint=previous, useposix=true, d_sigaction=define
> usethreads=define use5005threads=undef useithreads=define
> usemultiplicity=define
> useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
> use64bitint=undef use64bitall=undef uselongdouble=undef
> usemymalloc=n, bincompat5005=undef
> Compiler:
> cc='cc', ccflags ='-D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE
> -qmaxmem=-1 -qnoansialias -DUSE_NATIVE_DLOPEN
> -I/usr/local/include -q32
> -D_LARGE_FILES -qlonglong',
> optimize='-O',
> cppflags='-D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE
> -qmaxmem=-1
> -qnoansialias -DUSE_NATIVE_DLOPEN -I/usr/local/include -D_ALL_SOURCE
> -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=-1 -qnoansialias
> -DUSE_NATIVE_DLOPEN -I/usr/local/include -q32 -D_LARGE_FILES
> -qlonglong
> -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=-1
> -qnoansialias
> -DUSE_NATIVE_DLOPEN -I/usr/local/include -q32 -D_LARGE_FILES
> -qlonglong
> -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=-1
> -qnoansialias
> -DUSE_NATIVE_DLOPEN -I/usr/local/include -q32 -D_LARGE_FILES
> -qlonglong
> -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=-1
> -qnoansialias
> -DUSE_NATIVE_DLOPEN -I/usr/local/include -q32 -D_LARGE_FILES
> -qlonglong
> -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=-1
> -qnoansialias
> -DUSE_NATIVE_DLOPEN -I/usr/local/include -q32 -D_LARGE_FILES
> -qlonglong
> -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=-1
> -qnoansialias
> -DUSE_NATIVE_DLOPEN -I/usr/local/include -q32 -D_LARGE_FILES -q!
> longlong -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=-1
> -qnoansialias -DUSE_NATIVE_DLOPEN -I/usr/local/include -q32
> -D_LARGE_FILES -qlonglong -D_ALL_SOURCE -D_ANSI_C_SOURCE
> -D_POSIX_SOURCE
> -qmaxmem=-1 -qnoansialias -DUSE_NATIVE_DLOPEN
> -I/usr/local/include -q32
> -D_LARGE_FILES -qlonglong'
> ccversion='4.4.0.3', gccversion='', gccosandvers=''
> intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321
> d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=8
> ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t',
> lseeksize=8
> alignbytes=8, prototype=define
> Linker and Libraries:
> ld='ld', ldflags =' -brtl -L/usr/local/lib -b32'
> libpth=/usr/local/lib /lib /usr/lib /usr/ccs/lib
> libs=-lbind -lnsl -ldbm -ldl -lld -lm -lcrypt -lc -lbsd -lpthread
> perllibs=-lbind -lnsl -ldl -lld -lm -lcrypt -lc -lbsd -lpthread
> libc=/lib/libc.a, so=a, useshrplib=false, libperl=libperl.a
> gnulibc_version=''
> Dynamic Linking:
> dlsrc=dl_aix.xs, dlext=so, d_dlsymun=undef, ccdlflags='
> -bE:/usr/opt/perl5.8.6/lib/5.8.6/aix/CORE/perl.exp
> -bE:/usr/opt/perl5.8.6/lib/5.8.6/aix/CORE/perl.exp
> -bE:/usr/opt/perl5.8.6/lib/5.8.6/aix/CORE/perl.exp
> -bE:/usr/opt/perl5.8.6/lib/5.8.6/aix/CORE/perl.exp
> -bE:/usr/opt/perl5.8.6/lib/5.8.6/aix/CORE/perl.exp
> -bE:/usr/opt/perl5.8.6/lib/5.8.6/aix/CORE/perl.exp
> -bE:/usr/opt/perl5.8.6/lib/5.8.6/aix/CORE/perl.exp
> -bE:/usr/opt/perl5.8.6/lib/5.8.6/aix/CORE/perl.exp
> -bE:/usr/opt/perl5.8.6/lib/5.8.6/aix/CORE/perl.exp'
> cccdlflags=' ', lddlflags=' -bhalt:4 -bexpall -G -bnoentry -lc
> -L/usr/local/lib'
>
>
> Characteristics of this binary (from libperl):
> Compile-time options: MULTIPLICITY USE_ITHREADS USE_LARGE_FILES
> PERL_IMPLICIT_CONTEXT
> Built under aix
> Compiled at Apr 22 2005 10:58:16
> @INC:
> /usr/opt/perl5.8.6/lib/5.8.6/aix
> /usr/opt/perl5.8.6/lib/5.8.6
> /usr/opt/perl5.8.6/lib/site_perl/5.8.6/aix
> /usr/opt/perl5.8.6/lib/site_perl/5.8.6
> /usr/opt/perl5.8.6/lib/site_perl
> .
>
> #
> # Informix Version
> Using INFORMIXDIR=/usr/informix and ESQL/C compiler esql
> INFORMIXDIR = /usr/informix
> ESQLC = esql
> Version = INFORMIX-ESQL Version 9.50.UC1
> DBMS Version = Informix Dynamic Server 2000 Version 9.21.UC4
> Informix Server Entries in sqlhosts file (/usr/informix/etc/sqlhosts)
> sbctss2_s1 onipcshm sbctss2 sbctss2
>
> #
> # Sorted Environment
> ANT_HOME=/jakarta-tomcat/apache-ant-1.5.4
> AUTHSTATE=files
> A__z=! LOGNAME
> CGI_DIRECTORY=/var/docsearch/cgi-bin
> CLASSPATH=:/jakarta-tomcat/jakarta-tomcat-4.1.27/common/lib/an
> t.jar:/usr
> /jakarta-regexp-1.3/jakarta-regexp-1.3.jar
> CVSROOT=/usr/local/cvsroot
> DBD_INFORMIX_DATABASE=webapp
> DBD_INFORMIX_PASSWORD=XXXXXXXX
> DBD_INFORMIX_USER=root
> DBD_INFORMIX_USERNAME=root
> DOCUMENT_DIRECTORY=/usr/docsearch/html
> DOCUMENT_SERVER_MACHINE_NAME=localhost
> DOCUMENT_SERVER_PORT=49213
> ENV=/.kshrc
> HOME=/
> IMQCONFIGCL=/etc/IMNSearch/dbcshelp
> IMQCONFIGSRV=/etc/IMNSearch
> INFORMIXDIR=/usr/informix
> INFORMIXSERVER=sbctss2_s1
> INFORMIXTMP=/INFORMIXTMP
> JAVA_HOME=/usr/java131/bin
> K5MUTE=1
> LANG=en_US
> LC__FASTMSG=true
> LOCPATH=/usr/lib/nls/loc
> LOGIN=root
> LOGNAME=root
> MAIL=/usr/spool/mail/root
> MAILMSG=[YOU HAVE NEW MAIL]
> MANPATH=/usr/lpp/ssp/man:/usr/share/man;/usr/opt/perl5/man;/us
> r/local/op
> t/samba/man
> NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
> ODMDIR=/etc/objrepos
> ONCONFIG=onconfig.sbctss2_s1
> PATH=/usr/local/bin:/usr/bin:/etc:/usr/sbin:/usr/lbin:/usr/lcl
> bin:/usr/t
> bin:/usr/ucb://bin:/usr/bin/X11:/sbin:/usr/lpp/ssp/rcmd/bin:/u
> sr/informi
> x/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:/usr
> /lpp/ssp/b
> in:/usr/lpp/ssp/kerberos/bin:/usr/lpp/ssp/kerberos/etc:/usr/lp
> p/ssp/inst
> all/bin:/var/sysman:/etc/amd:/apache3/bin:/usr/informix/bin:/u
> sr/jdk_bas
> e/bin:/opt/freeware/bin:/var/ifor:/usr/opt/ifor/ls/conf:/usr/j
> ava131/bin
> :.
> PS1=root@sbctss2:$PWD>
> PWD=/usr/opt/perl5.8.6/.cpan/build/DBD-Informix-2005.01
> SHELL=/bin/ksh
> TERM=aixterm
> TZ=CST6CDT
> USER=root
> WCOLL=/.wcoll_hosts
> _=../../../bin/perl
>
> # End of Configuration Report
>
> #
> # Redoing configuration
> + [ ! -f Makefile ] || make realclean
> + rm -f esql esqlvrsn.h esqlinfo.h
> + ../../../bin/perl Makefile.PL
> *** ExtUtils::AutoInstall version 0.61
> *** Checking for dependencies...
> [Core Features]
> - DBI ...loaded. (1.48 >= 1.38)
> [High Resolution Timing]
> - Time::HiRes ...loaded. (1.66)
> [POD Format Testing]
> - Test::Pod ...loaded. (1.20)
> *** ExtUtils::AutoInstall configuration finished.
> Subroutine main::WriteMakefile redefined at
> /usr/opt/perl5.8.6/lib/site_perl/5.8.6/ExtUtils/AutoInstall.pm
> line 487.
>
> Configuring IBM Informix Database Driver for Perl DBI Version 2005.01
> (2005-03-14) (aka DBD::Informix)
> You are using DBI version 1.48 and Perl version 5.008006
> Remember to actually read the README file!
>
> Perl: perl v5.008006 aix-thread-multi dl_aix.xs
> System: aix sbctss2 3 4 000186704c00
> Using INFORMIXDIR=/usr/informix and ESQL/C compiler esql
> Using INFORMIX-ESQL Version 9.50.UC1 from /usr/informix
>
> Please upgrade to a more recent version of ClientSDK.
> DBD::Informix will probably work, but that is not guaranteed.
>
> Beware: DBD::Informix is not yet aware of all the new IUS data types.
>
> Assert macro will be disabled!
>
> lib/DBD/Informix/Defaults.pm written OK
> esqlvrsn.h written OK
> esqlinfo.h written OK
>
> Testing whether your Informix test environment will work...
> ESQLTEST Program Running:
> @(#)$Id: esqltest.ec,v 2004.1 2004/11/16 22:29:43 jleffler Exp $
> $INFORMIXDIR is set to '/usr/informix'.
> $INFORMIXSERVER is set to 'sbctss2_s1'.
> $DBI_DBNAME unset - defaulting to 'stores'.
> $DBD_INFORMIX_DATABASE set to 'webapp'.
> $DBD_INFORMIX_DATABASE2 unset - defaulting to 'webapp'.
> $DBD_INFORMIX_USERNAME is set to 'root'.
> $DBD_INFORMIX_USERNAME2 is unset - defaulting to 'root'.
> $DBD_INFORMIX_PASSWORD is set.
> $DBD_INFORMIX_PASSWORD2 is unset - defaulting to
> $DBD_INFORMIX_PASSWORD.
> Testing connection to webapp
> CONNECT TO 'webapp' with user info
> Testing concurrent connection to webapp
> CONNECT TO 'webapp' with user info
> You're using shared memory connections for both databases.
> DBD::Informix cannot test multiple concurrent connections.
> The multi-connection tests will be skipped.
> Your Informix environment is (probably) OK
>
>
> Fortunately, you are using a new version of ESQL/C. We could
> use 'esql -libs' to tell us which libraries to use, except that
> some versions of the esql script are very Clintonian and do not
> tell us the whole truth. So we have to do a fiddly workaround,
> editing the esql script on the fly and feeding the edited
> version to the shell and ... Oh, you really don't want to know
> what we do; it's horrid but it works, usually!
> ... Replacing reference to -lnetstub with /usr/informix/lib/netstub.a
> (override with DBD_INFORMIX_AIX_USENETSTUB)
> ... We are going to use the library list:
> -lifsql -lifasf -lifgen -lifos -lifgls
> /usr/informix/lib/netstub.a -lc_r
> -ldl -ltli_r -lm_r /usr/informix/lib/esql/checkapi.o -lifglx
>
> Checking if your kit is complete...
> Looks good
> Using DBI 1.48 (for perl 5.008006 on aix-thread-multi) installed in
> /usr/opt/perl5.8.6/lib/site_perl/5.8.6/aix/auto/DBI/
> Writing Makefile for DBD::Informix
>
> #
> # Redoing build
> + make
> cp lib/DBD/Informix/Summary.pm blib/lib/DBD/Informix/Summary.pm
> cp lib/DBD/Informix/TechSupport.pm
> blib/lib/DBD/Informix/TechSupport.pm
> cp lib/DBD/Informix/GetInfo.pm blib/lib/DBD/Informix/GetInfo.pm
> cp lib/Bundle/DBD/Informix.pm blib/lib/Bundle/DBD/Informix.pm
> cp lib/DBD/Informix/Configure.pm blib/lib/DBD/Informix/Configure.pm
> cp Informix.pm blib/lib/DBD/Informix.pm
> cp lib/DBD/Informix/TestHarness.pm
> blib/lib/DBD/Informix/TestHarness.pm
> cp lib/DBD/Informix/TypeInfo.pm blib/lib/DBD/Informix/TypeInfo.pm
> cp lib/DBD/Informix/Defaults.pm blib/lib/DBD/Informix/Defaults.pm
> cp lib/DBD/Informix/Metadata.pm blib/lib/DBD/Informix/Metadata.pm
> ../../../bin/perl -e 'use ExtUtils::Mksymlists;
> Mksymlists("NAME" => "DBD::Informix", "DL_FUNCS" => { },
> "FUNCLIST" =>
> [], "DL_VARS" => []);'
> ../../../bin/perl -p -e "s/~DRIVER~/Informix/g"
> /usr/opt/perl5.8.6/lib/site_perl/5.8.6/aix/auto/DBI//Driver.xst >
> Informix.xsi
> ../../../bin/perl /usr/opt/perl5.8.6/lib/5.8.6/ExtUtils/xsubpp
> -typemap /usr/opt/perl5.8.6/lib/5.8.6/ExtUtils/typemap Informix.xs >
> Informix.xsc && mv Informix.xsc Informix.c
> cc -c -I/usr/informix/incl/esql
> -I/usr/opt/perl5.8.6/lib/5.8.6/aix/auto/DBI
> -I/usr/opt/perl5.8.6/lib/site_perl/5.8.6/aix/auto/DBI -I/auto/DBI
> -I/usr/opt/perl5.8.6/lib/site_perl/5.8.6/aix/auto/DBI -D_ALL_SOURCE
> -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=-1 -qnoansialias
> -DUSE_NATIVE_DLOPEN -I/usr/local/include -q32 -D_LARGE_FILES
> -qlonglong
> -O -DVERSION=\"2005.01\" -DXS_VERSION=\"2005.01\"
> "-I/usr/opt/perl5.8.6/lib/5.8.6/aix/CORE"
> -DESQLC_VERSION=950 -DNDEBUG
> -DUSE_REAL_MALLOC -D__H_LOCALEDEF Informix.c
> INFORMIXC="../../../bin/perl esqlcc" ESQLCC="cc" esql -c -shared
> -I/usr/informix/incl/esql -I/usr/opt/perl5.8.6/lib/5.8.6/aix/auto/DBI
> -I/usr/opt/perl5.8.6/lib/site_perl/5.8.6/aix/auto/DBI -I/auto/DBI
> -I/usr/opt/perl5.8.6/lib/site_perl/5.8.6/aix/auto/DBI -D_ALL_SOURCE
> -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=-1 -qnoansialias
> -DUSE_NATIVE_DLOPEN -I/usr/local/include -q32 -D_LARGE_FILES
> -qlonglong
> -O -DVERSION=\"2005.01\" -DXS_VERSION=\"2005.01\"
> -I/usr/opt/perl5.8.6/lib/5.8.6/aix/CORE -DESQLC_VERSION=950 -DNDEBUG
> -DUSE_REAL_MALLOC -D__H_LOCALEDEF dbdimp.ec
> rm -f dbdimp.c
> INFORMIXC="../../../bin/perl esqlcc" ESQLCC="cc" esql -c -shared
> -I/usr/informix/incl/esql -I/usr/opt/perl5.8.6/lib/5.8.6/aix/auto/DBI
> -I/usr/opt/perl5.8.6/lib/site_perl/5.8.6/aix/auto/DBI -I/auto/DBI
> -I/usr/opt/perl5.8.6/lib/site_perl/5.8.6/aix/auto/DBI -D_ALL_SOURCE
> -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=-1 -qnoansialias
> -DUSE_NATIVE_DLOPEN -I/usr/local/include -q32 -D_LARGE_FILES
> -qlonglong
> -O -DVERSION=\"2005.01\" -DXS_VERSION=\"2005.01\"
> -I/usr/opt/perl5.8.6/lib/5.8.6/aix/CORE -DESQLC_VERSION=950 -DNDEBUG
> -DUSE_REAL_MALLOC -D__H_LOCALEDEF dbdattr.ec
> rm -f dbdattr.c
> INFORMIXC="../../../bin/perl esqlcc" ESQLCC="cc" esql -c -shared
> -I/usr/informix/incl/esql -I/usr/opt/perl5.8.6/lib/5.8.6/aix/auto/DBI
> -I/usr/opt/perl5.8.6/lib/site_perl/5.8.6/aix/auto/DBI -I/auto/DBI
> -I/usr/opt/perl5.8.6/lib/site_perl/5.8.6/aix/auto/DBI -D_ALL_SOURCE
> -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=-1 -qnoansialias
> -DUSE_NATIVE_DLOPEN -I/usr/local/include -q32 -D_LARGE_FILES
> -qlonglong
> -O -DVERSION=\"2005.01\" -DXS_VERSION=\"2005.01\"
> -I/usr/opt/perl5.8.6/lib/5.8.6/aix/CORE -DESQLC_VERSION=950 -DNDEBUG
> -DUSE_REAL_MALLOC -D__H_LOCALEDEF describe.ec
> rm -f describe.c
> cc -c -I/usr/informix/incl/esql
> -I/usr/opt/perl5.8.6/lib/5.8.6/aix/auto/DBI
> -I/usr/opt/perl5.8.6/lib/site_perl/5.8.6/aix/auto/DBI -I/auto/DBI
> -I/usr/opt/perl5.8.6/lib/site_perl/5.8.6/aix/auto/DBI -D_ALL_SOURCE
> -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=-1 -qnoansialias
> -DUSE_NATIVE_DLOPEN -I/usr/local/include -q32 -D_LARGE_FILES
> -qlonglong
> -O -DVERSION=\"2005.01\" -DXS_VERSION=\"2005.01\"
> "-I/usr/opt/perl5.8.6/lib/5.8.6/aix/CORE"
> -DESQLC_VERSION=950 -DNDEBUG
> -DUSE_REAL_MALLOC -D__H_LOCALEDEF sqltoken.c
> INFORMIXC="../../../bin/perl esqlcc" ESQLCC="cc" esql -c -shared
> -I/usr/informix/incl/esql -I/usr/opt/perl5.8.6/lib/5.8.6/aix/auto/DBI
> -I/usr/opt/perl5.8.6/lib/site_perl/5.8.6/aix/auto/DBI -I/auto/DBI
> -I/usr/opt/perl5.8.6/lib/site_perl/5.8.6/aix/auto/DBI -D_ALL_SOURCE
> -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=-1 -qnoansialias
> -DUSE_NATIVE_DLOPEN -I/usr/local/include -q32 -D_LARGE_FILES
> -qlonglong
> -O -DVERSION=\"2005.01\" -DXS_VERSION=\"2005.01\"
> -I/usr/opt/perl5.8.6/lib/5.8.6/aix/CORE -DESQLC_VERSION=950 -DNDEBUG
> -DUSE_REAL_MALLOC -D__H_LOCALEDEF sqltype.ec
> rm -f sqltype.c
> INFORMIXC="../../../bin/perl esqlcc" ESQLCC="cc" esql -c -shared
> -I/usr/informix/incl/esql -I/usr/opt/perl5.8.6/lib/5.8.6/aix/auto/DBI
> -I/usr/opt/perl5.8.6/lib/site_perl/5.8.6/aix/auto/DBI -I/auto/DBI
> -I/usr/opt/perl5.8.6/lib/site_perl/5.8.6/aix/auto/DBI -D_ALL_SOURCE
> -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=-1 -qnoansialias
> -DUSE_NATIVE_DLOPEN -I/usr/local/include -q32 -D_LARGE_FILES
> -qlonglong
> -O -DVERSION=\"2005.01\" -DXS_VERSION=\"2005.01\"
> -I/usr/opt/perl5.8.6/lib/5.8.6/aix/CORE -DESQLC_VERSION=950 -DNDEBUG
> -DUSE_REAL_MALLOC -D__H_LOCALEDEF ixblob.ec
> rm -f ixblob.c
> cc -c -I/usr/informix/incl/esql
> -I/usr/opt/perl5.8.6/lib/5.8.6/aix/auto/DBI
> -I/usr/opt/perl5.8.6/lib/site_perl/5.8.6/aix/auto/DBI -I/auto/DBI
> -I/usr/opt/perl5.8.6/lib/site_perl/5.8.6/aix/auto/DBI -D_ALL_SOURCE
> -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=-1 -qnoansialias
> -DUSE_NATIVE_DLOPEN -I/usr/local/include -q32 -D_LARGE_FILES
> -qlonglong
> -O -DVERSION=\"2005.01\" -DXS_VERSION=\"2005.01\"
> "-I/usr/opt/perl5.8.6/lib/5.8.6/aix/CORE"
> -DESQLC_VERSION=950 -DNDEBUG
> -DUSE_REAL_MALLOC -D__H_LOCALEDEF odbctype.c
> cc -c -I/usr/informix/incl/esql
> -I/usr/opt/perl5.8.6/lib/5.8.6/aix/auto/DBI
> -I/usr/opt/perl5.8.6/lib/site_perl/5.8.6/aix/auto/DBI -I/auto/DBI
> -I/usr/opt/perl5.8.6/lib/site_perl/5.8.6/aix/auto/DBI -D_ALL_SOURCE
> -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=-1 -qnoansialias
> -DUSE_NATIVE_DLOPEN -I/usr/local/include -q32 -D_LARGE_FILES
> -qlonglong
> -O -DVERSION=\"2005.01\" -DXS_VERSION=\"2005.01\"
> "-I/usr/opt/perl5.8.6/lib/5.8.6/aix/CORE"
> -DESQLC_VERSION=950 -DNDEBUG
> -DUSE_REAL_MALLOC -D__H_LOCALEDEF kludge.c
> cc -c -I/usr/informix/incl/esql
> -I/usr/opt/perl5.8.6/lib/5.8.6/aix/auto/DBI
> -I/usr/opt/perl5.8.6/lib/site_perl/5.8.6/aix/auto/DBI -I/auto/DBI
> -I/usr/opt/perl5.8.6/lib/site_perl/5.8.6/aix/auto/DBI -D_ALL_SOURCE
> -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=-1 -qnoansialias
> -DUSE_NATIVE_DLOPEN -I/usr/local/include -q32 -D_LARGE_FILES
> -qlonglong
> -O -DVERSION=\"2005.01\" -DXS_VERSION=\"2005.01\"
> "-I/usr/opt/perl5.8.6/lib/5.8.6/aix/CORE"
> -DESQLC_VERSION=950 -DNDEBUG
> -DUSE_REAL_MALLOC -D__H_LOCALEDEF link.c
> INFORMIXC="../../../bin/perl esqlcc" ESQLCC="cc" esql -c -shared
> -I/usr/informix/incl/esql -I/usr/opt/perl5.8.6/lib/5.8.6/aix/auto/DBI
> -I/usr/opt/perl5.8.6/lib/site_perl/5.8.6/aix/auto/DBI -I/auto/DBI
> -I/usr/opt/perl5.8.6/lib/site_perl/5.8.6/aix/auto/DBI -D_ALL_SOURCE
> -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=-1 -qnoansialias
> -DUSE_NATIVE_DLOPEN -I/usr/local/include -q32 -D_LARGE_FILES
> -qlonglong
> -O -DVERSION=\"2005.01\" -DXS_VERSION=\"2005.01\"
> -I/usr/opt/perl5.8.6/lib/5.8.6/aix/CORE -DESQLC_VERSION=950 -DNDEBUG
> -DUSE_REAL_MALLOC -D__H_LOCALEDEF esqlcver.ec
> rm -f esqlcver.c
> INFORMIXC="../../../bin/perl esqlcc" ESQLCC="cc" esql -c -shared
> -I/usr/informix/incl/esql -I/usr/opt/perl5.8.6/lib/5.8.6/aix/auto/DBI
> -I/usr/opt/perl5.8.6/lib/site_perl/5.8.6/aix/auto/DBI -I/auto/DBI
> -I/usr/opt/perl5.8.6/lib/site_perl/5.8.6/aix/auto/DBI -D_ALL_SOURCE
> -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=-1 -qnoansialias
> -DUSE_NATIVE_DLOPEN -I/usr/local/include -q32 -D_LARGE_FILES
> -qlonglong
> -O -DVERSION=\"2005.01\" -DXS_VERSION=\"2005.01\"
> -I/usr/opt/perl5.8.6/lib/5.8.6/aix/CORE -DESQLC_VERSION=950 -DNDEBUG
> -DUSE_REAL_MALLOC -D__H_LOCALEDEF esqlc_v6.ec
> rm -f esqlc_v6.c
> Running Mkbootstrap for DBD::Informix ()
> chmod 644 Informix.bs
> rm -f blib/arch/auto/DBD/Informix/Informix.so
> LD_RUN_PATH="" ld -bhalt:4 -bexpall -G -bnoentry -lc
> -L/usr/local/lib Informix.o dbdimp.o dbdattr.o describe.o sqltoken.o
> sqltype.o ixblob.o odbctype.o kludge.o link.o esqlcver.o esqlc_v6.o
> -L/usr/informix/lib -L/usr/informix/lib/esql -lifsql -lifasf -lifgen
> -lifos -lifgls /usr/informix/lib/netstub.a -lc_r -ldl -ltli_r -lm_r
> /usr/informix/lib/esql/checkapi.o -lifglx -o
> blib/arch/auto/DBD/Informix/Informix.so
> chmod 755 blib/arch/auto/DBD/Informix/Informix.so
> cp Informix.bs blib/arch/auto/DBD/Informix/Informix.bs
> chmod 644 blib/arch/auto/DBD/Informix/Informix.bs
> cp InformixTechSupport blib/script/InformixTechSupport
> ../../../bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)"
> blib/script/InformixTechSupport
> Manifying blib/man1/InformixTechSupport.1
> Manifying blib/man3/DBD::Informix::TechSupport.3
> Manifying blib/man3/DBD::Informix::Summary.3
> Manifying blib/man3/DBD::Informix::Configure.3
> Manifying blib/man3/DBD::Informix::TypeInfo.3
> Manifying blib/man3/DBD::Informix::TestHarness.3
> Manifying blib/man3/DBD::Informix::GetInfo.3
> Manifying blib/man3/Bundle::DBD::Informix.3
> Manifying blib/man3/DBD::Informix.3
> Manifying blib/man3/DBD::Informix::Defaults.3
> Manifying blib/man3/DBD::Informix::Metadata.3
>
> #
> # Redoing general testing
> + make test
> PERL_DL_NONLAZY=1 ../../../bin/perl "-MExtUtils::Command::MM"
> "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/t00basic.t
> t/t01stproc.t t/t02ixtype.t t/t05dbase.t t/t07dblist.t t/t08fork.t
> t/t09exec.t t/t10sqlca.t t/t12bindval.t t/t13bindref.t t/t14bindcol.t
> t/t15bindtyp.t t/t20error.t t/t21mconn.t t/t22mconn.t t/t23mconn.t
> t/t24mcurs.t t/t25dratt.t t/t28dtlit.t t/t29update.t t/t30update.t
> t/t31nulls.t t/t32nulls.t t/t33holdcurs.t t/t35cursor.t t/t40rows.t
> t/t41txacoff.t t/t42txacon.t t/t43trans.t t/t44txansi.t t/t46chpblk.t
> t/t50update.t t/t51getinfo.t t/t53types.t t/t54native.t t/t55mdata.t
> t/t56tabinfo.t t/t57tables.t t/t58typeinfoall.t t/t60unlog.t
> t/t65updcur.t t/t66insert.t t/t72blob.t t/t73blobupd.t t/t74blob.t
> t/t75blob.t t/t76blob.t t/t90ius.t t/t91udts.t t/t92rows.t
> t/t93lvarchar.t t/t94bool.t t/t95int8.t t/t99clean.t
> t/t00basic..........ok
> t/t01stproc.........ok
> t/t02ixtype.........ok
> t/t05dbase..........ok
> t/t07dblist.........ok
> t/t08fork...........ok
> t/t09exec...........ok
> t/t10sqlca..........ok
> t/t12bindval........ok
> t/t13bindref........skipped
> all skipped: bind_param_inout not supported by DBD::Informix
> t/t14bindcol........ok
> t/t15bindtyp........ok
> t/t20error..........ok
> t/t21mconn..........skipped
> all skipped: Two shared memory connections - multi-connection
> test skipped
> t/t22mconn..........skipped
> all skipped: Two shared memory connections - multi-connection
> test skipped
> t/t23mconn..........skipped
> all skipped: Two shared memory connections - multi-connection
> test skipped
> t/t24mcurs..........ok
> t/t25dratt..........ok
> t/t28dtlit..........ok
> t/t29update.........ok
> t/t30update.........ok
> t/t31nulls..........ok
> t/t32nulls..........ok
> t/t33holdcurs.......ok
> t/t35cursor.........ok
> t/t40rows...........ok
> t/t41txacoff........ok
> t/t42txacon.........ok
> t/t43trans..........ok
> t/t44txansi.........skipped
> all skipped: MODE ANSI test - database 'webapp' is
> not MODE ANSI
> t/t46chpblk.........ok
> t/t50update.........ok
> t/t51getinfo........ok
> t/t53types..........ok
> t/t54native.........ok
> t/t55mdata..........ok
> t/t56tabinfo........ok
> t/t57tables.........ok
> t/t58typeinfoall....ok
> t/t60unlog..........ok
> t/t65updcur.........ok
> t/t66insert.........ok
> t/t72blob...........ok
> t/t73blobupd........ok
> t/t74blob...........ok
> t/t75blob...........ok
> t/t76blob...........ok
> t/t90ius............ok
> t/t91udts...........DBD::Informix::db do failed: SQL: -9821: Space
> (sbspace) is not an sbspace. at
> /usr/opt/perl5.8.6/.cpan/build/DBD-Informix-2005.01/blib/lib/D
> BD/Informi
> x/TestHarness.pm line 347.
> DBD::Informix::db do failed: SQL: -206: The specified table
> (dbd_ix_udts) is not in the database.
> ISAM: -111: ISAM error: no record found. at
> /usr/opt/perl5.8.6/.cpan/build/DBD-Informix-2005.01/blib/lib/D
> BD/Informi
> x/TestHarness.pm line 347.
> DBD::Informix::db prepare failed: SQL: -206: The specified table
> (dbd_ix_udts) is not in the database.
> ISAM: -111: ISAM error: no record found. at t/t91udts.t line 88.
> Can't call method "execute" on an undefined value at t/t91udts.t line
> 99.
> dubious
> Test returned status 255 (wstat 65280, 0xff00)
> DIED. FAILED tests 6-7, 9-16
> Failed 10/16 tests, 37.50% okay
> t/t92rows...........ok
> t/t93lvarchar.......ok
> t/t94bool...........ok
> t/t95int8...........ok
> t/t99clean..........ok
> Failed 1/54 test scripts, 98.15% okay. 10/787 subtests failed, 98.73%
> okay.
> Failed Test Stat Wstat Total Fail Failed List of Failed
> --------------------------------------------------------------
> ----------
> -------
> t/t91udts.t 255 65280 16 18 112.50% 6-7 9-16
> 5 tests skipped.
> make: 1254-004 The error code from the last command is 25.
>
>
> Stop.
> failed on general testing at
> /usr/opt/perl5.8.6/lib/site_perl/5.8.6/aix/DBD/Informix/TechSupport.pm
> line 225.
>
> #
> # Doing selective testing
> + sh test.one.sh t/t91udts.t
> # Driver Information
> # Name: Informix
> # Version: 2005.01
> # Product: INFORMIX-ESQL Version 9.50.UC1
> # Product Version: 950
> # Connect to: webapp
> # IUS data types can be tested!
> 1..16
> # drop table dbd_ix_udts
> # Error Message:
> # SQL: -206: The specified table (dbd_ix_udts) is not in the database.
> # ISAM: -111: ISAM error: no record found.
> # SQLSTATE = 42000
> # drop type dbd_ix_distofi8 restrict
> # Error Message:
> # SQL: -9628: Type (dbd_ix_distofi8) not found.
> # SQLSTATE = IX000
> # drop type dbd_ix_distofbool restrict
> # Error Message:
> # SQL: -9628: Type (dbd_ix_distofbool) not found.
> # SQLSTATE = IX000
> # drop type dbd_ix_distoflvc restrict
> # Error Message:
> # SQL: -9628: Type (dbd_ix_distoflvc) not found.
> # SQLSTATE = IX000
> # drop type dbd_ix_distofnamed restrict
> # Error Message:
> # SQL: -9628: Type (dbd_ix_distofnamed) not found.
> # SQLSTATE = IX000
> # drop row type dbd_ix_udts_named restrict
> # Error Message:
> # SQL: -9992: Named row type (dbd_ix_udts_named) not found.
> # SQLSTATE = IX000
> # Test: do('create row type dbd_ix_udts_named (i int)'):
> ok 1
> # Test: do('create distinct type dbd_ix_distofi8 as int8'):
> ok 2
> # Test: do('create distinct type dbd_ix_distofbool as boolean'):
> ok 3
> # Test: do('create distinct type dbd_ix_distoflvc as lvarchar'):
> ok 4
> # Test: do('create distinct type dbd_ix_distofnamed as
> dbd_ix_udts_named'):
> ok 5
> # Test: do('
> # create table dbd_ix_udts
> # (s8 serial8,
> # i8 int8,
> # b boolean,
> # lvc lvarchar,
> # unnamed row(i int, l lvarchar),
> # named dbd_ix_udts_named,
> # sint set(int not null),
> # lunnamed list(row(i int, c char(10)) not null),
> # mnamed multiset(dbd_ix_udts_named not null),
> # di8 dbd_ix_distofi8,
> # db dbd_ix_distofbool,
> # dlvc dbd_ix_distoflvc,
> # dnamed dbd_ix_distofnamed, cl clob) put cl in (sbspace)'):
> DBD::Informix::db do failed: SQL: -9821: Space (sbspace) is not an
> sbspace. at blib/lib/DBD/Informix/TestHarness.pm line 347.
> not ok 6
> # Test: do('
> # insert into dbd_ix_udts values
> # (1, 1, 't',
> '1234567890123456789012345678901234567890123456789012345678901
> 2345678901
> 23456789012345678901234567890123456789012345678901234567890123
> 4567890123
> 45678901234567890123456789012345678901234567890123456789012345
> 6789012345
> 67890123456789012345678901234567890123456789012345678901234567
> 8901234567
> 8901234567890', row(1,
> '1234567890123456789012345678901234567890123456789012345678901
> 2345678901
> 23456789012345678901234567890123456789012345678901234567890123
> 4567890123
> 45678901234567890123456789012345678901234567890123456789012345
> 6789012345
> 67890123456789012345678901234567890123456789012345678901234567
> 8901234567
> 8901234567890'), row(1)::dbd_ix_udts_named,
> # set{1, 10, 100}, list{row(1, 'one')},
> multiset{row(1)::dbd_ix_udts_named},
> # '1', 't',
> '1234567890123456789012345678901234567890123456789012345678901
> 2345678901
> 23456789012345678901234567890123456789012345678901234567890123
> 4567890123
> 45678901234567890123456789012345678901234567890123456789012345
> 6789012345
> 67890123456789012345678901234567890123456789012345678901234567
> 8901234567
> 8901234567890', row(1)::dbd_ix_distofnamed , filetoclob('t/t91udts.t',
> 'client'))
> # '):
> DBD::Informix::db do failed: SQL: -206: The specified table
> (dbd_ix_udts) is not in the database.
> ISAM: -111: ISAM error: no record found. at
> blib/lib/DBD/Informix/TestHarness.pm line 347.
> not ok 7
> # PREPARE: insert into dbd_ix_udts values (?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?, ?, ?, ? , filetoclob(?, 'client'))
> DBD::Informix::db prepare failed: SQL: -206: The specified table
> (dbd_ix_udts) is not in the database.
> ISAM: -111: ISAM error: no record found. at t/t91udts.t line 88.
> Can't call method "execute" on an undefined value at t/t91udts.t line
> 99.
> ok 8
>
> I excluded the DBI_TRACE=9 for now, let me know if I should send it.
>
> Thanks,
>
> Todd E. O'Dell
> Network Services ( DATA )
> Room 1118
> 500 E. 8th
> Kansas City, MO 64106
> Office: (816)275-3626
> Alpha Page: 8162125424@xxxxxxxxxxxxxxxx
> to2958@xxxxxxx
> Rigidity and inflexibility are forever the enemy of ingenuity and
> creativity. -- Teodor Zlatanov
>
>
>
____________________________________________________________________________
The information contained in this email may be confidential and/or legally
privileged. It has been sent for the sole use of the intended recipient(s).
If the reader of this message is not an intended recipient, you are hereby
notified that any unauthorized review, use, disclosure, dissemination,
distribution, or copying of this communication, or any of its contents, is
strictly prohibited. If you have received this communication in error,
please contact the sender by reply email and destroy all copies of the
original message. To contact our email administrator directly, send to
postmaster@xxxxxxxxxxxxx
Thank you.
____________________________________________________________________________
_____________________________________________________________________________________
The information contained in this email may be confidential and/or legally privileged. It has been sent for the sole use of the intended recipient(s). If the reader of this message is not an intended recipient, you are hereby notified that any unauthorized review, use, disclosure, dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please contact the sender by reply email and destroy all copies of the original message. To contact our email administrator directly, send to postmaster@xxxxxxxxxxxx
Thank you.
_____________________________________________________________________________________
.
- Prev by Date: Re: chart_map_modifier in DBD::Chart
- Next by Date: Re: DBD::Informix 2005.01-> t91udts.t fails
- Previous by thread: DBD::Informix 2005.01-> t91udts.t fails
- Next by thread: Strange problems with fetchall_arrayref DBI, DBD::mysql
- Index(es):
Relevant Pages
|
