On 10-12-14 09:01 AM, [email protected] 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 > [email protected] > http://lists.slony.info/mailman/listinfo/slony1-general _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
