* database is located on the same disk
* It is firebird superserver 1.5.2 running on Debian
* clients are windows and linux boxes
* ~30 client PCs which are connecting to the server with 10 sek interval
they are located on local network
* connection string(something like this?):
firebird://user:pass@.../mydb
* terminal? nop
* I use rfunc UDF

check lsof output, pay attention to lines which indicates ESTABLISHED
connection, those two PCs are switched off(even netstat shows that there
is a connection)! Server somehow doesn't close those connections and
craches after some time, I have to kill it with -9. I can't do a lot of
debuggin(server is being used very intensive), but if you tell me what
data should I collect, I can do that.

btw, maybe dabase server is confused somehow because I have three
network interfaces with same IP. But I don't think that that is a problem.

fbserver 28371 root cwd DIR 8,1 4096 114017 /tmp
fbserver 28371 root rtd DIR 8,1 4096 2 /
fbserver 28371 root txt REG 8,1 2208072 146597
/opt/firebird/bin/fbserver
fbserver 28371 root mem REG 8,1 656428 146686
/opt/firebird/intl/fbintl
fbserver 28371 root mem REG 8,1 9128 539318
/lib/libuuid.so.1.2
fbserver 28371 root mem REG 8,1 3660 146691
/opt/firebird/lib/libib_util.so
fbserver 28371 root mem REG 8,1 51889 146598
/opt/firebird/UDF/rfunc
fbserver 28371 root mem-R REG 8,1 262144 146742
/opt/firebird/isc_lock1.KafeServer
fbserver 28371 root mem REG 8,1 34748 539351
/lib/tls/libnss_files-2.3.2.so
fbserver 28371 root mem REG 8,1 33440 539353
/lib/tls/libnss_nis-2.3.2.so
fbserver 28371 root mem REG 8,1 73304 539348
/lib/tls/libnsl-2.3.2.so
fbserver 28371 root mem REG 8,1 28648 539349
/lib/tls/libnss_compat-2.3.2.so
fbserver 28371 root mem REG 8,1 32324 538284
/lib/libgcc_s.so.1
fbserver 28371 root mem REG 8,1 78233 539356
/lib/tls/libpthread-0.60.so
fbserver 28371 root mem REG 8,1 9872 539345
/lib/tls/libdl-2.3.2.so
fbserver 28371 root mem REG 8,1 1253924 539343
/lib/tls/libc-2.3.2.so
fbserver 28371 root mem REG 8,1 134464 539346
/lib/tls/libm-2.3.2.so
fbserver 28371 root mem REG 8,1 18876 539344
/lib/tls/libcrypt-2.3.2.so
fbserver 28371 root mem REG 8,1 252592 538277
/lib/libncurses.so.5.4
fbserver 28371 root mem REG 8,1 737816 928592
/usr/lib/libstdc++.so.5.0.7
fbserver 28371 root mem REG 8,1 90088 539305
/lib/ld-2.3.2.so
fbserver 28371 root 0u IPv4 5828710 TCP
*:gds_db (LISTEN)
fbserver 28371 root 1u REG 8,1 6799360 1075022
/opt/firebird/db/lt_01.fdb
fbserver 28371 root 2uR REG 8,1 262144 146742
/opt/firebird/isc_lock1.KafeServer
fbserver 28371 root 4u REG 8,1 4669440 146735
/opt/firebird/security.fdb
fbserver 28371 root 5u IPv4 6029964 TCP
kafe.lintech.lv:gds_db->62.85.xx.xx:2857 (ESTABLISHED)
fbserver 28371 root 6r DIR 8,1 4096 146685
/opt/firebird/intl
fbserver 28371 root 7u IPv4 6055751 TCP
kafe.lintech.lv:gds_db->62.85.xx.xx:3314 (ESTABLISHED)
fbserver 28371 root 9r REG 8,1 132796 146732
/opt/firebird/firebird.msg


Helen Borrie wrote:

>At 03:06 PM 14/02/2005 +0200, you wrote:
>
>
>
>>What can couse these errors? and this one too:
>>
>> INET/inet_error: select in packet_receive errno = 9
>>
>>btw, my firewall doesn't block any ports..
>>
>>
>
>If it did block the Firebird service port, you wouldn't be able to connect
>at all.
>
>You didn't answer this question:
>
> >> Do you have the database file on a mounted filesystem (Windows: share
>or mapped drive) ?
>
>It would also help to mention
>--- the OS platform
>-- the server model (Classic/Superserver)
>-- where the clients are located
>-- what is the connection string being used by the clients
>-- if clients are on Linux, which client library they are using
>-- whether the host machine is also hosting a terminal server.
>-- whether any client queries are calling UDFs and, if so, where the UDFs
>came from
>
>./hb
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>