Kbase P27894: Errors 9952 and 9953 when starting client session
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/07/2003 |
|
Status: Unverified
FACT(s) (Environment):
HP-UX 11.0 64-bit
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
Error 9952 when starting client session
Error 9953 when starting client session
The user requested <number of private buffers> private read only buffers, but only <number of available buffers> were available. (9952)
The user requested <number of private buffers> private read only buffers, but none were available. (9953)
CAUSE:
The user requested a number of private, read only buffers using either the -Bp startup option or by assigning a value to the _MyConnection._MyConn-NumSeqBuffers Virtual System Table (VST).
Each user can request up to 64 private, read only buffers, as long as the total number of requested buffers for all users does not exceed 25% of the -B (Blocks in Database Buffers) startup option that was specified when starting this database.
Prior to 91C, the max value was 64, regardless of what the -B value was.
FIX:
1. If using a Progress version below 9.1C, there is no possibility to increase the number of private read-only buffers beyond 64. This is the maximum value for -Bp.
2. If using 9.1C or above, specify the -Bpmax. What the -Bpmax parameter enables is for Progress to be able to use up to 25% of -B as private read-only buffers.
See also: What is the Maximum Private Buffers per Connection (-Bpmax) parameter
An example, tested with 91D06 on HP-11 64-bit -
1. proserve sports -B 256
2. mpro sports -Bp 64
3. Running -
/* checkbp.p */
FIND _MyConnection.
DISP _MyConnection._MyConn-NumSeqBuffers.
gives result 64.
4. Try to start a second session with -Bp 64, get:
The user requested 64 private read only buffers, but none were available. (9953)
5. Session starts ok though, run checkbp.p, returns a value of 0.
Without specifying -Bpmax:
1. proserve sports -B 400
2. mpro sports -Bp 100 returns the 9952 error:
The user requested 100 private read only buffers, but only 64 were available. (9952)
If you restart the database with proserve sports -B 400 -Bpmax 100 you can then connect a client ok with -Bp 100.