PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: DRoss-Smith at reviewjournal dot com
Subject: dbd-sybase 1.07 compile issue
Date: Dec 7 2006 11:10PM

Hello list...

I'm building DBI and DBD sybase against a solaris 9 perl install (v5.6.1).
Because I'm using the standard perl that comes with the O/S, cc has been 
installed as the compiler to build like-minded perl modules.
DBI builds ok and is version 1.53- the oldest version it supports is 
5.6.1.
Sybase ASE is 12.5.0.3

DBD:Sybase isn't going so well.
the configure and make parts work but make test is failing.  When running 
make test verbose, I see conversion/overflow errors in a couple of places 
in the tests.
Ideas, anyone?

Thanks
Dean Ross-Smith

root@dtiweb2:DBD-Sybase-1.07:# make test
PERL_DL_NONLAZY=1 /bin/perl -Iblib/arch -Iblib/lib 
-I/usr/perl5/5.6.1/lib/sun4-solaris-64int -I/usr/perl5/5.6.1/lib -e 'use 
Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t
t/autocommit....ok
t/base..........ok
t/exec..........ok 9/22
#   Failed test 'Implicit finish handling'
#   at t/exec.t line 150.
t/exec..........NOK 20/22# Looks like you failed 1 test of 22.
t/exec..........dubious
        Test returned status 1 (wstat 256, 0x100)
DIED. FAILED test 20
        Failed 1/22 tests, 95.45% okay
t/fail..........ok
t/login.........ok
t/main..........ok
t/multi_sth.....ok
t/nsql..........ok
t/place.........ok
t/thread........skipped
        all skipped: this perl 5.006001 not configured to support iThreads
