Database gets partially corrupted in the "no-reserve" mode
----------------------------------------------------------

                 Key: CORE-5329
                 URL: http://tracker.firebirdsql.org/browse/CORE-5329
             Project: Firebird Core
          Issue Type: Bug
          Components: Engine
    Affects Versions: 3.0.0
            Reporter: Dmitry Yemanov


If a "no-reserve" (aka "use full space") option was enabled for a v2.5 
database, then the issue becomes visible right after restore on v3.0, just do 
an immediate validation and see:

Summary of validation errors
        Number of database page errors  : 90167

Then check firebird.log and see:

solaris Sat Aug 13 18:01:28 2016
        Database: /work/data/abc.fdb
        Error: Page 1017 wrong type (expected SCN inventory encountered 
purposely undefined)

solaris Sat Aug 13 18:01:28 2016
        Database: /work/data/abc.fdb
        Error: SCN's page 1017 {sequence 1} inconsistent

solaris Sat Aug 13 18:01:28 2016
        Database: /work/data/abc.fdb
        Error: Page 2034 wrong type (expected SCN inventory encountered 
purposely undefined)

solaris Sat Aug 13 18:01:28 2016
        Database: /work/data/abc.fdb
        Error: SCN's page 2034 {sequence 2} inconsistent

and so on. Only SCN pages are corrupted, they are all unexpectedly zeroed.

It means that only incremental restore is affected by this issue, basically the 
database operates OK. A short-term workaround is: gfix -use reserve + 
backup/restore.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are 
consuming the most bandwidth. Provides multi-vendor support for NetFlow, 
J-Flow, sFlow and other flows. Make informed decisions using capacity 
planning reports. http://sdm.link/zohodev2dev
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to