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> > >
