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 Peppler Data Migrations, Inc.
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short
or long term contract positions - http://www.peppler.org/resume.html