What version of CouchDB are you running? -Damien
On Aug 11, 2010, at 12:44 PM, Gordon Leland Hempton wrote: > For what it's worth, the only way I was able to fix this was to delete the > database and recreate all of the documents. > > On Fri, Aug 6, 2010 at 10:45 AM, Gordon Leland Hempton > <[email protected]>wrote: > >> Thanks for your responses! >> >> The design document for this database is trivial. There is only the single >> view which emits a single property as the key: >> >> { >> "_id": "_design/Trademark", >> "_rev": "6-ecab7bf9158e188ab2c39d37c4a1fb4d", >> "views": { >> "by_filingDate": { >> "map": "function(doc) { emit(doc.filingDate, null); }" >> } >> } >> } >> >> >> This exact same setup works on a smaller scale of data on our development >> boxes. >> >> >> I have also ensured that ldconfig was run. I am actually using the script >> provided on the wiki to update the xulrunner version. Futhermore, before I >> fixed xulrunner, NONE of my views were working, however now views are >> working fine on all databases exect ones of large size. >> >> >> Thanks, >> >> Gordon >> >> >> On Thu, Aug 5, 2010 at 1:25 PM, David Caylor <[email protected]> wrote: >> >> Did you run ldconfig after you set the xulrunner settings? I did that to >>> myself last time I updated a Ubuntu box where I'd installed couchdb from >>> source. I updated the xulrunner.conf, but forgot to run ldconfig, and got >>> pretty much what you are describing. >>> >>> David Caylor >>> >>> >>> On Wed, Aug 4, 2010 at 4:07 PM, Gordon Leland Hempton <[email protected] >>>> wrote: >>> >>>> After looking at the logs, it looks pretty bad: >>>> >>>> [Wed, 04 Aug 2010 22:57:28 GMT] [info] [<0.12883.0>] 127.0.0.1 - - 'GET' >>>> >>>> >>> /trademark/_design/Trademark/_view/by_filingDate?limit=10&stale=ok&descending=true&include_docs=true >>>> 200 >>>> >>>> [Wed, 04 Aug 2010 22:57:52 GMT] [error] [emulator] Error in process >>>> <0.12957.0> with exit value: >>> {badarg,[{erlang,binary_to_term,[<<1885695232 >>>> >>>> >>> bytes>>]},{couch_file,pread_term,2},{couch_db,make_doc,5},{couch_db,open_doc_int,3},{couch_view_updater,load_doc,5},{couch_view_updater,'-update/2-fun-2-',8},{couch_btree,stream_kv_node2,8... >>>> >>>> Anyone know where to start? >>>> >>>> I am running Ubuntu 10.04 server with couchdb 1.0 installed from source. >>> I >>>> have made sure the xulrunner settings are correct. >>>> >>>> Thanks, >>>> >>>> On Wed, Aug 4, 2010 at 12:18 PM, Gordon Leland Hempton >>>> <[email protected]>wrote: >>>> >>>>> I am working with a database of ~10 mil docs and 30GB size. I am >>> trying >>>> to >>>>> build a view consisting of a single field as the key and a null >>> document. >>>>> >>>>> After creating the view and trying to access it, the couchdb beam.smp >>>>> command eventually goes up to 12.3GB virtual memory and uses 3.7GB of >>>>> physical memory. Memory is clearly the bottleneck as the CPU usage is >>>> around >>>>> 5-15%. My system only has 4GB of memory so naturally all this paging >>> is >>>>> slowing everything down to a crawl. >>>>> >>>>> After a few minutes this usage will go back down, but it will get to >>> the >>>>> same levels every time I access the view (which is still building and >>> has >>>>> been for 12 hours). >>>>> >>>>> Is this normal? How can I improve this? >>>>> >>>>> -- >>>>> Gordon L. Hempton >>>>> http://componentlab.com >>>>> http://hempton.com >>>>> >>>> >>>> >>>> >>>> -- >>>> Gordon L. Hempton >>>> http://componentlab.com >>>> http://hempton.com >>>> >>> >> >> >> >> -- >> Gordon L. Hempton >> http://componentlab.com >> http://hempton.com >> > > > > -- > Gordon L. Hempton > http://componentlab.com > http://hempton.com
