Log file Viewer
#mongodb logs for Sunday the 6th of July, 2014
[00:19:45] <rfk> trying to connect to a mongodb instance running on ::1 using the 'mongo' interactive shell
[02:20:08] <rfk> `mongodb --ipv6 --host '::1'` -> "getaddrinfo(":") failed: hostname nor servname provided, or not known"
[02:34:06] <rfk> thing with the source is that the error seem to be from within the Mongo instantiation, which i guess is an object provided by the C++ API?
[02:34:20] <rfk> i've never read the source so i don't know, but i don't see the definition of the Mongo class in the JS anywhere
[02:36:33] <mehwork> "hostName may be an IPv6 address (with colons), in which case ":portNumber" is required"
[08:45:30] <lv92> i know that no sql is schema less .. but due to represent the logic schema i will make an example of that.
[08:52:19] <rkgarcia> lv92: but graph database is noSQL database as mongodb is but, they are different
[09:23:33] <kali> i don't think any graph database stores its data as a graph on disk :) neo4j uses linked lists of fixed records IIRC.
[09:36:20] <lv92> ok but for physicaly normally mean how the information are store in the file system
[11:41:03] <yakari> I try to connect via php on my remote mongodb server but i have an auth error message
[11:51:50] <inad922> I'm actually using mongoalchemy and I would like to do a transaction and if it fails just revert everything
[11:58:51] <kali> inad922: there is nothing like this in mongodb. you have to compose with atomicity of change on a single document and findAndModify
[11:59:41] <kali> inad922: you can implement a two phase commit on top of this, and possibly revert a half done operation, but you're more or less on your own
[11:59:51] <inad922> kali: Uh, that's really bad. So I can't just commit a series of changes and if any of them failes I just can't revert?
[12:38:27] <jsjc> Hi! I am newbie o mongo and struggling to get what I can think it should a simple query… I am trying to match all documents that have an element a that cointains $all [1,2] and added t this a array must have max 2 elements.
[12:39:13] <jsjc> I got to match all documents with 1,2 with this .find({'a':{'$all':[1,2]}}) but cannot end up limiting just to the documents that have a size 2
[15:43:55] <kali> in some cases, you may have subtypes stores together, like a "person", a "user" or an "employee" or whatever you apps handles. in that case either the precise type can be deduced from present or absent fields, either you add a field to specify it
[15:46:29] <Es0teric> hi, i am running mongodb on mac and it was installed through homebrew… when i run `mongo` and it tries to connect to "test" i get this error: warning: Failed to connect to 127.0.0.1:27017, reason: errno:61 Connection refused
[15:51:11] <Es0teric> kali i get this -> launchctl: Couldn't stat("/Users/leo/Library/LaunchAgents/homebrew.mxcl.mongodb.plist"): No such file or directory
[15:53:12] <kali> i'm not sure how the homebrew package is supposed to be run... http://docs.mongodb.org/manual/tutorial/install-mongodb-on-os-x suggest that it only install the binaries
[16:14:31] <kali> lv92: _id has enforced uniqueness, and must be present. i think null as one of these unique values
[16:26:25] <kali> any nosql ? i'm not sure you get the variety of software matching this criteria :)
[16:48:30] <faras> db.bills.update({uid: "8007-D-2013"},{ $set: { "creation_date": {"$date": Date("2014-01-10")}}})
[16:49:17] <faras> what I'm trying to do is to create a BSON datatype and store that in the creation_date field, which is what the client app needs
[16:49:55] <faras> right now I'm trying to update only one item for testing, but I actually have a batch import process
[16:50:31] <faras> lv92: I don't know about standards, but good documentation for implementations will not hurt
[16:53:14] <doryz> I'm having some strage mongo / mongoose problems and I was hoping someone can help me?
[17:02:35] <faras> ok, this seems to be the correct syntax: db.bills.update({uid: "8007-D-2013"},{ $set: { "creation_date": ISODate("2014-01-10")}})
[18:00:27] <obiwahn> db.grades.find({},{student_id : true, _id : false}) how do limit this query to only find each student_id once?
[18:06:24] <Riobe> obiwahn, what you're saying in SQL I believe would require ROW_NUMBER or RANK. To achieve that in MongoDB you'll need to play with the aggregation framework or MapReduce. If changing your schema so that you have one "grades" object for each student_id is possible with something like an array of objects that have a class id and a grade, then you wouldn't have to do anything special to limit it to one row per student_id.
[18:08:48] <Riobe> lv92, Usually through denormalization. Here's an example: http://stackoverflow.com/questions/2336700/mongodb-many-to-many-association
[18:09:36] <Riobe> lv92, The thought process in that example is a good one. Instead of having a Roles system data table with a mapping of rules to Users, you have each user store explicitly the Roles it has.
[18:10:24] <Riobe> lv92, If you needed, you could still have a Roles collection with information about the roles if you needed it. But you wouldn't do a mapping collection, you would just have an array of the Roles on each user.
[18:11:11] <faras> hi, I'm trying to mongoimport a json with a Date type, but I can't seem to find the right syntax
[18:11:36] <faras> I can do this in the mongo console and it works: db.bills.update({uid: "8007-D-2013"},{ $set: { "creation_date": ISODate("2014-01-10")}})
[18:12:54] <Riobe> faras: http://stackoverflow.com/questions/6475987/importing-date-datatype-using-mongoimport Does that help? If you're importing them into an empty collection you could just bring them in as a string and then run an update on the entire collection to convert them into a date.
[18:13:07] <Riobe> I haven't used mongoimport myself, so I haven't tried to get it to hit initially as a date.
[18:13:42] <Riobe> lv92, Read the top answer in the question I linked to: http://stackoverflow.com/a/2336885/232629
[18:14:03] <faras> Riobe: I don't like running a second process, so I was trying to do it with the $date descriptor
[18:16:00] <Riobe> faras: I'm not 100% sure but I'm interested. I'm trying to do some googling to see if I can figure it ou t.
[18:22:18] <faras> Riobe: I think I have actually read all there is to it, but I still can't figure it out, maybe your googling skills are better
[18:23:36] <Riobe> faras, I have a new install of Ubuntu at home. I usually do best when I can run a quick test so I'm going to throw MongoDB on this PC and try out a couple ideas. I like tech challenges like this one. :)
[18:26:56] <Riobe> Glad to help where I can. I've been switching to Ubuntu over the weekend from doing all my dev in Windows and various people in IRC have helped me a ton. Nice to actually be able to help someone else. :P
[18:27:14] <faras> <date> is the JSON representation of a 64-bit signed integer for milliseconds since epoch UTC (unsigned before version 1.9.1).
[18:28:02] <faras> <date> is the JSON representation of a 64-bit signed integer for milliseconds since epoch UTC (unsigned before version 1.9.1).
[18:28:18] <faras> how to I do a JSON representation of a 64-bit signed integer for milliseconds since epoch UTC
[18:28:20] <faras> <date> is the JSON representation of a 64-bit signed integer for milliseconds since epoch UTC (unsigned before version 1.9.1).
[18:31:17] <Riobe> Then the trick is to create the JSON you're importing with ticks as the time values.
[18:39:31] <obiwahn> i have searched a bit and did not find anything ... so it would be nice if somebody could confirm that there is no such thing:)
[18:39:44] <Riobe> obiwahn, From the shell you can, or from a driver you can. But mongodb runs in atomic operations. There are a few multi operations (like update, if set to do it), but most operations do one thing at a time. If you could offer an example I could answer a bit more specifically.
[18:43:00] <Riobe> obiwahn, http://docs.mongodb.org/manual/tutorial/write-scripts-for-the-mongo-shell/ Here is some basic information about writing a shell script. You can write Javascript functions that run on your database and do anything javascript can do. Though they still interact with mongodb through the api.
[18:59:34] <obiwahn> well i am still doing some kind of homework for an online course. i could have finished bye now but i like to find nice solutions:)
[19:11:56] <obiwahn> rv = db.grades.aggregate({$group : { "_id": "$student_id"}},{$sort : {"_id": 1}}).result ; null
[19:14:24] <Riobe> Did you read this: http://docs.mongodb.org/manual/tutorial/write-scripts-for-the-mongo-shell/ ?
[19:15:23] <Riobe> If you do the work you want to do in a javascript function in a *.js file, then load up the mongo shell and load("/path/to/that/script.js") then call the function you will likely have an easier time of things.
[19:16:08] <Riobe> The script you showed switches the terminal to the mongo shell , which takes over, and I doube will run the rest of of it till you exit the mongo shell. And outside of the mongo shell the rest of those statements would error.
[19:20:10] <Riobe> obiwahn, I find it best to get something running on the shell to prove it out before going to a driver.
[19:22:39] <Riobe> Put this in a *.js file: "function helloWorld() { print('Hello world!'); }" somewhere
[19:23:45] <Riobe> obiwahn, The technique in the file that you pastebin'd would not succeed in printing a hello world.
[19:26:23] <Riobe> db.grades.aggregate will return an object. I forget the scructure, but the results are contained in a property of that object.
[19:26:43] <Riobe> Doing a forEach directly on rv won't work because of that. In the shell do "var rv = <your command>"
[19:29:52] <Riobe> And it tries to run the statement after the mongo command after y ou exit the mongo shell, just like I said.
[19:33:02] <Riobe> With that in mind, you should read this: http://docs.mongodb.org/manual/tutorial/write-scripts-for-the-mongo-shell/
[19:33:10] <Riobe> For instance: To set the db global variable, use the getDB() method or the connect() method. You can assign the database reference to a variable other than db.
[19:33:15] <obiwahn> it is a bit supid because you do not get good syntax highlighting but i did not think that it would take me so longP
[19:33:43] <Riobe> There's a table that converts shell helpers like show collections into javascript equivalents for a script
[19:34:44] <Riobe> Cool, I couldn't remember that. Ah, I see that you're pulling it out already. Why do you have the word null after the ; where you .result?
[19:38:16] <Riobe> I get what your assignment is trying to do now...what was the actual assignment requirement?
[19:38:34] <Riobe> If a student has 3 grades entry, you'll just output the first one for that student.
[19:55:50] <Riobe> When I did this in my own test: "res = db.grades.aggregate([{'$group': {'_id': '$student', 'minGrade': { $min: '$grade'}}}, {'$sort': {'_id': 1}}])" it immediately output the results of the cursor it returned.
[19:56:30] <Riobe> When I simply added var to the beginning of res, "var res = ..." it did not. At that point the cursor was not spent because it didn't immediately run through it and I was able to do a simple forEach on it.
[19:57:15] <Riobe> Before it did nothing because it ran on an exhausted cursor that had nothing left to iterate over.
[19:58:09] <Riobe> What aggregate returns is a cursor with some methods, like a built-in forEach method.
[19:58:24] <Riobe> When I called foreach with a function on the result of aggregate (not aggregate().result) it worked.
[19:59:18] <Riobe> Just read your last paste. btw, instead of .limit(1) at the end, you can just turn find() into findOne()
[20:01:05] <Riobe> obiwahn, Actually, I think th is is what you want: http://docs.mongodb.org/manual/reference/method/db.collection.findAndModify/#findandmodify-wrapper-sorted-remove
[20:04:44] <Riobe> obiwahn, For if you come back, this seems to be simpler: http://stackoverflow.com/questions/13298635/how-remove-min-value-in-mongodb-for-group
[20:21:00] <Riobe> obiwahn, This was done from directly in the shell: "res.forEach(function (badGrade) { printjson(badGrade);})"
[20:21:15] <Riobe> After this was run: "var res = db.grades.aggregate([{'$group': {'_id': '$student', 'minGrade': { $min: '$grade'}}}, {'$sort': {'_id': 1}}])
[20:22:18] <Riobe> In my aggregate I output both the student and the min grade. That way you could go match on both of those fields when you remove.
[20:22:44] <Riobe> Or you could run a series of findAndModify commands where you match on each student id as the query, sort by grade: 1, and set remove: true.
[20:37:30] <Riobe> obiwahn, I wouldn't run it like that, because it wouldn't return anything. Instead I would do "db.grades.find({student: badGrade._id, grade: badGrade.minGrade})
[20:44:40] <Riobe> You have to put the result of .aggregate into a variable. It will be a cursor. Then you can .forEach() over it.
[20:46:59] <obiwahn> then ill get Sun Jul 6 22:44:58.669 TypeError: Object [object Object] has no method 'forEach'
[20:58:40] <obiwahn> i think i give up and write it to some pthon arrray and then query the db instead od doing it all in the db
[21:03:11] <Riobe> From what I read, and what worked for me in the shell, .aggregate() returns a cursor.
[21:03:50] <Riobe> I looked at what it actually does and it is a convenience method that while loops through and calls your function.
[21:04:26] <obiwahn> Sun Jul 6 23:02:32.276 TypeError: Object [object Object] has no method 'forEach'
[21:04:34] <Riobe> The result from .aggregate() for me was a cursor. I ran printjson() on it and found the forEach method.
[21:04:58] <Riobe> I think in 2.6 they switched from Spider Monkey javascript parser to V8. That might have something to do with it.
[21:05:34] <obiwahn> he db.collection.aggregate() now returns a cursor, which enables the aggregation pipeline to return result sets of any size.
[21:06:21] <Riobe> Then you'll have to while loop over the cursor calling a function on the result of .next() for each one.
[21:15:42] <obiwahn> http://docs.mongodb.org/v2.4/reference/method/db.collection.aggregate/#db.collection.aggregate
[21:17:58] <Riobe> If it really is an array that you're getting back, then I don't understand why forEach won't work.
[21:31:27] <Riobe> You either need to pull the first item from the cursor, or use the convenience method built into MongoDB to do it for you: findOne
[21:48:19] <sbujnak> Is there a built-in function for calculating popcount (Hamming Weight) in mongodb javascript?
[22:04:57] <obiwahn> i have been hours just one step from the solution because the output was not what i have expected
[22:06:32] <Riobe> My computer hates me. The USB keeps commiting sepuko. Oh well, keyboard still works.
[22:22:02] <apocolyps1> anyone recognize Unauthorized not authorized on hack to execute command { collStats: "system" }
[22:22:50] <apocolyps1> not sure where to start to find where this is getting triggered in my node app
[22:25:36] <apocolyps1> log showing up to [conn2727] after leaving proccess run overnight...... worried I actually running that many conections
[23:45:14] <sbujnak> When using the C++ driver, is it possible to specify mapReduce functions as c++ functions instead of javascript?