Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: gene dot livshits at jpmorgan dot com
Subject: DBD-Sybase 1.07_1 make test problem.
Date: Dec 8 2005 6:21PM


            I would like to get some help on the following problem:

I have Sybase 12.5 running on Solaris 2.8.  I am trying to compile

DBD-Sybase 1.07_1.  I chose this version specifically to go around

the libblk issue know to hunt the compilation of this module to to

the lack of the proper library in the distribution of the ASE 12.5.

I also made sure that there is -DNO_BLK=1 enabled.  As you can

see I have taken care of the locale as well.  Still the make test

fails with numerous messages ( see below ).  I have really tried 

everthing: compiling with libblk.a ( 32 bit ) which I have copied from

32 bit distribution - no luck.  I have tried DBD::Sybase version 1.04

no luck.  This is the turning point to ask for help on the maillist.

I have searched  the archives with no luck either..  Thanks in advance

for the help to resolve this issue.




espdb-dev3:DBD-Sybase-1.07_01/ # export LANG=en_US     

espdb-dev3:DBD-Sybase-1.07_01/ # make clean

]rm -rf Sybase.c Sybase.xsi PWD ./blib Makefile.aperl
blib/arch/auto/DBD/Sybase/extralibs.ld perlmain.c tmon.out mon.out
so_locations pm_to_blib *.o *.a perl.exe perl perl Sybase.bso
Sybase.def libSybase.def Sybase.exp Sybase.x core core.*perl.*.?
*perl.core core.[0-9] core.[0-9][0-9] core.[0-9][0-9][0-9]
core.[0-9][0-9][0-9][0-9] core.[0-9][0-9][0-9][0-9][0-9]

mv Makefile Makefile.old > /dev/null 2>&1

espdb-dev3:DBD-Sybase-1.07_01/ # /opt/esp/common/bin/perl Makefile.PL

Sybase OpenClient 12.5.1 found.


By default DBD::Sybase 1.05 and later use the 'CHAINED' mode (where

when 'AutoCommit' is turned off. Versions 1.04 and older instead managed

the transactions explicitly with a 'BEGIN TRAN' before the first DML

statement. Using the 'CHAINED' mode is preferable as it is the way that

Sybase implements AutoCommit handling for both its ODBC and JDBC drivers.


Use 'CHAINED' mode by default (Y/N) [Y]: 


Running in threaded mode - looking for _r libraries...

Found -lct_r for -lct

Found -lcs_r for -lcs

Found -ltcl_r for -ltcl

Found -lcomn_r for -lcomn

Found -lintl_r for -lintl

BLK api available - found: blk_r64

The DBD::Sybase module need access to a Sybase server to run the tests.

To clear an entry please enter 'undef'

Sybase server to use (default: SYBASE): LGL_SONAR_DEV3

User ID to log in to Sybase (default: sa): glivshits

Password (default: undef): Sybase database to use on LGL_SONAR_DEV3
(default: undef): dlck


* Writing login information, including password, to file PWD.


Checking if your kit is complete...

Looks good

Note (probably harmless): No library found for -lblk

Using DBI 1.48 (for perl 5.008007 on sun4-solaris-thread-multi-64int)
installed in

Writing Makefile for DBD::Sybase

espdb-dev3:DBD-Sybase-1.07_01/ # make

cp dbd-sybase.pod blib/lib/DBD/dbd-sybase.pod

cp blib/lib/DBD/

/opt/esp/common/bin/perl -p -e "s/~DRIVER~/Sybase/g"
auto/DBI//Driver.xst > Sybase.xsi

/opt/esp/common/bin/perl /opt/esp/common/lib/perl5/5.8.7/ExtUtils/xsubpp
-typemap /opt/esp/common/lib/perl5/5.8.7/ExtUtils/typemap  Sybase.xs >
Sybase.xsc && mv Sybase.xsc Sybase.c

gcc -c  -I/home/sybase/release/OCS-12_5/include -DNO_BLK=1
t/auto/DBI -D_REENTRANT -fno-strict-aliasing -pipe -I/usr/local/include
-DXS_VERSION=\"1.07_01\" -fPIC

gcc -c  -I/home/sybase/release/OCS-12_5/include -DNO_BLK=1
t/auto/DBI -D_REENTRANT -fno-strict-aliasing -pipe -I/usr/local/include
-DXS_VERSION=\"1.07_01\" -fPIC

Running Mkbootstrap for DBD::Sybase ()

chmod 644

rm -f blib/arch/auto/DBD/Sybase/

LD_RUN_PATH="/home/sybase/release/OCS-12_5/lib" gcc
-L/home/sybase/release/OCS-12_5/lib -G -L/usr/local/lib Sybase.o dbdimp.o
-o blib/arch/auto/DBD/Sybase/
-L/home/sybase/release/OCS-12_5/lib -lct_r -lcs_r -ltcl_r -lcomn_r
-lintl_r -ldl -lm   

chmod 755 blib/arch/auto/DBD/Sybase/

cp blib/arch/auto/DBD/Sybase/

chmod 644 blib/arch/auto/DBD/Sybase/

Manifying blib/man3/DBD::Sybase.3

espdb-dev3:DBD-Sybase-1.07_01/ # make test

PERL_DL_NONLAZY=1 /opt/esp/common/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t


        Test returned status 0 (wstat 139, 0x8b)

DIED. FAILED tests 2-9

        Failed 8/9 tests, 11.11% okay


        Test returned status 0 (wstat 139, 0x8b)


        Test returned status 0 (wstat 139, 0x8b)

DIED. FAILED tests 2-22

        Failed 21/22 tests, 4.55% okay


        Test returned status 0 (wstat 139, 0x8b)

DIED. FAILED tests 2-12

        Failed 11/12 tests, 8.33% okay


        Test returned status 0 (wstat 139, 0x8b)

DIED. FAILED tests 2-4

        Failed 3/4 tests, 25.00% okay


        Test returned status 0 (wstat 139, 0x8b)

DIED. FAILED tests 2-33

        Failed 32/33 tests, 3.03% okay


        Test returned status 0 (wstat 139, 0x8b)

DIED. FAILED tests 2-43

        Failed 42/43 tests, 2.33% okay


        Test returned status 0 (wstat 139, 0x8b)

DIED. FAILED tests 2-7

        Failed 6/7 tests, 14.29% okay


        Test returned status 0 (wstat 139, 0x8b)

DIED. FAILED tests 2-13

        Failed 12/13 tests, 7.69% okay


        Test returned status 0 (wstat 139, 0x8b)


        Test returned status 0 (wstat 139, 0x8b)

DIED. FAILED tests 2-62

        Failed 61/62 tests, 1.61% okay


        Test returned status 0 (wstat 139, 0x8b)

DIED. FAILED tests 2-11

        Failed 10/11 tests, 9.09% okay

Failed Test    Stat Wstat Total Fail  Failed  List of Failed


t/autocommit.t    0   139     9   16 177.78%  2-9

t/base.t          0   139    ??   ??       %  ??

t/exec.t          0   139    22   42 190.91%  2-22

t/fail.t          0   139    12   22 183.33%  2-12

t/login.t         0   139     4    6 150.00%  2-4

t/main.t          0   139    33   64 193.94%  2-33

t/multi_sth.t     0   139    43   84 195.35%  2-43

t/nsql.t          0   139     7   12 171.43%  2-7

t/place.t         0   139    13   24 184.62%  2-13

t/thread.t        0   139    ??   ??       %  ??

t/xblk.t          0   139    62  122 196.77%  2-62

t/xblob.t         0   139    11   20 181.82%  2-11

Failed 12/12 test scripts, 0.00% okay. 206/216 subtests failed, 4.63%

make: *** [test_dynamic] Error 255

espdb-dev3:DBD-Sybase-1.07_01/ #

This communication is for informational purposes only. It is not intended
as an offer or solicitation for the purchase or sale of any financial
instrument or as an official confirmation of any transaction. All market prices,
data and other information are not warranted as to completeness or accuracy and
are subject to change without notice. Any comments or statements made herein 
do not necessarily reflect those of JPMorgan Chase & Co., its subsidiaries 
and affiliates