Christopher Browne wrote:
Geoffrey <[EMAIL PROTECTED]> writes:
I want to make sure I have a good handle on this issue. We currently
have a master/slave configuration. In the event the slave must be
rebooted, what are the proper steps to insure that slony picks up from
where it left off.
What we are currently doing is simply restart the slon daemons for
each database.
That seems apropos.
For the most part this appears to work, but what concerns me is that
I have one table on one database where the number of records on the
master node has not increased in a while and the slave does not
appear to be 'trying to catch up.' That is to say, the slave has
fewer records in that table then the master and the slave table is
not growing.
Well, then "get thee to the slon logs..."
-> Do they indicate, for the subscriber, that errors are being experienced?
Not that I can tell. That is the first placed I looked.
-> Do they indicate that SYNCs are being processed, and data applied?
SYNCs processed, but says nothing to process:
2008-02-18 16:39:27 EST DEBUG2 localListenThread: Received event 1,10345
SYNC
2008-02-18 16:39:32 EST DEBUG2 remoteListenThread_2: queue event 2,7343 SYNC
2008-02-18 16:39:32 EST DEBUG2 remoteWorkerThread_2: Received event
2,7343 SYNC
2008-02-18 16:39:32 EST DEBUG2 remoteWorkerThread_2: SYNC 7343 processing
2008-02-18 16:39:32 EST DEBUG2 remoteWorkerThread_2: no sets need
syncing for this event
-> Is the subscriber in question behind (according to the view
sl_status) by an increasing amount of time?
I'm not sure what I'm looking for here. From the slave:
master=# select * from _master_cluster.sl_status;
st_origin | st_received | st_last_event | st_last_event_ts |
st_last_received | st_last_received_ts |
st_last_received_event_ts | st_lag_num_events | st_lag_time
-----------+-------------+---------------+----------------------------+------------------+----------------------------+----------------------------+-------------------+-------------
2 | 1 | 7377 | 02/18/2008 16:45:11.298502 |
7377 | 02/18/2008 16:45:11.728581 | 02/18/2008 16:45:11.298502 |
0 | @ 4.40 secs
Error messages in the slon logs should give some idea of what is going on.
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
