Re: [firebird-support] Page is of wrong type (expected 5, found 0)

 

On Thu, Jan 28, 2016 at 4:12 PM, Martin Schwedhelm silo_18@yahoo.com [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 edge

of 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 or

whatever, it doesn't zero the page.  My somewhat feeble recollection is that pages of zeros

are newly allocated and never used, or trompled by rogue processes.  

Good luck,

Ann

__._,_.___

---

Posted by: Ann Harrison <aharrison@ibphoenix.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (5)

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___