[HACKERS] How to detect invisible rows caused by the relfrozenxid bug?

2013-12-05 Thread Omar Kilani
Hi, How would one go about detecting whether they've lost rows due to the relfrozenxid? Unfortunately running 'SELECT txid_current() 2^31' on our DB returns false, and I'm a little bit worried, since we've been seeing some WeirdStuff(tm) lately. We're only 200M txids or so past 2^31. Thanks!

Re: [HACKERS] How to detect invisible rows caused by the relfrozenxid bug?

2013-12-05 Thread Robert Treat
On Thu, Dec 5, 2013 at 4:14 PM, Omar Kilani omar.kil...@gmail.com wrote: Hi, How would one go about detecting whether they've lost rows due to the relfrozenxid? Unfortunately running 'SELECT txid_current() 2^31' on our DB returns false, and I'm a little bit worried, since we've been seeing

Re: [HACKERS] How to detect invisible rows caused by the relfrozenxid bug?

2013-12-05 Thread Omar Kilani
Hi Robert, Sounds good. Is it safe to upgrade to 9.2.6 (we're on 9.2.5) in the mean time, or should we just leave things untouched? We (unknowingly) got hit by the slave replication bug 2 months ago, too. That was fun. :) Omar On Thu, Dec 5, 2013 at 2:48 PM, Robert Treat r...@xzilla.net wrote: