Wednesday, 15 October 2014

ERROR: sending message to EXTRACT SUNIL (Timeout waiting for message).

This is one of the issues that I have faced with GoldenGate 11.

One group is constantly giving me this "Timeout waiting for message" error after few minutes of starting the group.

As you see below the Time Since Chkpt is like 18 hours!!!.

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
EXTRACT     RUNNING     SUNIL      00:00:01      18:50:04

So, when you try getting the stats you get timeout warning error:

GGSCI () 9> stats SUNIL, status

Sending STATS request to EXTRACT SUNIL ...

ERROR: sending message to EXTRACT SUNIL (Timeout waiting for message).

Tried to STOP the extract and still the same error:

GGSCI () 10> stop SUNIL

Sending STOP request to EXTRACT SUNIL ...

ERROR: sending message to EXTRACT SUNIL (Timeout waiting for message).

Basically, this group is hung and only way to stop this is to kill (kill SUNIL) and restart. Well, this is not going to be accepted.


GGSCI (phlq1rfftorp001) 8> start extractSUNIL

Sending START request to MANAGER ...
EXTRACT SUNIL starting


GGSCI (phlq1rfftorp001) 9> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
EXTRACT     RUNNING     DP1FT       00:00:00      00:00:03
EXTRACT     STARTING    SUNIL       00:00:00      02:31:49




No comments:

Post a Comment