remk_1 wrote:

>> That's one of the internal "can't happen" errors. For
>> reasons unclear to me, only 20 transactions are
>> allowed to share a single page in cache.
>
> If it means that only 20 transactions can modify one record (or even
> several records of the page) at the same time, it could probably
> explain the error. We use several tables with just a few records that
> are changed so often that we may get over the limit before the
> transactions are committed.
>

Well, it wouldn't be twenty plus transactions updating the
same record. Concurrent transactions can't modify a single
record. On the other hand, you might hit that limit if each
transaction modified a different record and all the records
happened to be on the same page. But, as I said, I haven't
tracked through all the code to see where the limit is
enforced.

What page size are you using?

Regards,


Ann