Mon Oct 16 12:06:54 PDT 2006
- Previous message: [Slony1-general] Urgent: sl_log_1 not getting cleared
- Next message: [Slony1-general] Slon fails to start
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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.
- Previous message: [Slony1-general] Urgent: sl_log_1 not getting cleared
- Next message: [Slony1-general] Slon fails to start
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list