[10:32:37] <spotty> Hi all, I'm trying to tail a changestream via mongos (for a sharded cluster) and I'm experiencing "hickups" (i.e updates are not coming in live in my watch) Anybody has experience with this ? I spent hours investigating already, so I have a lot more info to provide if anybody can help me.
[10:33:32] <Derick> spotty: I think it's best to contact support about that one?
[10:35:23] <spotty> @Derick do you know which channel of support is the best to use ? Because there's a of different community support channels (incl. this one)
[10:37:47] <Derick> but your best bet community wise is probably the mongodb-user google group: https://groups.google.com/forum/#!forum/mongodb-user
[10:38:34] <spotty> Paid support can also be an option, I'm just not sure where to start there since I don't have a contract with them or anything.
[10:39:04] <spotty> I see on their website they have a lot of products & services for support, do you know which is the "basic one to ask a question" kind of ? :)
[10:42:22] <Derick> So I'd suggest the google group!
[10:42:43] <spotty> Perfect, I will have a look thanks !
[10:43:06] <spotty> Btw in the meanwhile I found a "sales" chat on their website, if they can't redirect me to the right channel, I don't know anybody else who can :)
[10:43:37] <Derick> They might try selling you something though! :)
[10:44:16] <spotty> Yeah indeed, we'll see how that goes :)
[14:11:10] <alsuren> is there a guaranteed-index-efficient way find documents with one of its fields set to the empty list (like https://stackoverflow.com/a/49101778/58477 )? I tried this on my local machine and a few times it gave "indexBounds": {"sources": [ "[undefined, undefined]", "[null, null]", "[[], []]" ],...} and now it's giving "sources": ["[MinKey, MaxKey]"] https://www.irccloud.com/pastebin/LszpRWCm/
[14:12:23] <alsuren> I don't want to run it on production and have it do a scan of the whole collection
[14:20:02] <alsuren> I suppose I could give it a maximum query runtime of a few seconds, and if the query planner decides to scan the whole collection, it will automatically get nuked?
[14:49:21] <ultraflash> I've being scouring through all the documentation for MongoDB and GridFS and googling like a mad man but I still can't figure out how to create a GridFS bucket I can then upload to. I'm using the PHP library installed via composer. Anyone know how to create a bucket?
[14:56:53] <ultraflash> have you any experience with GridFS?
[15:27:56] <alsuren> ah. it's good enough to just order by `sources` with a limit
[18:34:12] <MiticoDios> ello, I'm trying to achieve to do the following -> 1) First I want to get all the txn in my user_txn collections and group them by their email. 2) Then, add those txn for each user/email. 3) Then see who has more than 300+ amount
[18:34:56] <MiticoDios> Hello, I'm trying to achieve to do the following -> 1) First I want to get all the txn in my user_txn collections and group them by their email. 2) Then, add those txn for each user/email. 3) Then see who has more than 300+ amount, I'm using MongoDB with Laravel (php7.2)
[20:50:32] <manfred> Hey, is there anything different between the implementations of pymongo on python2 and python3?
[20:52:35] <manfred> i have a super weird situation where everything is working in python2, and it works fine from the repl in python3, but my commands are failing from my tests in python3
[20:53:16] <manfred> and i get Bad File descriptor error
[20:53:25] <manfred> during the selector step in topology
[20:54:24] <manfred> and i am just connecting to 'mongodb://localhost:27017'
[21:03:45] <manfred> pymongo.errors.ServerSelectionTimeoutError: localhost:27017: [Errno 9] Bad file descriptor
[21:11:30] <manfred> if anyone has any ideas, please whisper `gtmanfred` that one is on a bouncer. i don't have access to that right now. Thanks!
[21:56:58] <negaduck> hello. I've written a tiny webserver that translates simple queries to mongo instance. It seems that the max read requests per second I can get now is around 800. How good is that for a vm with 6 cores?
[21:59:39] <negaduck> the mongo instance is the bottleneck since without accessing the db I can get thousands of req/s. I'd like to understand how I can configure mongo to handle a couple of thousands of req/s.