|
|
|
After automatic recovery, record inserts unexpectedly failed with duplicate key errors on the c-treeACE SQL ROWID index. and these eventually succeeded after several retries. It was determined a transaction log entry was missing under specific circumstances of an update to a partitioned file serial segment value, used by the internal ROWID field. These files had recently undergone automatic recovery to to a prior server crash resulting in the header value of the file not in sync with the highwater mark of the file. This has been corrected by ensuring the log entry is correctly written.
Note: While this involved automatic recovery, data and index values maintained integrity. Only the serial segment file header value was affected. The symptom would be unexpected duplicate key entries, and eventually succeeding after several attempts as this value is incremented.
