Thanks for the update. Curious cut-off point!
On 23 January 2013 19:01, Donal Simmie <[email protected]> wrote: > Update: > > I deleted the largest document in the database, which was 14.6 MB and then > re-tried creating views from the js view server and they worked. > > There are a still a number of docs which are 11 MB so the process hang must > occur at some value greater than 11 MB. > > Note: I am using Chrome/Futon to create these views. > > > > On Mon, Jan 21, 2013 at 5:51 PM, Robert Newson <[email protected]> wrote: > >> Nope, the -S parameter has never done what it claims. >> >> B. >> >> On 21 January 2013 12:48, Donal Simmie <[email protected]> wrote: >> > I did try your approach Paul before I saw Robert's follow up and the same >> > thing happened. >> > >> > The error log is here in case sheds any light: >> > >> > http://pastebin.com/nFxU80FG - it doesn't for me ;) >> > >> > This time I was using a simpler emit than the second param being doc and >> > wouldn't generally emit the entire doc but thanks for link to that >> article >> > Dave. >> > >> > This was the view code I used this time: >> > >> > function(doc) { >> > emit(doc.user.screen_name, doc.user.id); >> > } >> > >> > Robert as for the view stack size setting not being a useful setting, it >> is >> > suggested here >> > http://wiki.apache.org/couchdb/Performance#JavaScript_View_Server that >> this >> > can be altered if there a problem in the logs that indicates stack size >> > might be an issue. Is this still valid advice? >> > >> > Thanks for the suggestions. >> > >> > >> > >> > On Mon, Jan 21, 2013 at 5:22 PM, Paul Davis <[email protected] >> >wrote: >> > >> >> Well ain't that a knock in the teeth. Never seen that note before so it >> >> must've been something lots of people were mistaking that API for. >> >> >> >> I've got no idea how to fix this then. >> >> >> >> >> >> On Mon, Jan 21, 2013 at 11:19 AM, Robert Newson <[email protected]> >> >> wrote: >> >> >> >> > Paul, you know that -S doesn't change the stack size just the size of >> >> > stack fragments. It's a useless setting afaict; >> >> > >> >> > from >> >> > >> >> >> https://developer.mozilla.org/en-US/docs/SpiderMonkey/JSAPI_Reference/JS_NewContext >> >> > >> >> > "The stackchunksize parameter does not control the JavaScript stack >> >> > size. (The JSAPI does not provide a way to adjust the stack depth >> >> > limit.) Passing a large number forstackchunksize is a mistake." >> >> > >> >> > B. >> >> > >> >> > On 21 January 2013 11:39, Paul Davis <[email protected]> >> >> wrote: >> >> > > Sounds like a stack size issue. Try setting -S to something largish >> >> > > (10485760 or so) on the couchjs command line in your default.ini >> >> > > >> >> > > >> >> > > On Mon, Jan 21, 2013 at 10:27 AM, Donal Simmie < >> [email protected] >> >> > >wrote: >> >> > > >> >> > >> As an update I have tried numerous approaches to attempt to >> >> > fix/workaround >> >> > >> this problem: >> >> > >> >> >> > >> 1. Compacting the database. >> >> > >> 2. Replicating to a local copy of the DB and retrying view >> creation. >> >> > >> 3. Dumping DB contents to JSON with dump.py and loading into >> another >> >> DB >> >> > >> with load.py >> >> > >> >> >> > >> None of these worked. >> >> > >> >> >> > >> After downloading the couchdb-python library I added the python >> view >> >> > server >> >> > >> to Futon and ran view code in python and this does fix the problem. >> >> > >> >> >> > >> So if the problem is with the javascript view server, does this >> help >> >> in >> >> > >> identifying what the issue might be and how I could fix it? >> >> > >> >> >> > >> E.g. >> >> > >> >> >> > >> Bad entry in config file, >> >> > >> Corrupt document(s), >> >> > >> Something else?? >> >> > >> >> >> > >> Thanks >> >> > >> >> >> > >> >> >> > >> >> >> > >> >> >> > >> >> >> > >> On Thu, Jan 17, 2013 at 2:59 PM, Donal Simmie < >> [email protected] >> >> > >> >wrote: >> >> > >> >> >> > >> > I am getting an os error on view creation for a certain database. >> >> All >> >> > my >> >> > >> > views for other databases are working but I cannot create any on >> >> this >> >> > one >> >> > >> > without it failing. >> >> > >> > >> >> > >> > The error message is: os_process_error,{exit_status,0}} >> >> > >> > >> >> > >> > I was trying a proper view but even this basic one is broken: >> >> > >> > >> >> > >> > function(doc) { >> >> > >> > emit(1, doc); >> >> > >> > } >> >> > >> > >> >> > >> > Note: >> >> > >> > I have been using Futon for view creation. >> >> > >> > The all documents view is fine and documents themselves can be >> >> viewed. >> >> > >> > I altered the default configuration file by adding a compactions >> >> > section >> >> > >> > with the following key/value pair: -default: [{db_fragmentation, >> >> > "70%"}, >> >> > >> > {view_fragmentation, "60%"}, {from, "23:00"}, {to, "04:00"}]. >> >> > >> > The DB in question contains 3.6 GB of data. >> >> > >> > >> >> > >> > Version: 1.2 >> >> > >> > Os: Mac OS X 10.8.2 >> >> > >> > >> >> > >> > The trace in the log file is available here: >> >> > >> http://pastebin.com/AdrJ6jeB >> >> > >> > >> >> > >> > Any suggestions please? >> >> > >> > >> >> > >> >> >> > >> >> >>
