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