Subject Firebird hangs in the server
Author SP Ooi

Looking for some help here.

We run Firebird on Redhat Linux platform. Our Firebird
services hangs up every now and then. Each time, we have to kill all
Firebird related processes and followed by fb_lock_mgr process last.
Next Firebird process that comes up will come up fine until next hang up.

Any idea why?

I have collected some gdb information on a hang process today:

(gdb) where
#0 0xffffe410 in __kernel_vsyscall ()
#1 0x00be23ab in semop () from /lib/tls/
#2 0xf76e3866 in ISC_mutex_lock () from /usr/lib/
#3 0xf77ee0c7 in LOCK_write_data () from /usr/lib/
#4 0xf77eec8c in LOCK_write_data () from /usr/lib/
#5 0xf77ed1ae in LOCK_init () from /usr/lib/
#6 0xf777d338 in LCK_init () from /usr/lib/
#7 0xf777096f in jrd8_attach_database () from /usr/lib/
#8 0xf76e9ac9 in isc_attach_database () from /usr/lib/
#9 0x080abd4c in ibase_db_open ()
#14 0x08066c2a in main ()
(gdb) quit

Has anybody experienced this same symptom?