Log file Viewer

[00:28:48] <brandonblack> .exit

[02:12:21] <JeffLing> Hey, is there a channel for the casbah driver specifically or can I ask a question here?

[02:14:27] <JeffLing> I'm using casbah. I'm having trouble using the QueryBuilder to make comparisons. Is this possible?

[02:42:36] <Astraea5> Hi. I just upgraded to 2.4.8 and setup users for my databases for the first time. I can't start mongod using "sudo service mongodb start", though. Could someone help me out?

[02:43:04] <joannac> What does the mongod log say?

[02:43:52] <Astraea5> I haven't been reading it, just the command line. Let me see if I can find where the log is by default, and I'll let you know.

[02:46:43] <Astraea5> Looks like this is the problem: couldn't open /var/lib/mongodb/admin.ns errno:13 Permission denied

[02:46:54] <Astraea5> error couldn't open file /var/lib/mongodb/admin.ns terminating

[02:48:01] <Astraea5> I'm not sure why that would be a problem when executing the command via sudo. I'll do some reading and see if I can figure it out.

[02:55:02] <Astraea5> It looks like this is a problem with users and permissions. At some point I did something which made this file belong to the user/group root/root, when it should belong to mongodb/mongodb

[02:55:26] <Astraea5> I'll fix that now. Are there any other files which, off the top of your head, you would suspect may be in need of permission changes as well?

[03:07:37] <Astraea5> I can start and stop the mongo service now. Thank you for the help.

[03:27:04] <Astraea5> I'm working on adding authentication to my program (making it so the program executes queries as a user with limited roles). Could someone validate if this is how authentication over a network works?:

[03:27:05] <Astraea5> After calling db.authenticate() the authentication details are stored on the client and sent back to the server with each subsequent command.

[03:47:48] <quattro_> i want to use MMS do i need to install the monitoring agent on every server?

[04:27:50] <uptownhr> hi, i'm new to mongo coming from relational db like mysql. I'm thinking of 3 main collections right now. User, Site and Group. Group will hold a list of Sites and assigned to a User. Site will be assigned to a User. I would want to be able to query for all sites a user owns, all the sites associated to a certain group. In this scenario, what would be the best structure?

[04:28:33] <uptownhr> sounds simple enough but would the best approach be just running two queries or should i be using sub documents?

[04:32:42] <uptownhr> http://docs.mongodb.org/manual/tutorial/model-referenced-one-to-many-relationships-between-documents/

[04:32:59] <uptownhr> mentions avoiding "mutable growing arrays"

[04:33:03] <uptownhr> can someone explain what that is?

[04:34:38] <uptownhr> is there a better channel to ask/discuss about mongo structures and queries?

[06:11:16] <s3b`> if I had a messaging service similar to fb's

[06:11:42] <s3b`> what would be more efficient:

