Kbase P6113: 782 error message, when connection to multiple database.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
FACT(s) (Environment):
UNIX
Progress 7.X
Progress 8.X
Progress 9.X
SYMPTOM(s):
Connecting to a database fails.
Socket number <num> is too large; it cannot be greater than <num>. (782)
Socket number 1287 is too large; it cannot be greater than 1023. (782)
Able to establish shared memory connections to 5 databases.
Remote connection to a 6th database fails with error.
Can connect to all databases separately.
Only encounters problem when attempting multiple database connections.
CHANGE:
Added extents to all databases.
CAUSE:
There is an internal limit within a client code - 1024 file descriptors only can be accessed within a session.
FIX:
Decrease the number of extents within your database structure.
Example: Having 1000 extents with 20 MB size (20 GB) - create 10 extents having fixed length 2 GB per extent, which will decrease the number of file descriptions in use.
Alternatively you can connect to the "last" database using client-server (-N -S -H) as the number of file descriptors in use will be reduced.