Log file Viewer
#mongodb logs for Wednesday the 26th of August, 2015
[02:02:09] <aaxxo> Can I request some help please? I have a query and want to pass output as json using express, but I am stuck with the correct syntax http://pastebin.com/fLBcpgsQ
[08:07:14] <joannac> synthetec: http://docs.mongodb.org/manual/reference/program/mongodump/#cmdoption--db
[08:07:30] <joannac> " If you do not specify a database, mongodump copies all databases in this instance into the dump files."
[08:22:16] <synthetec> Failed global initialization: BadValue Invalid or no user locale set. Please ensure LANG and/or LC_* environment vari
[08:47:41] <SmitySmiter> hey guys, I'm on a mac, yosemite, have mongodb installed and have been using it for a while before a few days
[08:47:57] <SmitySmiter> now, this is what happens when I run "mongo" in the terminal, http://paste.ubuntu.com/12197831/
[10:32:35] <student3102> I am trying to use distinct command on 3.0 driver but no luck, can someone give me example how to get results of a single column to array
[10:41:41] <student3102> can someone please give me example of distinct command on 3.0 driver in java, I am having troubles with Tresult(got no idea what it stands for)
[10:51:13] <darius93> student3102, you could provide some code that you currently have and we could help you base on that
[11:20:02] <student3102> it's not working.. and no I am not new in Java, I was just loosing my head over this xD
[11:22:27] <student3102> exception : readString can only be called when CurrentBSONType is STRING, not when CurrentBSONType is NULL.
[11:23:55] <cheeser> if you makes states a DistinctIterable instead, you can call filter() to remove those from the results
[11:25:14] <student3102> yeah, probably, tried with another field that has no null in it, and it worked, I will try now with distnct
[11:25:53] <charnel> Hi I want to get all the records in a collection and update to 2d box . Like getting lat and long and create a [lat, lng] what is the best way ?
[11:27:18] <cheeser> you want to add that array to the documents based on other fields in the docs, charnel?
[11:31:39] <cheeser> you'll have to loop through the docs and update them in your app before writing them back.
[11:33:04] <charnel> cheeser, I was coding a php script then wondered if there is a better way to do it in MongoDb side.
[11:33:38] <charnel> I've found the bulk.find.update but could not make sure if I could pass a function to that or not
[12:17:08] <cheeser> there's a filter() on DistinctIterable. you'd pass in the Document form of that.
[12:57:43] <no-thing_> hello, is it possible to see the progress of syncing from primary to secondary ?
[12:58:26] <kali> no-thing_: the secondary logs will give you a hint. nothing close to a progress bar or an ETA, but at least you can see stuff moving around
[14:23:24] <sandstrom> When using mongoid, is it possible to use a criteria (selecting on properties) before the objects are saved? That would make the code easier to use across both tests and real code (where documents will be persisted)
[14:24:50] <revoohc> Does anyone know if the mongodump output is version safe? In other words, could I mongodump a database today, archive the results, and expect to be able to restore them 2, 5, 10 years in the future?
[14:26:47] <kali> revoohc: well, mongodump is just a bson dump. and so far bson, has being remarquably stable.
[14:27:24] <kali> revoohc: i can not test it, because i have no file from that time around, but i'm pretty sure a dump from 2009 would still load
[15:10:24] <jordonbiondo> Hello, I'm having a strange issue with performance problems across mongoose / mongo. In my code, my query takes about 13 seconds, however, when I log the query mongoose is doing, and run it directly, the same query takes about .3 seconds. Has anyone had a problem like this?
[15:11:44] <jordonbiondo> so: Something.find({simple: 'criteria'}).then(function() {... }) takes 13 seconds. But db.getCollection('Something').find({simple: 'criteria'}) takes .3 seconds
[15:15:12] <StephenLynx> but I would bet it has something to do with the fact it tries to make mongo behave like a relational database.
[15:15:41] <cheeser> i've yet to see anyone but StephenLynx go ballistic at the mention of mongoose, actually.
[15:17:26] <Machske> Does anyone know how to query for $set in the oplog ? => db.oplog.rs.find( { "ns": "test.Position","op": "u", "o": { "$set": { $regex: ".*pos.*"} } }, { "o": 1 } ). This results in "$err" : "Can't canonicalize query: BadValue unknown operator: $set"
[16:08:47] <Doyle> How do you interpret the following currentOp lines? The lower case r indicates a database specific lock against ^ everything?
[16:17:44] <Doyle> The query is operating with database specific read lock, and the DB thundercats is globally locked?
[16:24:51] <jpfarias> I am having to re sync one of my config servers once a day after I added a couple shard servers
[17:05:52] <aricg> Hi, the docs say that for remote auth I need to append the public ip to the confs bind_ip = however the public ip is not avaliable on the machine with ipr its all done with magic
[17:06:42] <aricg> how can I let developers in remotly? this is just for testing right now, only username password auth is required at this time.
[17:21:04] <aricg> StephenLynx: it works over vpn on the 10. private ip (which is avaliable when you ip a on the mongo server)
[17:22:05] <aricg> I can actually get into mongo but with no auth if I just leave out username and password
[17:28:42] <StephenLynx> I don't remember mongo causing a fuss about authentication based on ip, but again, I have never messed too much with authentication
[17:50:51] <aricg> I'm not sure I get this, I just installed a new version of mongo and then created the users. there shouldnt be a mixup..
[18:54:34] <doc_tuna> and can you do deferred writing to mysql, i.e. send a query and proceed to reading your next mongo document without waiting for the callback from sql?
[18:55:42] <doc_tuna> you may not want to let more than x number of callbacks piled up, if things go into sql slower than they come out of mongo
[18:56:22] <doc_tuna> i'm just saying you can skip the mongo->file, file->sql by writing a scrip that reads from mongo and writes to your sql table
[19:00:57] <terminal_echo> i think we are going to use sqlalchemy to create exact model and then write to sql through it
[19:02:37] <geneous> gents, having mucho trouble with connection growth: http://stackoverflow.com/questions/32212027/mongodb-connections-number-growth-over-pools-limit-in-grails-app ... all wise counsel is mucho appreciated
[19:03:34] <terminal_echo> StephenLynx: yeah, what i mean is not maintaining the same id's but the foreign-key relationships that make SQL table reltionships faster
[19:04:01] <terminal_echo> i forget what they call that, like 100 insert statements at a time instead of one by one
[19:50:32] <sewardrobert> We are using mongodb with wiredTiger, however mongo will not restart after a server reboot and software upgrade. The boot fails with a backtrace. Any advice?
[19:51:28] <jpfarias> I am having to re sync one of my config servers once a day after I added a couple shard servers
[19:52:27] <jpfarias> I thought there was a distributed lock or something like that to make sure they were all consistent
[19:54:46] <jpfarias> anyway the shards are almost done balancing so I dont think it will be a big issue
[19:56:16] <doc_tuna> jpfarias: physical proximity wont do anything if the network is saturated, but you dont think it is?
[19:57:14] <doc_tuna> probably not just pointing out that even a gigabit switch and 2 feet of cat6 can be laggy
[21:05:36] <sewardrobert> We are using mongodb with wiredTiger, however mongo will not restart after a server reboot and software upgrade. The boot fails with a backtrace. Any advice?
[21:08:17] <sewardrobert> Starting mongod with the following command, does not produce any standard out.
[21:08:22] <sewardrobert> /usr/bin/mongod -vvvv --config /etc/mongod.conf --storageEngine wiredTiger --dbpath /var/lib/mongodb-wiredTiger
[21:30:47] <sewardrobert> We are using mongodb with wiredTiger, however mongo will not restart after a server reboot and software upgrade. The boot fails with a backtrace. Any advice?
[22:01:05] <INIT_6_> If I was to move the nmap files off the server as is. Is there a way to come back later and export the information to .json or other format?
[22:30:02] <INIT_6_> mongodump docs say it can't read them anymore. Changed in version 3.0.0: mongodump removed the --dbpath as well as related --directoryperdb and --journal options. You must use mongodump while connected to a mongod instance.
[22:38:29] <sewardrobert> The server is on a virtual machine. I believe the hosting provider bounced or migrated the VM.
[22:39:34] <sewardrobert> Before I noticed that Mongo was down, I also upgraded packages on the server including mongo. Combination of events may have caused the failure?
[22:45:14] <joannac> sewardrobert: can you look back in the logs and see if the mongod came back up on 3.0.5?
[22:55:39] <sewardrobert> It would appear that mongo was up for a long time. 7 months. The VM migration / restart made mongo shutdown (perhaps uncleanly?). Mongo has never successfully restarted as 3.0.4 or 3.0.6 (it's current version).
[22:55:55] <sewardrobert> joannac, It would appear that mongo was up for a long time. 7 months. The VM migration / restart made mongo shutdown (perhaps uncleanly?). Mongo has never successfully restarted as 3.0.4 or 3.0.6 (it's current version).
[23:09:04] <joannac> sewardrobert: so when you upgraded to 3.0.4, you cleanly shut down, and then when you started again with 3.0.4 you got that error?
[23:09:04] <sewardrobert> joannac, This sequence of events is likely. VM was shutdown by hosting provider. Mongo stayed down. We are starting it manually. Mongo was upgraded from 3.0.3 originally to 3.0.5 and then again 3.0.6. 3.0.5 and 3.0.6 versions were unable to reload the "corrupted" wiredTiger database.
[23:11:44] <sewardrobert> Ha! Funny. OK. I will try to spin another virtual on 3.0.3 and see if the DB can be opened.