Subject Re: [firebird-support] Questions about SuperServer
Author Milan Babuskov
Fabiano Bonin wrote:
> I have just installed FB SS 2.0 RC3 on a Linux Slackware server

Which Slackware version? Did you install NTPL build?

> estabilishing just one connection to a database, i see:

I installed FB SS NTPL 2.0 RC3 on Slackware 10.2 using .tar.gz package
from Firebird website. (I run Classic all the time, but had to check
now). Upon one connection to database, I see:

root@asus:~# fuser /opt/firebird/examples/empbuild/employee.fdb
/opt/firebird/examples/empbuild/employee.fdb: 1842

As, you can see, only one attachment.

> root@servidor:/dados# fuser *
> trevilub.fdb.2.0: 24403 24404 24405 24406 24407 24408 24410 24411

Either you are not using proper build, or the application that has
connected has made multiple attachments to the same database.

> Is it expected to have all these connections to the database?

No.

> Also, i see many instances of fbserver running:
> root@servidor:/dados# ps -e | grep fb
> 24402 ? 00:00:00 fbguard
> 24403 ? 00:00:00 fbserver
> 24404 ? 00:00:00 fbserver
> 24405 ? 00:00:00 fbserver
[...]

As Helen explained, there are cases when this can be normal. Although, I
don't see it in my setup:

root@asus:~# ps -e | grep fb
1841 ? 00:00:00 fbguard
1842 ? 00:00:00 fbserver

> I noted also that "/etc/rc.d/rc.firebird stop" is not killing the server:
>
> root@servidor:/dados# /etc/rc.d/rc.firebird stop
> Stopping Firebird server:
> root@servidor:/dados# ps -e | grep fb
> 24402 ? 00:00:00 fbguard
> 24431 ? 00:00:00 fbserver
> 24432 ? 00:00:00 fbserver
> 24433 ? 00:00:00 fbserver
> 24434 ? 00:00:00 fbserver
> 24435 ? 00:00:00 fbserver
> root@servidor:/dados#

root@asus:~# /etc/rc.d/rc.firebird stop
Stopping Firebird server:
root@asus:~# ps -e | grep fb
root@asus:~#

--
Milan Babuskov
http://swoes.blogspot.com/
http://www.flamerobin.org