Subject | Re: [firebird-support] Page is of wrong type (expected 5, found 0) |
---|---|
Author | Ann Harrison |
Post date | 2016-01-28T21:52:42Z |
On Thu, Jan 28, 2016 at 4:12 PM, Martin Schwedhelm silo_18@... [firebird-support] <firebird-support@yahoogroups.com> wrote:
As far as I can tell (via gstat) forced write is enabled.Also, regarding virtual machines, at least ESX(i) does not cache guest OS writes(http://www.yellow-bricks.com/2011/04/07/mythbuster s-esxesxi-caching-io/).OK. There are myths about disks that lie about writing stuff, but that's way on the outer edgeof probability, especially since you've got lots of pages of zeros.Maybe a thing that was not clear in my initial post:We don't use a sql command that deletes that many records or drop tables.The missing (zeroed) data should not be zeroed at all.When Firebird releases a page because it went empty or the table was dropped orwhatever, it doesn't zero the page. My somewhat feeble recollection is that pages of zerosare newly allocated and never used, or trompled by rogue processes.Good luck,Ann