Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Srinivasa Rao Duggineni <dsrao at wilco-int dot com>
Subject: Handling log full issues with DB-Library
Date: Sep 4 2002 3:58AM


	I have a situation where I am executing a query through DB-Lib
command in a Sybase database. If this query fills up the log to the
threshold limit, the data server suspends the execution of the query till
the space is made available in the log. But I want to catch that warning in
my script and want to cancel the connection to the database. I am actually
using the message handler in my script. So, whenever this happens, the
control goes into the message handler. I am trying to kill the connection
using dbclose/dbcancel, but It doesn't seem to work.

	Basically I want the control back to the script when this happens. 
	I am getting the "Segmentation fault(core dumped)" error when I
tried to close and reopen a connection with the same db handler inside the
message handler.

	Did anyone come across situation like this??
	Please pass on any idea that can handle this situation.


This message is confidential and may also be legally privileged. If you are not the intended recipient, please notify immediately. You should not copy it or use it for any purpose, nor disclose its contents to any other person. The views and opinions expressed in this e-mail message are the author's own and may not reflect the views and opinions of Wilco.