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: michael dot peppler at bnpparibas dot com
Subject: Re: dbd-sybase 1.07 compile issue
Date: Dec 8 2006 7:27AM

That's pretty weird.

Can you run the t/exec.t test on its own after adding DBI->trace(5) at the 
top, and send me (not the list) the results?

Thanks.

Michael





Internet
DRoss-Smith@reviewjournal.com@peppler.org - 08.12.2006 00:10
 
Sent by:        owner-sybperl-l@peppler.org
To:     sybperl-l
cc: 
Subject:        dbd-sybase 1.07 compile issue



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:# 


This message and any attachments (the "message") is
intended solely for the addressees and is confidential. 
If you receive this message in error, please delete it and 
immediately notify the sender. Any use not in accord with 
its purpose, any dissemination or disclosure, either whole 
or partial, is prohibited except formal approval. The internet
can not guarantee the integrity of this message. 
BNP PARIBAS (and its subsidiaries) shall (will) not 
therefore be liable for the message if modified. 

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

Ce message et toutes les pieces jointes (ci-apres le 
"message") sont etablis a l'intention exclusive de ses 
destinataires et sont confidentiels. Si vous recevez ce 
message par erreur, merci de le detruire et d'en avertir 
immediatement l'expediteur. Toute utilisation de ce 
message non conforme a sa destination, toute diffusion 
ou toute publication, totale ou partielle, est interdite, sauf 
autorisation expresse. L'internet ne permettant pas 
d'assurer l'integrite de ce message, BNP PARIBAS (et ses
filiales) decline(nt) toute responsabilite au titre de ce 
message, dans l'hypothese ou il aurait ete modifie.