Results 1 to 7 of 7

Thread: mysql fails to start

  1. #1

    Default mysql fails to start

    openSUSE 12.2 stable

    Application:
    Repository: openSUSE-12.2-OSS
    Name: mysql-community-server
    Version: 5.5.25a-1.2.1

    when starting mysqld from command line

    Code:
    rcmysql start
    it respond with
    Code:
    Job failed. See system journal and 'systemctl status' for details.
    and when running status it gives:
    Code:
    rcmysql status
    
    redirecting to systemctl
    mysql.service - LSB: Start the MySQL database server
              Loaded: loaded (/etc/init.d/mysql)
              Active: failed (Result: exit-code) since Sun, 23 Sep 2012 15:29:04 +0400; 25s ago
             Process: 6087 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)
              CGroup: name=systemd:/system/mysql.service
    
    
    Sep 23 15:28:33 linux-mkzk mysql[6087]: /etc/rc.status: line 57: /dev/stderr: No such device or address
    Sep 23 15:28:34 linux-mkzk mysql[6087]: Will update MySQL now, if you encounter any problems, please read following file:
    Sep 23 15:28:34 linux-mkzk mysql[6087]: /usr/share/doc/packages/mysql-community-server/README.SuSE
    Sep 23 15:28:34 linux-mkzk mysql[6087]: Running protected MySQL...
    Sep 23 15:29:04 linux-mkzk mysql[6087]: error: /var/tmp/mysql-protected.eUAF9G/mysql.sock file didn't appeared...
    Sep 23 15:29:04 linux-mkzk mysql[6087]: Try checking "/var/log/mysql/mysqld-upgrade-run.log"...
    Any help will be much appreciated

  2. #2
    Join Date
    Feb 2009
    Location
    Spain
    Posts
    25,547

    Default Re: mysql fails to start

    On 2012-09-23 13:36, rafisv wrote:

    > Code:
    > --------------------
    > Sep 23 15:29:04 linux-mkzk mysql[6087]: Try checking "/var/log/mysql/mysqld-upgrade-run.log"...
    >
    > --------------------




    --
    Cheers / Saludos,

    Carlos E. R.
    (from 12.1 x86_64 "Asparagus" at Telcontar)

  3. #3

    Default Re: mysql fails to start

    it says
    Code:
    120923  1:53:06 InnoDB: 1.1.8 started; log sequence number 1595675
    ./usr/sbin/mysqld: File './mysql-bin.000006' not found (Errcode: 13)
    120923  1:53:06 [ERROR] Failed to open log (file './mysql-bin.000006', errno 13)
    120923  1:53:06 [ERROR] Could not open log file
    120923  1:53:06 [ERROR] Can't init tc log
    120923  1:53:06 [ERROR] Aborting
    mysql-bin.000006 exists and the size is ~1Gb

  4. #4
    Join Date
    Feb 2009
    Location
    Spain
    Posts
    25,547

    Default Re: mysql fails to start

    On 2012-09-23 15:36, rafisv wrote:
    >
    > it says
    >
    > Code:
    > --------------------
    > 120923 1:53:06 InnoDB: 1.1.8 started; log sequence number 1595675
    > ./usr/sbin/mysqld: File './mysql-bin.000006' not found (Errcode: 13)
    > 120923 1:53:06 [ERROR] Failed to open log (file './mysql-bin.000006', errno 13)
    > 120923 1:53:06 [ERROR] Could not open log file
    > 120923 1:53:06 [ERROR] Can't init tc log
    > 120923 1:53:06 [ERROR] Aborting
    > --------------------
    >
    >
    > mysql-bin.000006 exists and the size is ~1Gb


    Well, that's the problem, but I do not know how to handle it.

    --
    Cheers / Saludos,

    Carlos E. R.
    (from 12.1 x86_64 "Asparagus" at Telcontar)

  5. #5
    Join Date
    Jun 2008
    Location
    Groningen, Netherlands
    Posts
    19,650
    Blog Entries
    14

    Default Re: mysql fails to start

    the file may exist, but it's not in the place mysql is looking for it. Check you /etc/my.cnf for the datadir.

    All this brings me to the question: was this a clean install? Or upgrade from a previous openSUSE version?
    ° Appreciate my reply? Click the star and let me know why.

    ° Perfection is not gonna happen. No way.

    https://en.opensuse.org/openSUSE:Board#Members
    http://en.opensuse.org/User:Knurpht
    http://nl.opensuse.org/Gebruiker:Knurpht

  6. #6

    Default Re: mysql fails to start

    this was upgrade from 12.1
    /etc/my.cnf says
    Code:
    datadir = /var/lib/mysql

  7. #7

    Default Re: mysql fails to start

    permissions in datadir = /var/lib/mysql were root for some files and dirs, changed to mysql:mysql and that fixed the issue

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
  •