Problem with DBD-Informix

[Corey Herbel]

System Information at bottom of the email.

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.

I'm assuming I can't skip this test since I will need to access SLOB data.


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
# drop type dbd_ix_distofi8 restrict
# drop type dbd_ix_distofbool restrict
# drop type dbd_ix_distoflvc restrict
# drop type dbd_ix_distofnamed restrict
# drop row type dbd_ix_udts_named restrict
# 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)
'):
ok 6
# Test: do('
insert into dbd_ix_udts values
(1, 1, 't', '123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890', row(1, '123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890'), row(1)::dbd_ix_udts_named,
set{1, 10, 100}, list{row(1, 'one')}, multiset{row(1)::dbd_ix_udts_named},
'1', 't', '123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890', row(1)::dbd_ix_distofnamed,
filetoclob('t/t91udts.t', 'client'))
'):
ok 7
# PREPARE: insert into dbd_ix_udts values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, filetoclob(?, 'client'))
ok 8
ok 9


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