pmxbot IRC Log Viewer

[02:58:30] <e^0_> any place where i can learn mongodb ?

[02:58:46] <e^0_> i am starting with databases i have no prior experience with DB.

[03:05:26] <Eremiell> e^0_: https://university.mongodb.com/

[03:09:38] <e^0_> Eremiell: in that it shows only future sessions taht are to be conducted ?

[03:15:17] <Eremiell> e^0_: I guess so. I think M102 should start soon again and M101P just started, you can still join.

[03:15:55] <e^0_> Eremiell: ok let me check that

[03:59:30] <lgm> Hello!

[03:59:43] <lgm> i'm running into a strange situation with sharding.

[04:00:27] <lgm> i had everything working, then went to rerun my tests on a clean machine and am now getting an error on adding a shard

[04:00:36] <lgm> mongos> db.runCommand( { addShard: "mongo.configsrv.1.dev:27017", name: "shardOne" } );

[04:00:42] <lgm> returns:

[04:00:50] <lgm> "$err" : "error creating initial database config information :: caused by :: can't find a shard to put new db on",

[04:01:03] <lgm> any help would be greatly appreciated

[09:29:38] <meadhikari> Hi is there a way to get the last data inserted, I am using mongoose

[11:01:48] <kas84> hi

[11:02:31] <kas84> does anybody know if mongodb does any kind of mainteinance operation after a huge deletion of data?

[11:02:50] <kas84> like reindexing or something like that

[11:03:11] <Derick> MongoDB doesn't do that

[11:03:28] <Derick> index updates happen while you delete each document

[11:57:13] <roxlu> hi guys, when I use something like .. db.find(...).limit(10) or db.find(...).limit(1000) would that have big performance differences? (I would say no, but just checking)

[11:57:46] <Derick> it has aperformance difference as you need to read more documents, and send more documents over the network

[11:57:52] <Derick> I'd say it's linear

[11:58:33] <roxlu> Derick: thanks, but I guess the actuall performance hit is in the find(...) itself and not the limit right?

[11:59:02] <Derick> it's in reading 100 more documents

[11:59:10] <Derick> *100 times the amount of documents

[11:59:25] <Derick> as long as it's an indexed query, that's it

[11:59:35] <Derick> if it's a non-indexed query, the hit is in the find()

[11:59:37] <roxlu> yeah. but the 'read' operation is probably neglectable for these amounts I would say?

[11:59:50] <roxlu> its a indexed query

[11:59:57] <Derick> Thta all depends on how large the documents are...

[12:00:07] <Derick> if they're 1MB each, it will certainly not be neglectable

[12:05:48] <roxlu> Derick: they're really tiny, < 200 bytes

[12:22:09] <kas84> Derick: mmm does it do anything special after a huge deletion?

[12:23:30] <kas84> the thing is, I stopped the online program that was writing to 50 collections or so,

[12:23:39] <kas84> deleted lots of data based on time with a node script for all those channels

[12:24:06] <kas84> and after it finished started the online program, back on and a few data was lost

[12:24:54] <kas84> like 1 in each 4 seconds of data

[19:45:01] <cortexman> { "content" : "<p>test</p>", "uid" : "JqmFcDP27rG42gdiH", "_id" : "uP8HnGtbnQK7PJMMW" } db.Responses.find({uid: "JqmFcDP27rG42gdiH"})

[19:45:10] <cortexman> what's wrong with this query? it doesn't return the document

[19:46:41] <kali> looks good from here

[19:47:01] <kali> sure the collection name is "Responses" ? not "responses" ?

[19:47:06] <kali> are you in the right DB ?

[19:48:01] <cortexman> db.Responses.find() works

[19:48:33] <kali> you're in the shell ?

[19:50:48] <cortexman> yes

[19:51:34] <kali> show me the session with the broken query and the working find

[19:51:44] <cortexman> oh gosh i'm an idiot

[19:52:07] <cortexman> i accidentally exited the shell and lost the db

[19:52:09] <cortexman> sorry

[19:52:19] <kali> no problem :)

[19:52:45] <kali> cortexman: i always set the db when starting the shell

[19:53:00] <kali> so if i close it, the up arrow will get me to the right place

[19:53:22] <kali> i mean: i start the shell with the db name as argument

[19:56:35] <cortexman> ah

[19:56:36] <cortexman> tx

[21:23:50] <h4k1m> hi guys

[21:24:17] <h4k1m> I've installed mongodb on freebsd and when I try to start it with `mongod`

[21:24:29] <h4k1m> I get a : could not connect to MongoDb [Errno 61] Connection refused

[21:25:10] <h4k1m> according to stackoverflow a /data/db folder is missing

[21:25:56] <h4k1m> should I create it manually or give a folder of mine as a --dbpath param

[21:27:35] <Derick> h4k1m: just create it

[21:29:15] <h4k1m> Derick: but I'm on freebsd should I create in the root?

[21:29:36] <Derick> h4k1m: it's really up to you where you want to store the data files really...

[21:29:39] <h4k1m> shouldnt mongod have permissions to write to this folder?

[21:29:50] <Derick> yes, it should be able to write to the dbpath

[21:30:03] <h4k1m> I think it would be better to have them in my own folder

[21:30:24] <h4k1m> but I guess that I have to add this dbpath to /etc/mongodb.conf

[21:32:37] <Derick> yes

[21:32:48] <Derick> tbh, I think /data/db is an odd default

[21:35:09] <h4k1m> Derick: but how do I specify dbpath inside /etc/mongod.conf in order for the service to start automatically

[21:35:15] <h4k1m> adding: dbpath=/home/user/mongodb didnt work

