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: Michael Peppler <mpeppler at peppler dot org>
Subject: Re: perl scripted killed
Date: Jul 27 2004 5:45AM

On Mon, 2004-07-26 at 22:56, David VanEmden wrote:
> I have a script which makes use of the DBD interface.  I am
> intermittantly getting a situation where the script stops and all I see
> is the messaged killed.  I have set the dbtrace to level 2 and the last
> things in the trace file are...
> 
>   syb_st_execute() -> ct_command() OK
>     syb_st_execute() -> ct_send() OK
> 
> The command to be executed is a stored procedure.  It never returns. 
> Any thoughts as to what might be the problem?

The most likely problem is that the stored proc dies on the server.
Check the server's error log.

Also, run the script with trace level 3, and then post the entire
section of the trace file that relates to this stored proc execution.

Michael
-- 
Michael Peppler                              Data Migrations, Inc.
mpeppler@peppler.org                       http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short
or long term contract positions - http://www.peppler.org/resume.html