sybperl-l Archive

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

FYI: we found the culprit, and it wasn't a perl DBD problem as
suspected.
 
Turns out when the sybase dataserver is started using the "tcp" protocol
(instead of the old hexidecimal "tli") in the interfaces file, it
reports these harmless disconnects..  By restarting the server using
"tli", there are no messages.
 
They currently have a CR open with the engineers to supress these
messages using sp_altermessage.
 
Dan

________________________________

From: michael.peppler@bnpparibas.com
[mailto:michael.peppler@bnpparibas.com] 
Sent: Wednesday, October 04, 2006 8:31 AM
To: DeGuzman, Daniel
Cc: sybperl-l@peppler.org
Subject: Re: DBD::Sybase with host process disconnect errors when run
from linux



This error usually happens when the client goes away without properly
closing the connection. 
You may be getting this because of a tcp_keepalive setting that is too
low on the db server side. 

What happens when you connect from the linux host with isql and issue
the same query? 

Michael 




Internet 
Daniel.DeGuzman@mtvstaff.com@peppler.org - 03.10.2006 20:22 
  

Sent by:        owner-sybperl-l@peppler.org 

To:        sybperl-l 

cc:         

Subject:        DBD::Sybase with host process disconnect errors when run
from linux 




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. 



This message and any attachments (the "message") is
intended solely for the addressees and is confidential. 
If you receive this message in error, please delete it and 
immediately notify the sender. Any use not in accord with 
its purpose, any dissemination or disclosure, either whole 
or partial, is prohibited except formal approval. The internet
can not guarantee the integrity of this message. 
BNP PARIBAS (and its subsidiaries) shall (will) not 
therefore be liable for the message if modified. 

                ---------------------------------------------

Ce message et toutes les pieces jointes (ci-apres le 
"message") sont etablis a l'intention exclusive de ses 
destinataires et sont confidentiels. Si vous recevez ce 
message par erreur, merci de le detruire et d'en avertir 
immediatement l'expediteur. Toute utilisation de ce 
message non conforme a sa destination, toute diffusion 
ou toute publication, totale ou partielle, est interdite, sauf 
autorisation expresse. L'internet ne permettant pas 
d'assurer l'integrite de ce message, BNP PARIBAS (et ses
filiales) decline(nt) toute responsabilite au titre de ce 
message, dans l'hypothese ou il aurait ete modifie.