sybperl-l Archive

From: Bill dot Morrow at metso dot com
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:04PM

More information, if anyone cares.

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.
   130      ++$count;
   131      print "dbpoll: reason = $reason\n";
   132  } while($count < 20 && $reason != DBRESULT);
   133
   134  exit if $reason != DBRESULT;


The first 19 tests in dblib.t pass successfully, and that select from
sysprocesses statement works just fine from sqsh.


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