Страница 1 из 1

Mysql can't get client address: Bad file descriptor

Добавлено: 2014-04-14 19:45:23
glb_ussr
Всем привет.
srv1 9.1-RELEASE FreeBSD 9.1-RELEASE #2
MySQL connection id is 15248598
Server version: 5.6.17

dmesg -a выдает
Apr 13 15:07:12 srv1 mysqld[60294]: warning: /etc/hosts.allow, line 23: can't get client address: Bad file descriptor
Apr 13 21:09:16 srv1 mysqld[60294]: warning: /etc/hosts.allow, line 23: getsockname: Bad file descriptor
Apr 13 22:36:16 srv1 mysqld[60294]: warning: /etc/hosts.allow, line 23: getsockname: Bad file descriptor
Apr 13 23:20:17 srv1 mysqld[60294]: warning: /etc/hosts.allow, line 23: getsockname: Bad file descriptor
Apr 14 03:15:36 srv1 mysqld[64211]: warning: /etc/hosts.allow, line 23: getsockname: Bad file descriptor
Apr 14 04:48:37 srv1 mysqld[64211]: warning: /etc/hosts.allow, line 23: getsockname: Bad file descriptor
Apr 14 06:41:38 srv1 mysqld[64211]: warning: /etc/hosts.allow, line 23: getsockname: Bad file descriptor
Apr 14 09:07:39 srv1 mysqld[64211]: warning: /etc/hosts.allow, line 23: getsockname: Bad file descriptor
Apr 14 09:14:39 srv1 mysqld[64211]: warning: /etc/hosts.allow, line 23: getsockname: Bad file descriptor
Apr 14 09:30:39 srv1 mysqld[64211]: warning: /etc/hosts.allow, line 23: can't get client address: Bad file descriptor
Apr 14 14:12:13 srv1 mysqld[69669]: warning: /etc/hosts.allow, line 23: can't get client address: Bad file descriptor
Apr 14 15:28:14 srv1 mysqld[69669]: warning: /etc/hosts.allow, line 23: can't get client address: Bad file descriptor

23 строка это
ALL : ALL : allow

sysctl -a |grep files
kern.maxfiles: 65000
kern.maxfilesperproc: 32000
kern.openfiles: 365

mysqladmin variables | grep open_files_limit
| open_files_limit | 32000

подскажите, что может быть ?

Re: Mysql can't get client address: Bad file descriptor

Добавлено: 2014-04-15 8:21:31
dmtr
место не закончилось? на /var например?

Re: Mysql can't get client address: Bad file descriptor

Добавлено: 2014-04-22 11:47:21
glb_ussr
нет.
Есть подозрение, такое, раньше эта копия mysql была слейвом, потом я мастера загасил, инфраструктуру перевел на этот сервер, а настройки слейва не удалил. Сейчас это обнаружилось, настройки слейва удалил, пока ошибок не замеченно.