Chapter 11: Troubleshooting
Troubleshooting Replication
246
Replication is not working.
QueryChangeLog.bat
shows
entries are queued-up in the
ChangeLog and the following
error occurs in either
SccAdSrvrlog.txt
or SafeWord
EV:
(ReplLogProcessor ReplJanitor
ERROR 2007/10/18
18:29:50.765 (EST)) Replication
thread 'ReplNext' has been
inactive since Thu Oct 18
18:14:29 EST 2007. Please
check database status on the
peer and network connectivity.
Replication seems to be working,
however, the
SccAdSrvrlog.txt
and SafeWord Event Viewer log
messages similar to the following
sample:
The SafeWord
Server has
lost
connection to
the replication
peer.
Review the error message
to determine which server
generated the error. In the
error to the left, the
SafeWord server has lost
its thread connection to the
ReplNext peer.
Port 5010 isn’t
LISTENING
Go to the ReplNext peer
and verify:
1
The SafeWord
Database service is
started.
2
Port 5010 is in the
LISTENING state using
netstat –na |
more
command.
Network
connectivity
issues or a
firewall is
blocking
connections
over port
5010.
•
Open a command
window (on ReplNext)
and perform a telnet
test to localhost over
port 5010 (
telnet
localhost 5010
) to
verify port 5010 is
accepting connections.
•
If local connectivity
works but the remote
MySQL server cannot
connect, investigate
the possibility that
some 3
rd
party device
is blocking the
connection or that
network connectivity
intermittently fails.
More...
Symptom
Poss. cause
Resolution