DBD::Sybase with host process disconnect errors when run from linux
"DeGuzman, Daniel" <[email protected]> Tue, 3 Oct 2006 14:22:31 -0400
| Newsgroups | gmane.comp.lang.perl.modules.dbi.sybase |
|---|---|
| Message-ID | <114EAEA8C0B03A40A5EB44E1B9AC9318B6F7DB@DIRECTEFFECT.mtvn.ad.viacom.com> |
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.