[#CORE-2611] CLONE -Lock conversion denied (215) error may occurs

Firebird Core

CLONE -Lock conversion denied (215) error may occurs

Created: 31/Aug/09 12:01 AM Updated: 28/Sep/09 02:34 AM

Component/s:

Engine

Affects Version/s:

2.1.2

Fix Version/s:

2.0.5, 2.1.2, 2.5 Beta 1

Time Tracking:

Not Specified

Environment:

Only Classic Server is affected. Tested by me on Windows only but must be OS independent.

Issue Links:

Depend

This issue depends on:

~~CORE-1984~~ Lock manager reported false deadlocks if one of deadlock participants waits with permitted timeout

~~CORE-2000~~ Lock manager reported false deadlocks under high load

Planning Status:

Unspecified

Description

« Hide

I still get this error on my Windows 64 Bit with Firebird 2.1.2 (Build 18118) 64 Bit

DBSERVER Mon Aug 31 10:03:31 2009
Database: D:\SERVER\DATA\DATA.FDB
page 1, page type 2 lock conversion denied (215)

All

Comments

Work Log

Change History

Version Control

FishEye

Sort Order:

[ Permalink | « Hide ]

Vlad Khorsun added a comment - 31/Aug/09 01:12 AM

Could you show how to reproduce it ?

[ Permalink | « Hide ]

Andreas Steibl added a comment - 31/Aug/09 03:48 AM

No, i got htis error on a customer Server.
We don't use 64 Bit Classic server in house.

I looked in the log file and saw this error (Some time ago, the server has reported the same error, but no one has contaced me - they have restarted the server)

[ Permalink | « Hide ]

Andreas Steibl added a comment - 17/Sep/09 01:58 AM

Hi, i just upgrade to new 2.1.3 64Bit lcassic, and today i still got this error.

I think i will install the server new with SuperServer :(

[ Permalink | « Hide ]

Vlad Khorsun added a comment - 17/Sep/09 10:05 AM

Andreas,

i can do nothing without ability to reproduce this error.

[ Permalink | « Hide ]

Andreas Steibl added a comment - 17/Sep/09 06:50 PM

I know, but i dont' know how to reproduce it ...

Today i will install "Firebird Classic 32Bit" if i will get the error again i will install "Firebird 64Bit Superserver"

[ Permalink | « Hide ]

Vlad Khorsun added a comment - 17/Sep/09 06:57 PM

I doubt 32 vs 64 bit is counts here.

Could you describe your application ? How big load is ? What kind of load it creates ? Etc...

[ Permalink | « Hide ]

Andreas Steibl added a comment - 17/Sep/09 10:48 PM

I will try it with 32Bit, and if it didn'T work change to superserver (i think with the upcoming 2.5 the superserver can use multiprocessor, and than i will switch to superserver on all servers) ...

Its an ERP System, and this is our biggest customer, with about 50 simultaneously connection, and some of theme are doing massivly SELECTS und UPDATES and INSERT

An other customer has also installed Classic 64 Bit, but not so much load, and there i didn't get the error.

[ Permalink | « Hide ]

Cesar Evenreal added a comment - 28/Sep/09 02:22 AM - edited

We are getting the same problem on our Firebird 2.1.2 Classic Server(32bit Debian/GNU Linux), SMP 4 dual core processors. The database size is about 1GB and RAM memory is 4GB.

This is the description of the error from the log file:
Database: /var/db/lgs.gdb
page 56308, page type 5 lock conversion denied (215)

The application has a pool of 10 process each one with a permanent connection to the database(they don't do a connect/disconnect for each query, they re-use it). That means 10 simultaneous connections, all of them doing massivly select, updates and inserts on about 6 tables.

The error message at the application is:
ErrorNumber = 335544336
ErrText = deadlock page 56308, page type 5 lock conversion denied At procedure 'SP_DEBITMONEY' At procedure 'SP_PURCHASE'