Subject | Re: [firebird-support] RE: I dont know why sweep is not doing clean |
---|---|
Author | Ann Harrison |
Post date | 2013-12-06T22:25:47Z |
On Fri, Dec 6, 2013 at 2:44 PM, <sopranoeli@...> wrote:
Hi Vlad, gstat -h result:
Oldest transaction 371932
Oldest active 1906983
Oldest snapshot 1906983
Next transaction 2696106
Only record versions created before transaction three hundredseventy-one thousand nine hundred and thirty two can be removed.All versions created by the next two million three hundred twentyfour thousand one hundred and seventy four transactions must bekept so that your transaction 1906983 can be guaranteed a stablesnapshot of the database.Find that transaction and kill it!Good luck,Ann