What causes bug 10261571, ROW COUNT DIFFERS BETWEEN TABLE AND MATERIALIZED VIEW? (Doc ID 1314808.1)

Last updated on MARCH 02, 2016

Applies to:

Oracle TimesTen In-Memory Database - Version 11.2.1 and later
Information in this document applies to any platform.
***currency checked 03-Nov-2014 **

Symptoms

Two types of error messages have been associated with this bug:


2010-11-29 08:21:21.99 Err : : 24614: 21574/0xaf35cb0: sbXactReclaim: failed in reclaim at line 7395. nprocessed = 0, rclmCnt = 5, smallHdr->type = 8, savedLR = 0xf12650e0
2010-11-29 08:21:21.99 Err : : 24614: 21574/0xaf35cb0: Reclaim failed in commit (error 908) while processing LSN 2413.7250984. 1 error messages follow.
2010-11-29 08:21:21.99 Err : : 24614: 21574/0xaf35cb0: TT0908: Key not found in table or index -- file "ttree.c", lineno 4292, procedure "sbTtDelete"


and a difference in row numbers between a detail table and a view built on it, which can lead to the following type of Assertion:


4053: Internal error: Assertion failed: ((((sbCurHdr_p)cur)->state) == sbCurStEmpty) [index.c:4.587:sbIxCurNext():7784] PID 26954 (ttIsqlCmd) CONN 2 (m4_db) 2010-05-07 10:22:27.678





Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms