Kbase P14797: Single user session with -B 100000 gets error 1083
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Unverified
SYMPTOM(s):
In single user mode, -B 100000 causes error 1083
SYSTEM ERROR: Number of private slots in segment table exhausted (1083).
Same value for -B works fine for Database Server start
CAUSE:
The single user process requires additional shared memory segments compared to the database broker, "proserve".
A single user process does:
. go through crash recovery
. initialized the shared memory segment with the buffer pool (sized by -B)
. load the programs it has to run
. run these programs, store values to variables, keep in memory some PERSISTENT procedures,....
The database broker does:
. go through crash recovery
. initialize the shared memory segment with the buffer pool (sized by -B) and other areas such as the "process tables" (sized by "-n")
. listen to any remote connection request and serve them (i.e. spawn a remote server if requested, "attach" the remote client to a remote server)
. do the "watchdog" job if there is no such process started manually (prowdog)
FIX:
Start the single user process with a lower value for "-B".
"100000" database blocks kept in memory for one process does not seem realistic.