Sl_log_1 and sl_log_2 not getting truncated.
От | Nimesh Satam |
---|---|
Тема | Sl_log_1 and sl_log_2 not getting truncated. |
Дата | |
Msg-id | 965aa3ed0901070448i1f4e71as2e7cac9505c8ccfb@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Sl_log_1 and sl_log_2 not getting truncated.
|
Список | pgsql-performance |
Hi,
We have recently installed slony and tsrted replication on one of our test machines. When we start inserting data in to the replicated database, the replication is taking properly. Over a period of time the lag increases between the two database.
Looking further we found that, sl_log_1 and sl_log2 are not getting truncated. Following are the versions which we are using. Slony has been installed for the first time
Postgres version: 8.3.5
slony version: 2.0.0
Can someone let me know what we should be looking at?
Following is the error which we get:
NOTICE: Slony-I: cleanup stale sl_nodelock entry for pid=17961
CONTEXT: SQL statement "SELECT "_inventorycluster".cleanupNodelock()"
PL/pgSQL function "cleanupevent" line 83 at PERFORM
NOTICE: Slony-I: Logswitch to sl_log_1 initiated
CONTEXT: SQL statement "SELECT "_inventorycluster".logswitch_start()"
PL/pgSQL function "cleanupevent" line 101 at PERFORM
2009-01-06 22:10:43 PST INFO cleanupThread: 0.149 seconds for cleanupEvent()
2009-01-06 22:10:43 PST ERROR cleanupThread: "vacuum analyze "_inventorycluster".sl_event;" - 2009-01-06 22:10:43 PST ERROR cleanupThread: "vacuum analyze "_inventorycluster".sl_confirm;" - 2009-01-06 22:10:43 PST ERROR cleanupThread: "vacuum analyze "_inventorycluster".sl_setsync;" - 2009-01-06 22:10:43 PST ERROR cleanupThread: "vacuum analyze "_inventorycluster".sl_log_1;" - 2009-01-06 22:10:43 PST ERROR cleanupThread: "vacuum analyze "_inventorycluster".sl_log_2;" - 2009-01-06 22:10:43 PST ERROR cleanupThread: "vacuum analyze "_inventorycluster".sl_seqlog;" - 2009-01-06 22:10:43 PST ERROR cleanupThread: "vacuum analyze "_inventorycluster".sl_archive_counter;" - 2009-01-06 22:10:43 PST ERROR cleanupThread: "vacuum analyze "pg_catalog".pg_listener;" - 2009-01-06 22:10:43 PST ERROR cleanupThread: "vacuum analyze "pg_catalog".pg_statistic;" - 2009-01-06 22:10:43 PST INFO cleanupThread: 0.280 seconds for vacuuming
NOTICE: Slony-I: log switch to sl_log_1 still in progress - sl_log_2 not truncated
CONTEXT: PL/pgSQL function "cleanupevent" line 99 at assignment
2009-01-06 22:21:31 PST INFO cleanupThread: 0.127 seconds for cleanupEvent()
Regards,
Nimesh.
We have recently installed slony and tsrted replication on one of our test machines. When we start inserting data in to the replicated database, the replication is taking properly. Over a period of time the lag increases between the two database.
Looking further we found that, sl_log_1 and sl_log2 are not getting truncated. Following are the versions which we are using. Slony has been installed for the first time
Postgres version: 8.3.5
slony version: 2.0.0
Can someone let me know what we should be looking at?
Following is the error which we get:
NOTICE: Slony-I: cleanup stale sl_nodelock entry for pid=17961
CONTEXT: SQL statement "SELECT "_inventorycluster".cleanupNodelock()"
PL/pgSQL function "cleanupevent" line 83 at PERFORM
NOTICE: Slony-I: Logswitch to sl_log_1 initiated
CONTEXT: SQL statement "SELECT "_inventorycluster".logswitch_start()"
PL/pgSQL function "cleanupevent" line 101 at PERFORM
2009-01-06 22:10:43 PST INFO cleanupThread: 0.149 seconds for cleanupEvent()
2009-01-06 22:10:43 PST ERROR cleanupThread: "vacuum analyze "_inventorycluster".sl_event;" - 2009-01-06 22:10:43 PST ERROR cleanupThread: "vacuum analyze "_inventorycluster".sl_confirm;" - 2009-01-06 22:10:43 PST ERROR cleanupThread: "vacuum analyze "_inventorycluster".sl_setsync;" - 2009-01-06 22:10:43 PST ERROR cleanupThread: "vacuum analyze "_inventorycluster".sl_log_1;" - 2009-01-06 22:10:43 PST ERROR cleanupThread: "vacuum analyze "_inventorycluster".sl_log_2;" - 2009-01-06 22:10:43 PST ERROR cleanupThread: "vacuum analyze "_inventorycluster".sl_seqlog;" - 2009-01-06 22:10:43 PST ERROR cleanupThread: "vacuum analyze "_inventorycluster".sl_archive_counter;" - 2009-01-06 22:10:43 PST ERROR cleanupThread: "vacuum analyze "pg_catalog".pg_listener;" - 2009-01-06 22:10:43 PST ERROR cleanupThread: "vacuum analyze "pg_catalog".pg_statistic;" - 2009-01-06 22:10:43 PST INFO cleanupThread: 0.280 seconds for vacuuming
NOTICE: Slony-I: log switch to sl_log_1 still in progress - sl_log_2 not truncated
CONTEXT: PL/pgSQL function "cleanupevent" line 99 at assignment
2009-01-06 22:21:31 PST INFO cleanupThread: 0.127 seconds for cleanupEvent()
Regards,
Nimesh.
В списке pgsql-performance по дате отправления: