Operational Defect Database

BugZero found this defect 152 days ago.

MongoDB | 2528324

count time-series collection is very slow, db.collection.count() run COLLSCAN stage.

Last update date:

3/14/2024

Affected products:

MongoDB Server

Affected releases:

No affected releases provided.

Fixed releases:

No fixed releases provided.

Description:

Info

count  time-series collection is very slow,  db.collection.count() run COLLSCAN stage.

Top User Comments

JIRAUSER1257066 commented on Wed, 6 Mar 2024 14:03:24 +0000: Hi 1147952115@qq.com, Thanks for nudging on this issue further. Time series collections are writable non-materialized views that are backed by an internal collection, so I suspect this difference makes a change to whether a fast count through metadata is permitted. I've asked the appropriate server team for further input on this behavior. Kind regards, Edwin 1147952115@qq.com commented on Fri, 12 Jan 2024 04:28:43 +0000: hi, edwin.zhou@mongodb.com This is a very serious bug and you should not turn off this PR because count should be retrieved from metadata, not a full table scan. please open the PR again, thanks. JIRAUSER1257066 commented on Tue, 19 Dec 2023 14:57:49 +0000: Hi 1147952115@qq.com, For this issue we'd like to encourage you to start by asking our community for help by posting on the MongoDB Developer Community Forums. If the discussion there leads you to suspect a bug in the MongoDB server, then we'd want to investigate it as a possible bug here in the SERVER project. Kind regards, Edwin 1147952115@qq.com commented on Tue, 19 Dec 2023 08:52:10 +0000:

Steps to Reproduce


Additional Resources / Links

Share:

BugZero® Risk Score

What's this?

Coming soon

Status

Needs Scheduling

Learn More

Search:

...