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

Unbounded lookaside table growth during insert workload

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major - P3
    • Resolution: Fixed
    • 3.6.0-rc8
    • 3.6.6, 4.0.0
    • Storage
    • None
    • Storage Execution
    • Fully Compatible
    • ALL

    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

              backlog-server-execution Backlog - Storage Execution Team
              bruce.lucas@mongodb.com Bruce Lucas (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              14 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: