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

TTL monitoring logs on system profile

XMLWordPrintableJSON

    • Type: Icon: Bug Bug
    • Resolution: Done
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: 5.0.4
    • Component/s: None
    • ALL
    • Hide

      From mongosh :

      • run `use database-test`
      • run `db.setProfilingLevel(2)`
      • run `db.eventlog.createIndex( { "lastModifiedDate": 1 }, { expireAfterSeconds: 30 } )`
      • run `db.eventlog.insertOne({ lastModifiedDate: new Date() })`
      • Wait one minute
      • run `db.system.profile.find()`
      • There are no information about TTL monitoring
      Show
      From mongosh : run `use database-test` run `db.setProfilingLevel(2)` run `db.eventlog.createIndex( { "lastModifiedDate": 1 }, { expireAfterSeconds: 30 } )` run `db.eventlog.insertOne({ lastModifiedDate: new Date() })` Wait one minute run `db.system.profile.find()` There are no information about TTL monitoring

      Hello,

      I'm using TTL Indexes (https://docs.mongodb.com/manual/core/index-ttl/#expiration-of-data) The deleting works fine but I want to log the data removed.

      The doc say : `When the TTL thread is active, you will see delete operations in the output of db.currentOp() or in the data collected by the database profiler.` 

      When I display the system profile, There are no information about the TTL and I need to log the trace of the remove.

      I set the profiling level to 2.

      Do you know if it's a bug or I didn't understand the monitoring ?

            Assignee:
            dmitry.agranat@mongodb.com Dmitry Agranat
            Reporter:
            pj-martin@outlook.fr Pierre-Jean Martin
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: