On Mon, 25 Nov 2002 16:29:00 -0600 Corey Herbel <[EMAIL PROTECTED]>
wrote:
> System Information at bottom of the email.
DBD::Informix v0.97005 has not been current for over two and a half years.
V1.00 hasn't been current for less than a week -- please check out v1.04.
> I can't seem to get the make test to complete.
> Each time it blows up the engine leaving
> shared memory segments and it is always on the
> same t91udts.t test.
That "shouldn't happen". Nothing an application does should take the server
down.
> I'm assuming I can't skip this test since I
> will need to access SLOB data.
If you need to access SLOBs, you probably do need this test to pass.
> Here is the output snippet of the test from the
> make test VERBOSE=1
> t/t91udts...........# Driver Information
> # Name: Informix
> # Version: 1.00.PC2
> # Product: INFORMIX-ESQL
> Version 9.30.UC1
> # Product Version: 930
> # Connect to: testdb1
> # 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
This is OK; it means the database was clean of the table before the test
started.
> # drop type dbd_ix_distofi8 restrict
[...]
> # 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)
> '):
> ok 6
This has me at least mildly puzzled - but I don't have manuals at hand to sort
out my puzzlement. I thought that a smart blobspace should be specified with
a PUT clause.
> # Test: do('
[...]
> # PREPARE: insert into dbd_ix_udts values (?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> filetoclob(?, 'client'))
> ok 8
> ok 9
So far, so good...
> .....and here is the section of code it fails
> on....
>
> # if the length of udt is longer than 256 and
> truncated value is
> # syntactically wrong (ex. row(3, '$longstr')),
> insert will fail and
> # report invalid syntax (rather than blow up).
> NB: $0 refers to this
> # script file!
> $sth->execute
> (3, 3, "f", "$longstr", "row(3, 'three')",
> "row(3)", "set{3, 30, 300}",
> "list{row(3, 'three'), row(30,
> 'thirty')}",
> "multiset{row(3), row(30)}", "3", "f",
> "$longstr", "row(3)", "$0")
> or die;
>
>
>
> Thanks for any help on this, I've been trying
> various tests for two weeks trying to figure
> out why this is happening. I've
> downgraded/upgraded
Well, full marks for persistence in the face of adversity.
Do you have a smart blobspace set up? Is it called sbspace? If not, the
older tests will fail (test error). If you have DBD::Informix 1.04.PC1, then
you can specify the name of the smart blobspace - or suppress the testing of
smart blobs (not that you want to do that).
> OS: Redhat 6.2 upgraded to 7.1
> IDS 9.2UC1/9.3UC2
> CSDK
> csdk230uc11_linux.rpm/clientsdk_2.5_UC2.rpm
> DBI DBI-1.13/DBI-1.30
> DBD DBD-Informix-0.97005/DBD-Informix-1.00.PC2
> IDS: 9.2 -- It's also a new install
If you can use the IDS 9.30.UC3 version, or the nearest available release,
that would be best. Similarly, review whether you can use ClientSDK 2.80 or
2.70. I'm not as confident as I'd like to be because there are issues with
different versions of Linux and the way the Informix code behaves.
Consider an upgrade to Perl 5.8.0, but I don't regard that as critical. Your
threading configuration is fine; I don't see what the trouble is.
> perl -V
> Summary of my perl5 (revision 5.0 version 6
> subversion 1) configuration:
> Platform:
> osname=linux, osvers=2.4.2-2smp,
> archname=i686-linux
> uname='linux prod3.sportingnews.com
> 2.4.2-2smp #1 smp sun apr 8 20:21:34 edt 2001
> i686 unknown '
> config_args='-de'
> hint=recommended, useposix=true,
> d_sigaction=define
> usethreads=undef use5005threads=undef
> useithreads=undef usemultiplicity=undef
> useperlio=undef d_sfio=undef
> uselargefiles=define usesocks=undef
> use64bitint=undef use64bitall=undef
> uselongdouble=undef
> Compiler:
> cc='cc', ccflags ='-fno-strict-aliasing
> -I/usr/local/include -D_LARGEFILE_SOURCE
> -D_FILE_OFFSET_BITS=64',
> optimize='-O2',
> cppflags='-fno-strict-aliasing
> -I/usr/local/include'
> ccversion='', gccversion='2.96 20000731
> (Red Hat Linux 7.1 2.96-81)', gccosandvers=''
> intsize=4, longsize=4, ptrsize=4,
> doublesize=8, byteorder=1234
> d_longlong=define, longlongsize=8,
> d_longdbl=define, longdblsize=12
> ivtype='long', ivsize=4, nvtype='double',
> nvsize=8, Off_t='off_t', lseeksize=8
> alignbytes=4, usemymalloc=n,
> prototype=define
> Linker and Libraries:
> ld='cc', ldflags =' -L/usr/local/lib'
> libpth=/usr/local/lib /lib /usr/lib
> libs=-lnsl -ldl -lm -lc -lcrypt -lutil
> perllibs=-lnsl -ldl -lm -lc -lcrypt -lutil
> libc=/lib/libc-2.2.4.so, so=so,
> useshrplib=false, libperl=libperl.a
> Dynamic Linking:
> dlsrc=dl_dlopen.xs, dlext=so,
> d_dlsymun=undef, ccdlflags='-rdynamic'
> cccdlflags='-fpic', lddlflags='-shared
> -L/usr/local/lib'
>
>
> Characteristics of this binary (from libperl):
> Compile-time options: USE_LARGE_FILES
> Built under linux
> Compiled at Nov 19 2002 13:57:35
> @INC:
> /usr/local/lib/perl5/5.6.1/i686-linux
> /usr/local/lib/perl5/5.6.1
>
> /usr/local/lib/perl5/site_perl/5.6.1/i686-linux
> /usr/local/lib/perl5/site_perl/5.6.1
> /usr/local/lib/perl5/site_perl
> .
>
>
