<    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:16 StephenLynx joined
01:08 NoOutlet joined
01:33 NoOutlet joined
02:02 `jpg joined
02:18 svm_invictvs joined
02:20 <malwar3hun73r> anyone around?
02:21 armyriad joined
02:49 freeport joined
02:49 joshontheweb joined
03:43 gentunian joined
03:53 orbyt_ joined
03:53 DyanneNova joined
04:07 svm_invictvs joined
04:14 Ropeney joined
04:31 SkyRocknRoll joined
04:47 _yoy_ joined
05:05 ayogi joined
05:14 jwd joined
05:17 mylord joined
05:17 <mylord> whats wrong with this sort? db.users.aggregate([{$match:{"roles":{$nin:['meta','admin','api']}}},{$group:{_id:{a:'$gip.country'},total:{$sum:"$points"}}},{$sort:{_id.a:-1}}}])
05:19 <mylord> sorry.. this one: db.users.aggregate([{$match:{"roles":{$nin:['meta','admin','api']}}},{$group:{_id:{a:'$gip.country'},total:{$sum:"$points"}}},{$sort:{a:-1}}])
05:19 <mylord> it’s not sorting the gip.country
05:19 <mylord> with the most total points
05:20 lpin joined
05:24 ayogi joined
05:24 armyriad joined
05:30 preludedrew joined
05:34 <mylord> basically, why isn’t this working? db.users.aggregate([{$match:{}},{$group:{_id:'$gip.country',total:{$sum:"$points"}}},{$sort:{'_id.total':-1}}])
05:34 <mylord> the sort does nothing
05:34 <mylord> the sort has no visible effect
05:35 Folkol joined
05:47 Folkol joined
06:03 coudenysj joined
06:06 jesopo joined
06:10 coudenysj joined
06:13 mddeff1 joined
06:45 _jd joined
06:56 jri joined
06:57 Folkol joined
07:00 coudenysj joined
07:02 rendar joined
07:31 coudenysj1 joined
07:37 Lujeni joined
07:57 ren0v0 joined
08:30 goldfish joined
08:31 SkyRocknRoll joined
08:40 jwd joined
08:49 Lujeni joined
09:14 silenced joined
09:14 raspado joined
09:20 okapi joined
09:20 Lujeni joined
09:31 jaequery joined
09:42 kexmex joined
09:43 jaequery joined
10:09 undertuga joined
10:17 re1 joined
10:20 raspado joined
10:21 raspado joined
10:29 gfidente joined
10:37 ssarah joined
10:57 artok joined
11:16 mylord joined
11:24 silenced joined
11:27 Folkol joined
11:35 _jd joined
12:01 yeitijem joined
12:05 audriusm joined
12:09 <audriusm> hi, how to skip records older than some _id ? I mean I ran query sorted by _id and now only know which was the latest. what query will give me the rest?
12:15 sz0 joined
12:18 compeman joined
12:20 `jpg joined
12:20 `jpg joined
12:21 `jpg joined
12:22 `jpg joined
12:23 `jpg joined
12:33 soosfarm joined
12:47 okapi joined
12:56 Lujeni joined
13:04 ramortegui joined
13:08 trevor joined
13:10 sterns joined
13:12 StephenLynx joined
13:14 trevor joined
13:21 ramortegui joined
13:22 joshontheweb joined
13:26 re1_ joined
13:35 kexmex joined
13:48 StephenLynx joined
13:57 FrozenSolid joined
14:00 jr3 joined
14:00 geoffb joined
14:07 <malwar3hun73r> i'm compiling from source to change BSONObjMaxUserSize from 16 to 32. All works as expected until I reboot and it then seems like the change is no longer valid (which makes no sense to me). Any suggestionsn?
14:10 <Derick> sounds like when you reboot, you start an older binary
14:12 culthero joined
14:18 freeport joined
14:22 raspado joined
14:25 ArchDebian joined
14:26 ArchDebian joined
14:35 edrocks joined
14:42 silenced joined
14:44 FrozenSolid joined
15:03 gentunian joined
15:03 coudenysj joined
15:14 DyanneNova joined
15:18 shackra joined
15:21 SkyRocknRoll joined
15:35 marc0s joined
15:35 sppadic_ joined
15:39 verwilst joined
15:44 Lujeni joined
15:49 <malwar3hun73r> Derick, yeah, i thought that too, but i've removed all older versions (or so i thought)
16:12 svm_invictvs joined
16:16 okapi joined
16:18 svm_invictvs joined
16:31 __alex joined
16:34 raspado joined
16:40 dump joined
16:46 jaequery joined
16:57 kexmex joined
17:00 coudenysj joined
17:01 jri joined
17:01 svm_invictvs joined
17:08 synchroack_ joined
17:08 Lujeni joined
17:15 edrocks joined
17:15 moura joined
17:19 point joined
17:24 s2013 joined
17:39 Folkol joined
18:00 Sasazuka joined
18:17 jr3 joined
18:27 re1 joined
18:39 einseenai joined
18:42 re1_ joined
18:45 `jpg joined
18:56 Abranus joined
19:00 RizziCR joined
19:04 timg__ joined
19:04 d10n-work joined
19:12 coudenysj joined
19:18 okapi joined
19:24 freeport joined
19:26 silenced joined
19:35 rendar joined
19:37 kexmex joined
19:38 okapi joined
19:51 Goopyo joined
20:11 broman joined
20:11 <broman> can someone please help me? I need to erase the db leaving the collections.. is that possible?
20:12 <Derick> no
20:12 <Derick> collections are part of the database
20:13 <broman> I want to erase only the data.. isn't this possible also?
20:13 <Derick> oh, just the data - sure
20:13 <Derick> db.colname.delete();
20:13 <Derick> or maybe you need:
20:13 <Derick> db.colname.delete( {} );
20:14 Abranus left
20:14 <Derick> sorry, it's remove() and not delete()
20:16 <broman> is there a bulk way of doing it?
20:16 <broman> ;)
20:19 <Derick> no, you need to do it collection by collection
20:19 <Derick> (or write a script)
20:24 `jpg joined
20:25 <broman> Derick, thank you very much!
20:35 `jpg joined
20:57 compeman joined
21:02 svm_invictvs joined
21:11 Folkol joined
21:13 Goopyo joined
21:18 silenced joined
21:19 chevz joined
21:20 chevz joined
21:28 StephenLynx joined
21:28 timg__ joined
21:33 jri joined
21:35 Muchoz joined
21:37 Sasazuka__ joined
21:37 jeffreylevesque joined
21:38 <jeffreylevesque> do i run https://docs.mongodb.com/v3.4/tutorial/deploy-shard-cluster/#add-shards-to-the-cluster on each mongodb node?
21:39 artok joined
21:42 re1 joined
21:47 re1_ joined
22:15 edrocks joined
22:28 gentunian joined
22:38 joshontheweb joined
22:52 s2013 joined
23:08 `jpg joined
23:14 xaep joined
23:17 joshontheweb joined
23:17 Abranus joined
23:20 xaep joined
23:36 s2013 joined
23:44 sterns joined