[SERVER-1983] Bad sort spec causes assertion failure Created: 21/Oct/10  Updated: 12/Jul/16  Resolved: 05/Nov/10

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

Type: Bug Priority: Minor - P4
Reporter: Roger Binns Assignee: Mathias Stearn
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

10gen official on 64 bit Ubuntu 10.10


Operating System: ALL
Participants:

 Description   

> db.aviga.find({}).sort("_id").explain()
Wed Oct 20 19:33:35 uncaught exception: error:

{ "$err" : "assertion db/query.h:262" }

> db.aviga.find({}).sort("_id")
error:

{ "$err" : "assertion db/query.h:262" }

If I use sort(

{"_id": 1}

) then it works fine.

Wed Oct 20 19:33:35 [conn11] Assertion failure 0 db/query.h 262
0x534771 0x54134f 0x610ae3 0x5ffce0 0x70547a 0x708ab6 0x8235ef 0x837460 0x7eff5d617971 0x7eff5cbd491d
/usr/bin/mongod(_ZN5mongo12sayDbContextEPKc+0xb1) [0x534771]
/usr/bin/mongod(_ZN5mongo8assertedEPKcS1_j+0x10f) [0x54134f]
/usr/bin/mongod(_ZN5mongo11ParsedQuery8_initTopERKNS_7BSONObjE+0x573) [0x610ae3]
/usr/bin/mongod(ZN5mongo8runQueryERNS_7MessageERNS_12QueryMessageERNS_5CurOpES1+0x1670) [0x5ffce0]
/usr/bin/mongod() [0x70547a]
/usr/bin/mongod(_ZN5mongo16assembleResponseERNS_7MessageERNS_10DbResponseERKNS_8SockAddrE+0x14d6) [0x708ab6]
/usr/bin/mongod(_ZN5mongo10connThreadEPNS_13MessagingPortE+0x30f) [0x8235ef]
/usr/bin/mongod(thread_proxy+0x80) [0x837460]
/lib/libpthread.so.0(+0x7971) [0x7eff5d617971]
/lib/libc.so.6(clone+0x6d) [0x7eff5cbd491d]
Wed Oct 20 19:33:35 [conn11] assertion 0 assertion db/query.h:262 ns:thumbplay.aviga query:{ query: {}, orderby: "_id", $explain: true }
Wed Oct 20 19:34:07 [conn11] Assertion failure 0 db/query.h 262
0x534771 0x54134f 0x610ae3 0x5ffce0 0x70547a 0x708ab6 0x8235ef 0x837460 0x7eff5d617971 0x7eff5cbd491d
/usr/bin/mongod(_ZN5mongo12sayDbContextEPKc+0xb1) [0x534771]
/usr/bin/mongod(_ZN5mongo8assertedEPKcS1_j+0x10f) [0x54134f]
/usr/bin/mongod(_ZN5mongo11ParsedQuery8_initTopERKNS_7BSONObjE+0x573) [0x610ae3]
/usr/bin/mongod(ZN5mongo8runQueryERNS_7MessageERNS_12QueryMessageERNS_5CurOpES1+0x1670) [0x5ffce0]
/usr/bin/mongod() [0x70547a]
/usr/bin/mongod(_ZN5mongo16assembleResponseERNS_7MessageERNS_10DbResponseERKNS_8SockAddrE+0x14d6) [0x708ab6]
/usr/bin/mongod(_ZN5mongo10connThreadEPNS_13MessagingPortE+0x30f) [0x8235ef]
/usr/bin/mongod(thread_proxy+0x80) [0x837460]
/lib/libpthread.so.0(+0x7971) [0x7eff5d617971]
/lib/libc.so.6(clone+0x6d) [0x7eff5cbd491d]
Wed Oct 20 19:34:07 [conn11] assertion 0 assertion db/query.h:262 ns:thumbplay.aviga query:{ query: {}, orderby: "_id" }



 Comments   
Comment by Mathias Stearn [ 05/Nov/10 ]

converted to user assert and gave useful error message:

> db.foo.find().sort("_id")
error:

{ "$err" : "sort must be an object or array", "code" : 13513 }
Comment by auto [ 05/Nov/10 ]

Author:

{'login': 'RedBeard0531', 'name': 'Mathias Stearn', 'email': 'mathias@10gen.com'}

Message: Better error message SERVER-1983
/mongodb/mongo/commit/b6ae12f022df4828a9fc072fcc654c01c302d5c0

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