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: "Ahmed, Riyaz" <Riyaz dot Ahmed at gs dot com>
Subject: Handling DBProcess dead message
Date: Apr 30 2004 1:24AM

Hi Mike,

I have a script that went into an infinite loop after it hit upon certain
Sybase server condition. This is the log snippet.

 367606 Server  : MYSERVER
 367607 Procedure       : my_procedure
 367608 Line            : 245
 367609 Text            : Cannot drop the table '#my_table' because it is
currently in use.
 367610 
 367611 Debug:  Exiting Message Handler..
 367612 Debug:  In Message Handler...
 367613 Debug:  Sybase error # = 21             isDeadLocked = 1
 367614 INFO:   Message ID      : 21
 367615 Severity        : 20
 367616 State   : 1
 367617 Server  : NYCTREPP08
 367618 Procedure       : my_procedure
 367619 Line            : 245
 367620 Text            : WARNING - Fatal Error 216 occurred at Apr 27 2004
12:55PM.  Please note the error and time, and contact a user with System
Administrator (SA) authorization.
 367621 
 367622 Debug:  Exiting Message Handler..
 367623 Debug:  In Message Handler...
 367624 Debug:  Sybase error # = 21             isDeadLocked = 1
 367625 INFO:   Message ID      : 21
 367626 Severity        : 20
 367627 State   : 1
 367628 Server  : MYSERVER
 367629 Procedure       : my_procedure
 367630 Line            : 245
 367631 Text            : WARNING - Fatal Error 216 occurred at Apr 27 2004
12:55PM.  Please note the error and time, and contact a user with System
Administrator (SA) authorization.
 367632 
 367633 Debug:  Exiting Message Handler..
 367634 Debug:  In Message Handler...
 367635 Debug:  Sybase error # = 5702           isDeadLocked = 1
 367636 Debug:  Exiting Message Handler..
 367637 Debug:  deadLockReTryCount              =       0
 367638 Debug:  dbsqlexec return status =       1
 367639 Debug:  In Error Handler..
 367640 INFO:   Sybase error: DBPROCESS is dead or not enabled.
 367641 Debug:  Exiting Error Handler..
 367642 Debug:  In Error Handler..
 367643 INFO:   Sybase error: DBPROCESS is dead or not enabled.
 367644 Debug:  Exiting Error Handler..
 367645 Debug:  In Error Handler..
 367646 INFO:   Sybase error: DBPROCESS is dead or not enabled.
 367647 Debug:  Exiting Error Handler..
 367648 Debug:  In Error Handler..
 367649 INFO:   Sybase error: DBPROCESS is dead or not enabled.

Can you please advise as to what can be done to better handle this scenario?

Regards,
Riyaz