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 'root@localhost' 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
Duplicate of https://www.howtoforge.com/community/threads/too-many-open-files.83021/ You can remove your own post if you posted it in wrong forum. Or mark it wrongly posted so time reading it is not wasted.
