[pkg-firebird-general] SCH_validate error caused Lock Manager Out of Room

[Aldo Caruso]

Hi,

  After some advices that I received in the official Firebird 
manteinance mailing list ( yahoo group firebird-support ) about the 
"Lock manager out of room" problem, it came to light that the error was 
a consequence of a previous error found in the firebird.log message:

  SCH_validate -- not entered.

  Helen Borrie suggested me that this has to do mainly with conflicts in 
the thread scheduler, which arise when the Linux kernel implements NPTL 
but the firebird package use the old threading model.

  In fact, not ony this problem appears in my Debian server, but also in 
an old Fedora Core 2 server whose Firebird package is not NPTL.

  As you, Damyan, suspected previously, NPTL has to do with the problem.

  In a previous answer you told me that, after inspecting the binary 
with the "$ldd fbserver" command, you concluded that 
firebird-super-server build for debian was not NPTL. On the other hand, 
in my debian server I have the following situation:

Debian Etch.
kernel: 2.6.18-4-686 #1 SMP
NPTL 2.3.6 ( I got this info with the command "getconf 
GNU_LIBPTHREAD_VERSION" )

So, fbserver uses pthread (old model) while the kernel uses NPTL, and 
hence, as Helen says, SCH_validate error can happen, blocking the server 
( you have to restart it ).

My question is:
Why is there only one alternative in Debian instead of two as there are 
in the original .tar.gz or .rpm packages from Firebird Super Server ( 
old threaded model and NTPL ) ? Looking at Firebird official download 
page, I found they have two choices for Super Server.

If this is the case for Debian, the only solution I have is using 
Classic Server, which, I hope, doesn't conflict with the threading model.

Thanks for any answer.
Aldo