PMXBOT Log file Viewer

Help | Karma | Search:

#mongodb logs for Monday the 26th of October, 2015

(Back to #mongodb overview) (Back to channel listing) (Animate logs)
[00:48:18] <podcastinator> ..
[00:48:45] <podcastinator> hello, i have a question about the mongo wire protocol
[00:49:04] <podcastinator> I noticed that inserts are not always sent over the wire with opcode "INSERT"
[00:49:47] <podcastinator> they are sometimes sent with opcode "QUERY", if the app needs mongodb to respond
[00:50:11] <podcastinator> this behavior, however, does not seem to be documented on the website
[00:50:47] <podcastinator> is there any resource/documentation available where all such cases are outlined?
[07:02:10] <oskie> what causes 3.0.7 to constantly read the database without clients?
[07:18:29] <aps> Hi all. I need to move a db from one replica-set to another on a live db. I looked at "copydb" command but it might result in divergent data due to new writes because of live db.
[07:18:29] <aps> Could you please suggest something here?
[07:40:53] <oskie> why not just mongodump followed by mongorestore
[07:54:02] <aps> oskie: but there'd be new entries that won't be there in the dump
[08:23:58] <oskie> aps: so you want continuous synchronization between different replica sets?
[08:24:35] <oskie> not sure if that is possible
[09:06:55] <aps> oskie: yeah
[09:22:39] <master_op> hello, is there a way to force mongo to sort document after the projection process ?
[09:51:56] <the_german> Hi I am using find().forEach( function ( ... to parse one collection into another. But the query stops after exactly 3600s. Is there a timeout that i am missing. I already use the noTimeout DBQuery option.
[14:13:44] <Thinh> Hi all--if I only have one wiredtiger engine, is it wise to set storage.wiredTiger.engineConfig.cacheSizeGB to something like 90% of the system RAM?
[14:25:35] <livcd> mm what happened to the --dbpath option ?
[14:26:09] <livcd> how can i now say ? mongodump -d db -c oplog.rs -o oplogD --dbpath bckp ?
[14:28:40] <StephenLynx> I use write the path to the dump as the last argument without anything
[14:28:48] <StephenLynx> mongodump -d db -c oplog.rs -o oplogD bckp
[14:28:58] <StephenLynx> use to*
[14:29:03] <livcd> i guess that would work
[14:30:02] <livcd> oh maybe not...positional argument not valid
[14:42:01] <StephenLynx> ah
[14:42:08] <StephenLynx> whats the -o?
[14:42:11] <StephenLynx> output?
[14:42:16] <livcd> y
[14:42:31] <StephenLynx> whats the dbpath then
[14:42:31] <StephenLynx> ?
[15:24:53] <livcd> StephenLynx: oh nevermind
[15:25:05] <livcd> now mongorestore tells me "no reacheble servers" wth
[15:45:25] <shlant> hi all. I have a SSL cert I use for encryption on the client side (ELB) and backend (nginx). Would it make sense for me to use the same cert for Mongo TLS? not sure what best practice is. Looks like it needs a legit CA so it would be that or purchase an additional cert yes?
[17:14:55] <CustosLimen> hi
[17:17:19] <CustosLimen> so the docker image for 3.1 uses debian wheezy
[17:18:16] <CustosLimen> https://github.com/docker-library/mongo/blob/5216cf8aedcf7634172e607b0c9718cc332e0d71/3.1/Dockerfile
[17:18:21] <CustosLimen> unless I'm missing something
[17:19:04] <CustosLimen> so - if I load this on docker inside RHEL
[17:19:07] <CustosLimen> how will support work
[17:19:16] <CustosLimen> ugh
[17:19:21] <CustosLimen> this docker does my head in with support
[17:19:25] <CustosLimen> I dunno what to do
[17:19:56] <shlant> CustosLimen: you're in the #mongodb channel..
[17:20:01] <CustosLimen> I know
[17:20:07] <CustosLimen> I ask here cos you guys have a docker image
[17:20:27] <shlant> so you are running docker on RHEL?
[17:20:34] <shlant> as in that's the docker host?
[17:20:51] <CustosLimen> well - look - I'm trying to figure if support of one os running in docker in different image is something I should be concerned about
[17:21:07] <CustosLimen> I actually thought mongodb's docker would use RHEL instead of debian
[17:21:11] <StephenLynx> why not run mongo directly on the RHEL host OS?
[17:21:16] <CustosLimen> and I'm actually not sure why it uses debian
[17:21:18] <shlant> most images use debian
[17:21:24] <StephenLynx> afaik, RHEL is the most supported kind of distros for mongo.
[17:21:27] <StephenLynx> debian is awful now.
[17:21:36] <StephenLynx> they are more concerned with politics than software.
[17:21:52] <CustosLimen> StephenLynx, cos I'm doing one of those XY problem questions
[17:21:53] <CustosLimen> http://xyproblem.info/
[17:21:55] <StephenLynx> they went as far as labeling ffmpeg deprecated to promote the fork of their friends.
[17:22:04] <StephenLynx> what
[17:22:08] <CustosLimen> StephenLynx, where what I'm asking is unrelated to what I want to know ;)
[17:22:19] <StephenLynx> how does running inferior software is relevant?
[17:22:42] <CustosLimen> StephenLynx, its not - which is why I'm saying I'm doing XY questions
[17:23:06] <shlant> CustosLimen: what do you mean by "support"? as in RHEL paid support? or are you asking why doesn't the mongo image use RHEL?
[17:24:26] <CustosLimen> shlant, actually - I will ask again later - going to gym now
[18:04:08] <GitGud> Uptime, why are you her
[18:04:09] <GitGud> here*
[18:04:43] <Uptime> GitGud: I've been here for ages, boy
[18:09:38] <shlant> for replica TLS, do I just combine my cert and key into one file? do I keep BEGIN/END CERTIFICATE/KEY?
[18:22:46] <Freman> so uh, we seem to have reached a limit for mongo/mongos - 12000 insets/second :D
[18:23:02] <Freman> oh wait, jumped to 15k
[18:25:32] <Freman> any tips on tuning it?
[18:28:25] <Freman> no longer writing to btrfs :D
[18:52:05] <SAiF> I feel that robomongo and mongovue don't work anymore.
[18:54:14] <daidoji> hello, does anyone have an example of "authentication" in code?
[18:54:19] <daidoji> the docs I'm reading aren't very clear
[18:55:45] <SAiF> are you able to use authentication with gui?
[18:56:04] <daidoji> there's a GUI?
[18:56:19] <StephenLynx> daidoji I can link my project
[18:56:36] <daidoji> StephenLynx: thanks
[18:57:00] <StephenLynx> https://gitlab.com/mrseth/LynxChan/blob/master/src/be/db.js#L668
[18:57:01] <daidoji> like I can auth via the command line tool
[18:57:04] <daidoji> but I'm having trouble in code
[19:09:49] <daidoji> so I'm confused
[19:09:54] <daidoji> I've setup authentication in my instance
[19:10:17] <daidoji> but I can query the databases without authenticating
[19:10:24] <daidoji> so I got authentication to work
[19:10:35] <daidoji> but apparently I don't need to authenticate
[19:15:33] <StephenLynx> you can connect without authenticating.
[19:15:46] <StephenLynx> you can't ACT on the database without authenticating if authentication is working.
[19:22:15] <daidoji> StephenLynx: doesn't that open the door to DoS?
[19:22:20] <daidoji> like shouldn't that be a bug?
[19:22:32] <StephenLynx> I thought that too.
[19:22:38] <StephenLynx> but it seems it isn't.
[19:22:45] <StephenLynx> you can double check though.
[19:23:02] <StephenLynx> I imagine if it were, there would be anything happening by now because of it.
[19:24:09] <daidoji> oh well, thats weird
[20:58:41] <daidoji> so how can I test authentication?
[20:58:54] <daidoji> like I setup my dev machine for authentication I think (and ssl)
[20:59:02] <daidoji> but it'll still give me a cursor if I don't authenticate
[20:59:34] <Derick> you need to iterate over the cursor
[21:01:26] <daidoji> Derick: I did and it gives me records
[21:12:48] <daidoji> thats why I'm confused
[21:15:18] <daidoji> oh wait, do I have to explicitly set the mongod instance to require auth?
[21:17:30] <daidoji> there it goes...
[21:17:33] <daidoji> thats confusing
[21:30:32] <fullstack> Crazy, check this out
[21:30:49] <fullstack> config_version is a Number column that contains 0
[21:31:34] <fullstack> db.someCollection.find({ config_version : { $not : { $type : 1 }}}); <-- find everywhere in the collection whwere conversion isn't a number
[21:31:43] <fullstack> But it returns everything
[21:31:48] <fullstack> if I do the inverse,
[21:32:10] <fullstack> db.someCollection.find({ config_version : { $type : 1 }});
[21:32:14] <fullstack> I get nothing!
[21:32:18] <fullstack> Has the world gone mad???
[21:34:56] <fullstack> if I do
[21:35:00] <fullstack> .find({ config_version : { $exists:true, $type : { $not : 1 }}});
[21:35:07] <fullstack> I get this strange error message
[21:35:18] <fullstack> Error: error: { "$err" : "type not supported for appendMinElementForType", "code" : 10061 }
[21:36:34] <daidoji> fullstack: yeah I think in teh documentation somewhere
[21:36:42] <daidoji> it says you can't use type in conjuction with other stuff I thought
[21:39:16] <fullstack> oh
[21:39:34] <fullstack> How do I select all data that isn't of a type
[21:39:53] <daidoji> fullstack: I'm not sure, they really discourage you from typechecking in mongodb
[21:40:03] <daidoji> you might have to write your own map/reduce
[21:40:14] <daidoji> cause I think I went down this road before when I was trying to groupBy($type)
[21:40:24] <daidoji> which isn't allowed
[21:42:13] <fullstack> It works on everything but Numbers
[21:49:44] <daidoji> fullstack: weird
[22:06:11] <Torkable> when I unwind nested arrays, the performance is terrible
[22:06:29] <Torkable> is there a way to improve the perf?
[22:07:09] <Torkable> { $unwind: "$array"}, {$unwind: "$array.array2"}
[22:07:14] <Torkable> takes forever
[22:32:55] <Torkable> psa: https://jira.mongodb.org/browse/SERVER-6436
[22:33:08] <Torkable> significantly improved perf