Log file Viewer

[01:04:01] <haunted> hi

[01:04:12] <haunted> I have something to tell you guys

[01:04:44] <haunted> The people on #postgresql-lounge say you guys are the stupidest people on Earth

[01:08:54] <haunted> Hello

[01:12:38] <haunted> cheeser, Derick, GothAlice, joannac, Number6

[01:12:52] <haunted> Can I talk to you guys for a second?

[01:15:50] <haunted> Bradipo is the one who said it

[01:15:52] <cheeser> i'm not at all interested in uneducated opinions of randos on the internet

[01:16:05] <cheeser> it's irrelevant here. and anywhere outside his/her head.

[01:16:15] <haunted> ok

[01:19:01] <mst> is one of your users sending idiots to #postgresql-lounge ?

[01:20:01] <cheeser> that channel has been mentioned twice here in the last 15 minutes. i didn't even know it existed until then.

[01:20:05] <cheeser> so, no.

[01:21:02] <cheeser> i don't know what's going on there but no one here is instigating anything.

[01:21:08] <cheeser> at least in channel

[01:21:09] <mst> haunted got banned, brought an alt on to pretend to be an upset mongodb user, got nuked

[01:21:11] <haunted> well the people on that channel know you guys

[01:21:21] <mst> haunted: don't evade bans, son

[01:21:25] <haunted> They say you guys are idiots

[01:21:30] <mst> cheeser: sorry for the confusion

[01:21:32] <haunted> it kind pretend

[01:21:37] <haunted> it aint pretend

[01:21:49] <mst> haunted: please stop, you're already a proven ban evader

[01:22:04] <cheeser> sounds like haunted is just trying to provoke some stupid feud.

[01:22:10] <haunted> NO?

[01:22:14] <cheeser> sounds like a k-line is in order

[01:22:20] <mst> like that, say.

[01:22:24] <cheeser> huzzah!

[01:22:26] <mst> cheeser: my apologies again for the noise.

[01:22:41] <cheeser> no worries. happy to help root out bad seeds

[01:22:56] <mst> ta

[01:22:58] <mst> bye

[01:22:58] <joannac> Thanks for checking in with us, mst!

[01:23:02] <joannac> ciao

[01:23:13] <mst> (and do give us a shout if the reciprocal problem ever happens etc.)

[01:42:50] <GothAlice> Mmm, k-lines.

[04:00:27] <aarobc> so Is there a way to create a document only if the field name doesn't exist?

[04:11:00] <cheeser> you want to do what now?

[05:08:14] <aarobc> cheeser: if the key exists, don't do anything. if it doesn't exist, create it with a specified value

[05:27:15] <joannac> aarobc: sounds like upsert to me

[05:27:43] <aarobc> joannac: but won't upsert update an existing value?

[05:30:47] <joannac> is the "create it with a specified value" a different value to what you are querying for?

[05:39:18] <joannac> aarobc: maybe an example would help

[05:41:57] <aarobc> joannac: this is the current ugly method I'm using https://gist.github.com/anonymous/881c8e919d11e5def181f0d9b8bc87ca

[06:53:24] <sumi> hello

[06:53:53] <sumi> hello

[07:15:37] <joannac> sumi: did you have a question?

[07:16:00] <sumi> no i didn't. thank you :D

[07:45:24] <Jonno_FTW> hello

[07:46:28] <Jonno_FTW> I want to update a list inside a of my documents, how do I go about this with pymongo?

[07:46:49] <joannac> $addToSet, or $push

[07:49:13] <Jonno_FTW> I acatually want to divid them all by 8, but they're strings of numbers

[07:55:47] <joannac> Jonno_FTW: well, you should probably fix that first (and get them stored as a number type)

[08:09:43] <thapakazi> hi there, whatsup; how do i know if my index are being used or not ?

[08:12:09] <quattro_> after resyncing my replicaset secondary I can’t connect to it anymore

[08:12:22] <quattro_> Error: network error while attempting to run command 'isMaster' on host ‘replica1’

[08:13:16] <thapakazi> quattro_: what is log saying ?

[08:14:05] <quattro_> thapakazi: oh I see totally forgot to check

