Kbase P87751: Error 2523 for a user requesting no lock
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
GOAL:
Error 2523 for a user requesting no lock
GOAL:
Why is it possible to get "User <num> died with 1 buffers locked. (2523)" when user <num> is a SQL92 client running SELECTs with transaction isolation level Read Uncommitted
FIX:
The "buffer locked" referenced in message 2523 is for a database block within the buffer pool.
As soon as a database server is started, all database blocks are accessed from within the buffer pool by all processes.
The processes concerned are: _mprosrv, _sqlsrv2 or _progres.
When a process needs to read a record, then it puts a lock on the block containing that record. No change within the block may occur when the process reads
1. from the data block header, the address of the record within the block
2. within the block, the record