<p dir="ltr">Hi,</p>
<p dir="ltr">Le 23 févr. 2015 16:51, "Clement Thomas" <<a href="mailto:clement1289@gmail.com">clement1289@gmail.com</a>> a écrit :<br>
><br>
> Hi All,<br>
> we face a weird problem in our 3 node slony setup.<br>
><br>
> * node1 (db1.domain.tld ) is the master provider and node2<br>
> (db2.domain.tld ), node3 (db3.domain.tld ) are subscribers.<br>
> currently nodes have 5 replication sets and the replication is working<br>
> fine.<br>
> * the problem is sl_log_1 and sl_log_2 tables in node1 gets cleaned up<br>
> properly, but the tables in the node2 and node3 doesn't. On node1 the<br>
> total number of rows in sl_log_1 table is 24845 and in sl_log_2 it is<br>
> 0. whereas<br>
><br>
> node2:<br>
><br>
> relation | size<br>
> ----------------------------------------------------------+---------<br>
> _mhb_replication.sl_log_2 | 130 GB<br>
> _mhb_replication.sl_log_2_idx1 | 47 GB<br>
> _mhb_replication.PartInd_mhb_replication_sl_log_2-node-1 | 30 GB<br>
><br>
> node3:<br>
> relation | size<br>
> ----------------------------------------------------------+--------<br>
> _mhb_replication.sl_log_2 | 133 GB<br>
> _mhb_replication.sl_log_2_idx1 | 47 GB<br>
> _mhb_replication.PartInd_mhb_replication_sl_log_2-node-1 | 30 GB<br>
> _mhb_replication.sl_log_1 | 352 MB<br>
><br>
><br>
> in node2 and node3 could see the following lines frequently.<br>
><br>
> slon[20695]: [4031-1] FATAL cleanupThread: "delete from<br>
> "_mhb_replication".sl_log_1 where log_origin = '1' and log_xid <<br>
> '2130551154'; delete from<br>
> slon[20695]: [4031-2] "_mhb_replication".sl_log_2 where log_origin =<br>
> '1' and log_xid < '2130551154'; delete from<br>
> "_mhb_replication".sl_seqlog where<br>
> slon[20695]: [4031-3] seql_origin = '1' and seql_ev_seqno <<br>
> '51449379'; select "_mhb_replication".logswitch_finish(); " - ERROR:<br>
> canceling statement<br>
> slon[20695]: [4031-4] due to statement timeout<br>
> slon[20695]: [4032-1] DEBUG2 slon_retry() from pid=20695<br>
><br>
> please find the slony_tools.conf here<br>
> <a href="https://gist.github.com/clement1289/d928acb771ca01a89281">https://gist.github.com/clement1289/d928acb771ca01a89281</a> and sl_status<br>
> /sl_listen output here<br>
> <a href="https://gist.github.com/clement1289/88df40f77c03c691eee5">https://gist.github.com/clement1289/88df40f77c03c691eee5</a> . Hoping for<br>
> some help.<br>
></p>
<p dir="ltr">You should change PostgreSQL configuration. Statement_timeout is too low. Unset it or set it higher.</p>