Hi William,
I had recreated the index several times. It doesn't appear to be the cause of the problem. I have no problem with:
db.employees.find({ query: { $or: [ { employeenum: { $gt: 5 } }, { check: { $gt: "E" } } ] }, $min: { employeenum: 5, check: "E" }, $maxScan: 2, $explain: false })
Which fetches for the next document in the index after the document with keys 5 - "E". This works perfectly. I would have thought that the corollary to going backwards would be:
db.employees.find({ query: { $or: [ { employeenum: { $lt: 5 } }, { check: { $lt: "E" } } ] }, $max: { employeenum: 5, check: "E" }, orderby: { employeenum: -1, check: -1 }, $maxScan: 2, $explain: false })
But that crashes the server. That is worrisome not just because it doesn't do what I want to do but that it crashes the server. Should I also infer that a corrupt index for one collection could cause the server to crash thereby killing all users?