Hi,
I had a problem with Slony and I was wondering how I can solve it.
Please let me know your point of view.
I have a master database in one server and a slave database on a different
server.
Unfortunately I found that the replica is not working. I checked the logs and
I found the following:
Master log:
2011-11-30 15:01:20 UCTFATAL cleanupThread: "select "_sql_cluster_grade1".
cleanupEvent('10 minutes'::interval, 'false'::boolean); " - FATAL: terminating
connection due to administrator command
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
>From this date the slave log is the following:
Slave log:
2011-11-30 15:01:19 UTCINFO remoteWorkerThread_1: syncing set 1 with 6 table
(s) from provider 1
2011-11-30 15:01:19 UTCINFO remoteWorkerThread_1: SYNC 5000053227 done in
0.004 seconds
2011-11-30 15:01:20 UTCERROR remoteListenThread_1: "select ev_origin,
ev_seqno, ev_timestamp, ev_snapshot, "pg_catalog".
txid_snapshot_xmin(ev_snapshot), "pg_catalog".txid_snapshot_xmax
(ev_snapshot), ev_type, ev_data1, ev_data2, ev_data3,
ev_data4, ev_data5, ev_data6, ev_data7, ev_data8 from
"_sql_cluster_grade1".sl_event e where (e.ev_origin = '1' and e.ev_seqno >
'5000053227') order by e.ev_origin, e.ev_seqno limit 40" - FATAL: terminating
connection due to administrator command
2011-11-30 15:01:20 UTCERROR remoteListenThread_1: "select con_origin,
con_received, max(con_seqno) as con_seqno, max(con_timestamp) as
con_timestamp from "_sql_cluster_grade1".sl_confirm where con_received <> 2
group by con_origin, con_received" 2011-11-30 15:01:22 UTCERROR
remoteListenThread_1: "select ev_origin, ev_seqno, ev_timestamp,
ev_snapshot, "pg_catalog".txid_snapshot_xmin(ev_snapshot),
"pg_catalog".txid_snapshot_xmax(ev_snapshot), ev_type, ev_data1,
ev_data2, ev_data3, ev_data4, ev_data5, ev_data6,
ev_data7, ev_data8 from "_sql_cluster_grade1".sl_event e where (e.ev_origin =
'1' and e.ev_seqno > '5000053227') order by e.ev_origin, e.ev_seqno limit 40" -
no connection to the server
2011-11-30 15:01:22 UTCERROR remoteListenThread_1: "select con_origin,
con_received, max(con_seqno) as con_seqno, max(con_timestamp) as
con_timestamp from "_sql_cluster_grade1".sl_confirm where con_received <> 2
group by con_origin, con_received" 2011-11-30 15:01:24 UTCERROR
remoteListenThread_1: "select ev_origin, ev_seqno, ev_timestamp,
ev_snapshot, "pg_catalog".txid_snapshot_xmin(ev_snapshot),
"pg_catalog".txid_snapshot_xmax(ev_snapshot), ev_type, ev_data1,
ev_data2, ev_data3, ev_data4, ev_data5, ev_data6,
ev_data7, ev_data8 from "_sql_cluster_grade1".sl_event e where (e.ev_origin =
'1' and e.ev_seqno > '5000053227') order by e.ev_origin, e.ev_seqno limit 40" -
no connection to the server
Please let me know how I can sync again the server without loose data and
restart the replica from the beginning.
Thank you,
Francesco Boccacci
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
