francescoboccacci at libero.it francescoboccacci at libero.it
Tue Dec 14 06:01:54 PST 2010
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:





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 


More information about the Slony1-general mailing list