<!--- 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
[ Full content available at: https://github.com/apache/couchdb/issues/1579 ]
This message was relayed via gitbox.apache.org for [email protected]