Subject Re: [firebird-support] Firebird Hang
Author Helen Borrie
At 12:48 AM 25/09/2006, you wrote:
>Hello firebird-support,
>1. I use firebird at Windows 2003 Enterprise. Everything is
> OK until this month i received message (at firebird.log) below 5
> times in a day:
>STEEL (Server) Wed Sep 13 13:02:13 2006
> SRVR_multi_thread/RECEIVE: error on main_port, shutting down

This is not hanging, it is stopping.

> All client can't connected to firebird server until the firebird
> service restarted (uninstall it then install_super again).

Why do you uninstall it? Why not just stop and restart the Guardian service?

> I've tried to add the following key:
> KEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters
> with the key: TcpNumConnections=1000
> but still get the same error.

If the server crashing is caused by overwhelming the resources of the
host machine, this is likely to make it worse, not better.

>2. One more things, my firebird server often error with the message:
> STEEL (Client) Wed May 17 14:39:57 2006
> D:\Programs\Firebird\Firebird_1_5\bin\fbserver.exe:
> terminated abnormally (4294967295)

That's a crash.

> This error had been occured before the first problem above. But, for
> these 2 months, the errors occured rarely.

In another posting you eliminated a bad UDF as the cause.

Tell us something about the memory resources on the host machine and
about the number of concurrent users logged in when the crashes occur.

Have you done any monitoring of transaction statistics, using gstat -h?

What kind of housekeeping regime do you have? (gbak backups, sweeps?)

What page size are you working with? and what is page buffer size?

etc., etc.