<    March 2017    >
Su Mo Tu We Th Fr Sa  
          1  2  3  4  
 5  6  7  8  9 10 11  
12 13 14 15 16 17 18  
19 20 21 22 23 24 25  
26 27 28 29 30 31
00:29 gentunian joined
00:34 synchroack joined
00:54 synchroack joined
00:59 synchroack joined
01:00 artok joined
01:01 Gwayne joined
01:01 Gwayne joined
01:13 dino82 joined
01:15 s2013 joined
01:18 Mia joined
01:24 Sasazuka_ joined
01:37 synchroack joined
02:03 orbyt_ joined
02:42 jeffreylevesque joined
02:42 gentunian joined
02:54 point joined
03:05 culthero joined
03:53 <Soopaman> is there a way to "default" an ObjectId referencing field?
04:11 ajaniMember joined
04:11 s2013 joined
04:15 trompstomp_ joined
04:20 trompstomp joined
04:21 <trompstomp> I am getting back into using Mongo after not using it for a year or so and I am looking for recommendations on a good management tool. Previously I used Robomongo but just saw they were recently bought out by 3T (Formerly MOngoChef). I still plan on giving Robomongo a go but I was curious if anyone had any other recommendations. 3T looks nice but I'm not willing to pay that price.
04:26 coudenysj joined
04:29 <Soopaman> robomongo still is free
04:30 <Soopaman> It "works", though I use it alongside shell
04:35 Waheedi joined
04:35 <trompstomp> hmm. i'm ggona give it a go. I was just curious if there were other recommendtions. It doesn't seem like any of the options are that good. r I haven't fund them yet
04:36 <trompstomp> Or I haven't found them yet*
04:45 ayogi joined
04:53 armyriad joined
05:06 deever_ joined
05:07 ruairi_ joined
05:25 farchanjo joined
05:34 raspado joined
05:42 smokeysea joined
05:43 KamiRath joined
05:43 kyuwonchoi joined
05:44 kyuwonchoi joined
05:45 kyuwonchoi joined
05:56 lpin joined
06:24 svm_invictvs joined
06:28 emil_k joined
06:29 <emil_k> Hi
06:31 Sasazuka joined
06:31 <emil_k> I am relatively new to mongodb and got the responsibility to administrate a mongodb setup which consists of one mongos instance on one server and a replica set with three servers each on it's own hardware.
06:31 <smokeysea> with connection with replica-set in mongodb, does one have to make/break before every read/write?
06:32 <smokeysea> emil_k: whats the question?
06:32 <emil_k> Now the disks on the replica servers are getting full and I have prepared three new servers which I would like to use and replace the current replica servers.
06:32 <emil_k> My current setup is in version 3.0 , while I have three new servers which have 3.2
06:32 <emil_k> My question is if I can simply run something like this:
06:33 <emil_k> One moment, please-
06:35 <emil_k> to add the new servers with rs.add("new_server_1:27017") rs.add("new_server_2:27017") and rs.add("new_server_3:27017") , next wait a day or two until they are in sync and then run rs.remove("old_server_1:27017") rs.remove("old_server_2:27017") and rs.remove("old_server_3:27017")
06:35 <emil_k> Is it as simple like that?
06:35 <smokeysea> experts need (beyond my scope ;))
06:35 <smokeysea> SOS please
06:36 <emil_k> Ok. :)
06:38 Folkol joined
06:41 Letze joined
06:41 coudenysj joined
06:43 <smokeysea> emil_k: from https://docs.mongodb.com/v3.2/tutorial/expand-replica-set/ it seems like you can stop the mongodb copy the data to new space and use that space as data in new instance. and rs.add()
06:43 <smokeysea> but wait till someone needs to confirm this. :|
06:44 <emil_k> smokeysea, thank you for taking a look at it, while I would prefer the described scenario above (if it is possible just to avoid a downtime of the services based on mongodb) :)
06:46 kyuwonchoi joined
06:46 <smokeysea> they say if you add directly without copying the data from old-instance then sync will take long time. Hence its better to copy from stopped instance. But if you think downtime is crucial then whatever you said might work.
06:49 AvianFlu joined
07:05 <emil_k> So I could stop the mongod on secondary server, copy the data to the new server, and then simply start the mongod on secondary server again and start the new servers mongod? But the file format on new server is wired tiger, on the old one it is not wired tiger and might create some more complexity.
07:06 <emil_k> Whatever works, I will be happy if someone could confirm so I can resolve this situation. :)
07:11 tharkun joined
07:18 emil_k_ joined
07:19 klics joined
07:26 emil_k joined
07:26 <emil_k> Sorry, I might timeout sometimes. Hope I did not miss anything. :)
07:28 Lujeni joined
07:40 okapi joined
07:49 <emil_k> In regards of my previous questions, is it save under any circumstance to run those commands on the primary and add only one server for testing? Or might it break something?
07:51 <emil_k> Can rs.add("new_server_1:27017") ever break things on the operational replica set or is it generally save to use?
07:53 igniting joined
07:57 kexmex joined
08:00 coudenysj1 joined
08:08 gfidente joined
08:15 evil_gordita joined
08:18 armyriad joined
08:26 smokeysea joined
08:28 dsardari joined
08:45 <emil_k> Hi, is anyone there who might help me out of this misery described above?
08:48 Folkol joined
08:54 <emil_k> I am just little concerned if I can add another member to the three member setup or is it a problem?
08:58 coudenysj joined
09:05 Liara-- joined
09:06 <emil_k> Or is it better in our three member replication setup to remove one old mongod with rs.remove and add another new server with more disk space with rs.add ?*
09:09 VerdeRnel joined
09:10 neodarz joined
09:15 <neodarz> Hello, I have a little problem...I don't understand how to make a script like an sql script to create a database and add some rows in my tables. Somebody know please ?
09:25 <Derick> you don't need to create a database
09:26 <Derick> you just need to insert documents, and a database and collection will be created for you
09:27 SkyRocknRoll joined
09:27 <neodarz> oh, ok but can I named my database ?
09:29 <Derick> sure
09:29 <Derick> how are you connecting to MongoDB?
09:30 <neodarz> with the command line tool "mongo"
09:31 gregor3005 joined
09:32 <Derick> okay
09:32 <neodarz> My mogondb database is local and without password
09:32 <Derick> on the command line, you can use "use mydatabasename"
09:33 <Derick> or, you can start it with "mongo mydatabasename"
09:34 <neodarz> okay, this work. But I want to write this command in a file and execute this with mongo
09:36 raspado joined
09:43 <emil_k> Derick, you have ops. Can you possibly provide me with some advise here?
09:43 <Derick> emil_k: I didn't see a question?
09:43 <emil_k> Oh
09:43 <emil_k> I will copy and paste to pastebin
09:43 <emil_k> Give me a minuute
09:43 <Derick> neodarz: you can pass a .js file as argument to mongo too
09:43 <Derick> do a "mongo --help" and it says so in the 2nd line of the output
09:44 <neodarz> Oh ! Derick It's ok finally, juste a typo error... Thank you for your help :)
09:45 <neodarz> Ah I dind't the second line of the --help ... But ok now it's work.
09:46 <emil_k> Derick, https://pastebin.com/wJ14h73P
09:47 <Derick> emil_k: you can do that - but I would recommend one at a time, and wait until it's synced
09:48 <emil_k> So there is no problem to add a fourth server to a three member setup?
09:48 <Derick> before you add the second new one
09:48 <Derick> emil_k: no
09:48 <emil_k> Ok, that sounds great. :)
09:48 <Derick> it wouldn't gain you any extra failover capability, but it's not making it worse either
09:49 <Derick> emil_k: please also make sure that before you do a "rs.remove", the primary is not one of the nodes you're removing
09:50 <emil_k> Derick, thank you , understood.
09:50 jwd joined
09:52 <Derick> emil_k: it's the same as our recommended way of upgrading mongo versions really
09:53 culthero joined
09:54 <emil_k> Derick, okay, good to know. I just wanted to verify with someone experienced that I am not on the wrong track here . :)
09:54 <emil_k> Thank you!
10:00 yeitijem joined
10:00 <emil_k> Derick, I did that and can confirm now rs.status shows new member in "STARTUP2" state and syninc from existing member. Thanks again! :)
10:15 slajax_ joined
10:37 basiclaser joined
10:48 m1dnight_ joined
10:53 m1dnight1 joined
10:54 yeitijem joined
11:06 rendar joined
11:18 okapi joined
11:33 coudenysj joined
11:47 <jeffreylevesque> am i supposed to create an explicit database for my config server?
11:50 kexmex joined
11:58 coudenysj joined
12:10 RickDeckard joined
12:12 Folkol joined
12:20 synchroack joined
12:27 coudenysj joined
12:39 huhu joined
12:40 StephenLynx joined
12:42 huhu_ joined
12:48 <huhu_> Hello, is there someone familiar with configuring an auditFilter for MongoDB?
12:48 emil_k joined
12:50 dexteruk_ joined
12:57 ramortegui joined
12:58 coudenysj1 joined
12:59 jeffreylevesque joined
13:00 geoffb joined
13:02 Soopaman joined
13:02 edrocks joined
13:15 coudenysj joined
13:32 Liara-- joined
13:37 raspado joined
13:39 Folkol joined
13:41 <emil_k> Derick, are you available? The state changed to secondary now for the recently added member. But one think makes me suspicious.
13:42 <emil_k> While checking on the primary the db size
13:42 <jeffreylevesque> i'm wondering if I should use postgres instead of mongo
13:42 <Derick> jeffreylevesque: definitely not
13:42 <jeffreylevesque> howcome?
13:42 <emil_k> show dbs is showing
13:42 <Derick> jeffreylevesque: why do you make the statement?
13:43 <jeffreylevesque> they both support json, and there's like 900+ people in #postgres. I'm working on personal hobby project. But, between coffee breaks / lunch i'm trying to figure out how to setup mongo, and it doesn't seem like a trivial process
13:44 <Derick> posgresql's JSONB datatype is nowhere near the same as MongoDB's native rich data structures
13:44 <Derick> setting up MongoDB is installing a package
13:44 <jeffreylevesque> i'm using the puppet module - https://github.com/puppetlabs/puppetlabs-mongodb
13:44 <emil_k> Derick, https://pastebin.com/dUJgvugZ
13:45 <jeffreylevesque> and, i don't know if i need to create a database for my config server, explicitly
13:45 <Derick> jeffreylevesque: sorry, I don't know puppet. WHy do you need a config server?
13:45 <jeffreylevesque> for sharding
13:45 <emil_k> The size given by show dbs is significantly bigger compared to file system usage of the new member
13:45 <Derick> jeffreylevesque: are you needing sharding for a "hobby project" ?
13:45 <jeffreylevesque> sharding replica sets
13:45 <jeffreylevesque> i'm building a prototype for https://github.com/jeff1evesque/machine-learning
13:45 <Derick> emil_k: 3.2 with default wiredtiger uses compression
13:45 <jeffreylevesque> well, that repo is a prototype
13:46 <Derick> jeffreylevesque: how much data do you have?
13:46 <emil_k> Oh, aweseome. :)
13:46 <emil_k> Derick, thank you again.
13:46 <Derick> emil_k: also, new data has no missing holes (As it's not fragmented)
13:47 <jeffreylevesque> it's just development sandbox
13:48 <jeffreylevesque> one thing i'm stuck on, is whether I have to explicitly create databases, or setting the config server mode to true, implicitly creates the db
13:48 xspades joined
13:48 <Derick> jeffreylevesque: start with something small - you don't need the replicasets and sharding
13:48 <Derick> I *believe* you need to have a database existing before you can shard it
13:48 <jeffreylevesque> it needs to be running to shard and replicated
13:49 <jeffreylevesque> but, i could probably write some kind of logic into puppet to check if it can connect
13:49 <jeffreylevesque> if all hosts can connect to each other, then i can link them
13:52 threespades joined
13:53 <jeffreylevesque> Derick: you work on mongod on a regular basis?
13:53 ruairi joined
13:53 <Derick> I work on the PHP driver
13:54 jniebuhr joined
13:55 <jeffreylevesque> ah really cool
13:55 <jeffreylevesque> i'm looking for people to help me
13:56 <jeffreylevesque> it's taking me too long to develop this app
13:57 gentunian joined
13:57 jniebuhr left
13:58 jniebuhr joined
13:58 jniebuhr left
13:58 jniebuhr joined
14:00 culthero joined
14:02 <Derick> i've enough side projects :D
14:04 jniebuhr joined
14:04 jniebuhr left
14:04 jniebuhr joined
14:05 jniebuhr left
14:05 jniebuhr joined
14:05 jniebuhr joined
14:10 freeport joined
14:14 okapi joined
14:18 griffindy joined
14:22 gentunian joined
14:27 Folkol joined
14:33 edrocks joined
14:34 s2013 joined
14:41 freeport joined
14:51 felixjet joined
14:56 emil_k joined
14:58 gentunian joined
15:00 felixjet joined
15:12 coudenysj joined
15:18 igniting joined
15:18 synchroack joined
15:28 timg__ joined
15:41 jeansch_ joined
15:43 raspado joined
15:43 jeansch joined
15:45 raspado_ joined
15:48 orbyt_ joined
15:59 timg___ joined
15:59 <jeansch> Hi, I've got a sharded setup, each shard have a replicaset.
15:59 <jeansch> I would like to add a new member to one of the replicaset (let call him sh_1).
15:59 <jeansch> I tried two ways:
15:59 <jeansch> - using rs.add() on the PRIMARY of sh_1 quickly fail and the new host remove itself.
15:59 <jeansch> - shuting down the SECONDARY, copying data to the new host, starting both, and using rs.reconfig(with update conf.members), that start and fail later.
15:59 <jeansch> In both case, the new host remove itself because he found he is not in the replicaset config.
15:59 <jeansch> The new host have the right replication settings (the name).
15:59 <jeansch> Do I have to mention the new host elsewhere ? (eg: in the mongos or config servers)
16:00 <jeansch> Mongo version is 3.0.4
16:01 <jeansch> mongos status says:
16:01 <jeansch> mongos> sh.status()
16:01 <jeansch> --- Sharding Status ---
16:01 <jeansch> [...]
16:01 <jeansch> shards:
16:01 <jeansch> { "_id" : "sh_0", "host" : "sh_0/mongors1.xxx:27010,mongors4.xxx:27011" }
16:01 <jeansch> { "_id" : "sh_1", "host" : "sh_1/mongors2.xxx:27010,mongors3.xxx:27010" }
16:01 <jeansch> [...]
16:04 armyriad joined
16:04 svm_invictvs joined
16:15 m1dnight_ joined
16:19 philipballew joined
16:26 Doow joined
16:47 wowz joined
16:51 SkyRocknRoll joined
16:56 okapi joined
16:57 kexmex joined
17:02 <wowz> Hi all, I got this error while importing a 40Mb json file that was previously exported. The largest document is 3MB. https://pastebin.com/rBkmWXdg
17:04 <wowz> export was done mongoexport --db dpp_Demo --collection workPeriodData --out workPeriodData.json
17:05 <wowz> and import mongoimport --db=dpp_Demo --collection=workPeriodData /tmp/dpp_Demo/workPeriodData.json
17:05 <wowz> but now I get this error?
17:07 point joined
17:09 Halidith joined
17:11 svm_invictvs joined
17:14 <Halidith> Hi, im having trouble filling this schema with documents. What am i doing wrong? This is the code: https://pastebin.com/8wunqvCD
17:18 emil_k joined
17:35 Soopaman joined
17:42 shackra joined
17:46 omenius joined
17:47 <omenius> I've read too many times that people don't like mongo because "you have to make it act like real database". Is this really the case?
17:52 <omenius> also many people say that "mongo is just cache database" :D
17:53 <omenius> forgive my ":D", it's just somewhat tragicomic that something so big/efforted software gets this kind of accusations
17:54 artok joined
18:00 Sasazuka joined
18:04 saml joined
18:04 <saml> hey, I have a string field that should be ISO8601. is there a way to do group by by date? dropping timestamp
18:08 itaipu joined
18:10 <saml> {$project:{t:{$substr: ['$field', 0, 10]
18:12 coudenysj joined
18:14 realisation joined
18:17 Soopaman joined
18:18 arussel joined
18:19 Sasazuka_ joined
18:23 jwd joined
18:27 Sasazuka joined
18:27 apetresc joined
18:29 <arussel> Is there a way to know how long does a query has to wait inside the server before being processed ?
18:36 Soopaman joined
18:39 emil_k joined
18:48 pxed joined
18:50 pxed joined
18:50 coudenysj joined
18:55 pxed joined
19:00 gamespttr joined
19:00 <gamespttr> hi -- if i add an index to a field, will the index be on all documents, old and new?
19:00 <gamespttr> i'm adding the index via the shell
19:02 <arussel> it will index all documents
19:08 <gamespttr> thank you
19:13 m1dnight_ joined
19:25 emil_k joined
19:31 daivyk joined
19:32 amackera joined
19:40 okapi joined
19:48 emil_k joined
19:48 okapi joined
19:53 <JohnsonAskot> If I'm using a query like: db.products.find({"variants": { $elemMatch: { "meta.group.code": "M10" } } }, {"globalTitle":1, "variants.$": 1}); is there a way to specify what fields in "variants.$" that I want to return?
19:58 s2013 joined
20:08 giok joined
20:09 timg__ joined
20:09 arti joined
20:10 daivyk joined
20:16 philipballew joined
20:22 daivyk joined
20:23 emil_k joined
20:25 <gamespttr> JohnsonAskot, why not {variants.$.fieldToReturn:1}
20:25 <gamespttr> oh is variants.$ a complex doc hmm
20:31 ootje joined
20:31 jeffreylevesque joined
20:35 <JohnsonAskot> gamespttr Yeah I've tried that. It includes all the fields instead of just the one I selected
20:36 okapi joined
20:54 <jeffreylevesque> anyone here can help me setup a sharding cluster?
20:59 mvensky joined
21:01 daivyk joined
21:06 okapi joined
21:08 mvensky joined
21:17 <jeffreylevesque> what is " got signal 15 (Terminated), will terminate after current cmd ends"
21:19 <jeffreylevesque> can anyone help me debug - https://bpaste.net/show/382eae4072f0?
21:19 mvensky joined
21:26 saml joined
21:28 StephenLynx joined
21:29 orbyt_ joined
21:54 raspado joined
22:01 westeros joined
22:16 castlelore joined
22:16 castlelore joined
22:24 sftp joined
22:50 s2013 joined
22:56 Guest11008 joined
23:21 kyuwonchoi joined
23:33 Sasazuka joined
23:44 point_ joined
23:53 sz0 joined