Issue Details (XML | Word | Printable)

Key: CORE-3188
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Vlad Khorsun
Reporter: Vlad Khorsun
Votes: 0
Watchers: 1
Operations

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

page 0 is of wrong type (expected 6, found 1)

Created: 17/Oct/10 09:16 PM   Updated: 04/Feb/11 12:22 PM
Component/s: Engine
Affects Version/s: 2.0.0, 1.5.4, 2.0.1, 2.0.2, 2.0.3, 1.5.5, 2.1.0, 2.0.4, 2.1.1, 2.0.5, 2.1.2, 2.1.3, 1.5.6, 2.0.6, 2.5.0
Fix Version/s: 2.1.4, 2.5.1, 3.0 Alpha 1

Time Tracking:
Not Specified

Environment: ClassicServer or SuperClassic

Planning Status: Unspecified


 Description  « Hide
Run Firebird 2.1 or 2.5, CS or SC

1)
1st isql session :
...\firebird\bin>isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database 't.fdb';
SQL>

2)
2nd isql session :
...\firebird\bin>isql t.fdb
Database: t.fdb
SQL>

3)
1st isql session :
SQL> create table tmpdat(id int not null primary key);
SQL>

4)
2nd isql session :
SQL> drop table tmpdat;
Statement failed, SQLSTATE = XX001
database file appears corrupt (...\FIREBIRD\BIN\T.FDB)
-wrong page type
-page 0 is of wrong type (expected 6, found 1)
SQL>

5) Validation found no errors


Firebird before v2.1 also have this issue but it have different consequences:

1st isql session :
...\firebird\bin>isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database 't.fdb';
SQL>

2)
2nd isql session :
...\firebird\bin>isql t.fdb
Database: t.fdb
SQL>

3)
1st isql session :
SQL> create table tmpdat(id int not null primary key);
SQL> insert into tmpdat values (1);
SQL> commit;
SQL>

4)
2nd isql session :
SQL> drop table tmpdat;
SQL> exit;

5)
1st isql session :
SQL> exit;

6) Run validation
...\firebird\bin>gfix -v -fu T.FDB
Summary of validation errors

        Number of record level errors : 1

firebird.log contains
Database: ...\FIREBIRD\BIN\T.FDB
Record 0 is wrong length in table (128)


 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Vlad Khorsun added a comment - 17/Oct/10 09:36 PM
Fix for 2.5.1 is committed, 2.1.4 and 3.0 follow soon

Vlad Khorsun added a comment - 25/Nov/10 11:22 AM
Back\Front ported into 2.1.4 and 3.0