PMXBOT Log file Viewer

Help | Karma | Search:

#mongodb logs for Wednesday the 6th of February, 2019

(Back to #mongodb overview) (Back to channel listing) (Animate logs)
[03:31:06] <Jonno_FTW> I have a very large collection but when I build an index mongodb crashes
[09:47:20] <Derick> Jonno_FTW: https://jira.mongodb.org
[10:09:54] <synthmeat> lol. yesterday guy comes in full of himself of how he's pushing 2B docs a month into his $4k tuned-up postgres on dedicated hardware. mucho consulting dinero.
[10:10:35] <synthmeat> i do few times more, HA, replicated, with backups, on $640 of VPS'
[10:10:48] <synthmeat> and i don't even try or anything, it just works
[10:47:29] <Derick> :)
[12:13:36] <Jonno_FTW> Derick: turned out to be a lack of memory on the VM, bumped it up to 16GB and 4GB swap and it's running now, we also bumped up maxIndexBuildMemoryUsageMegabytes: 4000
[12:13:48] <Jonno_FTW> we're at Index Build: 7068624200/11214646724 63%
[12:14:43] <Guest0193> Howdy, I am running a mongod --dbpath /data/db --repair currently but seeing a lot of "ClientCursor::yield can't unlock b/c of recursive lock ns: ace.stat_hourly", google says I can ignore these. Should I just continue to wait for the repair and how long can it take for a 30G database?
[14:16:32] <RxMcDonald> Hello, anyone knows how to find all documents and make resulsts unique by field x ? i.e. many documents with the same field X and only return 1 from each, but return the whole document, so distinct wouldn't work. I've been trying with aggregate without luck, there's no examples
[15:22:48] <chris_99> Hi, i'm just wondering, cacheSizeGB will control roughly the maximum amount of memory mongodb uses right?
[15:23:59] <chris_99> oh hmm, just found inMemorySizeGB too