<    April 2017    >
Su Mo Tu We Th Fr Sa  
 2  3  4  5  6  7  8  
 9 10 11 12 13 14 15  
16 17 18 19 20 21 22  
23 24 25 26 27 28 29  
00:00 svm_invictvs joined
00:16 dsardari joined
00:18 re1 joined
00:49 harry1 joined
00:50 raspado joined
00:50 Gwayne joined
00:50 Gwayne joined
00:53 harry1 joined
00:58 culthero joined
01:09 BlueProtoman joined
01:10 <BlueProtoman> If I have a lot of identical strings inside a MongoDB collection (say, from a finite set), does MongoDB store every single string? Or just pointers to some string table?
01:17 ksa_ joined
01:30 mdorenka joined
01:33 artok joined
01:52 Goopyo joined
01:58 Goopyo joined
02:08 orbyt_ joined
02:11 eperez joined
02:45 Goopyo joined
02:55 KingGregoryXVIII joined
03:00 SkyRocknRoll joined
03:06 raspado joined
03:11 Soopaman joined
03:22 KingGreg1ryXVIII joined
03:34 artok joined
03:39 Mia joined
03:40 jaequery joined
03:43 Soopaman joined
04:28 Soopaman joined
05:02 culthero joined
05:04 eperez joined
05:04 VeeWee joined
05:11 Soopaman joined
05:11 Soopaman joined
05:34 artok joined
05:35 Soopaman joined
05:39 preludedrew joined
05:51 Soopaman joined
05:51 lpin joined
05:54 Goopyo joined
05:55 jwd joined
05:56 igniting joined
05:57 coudenysj joined
06:20 yeitijem joined
06:22 Muchoz joined
06:24 senaps joined
06:26 Soopaman joined
06:36 Muchoz joined
06:39 Muchoz joined
06:40 coudenysj joined
06:48 stdranwl_ joined
06:52 <Bodenhaltung> Derick: If you have time, can you please take a look at my question yesterday?
06:59 ksa joined
07:00 jri joined
07:01 Liara- joined
07:02 culthero joined
07:06 eperez joined
07:13 artok joined
07:17 __MPZ joined
07:17 Muchoz joined
07:19 klics joined
07:28 Lujeni joined
07:32 Folkol joined
07:48 SkyRocknRoll joined
07:51 stdranwl_ joined
07:57 Folkol joined
08:14 evil_gordita joined
08:23 jri_ joined
08:25 jri joined
08:27 jri__ joined
08:30 _jd joined
08:34 jri joined
08:39 Letze joined
08:41 rendar joined
08:54 <Derick> Bodenhaltung: I thought I had replied to your question too?
08:55 <Bodenhaltung> Derick: No. :(
08:56 <Bodenhaltung> Should i send the link again to gistfile?
08:59 gfidente joined
08:59 gfidente joined
09:00 okapi joined
09:01 joshua joined
09:04 culthero joined
09:05 Folkol joined
09:06 artok joined
09:07 eperez joined
09:11 <Bodenhaltung> Derick: I have updated my paste with the datetimezone, this throws actually an error "Fatal error: Uncaught MongoDB\Driver\Exception\RuntimeException: can't convert from BSON type missing to Date in " can you help me to get this working? https://gist.github.com/Bodenhaltung/34fb39dc458e1b81e15734866f8683a9
09:11 <Bodenhaltung> If i try $add in $group i get the error: "The $add accumulator is a unary operator in ...."
09:13 <Derick> Bodenhaltung: I replied to that:
09:14 <Derick> you should do the project before the group though
09:17 <Bodenhaltung> Hmm, no error but also no result.
09:19 <Derick> you need to show what you're doing... I can't guess
09:22 <Bodenhaltung> Derick: Good point, looks now:
09:22 <Bodenhaltung> https://nopaste.me/view/b6c261bf
09:22 goldfish_ joined
09:24 <Derick> Bodenhaltung: you know PHP supports [ ... ] for array( ... ), right?
09:25 <Derick> Bodenhaltung: what types of values do you have in the date field? Is it ISODate, or a unix timestamp as integer?
09:25 <Bodenhaltung> Derick: It is ISODate
09:26 <Derick> OK, I think this should work then
09:26 <Derick> but you left out the first bit now... where you construct $dateStartQ
09:28 <Derick> Bodenhaltung: you might also want to watch https://jira.mongodb.org/browse/SERVER-28611 as that would make this much easier
09:35 <Bodenhaltung> Derick: Thanks for the hint with [ and the LInk to Watch, i get still no result, if i use the date in find() i get a few results: https://nopaste.me/view/9432451e
09:39 sieve joined
09:40 <sieve> Hi, Is it active in herE?
09:40 <Derick> sortof
09:41 <sieve> Surprised there isnt a slack
09:41 <sieve> All the new kids like slack
09:41 <Derick> Bodenhaltung: you will get the documents from today
09:42 <sieve> for post in posts.find({'timestamp': {'$gte': start, '$lt': end}}):
09:42 <sieve> ….post['server'] = servers.find_one( {'_id': {'$eq': post['server'] }})
09:42 <Derick> sieve: please use a pastebin for code
09:42 <sieve> I'm struggling to understand how I join
09:43 <Derick> MongoDB does not have joins
09:43 <sieve> Derick: well, indeed but you can resolve a ref or something no?
09:43 <sieve> Or is what I am doing the most efficient way?
09:44 <Derick> you need to do multiple queries. What you do, is probably not. As you will do a query for each of your originally found documents. It's better to construct an array of the IDs you found, and run a query with that as second query
09:45 <sieve> Derick: so I need a mechanism to check if something exists in my array and if not, query it.
09:46 <sieve> Derick: that was my line of thinking.
09:46 <sieve> Ok, cool. That will be an interesting programming challenge.
09:53 jonnyRV joined
09:54 jhonnyRV joined
09:56 <jhonnyRV> hello guys
09:58 Folkol joined
09:59 <jhonnyRV> i`m trying to use a script to insert some entries into mongoDB. (i`m using robomongo ATM). thing is that, regardless of number of entries i choose to insert, i only get only 127 entries per run (of script).
09:59 <jhonnyRV> is there some limit set in mongo for this?
10:05 <Derick> not at 127 - there are limits in the amount of data in a package, or items in a bulkwrite, but nowhere near 127
10:08 Liara- joined
10:09 <jhonnyRV> Derick: the very 1st run of script i do with robomongo it works fine (most of the times). like, i can insert some 10K entries. all next runs only add 127 entries per run
10:09 <jhonnyRV> its really weird
10:15 <Derick> could be a bug in robomongo? do you not get an error anywhere?
10:15 <Derick> log files?
10:15 <jhonnyRV> no, no errors
10:17 <jhonnyRV> anyway i can run the script from cli ?
10:17 <jhonnyRV> it's a .js file
10:17 <jhonnyRV> maybe it's robomongo's fault
10:18 <Derick> mongo --help will tell you how
10:30 Letze_ joined
10:39 jri_ joined
10:41 jri joined
10:48 ssarah joined
10:53 Folkol joined
10:54 jri joined
10:54 jri_ joined
10:55 KingGregoryXVIII joined
10:57 VeeWee joined
10:58 basiclaser joined
11:00 jri joined
11:01 okapi joined
11:08 kexmex joined
11:09 raspado joined
11:36 blizzow joined
11:36 okapi joined
11:39 sieve joined
11:59 okapi joined
12:08 <Bodenhaltung> re
12:09 <Bodenhaltung> Derick: Ah, it worked but now i get no value for the "average", it is still empty: https://nopaste.me/view/9432451e
12:19 StephenLynx joined
12:23 Folkol joined
12:32 harry1 joined
12:40 StephenLynx joined
12:42 KingGregoryXVIII joined
12:48 gentunian joined
13:00 ramortegui joined
13:07 brutuz joined
13:08 ngmvit joined
13:08 <ngmvit> iam trying to make a query but finding it difficult to do,
13:09 <ngmvit> 1) fetch all documents , 2) fetch more docs from same collection based on different match but the id should be same as the last step
13:10 <ngmvit> how can i do this, i was thinking of fetching all the docs and extracting ids and then i can use $in when making the 2nd query but i dont think its the correct way to do
13:11 jeffreylevesque joined
13:26 sieve joined
13:29 jeffreylevesque joined
13:35 klics joined
13:35 <Derick> Bodenhaltung: can you show one document in full?
13:36 jwd joined
13:46 jwd joined
14:00 geoffb joined
14:21 culthero joined
14:25 Folkol joined
14:40 Folkol joined
14:41 gentunian joined
14:47 jwd joined
14:51 raspado joined
14:56 jwd joined
15:00 igniting joined
15:07 blizzow joined
15:15 raspado joined
15:15 Folkol joined
15:34 bytee joined
15:37 Goopyo joined
15:41 artok joined
15:44 ssarah joined
15:54 Soopaman joined
15:55 silenced joined
15:59 MacWinner joined
16:00 artok_ joined
16:06 okapi joined
16:06 jwaibel joined
16:10 kexmex joined
16:10 artok_ left
16:11 Soopaman joined
16:11 artok joined
16:24 svm_invictvs joined
16:25 n0arch joined
16:27 jaequery joined
16:30 jri joined
16:36 philipballew joined
16:36 jwd joined
16:39 orbyt_ joined
16:46 silenced joined
16:49 Goopyo_ joined
17:06 jwd joined
17:07 jri joined
17:08 silenced joined
17:10 jwd joined
17:13 point joined
17:14 jwd joined
17:15 dump joined
17:32 okapi joined
17:38 jri joined
17:39 Soopaman joined
17:46 SkyRocknRoll joined
17:50 jri joined
17:51 trevor joined
17:52 SkyRocknRoll joined
17:54 MDesigner joined
17:57 <Bodenhaltung> Derick: Sure; https://nopaste.me/view/ec192256
17:58 jri joined
18:00 <Bodenhaltung> Ignore "[31/4670]" doesnt belongs to the document, tmux output.
18:04 Sasazuka joined
18:05 <MDesigner> hey all. I'm seeing some weird stuff with indices, namely, no performance gain from using them. I'm doing regex searches.
18:05 <MDesigner> https://stackoverflow.com/questions/43235793/mongodb-regex-search-best-practices-dont-seem-to-make-a-difference
18:05 <MDesigner> I'm not experienced enough with MongoDB to see what's going on here
18:05 artok_ joined
18:06 <Derick> Bodenhaltung: can't see anything wrong :-/
18:06 <Derick> MDesigner: indexes can only be used with regexes if they're anchored to the beginning of the string with ^
18:07 <MDesigner> @Derick I did anchoring too. anchored search with index was considerably slower than anchored search without index.
18:07 dougquaid joined
18:08 <Derick> that makes no sense
18:09 <MDesigner> exactly
18:09 <MDesigner> and yet the numbers I show in my post are accurate, according to Compass
18:09 <MDesigner> on the 'Explain' tab
18:10 <Derick> but it also could depend on whether docs/indexes have been loaded into memory, or the machine was doing other things. Just a single try/benchmark is not a good trial.
18:10 <dougquaid> My server experienced an unclean shutdown and now mongod won't start. I get the following error. How can I fix it? file:WiredTiger.wt, WT_CURSOR.next: read checksum error for 32768B block at offset 62736:317137][1212:0x7fb240ffbc80], file:WiredTiger.wt, WT_CURSOR.next: read checksum error for 32768B block at offset 626688: block header checksum of 1237709813 doesn't match expected checksum of 1291255085
18:10 <Derick> MDesigner: oh! case-insensitive
18:10 <Derick> that also means no index is used...
18:10 artok_ left
18:10 <MDesigner> Derick: but Compass is telling me in the explain results that the index *was* used
18:13 <brutuz> hi all..
18:14 <brutuz> i was wondering if anyone can provide me inputs on how to efficiently manage a big mongodb in a system's perspective
18:15 <MDesigner> Derick: http://imgur.com/a/YsVvp
18:15 <MDesigner> { "name": { $regex: "^do", $options: "i" } }
18:15 <MDesigner> it claims it used the `name` index
18:16 jwd joined
18:16 <MDesigner> 280ms total execution.. and when I delete the index, it's a whopping 90ms for just a collection scan
18:23 <Bodenhaltung> Derick: Ok, thanks for help. :) Maybe i ask the audience joker, stackoverflow.
18:25 Sasazuka joined
18:27 jri joined
18:28 blindbox joined
18:30 MDesigner left
18:36 Soopaman joined
18:43 jri joined
18:52 Diggsey joined
18:54 tildes joined
19:04 tildes joined
19:13 StephenLynx joined
19:16 jwd joined
19:27 okapi joined
19:27 jri joined
19:44 jr3 joined
19:50 <Bodenhaltung> Derick: wow, i really didn't see that to add this to $project, brb, screaming....
19:50 <Bodenhaltung> Derick: But $addFields looks like a smarter way: http://stackoverflow.com/questions/43239600/mongodb-php-add-tz-offset-to-aggregate-query-and-average-output
19:52 gentunian joined
19:53 <Derick> Bodenhaltung: I didn't know about addFields!
19:54 <Derick> Bodenhaltung: you should accept the answer that usese $addFields
19:54 <Derick> Bodenhaltung: it's also better if you don't add links (in your question) to information, but directly include the information in the question
19:55 tildes joined
20:36 <Bodenhaltung> Derick: Yeah, i accept the answer with addFields, nice. :D
20:37 <Bodenhaltung> Derick: The sample document seems to be a little to large for a post, next time i will trim the document to the relevant parts.
20:41 orbyt_ joined
21:01 <Derick> Bodenhaltung: yeah... you can still do that though ;-)
21:05 Sasazuka__ joined
21:10 silenced joined
21:30 ramortegui joined
21:31 StephenLynx joined
21:31 kexmex joined
21:53 KingGregoryXVIII joined
21:54 ssarah joined
22:00 silenced joined
22:07 Lujeni joined
22:15 Sasazuka joined
22:16 orbyt_ joined
22:58 point joined
23:03 point joined
23:05 kyuwonchoi joined
23:29 KingGregoryXVIII joined
23:34 svm_invictvs joined
23:41 KingGregoryXVIII joined