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
[security3.fdb] wrong page type page 22 is of wrong type (expected pointer, found index root) [CORE5415] #5688
Comments
Commented by: @AlexPeshkoff Does it happen when running some specific test or randomly in different tests? |
Commented by: @ibprovider >Does it happen when running some specific test or randomly in different tests? HOME4 Thu Dec 8 22:10:18 2016 Other test - charsets.rw.cmd.ansi.TBL_CS__WIN1251.VARCHAR__8.param_adBSTR.ins_cn_WIN1251.ins_user_NONE.sel_cn_WIN1251.sel_user_NONE.small.len_8.chars_WIN1251.bind__str_byref I think, the problem linked with connection operation. Not with scenario of test. >What does gfix say about SECURITY3.FDB after failed test? 1. I stop all tests HOME4 Fri Dec 9 20:15:24 2016 HOME4 Fri Dec 9 20:15:24 2016 -------------- |
Modified by: @ibproviderAttachment: security3__copy.zip [ 13041 ] |
Commented by: @AlexPeshkoff If gfix does not find errors DB copy hardly helps. We all know about damaged databases but suppose nobody heard before about database that got after it magically repaired. In this message: |
Modified by: @ibproviderAttachment: firebird.log [ 13044 ] |
Commented by: @ibprovider >Are expected/found types (pointer/index root) always same? Seems so. I attached the "firebird.log" file |
Commented by: @ibprovider The problem still exists - Firebird 3.0.2.32692 x64 SuperServer (Win10) HOME4 Sat Mar 11 04:49:05 2017 HOME4 Sat Mar 11 04:49:05 2017 HOME4 Sat Mar 11 04:49:05 2017 ------------- -------------- [script source code] dim cn set cn=createobject("ADODB.Connection") dim n n=0 while(true) cn.Provider="LCPI.IBProvider.3" cn.Properties("location").value="localhost:d:\database\ram\ibp_test_fb30_d3_2.gdb" wscript.echo n call cn.Open() call cn.Close() |
Commented by: @hvlad Could you produce stack trace (or full memory dump) at the moment when exception raised ? |
Commented by: @ibprovider >It happens in src\jrd\cch.cpp at page_validation_error() routine. Ok. I set the breakpoint in page_validation_error function. |
Commented by: @hvlad Thanks. Also, what kind of auth do you use (srp or legacy) ? I tried to reproduce it with few isql's running in parallel script with 1000 {connect; commit;} statements - no luck |
Commented by: @ibprovider >Also, what kind of auth do you use (srp or legacy) ? SRP >I tried to reproduce it with few isql's running in parallel script with 1000 {connect; commit;} statements - no luck I've got the same :) |
Commented by: @ibprovider Bingo! Dump file coming soon. > engine12.dll!page_validation_error(Jrd::thread_db * tdbb, Jrd::win * window, short type)Строка 4283 C++ |
Commented by: @ibprovider Dump file + sources + binaries + PDB and others: http://dropmefiles.com/G1Drh (330 MB) I hope, dump file with 20GB size is not problem for you. ----- - 2 database |
Commented by: @ibprovider Additional info The problem was catched after 4x275000 connect/disconnect operations (<11 hours) |
Commented by: @ibprovider Please notify me, when I can continue execution of tests. |
Commented by: @hvlad Thanks for the dump. It is very interesting: So far i have no explanation for this and continue to explore the things. PS You can continue to run your tests, thanks again |
Commented by: @ibprovider Description of previous error in log-file HOME4 Sun Mar 12 14:17:42 2017 |
Commented by: @ibprovider Second 4 dumps (for same binaries and sources) http://dropmefiles.com/qhYqi - 1 dump (270MB) firebird_2.dmp - failed (first case) [ok] I set the breakpoint to cch.cpp-648 /*648*/ if (bdb->bdb_buffer->pag_type != page_type && page_type != pag_undefined) and page_validation_error was not called |
Modified by: @hvladassignee: Vlad Khorsun [ hvlad ] |
Modified by: @AlexPeshkoffVersion: 2.5.7 [ 10770 ] Version: 3.0.1 [ 10730 ] Version: 2.5.6 [ 10721 ] Version: 3.0.0 [ 10740 ] Version: 4.0 Initial [ 10621 ] Version: 2.5.5 [ 10670 ] Version: 2.5.4 [ 10585 ] Version: 2.5.3 Update 1 [ 10650 ] Version: 2.1.7 [ 10651 ] Version: 2.5.3 [ 10461 ] Version: 2.5.2 Update 1 [ 10521 ] Version: 2.5.2 [ 10450 ] Version: 2.5.1 [ 10333 ] Version: 2.5.0 [ 10221 ] Fix Version: 4.0 Alpha 1 [ 10731 ] Fix Version: 3.0.3 [ 10810 ] Fix Version: 2.5.8 [ 10809 ] |
Commented by: @hvlad Big thanks to the Dmitry Kovalenko for the case, the many hours of testing and for the patience. |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: No test => Deferred Test Details: waitig for reply, letter 25.03.2017 1637 |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: Deferred => Cannot be tested Test Details: waitig for reply, letter 25.03.2017 1637 => Letter from hvlad, 26.03.2017 00:30. |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Closed [ 6 ] |
Submitted by: @ibprovider
Attachments:
security3__copy.zip
firebird.log
FB SuperServer x64 3.0.2.32641
Under load tests I get the some unexpected problem with connection to database
Test configuration: 8 test threads.
Message at test side:
[THR:002956] [07.12.2016 01:22:37] [test] connect to database ...
[THR:002956] [07.12.2016 01:22:37] ERROR: [blob.002.cmd.disable_defer_data.ansi.TBL_CS__TIS620.COL_BLOB.param_adLongVarWChar.bind__wstr.large1.len_4053.chars_TIS620.ins_UTF8.sel_NONE] Data Source initialization
1. [Unknown DBMS]: Error occurred during login, please check server firebird.log for details
2. [LCPI.IBProvider.3]: Ошибка подключения к базе данных.
Неопознанная ошибка
Message in firebird.log:
HOME4 Wed Dec 7 01:22:37 2016
Authentication error
database file appears corrupt (D:\PROGRAM_FILES\FIREBIRD_3_0_X64\SECURITY3.FDB)
wrong page type
page 22 is of wrong type (expected pointer, found index root)
The previous tests and the next tests (in this and other threads) work without problem.
In other word, this problem not affect to work of other tests.
Commits: 9d361b9 43e0777 bad0c72 8b8544e f72eee4 fcc44c1 2cda032
====== Test Details ======
Letter from hvlad, 26.03.2017 00:30.
The text was updated successfully, but these errors were encountered: