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 Peppler <mpeppler at peppler dot org>
Subject: Re: make test of dblib failing sybperl 2.13 / perl 5.6.1 on OSF 4 .0, Sybase 10.0.4 library ASE 11.9.2
Date: Jun 8 2001 2:47PM

Bill.Morrow@metso.com writes:
 > 
 > More information, if anyone cares.

I do!

 > I put DBlib/t/dblib.t in perl debug mode, and stepped through the script.
 > Strangely, it gets further along, and fails here:
 > 
 > main::(t/dblib.t:129):
 >   DB<1>
 > Sybase error: Read from SQL Server failed.
 > OS Error: Invalid argument
 > main::(t/dblib.t:130):
 > main::(t/dblib.t:131):
 >   DB<1>
 > Use of uninitialized value in concatenation (.) or string at t/dblib.t line 131.
 > Use of uninitialized value in numeric ne (!=) at t/dblib.t line 128.
 > main::(t/dblib.t:129):
 > 
 >    123  $X->dbcmd("select * from master..sysprocesses");
 >    124  $X->dbsqlsend;
 >    125  my $count = 0;
 >    126  my ($x, $reason);
 >    127
 >    128  do {
 >    129      ($x, $reason) = Sybase::DBlib->dbpoll(-1); <------- Sybase error:
 > Read from SQL Server failed.

Aha!

I suspect that you have a bad EBF. Some EBFs of 11.1.1 on Solaris have
a broken dbpoll(), and I guess that these are also broken on DEC
Unix...

First you can try to change the -1 parameter to some large value
(100000 say) and see if that fixes the problem. 

If that still fails you can comment out that whole block, unless you
need to use dbpoll() in your scripts, in which case I suggest bringing
this up with Sybase to get a more recent EBF of the libraries.

Michael


 > Bill.Morrow@metso.com writes:
 >  >
 >  >
 >  > make test of dblib is failing. I have
 >  >
 >  > EXTRA_LIBS= -lsdna -ldnet_stub
 >  >
 >  > in CONFIG, and set LD_LIBRARY_PATH to $SYBASE/lib
 >  >
 >  > The BCP and ctlib test pass successfully, here is some error output
 >  > once it hits dblib:
 >  > ...
 >  > All tests successful.
 >  > Files=2, Tests=52,  0 wallclock secs ( 0.25 cusr +  0.03 csys =  0.28
 >  > CPU)
 >  > gmake[1]: Leaving directory
 >  > `/usr/local/ksp/users/billm/sybperl-2.13/CTlib'
 >  > gmake[1]: Entering directory
 >  > `/usr/local/ksp/users/billm/sybperl-2.13/DBlib'
 >  > PERL_DL_NONLAZY=1 /usr/ucb/perl -I../blib/arch -I../blib/lib
 >  > -I/usr/local/ksp/ALPHA/system/lib/perl5/5.6.1/alpha-dec_osf
 > 
 > Well - the version of perl would normally be unimportant, but it seems
 > strange that the perl binary used for the test is in /usr/ucb/perl,
 > but the perl include dir is in /usr/local/ksp/...
 > 
 >  > -I/usr/local/ksp/ALPHA/system/lib/perl5/5.6.1 -e 'use Test::Harness
 >  > qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t
 >  > t/dblib.............Sybase error: Read from SQL Server failed.
 >  > OS Error: Bad file number
 > 
 > Can you access the server from the same shell using isql?
 > 
 > Michael
 > --
 > Michael Peppler - Data Migrations Inc. - mpeppler@peppler.org
 > http://www.mbay.net/~mpeppler - mpeppler@mbay.net
 > International Sybase User Group - http://www.isug.com
 > Sybase on Linux mailing list: ase-linux-list@isug.com
 > 
 > 
 > 

-- 
Michael Peppler - Data Migrations Inc. - mpeppler@peppler.org
http://www.mbay.net/~mpeppler - mpeppler@mbay.net
International Sybase User Group - http://www.isug.com
Sybase on Linux mailing list: ase-linux-list@isug.com