Log file Viewer
#mongodb logs for Wednesday the 11th of February, 2015
[00:03:58] <hicker> But would rather not, just because I'm not sure of all the possible values quite yet
[01:19:31] <haole> if most of my documents share, let's say, the same four fields, but some of them have extra unique fields to themselves, should I worry about optimizations upfront?
[05:36:27] <Boomtime> giowong: joannac is suggesting you try mongoimport, it can parse csv under strict conditions and make documents from each row, you may find it suits your needs
[07:47:04] <jerev> I have a date object in my data, that looks like {..., "dt": {"$date": "2015-10-02T15:15:00.000Z"}, ... } -- How do i match on this?
[07:47:28] <jerev> When I write a simple $match { dt { $gt: ... } } } it doesn't seem to give the correct results
[07:48:30] <kali> this is probably where you're wrong actually. show us the date format you use in the query
[07:50:04] <kali> ok. i'm guessing node.js and i'm not that fluent in that stuff. but it is supposed to work.
[07:50:25] <jerev> I tried isostrings like "2015-02-11T06:47:35.970Z" too. And that doesn't return anything either
[07:50:30] <kali> jerev: if you read the document in the mongo shell, how does the date show ? ISODate(...) ?
[07:53:35] <kali> jerev: this is why I asked about how the date appears in the shell. it should show as "dt":ISODate("...")
[09:08:04] <durre> is it a bad idea to do querys like this: {authorId: {$in: [id1, id2, id3 ...]}} ... I expect the list to normally be around 30 ids and maybe at most 100-150
[09:12:03] <kali> durre: this is fine. certainly better than performing individual queries for each author
[11:27:52] <Faved> hey all, can anyone tell me, I am messing around with using TTL on some mongo indexes, but I wonder if there is a way to make them slide? so if I set a TTL of say 2 mins on doc when I add it, can I call something which will make the 2 min "reset" ?
[11:32:23] <kali> just set the death_date in 10 minutes in the future (if that's the actual TTL you want) when you insert, and update it at 10 minutes in the future when you want to prolong your document life
[11:33:48] <Faved> so using that technique, if i have a doc which is orginally set for say 5 mins, am I amble to prolong that ttl indefinitely.
[11:34:03] <Faved> I am using something using Redis at the moment and I am looking at using mongo instead
[11:35:18] <kali> well, another option, use a 5min TTL on last_interaction, and update last_interaction every time there is an interaction
[11:36:06] <Faved> by using clock time on here? http://docs.mongodb.org/manual/tutorial/expire-data/
[11:37:17] <kali> mmm actually "clock time" is closer to the death_date approach, but both will work
[11:38:33] <Faved> I did try setting TTL of 5 mins on a flield and then tried updating that field to see if it "slid"
[12:03:42] <Faved> @kali Thanks updating the field in which the TTL was on (a date field) worked a treat
[12:30:25] <Hypfer> any way to say "please give me only every 5. result" ? or even better: "return results but only average for every 5" ?
[15:08:37] <queretaro> Hi, I've created an admin user in a single DB but I noticed that I still can access the DB without any credentials, how could I restrict that to only the admin?
[15:12:36] <salty-horse> hey. is there a way to tell mongodb to only match documents whose list field contains all provided elements? the $in operator provides an OR relation. I'm looking for AND
[15:14:15] <salty-horse> thanks! is there a similar thing for the $text operator? e.g. only matching strings that contain several provided words?
[15:33:54] <jthomas_> Good day, I'm back with a few questions. I set up DBs yesterday and userAdmin but those userAdmin roles apparently can'
[15:35:06] <jthomas_> Can anyone explain how to do that? I wanted to give more perms by rerunning the command but Mongo says the account exists (yes it does). Figured out how to drop the account, now I want to re-add it with userAdmin perms AND readWrite perms.
[15:36:06] <jthomas_> looking at the docs, it seeems to tell me to change to the DB that I want to affect, and run the db.createUser() command, but then it starts granting roles in unrelated DBs http://docs.mongodb.org/manual/tutorial/add-user-to-database/
[15:36:41] <jthomas_> why do I change to a DB if the roles are for other DBs? Do I have to change to each of my 4 and grant perms to all the others within each of these?
[16:54:24] <kali> cypas: well, it depends how you access mongodb, but the driver interface should escape for you
[17:09:35] <roadrunneratwast> I have a bunch of geographical data. Are there any mongo tools or packages for searching by location? Eg. A 10 mile radius from location X?
[18:25:27] <tubbo> hey all, having a bit of an issue when i attempt to access my mongodb database. "exception: BSONObj size: 0 (0x0) is invalid. Size must be between 0 and 16793600(16MB) First element: EOO"
[18:28:23] <tubbo> StephenLynx: do you think it might be a data issue? this is the only DB i get an error on, my other DBs are fine
[18:29:33] <tubbo> i can't access ONLY the test db at all. and this started when someone migrated my data from one machine to another :)
[18:30:12] <tubbo> where does mongo store its information? perhaps if i blew away the data dir and re-built everything this would work?
[18:31:47] <Nilium> Well, you probably also know me from SA, but I don't think anyone knows my SA name. I try to make sure it's unassociated with everything else.
[18:33:29] <tubbo> cheeser: blowing away the data for my test db fixed it...must have been a bad copy or something.
[18:42:21] <heewa> So, if I get an InvalidBSON error from pymongo read operation, is that something I should dig into (like is it a bug in mongo/pymongo?) or just sometimes happens?
[18:42:59] <heewa> (That sounds snarky, I meant it non-sarcastically. honestly wondering if it’s just fritzy like that sometimes)
[19:31:38] <worldwide> hello :-) sorry for this question but is it possible to combine $and and $or in a mongodb query?
[20:06:40] <juanlas> hey yall, so quick question, is there any overwhelming reason to use the native mongo Date type instead of just storing an ISO date string?
[20:07:08] <GothAlice> juanlas: All of the ways in which you can query the data go pif if you store it in a non-native date format. Not to mention how inefficient storage as a string would be.
[20:07:52] <GothAlice> A la: http://docs.mongodb.org/manual/meta/aggregation-quick-reference/#date-expressions
[20:09:14] <juanlas> ah cool, thanks GothAlice, i am trying to explain to a developer why someone would want to use native types
[20:09:19] <GothAlice> '2015-02-11T20:06:11.820952' = 26 bytes, plus null, plus 4-byte leading length = 31 bytes to store this date.
[20:10:58] <GothAlice> mango_: Upserts. Where you want to update a record if it exists, but create it otherwise.
[20:11:10] <GothAlice> $setOnInsert allows you to specify "default values" to use when creating a record in this scenario.
[20:18:15] <mango_> GothAlice: If the record (document) doesn't exist, then can defaults (values) be applied?
[20:18:56] <GothAlice> From the first paragraph of the link I gave: "If an update operation with upsert: true results in an insert of a document, then $setOnInsert assigns the specified values to the fields in the document. If the update operation does not result in an insert, $setOnInsert does nothing."
[20:23:45] <mango_> GothAlice: however if upsert:false, and a record exists then we do nothing right?
[20:25:27] <GothAlice> if upsert is false, $setOnInsert will either error (no point supplying it) or gracefully do nothing, regardless. (If the record didn't exist, with upsert: false, nothing would happen anyway.)
[21:06:50] <worldwide> thank you StephenLynx, after i tried it it works,.... i'll promise i will test it next time before i ask :-)