[06:12:15] <s3b`> db.convo {id: convoid, sender; user1, msg: "hello"}, orr db.convo {id:convoid, msgs: [{}, {}. {}];

[09:42:40] <will_123> Hi, does anyone know if there's a way to query a running mongodb instance for runtime config options such as --quota and --quotasize?

[09:48:33] <joannac> will_123: db.serverCmdLineOpts()

[09:56:29] <will_123> thanks joannac!

[11:03:56] <justanotherday> jkitchen!!!

[11:12:34] <hkonkhon> irc://irc.freenode.net/#mongodb

[11:13:07] <BlackPanx> we have deleted some data from our collection but it didn't reclaim space on disk... do i need to send repair or something over it, to reduce it's size back to what it has to be ?

[11:13:27] <BlackPanx> becouse i had 40GB of data there, now it should be around 2GB and i want those 38GB back

[11:18:02] <Nodex> you can compact I think but ot's not advisable on a live data set

[11:18:07] <Nodex> it's *

[11:20:12] <Nodex> my mistake. you want "repairDatabase"

[11:20:13] <Nodex> http://docs.mongodb.org/manual/reference/command/repairDatabase/#dbcmd.repairDatabase

[11:22:28] <BlackPanx> that repairDatabase will make full writelock on all my databases i guess

[11:22:46] <BlackPanx> if i understand correctly ?

[11:24:11] <justanotherday> Can anyone please help explain how I can insert sql dump files into mongodb

[11:26:17] <Nodex> BlackPanx: yes, it says it in the docs

[11:29:53] <BlackPanx> is it safe to execute this command on my master when it's running ?

[11:30:02] <BlackPanx> i mean, this replicaset is working

[11:30:09] <BlackPanx> and has reads all the time

[11:30:23] <BlackPanx> will this repair replicaset members also ?

[11:30:31] <BlackPanx> it doesn't say

[11:30:34] <BlackPanx> on the manual

[11:32:44] <leifw> BlackPanx: I've heard of people making a primary step down in order to run things like compaction before letting them catch back up and promoting them again, so there's probably a good reason to do something like that

[11:33:23] <leifw> BlackPanx: though maybe the only reason is to maintain availability, so maybe if you don't mind taking things offline for a while you don't need to do that

[11:34:11] <leifw> BlackPanx: though if you make it step down you may actually also need to take it out of the set, I don't remember if repair can be run on a replicating secondary

[11:36:46] <BlackPanx> thanks leifw

[11:36:52] <BlackPanx> i thought that might be the case

[11:38:34] <leifw> I'm pretty sure that operation wouldn't be logged, so it wouldn't replay on secondaries

[11:38:48] <leifw> I think the most careful thing to do would be to rotate one secondary out at a time and run it

[11:39:07] <leifw> a slow process but you'd keep the database up

[12:29:11] <justanotherday> Please does mongodb support linking between documents

[12:44:41] <mikejw> I'm using the mongo client from the command line and I'm expecting multiple results from a query.. how can I make sure that the ouput will be valid json as in an array of documents?

[12:44:54] <mikejw> (while manipulating the cursor)

[12:47:03] <BlackPanx> leifw: thanks for great idea. i think this will be best thing yes, since this repair command doesnt go thru replication. we executed repair on our current master and it didn't happen on slaves.

[12:50:14] <mikejw> I guess I'll just create the array before calling printjson :)

[13:28:42] <BlackPanx> this went smooth, each server down and not started with replSet , then repair database, then back uncommented replSet ...

[13:43:43] <Nodex> :)

[15:16:59] <timgluz> #bower

[15:26:43] <SmokedCheese> sup

[16:05:45] <Nodex> http://www.openpropertyexchange.co.uk/

[16:07:44] <pithagorians> hi all. i have already working db. can i take somehow it's "schema"?

[16:07:58] <Nodex> there is no schema

[16:08:20] <pithagorians> the db structure

[16:08:24] <pithagorians> i mean

[16:08:28] <pithagorians> without data

[16:09:55] <quickdry21> instructions here http://docs.mongodb.org/manual/tutorial/backup-sharded-cluster-with-filesystem-snapshots/#procedure call for a mongodump of the config db. any reason i couldn't take a filesystem snapshot of the config server i shut down?

[16:16:02] <Nodex> pithagorians : you will have to loop each document and build it yourself

[16:16:21] <pithagorians> :|

[16:29:20] <n008> getting this error: OperationFailure: database error: $or requires nonempty array

[16:32:06] <cheeser> sounds like you're missing an array

[16:36:34] <kali> or something in it

[16:37:55] <kali> it does feel good to help people

[16:53:05] <rafaelhbarros> any mongodb event coming up in austin-tx?

[16:54:08] <jyee1> rafaelhbarros: looks like you just missed the Austin MUG: http://www.meetup.com/Austin-MongoDB-User-Group/

[16:56:04] <rafaelhbarros> oh darn

[16:56:14] <rafaelhbarros> jyee: thanks for the suggestion!

[17:10:04] <quickdry21> When i do a db.fsyncLock(), my secondary hangs completely, can't open a new shell.

[17:10:24] <quickdry21> Won't respond to INT or TERM

[19:33:22] <ramsey> I want to create a collection of promo codes in which I can query for the next available code and mark it as "used," avoiding a race condition where another request could potentially get the same code. Anyone know of any resources that describe how to achieve this with MongoDB?

[19:36:36] <SmokedCheese> ramsey: http://docs.mongodb.org/manual/reference/command/findAndModify/

[19:37:19] <ramsey> SmokedCheese: Awesome! I think that's exactly what I need. Thanks!

[20:15:29] <quickdry21_> Is it necessary to fsyncLock a mongod instance if journaling is enabled? I'm doing a filesystem snapshot.

[21:42:06] <tomasso> i have stores with categories a products.. is there some way to return all products? they are stored as subdocuments, but they are not a different collection