-
Type: Bug
-
Resolution: Fixed
-
Priority: Major - P3
-
Affects Version/s: None
-
Component/s: None
The table having fast truncated pages from a previous session and reading them in a read-only database environment can lead to cache stuck as the instantiated deleted pages cannot evict until the truncate operation is globally visible.
1. Create a table and insert 10000 keys
2. Close and open the database.
3. Perform truncate operation, this will do a fast truncate.
4. Reopen the database in a read-only environment.
5. Read the key values before the truncate command. This operation fails as the cache gets full with all the instantiated deleted pages.