Log file Viewer

[06:20:14] <bachler> Hey guys, is there any way of speeding up the initial sync of a new or broken member of a replica set?

[06:33:13] <bachler> Also, it says in the documentation for 3.6 that the maximum oplog size is 50GB, what is the reason for this cap?

[06:33:48] <bachler> I have a older 2.4 cluster with a oplog size of over 100GB

[08:43:47] <Derick> I'm not sure why there is a new cap, but ... that is a lot in any case

[08:44:14] <Derick> I'm not sure how you can speed up initial sync... it just needs to copy all data over

[13:08:25] <Derick> not everybody does leaflets right: https://twitter.com/PhilStanier/status/991398931593617410

[14:33:51] <cubud> Hi all

[14:34:21] <cubud> I am running an aggregate on a collection. Could someone tell me how to remap the final result into a flatter structure please? https://hastebin.com/usevafoguy.pl

[14:38:01] <cubud> Just posted it on StackOverflow https://stackoverflow.com/questions/50137308/how-do-i-flatten-the-results-of-an-aggregation

[15:21:35] <Derick> just add: { $project: { 'VacancyId' : '$_id.VacancyID', 'Status' : '$_id.Status', 'Count' : 1 } }

[15:23:37] <cubud> Excellent, thanks!

[15:24:03] <cubud> Can I do a kind of switch statement in the projection? So I can say "if Status = 40 then '5'" etc

[15:24:38] <cubud> I want to show alternative values, because I want to map them to show the values that are used in another system (the equivalent values)

[15:27:51] <Derick> yes, you can

[15:28:07] <Derick> https://docs.mongodb.com/manual/reference/operator/aggregation/cond/

[15:28:44] <Derick> or

[15:28:46] <Derick> https://docs.mongodb.com/manual/reference/operator/aggregation/switch/

[15:35:53] <cubud> Ah crap. It seems I have to use 2.6.5

[15:38:08] <Derick> if you're still on that low a version, you *really* need to upgrade

[15:38:19] <Derick> we're 4 versions later already, on 3.6

[15:38:57] <cubud> Not my decision I'm afraid

[15:57:21] <cubud> Thanks very much for your help!!

[15:57:27] <cubud> I appreciate it!

[17:48:35] <wrkrcoop> hello. i just joined a project and i’m new to mongo. they want to create a feature where we show the user events related to a project (kinda like github)

[17:48:45] <wrkrcoop> an event is associated with a project which is a collection

[17:49:23] <wrkrcoop> bubt here’s the thing. i imagine they’re going to want two things: to see events related to a company so all events across projecrts. and to see events related to just a project.

[17:50:17] <wrkrcoop> if i create an event and tie it to projects then i can get events but not for a company, if i tie the event to the company i can get all events for a company but not a project. is there a way i can get both the events for a company (all events) and events for just a proejct?

[17:53:20] <wrkrcoop> also can i do pagination in reverse chronological order?