Skip to content
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

Closed
firebird-issue-importer opened this issue Feb 9, 2010 · 12 comments
Closed

Comments

@firebird-issue-importer
Copy link

firebird-issue-importer commented Feb 9, 2010

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Feb 11, 2010

Commented by: @ibprovider

Buggy, Buggy - Nach, Nach!

[11.02.2010 11:22:05] [info] Provider DLL :_IBProvider_v3_vc9_w64_trial_i.dll
[11.02.2010 11:22:05] [info] Provider Version:3.0.0.8627
[11.02.2010 11:22:05] [info] Server Name :Firebird (SuperClassic x64, VS2008SP1+, Release Fresh Build)
[11.02.2010 11:22:05] [info] Server Version :2.5.0.25920
[11.02.2010 11:22:05] [info] Client Name :Firebird SQL Server (x64)
[11.02.2010 11:22:05] [info] Client Version :2.5.0.25920
[11.02.2010 11:22:05] [info] Database ODS :11.2
[11.02.2010 11:22:05] [info] Database Dialect:3
[11.02.2010 11:22:05] [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

[Server Log] --------

HOME2 Thu Feb 11 13:04:16 2010
Database: D:\DATABASE\IBP_TEST_FB25_D3.GDB
page 1681413, page type 4 lock conversion denied (215)

[Test Log] ---------

[11.02.2010 11:22:05] Creation 8 thread(s)...
....
[11.02.2010 13:04:17] ERROR: [charsets|charsets.txt_params.user_trans.unicode.TBL_CS__WIN1251.VARCHAR_ARRAY__32.cn_UNICODE_FSS.user_WIN1251.chars_WIN1251.param_adBSTR_Array.bind_str_array.array_type_2] Execution of command
1. [LCPI.IBProvider.3]: Ошибка выполнения SQL выражения.
deadlock
page 1681413, page type 4 lock conversion denied

-------------
IBProvider tests: *1251*

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Feb 11, 2010

Commented by: @ibprovider

const SCHAR pag_pointer= 4; // Pointer page
const SCHAR pag_data= 5; // Data page

DPM?

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Apr 20, 2017

Commented by: @ibprovider

This problem still exist on Firebird 3.0.3.32714 (SuperClassic)

- Four test threads
- Database on the HDD

HOME4 Thu Apr 20 05:46:22 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D1_2.GDB
page 1620182, page type 4 lock denied (216)

HOME4 Thu Apr 20 05:53:11 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D1_2.GDB
page 1724023, page type 5 lock denied (216)

HOME4 Thu Apr 20 05:54:21 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D1_2.GDB
page 1724023, page type 5 lock denied (216)

HOME4 Thu Apr 20 05:55:32 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D1_2.GDB
page 1724023, page type 5 lock denied (216)

HOME4 Thu Apr 20 06:02:04 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D1_2.GDB
page 1733435, page type 5 lock denied (216)

HOME4 Thu Apr 20 06:03:14 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D1_2.GDB
page 1731818, page type 4 lock denied (216)

HOME4 Thu Apr 20 06:05:32 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D3_2.GDB
page 1780617, page type 5 lock denied (216)

HOME4 Thu Apr 20 06:06:43 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D3_2.GDB
page 1780617, page type 5 lock denied (216)

HOME4 Thu Apr 20 06:07:53 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D3_2.GDB
page 1780617, page type 5 lock denied (216)

HOME4 Thu Apr 20 06:17:00 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D3_2.GDB
page 1794919, page type 5 lock denied (216)

HOME4 Thu Apr 20 06:18:10 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D3_2.GDB
page 1794199, page type 4 lock denied (216)

HOME4 Thu Apr 20 06:32:03 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D3_2.GDB
page 1809504, page type 5 lock denied (216)

HOME4 Thu Apr 20 06:33:13 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D3_2.GDB
page 1809504, page type 5 lock denied (216)

HOME4 Thu Apr 20 06:40:33 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D1_2.GDB
page 1876649, page type 5 lock denied (216)

HOME4 Thu Apr 20 06:41:43 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D1_2.GDB
page 1873710, page type 4 lock denied (216)

HOME4 Thu Apr 20 06:46:50 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D1_2.GDB
page 1883585, page type 5 lock denied (216)

HOME4 Thu Apr 20 06:48:00 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D1_2.GDB
page 1880610, page type 4 lock denied (216)

HOME4 Thu Apr 20 06:49:35 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D3_2.GDB
page 1922811, page type 5 lock denied (216)

HOME4 Thu Apr 20 06:50:46 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D3_2.GDB
page 1922811, page type 5 lock denied (216)

HOME4 Thu Apr 20 06:51:56 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D3_2.GDB
page 1922811, page type 5 lock denied (216)

HOME4 Thu Apr 20 06:55:56 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D1_2.GDB
page 1897569, page type 5 lock denied (216)

HOME4 Thu Apr 20 06:57:06 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D1_2.GDB
page 1897299, page type 4 lock denied (216)

HOME4 Thu Apr 20 06:58:17 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D1_2.GDB
page 1897577, page type 5 lock denied (216)

HOME4 Thu Apr 20 06:59:27 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D1_2.GDB
page 1897299, page type 4 lock denied (216)

HOME4 Thu Apr 20 07:04:07 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D1_2.GDB
page 1900732, page type 4 lock denied (216)

HOME4 Thu Apr 20 07:05:24 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D1_2.GDB
page 1903983, page type 5 lock denied (216)

HOME4 Thu Apr 20 07:06:34 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D1_2.GDB
page 1903983, page type 5 lock denied (216)

HOME4 Thu Apr 20 07:07:44 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D1_2.GDB
page 1903983, page type 5 lock denied (216)

HOME4 Thu Apr 20 07:10:59 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D1_2.GDB
page 1907526, page type 5 lock denied (216)

HOME4 Thu Apr 20 07:12:10 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D1_2.GDB
page 1907526, page type 5 lock denied (216)

HOME4 Thu Apr 20 07:13:20 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D1_2.GDB
page 1907526, page type 5 lock denied (216)

HOME4 Thu Apr 20 07:17:02 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D1_2.GDB
page 1910876, page type 4 lock denied (216)

HOME4 Thu Apr 20 08:28:12 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D3_2.GDB
page 2366719, page type 5 lock denied (216)

HOME4 Thu Apr 20 08:29:22 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D3_2.GDB
page 2364237, page type 4 lock denied (216)

HOME4 Thu Apr 20 08:34:06 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D1_2.GDB
page 2292282, page type 5 lock denied (216)

HOME4 Thu Apr 20 08:35:17 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D1_2.GDB
page 2292282, page type 5 lock denied (216)

HOME4 Thu Apr 20 08:36:30 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D3_2.GDB
page 2378919, page type 5 lock denied (216)

HOME4 Thu Apr 20 08:37:40 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D3_2.GDB
page 2378919, page type 5 lock denied (216)

HOME4 Thu Apr 20 08:38:50 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D3_2.GDB
page 2378919, page type 5 lock denied (216)

HOME4 Thu Apr 20 08:51:34 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D1_2.GDB
page 2337340, page type 4 lock denied (216)

HOME4 Thu Apr 20 09:01:24 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D3_2.GDB
page 2427995, page type 5 lock denied (216)

HOME4 Thu Apr 20 09:02:35 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D3_2.GDB
page 2427995, page type 5 lock denied (216)

HOME4 Thu Apr 20 09:24:40 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D1_2.GDB
page 2470702, page type 5 lock denied (216)

HOME4 Thu Apr 20 09:25:51 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D1_2.GDB
page 2470702, page type 5 lock denied (216)

HOME4 Thu Apr 20 09:27:01 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D1_2.GDB
page 2470702, page type 5 lock denied (216)

HOME4 Thu Apr 20 09:43:44 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D1_2.GDB
page 2497856, page type 5 lock denied (216)

HOME4 Thu Apr 20 09:44:55 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D1_2.GDB
page 2497856, page type 5 lock denied (216)

HOME4 Thu Apr 20 09:46:05 2017
Database: D:\DATABASE\FB_03_0_0\IBP_TEST_FB30_D1_2.GDB
page 2497856, page type 5 lock denied (216)

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 10, 2017

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 10, 2017

Commented by: @hvlad

I reproduced "lock denied" errors using fb4\SC\win64 using tpcc.
The patch is committed, please test it.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 10, 2017

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.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 10, 2017

Modified by: @hvlad

Version: 3.0.2 [ 10785 ]

Version: 3.0.1 [ 10730 ]

Version: 3.0.0 [ 10740 ]

Version: 4.0 Initial [ 10621 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 11, 2017

Commented by: Jesus Angel Garcia Zarco (cointec)

V2.X from what version?
I still have this issue in V2.5.3,2.5.4 and 2.5.5

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 11, 2017

Commented by: @hvlad

The last issues i remember was CORE2848 and CORE4372.
Both fixed at 2.5.3
Note comments on CORE4372 that database should be created (or restored) with at least 2.5.3

If you still have this issue with current 2.5.7 and if you could reproduce it - contact me, please

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 14, 2017

Modified by: @pavel-zotov

status: Open [ 1 ] => Open [ 1 ]

QA Status: Not enough information

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 19, 2017

Modified by: @hvlad

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 4.0 Alpha 1 [ 10731 ]

Fix Version: 3.0.3 [ 10810 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 21, 2017

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment