sybperl-l Archive

From: "DeGuzman, Daniel" <Daniel dot DeGuzman at mtvstaff dot com>
Subject: DBD::Sybase with host process disconnect errors when run from linux
Date: Oct 3 2006 6:22PM

Has anyone come across this problem?  Any help would be appreciated
(it's driving me bananas).  When I run a simple connect to a sybase
server from a linux box, the connect creates a "host process disconnect"
message in the Sybase error log.  When I run the same script on a sun
solaris box, no message in the Sybase errorlog.  Do you think upgrading
it to the latest DBD version would help?

Dan

Details:

Script runs from linux box with DBD::sybase, Sybase.pm,v 1.4, linux
version Linux 2.4.21-27.0.2.ELsmp #1 SMP
Connects to Sybase 12.5.2 ESD2, running on Sun solaris 2.8

Code:

my $dbh = DBI->connect("dbi:Sybase:server=$status_server", $login,
$password, {PrintError => 1});

if ($dbh) {
   $query = "select xyz from db..table where status = 0";
   $hash = $dbh->selectall_hashref($query, "server_name");
   $dbh->disconnect;

   while (my ($k, $v) = each(%$hash)){
   print "$k => $v\n";
   }
}


Sybase error log: (this only happens during the "DBI-> connect" command)

1st time running script
01:00000:02914:2006/10/03 12:55:02.92 kernel  Cannot read, host process
disconnected: linux-db-1.1515.mtvi.com 37876 spid: 2914

2nd time running script
01:00000:02178:2006/10/03 12:55:03.07 kernel  Cannot read, host process
disconnected: linux-db-1.1515.mtvi.com 37876 spid: 2178

Notes:  The code returns valid results from both linux and sun; it's
just those darn messages in the errorlog that is making the errorlog
grow waaaaaay too much.