[21:35:15] <Derick> dbpath=/home/derick/mongodb-demo

[21:35:17] <Derick> is what I have

[21:35:31] <Derick> you need to make sure: 1. it exists, 2. the mongod user can write to it

[21:36:09] <h4k1m> Derick: maybe I should change the ownership

[21:36:24] <Derick> and don't forget /home/user either

[21:36:55] <h4k1m> yep sure the path has to be absolute

[21:37:01] <h4k1m> thanks for the help Derick

[21:37:13] <h4k1m> I'll try it now

[21:49:22] <h4k1m> that's why it was using the default location which doesnt bother me

[22:05:06] <john[[> vin 2

[22:06:06] <Zelest> Heh, drinking wine and arguing politics on Facebook.. I just love Internet!

[22:07:04] <fl0w> The political system is so outdated.

[22:07:31] <Derick> Zelest: try scotish independence...

[22:08:18] <Zelest> we have election in Sweden tomorrow..

[22:08:24] <fl0w> I know, I’m Swedish.

[22:08:34] <Zelest> fl0w, what ya voting on? :)

[22:08:52] <fl0w> honestly, undecided.

[22:08:59] <fl0w> … still

[22:09:01] <Zelest> Hehe

[22:09:05] <Zelest> I voted M a few days ago

[22:09:19] <fl0w> I should vote M considering I’m a small business owner

[22:09:22] <Zelest> Not happy with either, but I have no faith in the red/green setup tbh :/

[22:09:59] <Zelest> Well, 60% taxes.. fine, taxes are good.. but seeing how they spend taxpayers money, I don't really believe in taxation anymore. :/

[22:10:15] <Derick> Zelest: i am aware :-)

[22:10:48] <Zelest> And I lived on welfare for 5 years during the socialist years.. and their model for work does not work, I've tried it and no.. just no.. :P

[22:11:13] <Zelest> I consider shaving my head if M loses! :D

[22:11:16] <Zelest> In support

[22:11:46] <fl0w> I have no faith in voting for any party for 4 years … why can’t I have a default on some party and then poll vote online when things get interesting? Like, when M took office (which I voted for) and they voted for “data lagring” ..

[22:11:58] <fl0w> I was so mad.

[22:12:16] <Derick> M is?

[22:12:22] <fl0w> Moderaterna (right wing)

[22:12:26] <Derick> data lagring is not legal though, says the EU

[22:13:32] <fl0w> And nothing’s happening about that … I have no faith in the political system at all. This time around also has been one of the worst elections too in my opinion. It’s a blame game at its finest.

[22:14:15] <fl0w> Zelest: So I should /part then if they do ;) I’m a 1st gen immigrant.

[22:14:50] <Zelest> fl0w, Hahaha, I meant seeing Reinfeldt is bold.. :P

[22:15:07] <fl0w> Oh, I thought you were referring to SD :)

[22:15:20] <Zelest> SD is just not an option, ever. :)

[22:15:41] <fl0w> Well, then maybe I should just vote for you then!

[22:16:52] <fl0w> Onto mongo related topics. I’m trying to figure out if storing large sets of 2d cartesian data in mongo is … a good choice for me. For a tile based game, anyone worked with the 2d indexing in mongo before?

[22:17:27] <fl0w> Always the same thing, I ask a question, and a net split occurs.

[22:17:35] <Derick> :-)

[22:17:53] <Derick> i've only used 2dsphere stuff

[22:17:55] <Derick> but 2d works well

[22:18:21] <fl0w> plane 2d should be faster though, right?

[22:18:39] <fl0w> I would utilize $near heavily.

[22:18:42] <Zelest> fl0w, where in Sweden do you live btw? (think I've asked this before a while back)

[22:18:49] <Derick> yes, you should use that if it's not geospatial

[22:19:28] <fl0w> it’s not .. or, it can be whatever I want it to be but .. no, have no gain but doing it spherical.

[22:19:33] <fl0w> Zelest: Stockholm.

[22:19:37] <Zelest> Ah

[22:19:39] <Zelest> Örebro here

[22:20:11] <fl0w> So I’m about a 3 hour drive for some wine access then!

[22:20:45] <Zelest> 2 hours with train!

[22:20:58] <fl0w> There’s no trains leaving at night thought :/

[22:21:05] <Zelest> Ah, true that

[22:21:19] <Zelest> well, 2 hours with car as well, seeing it's night ;)

[22:21:26] <fl0w> tru.dat.

[22:22:11] <Zelest> only got white wine though.. and make sure to bring ladies!

[22:26:59] <fl0w> Christ, gotta hate cleaning up a wordpress database :/ The broken foreign keys are a mess.

[22:27:45] <Zelest> s/database.*are/it's/g

[22:29:50] <fl0w> Yea. So’s PHP and Wordpress.

[22:30:12] <Zelest> :)

[22:44:23] <Zelest> fl0w, heh, left a huge IRC channel now as well due to SD :D

[22:44:37] <fl0w> ?

[22:44:39] <Zelest> fl0w, apparantly half the channel supported their cause quite to the extreme

[22:45:14] <Zelest> we were discussing welfare and such.. and some asshat goes "se till att ha rätt hudfärg så får du nog det dubbla" .. and the war was on :P

[23:29:15] <fl0w> maybe somebody will know, if I have weird characters at the beginning of a file which is UTF-8, and it’s not an UTF-8 BOM, what could it be?

[23:47:43] <fels_zh> hi all

[23:48:57] <fels_zh> anyone here that can help me model my entitties

Log file Viewer

Help | Karma | Search:

#mongodb logs for Saturday the 13th of September, 2014