[SERVER-60065] operation aborted because all indexes on collection dropped Created: 18/Sep/21  Updated: 19/Sep/21  Resolved: 19/Sep/21

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: 3.4.10
Fix Version/s: None

Type: Bug Priority: Major - P3
Reporter: fu xi Assignee: Unassigned
Resolution: Done Votes: 0
Labels: aggregate, bug, sort
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Operating System: ALL
Steps To Reproduce:

query sql is this

db.test_alarm.aggregate([{
$lookup:

{ from: "number_sum", localField: "number", foreignField: "compress_number", as: "compress_counts" }

}, {
$match:
{
"alarmRule":

{ "$ne": "1" }

,
"username": "admin"
}
}, {
$sort :

{ "create_time": -1 }

}

])

If you remove the sorting, you can query the data normally,like this:
db.test_alarm.aggregate([
    { $lookup: 

{ from: "number_sum", localField: "number", foreignField: "compress_number", as: "compress_counts"         }

    },
    { $match: {
            "alarmRule": 

{                 "$ne": "1"             }

,
            "username": "admin"
        }
    },
    
])  
So I think it’s a sort of problem,I tested in another environment, if the query exceeds the query cache, an error will be reported:out of query cache tell me try add {allowDiskUse: true},if i add it,sql will always run

 

but i add {allowDiskUse: true} to report error environment,The error is still “all indexes on collection dropped” 

Please help me to solve this problem  ,Thank you very very much

or tell me the logic of this sort sorting, under which circumstances it will report an error

 

My English is bad, please forgive me   sorry!

 

 
 

Participants:

 Description   

Hello , I created 8 million pieces of data in the environment. After I aggregate and query the two sets in the data, when I use sort to sort, mongo reports an error.
query failed with error code 1608 and error messenge ‘collection or indexes disappeaed when cursor yielded: opertionFailed: opertion aborted because:all indexes on collection dropped’ on server xxxx:27017



 Comments   
Comment by Dmitry Agranat [ 19/Sep/21 ]

Hi 1028544680@qq.com,

MongoDB 3.4 reached EOL in January 2020 and the SERVER project is for bugs or feature suggestions for supported versions of the MongoDB server.

For MongoDB-related support discussion please post on the mongodb-user group or Stack Overflow with the mongodb tag. A question like this involving more discussion would be best posted on the mongodb-user group.

Regards,
Dima

Generated at Thu Feb 08 05:48:52 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.