[07:22:19] <haridas> Why the fs.chunks fs.files entries are not getting removed when we doing a delete on a document in another collection which stores big files ?
[07:23:17] <kali> haridas: implementing this kind of high level behaviour is up to the application
[09:55:31] <boombaloo> guys, we are running some bloody old single node mongo (1.8.1 !!) and want to move to 2.6 replica set...
[09:55:53] <boombaloo> can I get some advice how to approach the migration ?
[09:56:05] <boombaloo> we dont care about downtime...
[09:57:37] <boombaloo> if i dump the data, then stop old mongo, purge the data dir, upgrade and import, should I expect anything bad ?
[10:00:01] <juancarlosfarah> boombaloo: I don't think it would work that easily. In the docs it says "To upgrade an existing MongoDB deployment to 2.6, you must be running 2.4. If you’re running a version of MongoDB before 2.4, you must upgrade to 2.4 before upgrading to 2.6. See Upgrade MongoDB to 2.4 for the procedure to upgrade from 2.2 to 2.4."
[10:00:29] <juancarlosfarah> boombaloo: From this page: http://docs.mongodb.org/manual/release-notes/2.6-upgrade/
[10:00:32] <boombaloo> juancarlosfarah: but those are the upgrades when you have data in place...
[10:01:08] <boombaloo> what I asked about is : dump existing data, stop 1.8 - PURGE DATA DIRECTORY - upgrade to 2.6, import old data
[10:01:08] <juancarlosfarah> boombaloo: I believe so, yes.
[10:02:02] <boombaloo> essentially my question was. if I dump the data from 1.8 using 1.8 mongodump , will 2.6 mongo have any problems importing dumped 1.8 data ?
[10:02:43] <juancarlosfarah> boombaloo: There are changes in the authorization model, if you have users. I don't know about any previous changes between 1.8 and 2.2 that may also affect you.
[10:03:02] <boombaloo> I see...that's what I was afraid of....
[10:03:22] <boombaloo> what I can do I guess is to do gradual update....1.8 -> 2.2 -> 2.4 -> 2.6 /
[10:03:44] <boombaloo> I hate inheriting this stuff when I do contracting for companies :-)
[10:04:31] <juancarlosfarah> boombaloo: Yea. Unless anyone tells you that you can skip some versions, I would do a gradual update and be safe.
[10:05:35] <boombaloo> juancarlosfarah: damn :-) smells like quite some work...i thought i was gonna be smart :-)
[10:05:44] <boombaloo> btw is the user accounts the only "problem"?
[10:07:41] <juancarlosfarah> boombaloo: boombaloo: I'm looking at the docs. Looks like from 1.8 to 2.2 there's nothing to worry about. You can just change the binaries.
[10:07:46] <juancarlosfarah> boombaloo: See here: http://docs.mongodb.org/manual/release-notes/2.2/
[10:08:04] <boombaloo> MongoDB 2.0 data files are compatible with 2.2
[10:10:12] <juancarlosfarah> boombaloo: Yea, then from 2.2 to 2.4 there are some considerations for the system.users (http://docs.mongodb.org/manual/release-notes/2.4-upgrade/)
[10:12:09] <juancarlosfarah> boombaloo: Then the same from 2.4 to 2.6, though there's a nice procedure you can follow to upgrade the user authorisation data (http://docs.mongodb.org/manual/release-notes/2.6-upgrade-authorization/#upgrade-authorization-model)
[10:12:47] <juancarlosfarah> boombaloo: So it's not that bad. And if you're not using auth, you could probably try to take some shortcuts.
[10:13:08] <boombaloo> i dont actually think we are using auth AT ALL
[10:13:17] <boombaloo> i cant see any mention of it in mongoid config
[10:15:31] <juancarlosfarah> boombaloo: Check what you have in the system.users collection.
[10:18:13] <boombaloo> juancarlosfarah: there is no such collection in any of our dbs :-)
[10:21:30] <juancarlosfarah> boombaloo: Then you can try and see what happens if you do the upgrade directly!
[10:21:53] <boombaloo> I'll do the dump before to make sure
[10:22:05] <boombaloo> by directly you mean 1.8 -> 2.6 ?
[10:25:45] <juancarlosfarah> boombaloo: Yes, do the dump. Definitely. I would still do the update gradually. 1.8 -> 2.2 then to 2.4 then 2.6, but without modifying anything.
[10:26:19] <juancarlosfarah> boombaloo: But I guess there is no harm in trying to do the upgrade from 1.8 -> 2.6 and see what happens. As long as you back up.
[10:26:39] <boombaloo> yeah thats what im thinking
[10:35:45] <boombaloo> mm anyone has seen this before ? http://pastebin.com/LA0CvnzA
[10:36:03] <boombaloo> look like i cant connect to mongo using mongo cmd line client
[12:01:55] <r1pp3rj4ck> i tracked the process until this line in doctrine https://github.com/doctrine/mongodb/blob/master/lib/Doctrine/MongoDB/Database.php#L106
[12:02:03] <Nodex> I would look in the $manager object
[12:02:21] <r1pp3rj4ck> which calls MongoDB::command()
[12:02:35] <r1pp3rj4ck> tracked it with xdebug and the $data is correct here
[12:02:55] <r1pp3rj4ck> that's why i think it might be in the driver
[12:03:56] <Nodex> $this->createQueryBuilder(); <--- is that extended anywhere?
[12:04:27] <Nodex> if so does it write to the same object as the $manager ?
[12:05:49] <r1pp3rj4ck> createQueryBuilder is on the standard DocumentRepository
[12:06:03] <r1pp3rj4ck> forgot to mark that in the snippet though
[12:07:12] <Nodex> I personally don't know doctrine but that method seems to be the one called before the aggregation so it stands to reason that if it's being manipulated then it would be (for lack of a better word) concatting your function calls
[12:29:44] <Randomaniac> Is there an easy way to pass in a function that uses other functions into a where query, without having to copy all of their bodies inside it?
[13:15:08] <Gargoyle> bangbang: Sleep or idle? What do you mean?
[13:15:24] <bangbang> We are new to mongo and my developers keep experiencing some issues with getting data... If they wait for say, 30 minutes, then try to get the data, it'll throw an error
[13:15:36] <bangbang> if they refresh the page, the data appears as it should.
[13:16:03] <bangbang> The error is: Error: Response for getList SHOULD be an array and not an object or something else
[13:16:13] <Gargoyle> What error? and what do you mean by wait 30 mins?
[13:16:49] <bangbang> Gargoyle: What I mean by "wait"... is if the developer does nothing for a period of time, then tries to hit the database, the error will appear
[13:17:06] <bangbang> If they refresh the page after they get the error, the data appears as normal.
[13:17:37] <bangbang> I'm just trying to narrow down the possible problems, because the mongo logs aren't telling me anything.
[13:18:30] <Gargoyle> bangbang: MongoDB doesn't have pages to refresh! So perhaps you would like to take a few mins and compose a question that someone will have a chance of answering. (Hint, programming language, server & driver versions, example code and actual error messages - Use a pastebin or gist)
[13:20:35] <bangbang> Gargoyle: I appreciate the guidance in trying to help me form my question. Let me try and come up with something more descriptive.
[13:20:59] <Gargoyle> All Good. Got married, got a new role in company - bit of a sideways move not a promotion, but better chances of one, busy busy....
[13:21:41] <rspijker> bangbang: mongo doesn’t go to sleep, but cursors do expire after about 10 mins. So I’m guessing your developers are holding on to one of those inadvertently…
[15:03:28] <r1pp3rj4ck> i'll try to fix it if i'll have time
[16:13:54] <d-rock> I've got an interesting one here. mongodb-org version 2.6.3. I've got "hidden" collections. The collections are there, work fine for query/insert, show up in stats, etc, but if I issue a "show collections" from the mongo shell they don't show up in the list.
[16:21:10] <rspijker> d-rock: but they do show in db.getCollectionNames() ?
[19:35:59] <ddod> Can anyone help me figure out how I would query for entries added after a specific entry? Is the only way to do this by looking up when the entry was added and do a time-based query afterward?
[19:48:50] <obiwahn> it is alomst the query i have posted
[19:49:14] <obiwahn> is misses the number of cities that would be neccessary to calculate the average
[19:49:27] <obiwahn> but you can switch the sum for avg
[19:49:39] <obiwahn> but then it gives still th wrng result
[19:50:10] <obiwahn> Please calculate the average population of cities in California (abbreviation CA) and New York (NY) (taken together) with populations over 25,000.
[19:50:39] <obiwahn> does that somehow mean that a city name is only used once?
[19:52:04] <obiwahn> like when a city is in 2 states that it still counts as one city when calculating the average?!
[19:57:25] <rakkaus__> Hi guys! I am looking for default admin ( root) credentials
[19:57:47] <rakkaus__> I have installed mongodb with enabled auth
[19:58:02] <rakkaus__> how can I change admin user credentials?
[20:10:41] <s2013> anyone has an edxample of how a chat program would be designed? do you save each message as a separate document?
[20:12:15] <s2013> https://gist.github.com/ss2k/fe3b9571d2c527b48578 which would be preferable?
[20:26:52] <obiwahn> you will have smaller documents
[20:27:06] <s2013> even if i have 100 million records it wont be problem to parse through?
[20:27:39] <obiwahn> i guess that would be easier than having 1 document containing so many
[20:27:59] <obiwahn> you can then use indexes to speed up the lookup
[20:30:11] <rakkaus__> Guys, please help me, is there a default root / admin / super user? and how to change pwd ? I've installed mongo with auth = true, but I ca't do anything!
[20:30:39] <rakkaus__> I sure that there is some user like root in mysql without pwd
[20:30:44] <obiwahn> yes when the admin was not created in advance
[21:01:34] <obiwahn> s it totally wrong? or is it because cities might consist of smaller parts and the population has to be summed up before applying the filter?
[21:08:23] <obiwahn> A city might have multiple zip codes. --- in the same state
[21:09:55] <obiwahn> kali: ok i have found what is wrong
[21:10:35] <kali> strong the force with this one is
[22:14:06] <Persillade_> i'm a beginner in using a bash shell. I have installer mongo, have a connection but i don't have the prompt to enter commands. any one could advise ? thanks
[22:17:08] <joannac> Persillade_: you've opened the mongo shell?
[22:17:53] <Persillade_> joannac, I opened the shell on my mac os x, and typed mongod
[22:18:20] <Persillade_> i have 4 connections at the moment (don't know why i don't have just one)
[22:31:12] <obiwahn> oh different number of assignments that is a good reason
[23:10:03] <in_deep_thought> I am trying to build a simple to-do app with the to-do items being stored as json objects with various attributes. Does this sound like something I need a db for (like mongodb for example) or could I just store everything in .json files? How much easier/harder would it be to pull things from the json files rather than a db?
[23:12:42] <Guest26862> depends on what you want to do with the todo elements, and how many you'll have. If it's a todo app, you'll probably be able to fit everything in memory. Can you save the elements on the client side, or do you need a server to aggregate all of the todos for each user?
[23:13:06] <joannac> obiwahn: I'd prefer you didn't make answers to assignments publicly available. could you nuke it please?