nickva opened a new issue, #5346: URL: https://github.com/apache/couchdb/issues/5346
Because they do not reduce `active` size, smoosh auto-compactor won't enqueue them as their active/file ratio won't change much. We just deleted bodies erroneously counted as `active` so not surprising we didn't account for attachment there either. https://github.com/apache/couchdb/pull/4264 To reproduce it. Created a doc, then updated it with an attachment of 11MB ``` http $DB/db/doc { "_attachments": { "att1": { "content_type": "application/octet-stream", "digest": "md5-ZawHXI3TpIB1jONqVTLNSQ==", "length": 11534336, "revpos": 2, "stub": true } }, "_id": "doc", "_rev": "2-00158c3e5f64ad3afd75bfa5f24c0c93", "x": "yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy" } http $DB/db { "cluster": { "n": 1, "q": 1, "r": 1, "w": 1 }, "compact_running": false, "db_name": "db", "disk_format_version": 8, "doc_count": 1, "doc_del_count": 0, "instance_start_time": "1732722247", "props": {}, "purge_seq": "0-g2wAAAABaANkAA9ub2RlMUAxMjcuMC4wLjFsAAAAAmEAbgQA_____2phAGo", "sizes": { "active": 11556408, "external": 11534860, "file": 11579592 }, "update_seq": "2-g1AAAABLeJzLYWBgYMxgTmHgz8tPSTV0MDQy1zMAQsMcoARTIkMeC8N_IMjKYE5kygUKsScbWKSamVtiasgCAKOKEoA" } ``` Deleted the doc ``` http delete $DB/db/doc'?rev=2-00158c3e5f64ad3afd75bfa5f24c0c93' http $DB/db { "cluster": { "n": 1, "q": 1, "r": 1, "w": 1 }, "compact_running": false, "db_name": "db", "disk_format_version": 8, "doc_count": 0, "doc_del_count": 1, "instance_start_time": "1732722247", "props": {}, "purge_seq": "0-g2wAAAABaANkAA9ub2RlMUAxMjcuMC4wLjFsAAAAAmEAbgQA_____2phAGo", "sizes": { "active": 11549165, "external": 11534338, "file": 11595976 }, "update_seq": "3-g1AAAABLeJzLYWBgYMxgTmHgz8tPSTV0MDQy1zMAQsMcoARTIkMeC8N_IMjKYE5kzgUKsScbWKSamVtiasgCAKOqEoE" } ``` Active stays up at 11MB After compacting manually ``` http $DB/db { "cluster": { "n": 1, "q": 1, "r": 1, "w": 1 }, "compact_running": false, "db_name": "db", "disk_format_version": 8, "doc_count": 0, "doc_del_count": 1, "instance_start_time": "1732722247", "props": {}, "purge_seq": "0-g2wAAAABaANkAA9ub2RlMUAxMjcuMC4wLjFsAAAAAmEAbgQA_____2phAGo", "sizes": { "active": 324, "external": 2, "file": 16575 }, "update_seq": "3-g1AAAABLeJzLYWBgYMxgTmHgz8tPSTV0MDQy1zMAQsMcoARTIkMeC8N_IMjKYE5kzgUKsScbWKSamVtiasgCAKOqEoE" } ``` Thanks for @rnewson and the cloudant ops team for discovering it! -- 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]
