Kbase P128848: Database log shows 9446, 10831 and 10833 errors generated by client connection with no user number.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
14/04/2010 |
|
Status: Unverified
SYMPTOM(s):
Database log shows 9446, 10831 and 10833 errors generated by client connection with no user number.
Database is in multi-user mode.
Single user client connection is made using -RO switch.
[2008/01/25@04:41:53.928-0500] P-2230 T-1 I : (10831)
SYSTEM ERROR: Record continuation not found, fragment recid 2948981 area
54 3.
[2008/01/25@04:41:56.121-0500] P-2230 T-1 I : (10833)
SYSTEM ERROR: Invalid record with recid 19521194 area 54 1.
SYSTEM ERROR: <bkioWrite>: Bad file descriptor was used during <Write>, fd <file descriptor>, len <bytes>, offset <bytes>, file <file-name>. (9446)
SYSTEM ERROR: Record continuation not found, fragment recid <recid> area <areanum> <msg-inst> . (10831)
SYSTEM ERROR: Invalid record with recid <recid> area <area-num> <inst-num>. (10833)
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
CAUSE:
A read only connection to a database (using the -RO switch) caches information from the database at the time it makes its connection to the database.
If changes are made to the database, the information that was cached by the -RO client will likely be out of date and no longer valid and the read-only
session may generate errors due to stale pointers it cached when it initially connected. This is fully expected and informational only. As long as anyone
makes changes to data as it is now, the read-only clients will get the errors.
FIX:
1.The best option to avoid these errors is to use the OpenEdge Replication product (contact your account representative for more details).
2. Make a copy of the database (maybe daily) for just the read-only clients, so no changes will be made to it.
3. Disconnecting and reconnecting to the database should temporarily clear the errors.
4. If read-only users ignore the errors they will be ok but just won?t see any changes until they reconnect.