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: Tim Holt <holt at roguewave dot com>
Subject: RE: out of sync message
Date: Jun 4 1998 8:42PM

Interesting to hear that! 

I really didn't solve the problem of the fork.  In our
case, the time spent to do the update was pretty small,
and so it was not really necessary to do the fork'ed 
off task.  Had it been necessary, I had contemplated 
actually having a second perl program that did the 
task that was to be forked.  Then the main prog would just
run the other prog when necessary.

-----Original Message-----
> You know, I've fought that same error pair...
>    Sybase error: Datastream processing out of sync.
>    Sybase error: DBPROCESS is dead or not enabled.
> as well.  I never figured out exactly what was causing the
> problem, but it was centered in some code that was being
> fork'ed off to do an update in the background.  When I
> finally tossed the fork method, the errors went away.  
> Don't ask me what fixed what, but the errors went away.
> I've got my Sybperl error traps for our site set to email
> me w/all the error info, perl call dumps, etc. and I was
> getting tired of coming in to find 45 SQL/perl warnings 
> waiting for me in the mailbox!
> Tim Holt, Rogue Wave Software
Thank you for your insights regarding this problem. As it turns out, I
also doing forks in the script. I am wondering what other alternatives
used if any. I am also interested to know if you ever implemented a
like cancel request for an ongoing Sybperl query or a batch of commands.

Thank You
Simon Yaminian