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).
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