Created
January 17, 2013 10:34
-
-
Save aht/4555130 to your computer and use it in GitHub Desktop.
$centerSphere query hangs mongodb
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| > db['similar_items.tanhxdiv5ratings_cosinesimilarities.6'].count() | |
| 27745186 | |
| > db['similar_items.tanhxdiv5ratings_cosinesimilarities.6'].getIndexes() | |
| [ | |
| { | |
| "v" : 1, | |
| "key" : { | |
| "_id" : 1 | |
| }, | |
| "ns" : "osapi_int.similar_items.tanhxdiv5ratings_cosinesimilarities.6", | |
| "name" : "_id_" | |
| }, | |
| { | |
| "v" : 1, | |
| "key" : { | |
| "p1" : 1 | |
| }, | |
| "ns" : "osapi_int.similar_items.tanhxdiv5ratings_cosinesimilarities.6", | |
| "name" : "p1_1" | |
| }, | |
| { | |
| "v" : 1, | |
| "key" : { | |
| "p1" : 1, | |
| "p2" : 1 | |
| }, | |
| "ns" : "osapi_int.similar_items.tanhxdiv5ratings_cosinesimilarities.6", | |
| "name" : "p1_1_p2_1" | |
| }, | |
| { | |
| "v" : 1, | |
| "key" : { | |
| "xy" : "2d" | |
| }, | |
| "ns" : "osapi_int.similar_items.tanhxdiv5ratings_cosinesimilarities.6", | |
| "name" : "xy_2d" | |
| } | |
| ] |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "inprog" : [ | |
| { | |
| "opid" : 14035479, | |
| "active" : true, | |
| "secs_running" : 210, | |
| "op" : "query", | |
| "ns" : "osapi_int.similar_items.tanhxdiv5ratings_cosinesimilarities.6", | |
| "query" : { | |
| "query" : { | |
| "xy" : { | |
| "$within" : { | |
| "$centerSphere" : [ | |
| [ | |
| -122.3907852172852, | |
| 37.78129802378191 | |
| ], | |
| 0.00005 | |
| ] | |
| } | |
| } | |
| }, | |
| "$explain" : true | |
| }, | |
| "client" : "127.0.0.1:47221", | |
| "desc" : "conn2484", | |
| "threadId" : "0x7fcb73575700", | |
| "connectionId" : 2484, | |
| "locks" : { | |
| "^" : "r", | |
| "^osapi_int" : "R" | |
| }, | |
| "waitingForLock" : false, | |
| "numYields" : 0, | |
| "lockStats" : { | |
| "timeLockedMicros" : { | |
| }, | |
| "timeAcquiringMicros" : { | |
| "r" : NumberLong(6), | |
| "w" : NumberLong(0) | |
| } | |
| } | |
| }, | |
| { | |
| "opid" : 14035482, | |
| "active" : true, | |
| "secs_running" : 204, | |
| "op" : "query", | |
| "ns" : "", | |
| "query" : { | |
| "serverStatus" : 1 | |
| }, | |
| "client" : "127.0.0.1:47225", | |
| "desc" : "conn2488", | |
| "threadId" : "0x7fcdb52d7700", | |
| "connectionId" : 2488, | |
| "locks" : { | |
| "^" : "r" | |
| }, | |
| "waitingForLock" : true, | |
| "numYields" : 0, | |
| "lockStats" : { | |
| "timeLockedMicros" : { | |
| }, | |
| "timeAcquiringMicros" : { | |
| } | |
| } | |
| }, | |
| ] |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| (gdb) thread apply all bt | |
| Thread 16 (Thread 0x7fdeb1de7700 (LWP 1072)): | |
| #0 0x00007fdeb44d59f7 in do_sigwait () from /lib/x86_64-linux-gnu/libpthread.so.0 | |
| #1 0x00007fdeb44d5a79 in sigwait () from /lib/x86_64-linux-gnu/libpthread.so.0 | |
| #2 0x0000000000557b98 in mongo::interruptThread() () | |
| #3 0x00000000007c3659 in ?? () | |
| #4 0x00007fdeb44cde9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 | |
| #5 0x00007fdeb37e2dbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 | |
| #6 0x0000000000000000 in ?? () | |
| Thread 15 (Thread 0x7fdeb15e5700 (LWP 1074)): | |
| #0 0x00007fdeb44d552d in nanosleep () from /lib/x86_64-linux-gnu/libpthread.so.0 | |
| #1 0x0000000000c0f312 in mongo::sleepmicros(long long) () | |
| #2 0x00000000005787f4 in mongo::DataFileSync::run() () | |
| #3 0x0000000000595fce in mongo::BackgroundJob::jobBody(boost::shared_ptr<mongo::BackgroundJob::JobStatus>) () | |
| #4 0x0000000000597a84 in boost::detail::thread_data<boost::_bi::bind_t<void, boost::_mfi::mf1<void, mongo::BackgroundJob, boost::shared_ptr<mongo::BackgroundJob::JobStatus> >, boost::_bi::list2<boost::_bi::value<mongo::BackgroundJob*>, boost::_bi::value<boost::shared_ptr<mongo::BackgroundJob::JobStatus> > > > >::run() () | |
| #5 0x00000000007c3659 in ?? () | |
| #6 0x00007fdeb44cde9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 | |
| #7 0x00007fdeb37e2dbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 | |
| #8 0x0000000000000000 in ?? () | |
| Thread 14 (Thread 0x7fdeb0de4700 (LWP 1085)): | |
| #0 0x00007fdeb44d1d84 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 | |
| #1 0x000000000061c30b in void boost::condition_variable_any::wait<boost::unique_lock<boost::timed_mutex> >(boost::unique_lock<boost::timed_mutex>&) () | |
| #2 0x0000000000a8b6e9 in mongo::FileAllocator::run(mongo::FileAllocator*) () | |
| #3 0x00000000007c3659 in ?? () | |
| #4 0x00007fdeb44cde9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 | |
| #5 0x00007fdeb37e2dbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 | |
| #6 0x0000000000000000 in ?? () | |
| Thread 13 (Thread 0x7fdeb05e3700 (LWP 1087)): | |
| #0 0x00007fdeb44d1d84 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 | |
| #1 0x00000000007db28b in void boost::condition_variable_any::wait<boost::mutex>(boost::mutex&) () | |
| #2 0x0000000000adbd7f in mongo::Lock::GlobalWrite::GlobalWrite(bool, int) () | |
| #3 0x0000000000a0a6fc in ?? () | |
| #4 0x0000000000a0ae24 in mongo::dur::durThread() () | |
| #5 0x00000000007c3659 in ?? () | |
| #6 0x00007fdeb44cde9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 | |
| #7 0x00007fdeb37e2dbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 | |
| #8 0x0000000000000000 in ?? () | |
| ---Type <return> to continue, or q <return> to quit--- | |
| Thread 12 (Thread 0x7fdeafde2700 (LWP 1236)): | |
| #0 0x00007fdeb44d552d in nanosleep () from /lib/x86_64-linux-gnu/libpthread.so.0 | |
| #1 0x0000000000c0f88e in mongo::sleepsecs(int) () | |
| #2 0x000000000061192d in mongo::SnapshotThread::run() () | |
| #3 0x0000000000595fce in mongo::BackgroundJob::jobBody(boost::shared_ptr<mongo::BackgroundJob::JobStatus>) () | |
| #4 0x0000000000597a84 in boost::detail::thread_data<boost::_bi::bind_t<void, boost::_mfi::mf1<void, mongo::BackgroundJob, boost::shared_ptr<mongo::BackgroundJob::JobStatus> >, boost::_bi::list2<boost::_bi::value<mongo::BackgroundJob*>, boost::_bi::value<boost::shared_ptr<mongo::BackgroundJob::JobStatus> > > > >::run() () | |
| #5 0x00000000007c3659 in ?? () | |
| #6 0x00007fdeb44cde9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 | |
| #7 0x00007fdeb37e2dbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 | |
| #8 0x0000000000000000 in ?? () | |
| Thread 11 (Thread 0x7fdeaf5e1700 (LWP 1237)): | |
| #0 0x00007fdeb44d552d in nanosleep () from /lib/x86_64-linux-gnu/libpthread.so.0 | |
| #1 0x0000000000c0f88e in mongo::sleepsecs(int) () | |
| #2 0x000000000069ddf4 in mongo::ClientCursorMonitor::run() () | |
| #3 0x0000000000595fce in mongo::BackgroundJob::jobBody(boost::shared_ptr<mongo::BackgroundJob::JobStatus>) () | |
| #4 0x0000000000597a84 in boost::detail::thread_data<boost::_bi::bind_t<void, boost::_mfi::mf1<void, mongo::BackgroundJob, boost::shared_ptr<mongo::BackgroundJob::JobStatus> >, boost::_bi::list2<boost::_bi::value<mongo::BackgroundJob*>, boost::_bi::value<boost::shared_ptr<mongo::BackgroundJob::JobStatus> > > > >::run() () | |
| #5 0x00000000007c3659 in ?? () | |
| #6 0x00007fdeb44cde9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 | |
| #7 0x00007fdeb37e2dbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 | |
| #8 0x0000000000000000 in ?? () | |
| Thread 10 (Thread 0x7fdeaede0700 (LWP 1238)): | |
| #0 0x00007fdeb44d552d in nanosleep () from /lib/x86_64-linux-gnu/libpthread.so.0 | |
| #1 0x0000000000c0f88e in mongo::sleepsecs(int) () | |
| #2 0x0000000000594b6b in mongo::PeriodicTask::Runner::run() () | |
| #3 0x0000000000595fce in mongo::BackgroundJob::jobBody(boost::shared_ptr<mongo::BackgroundJob::JobStatus>) () | |
| #4 0x0000000000597a84 in boost::detail::thread_data<boost::_bi::bind_t<void, boost::_mfi::mf1<void, mongo::BackgroundJob, boost::shared_ptr<mongo::BackgroundJob::JobStatus> >, boost::_bi::list2<boost::_bi::value<mongo::BackgroundJob*>, boost::_bi::value<boost::shared_ptr<mongo::BackgroundJob::JobStatus> > > > >::run() () | |
| #5 0x00000000007c3659 in ?? () | |
| #6 0x00007fdeb44cde9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 | |
| #7 0x00007fdeb37e2dbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 | |
| #8 0x0000000000000000 in ?? () | |
| Thread 9 (Thread 0x7fdeae5df700 (LWP 1239)): | |
| #0 0x00007fdeb44d1d84 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 | |
| #1 0x00000000007db28b in void boost::condition_variable_any::wait<boost::mutex>(boost::mutex&) () | |
| #2 0x0000000000ad8f1c in mongo::Lock::DBRead::lockTop(mongo::LockState&) () | |
| ---Type <return> to continue, or q <return> to quit--- | |
| #3 0x0000000000ad9093 in mongo::Lock::DBRead::lockDB(std::string const&) () | |
| #4 0x0000000000adb095 in mongo::Lock::DBRead::DBRead(mongo::StringData const&) () | |
| #5 0x00000000007b2333 in mongo::TTLMonitor::run() () | |
| #6 0x0000000000595fce in mongo::BackgroundJob::jobBody(boost::shared_ptr<mongo::BackgroundJob::JobStatus>) () | |
| #7 0x0000000000597a84 in boost::detail::thread_data<boost::_bi::bind_t<void, boost::_mfi::mf1<void, mongo::BackgroundJob, boost::shared_ptr<mongo::BackgroundJob::JobStatus> >, boost::_bi::list2<boost::_bi::value<mongo::BackgroundJob*>, boost::_bi::value<boost::shared_ptr<mongo::BackgroundJob::JobStatus> > > > >::run() () | |
| #8 0x00000000007c3659 in ?? () | |
| #9 0x00007fdeb44cde9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 | |
| #10 0x00007fdeb37e2dbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 | |
| #11 0x0000000000000000 in ?? () | |
| Thread 8 (Thread 0x7fdeaddde700 (LWP 1240)): | |
| #0 0x00007fdeb37dc123 in select () from /lib/x86_64-linux-gnu/libc.so.6 | |
| #1 0x00000000006a4a5a in mongo::Listener::initAndListen() () | |
| #2 0x00000000008bd940 in mongo::webServerThread(mongo::AdminAccess const*) () | |
| #3 0x00000000007c3659 in ?? () | |
| #4 0x00007fdeb44cde9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 | |
| #5 0x00007fdeb37e2dbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 | |
| #6 0x0000000000000000 in ?? () | |
| Thread 7 (Thread 0x7fcb768b8700 (LWP 8634)): | |
| #0 0x00007fdeb44d514c in recv () from /lib/x86_64-linux-gnu/libpthread.so.0 | |
| #1 0x000000000089a053 in mongo::Socket::_recv(char*, int) () | |
| #2 0x000000000089a069 in mongo::Socket::unsafe_recv(char*, int) () | |
| #3 0x000000000089d654 in mongo::Socket::recv(char*, int) () | |
| #4 0x000000000081e59c in mongo::MessagingPort::recv(mongo::Message&) () | |
| #5 0x00000000005dbef7 in mongo::pms::threadRun(mongo::MessagingPort*) () | |
| #6 0x00007fdeb44cde9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 | |
| #7 0x00007fdeb37e2dbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 | |
| #8 0x0000000000000000 in ?? () | |
| Thread 6 (Thread 0x7fcc785c7700 (LWP 9052)): | |
| #0 0x00007fdeb44d514c in recv () from /lib/x86_64-linux-gnu/libpthread.so.0 | |
| #1 0x000000000089a053 in mongo::Socket::_recv(char*, int) () | |
| #2 0x000000000089a069 in mongo::Socket::unsafe_recv(char*, int) () | |
| #3 0x000000000089d654 in mongo::Socket::recv(char*, int) () | |
| #4 0x000000000081e59c in mongo::MessagingPort::recv(mongo::Message&) () | |
| #5 0x00000000005dbef7 in mongo::pms::threadRun(mongo::MessagingPort*) () | |
| #6 0x00007fdeb44cde9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 | |
| #7 0x00007fdeb37e2dbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 | |
| #8 0x0000000000000000 in ?? () | |
| ---Type <return> to continue, or q <return> to quit--- | |
| Thread 5 (Thread 0x7fcb766b6700 (LWP 9479)): | |
| #0 0x00007fdeb44d514c in recv () from /lib/x86_64-linux-gnu/libpthread.so.0 | |
| #1 0x000000000089a053 in mongo::Socket::_recv(char*, int) () | |
| #2 0x000000000089a069 in mongo::Socket::unsafe_recv(char*, int) () | |
| #3 0x000000000089d654 in mongo::Socket::recv(char*, int) () | |
| #4 0x000000000081e59c in mongo::MessagingPort::recv(mongo::Message&) () | |
| #5 0x00000000005dbef7 in mongo::pms::threadRun(mongo::MessagingPort*) () | |
| #6 0x00007fdeb44cde9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 | |
| #7 0x00007fdeb37e2dbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 | |
| #8 0x0000000000000000 in ?? () | |
| Thread 4 (Thread 0x7fcb76ebe700 (LWP 9950)): | |
| #0 0x00007fdeb44d514c in recv () from /lib/x86_64-linux-gnu/libpthread.so.0 | |
| #1 0x000000000089a053 in mongo::Socket::_recv(char*, int) () | |
| #2 0x000000000089a069 in mongo::Socket::unsafe_recv(char*, int) () | |
| #3 0x000000000089d654 in mongo::Socket::recv(char*, int) () | |
| #4 0x000000000081e59c in mongo::MessagingPort::recv(mongo::Message&) () | |
| #5 0x00000000005dbef7 in mongo::pms::threadRun(mongo::MessagingPort*) () | |
| #6 0x00007fdeb44cde9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 | |
| #7 0x00007fdeb37e2dbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 | |
| #8 0x0000000000000000 in ?? () | |
| Thread 3 (Thread 0x7fcb73575700 (LWP 10492)): | |
| #0 0x00000000006d6078 in mongo::GeoBrowse::addSpecific(mongo::GeoKeyNode const&, mongo::Point const&, bool, double, bool) () | |
| #1 0x00000000006d1884 in mongo::GeoAccumulator::add(mongo::GeoKeyNode const&) () | |
| #2 0x00000000006d1347 in mongo::BtreeLocation::checkAndAdvance(mongo::GeoHash const&, int&, mongo::GeoAccumulator*) () | |
| #3 0x00000000006e34a2 in mongo::GeoBrowse::fillStack(int, int, bool) () | |
| #4 0x00000000006c7e3a in mongo::GeoBrowse::advance() () | |
| #5 0x00000000006b0885 in mongo::queryWithQueryOptimizer(int, std::string const&, mongo::BSONObj const&, mongo::CurOp&, mongo::BSONObj const&, mongo::BSONObj const&, boost::shared_ptr<mongo::ParsedQuery> const&, mongo::BSONObj const&, mongo::ShardChunkVersion const&, boost::scoped_ptr<mongo::PageFaultRetryableSection>&, boost::scoped_ptr<mongo::NoPageFaultsAllowed>&, mongo::Message&) () | |
| #6 0x00000000006b3d38 in mongo::runQuery(mongo::Message&, mongo::QueryMessage&, mongo::CurOp&, mongo::Message&) () | |
| #7 0x0000000000b5ba7d in ?? () | |
| #8 0x0000000000b5d052 in mongo::assembleResponse(mongo::Message&, mongo::DbResponse&, mongo::HostAndPort const&) () | |
| #9 0x000000000056fa52 in mongo::MyMessageHandler::process(mongo::Message&, mongo::AbstractMessagingPort*, mongo::LastError*) () | |
| #10 0x00000000005dbf11 in mongo::pms::threadRun(mongo::MessagingPort*) () | |
| #11 0x00007fdeb44cde9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 | |
| #12 0x00007fdeb37e2dbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 | |
| #13 0x0000000000000000 in ?? () | |
| ---Type <return> to continue, or q <return> to quit--- | |
| Thread 2 (Thread 0x7fcdb52d7700 (LWP 10536)): | |
| #0 0x00007fdeb44d1d84 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 | |
| #1 0x00000000007db28b in void boost::condition_variable_any::wait<boost::mutex>(boost::mutex&) () | |
| #2 0x0000000000ad8f1c in mongo::Lock::DBRead::lockTop(mongo::LockState&) () | |
| #3 0x0000000000ad9093 in mongo::Lock::DBRead::lockDB(std::string const&) () | |
| #4 0x0000000000adb095 in mongo::Lock::DBRead::DBRead(mongo::StringData const&) () | |
| #5 0x000000000066d6ba in mongo::CmdServerStatus::run(std::string const&, mongo::BSONObj&, int, std::string&, mongo::BSONObjBuilder&, bool) () | |
| #6 0x00000000006571f1 in mongo::_execCommand(mongo::Command*, std::string const&, mongo::BSONObj&, int, mongo::BSONObjBuilder&, bool) () | |
| #7 0x0000000000658d5d in mongo::execCommand(mongo::Command*, mongo::Client&, int, char const*, mongo::BSONObj&, mongo::BSONObjBuilder&, bool) () | |
| #8 0x0000000000659c1e in mongo::_runCommands(char const*, mongo::BSONObj&, mongo::_BufBuilder<mongo::TrivialAllocator>&, mongo::BSONObjBuilder&, bool, int) () | |
| #9 0x00000000006afa08 in mongo::runCommands(char const*, mongo::BSONObj&, mongo::CurOp&, mongo::_BufBuilder<mongo::TrivialAllocator>&, mongo::BSONObjBuilder&, bool, int) () | |
| #10 0x00000000006b3241 in mongo::runQuery(mongo::Message&, mongo::QueryMessage&, mongo::CurOp&, mongo::Message&) () | |
| #11 0x0000000000b5ba7d in ?? () | |
| #12 0x0000000000b5d052 in mongo::assembleResponse(mongo::Message&, mongo::DbResponse&, mongo::HostAndPort const&) () | |
| #13 0x000000000056fa52 in mongo::MyMessageHandler::process(mongo::Message&, mongo::AbstractMessagingPort*, mongo::LastError*) () | |
| #14 0x00000000005dbf11 in mongo::pms::threadRun(mongo::MessagingPort*) () | |
| #15 0x00007fdeb44cde9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 | |
| #16 0x00007fdeb37e2dbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 | |
| #17 0x0000000000000000 in ?? () | |
| Thread 1 (Thread 0x7fdeb48f6b40 (LWP 1018)): | |
| #0 0x00007fdeb37dc123 in select () from /lib/x86_64-linux-gnu/libc.so.6 | |
| #1 0x00000000006a4a5a in mongo::Listener::initAndListen() () | |
| #2 0x0000000000559154 in mongo::listen(int) () | |
| #3 0x000000000055c86a in mongo::_initAndListen(int) () | |
| #4 0x000000000055d2dd in mongo::initAndListen(int) () | |
| #5 0x0000000000563dbe in ?? () | |
| #6 0x0000000000565399 in main () |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment