Hello,
one node stacked in replication, output from view sl_status (attached)
shows that it is outdated for 8 days, and it is not being replicated
(number of st_lag_num_events is increasing, and time (st_lag_time) is
increasing too).
We tried to increase syncing interval (slon -s), also we added -g 100 and
-o 0 but all this did not helped at all..
Servers are running well, no big load, network speed is the same as for
all other nodes..
Slon output:
2007-02-02 01:58:11 GMT DEBUG2 syncThread: new sl_action_seq 1 - SYNC 1036521
2007-02-02 01:58:12 GMT DEBUG2 localListenThread: Received event 4,1036521
SYNC
2007-02-02 01:58:20 GMT DEBUG2 syncThread: new sl_action_seq 1 - SYNC 1036522
2007-02-02 01:58:22 GMT DEBUG2 localListenThread: Received event 4,1036522
SYNC
2007-02-02 01:58:30 GMT DEBUG2 syncThread: new sl_action_seq 1 - SYNC 1036523
2007-02-02 01:58:32 GMT DEBUG2 localListenThread: Received event 4,1036523
SYNC
2007-02-02 01:58:40 GMT DEBUG2 syncThread: new sl_action_seq 1 - SYNC 1036524
2007-02-02 01:58:42 GMT DEBUG2 localListenThread: Received event 4,1036524
SYNC
2007-02-02 01:58:43 GMT DEBUG1 cleanupThread: 0.025 seconds for
cleanupEvent()
2007-02-02 01:58:43 GMT DEBUG1 cleanupThread: 0.018 seconds for delete
logs
2007-02-02 01:58:50 GMT DEBUG2 syncThread: new sl_action_seq 1 - SYNC 1036525
2007-02-02 01:58:52 GMT DEBUG2 localListenThread: Received event 4,1036525
SYNC
2007-02-02 01:59:00 GMT DEBUG2 syncThread: new sl_action_seq 1 - SYNC 1036526
2007-02-02 01:59:02 GMT DEBUG2 localListenThread: Received event 4,1036526
SYNC
2007-02-02 01:59:10 GMT DEBUG2 syncThread: new sl_action_seq 1 - SYNC 1036527
2007-02-02 01:59:12 GMT DEBUG2 localListenThread: Received event 4,1036527
SYNC
2007-02-02 01:59:20 GMT DEBUG2 syncThread: new sl_action_seq 1 - SYNC 1036528
2007-02-02 01:59:22 GMT DEBUG2 localListenThread: Received event 4,1036528
SYNC
2007-02-02 01:59:30 GMT DEBUG2 syncThread: new sl_action_seq 1 - SYNC 1036529
2007-02-02 01:59:32 GMT DEBUG2 localListenThread: Received event 4,1036529
SYNC
and nothing is changing..
Table sl_event has 350 000 records, sl_log_1 has 3800 records, sl_log_2
has 900 and sl_seqlog has 70000 recors on master side..
Where can be the problem? What we can do?
thx
Lukas
--
This message has been scanned for viruses and
dangerous content, and is believed to be clean.
select * from _replikiukas.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
-----------+-------------+---------------+----------------------------+------------------+----------------------------+----------------------------+-------------------+------------------------
1 | 2 | 1209353 | 2007-02-02 02:02:10.428671 |
1209353 | 2007-02-02 01:57:19.051646 | 2007-02-02 02:02:10.428671 |
0 | 00:00:03.242405
1 | 3 | 1209353 | 2007-02-02 02:02:10.428671 |
1209352 | 2007-02-02 01:58:31.262058 | 2007-02-02 02:02:00.438737 |
1 | 00:00:13.232339
1 | 6 | 1209353 | 2007-02-02 02:02:10.428671 |
1209351 | 2007-02-02 02:06:08.94034 | 2007-02-02 02:01:50.418494 |
2 | 00:00:23.252582
1 | 4 | 1209353 | 2007-02-02 02:02:10.428671 |
1138872 | 2007-01-24 22:36:07.158301 | 2007-01-24 22:31:45.674518 |
70481 | 8 days 03:30:27.996558
1 | 5 | 1209353 | 2007-02-02 02:02:10.428671 |
1209352 | 2007-02-02 01:57:26.151722 | 2007-02-02 02:02:00.438737 |
1 | 00:00:13.232339
(5 rows)_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
