sergey-safarov commented on issue #5934: URL: https://github.com/apache/couchdb/issues/5934#issuecomment-4235659772
I just reproduced issue again. For now I have do not deleted all docs from the database. Current 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": 190083335, "external": 657156, "active": 188159324 }, "props": {}, "doc_del_count": 1584, "doc_count": 844, "disk_format_version": 8, "compact_running": false, "cluster": { "q": 1, "n": 3, "w": 2, "r": 2 } } ``` On file system empty database use about 250 Mb ``` [user@host bin]$ ls -l /var/lib/couchdb/shards/00000000-ffffffff/test.1768133824.couch -rw-r--r--. 1 couchdb couchdb 190083335 Apr 13 09:06 /var/lib/couchdb/shards/00000000-ffffffff/test.1768133824.couch [user@host bin]$ du -hs /var/lib/couchdb/.shards/00000000-ffffffff/test.1768133824_design 74M /var/lib/couchdb/.shards/00000000-ffffffff/test.1768133824_design ``` If I dump call db content to text file it will take about 800 kb. ``` [user@host bin]$ curl -s 'http://admin:[email protected]:5984/test/_all_docs?include_docs=true&attachments=true' > /tmp/dump.json [user@host bin]$ ls -l /tmp/dump.json -rw-rw-r--. 1 user user 829276 Apr 13 10:19 /tmp/dump.json ``` Could you help troubleshoot why db size on disk more then 190 timer bigger then expected and cannot be compacted. -- 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]
