Kbase P141458: Getting 789 error when starting a database after adding extents to a database.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/02/2009 |
|
Status: Unverified
SYMPTOM(s):
Getting 789 error when starting a database after adding extents to a database.
Created socket, number is <socket-number>. Cannot accept socket 0 or greater than <MAXFD-1>. (789)
Created socket, number is 1032. Cannot accept socket 0 or greater than 1023. (789)
FACT(s) (Environment):
Database has more than 1000 extents
Operating system allows for 2048 maximum files to be opened by a process.
IBM AIX
OpenEdge 10.0B
CHANGE:
Added additional extents to a database to allow the database to continue to grow.
CAUSE:
Bug# OE00110620
FIX:
The MAXFD value within OpenEdge 10.0B is 1024 -1= 1023 file descriptors. The value 1023 does not mean that a database can contain 1023 extents. Rather the total number of extents / sockets that a process can open depends upon workfiles, stdin, stdout and stderr as well as database startup parameters. The following is a general formula that can be used when trying to access the actual number of files / sockets that a client or server process can use:
Use the following formula to determine the number of file handles used:
H = Static Handles + (# of .dn files) + (# of .bn files) + (# of .an files)
H
The number of file handles the OpenEdge RDBMS uses.
Static Handles
The number of handles allocated for any OpenEdge database. The number of static file handles that the process requires depends on whether you are running a client process or a server process:
Client - Requires nine file handles (PROMSGS + LG + DB + LBI + SRT+ STDIN STDOUT + 2). The file handles used for the input and output devices (STDIN and STDOUT) are allocated by the operating system.
Server - Requires five handles (PROMSGS + LG + DB + 2).
# of .dn files
The number of DB files defined for the database.
# of .bn files
The number of BI files defined for the database.
# of .an files
The number of AI files defined for the multi-volume database.
When calculating the number of file handles, consider the following exceptions:
If you are running a server in a UNIX environment that uses sockets for interprocess communication, add one file handle for each user.
Application programs use additional file handles when reading and writing text files and when compiling programs. The formula does not account for these additional resource requests.