Reading fast truncated pages in a readonly database can lead to cache stuck

XMLWordPrintableJSON

    • None
    • 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.

              Assignee:
              Haribabu Kommi
              Reporter:
              Haribabu Kommi
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Created:
                Updated:
                Resolved: