Re: DBD::Sybase 1.09 build error on perl 5.10.0

Checking google I see that someone else had similar errors a while  
ago, but didn't respond to my request for more information...

As I don't have a 12.0 client to test with I've asked for more  
information in the Sybase newsgroups.

Michael

On Dec 28, 2008, at 8:22 PM, Matthew Persico wrote:

> I have a failure building DBD::Sybase 1.09 in the xblk stuff, which I
> really don't use, but maybe you want to investigte anyway.
>
> I am building perl 5.10.0 on Solaris, threaded (yes, threaded, please
> don't try to talk me out of it.).
>
> DBI is 1.607.
>
> Sybase server is
> Adaptive Server Enterprise/12.5.3/EBF 12869 ESD#4/P/Sun_svr4/OS
> 5.8/ase1253/1923/64-bit/FBO/Thu Sep  8 16:05:41 2005
>
> Sybase client libs are 12.0. Yeah, I know. I have no control over  
> that.
>
> The failure is here. perl -V is below.
>
> t/xblk..........1..62
> ok 1 - use DBI;
> ok 2 - use DBD::Sybase;
> ok 3 - Connect
> ok 4 - Create table
> DBD::Sybase::db prepare warning: OpenClient message: LAYER = (0)
> ORIGIN = (0) SEVERITY = (0) NUMBER = (0)
> Server SYDAST01, database
> Message String: blk_init(): blk layer: internal BLK-Library error:
> Failed when CT_Lib routine ct_fetch(BLK_IN_GET_FMT) called.
> ok 5 - Prepare \#1
> ok 6 - Send row 1 - test 1
> cslib_cb: 2 4 1 36 cs_convert: cslib user api layer: common library
> error: The result is truncated because the conversion/operation
> resulted in overflow.
> cslib_cb: User Message: cs_convert failed: column 4:  
> (_convert(123.456, 16))
> DBD::Sybase::st execute failed: cs_convert: cslib user api layer:
> common library error: The result is truncated because the
> conversion/operation resulted in overflow. at t/xblk.t line 97.
> ok 7 - Send row 2 - test 1
> ok 8 - Send row 3 - test 1
> ok 9 - Commit test 1
> ok 10 - Rows test 1
> DBD::Sybase::db begin_work failed: Already in a transaction at
> t/xblk.t line 116.
> DBD::Sybase::db prepare warning: OpenClient message: LAYER = (0)
> ORIGIN = (0) SEVERITY = (0) NUMBER = (0)
> Server SYDAST01, database
> Message String: blk_init(): blk layer: internal BLK-Library error:
> Failed when CT_Lib routine ct_fetch(BLK_IN_GET_FMT) called.
> ok 11 - prepare \#2
> cslib_cb: 2 4 1 20 cs_convert: cslib user api layer: common library
> error: The conversion/operation resulted in overflow.
> cslib_cb: User Message: cs_convert failed: column 5: (_convert(feb 29
> 2001 11:00, 12))
> DBD::Sybase::st execute failed: cs_convert: cslib user api layer:
> common library error: The conversion/operation resulted in overflow.
> at t/xblk.t line 133.
> ok 12 - Execute row 1, test 2
> cslib_cb: 2 4 1 20 cs_convert: cslib user api layer: common library
> error: The conversion/operation resulted in overflow.
> cslib_cb: User Message: cs_convert failed: column 3:
> (_convert(123456789123456, 8))
> DBD::Sybase::st execute failed: cs_convert: cslib user api layer:
> common library error: The conversion/operation resulted in overflow.
> at t/xblk.t line 133.
> ok 13 - Execute row 2, test 2
> cslib_cb: 2 4 1 36 cs_convert: cslib user api layer: common library
> error: The result is truncated because the conversion/operation
> resulted in overflow.
> cslib_cb: User Message: cs_convert failed: column 4:  
> (_convert(123456.78, 16))
> DBD::Sybase::st execute warning: cs_convert: cslib user api layer:
> common library error: The result is truncated because the
> conversion/operation resulted in overflow.OpenClient message: LAYER =
> (0) ORIGIN = (0) SEVERITY = (0) NUMBER = (0)
> Server SYDAST01, database
> Message String: blk_rowxfer(): blk layer: internal BLK-Library error:
> Failed in conversion routine - condition overflow.  col = 4 row = 1.
> ok 14 - Execute row 3, test 2
> cslib_cb: 2 4 1 20 cs_convert: cslib user api layer: common library
> error: The conversion/operation resulted in overflow.
> cslib_cb: User Message: cs_convert failed: column 8:
> (_convert(34343434343434343434.23, 15))
> DBD::Sybase::st execute failed: cs_convert: cslib user api layer:
> common library error: The conversion/operation resulted in overflow.
> at t/xblk.t line 133.
> ok 15 - Execute row 4, test 2
> ok 16 - Commit test 2
> ok 17 - Rows, test 2
> DBD::Sybase::db begin_work failed: Already in a transaction at
> t/xblk.t line 150.
> dubious
>       Test returned status 0 (wstat 139, 0x8b)
> DIED. FAILED tests 18-62
>       Failed 45/62 tests, 27.42% okay
> t/xblob.........1..11
>
> [1841] $ perl -V
> Summary of my perl5 (revision 5 version 10 subversion 0)  
> configuration:
> Platform:
>   osname=solaris, osvers=2.8, archname=sun4-solaris-thread-multi
>   uname='sunos nycux-25k105 5.8 generic_117350-45 sun4u sparc
> sunw,sun-fire-15000 '
>   config_args='-de -Dusethreads -Dcc=cc
> -Dprefix=/home/persicom/perl.v5.10.0
> -Dhtml1dir=/home/persicom/perl.v5.10.0/html/html1
> -Dhtml3dir=/home/persicom/perl.v5.10.0/html/html3
> -Dinstallusrbinperl=undef [email protected]
> [email protected]'
>   hint=recommended, useposix=true, d_sigaction=define
>   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_REENTRANT -I/usr/local/include
> -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64',
>   optimize='-O',
>   cppflags='-D_REENTRANT -I/usr/local/include'
>   ccversion='Sun C 5.8 2005/10/13', gccversion='', gccosandvers=''
>   intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321
>   d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
>   ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t',
> lseeksize=8
>   alignbytes=8, prototype=define
> Linker and Libraries:
>   ld='cc', ldflags =' -L/usr/lib -L/usr/ccs/lib
> -L/opt/SUNWspro_11/prod/lib/v8plus -L/opt/SUNWspro_11/prod/lib -L/lib
> -L/usr/local/lib '
>   libpth=/usr/lib /usr/ccs/lib /opt/SUNWspro_11/prod/lib/v8plus
> /opt/SUNWspro_11/prod/lib /lib /usr/local/lib
>   libs=-lsocket -lnsl -ldl -lm -lpthread -lc
>   perllibs=-lsocket -lnsl -ldl -lm -lpthread -lc
>   libc=/lib/libc.so, so=so, useshrplib=false, libperl=libperl.a
>   gnulibc_version=''
> Dynamic Linking:
>   dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' '
>   cccdlflags='-KPIC', lddlflags='-G -L/usr/lib -L/usr/ccs/lib
> -L/opt/SUNWspro_11/prod/lib/v8plus -L/opt/SUNWspro_11/prod/lib -L/lib
> -L/usr/local/lib'
>
>
> Characteristics of this binary (from libperl):
> Compile-time options: MULTIPLICITY PERL_DONT_CREATE_GVSV
>                       PERL_IMPLICIT_CONTEXT PERL_MALLOC_WRAP  
> USE_ITHREADS
>                       USE_LARGE_FILES USE_PERLIO USE_REENTRANT_API
> Built under solaris
> Compiled at Dec 28 2008 00:07:21
> %ENV:
>   PERL5LIB="/sa/common/lib/5.10.0"
> @INC:
>   /sa/common/lib/5.10.0/sun4-solaris-thread-multi
>   /sa/common/lib/5.10.0
>   /home/persicom/perl.v5.10.0/lib/5.10.0/sun4-solaris-thread-multi
>   /home/persicom/perl.v5.10.0/lib/5.10.0
>   /home/persicom/perl.v5.10.0/lib/site_perl/5.10.0/sun4-solaris- 
> thread-multi
>   /home/persicom/perl.v5.10.0/lib/site_perl/5.10.0
>   .
>
>
> -- 
> Matthew O. Persico
>

Michael Peppler              -                    Peppler Consulting  
SaRL
[email protected]         -                     http://www.peppler.org
Sybase DBA/Developer         -      TeamSybase: http://www.teamsybase.com
Sybase on Linux FAQ          -      http://www.peppler.org/FAQ/linux.html