Results 1 to 2 of 2

Thread: Can not start maria db

  1. #1
    Join Date
    Dec 2011
    Location
    südlich der Mainlinie
    Posts
    12

    Default Can not start maria db

    Hello together,

    after a new installation of TUMBLEWEED I run into teh problem, that it is not possible to start maria db.

    Here is what happens:

    a) Installation of maria db

    Paket mariadb-client-10.0.21-1.2.x86_64 wird abgerufen (1/2), 872,1 KiB ( 19,9 MiB entpackt)
    Abruf: mariadb-client-10.0.21-1.2.x86_64.rpm ...........................................................................................[fertig (429,2 KiB/s)]
    Paket mariadb-10.0.21-1.2.x86_64 wird abgerufen (2/2), 8,8 MiB ( 79,1 MiB entpackt)
    Abruf: mariadb-10.0.21-1.2.x86_64.rpm ....................................................................................................[fertig (1,5 MiB/s)]
    Test auf Dateikonflikte: .............................................................................................................................[fertig]
    (1/4) mysql-community-server-5.6.26-1.2 wird entfernt ................................................................................................[fertig]
    Zusätzliche rpm-Ausgabe:
    Failed to execute operation: Unit name mysql@.service is not valid.
    Failed to stop mysql@.service: Unit name mysql@.service is not valid.
    Failed to get load state of mysql@.service: Unit name mysql@.service is not valid.


    (2/4) mysql-community-server-client-5.6.26-1.2 wird entfernt .........................................................................................[fertig]
    (3/4) Installation von: mariadb-client-10.0.21-1.2 ...................................................................................................[fertig]
    Zusätzliche rpm-Ausgabe:
    usermod: no changes


    (4/4) Installation von: mariadb-10.0.21-1.2 ..........................................................................................................[fertig]
    Zusätzliche rpm-Ausgabe:
    usermod: no changes
    Failed to execute operation: Unit name mysql@.service is not valid.


    Aktualisierungshinweise wurden von folgenden Paketen erhalten:
    mariadb-10.0.21-1.2.x86_64 (/var/adm/update-messages/mariadb-10.0.21-1.2)

    b) run

    rcmysql start

    ended with:

    Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.

    Output of systemctl status mysql.service:

    ● mysql.service - MySQL server
    Loaded: loaded (/usr/lib/systemd/system/mysql.service; enabled; vendor preset: disabled)
    Active: activating (start-pre) since So 2015-11-29 19:56:38 CET; 53s ago
    Process: 20859 ExecStartPre=/usr/lib/mysql/mysql-systemd-helper install default (code=exited, status=0/SUCCESS)
    Control: 20867 (mysql-systemd-h)
    CGroup: /system.slice/mysql.service
    └─control
    ├─20867 /bin/bash /usr/lib/mysql/mysql-systemd-helper upgrade default
    └─21012 sleep 1

    Nov 29 19:56:38 willnixWlan systemd[1]: Stopped MySQL server.
    Nov 29 19:56:38 willnixWlan systemd[1]: Starting MySQL server...
    Nov 29 19:56:38 willnixWlan mysql-systemd-helper[20867]: Checking MySQL configuration for obsolete options...
    Nov 29 19:56:38 willnixWlan mysql-systemd-helper[20867]: Trying to run upgrade of MySQL databases...
    Nov 29 19:56:38 willnixWlan mysql-systemd-helper[20867]: Stale files from previous upgrade detected, cleaned them up
    Nov 29 19:56:38 willnixWlan mysql-systemd-helper[20867]: Running protected MySQL...
    Nov 29 19:56:38 willnixWlan mysql-systemd-helper[20867]: Waiting for MySQL to start
    Nov 29 19:56:38 willnixWlan mysql-systemd-helper[20867]: 151129 19:56:38 [Note] /usr/sbin/mysqld (mysqld 10.0.21-MariaDB) starting as process 20887 ..
    .

    ps -elf | grep mysql shows:

    root 21254 1 0 80 0 - 3102 wait 19:58 ? 00:00:00 /bin/bash /usr/lib/mysql/mysql-systemd-helper upgrade default

    Any idea what is going wrong?

  2. #2
    Join Date
    Dec 2011
    Location
    südlich der Mainlinie
    Posts
    12

    Red face AW: Can not start maria db

    Hello again,
    I was able to solve the problem on my own.
    For some reason I had the wrong User/group priveleges in the dir /var/lib/mysql
    Code:
    -rw-rw---- 1 root  root  12582912 22. Nov 17:44 ibdata1
    -rw-rw---- 1 root  root  50331648 22. Nov 17:44 ib_logfile0
    -rw-rw---- 1 root  root  50331648 22. Nov 17:44 ib_logfile1
    drwx------ 1 root  root      2600 22. Nov 17:27 mysql/
    drwx------ 1 root  root      3296 22. Nov 17:27 performance_schema/
    -rw-r----- 1 root  root         0  1. Dez 20:55 sqlErr.err
    drwx------ 1 root  root         0 22. Nov 17:27 test/
    -rw-r----- 1 mysql mysql     8848  1. Dez 20:55 willnixWlan.err


    I deleted the content and afterwards I had that result:

    Code:
    rwxr-xr-x 1 mysql root       300  1. Dez 21:00 ./
    drwxr-xr-x 1 root  root       856  1. Dez 21:06 ../
    -rw-rw---- 1 mysql mysql    16384  1. Dez 20:57 aria_log.00000001
    -rw-rw---- 1 mysql mysql       52  1. Dez 20:57 aria_log_control
    -rw-rw---- 1 mysql mysql 12582912  1. Dez 20:57 ibdata1
    -rw-rw---- 1 mysql mysql 50331648  1. Dez 20:57 ib_logfile0
    -rw-rw---- 1 mysql mysql 50331648  1. Dez 20:57 ib_logfile1
    -rw-rw---- 1 mysql mysql        0  1. Dez 20:57 multi-master.info
    drwx------ 1 mysql root      2600  1. Dez 20:57 mysql/
    -rw-r--r-- 1 root  root         4  1. Dez 20:57 mysql_upgrade_info
    drwx------ 1 mysql mysql     3296  1. Dez 20:57 performance_schema/
    -rw-r----- 1 mysql mysql       60  1. Dez 20:58 willnixWlan.err
    -rw-rw---- 1 mysql mysql        6  1. Dez 20:57 willnixWlan.pid

    Now things are fine

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •