New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Database corruption after end of session : page xxx is of wrong type expected 4 found 7 [CORE3549] #3905
Comments
Modified by: alainsegura (linlin13)description: Engine version 2.5.1.26333 When a run my software with a "small" set of operations, nothing happen (all is ok). But After running a huge number of transactions including operations such as: "page 266 is of wrong type expected 4 found 7" and the database is then corrupted. At this time, i have no more information to provide, to find the origine of the problem. => Engine version 2.5.1.26333 Problem * When a run my software with the engine 2.5.0.26074 all is ok, in ALL cases. * When a run my software with a "small" set of operations, and with the engine 2.5.1.26333 nothing special happen (all is ok). * When a run my software with the engine 2.5.1.26333 with a huge number of transactions including operations such as: BUT after disconnection and reconnection to the database, the engine return the following error : "page 266 is of wrong type expected 4 found 7" and the database is corrupted and unusable !! Same problem under various OS version (windows) and databases. The engine "itself" is the cause of the problem. environment: Windows 7. => Windows (XP, 7) |
Commented by: alainsegura (linlin13) The database seem to be in a correct state while the initial connection is active. When the connection is closed, impossible to reconnect to the database, the engine return the error page X is of wrong type expected 4 found 7. |
Modified by: alainsegura (linlin13)description: Engine version 2.5.1.26333 Problem * When a run my software with the engine 2.5.0.26074 all is ok, in ALL cases. * When a run my software with a "small" set of operations, and with the engine 2.5.1.26333 nothing special happen (all is ok). * When a run my software with the engine 2.5.1.26333 with a huge number of transactions including operations such as: BUT after disconnection and reconnection to the database, the engine return the following error : "page 266 is of wrong type expected 4 found 7" and the database is corrupted and unusable !! Same problem under various OS version (windows) and databases. The engine "itself" is the cause of the problem. => Engine version 2.5.1.26333 Problem * When a run my software with the engine 2.5.0.26074 all is ok, in ALL cases. * When a run my software with a "small" (100000) set of operations, and with the engine 2.5.1.26333 nothing special happen (all is ok). * When a run my software with the engine 2.5.1.26333 with a huge number (10000000) of transactions including operations such as: BUT after disconnection and reconnection to the database, the engine return the following error : "page 266 is of wrong type expected 4 found 7" and the database is corrupted and unusable !! Same problem under various OS version (windows) and databases. The engine "itself" is the cause of the problem. environment: Windows (XP, 7) => Windows (All versions) |
Modified by: alainsegura (linlin13)description: Engine version 2.5.1.26333 Problem * When a run my software with the engine 2.5.0.26074 all is ok, in ALL cases. * When a run my software with a "small" (100000) set of operations, and with the engine 2.5.1.26333 nothing special happen (all is ok). * When a run my software with the engine 2.5.1.26333 with a huge number (10000000) of transactions including operations such as: BUT after disconnection and reconnection to the database, the engine return the following error : "page 266 is of wrong type expected 4 found 7" and the database is corrupted and unusable !! Same problem under various OS version (windows) and databases. The engine "itself" is the cause of the problem. => * When a run my software with the engine 2.5.0.26074 all is ok, in ALL cases. * When a run my software with a "small" (100000) set of operations, and with the engine 2.5.1.26333 nothing special happen (all is ok). * When a run my software with the engine 2.5.1.26333 with a huge number (10000000) of transactions including operations such as: BUT after disconnection and reconnection to the database, the engine return the following error : "page 266 is of wrong type expected 4 found 7" and the database is corrupted and unusable !! Same problem under various OS version (windows) and databases. The engine "itself" is the cause of the problem. environment: Windows (All versions) => Windows (All versions) -- Engine version 2.5.1.26333 32Bits Superserver. |
Commented by: @hvlad Reproducible test case required. |
Commented by: alainsegura (linlin13) I'am investigating this problem, at this time a have found this: *without the usage of global temporary table -> no database corrution *with the usage of command --> after hundred of transactions --> the database get corrupted. reproductible case coming soon... |
Commented by: alainsegura (linlin13) Sorry, i have created a new issue (core 3550) for a new problem, but in fact, it's the same issue, see core-3550 for detail and a reproductible case |
Modified by: @hvladassignee: Vlad Khorsun [ hvlad ] |
Commented by: @hvlad To reproduce: 1. Create GTT ON COMMIT PRESERVE ROWS and index on it in the same transaction : set autoddl off; 2. Make engine write record into RDB$PAGES with RDB$RELATION_ID = 0. It happens when new TIP or generator page is created. execute block 3. Disconnect and connect again. Error
or will be raised. |
Modified by: @hvladstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 2.5.1 [ 10333 ] Fix Version: 3.0 Alpha 1 [ 10331 ] Fix Version: 2.1.5 [ 10420 ] |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Modified by: @pavel-zotovstatus: Closed [ 6 ] => Closed [ 6 ] QA Status: Done successfully Test Details: NOTE: could NOT reproduce on official 2.5.1 (WI-V2.5.1.26351, issued 03-oct-2011). |
Submitted by: alainsegura (linlin13)
* When a run my software with the engine 2.5.0.26074 all is ok, in ALL cases.
* When a run my software with a "small" (100000) set of operations, and with the engine 2.5.1.26333 nothing special happen (all is ok).
* When a run my software with the engine 2.5.1.26333 with a huge number (10000000) of transactions including operations such as:
insert/update, select, create procedure, drop procedure The work end normally (no error message) while connected.
BUT after disconnection and reconnection to the database, the engine return the following error :
"page 266 is of wrong type expected 4 found 7"
and the database is corrupted and unusable !!
Same problem under various OS version (windows) and databases. The engine "itself" is the cause of the problem.
Commits: 3e9577b da874ec 4695be3
====== Test Details ======
NOTE: could NOT reproduce on official 2.5.1 (WI-V2.5.1.26351, issued 03-oct-2011).
Fix for this ticket in 2.5.1 was before official 2.5.1 release: 17-jul-2011, rev. 53327
The text was updated successfully, but these errors were encountered: