I've just upgraded a the server from Fb/0.9.5 to Fb/1.0 (build 821), and
restored the database under the new server.
After a few hours, there was no memory left. Any new connection was
denied, and trying to start Windows Explorer was not a success. Reboot
cleared the problem of course, but only for a short time (of course).
Then, the following patches were installed:
. Windows NT 4.0 Security Patch: Multiple NNTP Posts
can consume Memory - q304876 - 1.104 kb
. Windows NT 4.0 Security Patch: Memory Leak in SNMP
Vulnerability - Q314147 - 159 kb
I don't know whether these are relevant, but after patching everything
seemed to work fine. However, the next day there were problems. New
connections were denied, but the current ones were allowed to continue as
before. Once disconnected, it was not possible to make a new connection.
Trying to copy the log file to another machine gave "too low system resources".
The last error messages in the log before rebooting were:
-------------------------
FILMINFO_SERVER (Server) Tue Sep 17 13:55:07 2002
INET/inet_error: read errno = 10058

FILMINFO_SERVER (Server) Tue Sep 17 13:56:22 2002
INET/inet_error: read errno = 10038

FILMINFO_SERVER (Server) Tue Sep 17 13:57:40 2002
INET/inet_error: select in packet_receive errno = 10038

FILMINFO_SERVER (Client) Tue Sep 17 16:01:45 2002
INET/inet_error: connect errno = 10055

FILMINFO_SERVER (Client) Tue Sep 17 16:01:47 2002
INET/inet_error: connect errno = 10055

FILMINFO_SERVER (Client) Tue Sep 17 16:03:44 2002
INET/inet_error: connect errno = 10055

FILMINFO_SERVER (Client) Tue Sep 17 16:03:46 2002
INET/inet_error: connect errno = 10055
-------------------------

The database is accessed from one or two local computers (by TCP/IP) and
some other computers over Internet. The setup has worked fine for a long
time, first with IB/5.x and later with Firebird. The server runs on
WinNT4WS/SP6, the clients are Win/95 (was upgraded to WinSock2 in the
process) and Win/98, maybe Win2k as well. Client s/w (gds32.dll) was
upgraded when the server was upgraded (I'll check this again, the server is
in Norway, but some clients are located in Sweden - I hope they all
followed instructions ...).

Other info:
Page size: 8KB, Cache pages 8192.
Sweep interval: 0.
Forced writes: ON.
Dialect: 3.
Database size: 800MB.
Server memory; 256MB. (I think).
Server proc: PII/266. (I think).
gbak and sweep is usually run every night. This seems to have (mostly?)
failed after the upgrade.


Any clues?
Any (more) relevant MS patches?


Regards,
Aage J.