Discussion:
MongoDB 4.1.5: error creating wildcard index
(too old to reply)
John Green
2018-11-19 11:55:56 UTC
Permalink
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
2018-12-06 03:55:46 UTC
Permalink
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
2018-12-07 13:53:29 UTC
Permalink
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.
Continue reading on narkive:
Loading...