Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-3478

using sort and geo query within the map/reduce call mongoD drops

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Fixed
    • Affects Version/s: 1.9.0
    • Fix Version/s: 1.9.2
    • Component/s: Geo, Indexing
    • Environment:
      Oracle Linux Server release 6.1
      Kernel \r on an \m
    • Operating System:
      Linux

      Description

      db.users.mapReduce(m, r, { out : 'users_mr', sort : {_id:1}, query : {'location': { $within:

      { $centerSphere: [[ 10, 20 ], 1 ]}

      }} });

      Tue Jul 26 18:17:41 [initandlisten] db version v1.9.0, pdfile version 4.5
      Tue Jul 26 18:17:41 [initandlisten] git version: 434d8b47e569578d932e3caedd3bb16e8c0836a3
      Tue Jul 26 18:17:41 [initandlisten] build info: Linux bs-linux64.10gen.cc 2.6.21.7-2.ec2.v1.2.fc8xen #1 SMP Fri Nov 20 17:48:28 EST 2009 x86_64 BOOST_LIB_VERSION=1_41
      Tue Jul 26 18:17:41 [initandlisten] waiting for connections on port 27017
      Tue Jul 26 18:17:41 [websvr] web admin interface listening on port 28017
      Tue Jul 26 18:17:42 [initandlisten] connection accepted from 127.0.0.1:35696 #1
      Tue Jul 26 18:18:32 [conn2] CMD: drop teamo.tmp.mr.users_users_mr_3
      Tue Jul 26 18:18:32 [conn2] CMD: drop teamo.tmp.mr.users_users_mr_3_inc
      Tue Jul 26 18:18:32 [conn2] building new index on

      { 0: 1 }

      for teamo.tmp.mr.users_users_mr_3_inc
      Tue Jul 26 18:18:32 [conn2] done for 0 records 0.016 secs
      Tue Jul 26 18:18:32 [conn2] insert teamo.system.indexes 16ms
      Tue Jul 26 18:18:32 [conn2] profile: warning ns teamo.system.profile does not exist
      Tue Jul 26 18:18:33 [conn2] warning: best guess query plan requested, but scan and order are required for all plans query: { location.geo: { $within:

      { $centerSphere: [ [ 37.0, 0.0 ], 1.0 ] }

      } } order:

      { _id: 1.0 }

      choices:

      { location.geo: "2d" }

      Tue Jul 26 18:18:33 Got signal: 6 (Aborted).

      Tue Jul 26 18:18:33 Backtrace:
      0x92d809 0x2ae508a31ac0 0x2ae508a31a45 0x2ae508a33225 0x2ae508a2a9d5 0x6c6d5e 0x878e5f 0x83656c 0x837525 0x678418 0x67a9bc 0x79c495 0x7a3493 0x93c91f 0x5e46e5 0x946800 0x2ae5080487e1 0x2ae508ae58ed
      /usr/bin/mongod(_ZN5mongo10abruptQuitEi+0x399) [0x92d809]
      /lib64/libc.so.6(+0x32ac0) [0x2ae508a31ac0]
      /lib64/libc.so.6(gsignal+0x35) [0x2ae508a31a45]
      /lib64/libc.so.6(abort+0x175) [0x2ae508a33225]
      /lib64/libc.so.6(__assert_fail+0xf5) [0x2ae508a2a9d5]
      /usr/bin/mongod(_ZN5mongo12ClientCursorC1EiRKN5boost10shared_ptrINS_6CursorEEERKSsNS_7BSONObjE+0x70e) [0x6c6d5e]
      /usr/bin/mongod(_ZN5mongo2mr16MapReduceCommand3runERKSsRNS_7BSONObjERSsRNS_14BSONObjBuilderEb+0x47f) [0x878e5f]
      /usr/bin/mongod(_ZN5mongo11execCommandEPNS_7CommandERNS_6ClientEiPKcRNS_7BSONObjERNS_14BSONObjBuilderEb+0x7fc) [0x83656c]
      /usr/bin/mongod(_ZN5mongo12_runCommandsEPKcRNS_7BSONObjERNS_10BufBuilderERNS_14BSONObjBuilderEbi+0x2d5) [0x837525]
      /usr/bin/mongod(_ZN5mongo11runCommandsEPKcRNS_7BSONObjERNS_5CurOpERNS_10BufBuilderERNS_14BSONObjBuilderEbi+0x38) [0x678418]
      /usr/bin/mongod(ZN5mongo8runQueryERNS_7MessageERNS_12QueryMessageERNS_5CurOpES1+0xe9c) [0x67a9bc]
      /usr/bin/mongod() [0x79c495]
      /usr/bin/mongod(_ZN5mongo16assembleResponseERNS_7MessageERNS_10DbResponseERKNS_11HostAndPortE+0xde3) [0x7a3493]
      /usr/bin/mongod(_ZN5mongo16MyMessageHandler7processERNS_7MessageEPNS_21AbstractMessagingPortEPNS_9LastErrorE+0x7f) [0x93c91f]
      /usr/bin/mongod(_ZN5mongo3pms9threadRunEPNS_13MessagingPortE+0x3e5) [0x5e46e5]
      /usr/bin/mongod(thread_proxy+0x80) [0x946800]
      /lib64/libpthread.so.0(+0x77e1) [0x2ae5080487e1]
      /lib64/libc.so.6(clone+0x6d) [0x2ae508ae58ed]

      Tue Jul 26 18:18:33 dbexit:
      Tue Jul 26 18:18:33 [conn2] shutdown: going to close listening sockets...
      Tue Jul 26 18:18:33 [conn2] closing listening socket: 5
      Tue Jul 26 18:18:33 [conn2] closing listening socket: 6
      Tue Jul 26 18:18:33 [conn2] closing listening socket: 7
      Tue Jul 26 18:18:33 [conn2] removing socket file: /tmp/mongodb-27017.sock
      Tue Jul 26 18:18:33 [conn2] shutdown: going to flush diaglog...
      Tue Jul 26 18:18:33 [conn2] shutdown: going to close sockets...
      Tue Jul 26 18:18:33 [conn2] shutdown: waiting for fs preallocator...
      Tue Jul 26 18:18:33 [conn2] shutdown: closing all files...
      Tue Jul 26 18:18:33 [conn2] closeAllFiles() finished
      Tue Jul 26 18:18:33 [conn2] shutdown: removing fs lock...
      Tue Jul 26 18:18:33 dbexit: really exiting now
      Tue Jul 26 18:18:33 Got signal: 6 (Aborted).

      Tue Jul 26 18:18:33 Backtrace:
      0x92d809 0x2ae508a31ac0 0x2ae508a31a45 0x2ae508a33225 0x2ae508a2a9d5 0x6c4638 0x2ae508a35072 0x79a8e8 0x92d966 0x2ae508a31ac0 0x2ae508a31a45 0x2ae508a33225 0x2ae508a2a9d5 0x6c6d5e 0x878e5f 0x83656c 0x837525 0x678418 0x67a9bc 0x79c495
      /usr/bin/mongod(_ZN5mongo10abruptQuitEi+0x399) [0x92d809]
      /lib64/libc.so.6(+0x32ac0) [0x2ae508a31ac0]
      /lib64/libc.so.6(gsignal+0x35) [0x2ae508a31a45]
      /lib64/libc.so.6(abort+0x175) [0x2ae508a33225]
      /lib64/libc.so.6(__assert_fail+0xf5) [0x2ae508a2a9d5]
      /usr/bin/mongod() [0x6c4638]
      /lib64/libc.so.6(exit+0xe2) [0x2ae508a35072]
      /usr/bin/mongod(_ZN5mongo6dbexitENS_8ExitCodeEPKcb+0x198) [0x79a8e8]
      /usr/bin/mongod(_ZN5mongo10abruptQuitEi+0x4f6) [0x92d966]
      /lib64/libc.so.6(+0x32ac0) [0x2ae508a31ac0]
      /lib64/libc.so.6(gsignal+0x35) [0x2ae508a31a45]
      /lib64/libc.so.6(abort+0x175) [0x2ae508a33225]
      /lib64/libc.so.6(__assert_fail+0xf5) [0x2ae508a2a9d5]
      /usr/bin/mongod(_ZN5mongo12ClientCursorC1EiRKN5boost10shared_ptrINS_6CursorEEERKSsNS_7BSONObjE+0x70e) [0x6c6d5e]
      /usr/bin/mongod(_ZN5mongo2mr16MapReduceCommand3runERKSsRNS_7BSONObjERSsRNS_14BSONObjBuilderEb+0x47f) [0x878e5f]
      /usr/bin/mongod(_ZN5mongo11execCommandEPNS_7CommandERNS_6ClientEiPKcRNS_7BSONObjERNS_14BSONObjBuilderEb+0x7fc) [0x83656c]
      /usr/bin/mongod(_ZN5mongo12_runCommandsEPKcRNS_7BSONObjERNS_10BufBuilderERNS_14BSONObjBuilderEbi+0x2d5) [0x837525]
      /usr/bin/mongod(_ZN5mongo11runCommandsEPKcRNS_7BSONObjERNS_5CurOpERNS_10BufBuilderERNS_14BSONObjBuilderEbi+0x38) [0x678418]
      /usr/bin/mongod(ZN5mongo8runQueryERNS_7MessageERNS_12QueryMessageERNS_5CurOpES1+0xe9c) [0x67a9bc]
      /usr/bin/mongod() [0x79c495]

      Tue Jul 26 18:18:33 dbexit: ; exiting immediately
      Tue Jul 26 18:18:33 ERROR: Client::~Client _context should be null but is not; client:conn

        Attachments

        1. benchmark02.rb
          1 kB
          Veniamin

          Activity

            People

            Assignee:
            greg_10gen Greg Studer
            Reporter:
            santarus Veniamin
            Participants:
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: