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
page 14194, page type 5 lock conversion denied (215) [CORE2853] #3238
Comments
Commented by: @ibprovider Buggy, Buggy - Nach, Nach! [11.02.2010 11:22:05] [info] Provider DLL :_IBProvider_v3_vc9_w64_trial_i.dll provider=LCPI.IBProvider.3;location=localhost:d:\database\ibp_test_fb25_d3.gdb;user id=gamer;password=vermut;ctype=win1251;icu_library=icuuc30.dll [Server Log] -------- HOME2 Thu Feb 11 13:04:16 2010 [Test Log] --------- [11.02.2010 11:22:05] Creation 8 thread(s)... ------------- |
Commented by: @ibprovider const SCHAR pag_pointer= 4; // Pointer page DPM? |
Commented by: @ibprovider This problem still exist on Firebird 3.0.3.32714 (SuperClassic) - Four test threads HOME4 Thu Apr 20 05:46:22 2017 HOME4 Thu Apr 20 05:53:11 2017 HOME4 Thu Apr 20 05:54:21 2017 HOME4 Thu Apr 20 05:55:32 2017 HOME4 Thu Apr 20 06:02:04 2017 HOME4 Thu Apr 20 06:03:14 2017 HOME4 Thu Apr 20 06:05:32 2017 HOME4 Thu Apr 20 06:06:43 2017 HOME4 Thu Apr 20 06:07:53 2017 HOME4 Thu Apr 20 06:17:00 2017 HOME4 Thu Apr 20 06:18:10 2017 HOME4 Thu Apr 20 06:32:03 2017 HOME4 Thu Apr 20 06:33:13 2017 HOME4 Thu Apr 20 06:40:33 2017 HOME4 Thu Apr 20 06:41:43 2017 HOME4 Thu Apr 20 06:46:50 2017 HOME4 Thu Apr 20 06:48:00 2017 HOME4 Thu Apr 20 06:49:35 2017 HOME4 Thu Apr 20 06:50:46 2017 HOME4 Thu Apr 20 06:51:56 2017 HOME4 Thu Apr 20 06:55:56 2017 HOME4 Thu Apr 20 06:57:06 2017 HOME4 Thu Apr 20 06:58:17 2017 HOME4 Thu Apr 20 06:59:27 2017 HOME4 Thu Apr 20 07:04:07 2017 HOME4 Thu Apr 20 07:05:24 2017 HOME4 Thu Apr 20 07:06:34 2017 HOME4 Thu Apr 20 07:07:44 2017 HOME4 Thu Apr 20 07:10:59 2017 HOME4 Thu Apr 20 07:12:10 2017 HOME4 Thu Apr 20 07:13:20 2017 HOME4 Thu Apr 20 07:17:02 2017 HOME4 Thu Apr 20 08:28:12 2017 HOME4 Thu Apr 20 08:29:22 2017 HOME4 Thu Apr 20 08:34:06 2017 HOME4 Thu Apr 20 08:35:17 2017 HOME4 Thu Apr 20 08:36:30 2017 HOME4 Thu Apr 20 08:37:40 2017 HOME4 Thu Apr 20 08:38:50 2017 HOME4 Thu Apr 20 08:51:34 2017 HOME4 Thu Apr 20 09:01:24 2017 HOME4 Thu Apr 20 09:02:35 2017 HOME4 Thu Apr 20 09:24:40 2017 HOME4 Thu Apr 20 09:25:51 2017 HOME4 Thu Apr 20 09:27:01 2017 HOME4 Thu Apr 20 09:43:44 2017 HOME4 Thu Apr 20 09:44:55 2017 HOME4 Thu Apr 20 09:46:05 2017 |
Modified by: @hvladassignee: Vlad Khorsun [ hvlad ] |
Commented by: @hvlad I reproduced "lock denied" errors using fb4\SC\win64 using tpcc. |
Commented by: @hvlad v2.x have fixed all known reasons for this issue, I believe. Currently is was reproduced at v3 and v4 with different reason. |
Modified by: @hvladVersion: 3.0.2 [ 10785 ] Version: 3.0.1 [ 10730 ] Version: 3.0.0 [ 10740 ] Version: 4.0 Initial [ 10621 ] |
Commented by: Jesus Angel Garcia Zarco (cointec) V2.X from what version? |
Modified by: @hvladstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 4.0 Alpha 1 [ 10731 ] Fix Version: 3.0.3 [ 10810 ] |
Commented by: Jesus Angel Garcia Zarco (cointec) Thank you, I think that databases that has this issue were created in version 2.5.2. If I see this behaviour in databases created after 2.5.3 I will notify you. Is complicated reproduce the case because I have seen it in logs 2 or 3 times per week and under high load. |
Submitted by: @ibprovider
[09.02.2010 01:54:46] [info] Provider DLL :_IBProvider_v3_i.dll
[09.02.2010 01:54:46] [info] Provider Version:3.0.0.8623
[09.02.2010 01:54:46] [info] Server Name :Firebird (x64/SuperClassic/VS2008 SP1+/has the fix for CORE2851)
[09.02.2010 01:54:46] [info] Server Version :2.5.0.25920
[09.02.2010 01:54:46] [info] Client Name :Firebird SQL Server (32 bits)
[09.02.2010 01:54:46] [info] Client Version :2.5.0.25920
[09.02.2010 01:54:46] [info] Database ODS :11.2
[09.02.2010 01:54:46] [info] Database Dialect:3
[09.02.2010 01:54:46] [info] ConnectionString:
provider=LCPI.IBProvider.3;location=localhost:d:\database\ibp_test_fb25_d3.gdb;user id=gamer;password=vermut;ctype=win1251;icu_library=icuuc30.dll;dbclient_library=fbclient.dll
[09.02.2010 01:54:46] Creation 8 thread(s)...
----- [Firebird Log]
HOME2 Tue Feb 09 03:39:55 2010
Database: D:\DATABASE\IBP_TEST_FB25_D3.GDB
page 14194, page type 5 lock conversion denied (215)
HOME2 Tue Feb 09 03:40:05 2010
Database: D:\DATABASE\IBP_TEST_FB25_D3.GDB
page 14194, page type 5 lock conversion denied (215)
----- [Tests]
Write and Read VARCHAR-Arrays (8 threads with own connections)
VARCHAR_ARRAY__32 VARCHAR(32) [0:2] CHARACTER SET WIN1251
IBProvider tests: *1251*
[09.02.2010 07:39:24] [summary] ------------------------------------------- [SUMMARY INFORMATION]
[09.02.2010 07:39:24] [summary] [TESTS]
[09.02.2010 07:39:24] [summary] TOTAL : 80472
[09.02.2010 07:39:24] [summary] SUCCEEDED : 80470
[09.02.2010 07:39:24] [summary] FAILED : 2 [ 2 error(s) ]
[09.02.2010 07:39:24] [summary] WITH WARNINGS : 0
[09.02.2010 07:39:24] [summary]
[09.02.2010 07:39:24] [summary] - - - - - - - - - - - - - - - - - - - - - -
[09.02.2010 07:39:24] [summary] [TEST TIMES]
[09.02.2010 07:39:24] [summary] REAL :1621116940000 [1 day(s)21:01:51.6940000]
[09.02.2010 07:39:24] [summary] USER :100951055118 [02:48:15.1055118]
[09.02.2010 07:39:24] [summary] KERNEL :17637785062 [00:29:23.7785062]
[09.02.2010 07:39:24] [summary] TOTAL :118588840180 [03:17:38.8840180]
[09.02.2010 07:39:24] [summary]
[09.02.2010 07:39:24] [summary] - - - - - - - - - - - - - - - - - - - - - -
[09.02.2010 07:39:24] [summary] TOTAL ERRORS : 2
[09.02.2010 07:39:24] [summary] TOTAL WARNINGS: 0
Commits: e71fcbb 56b25b5
The text was updated successfully, but these errors were encountered: