[Firebird-devel] Problems shutting down (a heaviliy loaded) firebird database again

[<bjo...@rr...>]

Hello,

  as I didn't get an answer last year on support lsit I'll try it on developer list today as I've got the same error messages trying to shut down classic server on Linux.

Here is the content of firebird.log from this morning:


rzdb5   Fri Mar 30 08:37:55 2012
        Shutting down the server with 1 active connection(s) to 1 database(s), 0 active service(s)


rzdb5   Fri Mar 30 08:38:00 2012
        Firebird shutdown is still in progress after the specified timeout


rzdb5   Fri Mar 30 08:38:00 2012
        Operating system call pthread_mutex_destroy failed. Error code 16


rzdb5   Fri Mar 30 08:38:58 2012
        Shutting down the server with 1 active connection(s) to 1 database(s), 0 active service(s)


rzdb5   Fri Mar 30 08:38:58 2012
        Shutting down the server with 1 active connection(s) to 1 database(s), 0 active service(s)


rzdb5   Fri Mar 30 08:38:58 2012
        Shutting down the server with 1 active connection(s) to 1 database(s), 0 active service(s)


rzdb5   Fri Mar 30 08:38:58 2012
        Shutting down the server with 1 active connection(s) to 1 database(s), 0 active service(s)


rzdb5   Fri Mar 30 08:39:03 2012
        Firebird shutdown is still in progress after the specified timeout


rzdb5   Fri Mar 30 08:39:03 2012
        Operating system call pthread_mutex_destroy failed. Error code 16


rzdb5   Fri Mar 30 08:39:03 2012
        Firebird shutdown is still in progress after the specified timeout


rzdb5   Fri Mar 30 08:39:03 2012
        Operating system call pthread_mutex_destroy failed. Error code 16


rzdb5   Fri Mar 30 08:39:03 2012
        Firebird shutdown is still in progress after the specified timeout


rzdb5   Fri Mar 30 08:39:03 2012
        Operating system call pthread_mutex_destroy failed. Error code 16


rzdb5   Fri Mar 30 08:41:13 2012
        Shutting down the server with 1 active connection(s) to 1 database(s), 0 active service(s)


rzdb5   Fri Mar 30 08:45:18 2012
        INET/inet_error: read errno = 104


rzdb5   Fri Mar 30 08:52:59 2012
        Shutting down the server with 1 active connection(s) to 1 database(s), 0 active service(s)


rzdb5   Fri Mar 30 08:53:33 2012
        Shutting down the server with 1 active connection(s) to 1 database(s), 0 active service(s)

--

System Infos:
rzdb5 FAU/firebird> uname -a
Linux rzdb5 2.6.32.54-0.3-default #1 SMP 2012-01-27 17:38:56 +0100 x86_64 x86_64 x86_64 GNU/Linux

rzdb5 FAU/firebird> ./bin/fb_inet_server -Z
Firebird TCP/IP server version LI-V2.5.1.26351 Firebird 2.5



Only resetting the machine worked this morning for recovery. 



Dies ist eine weitergeleitete Nachricht
Von    : Björn Reimer <bjo...@rr...>
An     : fir...@ya..., fir...@ya...
Datum  : Mittwoch, 14. September 2011, 16:04
Betreff: [firebird-support] Problems shutting down a heaviliy loaded firebird database

===8<=================== Original Nachrichtentext ===================
Additional Info:


The error "Operating system call pthread_mutex_destroy failed. Error code 16" was repeated 657 times which was the number of hanging processes after initiating shutdown.

The used firebird architecture is clasic server of course.


> Hello,

>   trying to shut down a heavily loaded database (670 concurrent connections but hardly
> any running statements) I'm getting the following errors in firebird.log:

> [...]
> rzdb6   Wed Sep 14 13:38:04 2011
>         Firebird shutdown is still in progress after the specified timeout


> rzdb6   Wed Sep 14 13:38:04 2011
>         Firebird shutdown is still in progress after the specified timeout


> rzdb6   Wed Sep 14 13:38:04 2011
>         Operating system call pthread_mutex_destroy failed. Error code 16


> rzdb6   Wed Sep 14 13:38:04 2011
>         Operating system call pthread_mutex_destroy failed. Error code 16


> rzdb6   Wed Sep 14 13:38:04 2011
>         Operating system call pthread_mutex_destroy failed. Error code 16


> rzdb6   Wed Sep 14 13:38:04 2011
>         Firebird shutdown is still in progress after the specified timeout
> [...]


> after waiting some minutes with repeating messages like above I've had to use 
> killall -u firebird 
> to stop the stuff which causes some orphan pages and orphan backversions :-(


> System infos:
> rzdb6 /data/firebird# uname -a
> Linux rzdb6 2.6.32.13-0.4-default #1 SMP 2010-06-15 12:47:25 +0200 x86_64 x86_64 x86_64 GNU/Linux

> rzdb6 /data/firebird# ./bin/fb_inet_server -Z
> Firebird TCP/IP server version LI-V2.5.0.26074 Firebird 2.5


> Any idea what could have gone wrong?




===8<============== Ende des Original Nachrichtentextes =============

-- 
Björn Reimer - RRZE