Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-32154

Unbounded lookaside table growth during insert workload

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Fixed
    • Affects Version/s: 3.6.0-rc8
    • Fix Version/s: 3.6.6, 4.0.0
    • Component/s: Storage
    • Labels:
      None
    • Backwards Compatibility:
      Fully Compatible
    • Operating System:
      ALL
    • Case:

      Description

      1-node repl set, SSD, 50 GB oplog, 4 GB cache, 5 threads inserting 130 kB docs.

      It appears that the lookaside table, both number of entries and size of WiredTigerLAS.wt ("csv size" metric), grows without bound during a heavy write workload. Even after the workload is stopped the table doesn't shrink.

      FTDC data attached.

        Attachments

        1. dd-rc8-small.tar
          687 kB
          Bruce Lucas
        2. growth.png
          146 kB
          Bruce Lucas
        3. index-build.png
          162 kB
          Bruce Lucas
        4. Screen Shot 2017-12-15 at 4.12.53 pm.png
          462 kB
          Alexander Gorrod

          Issue Links

          depends on

          Improvement - An improvement or enhancement to an existing feature or task. WT-3766 Lookaside sweep for obsolete updates

          • Major - P3 - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. WT-3911 Ignore lookaside data on shutdown

          • Major - P3 - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. WT-3937 Tune lookaside sweep to react to workload

          • Major - P3 - Major loss of function.
          • Closed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. SERVER-32139 Oplog truncation creates large amount of dirty data in cache

          • Major - P3 - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. WT-3766 Lookaside sweep for obsolete updates

          • Major - P3 - Major loss of function.
          • Closed

            Activity

              People

              Assignee:
              backlog-server-execution Backlog - Storage Execution Team
              Reporter:
              bruce.lucas Bruce Lucas
              Participants:
              Votes:
              0 Vote for this issue
              Watchers:
              14 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: