Time Series Collection

XMLWordPrintableJSON

    • Type: Bug
    • Resolution: Duplicate
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Server Triage
    • ALL
    • Hide

      db.createCollection(
          "weather27h1",
          {
             timeseries:

      {           timeField: "timestamp",           metaField: "metadata",           granularity: "hours"        }

      ,
             expireAfterSeconds: 86400
          }
      )
       
      db.weather27h1.insertMany( [
         

      {       "metadata": \{ "sensorId": 5578, "type": "temperature" }

      ,
            "timestamp": ISODate("2023-08-10T00:00:00.000Z"),
            "temp": 12
         },
         

      {       "metadata": \{ "sensorId": 5578, "type": "temperature" }

      ,
            "timestamp": ISODate("2023-08-10T04:00:00.000Z"),
            "temp": 11
         },
         

      {       "metadata": \{ "sensorId": 5578, "type": "temperature" }

      ,
            "timestamp": ISODate("2023-08-10T08:00:00.000Z"),
            "temp": 11
         },
         

      {       "metadata": \{ "sensorId": 5578, "type": "temperature" }

      ,
            "timestamp": ISODate("2023-08-10T12:00:00.000Z"),
            "temp": 12
         },
         

      {       "metadata": \{ "sensorId": 5578, "type": "temperature" }

      ,
            "timestamp": ISODate("2023-08-10T16:00:00.000Z"),
            "temp": 16
         },
         

      {       "metadata": \{ "sensorId": 5578, "type": "temperature" }

      ,
            "timestamp": ISODate("2023-08-17T20:00:00.000Z"),
            "temp": 15
         },

      {       "metadata": \{ "sensorId": 5578, "type": "temperature" }

      ,
            "timestamp": ISODate("2023-08-19T00:00:00.000Z"),
            "temp": 13
         },
         

      {       "metadata": \{ "sensorId": 5578, "type": "temperature" }

      ,
            "timestamp": ISODate("2023-08-19T04:00:00.000Z"),
            "temp": 12
         },
         

      {       "metadata": \{ "sensorId": 5578, "type": "temperature" }

      ,
            "timestamp": ISODate("2023-08-19T08:00:00.000Z"),
            "temp": 11
         },
         

      {       "metadata": \{ "sensorId": 5578, "type": "temperature" }

      ,
            "timestamp": ISODate("2023-08-19T12:00:00.000Z"),
            "temp": 12
         },
         

      {       "metadata": \{ "sensorId": 5578, "type": "temperature" }

      ,
            "timestamp": ISODate("2023-08-19T16:00:00.000Z"),
            "temp": 17
         },
         

      {       "metadata": \{ "sensorId": 5578, "type": "temperature" }

      ,
            "timestamp": ISODate("2023-08-19T20:00:00.000Z"),
            "temp": 12
         }
      ] )
       
       

      Show
      db.createCollection(     "weather27h1",     {        timeseries: {           timeField: "timestamp",           metaField: "metadata",           granularity: "hours"        } ,        expireAfterSeconds: 86400     } )   db.weather27h1.insertMany( [     {       "metadata": \{ "sensorId": 5578, "type": "temperature" } ,       "timestamp": ISODate("2023-08-10T00:00:00.000Z"),       "temp": 12    },     {       "metadata": \{ "sensorId": 5578, "type": "temperature" } ,       "timestamp": ISODate("2023-08-10T04:00:00.000Z"),       "temp": 11    },     {       "metadata": \{ "sensorId": 5578, "type": "temperature" } ,       "timestamp": ISODate("2023-08-10T08:00:00.000Z"),       "temp": 11    },     {       "metadata": \{ "sensorId": 5578, "type": "temperature" } ,       "timestamp": ISODate("2023-08-10T12:00:00.000Z"),       "temp": 12    },     {       "metadata": \{ "sensorId": 5578, "type": "temperature" } ,       "timestamp": ISODate("2023-08-10T16:00:00.000Z"),       "temp": 16    },     {       "metadata": \{ "sensorId": 5578, "type": "temperature" } ,       "timestamp": ISODate("2023-08-17T20:00:00.000Z"),       "temp": 15    }, {       "metadata": \{ "sensorId": 5578, "type": "temperature" } ,       "timestamp": ISODate("2023-08-19T00:00:00.000Z"),       "temp": 13    },     {       "metadata": \{ "sensorId": 5578, "type": "temperature" } ,       "timestamp": ISODate("2023-08-19T04:00:00.000Z"),       "temp": 12    },     {       "metadata": \{ "sensorId": 5578, "type": "temperature" } ,       "timestamp": ISODate("2023-08-19T08:00:00.000Z"),       "temp": 11    },     {       "metadata": \{ "sensorId": 5578, "type": "temperature" } ,       "timestamp": ISODate("2023-08-19T12:00:00.000Z"),       "temp": 12    },     {       "metadata": \{ "sensorId": 5578, "type": "temperature" } ,       "timestamp": ISODate("2023-08-19T16:00:00.000Z"),       "temp": 17    },     {       "metadata": \{ "sensorId": 5578, "type": "temperature" } ,       "timestamp": ISODate("2023-08-19T20:00:00.000Z"),       "temp": 12    } ] )    
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None

      Hi all,

         I met a strange about the time series collection . MongoDB version 5.0.18 and i create a time series collection with Expire property but when the time is come we see that document did not removed. Current date is ISODate("2023-08-17T06:53:03.288Z"), but you can see in the pic the data with timestamp ISODate("2023-08-10T00:00:00Z") was not removed and still exists. Who can tell me why 

       

         

        1. weather27h1
          2 kB
        2. image-2023-08-17-14-53-46-724.png
          image-2023-08-17-14-53-46-724.png
          346 kB

            Assignee:
            [HELP ONLY] Backlog - Triage Team
            Reporter:
            zhijia zhang
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: