I am using Slony version 2.0.1. I am getting an analyze error for 8 tables =
every 10 minutes during the cleanup cycle. An extract from the log is inclu=
ded below. =


2009-04-29 09:42:45 EDT INFO=A0=A0 cleanupThread:=A0=A0=A0 0.011 seconds fo=
r cleanupEvent()
2009-04-29 09:42:45 EDT DEBUG1 cleanupThread: minxid: 100675
2009-04-29 09:42:45 EDT DEBUG1 cleanupThread: number of tables to clean: 9
2009-04-29 09:42:45 EDT DEBUG1 cleanupThread:=A0 analyze "_mas_rep".sl_even=
t;
2009-04-29 09:42:45 EDT ERROR=A0 cleanupThread: " analyze "_mas_rep".sl_eve=
nt;" - 2009-04-29 09:42:45 EDT DEBUG1 cleanupThread:=A0 analyze "_mas_rep".=
sl_confirm;
2009-04-29 09:42:45 EDT ERROR=A0 cleanupThread: " analyze "_mas_rep".sl_con=
firm;" - 2009-04-29 09:42:45 EDT DEBUG1 cleanupThread:=A0 analyze "_mas_rep=
".sl_setsync;
2009-04-29 09:42:45 EDT ERROR=A0 cleanupThread: " analyze "_mas_rep".sl_set=
sync;" - 2009-04-29 09:42:45 EDT DEBUG1 cleanupThread:=A0 analyze "_mas_rep=
".sl_log_1;
2009-04-29 09:42:45 EDT ERROR=A0 cleanupThread: " analyze "_mas_rep".sl_log=
_1;" - 2009-04-29 09:42:45 EDT DEBUG1 cleanupThread:=A0 analyze "_mas_rep".=
sl_log_2;
2009-04-29 09:42:45 EDT ERROR=A0 cleanupThread: " analyze "_mas_rep".sl_log=
_2;" - 2009-04-29 09:42:45 EDT DEBUG1 cleanupThread:=A0 analyze "_mas_rep".=
sl_seqlog;
2009-04-29 09:42:45 EDT ERROR=A0 cleanupThread: " analyze "_mas_rep".sl_seq=
log;" - 2009-04-29 09:42:45 EDT DEBUG1 cleanupThread:=A0 analyze "_mas_rep"=
.sl_archive_counter;
2009-04-29 09:42:45 EDT ERROR=A0 cleanupThread: " analyze "_mas_rep".sl_arc=
hive_counter;" - 2009-04-29 09:42:45 EDT DEBUG1 cleanupThread:=A0 analyze "=
pg_catalog".pg_listener;
2009-04-29 09:42:45 EDT ERROR=A0 cleanupThread: " analyze "pg_catalog".pg_l=
istener;" - 2009-04-29 09:42:45 EDT DEBUG1 cleanupThread:=A0 analyze "pg_ca=
talog".pg_statistic;
2009-04-29 09:42:45 EDT ERROR=A0 cleanupThread: " analyze "pg_catalog".pg_s=
tatistic;" - 2009-04-29 09:42:45 EDT INFO=A0=A0 cleanupThread:=A0=A0=A0 0.0=
07 seconds for vacuuming

Since the process is run as slony and the tables are owned by slony, I am p=
uzzled as to why this would occur. Any input would be greatly appreciated. =


Melvin Davidson =






      =

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20090429/=
975876cc/attachment.htm