PMXBOT Log file Viewer

Help | Karma | Search:

#mongodb logs for Thursday the 30th of April, 2015

(Back to #mongodb overview) (Back to channel listing) (Animate logs)
[02:00:07] <mongodoh> hello
[02:44:15] <morenoh149> mongodoh: yo
[02:48:38] <mongodoh> oh hello there
[03:12:49] <arussel> GothAlice: thanks for your answer 'db.collection.update({arr: {$elemMatch: {a: "b"}}}, {$inc: {"arr.$.t": 1}})' is there a way to have it all in the update ?
[03:13:07] <GothAlice> No.
[03:13:20] <GothAlice> $elemMatch stops on the first match.
[03:14:08] <GothAlice> http://docs.mongodb.org/manual/reference/operator/projection/positional/
[03:14:17] <GothAlice> See the first paragraph of the definition.
[03:57:16] <arussel> GothAlice: thanks
[03:57:32] <GothAlice> It never hurts to help. :)
[04:10:20] <mongodoh> if i wanted to replicate data from Oracle to MongoDB, what would be the best solution?
[04:12:24] <mongodoh> Oracle DB is for OLTP application but MongoDB would only need a subset of the data
[04:12:57] <mongodoh> MongoDB would be used primarily to feed an online search function
[04:14:06] <mongodoh> found some stuff online using triggers in Oracle
[04:14:47] <mongodoh> seemed doable but maybe not so common since I couldn't find much on the topic
[04:26:47] <joannac> mongodoh: erm, why?
[04:27:19] <joannac> Oracle's schema will likely be inefficient for MongoDB and vice versa
[04:27:34] <joannac> it really wouldn't make sense to have a straight sync between the 2
[05:16:51] <mongodoh> joannac: found a decent json pl/sql library so it wouldn't be hard to create a document for the subset data from Oracle
[05:17:14] <mongodoh> the search application will likely live in the cloud as well
[05:17:52] <mongodoh> would want a database capable of existing there with the application as well
[05:18:21] <mongodoh> and it would only be a one-way sync
[05:18:32] <mongodoh> oracle->mongodb
[05:58:04] <wday> mms backup provisioning question - for existing large installations, do new shards need to be provisioned on the mms backup backend before being added to the cluster, or is it safe to add more shards and let mms backup pick up the change?
[06:18:53] <Boomtime> wday: when you select a cluster for backup in mms, it will resolve the shards, at all times
[06:19:19] <Boomtime> you _must_ not select individual shards for backup (like you would a replica-set) or this will actually block proper function
[07:50:12] <jeanre> hi all
[07:50:48] <jeanre> is there a way to add two hours to $group: { _id: { hour: { $hour: "$stopTime" } }}
[07:52:11] <jeanre> because mongo uses UCT and we are in GMT my query is returning the incorrect date
[08:51:46] <newbsduser> how can I increase update operation count /per second... (current max update operation count 2000-3000 on single instance). I read about fast updates.. Are there another options to do that?
[09:05:53] <girb1> new to mongDB please help .. I'm dumping 30 days old data as JSON dump to file using pymongo
[09:08:00] <girb1> when I restore there is a different ObjectID in mongo .. is there a way I can restore the same ObjectID
[09:49:53] <pigoz> supposed I have a collection with an array field. I have a record with field: [a, b, c], I want queries with [a, b, c] or [a, b, c, d] to match, but for example: [a] should not match. Is there a way to model this?
[09:58:57] <errakesh1> which database admin is better one ?
[10:26:48] <errakesh1> which database admin interfase is better one for mongodb?
[10:31:53] <KekSi> depends on what you want from it - i personally like robomongo but it's useless with my current setup (using ssl certificates to log in - which robomongo doesn't support yet)
[11:40:32] <bigon> Hi
[11:41:28] <bigon> we would like to upgrade from 2.0.2 to 2.6.x, can we just upgrade in one go? or should be upgrade with all the intemediate versions and restart in between
[11:41:31] <bigon> ?
[11:50:13] <Hilli> bigon: You have to go 2.2, 2.4 and the 2.6. Release docs has the details.
[13:41:30] <inad922> Hi
[13:41:48] <inad922> I try to create a user on mongodb and connect to it via pymongo
[13:42:04] <inad922> I create the user via this method
[13:42:05] <inad922> http://docs.mongodb.org/manual/tutorial/add-user-to-database/
[13:42:32] <inad922> But I'm unable to create documents in the given database with pymongo
[13:42:43] <inad922> Anyone has a guess what might be the problem
[13:42:44] <inad922> ?
[13:44:25] <deathanchor> any errors?
[13:45:00] <inad922> deathanchor: Yeah, a connectionerror
[13:45:43] <deathanchor> have you tried connecting with just plain mongo -u user -p pw ?
[13:46:17] <inad922> If I connect with client = MongoClient("mongodb://newrelic:kft7dx@127.0.0.1") it doesn't work even if I try to access the db via db["newrelic_test"] but if I connect via client = MongoClient("mongodb://newrelic:kft7dx@127.0.0.1/newrelic_test") it just works
[13:46:26] <inad922> Yeah plain mongo works too
[13:46:40] <inad922> mongoengine seem to fail though
[13:47:51] <ignasr> hello, I am trying to find why mongodb is saturating my disks with ~1000 IOPs every hour for one minute, when normally I have ~100 IOPs (DB size 6GB, RAM size 4 GB). How should I debug this? mongostat show locked > 100% and queue build up, but it seems that this is only the result of IO starvation.
[13:48:49] <ignasr> seems like flushes of some kind, but can't find the source
[13:48:51] <deathanchor> ignasr: I'd check the logs for any db ops which take a long time.
[13:49:17] <deathanchor> inad922: sorry I don't have much exp with pymongo and auth
[13:53:36] <ignasr> deathanchor: lots of slow queries logged for that minute, but again, its probably only the result of slow disk responce at that minute. There is no query count increase at that time
[13:53:59] <ignasr> otherwise nothing strange is logged. Maybe I should increase the loggin level
[13:55:38] <ignasr> its a standalone instance, so no replication
[14:01:53] <pamp> with wiredtiger which is the maximum concurrent writes recommended?
[14:22:35] <demahum> I am following this tutorial: http://www.learn2crack.com/2014/06/android-chat-application-using-gcm-server.html#, but I am stuck at the mongoDB part of it. I have created a database using robomongo, but now I should create a directory (you will recognize steps on the link). Any help?
[14:32:35] <StephenLynx> demahum you don't have to create databases or collections, you just use them and mongo will create them if they are not found
[14:35:12] <pamp> wiredTigerConcurrentWriteTransactions anyone have knowledgment about this?
[14:35:26] <pamp> for an 8 core processor?
[14:35:38] <pamp> for best write perf
[14:37:56] <revoohc> Anyone know where to find the definition of what serverStatus.opcounters.command is representing? We just upgraded from 2.2 -> 2.6.9 and our command numbers have dropped significantly. All I’ve been able to find out is that 2.6 is no longer counter writes as commands. But what exactly is it counting as a command?
[14:41:31] <demahum> StephenLynx: thanks. :)
[14:44:16] <terlar> Anyone using the new Ruby Driver 2.0? I have been experiencing some weird issues.
[15:14:39] <eren> i guess I'm stuck at STARTUP2 phase
[15:14:58] <eren> I got mongodump and restored it to secondary nodes
[15:15:04] <eren> then I started replicated cluster
[15:15:35] <eren> now secondary nodes are STARTUP2, and I see that one of them reports " clearing collection plan cache - 1000 write operations detected since last refresh."
[15:15:52] <eren> the other one doesn't report it but it reports: STORAGE [rsSync] clone ceilometer.meter 10647551
[15:16:02] <eren> should I wait?
[15:40:26] <mmars> when I configure mongod v2.6 w/ replSet, what does that config option do? what if I run mongod with a replSet option but don't initiate a replication set or configure one?
[15:45:41] <gansbrest> hi. My logs seem to be filled with following messages http://pastebin.com/tDHaahcM
[15:45:56] <gansbrest> That instance is long gone
[15:46:11] <gansbrest> why is it still going crazy about it
[15:46:24] <gansbrest> how to disable
[15:56:18] <terlar> I get `NoMethodError: undefined method `dispatch' for nil:NilClass`
[15:56:23] <terlar> https://github.com/mongodb/mongo-ruby-driver/blob/master/lib/mongo/operation/executable.rb#L35
[16:32:10] <dorongutman> hello
[16:34:15] <dorongutman> I have a collection of photos, in which every document has an object representing different sizes of photos: {_id: 11112222, sizes: { small: “http://blabla.com/11112222.small.jpg”, medium: “http://blabla.com/11112222.medium.jpg” …… etc..
[16:35:13] <dorongutman> is there an update query I can run that changes all collections with a “medium” size to a different url such as http://blabla.com/11112222.mid.jpg ?
[17:20:50] <Valesk> Did the C# Driver for Mongo remove FindAllAs()? Can' t seem to find any recent documentation on it..
[17:23:57] <Xeon06> Hey guys. Can anyone tell me if it would be a good idea to make sure that find queries like {foo: {$in: ["one item"]}} are changed to {foo: "one item"} or is that optimization already taken care of?
[17:25:22] <deathanchor> Xeon06: use .explain() to compare time and performance
[17:27:40] <Xeon06> deathanchor: Didn't know about that, thanks!
[20:01:38] <arussel> is there a way to push into an array and remove element in a single update ?
[20:04:38] <StephenLynx> I believe so.
[20:04:48] <StephenLynx> you can have several operations in a update block.
[20:06:18] <arussel> db.foo.update({}, {$push: {a: 3}, $pull: {a: 1}})
[20:06:30] <arussel> => "errmsg" : "Cannot update 'a' and 'a' at the same time"
[20:06:39] <StephenLynx> hm
[20:07:05] <StephenLynx> yeah, then maybe not.
[20:07:29] <arussel> strange as $push/$sort/$slice does kind of 2 queries on the array
[20:08:39] <StephenLynx> they perform 2 operations.
[20:08:45] <StephenLynx> but only one is an update.
[20:08:53] <StephenLynx> the others are just handling read data.
[20:10:01] <arussel> no $each add to the array, $slice remove from the array, they're 2 updates.
[20:10:25] <StephenLynx> ah
[20:10:32] <StephenLynx> wait
[20:10:46] <arussel> but that doesn't really solve my problem :)
[20:10:48] <StephenLynx> isn't $slice a projection operator?
[20:11:17] <StephenLynx> ah, theres a $slice in update too
[20:11:31] <arussel> I have a list of object, {timestamp, value}, I need to push a new value and remove the value older than a specific timestamp
[20:11:45] <StephenLynx> those silly ambiguous operators
[20:46:21] <jr3> test
[20:46:43] <GothAlice> pass
[20:58:01] <PVDM> Hey guys... I'm trying to see if I can do this with mongoose, but not getting much help in my google searches: I have object/collection A which references Object/collection StaticA, I want to limit my results in a query of A by something defined on StaticA...
[21:23:05] <PVDM> NE1?
[22:19:19] <joannac> PVDM: #mongoosejs is probably better for this?
[22:28:03] <PVDM> ahh, thanks. I came to the conclusion that we there was a better way to structure our data :)
[22:38:31] <GothAlice> PVDM: Due to the number of support requests I see involving Mongoose, it's my general suggestion to prototype data design and methodology using raw MongoDB tools instead of abstraction layers. This can make support easier, as well as eliminates distractions. MongoDB is schema-less, and making use of this for prototyping saves a lot of time.
[22:39:15] <GothAlice> (If you can't get it working in the MongoDB shell, it's doubtful adding more glue will improve things. ;)
[22:39:48] <PVDM> yeah, i kind of came to that conclusion :). Thanks!
[23:57:27] <Wulf> hi
[23:58:16] <Wulf> I've got a collection named `stats'. How can I see what's inside? db.stats.find() says "TypeError: Object function (scale){ return this.runCommand( { dbstats : 1 , scale : scale } ); } has no method 'find'"