PMXBOT Log file Viewer

Help | Karma | Search:

#mongodb logs for Thursday the 29th of May, 2014

(Back to #mongodb overview) (Back to channel listing) (Animate logs)
[00:56:52] <KrzyStar> Hmmm interesting
[00:57:09] <KrzyStar> Mongo client still fails to start up
[00:57:21] <KrzyStar> Might it be because I'm running a hardened kernel?
[00:57:59] <KrzyStar> Hm, it seems so - https://jira.mongodb.org/browse/SERVER-9248
[01:00:52] <KrzyStar> Erm nope, bullshit, it would've already been patched
[01:00:55] <KrzyStar> http://krzystar.neutrino.re/paste/mongo.txt
[01:57:54] <joannac> KrzyStar: looks like https://jira.mongodb.org/browse/SERVER-12991 ?
[03:39:46] <adrian_berg> anyone around here?
[03:39:54] <adrian_berg> https://pastee.org/dmuav
[03:40:09] <adrian_berg> i'm trying to figure out why this doesn't print out the expected results
[03:40:33] <adrian_berg> I instead get this result:
[03:40:34] <adrian_berg> https://pastee.org/kem5e
[03:54:02] <joannac> have you tried adding w:1 to your connection parameters?
[07:28:02] <user123321> Should I install MongoDB first or PHP-My-ADMIN in Ubuntu? Does any order affect a conflict, could I have some advice? Thanks!
[07:28:11] <user123321> PHY-MO-ADMIN*
[07:28:18] <user123321> php*
[08:33:43] <nevan> MongoClient::connect(): php_network_getaddresses: getaddrinfo failed: Name or service not known
[08:33:57] <nevan> what can cause this .... i am using the latest php mongo driver
[08:33:58] <nevan> ?
[08:33:59] <nevan> ?
[08:35:43] <nevan> ?
[08:36:14] <nevan> MongoClient::connect(): php_network_getaddresses: getaddrinfo failed: Name or service not known
[08:37:17] <Gargoyle> nevan: Just because you repeat yourself does not mean you'll get a qucker answer (or any answer at all).
[08:37:53] <Gargoyle> The error means your machine failed to lookup the hostname you are trying to connect to.
[08:38:23] <nevan> sorry but it was an effor to get attention as most of the times before nobody actually responds...sorry again
[08:38:58] <nevan> but when i give single string instead of seeds of replica sets then i do not come across this issue
[08:39:19] <nevan> its just when i use primary, secondary IP's in connection settings
[08:40:22] <Gargoyle> nevan: People in here give their time freely. If they can answer, they will. If they can't because they don't know or are too busy, then they will keep quiet. Do you really want 346 "I don't know" replies! :-)
[08:40:34] <Gargoyle> nevan: Pastebin the actual connection code you are using.
[08:40:47] <nevan> i apologize yet again
[08:40:59] <nevan> ok...ill just paste it
[08:44:57] <nevan> http://pastebin.com/LTNRJuVX
[08:45:32] <Gargoyle> nevan: That is not PHP code
[08:45:36] <nevan> @Gargoyle : just replaced the actual IP with (IP) , replica set name with <replicaset> and dbname with <dbname>
[08:45:50] <nevan> thats part of config.ini ...zend framework
[08:47:42] <nevan> modified the paste http://pastebin.com/pZi7YKf7
[08:48:20] <nevan> but if i use single IP then it works
[08:48:33] <nevan> its php mongo driver 1.5.2 and mongo 2.
[08:48:36] <nevan> 2.6
[08:49:05] <nevan> pings to each IP are absloutely ok
[08:49:11] <Gargoyle> OK, I have no knowledge about ZF and MongoDB. However, just by looking at that snippet whatever code is interpreting that line is going to have difficulties with the number of arguments
[08:49:24] <nevan> what do you suggest?
[08:49:42] <Gargoyle> #zftalk !? :-)
[08:50:06] <nevan> thanks never thought about that :)
[08:50:19] <Gargoyle> You could also try single quotes round the mongodb://... connection string to separate it from the array of options
[08:50:31] <nevan> okay
[08:50:35] <Gargoyle> But that's just a shot in the dark
[08:50:48] <nevan> well anything that works :-)
[08:51:36] <nevan> ok i have one mongo specifig question pertaining to sharding...may i
[08:51:54] <Gargoyle> yup
[08:55:04] <nevan> suddenly our mongo stops to respond and every system resource is under utilized
[08:55:13] <nevan> has been happening frequently
[08:55:50] <nevan> no error whatsoever in logs...restarting instances solves the problem version 2.4.9
[08:55:58] <Gargoyle> nevan: Dunno about that - but hang around, someone else might.
[08:56:04] <nevan> k
[08:56:12] <Gargoyle> nevan: Can I send you a PM ?
[08:56:17] <nevan> and can we monitor replication lag
[08:56:18] <nevan> yes
[08:58:04] <Gargoyle> rs.status() will tell you current replication status. And there's a free service from mongodb.org called MMS which can give you nice graphs on all sorts of things. :)
[08:58:35] <nevan> i am using that..but its kind of cryptic as which ones are important and critical ?
[09:01:33] <Gargoyle> Time for some hot chocolate! laters...
[11:15:22] <KrzyStar> joannac: yes, it seems like disabling MPROTECT for the mongo binary fixed it.
[11:15:24] <KrzyStar> Thanks!
[11:32:01] <G1eb> hello, strange thing, my documents have fields that are nested docs and the key is a url
[11:32:32] <G1eb> I can lookup the doc using the _id field just fine but if I try that url I get nothing.
[11:32:38] <G1eb> any idea what this could be
[11:58:32] <Kerm1t> hi, anybody home?
[12:16:56] <nevan> need some information on upgrading to mongo 2.6 from 2.4
[12:17:33] <nevan> i have some field name starting with "$" which is not accecpted by new mongo2.6 ....what can be the most viable solution to this ...any idea
[12:17:34] <nevan> ?
[12:23:30] <ajph> nevan: even in 2.4 You can use any (UTF8) character in the field name which aren't special (contains ".", or starts with "$").
[12:33:34] <radixo> hello guys.. I am trying to follow the http://docs.mongodb.org/manual/tutorial/enable-authentication/ but when I arrive to step "2" (Connect to the MongoDB instance via the localhost exception) I get this error: 2014-05-29T12:27:33.564+0000 Error: couldn't connect to server localhost:27017 (127.0.0.1), connection attempt failed at src/mongo/shell/mongo.js:148
[12:35:20] <radixo> someone could help?
[12:37:31] <nevan> @ajph we have such fields in current db (2.4) but to port it to 2.6 which restricts this
[12:37:39] <nevan> *how
[12:39:58] <ajph> nevan: just because it works doesn't mean you should do it - http://docs.mongodb.org/v2.4/reference/limits/#Restrictions-on-Field-Names
[12:42:04] <ajph> radixo: doesn't look like an auth error. are you sure the service is up?
[12:44:23] <radixo> ajph: I think so
[12:44:33] <radixo> let me certificate.
[12:46:59] <radixo> ajph: no.. it is not!!
[12:54:28] <tmssgrdn> Hi, I am very new to MongoDB and nosql in general. Is it possible to restrict what goes in a document, or is that not something one would want for MongoDB? More specifically I am thinking of types and "NOT NULL" like restrictions.
[12:54:52] <tmssgrdn> s/one would want/one would not want/
[12:55:38] <tmssgrdn> I ... writing. Sorry
[12:58:54] <cheeser> there is no schema validation in mongo, no.
[13:27:41] <radixo> I found the error.. I am not getting right mongod.conf with authorization
[13:49:55] <inad922> hello
[13:50:33] <inad922> How can I set the value of a field in an update call with pymongo if I want to base it on another field in the same object?
[13:54:33] <radixo> whu the tutorial for authentication does not work???
[13:59:32] <ajph> radixo?
[14:07:03] <radixo> ajph: it is not working.. now that i created the user.. I can't log in database
[14:07:05] <radixo> :(
[14:09:49] <ajph> radixo: are you authenticating to the 'admin' database?
[14:10:00] <ajph> mongo -host localhost -u blah -p bleh admin
[14:10:05] <ajph> or something like that
[14:11:08] <radixo> ajph: it was that..
[14:11:20] <radixo> now i think i found what i want
[14:11:44] <radixo> roles: ["root"]
[14:12:17] <radixo> can I do that to the user that I have just created?
[14:14:38] <ajph> radixo: you can
[14:14:44] <ajph> what roles does your new user have so far?
[14:16:46] <tmssgrdn> cheeser: thanks.
[14:17:16] <cheeser> sure
[14:18:04] <radixo> ajph: userAdminAnyDatabase on db admin
[14:19:49] <ajph> radixo: do you get an auth error when connecting?
[14:20:50] <radixo> ajph:
[14:20:52] <radixo> ajph: yes
[14:21:11] <radixo> ajph: Error while trying to show server startup warnings: not authorized on admin to e xecute command { getLog: "startupWarnings" }
[14:31:37] <radixo> ajph: I got it..
[15:03:11] <revoohc> In MongoDB 2.2.4, how do I see what the active running server config is?
[15:15:59] <radixo> hello guys.. How can I migrate the server? can I use replication for that?
[15:23:23] <freeone3000> Is there a way for db.copyDatabase to report progress?
[15:42:39] <dsirijus> a question from a newbie - can i have an Object inside a Document without using another Document via ObjectID?
[15:43:14] <Derick> uh?
[15:43:21] <Derick> objectids are nothing special
[15:44:10] <dsirijus> i mean, can a document be {this:String, that:{something:"nothing"}} without 'that' being ObjectID?
[15:44:20] <Derick> sure
[15:44:46] <dsirijus> i'm asking cuz some list of types i've found didn't include Object
[15:45:23] <dsirijus> String, Number, Date, Buffer, Boolean, Mixed, ObjectId, Array
[15:45:30] <dsirijus> or is that Mixed what i'm talking about?
[15:45:36] <Derick> hmm, maybe
[15:45:48] <dsirijus> purfect. thanks!
[15:50:35] <dsirijus> yeh, the list was incomplete. found a complete one
[15:50:50] <saml> dsirijus, you can't have docs like {[]:1}
[15:51:11] <saml> key can be int or string
[15:51:28] <saml> i mean, key can be string only
[16:00:14] <modcure> when setting the write concern in mongodb to knowledge the write... this knowledgement is only agreeing to the face that the record was commited in memory and not to the data files correct?
[16:00:59] <saml> modcure, http://docs.mongodb.org/manual/core/write-concern/#write-concern-acknowledged
[16:02:43] <Dogevo_> is it reasonable to assume that 'a collection' may contain hundreds of millions of 'small' documents per shard? And allocated memory is a larger determinant to performance than the number of docments per collection??
[16:03:42] <saml> what kind of performance? read performance?
[16:03:53] <Dogevo_> yes heavily read performance
[16:04:00] <saml> if you are scanning many small documents, it'll be slower than scanning few large documents
[16:04:23] <modcure> saml, it seems the write concern only updates the memory data and not the database but the journal write concern commits the record to disk. is this accurate?
[16:04:31] <Dogevo_> yes, but regardless we'd be scanning many sub documents in larger documents
[16:05:01] <saml> oh right. i'd do measurements
[16:06:23] <saml> if you kill mongod right after getting write response with acknowledged write concern, data will be written to disk. i think
[16:06:38] <saml> maybe not. test and blog about it
[16:06:43] <saml> easy way to get rich
[16:07:12] <modcure> i think it only writes to ram.. if it was written to the data files on disk then whats the point about having a journal file
[16:07:26] <modcure> i will play with it
[16:07:32] <saml> let us know
[16:07:39] <modcure> im no pro like you :)
[16:07:59] <saml> no you pro
[16:09:28] <cheeser> there are different levels of write concerns: http://docs.mongodb.org/manual/core/write-concern/
[16:09:33] <saml> http://api.mongodb.org/java/current/com/mongodb/WriteConcern.html#FSYNCED
[16:09:57] <dsirijus> saml, ok. yes, understood
[16:10:49] <dsirijus> a premature optimization question - i have a certain object in user document, over which i'll probably need to iterate very frequently (a second or few)...
[16:10:56] <dsirijus> should i split that in separate collection?
[16:12:13] <saml> http://techidiocy.com/types-write-concern-mongodb-performance-vs-persistence/ modcure
[16:13:47] <saml> dsirijus, no. why separate collection?
[16:13:59] <saml> is the object repeated in multiple docs?
[16:14:35] <dsirijus> well, i'm new to databases in general, so i might reformulate question to something i know i want
[16:15:32] <dsirijus> so, we have a value for each user that grows each Y seconds
[16:15:59] <saml> an array?
[16:16:00] <dsirijus> it's irrelevant for users not currently logged in (though it needs to be correct value when he gets back in)
[16:16:46] <dsirijus> but, online users request that value very frequently in session (say, every half a minute or so, the frontend can simulate it growing in-between the "syncs")
[16:17:28] <dsirijus> we're not sure what bit should be put in database when exactly
[16:17:49] <dsirijus> distribution of that logic in between frontend/backend/db is a bit fuzzy
[16:18:16] <saml> no idea what that is
[16:18:43] <dsirijus> yeh, i better formulate the issue in my head first
[16:19:03] <Dogevo_> that's less a mongodb concern and more a point about your own data design I assume
[16:19:42] <dsirijus> Dogevo_: yes. but it touches mongo at one end
[16:19:56] <dsirijus> it's not appropriate question to this channel, there we could agree :)
[16:19:58] <Dogevo_> I take it you'd have the same concern regardless of your choice of persistence
[16:20:43] <saml> what's your web site?
[16:25:51] <dsirijus> saml: my? it's a game in development.
[16:26:07] <saml> oh i see
[16:26:17] <saml> so users are gamers?
[16:26:34] <saml> waht's that data that's being read/written frequently?
[16:28:42] <Dogevo_> some of that data might fit in the appropriately volatile category
[16:30:16] <dsirijus> saml, we've solved it
[16:30:18] <dsirijus> lol
[16:30:25] <dsirijus> and yes, it's a database solution really
[16:30:36] <dsirijus> just a moment, and i'll explain
[16:30:58] <Dogevo_> What's a recommended strategy people have for dealing with documents that could frequently extend beyond the document size limit?
[16:31:15] <dsirijus> ok, there's this energy, in theory on high level players that value updates almost every second....
[16:31:40] <dsirijus> so, in frontend, we've just defined "sync points" where user either wants to display that value, or spend some of it and update it
[16:32:14] <dsirijus> database stores time of the last "sync point" request, and node just calculates the new value (validates if he's spending energy)...
[16:32:17] <dsirijus> and that's it :)
[16:33:11] <dsirijus> i'm still gonna split energy in new collection, i think
[16:33:22] <dsirijus> dunno why, but it seems like a right thing to do :D
[16:35:33] <dsirijus> the visual cue of that value updating at perfect rate (every frame of the game) on frontend is just frontend ticking, hoping someone doesn't play with system clock or memory hacking
[17:17:57] <synth_> hello, i was curious if there's a way to silence this warning? import pymongo produces: /usr/local/lib/python2.7/dist-packages/pymongo-2.6_-py2.7-linux-x86_64.egg/pymongo/thread_util.py:31: UserWarning: libevent version mismatch: system version is '2.0.19-stable' but this gevent is compiled against '2.0.16-stable'
[17:56:26] <saml> synth_, upgrade gevent
[17:56:35] <saml> pip install --upgrade gevent
[17:59:25] <synth_> ok i'll give that a shot
[18:00:02] <dsirijus> can mongo do funky stuff like have a key identifier (in key-value pair) be value from some other collection from some other key?
[18:00:25] <dsirijus> (if that value is a String, of course)
[18:02:42] <dsirijus> say a have a document {_id:ObjectID<1>, key:"value"}. can i create, dynamically, another document that's {_id:ObjectID<2>, value(string from that first document):"whatever"}?
[18:03:50] <dsirijus> or is that stuff to be at application level?
[18:04:13] <saml> application level
[18:05:00] <dsirijus> ok. i apologize for all my inappropriate questions.
[18:07:14] <synth_> saml: http://sprunge.us/HcaD?sh still getting an error when using pymongo :(
[18:07:23] <dsirijus> saml: ok, another one - is array of ObjectIDs a valid type?
[18:07:57] <dsirijus> i.e. {whatever:[ObjectID<1>, ObjectID<2>]}
[18:10:28] <saml> dsirijus, sure
[18:11:22] <saml> synth_, weird. try in virtualenv?
[18:11:34] <dsirijus> this mongo is friggin' awesome
[18:11:43] <synth_> saml, i'm not entirely sure what that is :(
[18:11:58] <saml> you just compiled gevent with libev
[18:12:07] <saml> not sure why pymongo complains about libevent
[18:12:19] <saml> sudo pip install --upgrade pymongo ?
[18:12:23] <saml> try upgrading pymongo?
[18:12:42] <synth_> ok i'll try that
[18:15:08] <synth_> saml, now getting this: http://sprunge.us/UFaG?sh same error but now includes from gevent.lock import BoundedSemaphore as GeventBoundedSemaphore
[18:19:07] <jhuel> hi i have a problem with the c++ driver
[18:19:46] <jhuel> and i can't find a way to not get a compilation error of LNK1104: cannot open file 'mongoclient-gd.obj'
[18:20:02] <jhuel> i have no idea why, all the lib and headers are included
[18:20:25] <jhuel> the mongoclient-gd.lib and dll exist
[19:06:13] <revoohc> anyone now why the journal on one secondary node would be significantly than the journal on master or the other secondary node in a replicaset?
[19:10:36] <Siddharth123> Hello, everyone.
[19:11:25] <Siddharth123> I'm looking for some help with regards to designing my app that uses MongoDB at the back-end.
[19:12:26] <Siddharth123> The questions are particularly design related, I guess. And I'm looking for the best way to store the data in question.
[19:12:37] <Siddharth123> Can I get any help, please?
[19:16:54] <Siddharth123> Anyone?
[19:18:05] <try2bgr8> /server/add -auto -ssl -ssl_verify -ssl_capath /etc/ssl/certs -network Freenode irce.freenode.net 7000
[19:25:41] <bschrock> Hello, I am trying to remove a config server from a sharded replset (that is not actually partitioned) and I get this error: { "ok" : 0, "errmsg" : "Can't remove last shard" }. Does anyone know why?
[19:53:09] <sheki> i have a question about mongo handles $IN queries across shards
[19:53:21] <sheki> i have a $IN query across the _id field .
[19:53:29] <sheki> do all the shards run, it
[19:53:41] <sheki> (my collections are sharded by id)
[19:53:59] <sheki> or mongos intelligently routes part of the $IN array to the respective shards
[19:54:12] <ranman> I could be mistaken but I don't think that's a scatter gather query I think it will only hit the shards it needs to
[20:00:59] <jtreminio> Hi all. I have been experiencing very slow download speeds for mongo through official repos. Is this a known issue?
[20:15:41] <ranman> jtreminio: what's the specific repo / url ?
[20:16:28] <jtreminio> ranman: downloads-distro.mongodb.org
[20:16:40] <ranman> more specific than that?
[20:17:20] <jtreminio> ranman: one second and I'll pastie the apt file contents
[20:17:35] <ranman> kk
[20:44:13] <ngl> nobody home?
[20:54:15] <synth_> D:
[21:22:37] <bdha> Hey folks... I'm trying to enable the httpinterface. I've set httpinterface=true in mongod.conf and restarted. auth=false. When I hit :28017, however, I get prompted for a user/pass.
[21:22:51] <bdha> According to the docs, http/rest interfaces don't actually support auth.
[21:22:56] <bdha> I'm using 2.6.1 and a bit confused. ;-)
[21:32:54] <radixo> why my mongo 2.6.1 has no YAML config file for mongod
[23:06:34] <astropirate> Hi guys
[23:07:46] <astropirate> When I manually run mongod using "sudo mongod" I am able to access my DB from another server on the same network. However, when I run it using a service using "sudo service mongod start" I am not able to. It shows it running when I check its status as well and can use the mongo client with it
[23:07:53] <astropirate> just not access it from the outside
[23:08:17] <astropirate> i installed it by following this guide: http://docs.mongodb.org/manual/tutorial/install-mongodb-on-ubuntu/
[23:13:11] <astropirate> it apears that the mongod service only listens on 127.0.0.1 and not any other address
[23:13:23] <astropirate> but when it's not a service, it will listen on any address
[23:17:17] <astropirate> AHHH
[23:17:25] <astropirate> found it, had to comment out line one /etc/mongod.conf
[23:21:45] <mbenv> what was the one line that caused the problem?
[23:24:15] <daidoji> hello, for those using pymongo, is there any way to recover all of the operations from the BulkOperationBuilder on exception?
[23:24:45] <daidoji> ie) insert, insert_malformed, insert, execute
[23:24:59] <daidoji> can I print out all the insert ops in order to review in the logs which records had trouble?