pmxbot IRC Log Viewer

[06:24:41] <aps> While trying to start mongos, I get following error:

[06:24:41] <aps> "ERROR: error upgrading config database to v5 :: caused by :: could not write initial changelog entry for upgrade :: caused by :: failed to write to changelog: could not verify config servers were active and reachable before write"

[06:24:41] <aps> I can connect to config members. what is the reason for this error?

[06:25:00] <aps> How do I fix this?

[06:43:23] <gemtastic> As a default it seems like MongoDB is accessable without any passwords or authentication. If I create users, will that change?

[07:03:31] <Boomtime> gemtastic: the existence of users only matter if auth is enabled on the server - without auth, you can still create users, and you can even test auth'ing, but you'll also still be able to connect without auth'ing at all

[07:04:28] <gemtastic> That makes it sound like authing is completely pointless

[07:05:32] <gemtastic> How do I protect my Mongodb database?

[07:06:02] <Boomtime> you enable auth on the server

[07:06:15] <Boomtime> "the existence of users only matter if auth is enabled on the server" <- is this not clear?

[07:06:30] <Boomtime> if auth is enabled on the server you MUST auth every user

[07:06:52] <gemtastic> No, that is not clear to me at all, I'm still a n00b :(

[07:07:23] <Boomtime> sorry, if that sounded harsh, but auth'ing is not exactly unique to mongodb

[07:07:46] <gemtastic> I have no idea how to put auth on the server or what that actually implies :/

[07:08:02] <Boomtime> http://docs.mongodb.org/manual/tutorial/enable-authentication/

[07:08:06] <Boomtime> :-)

[07:08:29] <gemtastic> Thanks, I'll read it

[07:08:37] <Boomtime> that tutorial will guide you through the steps, including creating the necessary user account needed to create further users

[07:09:05] <Boomtime> the first thing everybody does when they enable auth is lock themselves out of the database - be sure to read it all before you start

[07:09:52] <gemtastic> Well, this is the first time I'm building something that's gonna be pushed to a real server. Atm I'm still just trying to get a secure testing environment working on my computer...

[07:10:25] <Boomtime> righto

[07:10:51] <gemtastic> I'm gonna read the link now before I ask any more questions it will answer ;)

[07:51:40] <kexmex> Hey guys. I think CPU is high due to Leap second. What to do?

[08:42:07] <schlitzer> hey, i have took over a mongodb 1.8 installation (replicaset)

[08:42:26] <schlitzer> is it possible to upgrade to mongo 3.0 directly?

[08:49:29] <coudenysj> schlitzer: "To upgrade an existing MongoDB deployment to 3.0, you must be running 2.6. "

[08:49:50] <coudenysj> http://docs.mongodb.org/manual/release-notes/3.0-upgrade/#upgrade-requirements

[08:53:20] <schlitzer> coudenysj, then would be the question if it is possible to directly upgrade from 1.8 to 2.6

[08:53:34] <coudenysj> you must follow the upgrade chain

[08:53:48] <coudenysj> http://docs.mongodb.org/manual/release-notes/2.6-upgrade/#upgrade-requirements

[08:53:58] <coudenysj> etc...

[08:58:33] <schlitzer> okay thank you

[09:59:53] <Repox> Hi guys. I have a setup with a master node and a replica node. It's running and all is well. Is it possible for me to enable authentication now? And should it be done in a specific way when a replica set is setup?

[10:32:13] <bonhoeffer> what datatype is Meteor.userId()

[10:33:05] <bonhoeffer> BSON integer?

[11:13:55] <aps> Hi. I get this error while trying to start mongos - "configServer connection startup check failed"

[11:13:56] <aps> I checked that mongoc servers are running. Any ideas?

[11:31:50] <aps> Okay, so I have found out that my config servers are out of sync. How can I fix this if I *don't* care about the data?

[15:58:06] <diegoaguilar> Hello, can someone help me with this mongodb query? http://stackoverflow.com/questions/31210584

[16:24:00] <pamp> I cant connect to mongo cluster with .Net driver 2.0, here is my code: http://dpaste.com/382ZMZ6. I tried to connect to a standalone local instance and it works, but when I try connect to the cluster I get an exception TimeOut

[16:24:16] <pamp> I m missing something in the connection string?