t/xblk..........ok
t/xblob.........ok
Failed Test Stat Wstat Total Fail  List of Failed
-------------------------------------------------------------------------------
t/exec.t       1   256    22    1  20
1 test skipped.
Failed 1/12 test scripts. 1/221 subtests failed.
Files=12, Tests=221,  3 wallclock secs ( 1.98 cusr +  0.33 csys =  2.31 
CPU)
Failed 1/12 test programs. 1/221 subtests failed.
*** Error code 11
make: Fatal error: Command failed for target `test_dynamic'
root@dtiweb2:DBD-Sybase-1.07:#

------------------------------------------------------------------------

Running verbose shows
root@dtiweb2:DBD-Sybase-1.07:# make test TEST_VERBOSE=1
PERL_DL_NONLAZY=1 /bin/perl -Iblib/arch -Iblib/lib 
-I/usr/perl5/5.6.1/lib/sun4-solaris-64int -I/usr/perl5/5.6.1/lib -e 'use 
Test::Harness qw(&runtests $verbose); $verbose=1; runtests @ARGV;' t/*.t
t/autocommit....1..9
ok 1 - use DBI;
ok 2 - use DBD::Sybase;
ok 3 - Connect
ok 4 - rollback
a string 1
another string 2
foodiboo 3
a string 4
ok 5 - Commit
ok 6 - begin_work
ok 7 - Non-chained prepare
ok 8 - Finish
ok 9 - commit
ok
t/base..........1..5
ok 1
ok 2
ok 3
ok 4
ok 5
ok
t/exec..........1..22
ok 1 - use DBI;
ok 2 - use DBD::Sybase;
ok 3 - Connect
ok 4 - Prepare sp_helpindex
ok 5 - exec sysusers
ok 6 - -1 (create proc)
#
ok 7 - prepare dbitest
ok 8 - execute dbitest 1
ok 9 - exec dbitest 2
DBD::Sybase::st fetch warning: Number of row fields inconsistent with 
NUM_OF_FIELDS, NUM_OF_FIELDS updated at t/exec.t line 173.
DBD::Sybase::st fetch warning: Number of row fields inconsistent with 
NUM_OF_FIELDS, NUM_OF_FIELDS updated at t/exec.t line 174.
ok 10 - exec dbitest 3
ok 11 - out param 1
ok 12 - execute fail mode 1
DBD::Sybase::st fetch warning: Number of row fields inconsistent with 
NUM_OF_FIELDS, NUM_OF_FIELDS updated at t/exec.t line 173.
DBD::Sybase::st fetch warning: Number of row fields inconsistent with 
NUM_OF_FIELDS, NUM_OF_FIELDS updated at t/exec.t line 174.
ok 13 - execute fail mode 2
DBD::Sybase::st fetch warning: Number of row fields inconsistent with 
NUM_OF_FIELDS, NUM_OF_FIELDS updated at t/exec.t line 173.
DBD::Sybase::st fetch warning: Number of row fields inconsistent with 
NUM_OF_FIELDS, NUM_OF_FIELDS updated at t/exec.t line 174.
ok 14 - execute fail mode 3
DBD::Sybase::st fetch warning: Number of row fields inconsistent with 
NUM_OF_FIELDS, NUM_OF_FIELDS updated at t/exec.t line 173.
DBD::Sybase::st fetch warning: Number of row fields inconsistent with 
NUM_OF_FIELDS, NUM_OF_FIELDS updated at t/exec.t line 174.
ok 15 - execute fail mode 4
DBD::Sybase::st fetch warning: Number of row fields inconsistent with 
NUM_OF_FIELDS, NUM_OF_FIELDS updated at t/exec.t line 173.
DBD::Sybase::st fetch warning: Number of row fields inconsistent with 
NUM_OF_FIELDS, NUM_OF_FIELDS updated at t/exec.t line 174.
ok 16 - execute fail mode 5
DBD::Sybase::st fetch warning: Number of row fields inconsistent with 
NUM_OF_FIELDS, NUM_OF_FIELDS updated at t/exec.t line 173.
DBD::Sybase::st fetch warning: Number of row fields inconsistent with 
NUM_OF_FIELDS, NUM_OF_FIELDS updated at t/exec.t line 174.
DBD::Sybase::st fetch warning: Number of row fields inconsistent with 
NUM_OF_FIELDS, NUM_OF_FIELDS updated
Number of row fields inconsistent with NUM_OF_FIELDS, NUM_OF_FIELDS 
updated at t/exec.t line 174.
ok 17 - execute fail mode 6
DBD::Sybase::st fetch warning: Number of row fields inconsistent with 
NUM_OF_FIELDS, NUM_OF_FIELDS updated at t/exec.t line 173.
DBD::Sybase::st fetch warning: Number of row fields inconsistent with 
NUM_OF_FIELDS, NUM_OF_FIELDS updated at t/exec.t line 174.
ok 18 - -1 (create proc)
#
ok 19 - Implicit finish handling
DBD::Sybase::st fetch warning: Number of row fields inconsistent with 
NUM_OF_FIELDS, NUM_OF_FIELDS updated at t/exec.t line 149.
Use of uninitialized value in numeric eq (==) at t/exec.t line 150.

#   Failed test 'Implicit finish handling'
#   at t/exec.t line 150.
not ok 20 - Implicit finish handling
DBD::Sybase::st fetch warning: Number of row fields inconsistent with 
NUM_OF_FIELDS, NUM_OF_FIELDS updated at t/exec.t line 149.
ok 21 - Implicit finish handling
ok 22 - Implicit finish handling
# Looks like you failed 1 test of 22.
dubious
        Test returned status 1 (wstat 256, 0x100)
DIED. FAILED test 20
        Failed 1/22 tests, 95.45% okay
t/fail..........1..12
ok 1 - use DBI;
ok 2 - use DBD::Sybase;
ok 3 - Connect
ok 4 - Missing table
ok 5 - Sysusers
ok 6 - Create table
ok 7 - prepare w/placeholder
ok 8 - execute w/placeholder
ok 9 - execute w/placeholder
ok 10 - prepare
---- snip---
all tests ok
---- snip ----
18826 691 16393 KFRANTZA
18827 692 16393 EJANKOWSKIA
20349 693 0 j2ee
ok 7 - syb_nsql 2
1
ok
t/place.........1..13
ok 1 - use DBI;
ok 2 - use DBD::Sybase;
ok 3 - Connect
ok 4 - Create table
ok 5 - prepare
ok 6 - insert 1
ok 7 - insert 2
ok 8 - insert 3 (fail)
ok 9 - prepare 2
ok 10 - select
test Jan  3 1998 12:00AM 123.4 222.333
other test Jan 25 1998 12:00AM 4445123.4 2.000
ok 11 - fetch count
ok 12 - select 2
other test Jan 25 1998 12:00AM 4445123.4 2.000
ok 13 - fetch 2
ok
t/thread........1..0 # Skipped: this perl 5.006001 not configured to 
support iThreads
skipped
        all skipped: this perl 5.006001 not configured to support iThreads
t/xblk..........1..62
ok 1 - use DBI;
ok 2 - use DBD::Sybase;
ok 3 - Connect
ok 4 - Create table
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 94.
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 113.
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 130.
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 130.
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 TESTADMEDIA, 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 130.
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 147.
ok 18 - Prepare \#3
ok 19 - Execute row 1, test 3
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 161.
ok 20 - Execute row 2, test 3
ok 21 - Execute row 3, test 3
ok 22 - Commit, test 3
ok 23 - Rows, test 3
DBD::Sybase::db begin_work failed: Already in a transaction at t/xblk.t 
line 179.
DBD::Sybase::db prepare failed: Can't get table name from 'insrt #tmp 
values(:p1, :p2, :p3, :p4, :p5, :p6, :p7, :p8, :p9, :p10)' at t/xblk.t 
line 181.
ok 24 - Prepare \#4
Can't get table name from 'insrt #tmp values(:p1, :p2, :p3, :p4, :p5, :p6, 
:p7, :p8, :p9, :p10)'
DBD::Sybase::db prepare failed: Can't get table name from 'select * from 
#tmp where foo = :p1' at t/xblk.t line 187.
ok 25 - Prepare \#5
DBD::Sybase::db prepare failed: The syb_bcp_attribs attribute is set, but 
no placeholders found in the query at t/xblk.t line 191.
ok 26 - Prepare \#6
The syb_bcp_attribs attribute is set, but no placeholders found in the 
query
DBD::Sybase::db begin_work failed: Already in a transaction at t/xblk.t 
line 203.
ok 27 - Prepare test 5
ok 28 - Send row 1 - test 5
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 218.
ok 29 - Send row 2 - test 5
ok 30 - Send row 3 - test 5
finish: 3 uncommited rows will be rolled back at t/xblk.t line 224.
DBD::Sybase::db begin_work failed: Already in a transaction at t/xblk.t 
line 231.
ok 31 - Prepare test 6
ok 32 - Send row 1 - test 6
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 246.
ok 33 - Send row 2 - test 6
ok 34 - Send row 3 - test 6
ok 35 - test 6 rollback
ok 36 - test 6 finish
DBD::Sybase::db begin_work failed: Already in a transaction at t/xblk.t 
line 257.
ok 37 - test 6 prepare select
ok 38 - test 6 execute select
ok 39 - test 6 row value
DBD::Sybase::db begin_work failed: Already in a transaction at t/xblk.t 
line 268.
ok 40 - Prepare test 6 (2)
ok 41 - Send row 4 - test 6
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 276.
ok 42 - Send row 5 - test 6
ok 43 - Send row 6 - test 6
ok 44 - test 6 commit
ok 45 - Send row 7 - test 6
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 284.
ok 46 - Send row 8 - test 6
ok 47 - Send row 9 - test 6
ok 48 - test 6 rollback
ok 49 - test 6 finish
ok 50 - prepare test 7
ok 51 - execute test 7
9 366 3333.11
ok 52 - Row count
ok 53 - Sum(i)
ok 54 - Sum(n)
ok 55 - Prepare update test 8
ok 56 - Execute update test 8
ok 57 - Prepare test 8
ok 58 - Send row 1 - test 8
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 348.
ok 59 - Send row 2 - test 8
ok 60 - Send row 3 - test 8
ok 61 - Commit test 8
ok 62 - Rows test 8
ok
t/xblob.........1..11
ok 1 - use DBI;
ok 2 - use DBD::Sybase;
ok 3 - Connect
ok 4 - Create table
ok 5 - Insert image
ok 6 - Images are the same
ok 7 - Drop table
ok 8 - Creat table
ok 9 - Insert image
ok 10 - Images are the same
ok 11 - Drop table
ok
Failed Test Stat Wstat Total Fail  List of Failed
-------------------------------------------------------------------------------
t/exec.t       1   256    22    1  20
1 test skipped.
Failed 1/12 test scripts. 1/221 subtests failed.
Files=12, Tests=221,  3 wallclock secs ( 2.01 cusr +  0.32 csys =  2.33 
CPU)
Failed 1/12 test programs. 1/221 subtests failed.
*** Error code 11
make: Fatal error: Command failed for target `test_dynamic'
root@dtiweb2:DBD-Sybase-1.07:#