[SERVER-1179] md5 command stopped working Created: 01/Jun/10  Updated: 12/Jul/16  Resolved: 01/Jun/10

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

Type: Bug Priority: Major - P3
Reporter: Kristina Chodorow (Inactive) Assignee: Eliot Horowitz (Inactive)
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Tue Jun 1 11:14:27 db version v1.5.2-pre-, pdfile version 4.5
Tue Jun 1 11:14:27 git version: 18de73318736ed61a028f03ddfd4b562cd204c39
Tue Jun 1 11:14:27 sys info: Linux ubuntu 2.6.31-15-generic #50-Ubuntu SMP Tue Nov 10 14:54:29 UTC 2009 i686 BOOST_LIB_VERSION=1_38


Participants:

 Description   

Running this command doesn't work anymore:

> db.runCommand(

{filemd5:ObjectId(), root:"fs"}

)
{
"errmsg" : "exception: best guess plan requested, but scan and order required",
"code" : 13284,
"ok" : false
}

Log:

Tue Jun 1 11:11:58 connection accepted from 127.0.0.1:53690 #2
Tue Jun 1 11:12:14 Assertion: 13284:best guess plan requested, but scan and order required
0x812efdd 0x827f03e 0x82c97fb 0x82d10bb 0x82c0433 0x82c1003 0x81a8c59 0x81aaeaf 0x8254395 0x82e8912 0x811a0df 0x16bc1d 0x13380e 0xb1c8de
./mongod(_ZN5mongo11msgassertedEiPKc+0x29d) [0x812efdd]
./mongod(_ZNK5mongo12QueryPlanSet12getBestGuessEv+0x9e) [0x827f03e]
./mongod(ZN5mongo15bestGuessCursorEPKcRKNS_7BSONObjES4+0x19b) [0x82c97fb]
./mongod(_ZN5mongo10CmdFileMD53runERKSsRNS_7BSONObjERSsRNS_14BSONObjBuilderEb+0x36b) [0x82d10bb]
./mongod(_ZN5mongo11execCommandEPNS_7CommandERNS_6ClientEiPKcRNS_7BSONObjERNS_14BSONObjBuilderEb+0x2d3) [0x82c0433]
./mongod(_ZN5mongo12_runCommandsEPKcRNS_7BSONObjERNS_10BufBuilderERNS_14BSONObjBuilderEbi+0x323) [0x82c1003]
./mongod(_ZN5mongo11runCommandsEPKcRNS_7BSONObjERNS_5CurOpERNS_10BufBuilderERNS_14BSONObjBuilderEbi+0x49) [0x81a8c59]
./mongod(ZN5mongo8runQueryERNS_7MessageERNS_12QueryMessageERNS_5CurOpES1+0xc3f) [0x81aaeaf]
./mongod(_ZN5mongo16assembleResponseERNS_7MessageERNS_10DbResponseERKNS_8SockAddrE+0x10e5) [0x8254395]
./mongod(_ZN5mongo10connThreadEv+0x2e2) [0x82e8912]
./mongod(_ZN5boost6detail11thread_dataIPFvvEE3runEv+0xf) [0x811a0df]
/usr/lib/libboost_thread-mt.so.1.38.0(thread_proxy+0x5d) [0x16bc1d]
/lib/tls/i686/cmov/libpthread.so.0 [0x13380e]
/lib/tls/i686/cmov/libc.so.6(clone+0x5e) [0xb1c8de]



 Comments   
Comment by Kristina Chodorow (Inactive) [ 01/Jun/10 ]

Yeah, I guess that's it. The db is empty and if I insert a file it works.

Comment by Eliot Horowitz (Inactive) [ 01/Jun/10 ]

Is it possible the index isn't created at this point?
That seems to be saying there isn't an index

Comment by Kristina Chodorow (Inactive) [ 01/Jun/10 ]

I now get:

> db.runCommand(

{filemd5:ObjectId(), root:"fs"}

)
{
"errmsg" : "exception: best guess plan requested, but scan and order required: query:

{ files_id: ObjectId('4c056b1d0fb421dc47fe6a25') }

order:

{ files_id: 1, n: 1 }

choices:

{ $natural: 1 }

",
"code" : 13284,
"ok" : false
}
>

Tue Jun 1 16:18:33 connection accepted from 127.0.0.1:42389 #1
Tue Jun 1 16:18:37 Assertion: 13284:best guess plan requested, but scan and order required: query:

{ files_id: ObjectId('4c056b1d0fb421dc47fe6a25') }

order:

{ files_id: 1, n: 1 }

choices:

{ $natural: 1 }


Tue Jun 1 16:18:37 query test.$cmd ntoreturn:1 command:

{ filemd5: ObjectId('4c056b1d0fb421dc47fe6a25'), root: "fs" }

reslen:248 298ms

Comment by auto [ 01/Jun/10 ]

Author:

{'login': 'erh', 'name': 'Eliot Horowitz', 'email': 'eliot@10gen.com'}

Message: more debugging for SERVER-1179
http://github.com/mongodb/mongo/commit/741d9f7a19b569beefd6156517df2cc13eed92c9

Comment by auto [ 01/Jun/10 ]

Author:

{'login': 'erh', 'name': 'Eliot Horowitz', 'email': 'eliot@10gen.com'}

Message: debugging for SERVER-1179
http://github.com/mongodb/mongo/commit/285568137248721603b4afe9030eba64a5b2af56

Generated at Thu Feb 08 02:56:18 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.