Log file Viewer
#mongodb logs for Monday the 22nd of June, 2015
[01:21:31] <AbuDhar> I mean have my collections(tables) with defined attributes like with MySQL? lol
[01:24:52] <cheeser> depends on the language. i think mongoose supports that if you use python. morphia does if you use java. c#'s driver will.
[01:25:23] <cheeser> with statically type langauges you kinda get that schema enforcement for free. most ODMs would give you some version of that.
[01:27:57] <joannac> AbuDhar: there are a steady stream of people through this channel who use mongoose without really understanding mongodb, and get themselves into trouble
[01:28:14] <joannac> if you're going to use mongoose, make sure you understand what it's abstracting
[03:38:39] <cheeser> http://docs.mongodb.org/manual/administration/production-notes/#kernel-and-file-systems
[03:57:25] <krebipeti> i would like to create a system which is insert data on the primary server, and all read will be balanced to the secondary server. i'm thinking about spreading the load between read/write
[03:59:41] <krebipeti> ahh...alright. i'm actually a bit confuse when to use replication and when to use sharding. so i can do that by sharding?
[04:00:28] <cheeser> sharding is for spreading read/write loads. replication is for durability and failover.
[11:01:33] <Sp4rKy> Hi, I have a replicaset with a primary and a secondary. I want to remove the secondary (so that I move to a standalone instance) and remove the db from the (old) secondary
[11:02:03] <Sp4rKy> I used rs.remove to remove the secondary from cluster, but then I get "not master" when trying to remove the db on the secondary
[11:17:12] <coudenysj> Sp4rKy: are you issuing the remove command on the secondary or on the primary?
[11:17:51] <Sp4rKy> coudenysj: I achieved it by then restarting the (old) secondary with no replSet param
[12:38:19] <djMax> I have a 3 member replica set that got "moved." All the hostnames are now different. I can't seem to reconfig them as it keeps telling me "LOADINGCONFIG" failed. Is it possible to revive them?
[12:41:17] <deathanchor> djMax: not recommended, but you could start them up standalone and modify the local db where the replica info is stored. (db.system.replset) then bring them all back online
[12:44:23] <deathanchor> yeah, what I did was just trust one to be the primary. stated it in standalone, dropped the 'local' db and started it up in replset, and did an rs.initiate() on it, then added the other hosts one at a time.
[12:45:05] <djMax> interesting. And blew away the db entirely on the others? Or just let replication take care of it?
[12:45:56] <deathanchor> but I don't think the others will allow it to sync if it has an old config in place
[12:46:18] <deathanchor> so you need to blow those away too (or config them manually in standalone mode)
[12:46:31] <cheeser> the recommendation, i think, is to add new replica set members on the new hosts and remove the old ones one sync is done
[12:52:19] <deathanchor> since you are starting it in standalone to make the small mod, why not just turn off auth and just do a bind to the localhost to avoid anyone else using it while you mod the local db?
[13:05:48] <djMax> seems like it's back up. One is still "RECOVERING" which seems odd because there shouldn't be much to recover
[13:10:48] <djMax> docs seem to suggest I should remove the dbpath, but wouldn't that lose the replica set config?
[13:41:08] <nalum> hello all, I'm running an aggregate function to add 7 hours to a date, is there a way to restrict it to only affect documents that have a specific value set in a field?
[13:55:50] <vagelis> Hello, can u see my message? ChanServ says that I have to register my nickname even though i think I have done it.
[13:57:37] <deathanchor> vagelis: you don't need to ask permission to ask a question related to mongo (or it's various flavors)
[14:00:49] <vagelis> Well I had the impression that even though the room is called Mongodb its not supposed to be a place for questions :s I dont i just had this impression. Ok so, my question is, well I am trying to understand the explain(). So in winning plan the inner brackets say IXSCAN. Even though the query is find({ random_field { $gt: 5 } }).sort({ index_field: 1 })
[14:01:21] <vagelis> So even though the query doesnt use an index for find, it uses index for sorting.
[14:02:06] <vagelis> The answer to the question if query uses index to find and match document is NO why the inner brackets show IXSCAN?
[14:04:21] <vagelis> random_field is just a random field. index_field is a created index. I tried to name them like that so you can understand.
[14:06:39] <deathanchor> vagelis: not sure of the question exactly, but if the query uses one index, then the sort will either use the same index or not at all.
[14:11:52] <deathanchor> how about sharing a gist of the explain output? you can sanitize any private info
[14:12:58] <vagelis> well i dont know what is supposed to be private info :S i am currently in the mongouniversity and I dont know what should/should not show
[14:17:33] <vagelis> Also i dont get why it does it backwards. I asked that and I am waiting an answer but this is less important for me right now.
[14:21:50] <deathanchor> ok, so the query didn't use an index to filter because random_field wasn't indexed, but the sort was indexed, so I used the index for sorting only it appers.
[14:24:14] <deathanchor> vagelis: I have no mongodb 3.0 exposure, (hence my stating I'm always on the old old fogy version of 2.2, 2.6)
[14:28:25] <fxmulder> so I found that after setting up sharding and migrating data, the original shard still contains the old migrated data leading to duplicate documents between the shards, whats the best way to clean that up?
[14:56:11] <deathanchor> saml: you can also try a strings on all the files and grep and hope you find something useful
[15:00:25] <GothAlice> fxmulder: "admin" and "local" are used to control MongoDB behaviour and store internal state.
[15:04:14] <GothAlice> It's automatically created the first time it's needed. I.e. when adding the first user after enabling authentication, when setting up a replica set or shard array, etc.
[17:13:25] <shlant> anyone know how I can give truly "full access" in mongo short of assigning every role to a user? My app seems to not be able to access some data or create some db's and in attempting to troubleshoot if it's permissions, I tried using a "root" user, but that doesn't seem to give me the "full access" permissions I want.
[18:25:32] <Argorok> Hi! How can I sum a field and group by dayOfWeek? I wanna build a query that retrieve for me the sum of the field grouped by day of week of another field
[18:27:14] <Argorok> deathanchor, Is the only way to do it? Ok, let me try. I saw it in the docs, but looked like a lot more than what I need
[18:27:46] <StephenLynx> if you need to perform any operation that relates several documents to produce another one, you have to use $group
[18:28:03] <StephenLynx> and afaik you can only do that on aggregate, but I am not 100% sure of all that.
[18:32:36] <Argorok> No problem :D Hmmmmm, project is like projection and not a project itself. I was reading the word project and translating in the wrong way when I first read
[18:38:29] <deathanchor> I read it as Pro-Ject (project onto a screen) not Pra-ject (like a working project)... NY accent here.
[18:50:43] <m3t4lukas> thing is when I use logstash it's difficult when there are multiple logging formats...
[18:53:45] <StephenLynx> I always got curious. What kind of scenario uses both C and mongo? What are you using mongo for?
[20:45:27] <tejasmanohar> name: { first: String, last: String } vs firstName: String, lastName: String
[21:46:34] <Siamaster> db.createUser({"user": "Siamaster", "pwd": "myPassword", "roles" : [{"role": "dbOwner", "db" : "MyAppDb"}]});
[21:54:19] <Siamaster> and show collections aren't working in the admin database when I'm logged in with a user with the userAdminAnyDatabase role
[23:54:58] <shlant> anyone know why I would get "connected to: blah" with mongorestore and that's it? it doesn't restore anything and no output