Consultor Eletrônico

Status: Verified

FACT(s) (Environment):

Progress 9.1D

SYMPTOM(s):

The server or the system has no more resources. Try a larger -n. (748)

No servers are available. Try again later. (1154)

Error 748 on the client and 1154 in the log file

-Mn x -Ma < -n

Database started with non-default Message Buffer Size -Mm session parameter

Client session started WITHOUT Message Buffer Size -Mm session parameter

Client session started with default Message Buffer Size -Mm session parameter 1024

Server has -Mm parm <size> and client has <size>. They must match. (1150)

Server has -Mm param 8192 and client has 1024. They must match (1150)

Client connection fails with error 1150 as expected

After the product of -Ma x -Mn failed connections are made (1150) no more connections can be made to the database.

CAUSE:

BUG# 20030721-005

CAUSE:

The server believes that there are still pending connections - connections that are initiated but are never completed.

FIX:

Initially, restart the database to initially address this issue by clearing out the pending connections.
Thereafter;
Apply Progress 9.1D08 Service Pack where this issue was addressed by decrementing the pending connections count should the remote client connection not complete.

or
Consider using the -PendConnTime <seconds> startup parameter on the broker. When this parameter is used, then after <seconds> time has passed since the last connection attempt, the servers will clear any pending connections that have not completed and free up user slots.

For example: if "-PendConnTime 10" was added to the startup.pf file and then after -Mn * -Ma connections the (1154) message would appear (as expected), but after 10 seconds, the pending connections would get cleared and connections would be able to be made again.

The pending connections value for the servers is in:
promon -> R&D -> 1. Status Displays -> 3. Servers