On 10-12-14 09:01 AM, francescoboccacci at libero.it wrote:
> Hi to all.
> I have some doubts about how slony-I replication process works.
> I Have one master and 4 slaves that share some tables.
> I create a cluster script and run it. After i run slon daemon in all nodes.
> At
> the end i run subscribe script. After this operation my server (linux) show
> messages but i don't undestand if this is normal or what are. After 2 hours
> it
> still show me message like these:
>

All of the messages below are normal messages from slony during normal 
operations of slony.  I don't see any indication of a problem.

If you connect to your slaves, do you see your data replicated?

If your still having a problem look at what the 
_sql_cluster_1_2_3_4_9.sl_status table contains.

Also it is good practice to include which version of slony your using 
when posting messages to the list.



>
>
>
>
> NOTICE:  Slony-I: Logswitch to sl_log_2 initiated
> CONTEXT:  SQL statement "SELECT  "_sql_cluster_1_2_3_4_9".logswitch_start()"
> PL/pgSQL function "cleanupevent" line 101 at PERFORM
> NOTICE:  Slony-I: Logswitch to sl_log_2 initiated
> CONTEXT:  SQL statement "SELECT  "_sql_cluster_1_2_3_4_9".logswitch_start()"
> PL/pgSQL function "cleanupevent" line 101 at PERFORM
> NOTICE:  Slony-I: Logswitch to sl_log_2 initiated
> CONTEXT:  SQL statement "SELECT  "_sql_cluster_1_2_3_4_9".logswitch_start()"
> PL/pgSQL function "cleanupevent" line 101 at PERFORM
> NOTICE:  Slony-I: Logswitch to sl_log_2 initiated
> CONTEXT:  SQL statement "SELECT  "_sql_cluster_1_2_3_4_9".logswitch_start()"
> PL/pgSQL function "cleanupevent" line 101 at PERFORM
> NOTICE:  Slony-I: Logswitch to sl_log_2 initiated
> CONTEXT:  SQL statement "SELECT  "_sql_cluster_1_2_3_4_9".logswitch_start()"
> PL/pgSQL function "cleanupevent" line 101 at PERFORM
> NOTICE:  Slony-I: log switch to sl_log_2 complete - truncate sl_log_1
> CONTEXT:  PL/pgSQL function "cleanupevent" line 99 at assignment
> NOTICE:  Slony-I: log switch to sl_log_2 complete - truncate sl_log_1
> CONTEXT:  PL/pgSQL function "cleanupevent" line 99 at assignment
> NOTICE:  Slony-I: log switch to sl_log_2 complete - truncate sl_log_1
> CONTEXT:  PL/pgSQL function "cleanupevent" line 99 at assignment
> NOTICE:  Slony-I: log switch to sl_log_2 complete - truncate sl_log_1
> CONTEXT:  PL/pgSQL function "cleanupevent" line 99 at assignment
> NOTICE:  Slony-I: log switch to sl_log_2 complete - truncate sl_log_1
> CONTEXT:  PL/pgSQL function "cleanupevent" line 99 at assignment
> NOTICE:  Slony-I: Logswitch to sl_log_1 initiated
> CONTEXT:  SQL statement "SELECT  "_sql_cluster_1_2_3_4_9".logswitch_start()"
> PL/pgSQL function "cleanupevent" line 101 at PERFORM
> NOTICE:  Slony-I: Logswitch to sl_log_1 initiated
> CONTEXT:  SQL statement "SELECT  "_sql_cluster_1_2_3_4_9".logswitch_start()"
> PL/pgSQL function "cleanupevent" line 101 at PERFORM
> NOTICE:  Slony-I: Logswitch to sl_log_1 initiated
> CONTEXT:  SQL statement "SELECT  "_sql_cluster_1_2_3_4_9".logswitch_start()"
> PL/pgSQL function "cleanupevent" line 101 at PERFORM
> NOTICE:  Slony-I: Logswitch to sl_log_1 initiated
> CONTEXT:  SQL statement "SELECT  "_sql_cluster_1_2_3_4_9".logswitch_start()"
> PL/pgSQL function "cleanupevent" line 101 at PERFORM
> NOTICE:  Slony-I: Logswitch to sl_log_1 initiated
> CONTEXT:  SQL statement "SELECT  "_sql_cluster_1_2_3_4_9".logswitch_start()"
> PL/pgSQL function "cleanupevent" line 101 at PERFORM
> NOTICE:  Slony-I: log switch to sl_log_1 complete - truncate sl_log_2
> CONTEXT:  PL/pgSQL function "cleanupevent" line 99 at assignment
> NOTICE:  Slony-I: log switch to sl_log_1 complete - truncate sl_log_2
> CONTEXT:  PL/pgSQL function "cleanupevent" line 99 at assignment
> NOTICE:  Slony-I: log switch to sl_log_1 complete - truncate sl_log_2
> CONTEXT:  PL/pgSQL function "cleanupevent" line 99 at assignment
> NOTICE:  Slony-I: log switch to sl_log_1 complete - truncate sl_log_2
> CONTEXT:  PL/pgSQL function "cleanupevent" line 99 at assignment
> NOTICE:  Slony-I: log switch to sl_log_1 complete - truncate sl_log_2
> CONTEXT:  PL/pgSQL function "cleanupevent" line 99 at assignment
>
> ..
> and so on.
> What happen? I need to restart some process or wait the end of the process?
>
> Please help me.
>
> Thanks to all
>
> Francesco
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general