[mongodb-user] MongoDB 4.1.5: error creating wildcard index

[John Green]

On Windows 10, using MongoDB 4.1.5, I'm trying to create a wildcard index

db.documents.createIndex({"$**":1})

It gets to about 15% completion, then I get an error

2018-11-19T06:33:06.690-0500 I COMMAND [conn14] command
monarchDb.documents appName: "MongoDB Shell" command: createIndexes {
createIndexes: "documents", indexes: [ { key: { $**: 1.0 }, name: "$**_1" }
], lsid: { id: UUID("3e9587f3-1652-4d3a-b3c6-a7b5d2393ad5") }, $db:
"monarchDb" } numYields:0 ok:0 errMsg:"error fetching current file
descriptor offset in file \"c:\\data\\mongodb\\test/_tmp/extsort-index.1\":
errno:0 No error" errName:Location50980 errCode:50980 reslen:204 locks:{
Global: { acquireCount: { r: 4, w: 2 } }, Database: { acquireCount: { r: 1,
w: 2, W: 1 } }, Collection: { acquireCount: { w: 2 } } } protocol:op_msg
1708930ms

is this a known issue with a workaround?
--
You received this message because you are subscribed to the Google Groups "mongodb-user"
group.

For other MongoDB technical support options, see: https://docs.mongodb.com/manual/support/
---
You received this message because you are subscribed to the Google Groups "mongodb-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mongodb-user+***@googlegroups.com.
To post to this group, send email to mongodb-***@googlegroups.com.
Visit this group at https://groups.google.com/group/mongodb-user.
To view this discussion on the web visit https://groups.google.com/d/msgid/mongodb-user/57417cd5-fde2-46a7-91c3-915e5e79ef00%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

['Wan Bachtiar' via mongodb-user]

is this a known issue with a workaround?

Hi John,

I tried to replicate the error (Windows 10, MongoDB development v4.1.5),
with a smaller dataset without success. Would you be able to provide
reproducible steps ? Also example document schema, and how big is your
dataset ?

errMsg:”error fetching current file descriptor offset in file
\”c:\data\mongodb\test/_tmp/extsort-index.1\”: errno:0 No error”
errName:Location50980 errCode:50980

Based on the error message, this is related to Windows file descriptor. The
part of code that is throwing the error failed to find last position of the
sorter file descriptor.

Regards,

Wan.
​
--
You received this message because you are subscribed to the Google Groups "mongodb-user"
group.

For other MongoDB technical support options, see: https://docs.mongodb.com/manual/support/
---
You received this message because you are subscribed to the Google Groups "mongodb-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mongodb-user+***@googlegroups.com.
To post to this group, send email to mongodb-***@googlegroups.com.
Visit this group at https://groups.google.com/group/mongodb-user.
To view this discussion on the web visit https://groups.google.com/d/msgid/mongodb-user/9e5b6d55-92f1-49bf-b74a-4dc165653c7b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[John Green]

Wan,

The collection had about 8.7 million documents, average size 6.2 KiB, total
size 51 GiB
I can't provide the dataset used. I did get the same dataset loaded and
indexed on a Linux system

Regards,
John

Post by John Green
is this a known issue with a workaround?
Hi John,
I tried to replicate the error (Windows 10, MongoDB development v4.1.5),
with a smaller dataset without success. Would you be able to provide
reproducible steps ? Also example document schema, and how big is your
dataset ?
errMsg:”error fetching current file descriptor offset in file
\”c:\data\mongodb\test/_tmp/extsort-index.1\”: errno:0 No error”
errName:Location50980 errCode:50980
Based on the error message, this is related to Windows file descriptor.
The part of code that is throwing the error failed to find last position of
the sorter file descriptor.
Regards,
Wan.
​

--
You received this message because you are subscribed to the Google Groups "mongodb-user"
group.

For other MongoDB technical support options, see: https://docs.mongodb.com/manual/support/
---
You received this message because you are subscribed to the Google Groups "mongodb-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mongodb-user+***@googlegroups.com.
To post to this group, send email to mongodb-***@googlegroups.com.
Visit this group at https://groups.google.com/group/mongodb-user.
To view this discussion on the web visit https://groups.google.com/d/msgid/mongodb-user/915c22df-e0b9-46e4-bc7e-8af5483e13c3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.