Thanks guys. I can live with that. That's better than the other plan I was hatching to delete the db and recreating it :) I will try it the next time I get a chance to shut down CouchDB and let you know if it worked.
On Thu, Apr 22, 2010 at 3:03 PM, Dave Ray <[email protected]> wrote: > Adam is right. If you look in your db folder, you'll see two files, > "mydb.couch" and "mydb.couch.compact" (or something like that). I > think CouchDB creates the compacted file and then tries to replace the > original database with it, but fails due to Windows restrictions on > fiddling with open files. FWIW, you can shutdown CouchDB and manually > do the replace and you'll have a compacted database. > > Dave > > On Thu, Apr 22, 2010 at 3:56 PM, Adam Kocoloski <[email protected]> > wrote: > > Hi Naren, I'm not a Windows expert, but I believe compaction is broken on > Windows because we try to rename an open file. Regards, > > > > Adam > > > > On Apr 22, 2010, at 3:55 PM, naren wrote: > > > >> I am using 0.10 on Windows and tried to do a 'compact database' from > Sofa. I > >> got the following error message on the CouchDB window. I am lost for an > >> explanation of what may be happening. Any help is much appreciated. > >> > >> Thanks > >> Naren > >> > >> ================ > >> > >> 1> [info] [<0.2312.24>] Starting compaction for db "mydatabase" > >> 1> [info] [<0.26559.24>] 10.0.39.177 - - 'POST' /mydatabase/_compact 202 > >> 1> [error] [<0.2312.24>] ** Generic server <0.2312.24> terminating > >> ** Last message in was {'$gen_cast', > >> {compact_done, > >> > >> "../var/lib/couchdb/mydatabase.couch.compact"} > >> } > >> ** When Server state == {db,<0.2311.24>,<0.2312.24>,<0.26565.24>, > >> > <<"1271954425451970">>,<0.2309.24>,<0.2314.24>, > >> {db_header,4,508350,0, > >> {4253011781,{33710,17864}}, > >> {4253014027,51574}, > >> nil,0,nil,nil,1000}, > >> 508350, > >> {btree,<0.2309.24>, > >> {4253011781,{33710,17864}}, > >> #Fun<couch_db_updater.8.117532479>, > >> #Fun<couch_db_updater.9.105507025>, > >> #Fun<couch_db_updater.7.32442936>, > >> #Fun<couch_db_updater.10.43662179>}, > >> {btree,<0.2309.24>, > >> {4253014027,51574}, > >> #Fun<couch_db_updater.11.41695917>, > >> #Fun<couch_db_updater.12.6934644>, > >> #Fun<couch_btree.5.124754102>, > >> #Fun<couch_db_updater.13.28245598>}, > >> {btree,<0.2309.24>,nil, > >> #Fun<couch_btree.0.83553141>, > >> #Fun<couch_btree.1.30790806>, > >> #Fun<couch_btree.2.124754102>,nil}, > >> 508350,<<"mydatabase">>, > >> "../var/lib/couchdb/mydatabase.couch",[],[], > >> nil, > >> {user_ctx,null,[]}, > >> nil,1000, > >> [before_header,after_header,on_file_open]} > >> ** Reason for termination == > >> ** {{badmatch,{error,eacces}}, > >> [{couch_db_updater,handle_cast,2}, > >> {gen_server,handle_msg,5}, > >> {proc_lib,init_p_do_apply,3}]} > >> > >> 1> > >> =ERROR REPORT==== 22-Apr-2010::14:48:00 === > >> ** Generic server <0.2312.24> terminating > >> ** Last message in was {'$gen_cast', > >> {compact_done, > >> > >> "../var/lib/couchdb/mydatabase.couch.compact"} > >> } > >> ** When Server state == {db,<0.2311.24>,<0.2312.24>,<0.26565.24>, > >> > <<"1271954425451970">>,<0.2309.24>,<0.2314.24>, > >> {db_header,4,508350,0, > >> {4253011781,{33710,17864}}, > >> {4253014027,51574}, > >> nil,0,nil,nil,1000}, > >> 508350, > >> {btree,<0.2309.24>, > >> {4253011781,{33710,17864}}, > >> #Fun<couch_db_updater.8.117532479>, > >> #Fun<couch_db_updater.9.105507025>, > >> #Fun<couch_db_updater.7.32442936>, > >> #Fun<couch_db_updater.10.43662179>}, > >> {btree,<0.2309.24>, > >> {4253014027,51574}, > >> #Fun<couch_db_updater.11.41695917>, > >> #Fun<couch_db_updater.12.6934644>, > >> #Fun<couch_btree.5.124754102>, > >> #Fun<couch_db_updater.13.28245598>}, > >> {btree,<0.2309.24>,nil, > >> #Fun<couch_btree.0.83553141>, > >> #Fun<couch_btree.1.30790806>, > >> #Fun<couch_btree.2.124754102>,nil}, > >> 508350,<<"mydatabase">>, > >> "../var/lib/couchdb/mydatabase.couch",[],[], > >> nil, > >> {user_ctx,null,[]}, > >> nil,1000, > >> [before_header,after_header,on_file_open]} > >> ** Reason for termination == > >> ** {{badmatch,{error,eacces}}, > >> [{couch_db_updater,handle_cast,2}, > >> {gen_server,handle_msg,5}, > >> {proc_lib,init_p_do_apply,3}]} > >> 1> [error] [<0.2312.24>] {error_report,<0.24.0>, > >> {<0.2312.24>,crash_report, > >> [[{initial_call,{couch_db_updater,init,['Argument__1']}}, > >> {pid,<0.2312.24>}, > >> {registered_name,[]}, > >> {error_info,{exit,{{badmatch,{error,eacces}}, > >> [{couch_db_updater,handle_cast,2}, > >> {gen_server,handle_msg,5}, > >> {proc_lib,init_p_do_apply,3}]}, > >> [{gen_server,terminate,6}, > >> {proc_lib,init_p_do_apply,3}]}}, > >> > >> {ancestors,[<0.2311.24>,couch_server,couch_primary_services, > >> couch_server_sup,<0.1.0>]}, > >> {messages,[]}, > >> {links,[<0.2311.24>]}, > >> {dictionary,[]}, > >> {trap_exit,false}, > >> {status,running}, > >> {heap_size,1597}, > >> {stack_size,24}, > >> {reductions,25515552}], > >> []]}} > >> 1> [info] [<0.3052.24>] Shutting down view group server, monitored db is > >> closing > >> . > >> 1> > > > > >
