Log file Viewer
#mongodb logs for Tuesday the 19th of March, 2013
[00:26:02] <joshua> anyone familiar with what a " warning: Finding the split vector for database.collection..." type of message means in the logs
[09:02:02] <halfie> hi, I have an array in my data (each entry has this array), the array has bunch of dictionaries. How do I search based on a particular dictionary value?
[09:31:28] <ron> not good, unfortunately. got one of those diseases that can take months to recover.
[09:53:22] <resting> mongo _id.getTimestamp shows a different time from my system…how do i change it?
[09:59:27] <resting> kali: erm…basically the when i do getTimestamp() on the _id object in the shell, it shows a different time from my system
[10:01:29] <ron> Nodex: yeah. and of course I have a new project at work where I need to create a pilot in 2 months, during which I also need to hire and train 10+ employees.
[10:02:51] <ron> Nodex: no, sortof a demo of the application but one that you actually give the user to... use.
[10:04:55] <Nodex> for example in PHP you can set the default timezone of anything that calls an epoch
[10:05:19] <Nodex> ergo if you're language and framework/driver allows this then it's probbly set in there somewhere
[10:10:08] <Nodex> http://stackoverflow.com/questions/1620188/how-can-i-set-the-time-zone-before-calling-strftime
[10:12:54] <resting> Nodex: hm…you mean the C drive is affecting the timestamp? weird though cause its only this system that has problem...
[10:15:02] <Nodex> can you do this.... var t=new Date(); var ta=t.getTime()*1000; db.foo.insert({timestamp:ta});
[10:21:41] <Nodex> then get the document you inserted and do "getTimestamp()" on _id and compare the 2 results
[10:24:07] <resting> Nodex: the one you told me to insert? _id is wrong..but the 'timestamp' is correct
[10:39:58] <kali> resting: run this and show us the output, please: mongo --nodb --quiet --eval "new ObjectId().getTimestamp()"
[10:40:11] <kali> resting and then this: TZ= mongo --nodb --quiet --eval "new ObjectId().getTimestamp()"
[10:44:07] <kali> resting: mongo stores UTC. displaying the timestamp in the right timezone is up to you
[10:45:54] <resting> kali: hm..really..i see…hm..i thought it displays fine in other systems…let me see if i can do a quick check
[10:47:43] <resting> kali: hm..nope…some how this system is saving in UTC…i have a system that saves in JST fine
[10:48:58] <kali> resting: mongodb does not store the timezone, the driver translate the time object from the language in a simple utc numeric timestamp
[10:49:35] <kali> there is nothing out of spec in the behaviour you showed us, so i don't know how to help
[14:34:27] <Gargoyle> Don't mind. A mongodump tar balled up is fine. But whatever is easiest for you?
[15:42:46] <Nodex> "Faster Counts: In many cases, counts in MongoDB 2.4 are an order of magnitude faster than previous versions. We made numerous optimizations to the query execution engine in order to improve common access patterns. One example is in a single b-tree bucket: if the first and last entry in the bucket match a count range, we know the middle keys do as well, thus we do not have to check them
[16:33:54] <nDuff> dreeerererere34: MongoDB is schemaless. If you want to store an array, just push a document with a JSON list.
[16:34:43] <nDuff> dreeerererere34: If your question is about some particular set of database bindings, we couldn't answer it without knowing the library you're trying to use.
[16:35:50] <dreeerererere34> nDuff i'm working with node.js and mongoose and i need to define type of data which i will use. i already tried to use schema.types.mixed and schema.json and both are working, but the problem is on output because it outputs numbers without arrays
[16:44:37] <double_p> hi. tried an update from 2.0 to 2.2.3 by adding a new secondary rs. which works if you start with a full replication.. but if i try so w/ scp'ing the whole data_dir before, it fasserts. wasnt 2.2 meant to be container-compatible to 2.0?
[16:45:52] <bmcgee> hey guys, I'm trying to implement simple filtering with paging support on my collection. Basic idea is laid out here: https://gist.github.com/brianmcgee/5197686. Are there any standard patterns I should be aware of?
[16:51:17] <upayavira> Question: I've done rs.initiate(). I want to do the opposite, make it back into a single stand-alone node. Should I just restart mongo without replSet=rs1?
[18:54:48] <maginot> Hello fellas, I'm a little confused about the using the specific bson types in a json document for struct modeling. Is there a place where I can find an example of the types written in a json file?
[18:56:19] <maginot> is this right: { $timestamp : "2000-10-10 01:01:01", $date: "2001-01-01", $ObjectId: 12345... } ?
[19:05:51] <apetresc> Hey guys, I've got a strange problem; I've got a snapshot of an old Mongo server's data directory and I'm trying to attach a new mongo instance to it. I've set the dbpath properly and the lock file is appearing in the right place, but none of the dbs/collections that are supposed to be in there are showing up. When I do "show dbs' it only shows (local). Anyone know what's up?
[19:06:03] <apetresc> It's not a permissions issue, the mongo user is able to read/write to the data directory without a problm
[19:08:38] <lazyPower> Whats in your oplog? may have some pointer as to whats going on thats preventing the database instance from seeing the data
[19:09:33] <apetresc> lazyPower: is oplog just the regular log file? Here's the contents: https://gist.github.com/5199150
[19:20:36] <ehershey> because the actual data files aren't in your directory directly but look like they must be in subdirectories
[19:39:04] <Mkop1> if I have a collection with documents like {name:'Whatever',owner:['John','Mary','Sue']}, how can I get all documents owned by John?
[19:40:38] <AAA_awright> And you can match any item an in Array to any item in an Array with... I forget, $in or $any or something like that
[19:41:37] <Mkop1> can I arbitrary sometimes have owner: 'John' and sometimes owner: ['John','Mary'], and find both with the same query?
[19:46:54] <AAA_awright> I'm not sure if there's indexing for this case, I doubt it, so the order in which they are specified may make a difference
[19:47:41] <AAA_awright> If you know Mary owns fewer documents than John you'd want to filter for that first, then 'John'... anyone know how this works exactly?
[19:57:03] <meekohi> Hey I'm trying to understand why a simple update doesn't work: db.twists.update({"created_at": null},{$set: {"created_at": +new Date()}}). What's the usual way of 'debugging' things with mongodb shell?
[19:57:42] <AAA_awright> Mkop1: That's just making sure you can do queries on single items in the array, it doesn't let you efficently do queries like "find documents where owner CONTAINS 'Mary' AND 'Sue'"
[19:58:32] <AAA_awright> Mkop1: The best you can do is search first for the Owner that returns the smallest set, then go through in O(n) time on the remaining owners listed
[20:30:20] <pala2> What does this sort part mean?? Users.find({score: {$gt: 100}}, {sort: {score: -1}});
[20:33:42] <jmpf> running sharded 2.2.3 - do I need all my mongos upgraded to 2.4 && use --upgrade 1st? or can I just start doing rolling upgrades?
[20:43:15] <roel__> Hello all, need some info to point me in the right direction: is it possible to use mongo as main DB and link another DB behind it that is near-real-time and receiving updates, kind of streaming? To store certain properties by collection and trigger some applications when required.
[21:18:02] <therealkasey> so someone tried to do a mongorestore on a nearly full disk. aborted it when they realized the error of their ways. deleted the raw db files from /var/lib/mongodb. still have the lock issue. note that the journal files are north of a gig, and we've only got 714M free on the disk. are these journal files likely full of changes from the restore waiting to be applied?
[21:28:24] <tworkin> whats the best way to store a ~4mb string? im afraid this pushes the max bson object size
[21:35:36] <therealkasey> WarDekar: use the dot notation to refer to the nested field: ensureIndex({"document.deep.dark.value" : 1})