[SOLVED] mariadb fails to start
FedoraForum.org - Fedora Support Forums and Community
Results 1 to 9 of 9
  1. #1
    Join Date
    May 2014
    Location
    Israel
    Posts
    9

    mariadb fails to start

    Hi,
    When I try to use mariadb (after installing mysql-server and mysql packages) I get this error when running "systemctl start mariadb.service"
    Code:
    Job for mariadb.service failed. See 'systemctl status mariadb.service' and 'journalctl -xn' for details.
    When running the suggested commands
    Code:
    sudo systemctl -l status mariadb.service
    mariadb.service - MariaDB database server
       Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled)
       Active: failed (Result: exit-code) since Sat 2014-05-03 21:27:53 IDT; 52s ago
      Process: 3154 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=1/FAILURE)
      Process: 3153 ExecStart=/usr/bin/mysqld_safe --basedir=/usr (code=exited, status=0/SUCCESS)
      Process: 3123 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)
     Main PID: 3153 (code=exited, status=0/SUCCESS)
    
    May 03 21:27:50 localhost.localdomain mysqld_safe[3153]: 140503 21:27:50 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
    May 03 21:27:50 localhost.localdomain mysqld_safe[3153]: 140503 21:27:50 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    May 03 21:27:52 localhost.localdomain mysqld_safe[3153]: 140503 21:27:52 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
    May 03 21:27:53 localhost.localdomain systemd[1]: mariadb.service: control process exited, code=exited status=1
    May 03 21:27:53 localhost.localdomain systemd[1]: Failed to start MariaDB database server.
    May 03 21:27:53 localhost.localdomain systemd[1]: Unit mariadb.service entered failed state.
    Code:
    journalctl -xn
    -- Logs begin at Sun 2014-04-27 14:16:34 IDT, end at Sat 2014-05-03 21:28:46 IDT. --
    May 03 21:27:49 localhost.localdomain sudo[3115]: moshe : TTY=pts/0 ; PWD=/home/moshe ; USER=root ; COMMAND=/bin/system
    May 03 21:27:49 localhost.localdomain systemd[1]: Starting MariaDB database server...
    -- Subject: Unit mariadb.service has begun with start-up
    -- Defined-By: systemd
    -- 
    -- Unit mariadb.service has begun starting up.
    May 03 21:27:50 localhost.localdomain mysqld_safe[3153]: 140503 21:27:50 mysqld_safe Logging to '/var/log/mariadb/maria
    May 03 21:27:50 localhost.localdomain mysqld_safe[3153]: 140503 21:27:50 mysqld_safe Starting mysqld daemon with databa
    May 03 21:27:52 localhost.localdomain mysqld_safe[3153]: 140503 21:27:52 mysqld_safe mysqld from pid file /var/run/mari
    May 03 21:27:53 localhost.localdomain systemd[1]: mariadb.service: control process exited, code=exited status=1
    May 03 21:27:53 localhost.localdomain systemd[1]: Failed to start MariaDB database server.
    -- Subject: Unit mariadb.service has failed
    -- Defined-By: systemd
    -- 
    -- Unit mariadb.service has failed.
    -- 
    -- The result is failed.
    May 03 21:27:53 localhost.localdomain systemd[1]: Unit mariadb.service entered failed state.
    May 03 21:28:16 localhost.localdomain fprintd[3116]: ** Message: No devices in use, exit
    May 03 21:28:46 localhost.localdomain sudo[3386]: moshe : TTY=pts/0 ; PWD=/home/moshe ; USER=root ; COMMAND=/bin/system
    I saw while searching google the thread from the pre release but it didn't help (can't post links even when from here for some reason).

    I use fedora 20 fully updated without testing on this computer
    Any suggestions?

  2. #2
    Join Date
    Aug 2005
    Location
    Washington (the state), USA
    Age
    66
    Posts
    376

    Re: mariadb fails to start

    What does /var/log/mariadb/mariadb.log say?

  3. #3
    Join Date
    May 2014
    Location
    Israel
    Posts
    9

    Re: mariadb fails to start

    Here is the log of the last time I tried to use mariadb
    Code:
    140503 21:30:37 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    140503 21:30:38 [ERROR] mysqld: File '/var/lib/mysql/aria_log_control' not found (Errcode: 13)
    140503 21:30:38 [ERROR] mysqld: Got error 'Can't open file' when trying to use aria control file '/var/lib/mysql/aria_log_control'
    140503 21:30:38 [ERROR] Plugin 'Aria' init function returned error.
    140503 21:30:38 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
    140503 21:30:38 InnoDB: The InnoDB memory heap is disabled
    140503 21:30:38 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    140503 21:30:38 InnoDB: Compressed tables use zlib 1.2.8
    140503 21:30:38 InnoDB: Using Linux native AIO
    140503 21:30:38 InnoDB: Initializing buffer pool, size = 128.0M
    140503 21:30:38 InnoDB: Completed initialization of buffer pool
    140503 21:30:38 InnoDB: highest supported file format is Barracuda.
    140503 21:30:38  InnoDB: Waiting for the background threads to start
    140503 21:30:39 Percona XtraDB (http://www.percona.com) 5.5.37-MariaDB-34.0 started; log sequence number 1597945
    140503 21:30:39 [Note] Plugin 'FEEDBACK' is disabled.
    140503 21:30:39 [ERROR] mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
    140503 21:30:39 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
    140503 21:30:39 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
    140503 21:30:39 [ERROR] Aborting
    
    140503 21:30:39  InnoDB: Starting shutdown...
    140503 21:30:40  InnoDB: Shutdown completed; log sequence number 1597945
    140503 21:30:40 [Note] /usr/libexec/mysqld: Shutdown complete
    
    140503 21:30:40 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended

  4. #4
    Join Date
    Mar 2008
    Location
    Germany
    Posts
    449

    Re: mariadb fails to start

    maybe it helps to delete this 2 logfiles

    Code:
    /var/lib/mysql/ib_logfile0
    /var/lib/mysql/ib_logfile1
    as described here https://bbs.archlinux.org/viewtopic.php?id=160277

  5. #5
    Join Date
    May 2014
    Location
    Israel
    Posts
    9

    Re: mariadb fails to start

    Thanks for the replay.
    It didn't help but we have kind of progress, now it seems that it exited normally.
    Code:
    journalctl -xn
    -- Logs begin at Sun 2014-04-27 14:16:34 IDT, end at Sun 2014-05-04 01:01:02 IDT. --
    May 04 01:00:42 localhost.localdomain sudo[6412]: moshe : TTY=pts/0 ; PWD=/home/moshe ; USER=root ; COMMAND=/bin/system
    May 04 01:01:01 localhost.localdomain systemd[1]: Starting Session 7 of user root.
    -- Subject: Unit session-7.scope has begun with start-up
    -- Defined-By: systemd
    -- 
    -- Unit session-7.scope has begun starting up.
    May 04 01:01:01 localhost.localdomain systemd[1]: Started Session 7 of user root.
    -- Subject: Unit session-7.scope has finished start-up
    -- Defined-By: systemd
    -- 
    -- Unit session-7.scope has finished starting up.
    -- 
    -- The start-up result is done.
    May 04 01:01:01 localhost.localdomain CROND[6421]: (root) CMD (run-parts /etc/cron.hourly)
    May 04 01:01:01 localhost.localdomain run-parts[6430]: (/etc/cron.hourly) starting 0anacron
    May 04 01:01:01 localhost.localdomain anacron[6470]: Anacron started on 2014-05-04
    May 04 01:01:01 localhost.localdomain run-parts[6472]: (/etc/cron.hourly) finished 0anacron
    May 04 01:01:01 localhost.localdomain run-parts[6475]: (/etc/cron.hourly) starting mcelog.cron
    May 04 01:01:01 localhost.localdomain run-parts[6480]: (/etc/cron.hourly) finished mcelog.cron
    May 04 01:01:02 localhost.localdomain anacron[6470]: Normal exit (0 jobs run)
    Then I tried to remove the file ariadb_log.000001 (I might be wrong with how many zero's there are) and from then on the results are as follows:
    Code:
    sudo systemctl -l status mariadb.service
    mariadb.service - MariaDB database server
       Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled)
       Active: failed (Result: exit-code) since Sun 2014-05-04 01:14:07 IDT; 3s ago
      Process: 7132 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=1/FAILURE)
      Process: 7131 ExecStart=/usr/bin/mysqld_safe --basedir=/usr (code=exited, status=0/SUCCESS)
      Process: 7103 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)
     Main PID: 7131 (code=exited, status=0/SUCCESS)
    
    May 04 01:14:04 localhost.localdomain mysqld_safe[7131]: 140504 01:14:04 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
    May 04 01:14:04 localhost.localdomain mysqld_safe[7131]: 140504 01:14:04 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    May 04 01:14:06 localhost.localdomain mysqld_safe[7131]: 140504 01:14:06 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
    May 04 01:14:07 localhost.localdomain systemd[1]: mariadb.service: control process exited, code=exited status=1
    May 04 01:14:07 localhost.localdomain systemd[1]: Failed to start MariaDB database server.
    May 04 01:14:07 localhost.localdomain systemd[1]: Unit mariadb.service entered failed state
    Code:
    journalctl -xn
    -- Logs begin at Sun 2014-04-27 14:16:34 IDT, end at Sun 2014-05-04 01:14:10 IDT. --
    May 04 01:13:55 localhost.localdomain systemd[1]: Started PackageKit Daemon.
    -- Subject: Unit packagekit.service has finished start-up
    -- Defined-By: systemd
    -- 
    -- Unit packagekit.service has finished starting up.
    -- 
    -- The start-up result is done.
    May 04 01:14:03 localhost.localdomain sudo[7100]: moshe : TTY=pts/0 ; PWD=/home/moshe ; USER=root ; COMMAND=/bin/system
    May 04 01:14:03 localhost.localdomain systemd[1]: Starting MariaDB database server...
    -- Subject: Unit mariadb.service has begun with start-up
    -- Defined-By: systemd
    -- 
    -- Unit mariadb.service has begun starting up.
    May 04 01:14:04 localhost.localdomain mysqld_safe[7131]: 140504 01:14:04 mysqld_safe Logging to '/var/log/mariadb/maria
    May 04 01:14:04 localhost.localdomain mysqld_safe[7131]: 140504 01:14:04 mysqld_safe Starting mysqld daemon with databa
    May 04 01:14:06 localhost.localdomain mysqld_safe[7131]: 140504 01:14:06 mysqld_safe mysqld from pid file /var/run/mari
    May 04 01:14:07 localhost.localdomain systemd[1]: mariadb.service: control process exited, code=exited status=1
    May 04 01:14:07 localhost.localdomain systemd[1]: Failed to start MariaDB database server.
    -- Subject: Unit mariadb.service has failed
    -- Defined-By: systemd
    -- 
    -- Unit mariadb.service has failed.
    -- 
    -- The result is failed.

  6. #6
    Join Date
    May 2014
    Location
    Israel
    Posts
    9

    Re: mariadb fails to start

    OK, I solved the problem I created when removing the file aria_log by using the command 'mysql_install_db'
    but the initial problem still exists.

    some commands for info
    Code:
    systemctl -l status mariadb.service
    mariadb.service - MariaDB database server
       Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled)
       Active: failed (Result: exit-code) since Mon 2014-05-05 23:13:03 IDT; 7s ago
      Process: 21824 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=1/FAILURE)
      Process: 21823 ExecStart=/usr/bin/mysqld_safe --basedir=/usr (code=exited, status=0/SUCCESS)
      Process: 21795 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)
     Main PID: 21823 (code=exited, status=0/SUCCESS)
    
    May 05 23:12:59 localhost.localdomain systemd[1]: Starting MariaDB database server...
    May 05 23:13:00 localhost.localdomain mysqld_safe[21823]: 140505 23:13:00 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
    May 05 23:13:00 localhost.localdomain mysqld_safe[21823]: 140505 23:13:00 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    May 05 23:13:02 localhost.localdomain mysqld_safe[21823]: 140505 23:13:02 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
    May 05 23:13:03 localhost.localdomain systemd[1]: mariadb.service: control process exited, code=exited status=1
    May 05 23:13:03 localhost.localdomain systemd[1]: Failed to start MariaDB database server.
    May 05 23:13:03 localhost.localdomain systemd[1]: Unit mariadb.service entered failed state.
    Code:
    -- Logs begin at Sun 2014-04-27 14:16:34 IDT, end at Mon 2014-05-05 23:13:23 IDT. --
    May 05 23:12:53 localhost.localdomain fprintd[21788]: ** Message: entering main loop
    May 05 23:12:59 localhost.localdomain sudo[21787]: moshe : TTY=pts/0 ; PWD=/home/moshe ; USER=root ; COMMAND=/bin/systemctl start mariadb.service
    May 05 23:12:59 localhost.localdomain systemd[1]: Starting MariaDB database server...
    -- Subject: Unit mariadb.service has begun with start-up
    -- Defined-By: systemd
    -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
    -- 
    -- Unit mariadb.service has begun starting up.
    May 05 23:13:00 localhost.localdomain mysqld_safe[21823]: 140505 23:13:00 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
    May 05 23:13:00 localhost.localdomain mysqld_safe[21823]: 140505 23:13:00 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    May 05 23:13:02 localhost.localdomain mysqld_safe[21823]: 140505 23:13:02 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
    May 05 23:13:03 localhost.localdomain systemd[1]: mariadb.service: control process exited, code=exited status=1
    May 05 23:13:03 localhost.localdomain systemd[1]: Failed to start MariaDB database server.
    -- Subject: Unit mariadb.service has failed
    -- Defined-By: systemd
    -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
    -- 
    -- Unit mariadb.service has failed.
    -- 
    -- The result is failed.
    May 05 23:13:03 localhost.localdomain systemd[1]: Unit mariadb.service entered failed state.
    May 05 23:13:23 localhost.localdomain fprintd[21788]: ** Message: No devices in use, exit
    Code:
    mysql
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    from the log file
    Code:
    140505 23:23:17 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    140505 23:23:17 [ERROR] mysqld: File '/var/lib/mysql/aria_log_control' not found (Errcode: 13)
    140505 23:23:17 [ERROR] mysqld: Got error 'Can't open file' when trying to use aria control file '/var/lib/mysql/aria_log_control'
    140505 23:23:17 [ERROR] Plugin 'Aria' init function returned error.
    140505 23:23:17 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
    140505 23:23:17 InnoDB: The InnoDB memory heap is disabled
    140505 23:23:17 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    140505 23:23:17 InnoDB: Compressed tables use zlib 1.2.8
    140505 23:23:17 InnoDB: Using Linux native AIO
    140505 23:23:17 InnoDB: Initializing buffer pool, size = 128.0M
    140505 23:23:17 InnoDB: Completed initialization of buffer pool
    140505 23:23:17 InnoDB: highest supported file format is Barracuda.
    140505 23:23:17  InnoDB: Waiting for the background threads to start
    140505 23:23:18 Percona XtraDB (http://www.percona.com) 5.5.37-MariaDB-34.0 started; log sequence number 1598476
    140505 23:23:18 [Note] Plugin 'FEEDBACK' is disabled.
    140505 23:23:18 [ERROR] mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
    140505 23:23:18 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
    140505 23:23:18 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
    140505 23:23:18 [ERROR] Aborting
    
    140505 23:23:18  InnoDB: Starting shutdown...
    140505 23:23:19  InnoDB: Shutdown completed; log sequence number 1598476
    140505 23:23:19 [Note] /usr/libexec/mysqld: Shutdown complete
    
    140505 23:23:19 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
    something I checked and found out is that the file 'plugin.frm' exists in '/var/lib/mysql/mysql' so I guess that it looks for the file somewhere else.
    1. How can I check if I am correct?
    2. If I am correct, how to solve this?

    Thanks

  7. #7
    Join Date
    May 2014
    Location
    Israel
    Posts
    9

    Re: mariadb fails to start

    OK, I solved the problem.
    I had to remove mariadb, mariadb-server, mysql, mysql-server. Then I removed /var/lib/mysql and then reinstalled mariadb, mariadb-server, mysql and mysql-server.

    What I don't understand is why should it be so complicated?

  8. #8
    Join Date
    Dec 2014
    Location
    UK
    Posts
    1

    Re: mariadb fails to start

    Just a quick shout for `fixfiles relabel /var/lib/mysql/`, which worked for me or might have. I had only tried to start mysqld.service once; perhaps a second try without the fixfiles would have achieved the same success.

  9. #9
    Join Date
    Jan 2011
    Posts
    1,116

    Re: mariadb fails to start

    Oops wrong thread, sorry.

    The information is great, now we all can do something about it, some sure will opt to not use it and that is fine, some will use it anyways and that is fine to, me I like to think about how to fix it.

    How to change a protected page into a non protected page
    http://moinmo.in/MoinMoinQuestions/Permissions

    Code:
    How are ACLs configured in wikiconfig.py?
    
        acl_rights_default = u'StudentGroup:read,write,delete,revert All:read'
        acl_rights_before = u'AdminGroup:read,write,delete,revert,admin '
    Could it be that simple? just removing the "write" from that page?

    The SSL part is not that crucial, if you have a trusted form to verify integrity elsewhere.

    Resources:
    http://moinmo.in/
    https://en.wikipedia.org/wiki/MoinMoin

Similar Threads

  1. Install of MariaDB Fails
    By Granolageek in forum Installation, Upgrades and Live Media
    Replies: 2
    Last Post: 21st January 2014, 11:46 AM
  2. MariaDb Fails To Start with Systemctl
    By GarethTheRed in forum F-20 Development Forum
    Replies: 7
    Last Post: 29th November 2013, 07:34 PM
  3. MariaDB conflicts with MySQL
    By flaflashr in forum EOL (End Of Life) Versions
    Replies: 3
    Last Post: 2nd August 2013, 02:08 PM
  4. MariaDB question
    By JuanKman94 in forum Programming & Packaging
    Replies: 3
    Last Post: 8th July 2013, 02:28 AM
  5. #/etc/init.d/mysqld start FAILS won't start mysql
    By cwynn in forum Servers & Networking
    Replies: 17
    Last Post: 19th September 2006, 02:59 AM

Tags for this Thread

Posting Permissions

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