adyshimony commented on issue #796: CouchDB Error - No DB shards could be opened URL: https://github.com/apache/couchdb/issues/796#issuecomment-370187107 ***Solved - scroll down to read solution** Hi, I have the same issue with 60 dbs, running on a local computer, each db has 4 views, up to 2 millions docs for every DB. only the last db is being updated. I am getting emfile error, and shard db error, and errors are changing according to the query range. Sometimes only one db returns error, sometimes multiple. https://gist.github.com/adyshimony/d5b9fec95a7ec7544095cef398960c5c I set up the config exactly as written here http://docs.couchdb.org/en/stable/maintenance/performance.html#system-resource-limits Checking ulimit -n returns 64000 Also set max_dbs_open is 15k Also added [couchdb] update_lru_on_read = false But when checking for service limits: ??beam.smp(1532)???couchjs(3546)???{couchjs}(3554) ? ??couchjs(3547)???{couchjs}(3555) ? ??couchjs(3548)???{couchjs}(3553) cat /proc/3546/limits I am getting Max open files 1024 For every process in the list, even that I configured this: /etc/systemd/system/couchdb.d/override.conf [Service] LimitNOFILE=64000. **OK solutions found, I am not delete this cause maybe it can help someone.** Add /etc/systemd/system/couchdb.service.d/limits.conf [Service] LimitNOFILE=64000 Fixed the issue with all the other things I mention above. /etc/systemd/system/couchdb.d/override.conf is not enough if working at all.
---------------------------------------------------------------- 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
