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: 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 3:58PM


I'll check if we're lagging on EBF's. If it was identified in Solaris 11.1.1,
one would think it would be fixed for DEC 11.9.2. (Hmmm. I just came across your
comments over the last few years in comp.lang.perl.x regarding dbpoll() timing
out prematurely.) So maybe I shouldn't think that way :)

Changing dblib.t thusly:

   128  do {
   129      ($x, $reason) = Sybase::DBlib->dbpoll(100000); # was dbpoll(-1)
   130      ++$count;
   131      print "dbpoll: reason = $reason\n";
   132  } while($count < 20 && $reason != DBRESULT);

had no effect on the test, running under the perl debugger, or full speed. If I
comment out the test, it is reported as a failure :).

Do you think using the old 10.0.4 client libraries is a factor? I have no choice
right now.

Bill
|--------+----------------------->
|        |  mpeppler@peppler.org |
|        |                       |
|        |  06/08/2001 08:47 AM  |
|        |  Please respond to    |
|        |  SYBPERL-L            |
|        |                       |
|--------+----------------------->
  >---------------------------------------------------------------------------|
  |                                                                           |
  |       To:     SYBPERL-L@list.cren.net                                     |
  |       cc:     (bcc: Bill Morrow/CGY/NelesAutomation)                      |
  |       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        |
  >---------------------------------------------------------------------------|




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