sergey-safarov commented on issue #5934: URL: https://github.com/apache/couchdb/issues/5934#issuecomment-4238120415
> please manually invoke compaction for the database, confirm this was successfully completed, and report the sizes again, then we can investigate. Here is results ``` [user@host bin]# curl -X POST \ > -H "Content-Type: application/json" \ > 'http://admin:[email protected]:5984/test/_compact' {"ok":true} [user@host bin]# curl -s 'http://admin:[email protected]:5984/test' | jq { "instance_start_time": "1768133824", "db_name": "test", "purge_seq": "6101027-g2wAAAABaANkAB9jb3VjaGRiQGVzcnAtZGIwYS5waC5uZ2E5MTEuY29tbAAAAAJhAG4EAP____9qYgBdGCNq", "update_seq": "12211142-g1AAAABueJzLYWBgYMxgTmGQT84vTc5ISXJILS4q0E1JMkjUK8jQy0tPtDQ01EvOz80BKmRKZMhjYfgPBFkZzEkMu4KP5QJF2c0NjFKMjC0Jm5EFACQiIi8", "sizes": { "file": 190021895, "external": 657156, "active": 188157519 }, "props": {}, "doc_del_count": 1584, "doc_count": 844, "disk_format_version": 8, "compact_running": true, "cluster": { "q": 1, "n": 3, "w": 2, "r": 2 } } ``` > and manually compact all view groups too Here is procedure ```sh # get design docs views=$(curl -s --noproxy '*' 'http://admin:[email protected]:5984/test/_all_docs' | jq -r '.rows | map(.id) | map(select(startswith("_design"))) | .[]') # compact views set -x for view in ${views}; do view_stripped=$(echo "${view}" | sed -e 's|_design/||') curl -X POST \ -H "Content-Type: application/json" \ "http://admin:[email protected]:5984/test/_compact/${view_stripped}"; done ``` After compaction database status ``` [user@host bin]# curl -s http://admin:[email protected]:5984/test/| jq { "instance_start_time": "1768133824", "db_name": "test", "purge_seq": "6101027-g2wAAAABaANkAB9jb3VjaGRiQGVzcnAtZGIwYS5waC5uZ2E5MTEuY29tbAAAAAJhAG4EAP____9qYgBdGCNq", "update_seq": "12211142-g1AAAABueJzLYWBgYMxgTmGQT84vTc5ISXJILS4q0E1JMkjUK8jQy0tPtDQ01EvOz80BKmRKZMhjYfgPBFkZzEkMu4KP5QJF2c0NjFKMjC0Jm5EFACQiIi8", "sizes": { "file": 190021895, "external": 657156, "active": 188157519 }, "props": {}, "doc_del_count": 1584, "doc_count": 844, "disk_format_version": 8, "compact_running": false, "cluster": { "q": 1, "n": 3, "w": 2, "r": 2 } } ``` For it looks like after compaction issue still here. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
