On Mon, 2006-10-16 at 11:55 -0700, Junaili Lie wrote: > Problem solved. > although there's no old transaction in pg_stat_activity (no <IDLE> in > transaction), I checked the pg_locks and found the transactionid = > 746264948 (ev_minxid). > So, I terminated the process associated with that transactionid, and a > big chunk of sl_log_1 entries got deleted. > :D > I am not too sure if this is a bug related to slony or our > application. >
Most likely your app. -- Brad Nicholson 416-673-4106 Database Administrator, Afilias Canada Corp. _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
