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
sweep running on read_only databases [CORE342] #680
Comments
Modified by: @pcisarWorkflow: jira [ 10366 ] => Firebird [ 14611 ] |
Modified by: @hvladstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 2.5.3 [ 10461 ] Fix Version: 3.0 Alpha 1 [ 10331 ] |
Commented by: @pavel-zotov I still _can_ reproduce message in FB 2.5.3 ... 2.5.6 about "cannot find tip page", but with different line numbers: internal Firebird consistency check (cannot find tip page (165), file: tra.cpp line: 2375) // WI-V2.5.3.26780 For each FB version I did following: Then I did connect to that database (by ISQL) and run script ("core_0342-run.sql " -- see attached .7z):set list on;
|
Modified by: @pavel-zotovAttachment: core_0342_raw_fdb_files_prepared_for_running_on_FB_253_254_256.7z [ 12913 ] |
Commented by: @pavel-zotov The same on 3.0! Please look: Database: localhost/3333:C:\MIX\firebird\QA\fbt-repo\tmp\E30.FDb, User: SYSDBA CURRENT_TRANSACTION 5 Statement failed, SQLSTATE = XX000 Checked on SS, SC. Classic (and ONLY this arch.) will add into firebird.log (after text about "cannot find tip page ") also this: CSPROG Tue Mar 08 15:02:37 2016 SuperServer will be crashed (service will be stopped). |
Modified by: @pavel-zotovAttachment: core_0342_raw_fdb_files_prepared_for_running_on_FB_30.7z [ 12914 ] |
Commented by: @pavel-zotov I found thresholds for 2.5.6 and 3.0: maximal number of autonomous transactions (which move Tx counters) should not exceed 16297 for 2.5.6 and 32681 for 3.0.0 -- at least for databases which are attached above: So, the following script contains max. available values for 'n'; if we'll increase 'n' by 1 we get "internal Firebird consistency check (cannot find tip page (165), file: tra.cpp line: NNNN)": set list on; BTW, I have *no* firebird.conf which contain 'bugcheckabort = 1'. So, from where this does appear (I mean "bugcheck" word in following text):Statement failed, SQLSTATE = XX000
|
Commented by: @dyemanov Your "threasholds" are easy to explain, they depend on the default page size (4KB in v2.5 and 8KB in v3.0). Every transaction state occupies two bits in TIP, so the page size should be multiplied by four to get these numbers. |
Commented by: @pavel-zotov But what about this ticket state (resolved / fixed) ? |
Commented by: @pavel-zotov > do you see a sweep in your tests ? _NO_ messages about sweep did appear in firebird.log for 2.5.3, 2.5.4, 2.5.6 & 3.0 |
Commented by: @pavel-zotov > do you see a sweep in your tests ? OK, I understand. One need to make "integral test" for several tickets at once. |
Commented by: @pavel-zotov I have to correct myself about 2.5.6: on _LAST_ snapshot (WI-V2.5.6.26980) all works fine. Checked on SS and SC, with script that tries to increase Tx counter up to 1'000'000. As of 4.0 - still get error message (see above; checked on WI-T4.0.0.32386 , build of 08-mar-2016). |
Submitted by: Mustafa YILMAZ (myilmaz)
Attachments:
core_0342_raw_fdb_files_prepared_for_running_on_FB_253_254_256.7z
core_0342_raw_fdb_files_prepared_for_running_on_FB_30.7z
SFID: 1238128#
Submitted By: myilmaz
versions: fb 1.5.2, fb 2 alpha 2
test case:
create test db
set sweep internal to 0
set read_only to true
reconnect test db
execute 20000 times (move up transaction counter)
SELECT COUNT(*) FROM RDB$DATABASE;
COMMIT;
firebird 2 log message
internal gds software consistency check (cannot find tip
page (165), file: tra.cpp line: 2475)
The text was updated successfully, but these errors were encountered: