So, with F26, all was happy. Now, not so much.
# systemctl start mariadb Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details. [root@sds-desk lib]# systemctl status mariadb.service ● mariadb.service - MariaDB 10.2 database server Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled) Active: failed (Result: exit-code) since Tue 2017-11-14 16:13:38 CST; 2s ago Process: 10961 ExecStart=/usr/libexec/mysqld --basedir=/usr $MYSQLD_OPTS $_WSREP_NEW_CLUSTER (code=exited, status=1/FAILURE) Process: 10924 ExecStartPre=/usr/libexec/mysql-prepare-db-dir mariadb.service (code=exited, status=0/SUCCESS) Process: 10899 ExecStartPre=/usr/libexec/mysql-check-socket (code=exited, status=0/SUCCESS) Main PID: 10961 (code=exited, status=1/FAILURE) Status: "Starting final batch to recover 7 pages from redo log"
Nov 14 16:13:37 sds-desk.local mysql-check-socket[10899]: Socket file /var/lib/mysql/mysql.sock exists. Nov 14 16:13:37 sds-desk.local mysql-check-socket[10899]: No process is using /var/lib/mysql/mysql.sock, which means it is a garbage, so it will be removed automatically. Nov 14 16:13:37 sds-desk.local mysql-prepare-db-dir[10924]: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done. Nov 14 16:13:37 sds-desk.local mysql-prepare-db-dir[10924]: If this is not the case, make sure the /var/lib/mysql is empty before running mysql-prepare-db-dir. Nov 14 16:13:37 sds-desk.local mysqld[10961]: 2017-11-14 16:13:37 140577406647552 [Note] /usr/libexec/mysqld (mysqld 10.2.9-MariaDB) starting as process 10961 ... Nov 14 16:13:37 sds-desk.local mysqld[10961]: 2017-11-14 16:13:37 140577406647552 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 table_cache: 431 Nov 14 16:13:38 sds-desk.local systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE Nov 14 16:13:38 sds-desk.local systemd[1]: Failed to start MariaDB 10.2 database server. Nov 14 16:13:38 sds-desk.local systemd[1]: mariadb.service: Unit entered failed state. Nov 14 16:13:38 sds-desk.local systemd[1]: mariadb.service: Failed with result 'exit-code'.
On 11/14/2017 04:17 PM, SternData wrote:
So, with F26, all was happy. Now, not so much.
# systemctl start mariadb Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details. [root@sds-desk lib]# systemctl status mariadb.service ● mariadb.service - MariaDB 10.2 database server Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled) Active: failed (Result: exit-code) since Tue 2017-11-14 16:13:38 CST; 2s ago Process: 10961 ExecStart=/usr/libexec/mysqld --basedir=/usr $MYSQLD_OPTS $_WSREP_NEW_CLUSTER (code=exited, status=1/FAILURE) Process: 10924 ExecStartPre=/usr/libexec/mysql-prepare-db-dir mariadb.service (code=exited, status=0/SUCCESS) Process: 10899 ExecStartPre=/usr/libexec/mysql-check-socket (code=exited, status=0/SUCCESS) Main PID: 10961 (code=exited, status=1/FAILURE) Status: "Starting final batch to recover 7 pages from redo log"
Nov 14 16:13:37 sds-desk.local mysql-check-socket[10899]: Socket file /var/lib/mysql/mysql.sock exists. Nov 14 16:13:37 sds-desk.local mysql-check-socket[10899]: No process is using /var/lib/mysql/mysql.sock, which means it is a garbage, so it will be removed automatically. Nov 14 16:13:37 sds-desk.local mysql-prepare-db-dir[10924]: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done. Nov 14 16:13:37 sds-desk.local mysql-prepare-db-dir[10924]: If this is not the case, make sure the /var/lib/mysql is empty before running mysql-prepare-db-dir. Nov 14 16:13:37 sds-desk.local mysqld[10961]: 2017-11-14 16:13:37 140577406647552 [Note] /usr/libexec/mysqld (mysqld 10.2.9-MariaDB) starting as process 10961 ... Nov 14 16:13:37 sds-desk.local mysqld[10961]: 2017-11-14 16:13:37 140577406647552 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 table_cache: 431 Nov 14 16:13:38 sds-desk.local systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE Nov 14 16:13:38 sds-desk.local systemd[1]: Failed to start MariaDB 10.2 database server. Nov 14 16:13:38 sds-desk.local systemd[1]: mariadb.service: Unit entered failed state. Nov 14 16:13:38 sds-desk.local systemd[1]: mariadb.service: Failed with result 'exit-code'.
The log says it seems to be an error with "max_open_files"
2017-11-14 16:31:19 140687694683392 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2017-11-14 16:31:19 140687694683392 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2017-11-14 16:31:19 140687694683392 [Note] InnoDB: Waiting for purge to start 2017-11-14 16:31:19 140687694683392 [Note] InnoDB: 5.7.19 started; log sequence number 2762959954 2017-11-14 16:31:19 140686393329408 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2017-11-14 16:31:19 140686393329408 [Note] InnoDB: Buffer pool(s) load completed at 171114 16:31:19 2017-11-14 16:31:19 140687694683392 [Note] Plugin 'FEEDBACK' is disabled. 2017-11-14 16:31:19 140687694683392 [ERROR] /usr/libexec/mysqld: unknown variable 'max_open_files=2048' 2017-11-14 16:31:19 140687694683392 [ERROR] Aborting
I blew away my.cnf and the directory my.cnf.d, did "dnf reinstall mariadb mariadb-server" and all is good. There was cruft left over from too my updates/tweaks/etc.
On Tue, 14 Nov 2017, SternData wrote:
So, with F26, all was happy. Now, not so much.
# systemctl start mariadb Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details. [root@sds-desk lib]# systemctl status mariadb.service ● mariadb.service - MariaDB 10.2 database server Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled) Active: failed (Result: exit-code) since Tue 2017-11-14 16:13:38 CST; 2s ago Process: 10961 ExecStart=/usr/libexec/mysqld --basedir=/usr $MYSQLD_OPTS $_WSREP_NEW_CLUSTER (code=exited, status=1/FAILURE) Process: 10924 ExecStartPre=/usr/libexec/mysql-prepare-db-dir mariadb.service (code=exited, status=0/SUCCESS) Process: 10899 ExecStartPre=/usr/libexec/mysql-check-socket (code=exited, status=0/SUCCESS) Main PID: 10961 (code=exited, status=1/FAILURE) Status: "Starting final batch to recover 7 pages from redo log"
Nov 14 16:13:37 sds-desk.local mysql-check-socket[10899]: Socket file /var/lib/mysql/mysql.sock exists. Nov 14 16:13:37 sds-desk.local mysql-check-socket[10899]: No process is using /var/lib/mysql/mysql.sock, which means it is a garbage, so it will be removed automatically. Nov 14 16:13:37 sds-desk.local mysql-prepare-db-dir[10924]: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done. Nov 14 16:13:37 sds-desk.local mysql-prepare-db-dir[10924]: If this is not the case, make sure the /var/lib/mysql is empty before running mysql-prepare-db-dir. Nov 14 16:13:37 sds-desk.local mysqld[10961]: 2017-11-14 16:13:37 140577406647552 [Note] /usr/libexec/mysqld (mysqld 10.2.9-MariaDB) starting as process 10961 ... Nov 14 16:13:37 sds-desk.local mysqld[10961]: 2017-11-14 16:13:37 140577406647552 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 table_cache: 431 Nov 14 16:13:38 sds-desk.local systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE Nov 14 16:13:38 sds-desk.local systemd[1]: Failed to start MariaDB 10.2 database server. Nov 14 16:13:38 sds-desk.local systemd[1]: mariadb.service: Unit entered failed state. Nov 14 16:13:38 sds-desk.local systemd[1]: mariadb.service: Failed with result 'exit-code'.
Is there anything in the mariadb log file? I also seem to remember that there is at least one dropped option in 10.2 which might be causing an error if it is still in your configuration.
Michael Young
its the same problem with the newest stable fc26
mariadb creates mysql.sock in /run/mysqld/ but looks in /var/lib/mysql for it
solve by doing a softlink from /run/mysqld/mysql.sock to /var/lib/mysql/mysql.sock
atleast it solved it for me on 4.13.11-200.fc26.x86_64
peter Sweden
On 2017-11-15 00:01, Michael Young wrote:
On Tue, 14 Nov 2017, SternData wrote:
So, with F26, all was happy. Now, not so much.
# systemctl start mariadb Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details. [root@sds-desk lib]# systemctl status mariadb.service ● mariadb.service - MariaDB 10.2 database server Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled) Active: failed (Result: exit-code) since Tue 2017-11-14 16:13:38 CST; 2s ago Process: 10961 ExecStart=/usr/libexec/mysqld --basedir=/usr $MYSQLD_OPTS $_WSREP_NEW_CLUSTER (code=exited, status=1/FAILURE) Process: 10924 ExecStartPre=/usr/libexec/mysql-prepare-db-dir mariadb.service (code=exited, status=0/SUCCESS) Process: 10899 ExecStartPre=/usr/libexec/mysql-check-socket (code=exited, status=0/SUCCESS) Main PID: 10961 (code=exited, status=1/FAILURE) Status: "Starting final batch to recover 7 pages from redo log"
Nov 14 16:13:37 sds-desk.local mysql-check-socket[10899]: Socket file /var/lib/mysql/mysql.sock exists. Nov 14 16:13:37 sds-desk.local mysql-check-socket[10899]: No process is using /var/lib/mysql/mysql.sock, which means it is a garbage, so it will be removed automatically. Nov 14 16:13:37 sds-desk.local mysql-prepare-db-dir[10924]: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done. Nov 14 16:13:37 sds-desk.local mysql-prepare-db-dir[10924]: If this is not the case, make sure the /var/lib/mysql is empty before running mysql-prepare-db-dir. Nov 14 16:13:37 sds-desk.local mysqld[10961]: 2017-11-14 16:13:37 140577406647552 [Note] /usr/libexec/mysqld (mysqld 10.2.9-MariaDB) starting as process 10961 ... Nov 14 16:13:37 sds-desk.local mysqld[10961]: 2017-11-14 16:13:37 140577406647552 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 table_cache: 431 Nov 14 16:13:38 sds-desk.local systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE Nov 14 16:13:38 sds-desk.local systemd[1]: Failed to start MariaDB 10.2 database server. Nov 14 16:13:38 sds-desk.local systemd[1]: mariadb.service: Unit entered failed state. Nov 14 16:13:38 sds-desk.local systemd[1]: mariadb.service: Failed with result 'exit-code'.
Is there anything in the mariadb log file? I also seem to remember that there is at least one dropped option in 10.2 which might be causing an error if it is still in your configuration.
Michael Young
users mailing list -- users@lists.fedoraproject.org To unsubscribe send an email to users-leave@lists.fedoraproject.org
Here's Fedora 22's setup: [0:root@elmo joe]$ cat /etc/redhat-release Fedora release 22 (Twenty Two)
[0:root@elmo joe]$ grep -i sock /etc/my.cnf /etc/my.cnf.d/* /etc/my.cnf.d/mariadb-server.cnf:socket=/var/lib/mysql/mysql.sock
[0:root@elmo joe]$ locate mysql.sock /var/lib/mysql/mysql.sock
HTH, Bill
On 11/15/2017 5:18 AM, Peter Lindblom wrote:
its the same problem with the newest stable fc26
mariadb creates mysql.sock in /run/mysqld/ but looks in /var/lib/mysql for it
solve by doing a softlink from /run/mysqld/mysql.sock to /var/lib/mysql/mysql.sock
atleast it solved it for me on 4.13.11-200.fc26.x86_64
peter Sweden
On 2017-11-15 00:01, Michael Young wrote:
On Tue, 14 Nov 2017, SternData wrote:
So, with F26, all was happy. Now, not so much.
# systemctl start mariadb Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details. [root@sds-desk lib]# systemctl status mariadb.service ● mariadb.service - MariaDB 10.2 database server Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled) Active: failed (Result: exit-code) since Tue 2017-11-14 16:13:38 CST; 2s ago Process: 10961 ExecStart=/usr/libexec/mysqld --basedir=/usr $MYSQLD_OPTS $_WSREP_NEW_CLUSTER (code=exited, status=1/FAILURE) Process: 10924 ExecStartPre=/usr/libexec/mysql-prepare-db-dir mariadb.service (code=exited, status=0/SUCCESS) Process: 10899 ExecStartPre=/usr/libexec/mysql-check-socket (code=exited, status=0/SUCCESS) Main PID: 10961 (code=exited, status=1/FAILURE) Status: "Starting final batch to recover 7 pages from redo log"
Nov 14 16:13:37 sds-desk.local mysql-check-socket[10899]: Socket file /var/lib/mysql/mysql.sock exists. Nov 14 16:13:37 sds-desk.local mysql-check-socket[10899]: No process is using /var/lib/mysql/mysql.sock, which means it is a garbage, so it will be removed automatically. Nov 14 16:13:37 sds-desk.local mysql-prepare-db-dir[10924]: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done. Nov 14 16:13:37 sds-desk.local mysql-prepare-db-dir[10924]: If this is not the case, make sure the /var/lib/mysql is empty before running mysql-prepare-db-dir. Nov 14 16:13:37 sds-desk.local mysqld[10961]: 2017-11-14 16:13:37 140577406647552 [Note] /usr/libexec/mysqld (mysqld 10.2.9-MariaDB) starting as process 10961 ... Nov 14 16:13:37 sds-desk.local mysqld[10961]: 2017-11-14 16:13:37 140577406647552 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 table_cache: 431 Nov 14 16:13:38 sds-desk.local systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE Nov 14 16:13:38 sds-desk.local systemd[1]: Failed to start MariaDB 10.2 database server. Nov 14 16:13:38 sds-desk.local systemd[1]: mariadb.service: Unit entered failed state. Nov 14 16:13:38 sds-desk.local systemd[1]: mariadb.service: Failed with result 'exit-code'.
Is there anything in the mariadb log file? I also seem to remember that there is at least one dropped option in 10.2 which might be causing an error if it is still in your configuration.
Michael Young
users mailing list --users@lists.fedoraproject.org To unsubscribe send an email tousers-leave@lists.fedoraproject.org
users mailing list -- users@lists.fedoraproject.org To unsubscribe send an email to users-leave@lists.fedoraproject.org