maria-discuss team mailing list archive
Mailing list archive
Re: connection handling is buggy (HY000/2002): Resource temporarily unavailable)
> >> 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.
At least I got this after some update on OpenSuse Leap 42.2 and since the systemd service file for Mariadb doesn't specify Tasks everything went south immediately.
So from now on I'm setting DefaultTasksMax=infinity in the global systemd config.