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

CLONE -Lock conversion denied (215) error may occurs [CORE2611] #3021

Closed
firebird-automations opened this issue Aug 31, 2009 · 18 comments
Closed

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Andreas Steibl (snoopy_spy)

Depends on CORE1984
Depends on CORE2000

Votes: 3

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)

@firebird-automations
Copy link
Collaborator Author

Modified by: Andreas Steibl (snoopy_spy)

Link: This issue depends on CORE1984 [ CORE1984 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: Andreas Steibl (snoopy_spy)

Link: This issue depends on CORE2000 [ CORE2000 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: Andreas Steibl (snoopy_spy)

description: I still get this error on my Windows 64 Bit with Firebird 2.1.2 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)

@firebird-automations
Copy link
Collaborator Author

Modified by: Andreas Steibl (snoopy_spy)

Version: 2.1.2 [ 10270 ]

description: I still get this error on my Windows 64 Bit with Firebird 2.1.2 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)

=>

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)

Version: 2.0.0 [ 10091 ] =>

Version: 1.5.4 [ 10100 ] =>

Version: 2.0.1 [ 10090 ] =>

Version: 2.0.2 [ 10130 ] =>

Version: 2.0.3 [ 10200 ] =>

Version: 1.5.5 [ 10220 ] =>

Version: 2.1.0 [ 10041 ] =>

Version: 2.0.4 [ 10211 ] =>

Version: 2.1.1 [ 10223 ] =>

Version: 2.0.5 [ 10222 ] =>

Version: 1.5.6 [ 10225 ] =>

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

Could you show how to reproduce it ?

@firebird-automations
Copy link
Collaborator Author

Commented by: Andreas Steibl (snoopy_spy)

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)

@firebird-automations
Copy link
Collaborator Author

Commented by: Andreas Steibl (snoopy_spy)

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 :(

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

Andreas,

i can do nothing without ability to reproduce this error.

@firebird-automations
Copy link
Collaborator Author

Commented by: Andreas Steibl (snoopy_spy)

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"

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

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...

@firebird-automations
Copy link
Collaborator Author

Commented by: Andreas Steibl (snoopy_spy)

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.

@firebird-automations
Copy link
Collaborator Author

Commented by: Cesar Evenreal (zezar98)

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'

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

I believe it is fixed as CORE2848 and CORE4372

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

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

resolution: Duplicate [ 3 ]

Fix Version: 2.5.3 [ 10461 ]

Fix Version: 3.0 Beta 1 [ 10332 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

Fix Version: 2.5 Beta 1 [ 10251 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 2.0.5 [ 10222 ] =>

Fix Version: 2.1.2 [ 10270 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

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

No branches or pull requests

2 participants