Log file Viewer
#mongodb logs for Wednesday the 1st of May, 2013
[02:19:26] <doktrin> hello, I'm brand new to mongo. in the following statement, what is the closest relational DB analogue to "foo" - a DB, or a table? db.foo.save({ stuff:"blah"})
[02:24:05] <preaction> doktrin, a collection ("foo") is most-closely related to a "table". "db" is the "database"
[02:31:52] <doktrin> I noticed that everything seems to be namespaced in the db 'test' (i.e. db.foo returns "test.foo", & db.test -> "test.test") - where is the 'test' db name set?
[02:34:02] <preaction> it's the default database. you can specify your own on the command-line "mongo mydb", or inside using "use mydb"
[02:34:56] <doktrin> i guess I'm kind of over-used to postgres, where I have to basically sacrifice a few stray animals to get a db initialized
[02:49:38] <jonesy> hi all. Got a question about monitoring replication lag. I was figuring it should be done using db.printSlaveReplicationInfo and db.printReplicationInfo (comparing the 'syncedTo' and 'oplog last event time' & setting a threshold on the difference). I'm seeing a check right now that uses 'rs.status()', and just compares optimes.
[02:50:02] <jonesy> I thought rs.status optimes were the times of the last operation on each node, not the 'syncedTo' time.
[08:08:36] <pilgo> The following keeps giving me "Invalid modifier specified $unset" : db.lists.update({}, {$unset : { 'users' : 1}}, false, true)
[08:15:11] <Nodex> plus yo're using $unset wrong ... db.collection.update( { field: value1 }, { $unset: { field1: "" } } );
[08:58:52] <andre_fff> I have a doubt if I am choosing the right schema to a one to many relationship
[09:18:21] <pilgo> Nodex: Thinking I should back this up. ….just in case I mess up more than I already ahve
[10:43:51] <ExxKA> Hey guys. Yesterday I was in here asking about how best to extract the date from an _id field for using aggregation/mapReduce. I wrote a short article about it, and also about how to create _ids with a custom time and date. Enjoy! http://bit.ly/14TJsyz
[10:45:54] <landstalker> what are your experiences of restoring using mongorestore? I did a test complete restore yesterday of an 83GB backup which when installed created 173GB of data. It took around 8 hours
[13:30:22] <gheegh> hey all, i'm fighting a cursor not found message. I'm curious about opinions. If I need to retrieve a small amount of data from maybe 100,000 documents (3 of 100 fields), am I better off iterating over the collection to get it pulling only that data, OR am I better off doing 3 queries asking for just the unique value of each of those fields?
[13:47:57] <Baastrup> Hello, maybe someone could offer some insight. When using the $sort modifier with $push, is it possible to set a $slice of unlimited? ..or; why isn't it?
[14:07:00] <gheegh> hey all.. quick question.. i'm trying to find documents with an integer value that is within X of another document in the same collection.. ideally, i'd like to do a query that just returns those values.. this will be over about 100,000 documents.. is there a better way to do this in mongo other than just iterating over the collection to grab those values?
[14:07:52] <kali> gheegh: this is the equivalent of a self join... not something mongodb likes very much to do :)
[15:43:44] <dukedave> Is it still true that MongoDB does *not* support compound indexes containing a 2d index, but not starting with the 2d index? As per: http://stackoverflow.com/questions/7986027/geospatial-indexing-with-a-simple-key-first
[15:51:56] <akrs> Hey guys - i'm trying to find the most commented items from a collection where comments are a property (array). aggregation framework gets me the item ids, which i then pass to a where-in call, but the come back unsorted, so I have to re-order them manually. Is there a simpler way to get this set? Thanks.
[16:04:30] <idea-users225> Hi! MongoClient is throwing "java.net.UnknownHostException" even though I localhost loop setup in my /etc/hosts and can ping it from terminal
[16:29:32] <dukedave> Can someone sanity check this comment I just made: http://stackoverflow.com/questions/5125521/uses-for-mongodb-objectid-creation-time#comment23373272_5128574
[16:33:17] <Nodex> on sharded / replicated systems there is not clashes so this means that TRUE sorting can always occur
[17:24:43] <akrs> Nodex, can't sort on length of a property (e.g. Item.comments.length) - unless I'm mistaken.
[17:48:48] <JoeyJoeJo> I have fields in my collection which represent points of a polygon. Does mongo have any function that can tell me if two polygons intersect?
[17:51:22] <gazarsgo> i think you'll need to conform to GeoJSON if you want to use mongo's spatial stuff
[17:52:14] <gazarsgo> http://docs.mongodb.org/manual/reference/operator/query-geospatial/#geo-overview-location-data
[17:58:48] <JoeyJoeJo> I have one more question - I want to delete duplicates. I consider two documents to be duplicates if field1 and field2 are the same in each document. I then want to delete the document which has the greatest value in field3. Is that something I can do in mongo or would I have to do that in my app?
[18:02:29] <TkTech> Does $and not work on arrays? I'm trying to find all documents where the array "products" has a sub-document with field == 1 but no sub-document with field == 2
[18:04:40] <Infin1ty> someone accidentatly ran a query using "id" instead of "_id", it created a huge load on the database, i killed those operations, but yet, they appear to come again with new opid
[18:04:58] <Infin1ty> the cluster is now in some kind of a loop because of querying by "id" instead of "_id" and i can't kill those operations
[18:08:44] <Tark|2> if I do follow: db = MongoClient().dbname in global part of my script, it won't use a pool, isn't it?
[19:05:17] <hobbinator> I am trying to use Python streaming in the Mongo Hadoop connector. I am getting a ClassNotFoundException for MongoStreamJob. However, documentation states that the streaming-assembly jar file should compile since I am using a Hadoop version 0.23.x
[19:06:06] <hobbinator> I am specifically using 0.23.7, should I roll back to 0.23.1, or are there any other dependencies that should be in my hadoop/lib folder?
[19:16:04] <pr_op> Im getting an error with nonAtomic out flag in pyMongo. Using a reduce action, tried the same parameters in console w/o issue.
[19:18:07] <pr_op> pymongo.errors.OperationFailure, failed: exception: unknown out specifier [nonAtomic]. works in console, not pymongo
[19:55:56] <tjmehta> Hello everyone, is there a mongo query operator that determines whether a document key is not an array?
[21:05:36] <kali> mali: it used to be fine, but since 2.4, config server are eating a bit too much ram and cpu for my taste
[21:38:13] <Almindor> if you do a find and it uses a compound index (say 3 keys 1st being the '2d'), is there a way to see if it actually used the two other parts of it?
[21:39:17] <Bilge> I want to be able to compress the output without it touching the local file system
[21:45:24] <mgriffin> I didn't see anything in http://docs.mongodb.org/manual/reference/explain/ (eg mysql uses key_len in explain output)
[22:04:47] <glitch273> Hello, I'm having some trouble googling this but how would I setup a simple string Enum type (ie. for status like "active" or "dismiss")? I'm using MongoEngine.
[22:43:24] <[Neurotic]> Don't suppose there is anyone in here that takes care of the Ruby driver for Mongo?
[23:21:56] <liubei> i have 3 mogod in a replica set, running in 192.169.1.1 each one in a port (27017, 27018, 27019)
[23:23:14] <liubei> MongoClient("192.169.1.1:27017", replicaset='rs0', read_preference=mongo.ReadPreference.SECONDARY)