Subject Firebird 2.1.3 on OpenVZ
Author xsaero00
I am trying to run live Firebird server 2.1.3 on OpenVZ container and I am having all sorts of problems. I have been able to run test database servers on OpenVZ containers with no problems.

I keep getting following messages in the firebird log.

data-01 Sun Dec 6 19:23:15 2009
deadlock


data-01 Sun Dec 6 19:23:15 2009
page 708, page type 3 lock conversion denied


data-01 Sun Dec 6 21:15:20 2009
Database: /var/lib/firebird/system/security2.fdb
page 714, page type 3 lock conversion denied (215)


data-01 Sun Dec 6 21:15:30 2009
Database: /var/lib/firebird/system/security2.fdb
page 714, page type 3 lock conversion denied (215)


data-01 Sun Dec 6 21:19:30 2009
Fatal lock manager error: semaphores are exhausted, errno: 11


data-01 Sun Dec 6 21:19:30 2009
Fatal lock manager error: semaphores are exhausted, errno: 11


data-01 Sun Dec 6 21:19:37 2009
Fatal lock manager error: semaphores are exhausted, errno: 11


data-01 Sun Dec 6 21:19:37 2009
Fatal lock manager error: semaphores are exhausted, errno: 11


When the "semaphores are exhausted" message appears then the database server becomes unresponsive and the container hosting the firebird service has to be restarted. I tried increasing the semaphore count but it does not let me. When I try to up the limit in firebird.log I see error like this:

stagedata-01 Mon Dec 7 08:47:13 2009
Number of requested semaphores (256) is greater then size of the existing semaphore set (128)

Even though the "sysctl kernel.sem" returns
kernel.sem = 256 32000 32 128

I have no idea what to do with "lock conversion denied" errors.

If this is any relevance, I am using a CentOS 5 64 bit with firebird distribution from http://fedoraproject.org/wiki/EPEL repository.
Installed Packages
firebird.x86_64 2.1.3.18185.0-2.el5 installed
firebird-classic.x86_64 2.1.3.18185.0-2.el5 installed
firebird-filesystem.x86_64 2.1.3.18185.0-2.el5 installed
firebird-libfbclient.x86_64 2.1.3.18185.0-2.el5 installed
firebird-libfbembed.x86_64 2.1.3.18185.0-2.el5 installed

Any suggestions on how to resolve these issues would be appreciated.