← Back to team overview

maria-discuss team mailing list archive

Re: connection handling is buggy (HY000/2002): Resource temporarily unavailable)


looks more like similar to https://www.percona.com/blog/2009/11/20/rare-evil-mysql-bug/ which is really old but who knows

Am 17.07.2017 um 14:48 schrieb Reindl Harald:
Am 17.07.2017 um 14:39 schrieb Reinis Rozitis:
mysqld as well as httpd had "LimitNOFILE=infinity" in the
systemd-unit, the connection type is unix socket, so that all should
not be a problem on a i7-3770 CPU @ 3.40GHz with 32 GB RAM

Could it be you are hitting this https://github.com/systemd/systemd/issues/3211 (also https://news.ycombinator.com/item?id=11675129 ) - besides the open files limit some systemd versions (before it was bumped to a relative value) are screwed with the default 512 tasks limit.

for sure not, i read systemd news and adjust my services


[root@srv-rhsoft:~]$ systemctl status mysqld
? mysqld.service - MariaDB Database
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
    Active: active (running) since Mo 2017-07-17 14:04:39 CEST; 43min ago
  Main PID: 24897 (mysqld)
    Status: "Taking your SQL requests now..."
     Tasks: 238 (limit: 2048)