Page 1 of 3 123 LastLast
Results 1 to 10 of 22

Thread: Maria / MySQL Fails to Start

  1. #1

    Default Maria / MySQL Fails to Start

    OpenSuse Tumbleweed 64 bit

    mysqld 10.0.22-MariaDB


    Code:
    systemctl start mysql.d service
    Job for mysql.service failed because the control process exited with error code.
    See "systemctl  status mysql.service" and "journalctl  -xe" for details.
    
    journalctl  -xe
    WARNING: terminal is not fully functional
    -  (press RETURN)Mar 25 00:38:07 linux-qob4 mysql-systemd-helper[7249]: MySQL didn't start, can't continue
    Mar 25 00:38:07 linux-qob4 systemd[1]: mysql.service: Control process exited, code=exited status=1
    Mar 25 00:38:07 linux-qob4 systemd[1]: Failed to start MySQL server.
    -- Subject: Unit mysql.service has failed
    -- Defined-By: systemd
    -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
    --  
    -- Unit mysql.service has failed.
    --  
    -- The result is failed.
    Mar 25 00:38:07 linux-qob4 systemd[1]: mysql.service: Unit entered failed state.
    Mar 25 00:38:07 linux-qob4 systemd[1]: mysql.service: Failed with result 'exit-code'.
    Mar 25 00:38:07 linux-qob4 systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
    Mar 25 00:38:07 linux-qob4 systemd[1]: Stopped MySQL server.
    -- Subject: Unit mysql.service has finished shutting down
    -- Defined-By: systemd
    -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
    --  
    -- Unit mysql.service has finished shutting down.
    Mar 25 00:38:07 linux-qob4 systemd[1]: Starting MySQL server...
    -- Subject: Unit mysql.service has begun start-up
    -- Defined-By: systemd
    -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
    --  
    -- Unit mysql.service has begun starting up.
    Mar 25 00:38:07 linux-qob4 mysql-systemd-helper[7506]: Checking MySQL configuration for obsolete options...
    Mar 25 00:38:07 linux-qob4 mysql-systemd-helper[7506]: Trying to run upgrade of MySQL databases...
    Mar 25 00:38:07 linux-qob4 mysql-systemd-helper[7506]: Stale files from previous upgrade detected, cleaned them up
    Mar 25 00:38:07 linux-qob4 mysql-systemd-helper[7506]: Running protected MySQL...
    Mar 25 00:38:07 linux-qob4 mysql-systemd-helper[7506]: Waiting for MySQL to start
    Mar 25 00:38:07 linux-qob4 mysql-systemd-helper[7506]: 180325  0:38:07 [Note] /usr/sbin/mysqld (mysqld 10.0.22-MariaDB) starting as process 7528 ...
    
    Process continues to attempt restart but fails

    /MySQL directory and subfolders and files have correct ownership mysql:mysql

  2. #2
    Join Date
    Jan 2018
    Location
    Canada
    Posts
    193

    Default Re: Maria / MySQL Fails to Start

    There might be some additional info in

    /var/log/mysql/mysqld.log

  3. #3

    Default Re: Maria / MySQL Fails to Start

    There is no

    /var/log/mysql/mysqld.log

  4. #4
    Join Date
    Oct 2008
    Location
    Glasgow, Scotland
    Posts
    1,277

    Default Re: Maria / MySQL Fails to Start

    Quote Originally Posted by leoplaw View Post
    There is no
    /var/log/mysql/mysqld.log
    Try:
    Code:
    :~> journalctl --unit=mysql
    --
    slàinte mhath,
    rayH

    ~ knowing the right answer is easier than knowing the right question.

  5. #5

    Default Re: Maria / MySQL Fails to Start

    here is the output from journalctl --unit=mysql

    I still do not see anything useful

    Code:
    Mar 11 00:47:02 linux-qob4 systemd[1]: Starting MySQL server...
    Mar 11 00:47:02 linux-qob4 mysql-systemd-helper[27653]: Checking MySQL configuration for obsolete options...
    Mar 11 00:47:02 linux-qob4 mysql-systemd-helper[27653]: Trying to run upgrade of MySQL databases...
    Mar 11 00:47:02 linux-qob4 mysql-systemd-helper[27653]: Running protected MySQL...
    Mar 11 00:47:02 linux-qob4 mysql-systemd-helper[27653]: Waiting for MySQL to start
    Mar 11 00:47:02 linux-qob4 mysql-systemd-helper[27653]: 180311  0:47:02 [Note] /usr/sbin/mysqld (mysqld 10.0.22-MariaDB) starting as process 27672 ...
    Mar 11 00:48:02 linux-qob4 mysql-systemd-helper[27653]: MySQL is still dead
    Mar 11 00:48:02 linux-qob4 mysql-systemd-helper[27653]: MySQL didn't start, can't continue
    Mar 11 00:48:02 linux-qob4 systemd[1]: mysql.service: Control process exited, code=exited status=1
    Mar 11 00:48:02 linux-qob4 systemd[1]: Failed to start MySQL server.
    Mar 11 00:48:02 linux-qob4 systemd[1]: mysql.service: Unit entered failed state.
    Mar 11 00:48:02 linux-qob4 systemd[1]: mysql.service: Failed with result 'exit-code'.
    Mar 11 00:48:02 linux-qob4 systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
    Mar 11 00:48:02 linux-qob4 systemd[1]: Stopped MySQL server.
    Mar 11 00:48:02 linux-qob4 systemd[1]: Starting MySQL server...
    
    

  6. #6
    Join Date
    Oct 2008
    Location
    Glasgow, Scotland
    Posts
    1,277

    Default Re: Maria / MySQL Fails to Start

    Quote Originally Posted by leoplaw View Post
    here is the output from journalctl --unit=mysql
    ...
    I still do not see anything useful
    Have you actually configured/installed a database?
    What? Where? How?
    --
    slàinte mhath,
    rayH

    ~ knowing the right answer is easier than knowing the right question.

  7. #7

    Default Re: Maria / MySQL Fails to Start

    Yes, I have databases, with users, migrated from my old machine.

    MySQL installed from openSuse repositories via Yast.

    I have the MySQL database at a custom location set via my.cnf. The directory and all contents have the owner:group mysql:mysql

    my /etc/my.cnf


    Code:
    # This is default example of MySQL/MariaDB configuration provided with openSUSE package
    # It is based on upstream defaults with some additional examples.
    
    
    
    
    # The following options will be passed to all MariaDB clients
    [client]
    # password  = your_password
    # port       = 3306
    # socket     = /var/run/mysql/mysql.sock
    
    
    [mysqld]
    
    
    # Remove leading # if you don't want to listen on network (only socket - safer)
    # skip-networking
    
    
    # Remove leading # and set to the amount of RAM for the most important data
    # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
    # innodb_buffer_pool_size = 128M
    
    
    # Using newer file format that supports dynamic and compressed row formats.
    # If you are using replication you have to make sure, that these options are
    # set everywhere the same way (probably comment them out is the easiest way)
    innodb_file_format=Barracuda
    innodb_file_per_table=ON
    
    
    # Remove leading # to turn on a very important data integrity option: logging
    # changes to the binary log between backups.
    # log_bin=mysql-bin
    # binlog_format=mixed
    
    
    # Remove leading # if you want to store your database elsewhere
    datadir	= /home/xyz/MySQL
    
    
    # required unique id between 1 and 2^32 - 1
    # defaults to 1 if master-host is not set
    # but will not function as a master if omitted
    server-id	= 1
    
    
    # These are commonly set, remove the # and set as required.
    # port = 3306
    # socket = /var/run/mysql/mysql.sock
    
    
    # Don't listen on a TCP/IP port at all. This can be a security enhancement,
    # if all processes that need to connect to mysqld run on the same host.
    # All interaction with mysqld must be made via Unix sockets or named pipes.
    # Note that using this option without enabling named pipes on Windows
    # (via the "enable-named-pipe" option) will render mysqld useless!
    # 
    # skip-networking
    
    
    # Remove leading # to set options mainly useful for reporting servers.
    # The server defaults are faster for transactions and fast SELECTs.
    # Adjust sizes as needed, experiment to find the optimal values.
    # join_buffer_size = 128M
    # sort_buffer_size = 2M
    # read_rnd_buffer_size = 2M 
    
    
    sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
    
    
    [mysqld_multi]
    mysqld     = /usr/bin/mysqld_safe
    mysqladmin = /usr/bin/mysqladmin
    log        = /var/log/mysqld_multi.log
    
    
    # If you want to use mysqld_multi uncomment 1 or more mysqld sections
    # below or add your own ones.
    
    
    # WARNING
    # --------
    # If you uncomment mysqld1 than make absolutely sure, that database mysql,
    # configured above, is not started.  This may result in corrupted data!
    #
    # [mysqld1]
    # port       = 3306
    # datadir    = /var/lib/mysql
    # pid-file   = /var/lib/mysql/mysqld.pid
    # socket     = /var/lib/mysql/mysql.sock
    # user       = mysql
    
    
    # [mysqld2]
    # port       = 3307
    # datadir    = /var/lib/mysql-databases/mysqld2
    # pid-file   = /var/lib/mysql-databases/mysqld2/mysql.pid
    # socket     = /var/lib/mysql-databases/mysqld2/mysql.sock
    # user       = mysql
    
    
    # [mysqld3]
    # port       = 3308
    # datadir    = /var/lib/mysql-databases/mysqld3
    # pid-file   = /var/lib/mysql-databases/mysqld3/mysql.pid
    # socket     = /var/lib/mysql-databases/mysqld3/mysql.sock
    # user       = mysql
    
    
    # [mysqld6]
    # port       = 3309
    # datadir    = /var/lib/mysql-databases/mysqld6
    # pid-file   = /var/lib/mysql-databases/mysqld6/mysql.pid
    # socket     = /var/lib/mysql-databases/mysqld6/mysql.sock
    # user       = mysql
    
    
    !includedir /etc/my.cnf.d

  8. #8
    Join Date
    Oct 2008
    Location
    Glasgow, Scotland
    Posts
    1,277

    Default Re: Maria / MySQL Fails to Start

    Quote Originally Posted by leoplaw View Post
    OpenSuse Tumbleweed 64 bit

    mysqld 10.0.22-MariaDB


    Code:
    systemctl start mysql.d service 
    ...
    Try:
    Code:
    sudo systemctl start mysql
    --
    slàinte mhath,
    rayH

    ~ knowing the right answer is easier than knowing the right question.

  9. #9
    Join Date
    Oct 2008
    Location
    Glasgow, Scotland
    Posts
    1,277

    Default Re: Maria / MySQL Fails to Start

    Quote Originally Posted by leoplaw View Post
    Yes, I have databases, with users, migrated from my old machine.

    MySQL installed from openSuse repositories via Yast.

    I have the MySQL database at a custom location set via my.cnf. The directory and all contents have the owner:group mysql:mysql

    my /etc/my.cnf


    Code:
    # This is default example of MySQL/MariaDB cEach database will be in a directory Each database will be in a directory onfiguration provided with openSUSE package
    
    datadir    = /home/xyz/MySQL
    Check that the mysql user can access (navigate to) /home/xyz/MySQL -- other will need access to /home/xyz. Each database will be in its own directory within MySQL.

    Why are the logs two weeks old?

    MySQL installed from openSuse repositories via Yast.
    I do not understand this. A fully functional MariaDB is installed in Tumbleeweed by default. It is used by e.g. KDE. All I had to do was copy a database folder from a server to /home/testData, point “datadir” to the testData and “systemctl start mysql” to be able to query the database with a “mysql oldDb” command.
    --
    slàinte mhath,
    rayH

    ~ knowing the right answer is easier than knowing the right question.

  10. #10

    Default Re: Maria / MySQL Fails to Start

    Yes, as previously mentioned, and I checked again

    /home/xyz/MySQL

    has the following owner and group - mysql:mysql

    as do all directories and files below it.


    the logs from two weeks ago are the same as last night and today, it is still the same problem. I just took the first entries from the log.


    Nor, do I understand the problem either, because I have set up and migrated MySQL databases multiple times previously. I also copied the MySQL directory over from the old machine. In the pas this worked also.

    I am missing something, hence I am asking for help / suggestions.

    I am already issuing the following command to attempt to start MySQL, as mentioned above, and receiving the uninformative error messages and log entries I have posted.

    systemctl start mysql

Page 1 of 3 123 LastLast

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
  •