[08:14:10] <quattro_> thapakazi: 2016-07-26T08:04:16.881Z I NETWORK [initandlisten] connection refused because too many open connections: 819

[08:17:22] <thapakazi> oh seems servers kinda overloaded

[08:18:40] <thapakazi> Asking again, how do i know if my index are being used or not ?

[08:18:47] <quattro_> thapakazi: it’s a very busy replica set, it always has around 1200 connections open, apparently the ulimit suddenly changed back to 1024

[08:22:12] <thapakazi> no idea on that domain quattro_

[08:23:17] <joannac> thapakazi: check if queries are using it? in 3.2, there's also index usage stats https://docs.mongodb.com/manual/tutorial/measure-index-use/

[08:36:19] <thapakazi> 14:10 *** Rumbles JOIN

[08:36:26] <thapakazi> leh, thanks joannac

[09:49:00] <hemangpatel> Hello

[09:54:45] <hemangpatel> Here is my document, https://gist.github.com/Chintanvpatel/609a99f3f043ae3776b854374d6da497

[09:54:58] <lowbro> nice document there

[09:56:21] <hemangpatel> How can i filter this document in which content contain "type"=>"text" I don't have any keys of content object

[10:07:49] <jokke> hey

[10:07:58] <jokke> i need to sync two replica set nodes

[10:08:37] <jokke> i took a snapshot of the primary's data partition and used it to recreate the data partition for the secondary

[10:08:53] <jokke> if i fire up the secondary i get the following error: [rsSync] Invariant failure drec(ret)->extentOfs() < ret.getOfs() src/mongo/db/storage/mmap_v1/record_store_v1_capped.cpp 421

[10:08:59] <jokke> (in the log)

[10:09:20] <jokke> any idea what this means?

[11:43:08] <Twirl> Hello, I'm trying to use this module "node-mongodb-native", as a back-end to my react application, so I'm trying to import the client to connect to the database directly with var MongoClient = require('mongodb').MongoClient and it's throwing a bunch of errors that it cannot find "net", "dns" and "fs" modules (probably webpack?) am I missing something? Maybe i'm approaching this in the wrong way and I should separate the server from the client and connect i

[11:49:22] <Twirl> Module not found: Error: Cannot resolve module 'dns' in... ?

[14:47:09] <quattro_> how do i make mongodb 3.2 ignore informational and debug messages in the log?

[14:50:59] <quattro_> I’m not sure how these log levels associate with the numbers, there’s level -1 to 5

[15:17:13] <jokke> anyone here? i'm very confused how differently two of my mongod instances with identical data dirs are behaving

[15:17:45] <jokke> the second node takes forever to start because it's preallocating journal files

[15:17:58] <jokke> the first node does no such thing and is up and running instantly

[15:18:13] <jokke> even the configs are identical

[18:47:52] <n1colas> Hell

[18:48:26] <n1colas> o

[20:54:01] <Trinity> Is there a way to do an atomic find and update operation?

[20:54:23] <Trinity> to avoid race conditions if there are multiple processes running and your update is dependent on your find

[20:55:34] <StephenLynx> yes.

[20:55:48] <StephenLynx> findandmodify

[21:29:06] <Trinity> StephenLynx, I know you left but... if anyone else could help. The docs state that the returned object is the old version

[21:29:57] <Trinity> to be precise, I would like to remove a set of indexes from an array, since there is no operations modifier for that what I could do is unset and then remove but that would make the operation non-atomic

[21:30:23] <Trinity> now if I find the array edit it in javascript and then update it again it should be atomic except there could possibly be a race condition if more than one process was working on that document

[21:31:02] <Trinity> i.e I find the document, another process updates the document, and my update which was dependent on the previous find's version of the doc now updates it to something else

[21:31:08] <cheeser> this doesn't do what you want? https://docs.mongodb.com/manual/reference/operator/update/pull/

[21:31:34] <Trinity> cheeser, can i use it to pull by index?

[21:31:54] <Trinity> i.e someItem: [0,1,2,3,4,5] and I only want to remove index 0 and 1

[21:32:00] <Trinity> rather than by contents

[21:34:03] <cheeser> doesn't look like it.