Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

robomongo failed to execute time consuming queries #1138

Closed
shengy1192003 opened this issue Jul 22, 2016 · 2 comments
Closed

robomongo failed to execute time consuming queries #1138

shengy1192003 opened this issue Jul 22, 2016 · 2 comments

Comments

@shengy1192003
Copy link

I'm using Robomongo 0.9.0-RC9 on Linux shengy-ThinkPad-W541 4.4.0-31-generic #50-Ubuntu SMP Wed Jul 13 00:07:12 UTC 2016 x86_64 x86_64 x86_64 GNU/Linux

When I tried to execute the following command robomongo does not insert all data correctly

for (var i = 0; i < 200000; i++) {
    db.numbers.insert({num: i});
}

The result of db.numbers.count() is 58350

the same query works as expected in mongo shell.

My mongo version is:

➜  mongo mongo --version
MongoDB shell version: 3.2.7
➜  mongo mongod --version
db version v3.2.7
git version: 4249c1d2b5999ebbf1fdf3bc0e0e3b3ff5c0aaf2
OpenSSL version: OpenSSL 1.0.2g-fips  1 Mar 2016
allocator: tcmalloc
modules: none
build environment:
    distmod: ubuntu1604
    distarch: x86_64
    target_arch: x86_64

db.hostInfo() is

> db.hostInfo()
{
        "system" : {
                "currentTime" : ISODate("2016-07-22T14:50:26.474Z"),
                "hostname" : "shengy-ThinkPad-W541",
                "cpuAddrSize" : 64,
                "memSizeMB" : 7613,
                "numCores" : 8,
                "cpuArch" : "x86_64",
                "numaEnabled" : false
        },
        "os" : {
                "type" : "Linux",
                "name" : "Ubuntu",
                "version" : "16.04"
        },
        "extra" : {
                "versionString" : "Linux version 4.4.0-31-generic (buildd@lgw01-16) (gcc version 5.3.1 20160413 (Ubuntu 5.3.1-14ubuntu2.1) ) #50-Ubuntu SMP Wed Jul 13 00:07:12 UTC 2016",
                "libcVersion" : "2.23",
                "versionSignature" : "Ubuntu 4.4.0-31.50-generic 4.4.13",
                "kernelVersion" : "4.4.0-31-generic",
                "cpuFrequencyMHz" : "3154.199",
                "cpuFeatures" : "fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon pebs bts rep_good nopl xtopology nonstop_tsc aperfmperf eagerfpu pni pclmulqdq dtes64 monitor ds_cpl vmx est tm2 ssse3 sdbg fma cx16 xtpr pdcm pcid sse4_1 sse4_2 movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand lahf_lm abm epb tpr_shadow vnmi flexpriority ept vpid fsgsbase tsc_adjust bmi1 avx2 smep bmi2 erms invpcid xsaveopt dtherm ida arat pln pts",
                "pageSize" : NumberLong(4096),
                "numPages" : 1948929,
                "maxOpenFiles" : 1024
        },
        "ok" : 1
}
@juliashibalko
Copy link
Collaborator

Hi @shengy1192003 Thanks for detailed report! This is known issue so let me suggest you to check workaround described in the ticket #1106 (comment). It should help to solve the problem you wrote about.

@juliashibalko
Copy link
Collaborator

@shengy1192003 Let me suggest to track issue progress with #1106 (comment). I will close this one but please feel free to reopen or create new ticket. Hope workaround help you, thanks!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants