Issue Details (XML | Word | Printable)

Key: CORE-1610
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Sergei Rubanik
Votes: 1
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Full shutdown causes database corruption if it happens when SuperServer is running a query modifying data

Created: 22/Nov/07 04:56 AM   Updated: 18/Nov/08 01:17 PM
Component/s: Engine, GFIX
Affects Version/s: 2.0.3
Fix Version/s: 2.1 RC1, 2.0.4

Time Tracking:
Issue & Sub-Tasks
Issue Only
Not Specified

File Attachments: 1. Text File CORE-1610_create_db.sql (2 kB)
2. Text File CORE-1610_test_db.sql (1 kB)

Environment:
OS: Windows Server 2003 Standard Edition SP 2, Windows XP Professional SP2
Server Version: WI-V2.0.3.12981 Firebird 2.0
Server Implementation: Firebird/x86/Windows NT
SuperServer mode.
Client Library Version: 2.0.3.12981
ODS Version: 11.0

Sub-Tasks  All   Open   

 Description  « Hide
How to reproduce:

1. Edit database file name in both scripts (we use the same scripts as in CORE-1299).

2. Create test database by CORE-1610_create_db.sql.

3. Run CORE-1610_test_db.sql and shut down the database while the script is running with
    
   gfix -shut full -force 0

   Firebird.log contains:

-- Log Start --
SERGEI (Server) Thu Nov 22 11:23:47 2007
Database: C:\PROGRAM FILES\HERBST SOFTWARE\HERBST INSIGHT 2 SERVER\BUG5.FDB.ACC
database C:\PROGRAM FILES\HERBST SOFTWARE\HERBST INSIGHT 2 SERVER\BUG5.FDB.ACC shutdown
internal gds software consistency check (error during savepoint backout (290), file: exe.cpp line: 3731)


SERGEI (Server) Thu Nov 22 11:23:48 2007
Database: C:\PROGRAM FILES\HERBST SOFTWARE\HERBST INSIGHT 2 SERVER\BUG5.FDB.ACC
database C:\PROGRAM FILES\HERBST SOFTWARE\HERBST INSIGHT 2 SERVER\BUG5.FDB.ACC shutdown

-- Log End --

4. If no errors happened on step 3, restart the database with
    
   gfix -online
   
   and repeat step 3.

5. Restart the database with

   gfix -online

6. Validate the database with

   gfix -f -v

   It reports:

----------------- Start log on 22/11/2007 11:25:10 ------------------
Exception
Company name: BUG5.FDB
Exit Code = 0. Summary of validation errors
Number of index page errors : 8
Number of database page errors : 1

------------------ End log on 22/11/2007 11:25:10 -------------------

Firebird.log contains:

-- Log Start --
SERGEI (Server) Thu Nov 22 11:25:10 2007
Database: C:\PROGRAM FILES\HERBST SOFTWARE\HERBST INSIGHT 2 SERVER\BUG5.FDB.ACC
Index 1 is corrupt on page 198 level 1. File: \fb2\dev\fb2R2_0_3\firebird2\src\jrd\validation.cpp, line: 1646
in table T1 (128)



SERGEI (Server) Thu Nov 22 11:25:10 2007
Database: C:\PROGRAM FILES\HERBST SOFTWARE\HERBST INSIGHT 2 SERVER\BUG5.FDB.ACC
Index 1 is corrupt on page 198 level 1. File: \fb2\dev\fb2R2_0_3\firebird2\src\jrd\validation.cpp, line: 1646
in table T1 (128)



SERGEI (Server) Thu Nov 22 11:25:10 2007
Database: C:\PROGRAM FILES\HERBST SOFTWARE\HERBST INSIGHT 2 SERVER\BUG5.FDB.ACC
Index 1 is corrupt on page 198 level 1. File: \fb2\dev\fb2R2_0_3\firebird2\src\jrd\validation.cpp, line: 1646
in table T1 (128)



SERGEI (Server) Thu Nov 22 11:25:10 2007
Database: C:\PROGRAM FILES\HERBST SOFTWARE\HERBST INSIGHT 2 SERVER\BUG5.FDB.ACC
Index 1 is corrupt on page 198 level 1. File: \fb2\dev\fb2R2_0_3\firebird2\src\jrd\validation.cpp, line: 1646
in table T1 (128)



SERGEI (Server) Thu Nov 22 11:25:10 2007
Database: C:\PROGRAM FILES\HERBST SOFTWARE\HERBST INSIGHT 2 SERVER\BUG5.FDB.ACC
Index 1 is corrupt on page 198 level 1. File: \fb2\dev\fb2R2_0_3\firebird2\src\jrd\validation.cpp, line: 1646
in table T1 (128)



SERGEI (Server) Thu Nov 22 11:25:10 2007
Database: C:\PROGRAM FILES\HERBST SOFTWARE\HERBST INSIGHT 2 SERVER\BUG5.FDB.ACC
Index 1 is corrupt on page 198 level 1. File: \fb2\dev\fb2R2_0_3\firebird2\src\jrd\validation.cpp, line: 1646
in table T1 (128)



SERGEI (Server) Thu Nov 22 11:25:10 2007
Database: C:\PROGRAM FILES\HERBST SOFTWARE\HERBST INSIGHT 2 SERVER\BUG5.FDB.ACC
Index 1 is corrupt (missing entries) in table T1 (128)



SERGEI (Server) Thu Nov 22 11:25:10 2007
Database: C:\PROGRAM FILES\HERBST SOFTWARE\HERBST INSIGHT 2 SERVER\BUG5.FDB.ACC
Index 2 is corrupt (missing entries) in table T1 (128)



SERGEI (Server) Thu Nov 22 11:25:10 2007
Database: C:\PROGRAM FILES\HERBST SOFTWARE\HERBST INSIGHT 2 SERVER\BUG5.FDB.ACC
Page 211 is an orphan

-- Log End --


 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
maziar added a comment - 24/Nov/07 11:34 PM
I have same problem in fb 2.1 beta 2

it is MAJOR BUG