<    April 2017    >
Su Mo Tu We Th Fr Sa  
                   1  
 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  
30
00:04 gentunian joined
00:28 Soopaman joined
00:31 Siegfried joined
00:34 svm_invictvs joined
00:35 evulish joined
00:47 Gwayne joined
00:57 re1 joined
00:57 gentunian joined
01:22 johnnyfive joined
01:31 Wulf4 joined
01:45 jri joined
01:50 harry1 joined
01:50 kyuwonchoi joined
01:52 Soopaman joined
01:53 Mia joined
01:53 Mia joined
02:08 edrocks joined
02:14 YoY joined
02:26 orbyt_ joined
02:32 BlueProtoman joined
02:34 <BlueProtoman> I have a bunch of articles, each with one or more tags (stored as an array of strings). For a given unordered pair of tags, how can I get the number of articles that have both of these tags?
02:36 Soopaman joined
02:48 blizzow joined
02:59 mdorenka joined
03:08 evulish joined
03:46 freddy_ joined
03:47 freddy___ joined
04:27 freddy___ joined
04:33 svm_invictvs joined
04:33 castlelore joined
04:45 jri joined
04:46 kyuwonchoi joined
04:56 freeport joined
05:10 Soopaman joined
05:17 ayogi joined
05:18 Siegfried joined
05:20 castlelore joined
05:25 lowbro joined
05:25 lowbro joined
05:29 Siegfried joined
05:30 felixjet joined
05:41 Soopaman joined
05:47 coudenysj joined
05:48 castlelore joined
05:51 freddy_ joined
06:00 coudenysj joined
06:07 lpin joined
06:23 freddy___ joined
06:28 FrozenSolid joined
06:51 ams__ joined
07:03 evulish joined
07:10 jri joined
07:12 kyuwonchoi joined
07:13 edrocks joined
07:14 joshontheweb joined
07:20 rendar joined
07:35 okapi joined
07:44 sbo joined
07:45 sbo_ joined
07:46 sbo_ left
07:46 Boemm joined
07:46 <Boemm> Hello
07:47 <Boemm> I got a question related to sharding setup and the mongos which are connected ...
07:49 <Boemm> when doing a sh.status(true) I get the list of mongos which are active on the servers. unfortunately we have hosts with same short, but different fqdn names, eg. mongodb-arb01.dcone.net and mongodb-arb01.dctwo.net
07:49 <Boemm> the mongos list of active mongoses shows only the short names, so only mongodb-arb01 for those servers ...
07:50 <Boemm> Is it somehow possible to force mongos instances to use a definied _id for itself?
07:51 rodmar__ joined
07:52 <rodmar__> hi
07:53 <rodmar__> I have a documents that contains an array of documents {"array": [ {...}, {...}, ...]}
07:54 <rodmar__> I have some queries where I want to return only the matching documents in the array and the way I do it is using an aggregation pipeline where I: 1) run my match query 2) unwind the array 3) run the matching query again
07:55 <rodmar__> Is it possible to do the same using text search? I want to return only the embedded documents in the array that match a given text search
07:55 freddy_ joined
08:00 <rodmar__> I know that text search can only be used in the first stage of the pipeline but I was wondering if there is another way of doing the query.
08:40 felixjet joined
08:44 freddy_ joined
08:51 freddy___ joined
09:00 yeitijem joined
09:20 kexmex joined
09:46 kyuwonchoi joined
10:06 jamiel joined
10:29 mbwe joined
10:41 ph8 joined
10:41 SkyRocknRoll joined
10:42 ph8 joined
10:42 <ph8> Morning all! I've just found a load of our code that uses $$ e.g. db.find('myArray.$$.name') <-- to get all the names of all the items in myArray. That's how it appears to be getting used at least, but i can't find *any* official documentation on it, i've been googling for ages! Can anyone point me in the right direction?
11:01 gfidente joined
11:16 edrocks joined
11:31 Folkol joined
11:49 freddy_ joined
11:52 freddy_ joined
11:53 sterns joined
12:00 StephenLynx joined
12:03 Folkol joined
12:15 freddy_ joined
12:16 freddy_ joined
12:23 edrocks joined
12:25 Dev0n joined
12:35 ph8 joined
12:50 kyuwonchoi joined
12:55 KevinDC joined
12:56 BjornDeRijcke joined
12:57 jr3 joined
12:59 ramortegui joined
13:00 sspreitz joined
13:06 <BjornDeRijcke> Hi there. I've been encountering a problem with creating new collections simulataniously. I couldn't find anything usefull on the web so I thought I'd try and ask here.
13:06 <BjornDeRijcke> We're making integration tests for our application (C#, .net core), and we wish to create a separate database for each test, so there is no possible conflict with the data.
13:06 <BjornDeRijcke> These tests run parallel, and when they connect to our router we are getting the following timeout exception:
13:06 <BjornDeRijcke> Message: System.TimeoutException : A timeout occured after 30000ms selecting a server using CompositeServerSelector{ Selectors = WritableServerSelector, LatencyLimitingServerSelector{ AllowedLatencyRange = 00:00:00.0150000 } }. Client view of cluster state is { ClusterId : "1", ConnectionMode : "Automatic", Type : "Unknown", State : "Disconnected", Servers : [{ ServerId: "{ ClusterId : 1, EndPoint : "10.20.2.129:27017" }", EndP
13:06 <BjornDeRijcke> If we run the tests in sequence, all works fine. It is specifically when we run them parallel.
13:07 ace- joined
13:07 <BjornDeRijcke> If anyone has an idea, I'd be very happy to hear about it! : )
13:12 jri joined
13:14 freddy_ joined
13:15 kexmex joined
13:19 StephenLynx joined
13:20 sz0 joined
13:37 freddy_ joined
13:38 coffeejunk left
13:38 Doow joined
13:42 pxed joined
13:43 undertuga joined
13:52 skot joined
13:59 jri joined
14:00 geoffb joined
14:10 felixjet joined
14:10 freeport joined
14:11 culthero joined
14:11 felixjet joined
14:15 FatNoLife joined
14:16 evulish joined
14:16 Siegfried joined
14:29 Soopaman joined
14:33 dretnx joined
14:35 gfidente joined
14:35 gfidente joined
14:41 freeport joined
14:41 gentunian joined
14:49 okapi joined
14:50 AvianFlu joined
14:52 StephenLynx joined
14:52 scorphus joined
14:56 cduchesne joined
14:58 avery joined
14:58 megamaced joined
14:59 semanticman joined
15:08 kexmex joined
15:17 okapi joined
15:33 shackra joined
15:34 pxed joined
15:36 semanticman joined
15:39 knight33 joined
15:40 <knight33> I just can't understand this, and I've read the documentation so many times. I've created the index a:1, b:1, c:1, d:1, e:1, right? Why does this query/sort use the index then? db.dance.find( { a: { $gt: 2 }, e:1 } ).sort( { c: -1 } ).explain()
15:40 <knight33> It's all out of order, doesn't use index prefixes, and is sorting in the opposite direction. It still shows IXSCAN in the explain output, and that it's using my index, which goes against everything I've read in the documentation: "indexName": "a_1_b_1_c_1_d_1_e_1"
15:41 freddy_ joined
15:45 semanticman joined
16:01 RBoreal_Frippery joined
16:02 ayogi joined
16:02 davidmichaelkarr joined
16:02 <RBoreal_Frippery> Say I would like to store some metadata about certain filesystem paths in the database, with values like '/var/www/something' (linux style). Later I would like to search for entries 'under' a certain path. Can I use regex for it? is there anything extremely bad you can think of that would arise from this method?
16:03 AvianFlu joined
16:09 <knight33> Yeah, regex would work. db.collection.find({path:/^\/var\//})
16:12 MuzlL0dr joined
16:13 evulish joined
16:18 YoY joined
16:19 kexmex joined
16:26 jri joined
16:26 SkyRocknRoll joined
16:28 BlueProtoman joined
16:34 blizzow joined
17:41 silenced joined
17:46 supershabam left
17:50 Mantis_ joined
17:54 silenced joined
18:02 Sasazuka joined
18:29 ssarah joined
18:37 tibyke_ joined
18:37 StephenLynx joined
18:38 tharkun_ joined
18:38 Flyer_ joined
18:38 jj-_ joined
18:41 irclogger_com joined
18:41 Topic for
18:48 owg1_ joined
18:48 michaeldgagnon joined
18:49 joshontheweb joined
18:49 <michaeldgagnon> Any insight into what this db.serverStatus().wiredTiger.cache reported value means? -- "failed eviction of pages that exceeded the in-memory maximum"
18:52 owg1_ left
18:59 MuzlL0dr joined
19:06 pxed joined
19:17 silenced joined
19:30 ssarah joined
19:31 silenced joined
19:52 rendar joined
19:52 rendar joined
20:11 Ratler joined
20:22 svm_invictvs joined
20:25 Ratler joined
20:32 Waheedi joined
20:41 rayn joined
20:48 knight33 joined
21:00 Ratler joined
21:03 Waheedi joined
21:25 silenced joined
21:26 Ratler joined
21:28 rodmar__ joined
21:34 StephenLynx joined
21:36 evulish joined
21:38 mdorenka_ joined
21:42 joshontheweb joined
21:49 beauvolio joined
22:06 Ratler joined
22:13 markizano joined
22:15 messa joined
22:15 damnlie joined
22:15 mitzip joined
22:15 knight33 joined
22:17 <knight33> Does a sort always happen before a query?
22:17 BlackPanx joined
22:18 geoffb joined
22:25 jga joined
22:29 varesa joined
22:35 RBoreal_Frippery joined
22:37 point joined
22:37 <point> anybody monitor mongo with collectd/statsd? any suggestions for tools to do so? apparently the collectd plugin for mongodb has basically died
22:38 <point> the development on the collectd plugin for mongodb*
22:43 jri joined
22:45 Ropeney joined
22:45 point___ joined
22:47 orbyt_ joined
22:59 Ropeney joined
23:06 harry joined
23:12 gentunian joined
23:22 rayn joined
23:29 evulish joined
23:37 evulish joined
23:37 silenced joined
23:41 steve__ joined
23:52 Ubuntu-BR joined