errno: 24 - Too many open files

Discussion in 'Installation/Configuration' started by ferra, Oct 10, 2019.

  1. ferra

    ferra New Member

    Hello,

    I reboot Ispconfig server and mysql stops with this error:
    errno: 24 - Too many open files
    I edited /etc/systemd/system.conf and uncomment and make
    DefaultLimitNOFILE=infinity
    DefaultLimitMEMLOCK=infinity

    then restart the server again, mysql seems to be running, I can access the site and database, but get this when running
    service mysql status
    ● mysql.service - LSB: Start and stop the mysql database server daemon
    Loaded: loaded (/etc/init.d/mysql; bad; vendor preset: enabled)
    Active: failed (Result: exit-code) since Wed 2019-10-09 23:20:01 WEST; 29min ago
    Docs: man:systemd-sysv-generator(8)
    Process: 1540 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)
    Tasks: 36
    Memory: 625.1M
    CPU: 17.329s
    CGroup: /system.slice/mysql.service
    ├─1741 /bin/bash /usr/bin/mysqld_safe
    ├─1898 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --skip-log-error --pid-file=/var/run/mysqld/my
    └─1899 logger -t mysqld -p daemon error

    Oct 09 23:20:38 alfa.acloud.pt mysqld[1899]: 191009 23:20:38 [Note] InnoDB: 128 rollback segment(s) are active.
    Oct 09 23:20:38 alfa.acloud.pt mysqld[1899]: 191009 23:20:38 [Note] InnoDB: Waiting for purge to start
    Oct 09 23:20:38 alfa.acloud.pt mysqld[1899]: 191009 23:20:38 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.42-84.2 started; log sequence number 83596377720
    Oct 09 23:20:38 alfa.acloud.pt mysqld[1899]: 191009 23:20:38 [Note] Plugin 'FEEDBACK' is disabled.
    Oct 09 23:20:39 alfa.acloud.pt mysqld[1899]: 191009 23:20:39 [Note] Server socket created on IP: '::'.
    Oct 09 23:20:39 alfa.acloud.pt mysqld[1899]: 191009 23:20:39 [Warning] 'user' entry '[email protected]' has both a password and an authentication plugin specified. The pass
    Oct 09 23:20:39 alfa.acloud.pt mysqld[1899]: 191009 23:20:39 [Note] /usr/sbin/mysqld: ready for connections.
    Oct 09 23:20:39 alfa.acloud.pt mysqld[1899]: Version: '10.0.38-MariaDB-0ubuntu0.16.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Ubuntu 16.04
    Oct 09 23:22:11 alfa.acloud.pt mysqld[1899]: 191009 23:22:11 [ERROR] mysqld: Table './dbispconfig/sys_session' is marked as crashed and should be repaired
    Oct 09 23:22:11 alfa.acloud.pt mysqld[1899]: 191009 23:22:11 [Warning] Checking table: './dbispconfig/sys_session'


    Any idea?

    Thanks
    Ferra
     
  2. Taleman

    Taleman Well-Known Member HowtoForge Supporter

Share This Page