akircher opened a new issue #1579: Autocompaction never triggered in Couch v2.2 URL: https://github.com/apache/couchdb/issues/1579 <!--- Provide a general summary of the issue in the Title above --> ## Expected Behavior <!--- If you're describing a bug, tell us what should happen --> Autocompaction is not being triggered even though the db and views are above the threshold % specified in the config and there seems to be enough diskspace: ~30% used on a 150GB drive. No error is provided in the log file. Triggering compaction manually with curl works as expected. My compaction settings are currently but I have tried many variations of these ``` compaction_daemon | check_interval | 30 | compaction_daemon | check_interval | min_file_size | 13000 compactions | _default | [{db_fragmentation, "20%"}, {view_fragmentation, "20%"}] ``` My installation has 5 databases. `/_dbs`: ``` {"db_name":"_dbs","update_seq":"7-g2wAAAABaANkABFjb3VjaGRiQDEyNy4wLjAuMWwAAAACYQBuBAD_____amEHag","sizes":{"file":12479,"external":8365,"active":3004},"purge_seq":0,"other":{"data_size":8365},"doc_del_count":0,"doc_count":7,"disk_size":12479,"disk_format_version":6,"data_size":3004,"compact_running":false,"cluster":{"q":1,"n":1,"w":1,"r":1},"instance_start_time":"0"} ``` The largest db is `transasction`: `/transaction`: (note that I just ran compaction manually on this and so it no longer needs an autocompaction) ``` {"db_name":"transaction","update_seq":"913507-g1AAAAFreJzLYWBg4MhgTmEQTM4vTc5ISXIwNDLXMwBCwxygFFMiQ5L8____s5IYGPcZ41GXpAAkk-yhSvf441PqAFIaD1W6owSf0gSQ0nqo0kPX8SjNYwGSDA1ACqh6Pkj5ri0ElS-AKN8PUr4_mqDyAxDl90HKD2wjqPwBRDnY7fsvZgEAVlBo7Q","sizes":{"file":260130402,"external":218239373,"active":259627940},"purge_seq":0,"other":{"data_size":218239373},"doc_del_count":4816,"doc_count":273983,"disk_size":260130402,"disk_format_version":6,"data_size":259627940,"compact_running":false,"cluster":{"q":8,"n":1,"w":1,"r":1},"instance_start_time":"0"} ``` I have about 40 views each within their own ddoc. Here is one of the 40 views that are not getting compacting `/transaction/_design/inventory.value-by-generic/_info` ``` {"name":"inventory.value-by-generic","view_index":{"updates_pending":{"minimum":0,"preferred":0,"total":0},"waiting_commit":false,"waiting_clients":0,"updater_running":false,"update_seq":913507,"sizes":{"file":2205017462,"external":258446339,"active":217542472},"signature":"e31ca84e6148d04f91b6fff3a5f3c329","purge_seq":0,"language":"javascript","disk_size":2205017462,"data_size":258446339,"compact_running":false}} ``` I have been calculating fragmentation as (2205017462-258446339)/2205017462 = 88% ## Possible Solution <!--- Not obligatory, but suggest a fix/reason for the bug, --> <!--- or ideas how to implement the addition or change --> I am thinking it is a bug with 2.x Things seemed to be working on 1.7. Just a guess but my view names do contain a `.` which might be getting confused with the how shards are identified in the compaction syntax. ## Context <!--- How has this issue affected you? What are you trying to accomplish? --> <!--- Providing context helps us come up with a solution that is most useful in the real world --> I have to run compaction manually on all databases and views. ## Your Environment <!--- Include as many relevant details about the environment you experienced the bug in --> * Version used: * Browser Name and version: * Operating System and version (desktop or mobile): * Link to your project: Ubuntu 16.04. Couch 2.2. Node 10
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services