[16:32:44] <bybb> Hey everyone

[16:33:33] <bybb> Have you already tried and succeed to run mMngoDB in Docker on a Mac OS?

[16:33:40] <bybb> MongoDB

[16:34:13] <bybb> I get a permission error on a mounted volume

[16:59:38] <pqatsi> This error can lead mongo to crash? NETWORK [conn609] SocketException handling request, closing client connection: 9001 socket exception [SEND_ERROR] server [127.0.0.1:57658]

[17:00:59] <joannac> pqatsi: no, that's a socket exception, a single connection closing

[17:01:33] <pqatsi> joannac: even if repeat a lot of times?

[17:02:26] <pqatsi> joannac: because filtering WRITE, QUERY and COMMAND from mongo log, i got a lot of these one after other and a server crash at last

[17:02:57] <pqatsi> Like this:

[17:02:57] <pqatsi> 2015-07-03T12:48:30.826-0300 I NETWORK [conn3106] SocketException handling request, closing client connection: 9001 socket exception [SEND_ERROR] server [127.0.0.1:37210

[17:03:00] <pqatsi> ]

[17:03:03] <pqatsi> 2015-07-03T12:48:33.354-0300 I CONTROL [thread1] ***** SERVER RESTARTED *****

[17:08:05] <joannac> check your system logs

[17:13:18] <pqatsi> joannac: only place that have something is dmesg: http://pastebin.com/yQ5Ntjby

[17:13:58] <joannac> the system stayed up, but mongod went down?

[17:14:52] <joannac> the above is a hard crash ... usually when mongod crashes there's something in the logs indicating why

[17:22:11] <pqatsi> joannac: notting on log.... :(

[18:04:34] <joannac> mantovani: in response to your PM, read the topic and register your nick

[18:05:13] <mantovani> done

[18:05:21] <mantovani> I didn't notice I was " mantovani2 "

[18:12:07] <jlherondelle_> hi

[18:14:03] <joannac> mantovani: :) happens to me all the time after a netsplit

[18:14:06] <joannac> jlherondelle_: hi

[18:14:35] <jlherondelle_> someone here using cakephp ?

[18:14:42] <jlherondelle_> with mongodb

[18:15:10] <cheeser> i avoid php as much as possible.

[18:17:23] <jlherondelle_> i try to get posts less than 3 hours like this :

[18:17:28] <jlherondelle_> $myList = $this->Post->find('all',array('conditions'=>array(

[18:17:29] <jlherondelle_> 'post.created >' => date('c', strtotime("-3 hours")))));

[18:18:00] <jlherondelle_> request is :

[18:18:52] <jlherondelle_> db.Post.find( {"post.created >":"2015-07-03T15:04:52+00:00"}, [] ).sort( [] ).limit( 0 ).skip( 0 ).hint( [] )

[18:19:42] <jlherondelle_> do yoy know if mongodb can understand this request ?

[18:20:18] <joannac> why do you have so many empty arguments for things?

[18:20:21] <joannac> just leave them out

[18:20:22] <cheeser> i would expect so.

[18:20:31] <cheeser> ( i was wondering about that, too )

[18:21:24] <jlherondelle_> it should provide with the plugin i think

[18:21:39] <joannac> in any case, why don't you just run it?

[18:21:48] <joannac> would be faster than asking us

[18:22:15] <jlherondelle_> i'm in an internship and don't have any access

[18:22:34] <jlherondelle_> i'm going to ask testing the request :)

[18:23:07] <joannac> wait

[18:23:11] <joannac> your query is wrong

[18:23:18] <joannac> google for mongodb and $gt

[18:23:38] <jlherondelle_> i just saw this

[18:23:48] <jlherondelle_> but i don't understand, in cakephp doc

[18:23:49] <joannac> also, if whoever wrote this app is storing dates as strings, hit them over the head

[18:23:54] <joannac> that is a really bad idea

[18:24:12] <jlherondelle_> i know lol

[18:24:14] <jlherondelle_> but he doe

[18:24:15] <cheeser> joannac: for the record, morphia supports writing queries with > , e.g.

[18:24:15] <jlherondelle_> does

[18:24:22] <cheeser> some layers will do that translation for you

[18:24:25] <joannac> cheeser: oh.

[18:24:38] <joannac> cheeser: but inside the double quotes?

[18:24:41] <jlherondelle_> cake php told me to do :

[18:24:43] <jlherondelle_> array (

[18:24:43] <jlherondelle_> "Post.title" => array("First post", "Second post", "Third post"),

[18:24:44] <cheeser> sure

[18:24:45] <jlherondelle_> "Post.created >" => date('Y-m-d', strtotime("-2 weeks"))

[18:24:47] <jlherondelle_> )

[18:24:49] <joannac> cheeser: i would've expected "a.b" > "blah"

[18:25:03] <joannac> cheeser: not "a.b >" : "blah"

[18:25:16] <joannac> cheeser: your crazy layer is crazy

[18:25:23] <cheeser> it's bestest

[18:34:57] <jlherondelle_> Does this make sense for you ? db.Post.find( {"post.created":"$gt 2015-07-03T15:04:52+00:00"} )

[18:35:19] <jlherondelle_> better than the previous one ?

[18:38:39] <cheeser> the details are lost in the context of the php driver. neither joannac nor i have the experience to say much about it.

[18:39:28] <jlherondelle_> it's ok :D

[18:39:31] <jlherondelle_> thanks a lot !

[18:47:51] <jlherondelle_> I think mongodb can't compare string with "$gt" or ">", that's why my request can't work correctly

[18:59:42] <jlherondelle_> Bye guys, see u !

[19:30:41] <bros> I have an array of subdocuments.They each have a timestamp on them. How can I make an aggregation that allows me to figure out the differences between the timestamps?

[19:31:00] <bros> For example, the difference between subdocument index 1 and subdocument index 0?

[22:48:14] <brunoj_rs> hey all

[22:48:54] <brunoj_rs> I'm getting some really weird behavior with the $in modifier on my queries

[22:49:07] <diegoaguilar> Hello, any expert with aggregation framework?

[22:49:08] <diegoaguilar> http://stackoverflow.com/questions/31210584/how-to-use-multiple-operators-to-a-mongodb-aggregation

[22:49:29] <brunoj_rs> the results seem to depend on the length of the array passed to the $in, and to be rather uninfluenced otherwise

[22:55:30] <Boomtime> brunoj_rs: can you share the query you are using?

[23:20:15] <brunoj_rs> Boomtime

[23:20:24] <brunoj_rs> I have traced the problem to the .sort() command

[23:20:30] <brunoj_rs> $in works fine after all

[23:22:04] <brunoj_rs> so, not $in but sort show strange behavior which depends on the number of entries in the original query. I am querying documents, which subsequently i want to sort by their "timeline" field, which is a simple integer (not datetime) representing the epoch

[23:22:25] <brunoj_rs> if I leave out sort, and do the sorting at the application level, the system works fine

[23:22:53] <brunoj_rs> however, if I let mongo do it, it simply cuts off the sorted list at an arbitrary point

[23:24:36] <brunoj_rs> now, this only happens if in the original query, of this shape: {"keyword": {"$in": [some keywords]}, "timestamp":{"$gte": from_time, "$lt": to_time}}

[23:24:50] <brunoj_rs> i have 10 or less keywords

[23:25:00] <brunoj_rs> if i have more than 10, the arbitrary cutoff happens

[23:25:09] <brunoj_rs> it doesn't matter WHICH ones however

[23:25:34] <brunoj_rs> so all possible combinations of the keywords return the correct result, as long as the $in contains 10 or less of them

[23:25:47] <brunoj_rs> (the timestamp query remains the same in all cases)

[23:26:09] <brunoj_rs> for the time being, I'm just going to sort on the application level

[23:32:04] <brunoj_rs> hey Boomtime

[23:35:59] <brunoj_rs> Take care people, I'm off

[23:43:17] <Boomtime> interesting claim about the $in and sort, it is obviously not true, but it would have been nice to see the actual query

[23:44:31] <Boomtime> and to confirm, tested with a result set of a few hundred thousand, with and without sort - with a predicate $in array of 10,11, or 12 items - also with the timestamp range predicate

[23:44:43] <Boomtime> all just dandy

Log file Viewer

Help | Karma | Search:

#mongodb logs for Friday the 3rd of July, 2015