Bug 1313298
Summary: | mariadb does not start | ||
---|---|---|---|
Product: | [Fedora] Fedora | Reporter: | Marcin Juszkiewicz <mjuszkie> |
Component: | mariadb | Assignee: | Jakub Dorňák <jdornak> |
Status: | CLOSED NOTABUG | QA Contact: | Fedora Extras Quality Assurance <extras-qa> |
Severity: | high | Docs Contact: | |
Priority: | unspecified | ||
Version: | rawhide | CC: | hhorak, jadijadi, jdornak, jstanek, mjuszkie, mmuzila |
Target Milestone: | --- | ||
Target Release: | --- | ||
Hardware: | x86_64 | ||
OS: | Unspecified | ||
Whiteboard: | |||
Fixed In Version: | Doc Type: | Bug Fix | |
Doc Text: | Story Points: | --- | |
Clone Of: | Environment: | ||
Last Closed: | 2016-03-21 08:38:03 UTC | Type: | Bug |
Regression: | --- | Mount Type: | --- |
Documentation: | --- | CRM: | |
Verified Versions: | Category: | --- | |
oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
Cloudforms Team: | --- | Target Upstream Version: | |
Embargoed: |
Description
Marcin Juszkiewicz
2016-03-01 11:04:43 UTC
1:10.1.11-7.fc24 has same effect Same with 10.1.11-6 and 10.1.11-5 versions. Will not check older ones today. ping? Current version in both f24 and rawhide is mariadb-server-10.1.12-2.fc24/5. I have successfully tried to start it. Are you able to reproduce it with current rawhide/f24 version? 12:59 root@puchatek:hrw# rpm -q mariadb mariadb-10.1.12-2.fc25.x86_64 12:59 root@puchatek:hrw# systemctl restart mariadb Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details. 12:59 root@puchatek:hrw# systemctl status mariadb ● mariadb.service - MariaDB 10.1 database server Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled) Active: failed (Result: exit-code) since śro 2016-03-09 12:59:33 CET; 8s ago Process: 8485 ExecStopPost=/usr/libexec/mysql-wait-stop (code=exited, status=0/SUCCESS) Process: 8453 ExecStart=/usr/libexec/mysqld --basedir=/usr $MYSQLD_OPTS $_WSREP_NEW_CLUSTER (code=exited, status=1/FAILURE) Process: 8417 ExecStartPre=/usr/libexec/mysql-prepare-db-dir %n (code=exited, status=0/SUCCESS) Process: 8388 ExecStartPre=/usr/libexec/mysql-check-socket (code=exited, status=0/SUCCESS) Main PID: 8453 (code=exited, status=1/FAILURE) Status: "MariaDB server is down" 13:00 root@puchatek:hrw# journalctl -xe mar 09 12:59:30 puchatek.local systemd[1]: Starting MariaDB 10.1 database server... mar 09 12:59:30 puchatek.local mysqld[8453]: 2016-03-09 12:59:30 140080268855488 [Note] /usr/libexec/mysqld (mysqld 10.1.12-MariaDB) s mar 09 12:59:33 puchatek.local systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE mar 09 12:59:33 puchatek.local systemd[1]: Failed to start MariaDB 10.1 database server. mar 09 12:59:33 puchatek.local systemd[1]: mariadb.service: Unit entered failed state. mar 09 12:59:33 puchatek.local systemd[1]: mariadb.service: Failed with result 'exit-code'. mar 09 12:59:30 puchatek.local systemd[1]: Stopped MariaDB 10.1 database server. -- Subject: Ukończono wyłączanie jednostki mariadb.service -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- Jednostka mariadb.service ukończyła wyłączanie. mar 09 12:59:30 puchatek.local systemd[1]: Starting MariaDB 10.1 database server... -- Subject: Rozpoczęto uruchamianie jednostki mariadb.service -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- Jednostka mariadb.service rozpoczęła uruchamianie. mar 09 12:59:30 puchatek.local mysqld[8453]: 2016-03-09 12:59:30 140080268855488 [Note] /usr/libexec/mysqld (mysqld 10.1.12-MariaDB) starting as process 8453 ... mar 09 12:59:33 puchatek.local systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE mar 09 12:59:33 puchatek.local systemd[1]: Failed to start MariaDB 10.1 database server. -- Subject: Jednostka mariadb.service się nie powiodła -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- Jednostka mariadb.service się nie powiodła. -- -- Wynik: failed. mar 09 12:59:33 puchatek.local audit[1]: SERVICE_START pid=1 uid=0 auid=4294967295 ses=4294967295 subj=system_u:system_r:init_t:s0 msg='unit=mariadb comm="systemd" exe="/usr/lib/systemd/systemd" hostname=? addr=? terminal=? res=failed' mar 09 12:59:33 puchatek.local systemd[1]: mariadb.service: Unit entered failed state. mar 09 12:59:33 puchatek.local systemd[1]: mariadb.service: Failed with result 'exit-code'. mar 09 12:59:33 puchatek.local polkitd[1044]: Unregistered Authentication Agent for unix-process:8381:817387 (system bus name :1.80, object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale pl_PL.UTF-8) (disconnected from bus) mar 09 12:59:48 puchatek.local audit: NETFILTER_CFG table=filter family=2 entries=0 mar 09 12:59:48 puchatek.local audit: NETFILTER_CFG table=filter family=10 entries=0 mar 09 12:59:48 puchatek.local audit: NETFILTER_CFG table=nat family=2 entries=0 mar 09 12:59:48 puchatek.local audit: NETFILTER_CFG table=mangle family=2 entries=0 mar 09 12:59:48 puchatek.local audit: NETFILTER_CFG table=filter family=2 entries=0 mar 09 12:59:48 puchatek.local audit: NETFILTER_CFG table=filter family=10 entries=0 mar 09 12:59:48 puchatek.local audit: NETFILTER_CFG table=nat family=2 entries=0 mar 09 12:59:48 puchatek.local audit: NETFILTER_CFG table=mangle family=2 entries=0 Uninstalled mariadb*, removed /var/lib/mysql/* and installed mariadb-server back. Works. And again, the same situation happened ;( Will move my development outside of Fedora machine. Same problem here. The "Unregistered Authentication Agent for unix-process" appears after I import my dump from the older mariadb into the Fedora24 version of it. (In reply to Marcin Juszkiewicz from comment #7) > And again, the same situation happened ;( > > Will move my development outside of Fedora machine. At the end I "resolved" my issue by installing the clean mariadb-server and then importing ONLY the databases I needed (not the whole dump). This is the command: # mysql -u root -p --one-database 'sefaresh' < /tmp/mysql_jun_complete_dump.mysql |