Results 1 to 9 of 9

Thread: mysql fails to start on initial installation of new system

  1. #1
    Join Date
    May 2009
    Location
    Iowa, USA
    Posts
    38

    Question mysql fails to start on initial installation of new system

    I just installed a fresh copy of Leap 42.2 a few days ago (minimal x window) as I'm trying to create a webserver for the first time.
    I have been following the SDB Lamp guide to get everything set up.
    When I try to start mysql with
    Code:
    systemctl start mysql
    I get the following:
    Code:
    linux-77k0:~ # systemctl start mysql
    Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
    systemctl satus mysql.service gives:
    Code:
    linux-77k0:~ # systemctl status mysql.service 
    ● mysql.service - MySQL server
       Loaded: loaded (/usr/lib/systemd/system/mysql.service; enabled; vendor preset: disabled)
       Active: activating (start-post) (Result: exit-code) since Sun 2017-08-06 19:11:57 CDT; 12s ago
      Process: 28441 ExecStart=/usr/lib/mysql/mysql-systemd-helper start (code=exited, status=127)
      Process: 28429 ExecStartPre=/usr/lib/mysql/mysql-systemd-helper upgrade (code=exited, status=0/SUCCESS)
      Process: 28419 ExecStartPre=/usr/lib/mysql/mysql-systemd-helper install (code=exited, status=0/SUCCESS)
     Main PID: 28441 (code=exited, status=127);         : 28442 (mysql-systemd-h)
        Tasks: 2 (limit: 512)
       CGroup: /system.slice/mysql.service
               └─control
                 ├─28442 /bin/bash /usr/lib/mysql/mysql-systemd-helper wait
                 └─28496 sleep 1
    
    Aug 06 19:11:57 linux-77k0 systemd[1]: Starting MySQL server...
    Aug 06 19:11:57 linux-77k0 mysql-systemd-helper[28442]: Waiting for MySQL to start
    Aug 06 19:11:57 linux-77k0 mysql-systemd-helper[28441]: /usr/sbin/mysqld: symbol lookup error: /usr/sbin/mysqld: undefined symbol: pcre_stack_guard
    Aug 06 19:11:57 linux-77k0 systemd[1]: mysql.service: Main process exited, code=exited, status=127/n/a
    and the output of journalctl -xe is:
    Code:
    linux-77k0:~ # journalctl -xe
    Aug 06 19:11:56 linux-77k0 systemd[1]: Failed to start MySQL server.
    -- Subject: Unit mysql.service has failed
    -- Defined-By: systemd
    -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
    -- 
    -- Unit mysql.service has failed.
    -- 
    -- The result is failed.
    Aug 06 19:11:56 linux-77k0 systemd[1]: mysql.service: Unit entered failed state.
    Aug 06 19:11:56 linux-77k0 systemd[1]: mysql.service: Failed with result 'exit-code'.
    Aug 06 19:11:57 linux-77k0 systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
    Aug 06 19:11:57 linux-77k0 systemd[1]: Stopped MySQL server.
    -- Subject: Unit mysql.service has finished shutting down
    -- Defined-By: systemd
    -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
    -- 
    -- Unit mysql.service has finished shutting down.
    Aug 06 19:11:57 linux-77k0 systemd[1]: Starting MySQL server...
    -- Subject: Unit mysql.service has begun start-up
    -- Defined-By: systemd
    -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
    -- 
    -- Unit mysql.service has begun starting up.
    Aug 06 19:11:57 linux-77k0 mysql-systemd-helper[28442]: Waiting for MySQL to start
    Aug 06 19:11:57 linux-77k0 mysql-systemd-helper[28441]: /usr/sbin/mysqld: symbol lookup error: /usr/sbin/mysqld: undefined symbol: pcre_stack_guard
    Aug 06 19:11:57 linux-77k0 systemd[1]: mysql.service: Main process exited, code=exited, status=127/n/a
    I'm not sure what either of those are telling me other than a bad symlink?
    I've searched around but most similar problems are from corrupted db after an upgrade.
    This is a fresh install on a freshly installed system.
    Thanks for any help.

  2. #2
    Join Date
    Jun 2008
    Location
    San Diego, Ca, USA
    Posts
    11,144
    Blog Entries
    2

    Default Re: mysql fails to start on initial installation of new system

    1. Before installing a major application and <especially> after a brand new install (unless it's an online install), you should always update your system. Although you should have updated before installing, you can also update your system now. You can do this by executing the following in an elevated browser
    Code:
    zypper up
    Then, try starting your service.

    2. If the above doesn't work, you need to describe or post info about your mysql server... Is it mariadb? Did you install it standalone or as part of the LAMP pattern? How did you install, using YaST Software Manager or zypper referencing a specific package or pattern? Or, did you install as a download from somewhere else like Oracle?

    TSU
    Beginner Wiki Quickstart - https://en.opensuse.org/User:Tsu2/Quickstart_Wiki
    Solved a problem recently? Create a wiki page for future personal reference!
    Learn something new?
    Attended a computing event?
    Post and Share!

  3. #3
    Join Date
    May 2012
    Location
    Finland
    Posts
    2,004

    Default Re: mysql fails to start on initial installation of new system

    Please show us the list of your repositories; zypper lr -d and encase the output in
    Code:
    code!
    tags.

    PCRE issues are almost always related to having added one of the database repos or mixing repositories.
    .: miuku #suse @ irc.freenode.net
    :: miuku@opensuse.org

    .: h​ttps://download.opensuse.org/repositories/home:/Miuku/

  4. #4
    Join Date
    May 2009
    Location
    Iowa, USA
    Posts
    38

    Default Re: mysql fails to start on initial installation of new system

    Until I get home from work I can ssh into it. I'll try letting it update while I'm here.

    zypper lr -d yields:
    Code:
    linux-77k0:~ # zypper lr -d
    #  | Alias                     | Name                                    | Enabled | GPG Check | Refresh | Priority | Type   | URI                                                                      | Service
    ---+---------------------------+-----------------------------------------+---------+-----------+---------+----------+--------+--------------------------------------------------------------------------+--------
     1 | openSUSE-42.2-0           | openSUSE-42.2-0                         | No      | ----      | Yes     |   99     | yast2  | hd:///?device=/dev/disk/by-id/scsi-0PNY_USB_2.0_FD_058F-part4            |
     2 | repo-debug                | openSUSE-Leap-42.2-Debug                | No      | ----      | Yes     |   99     | NONE   | http://download.opensuse.org/debug/distribution/leap/42.2/repo/oss/      |
     3 | repo-debug-non-oss        | openSUSE-Leap-42.2-Debug-Non-Oss        | No      | ----      | Yes     |   99     | NONE   | http://download.opensuse.org/debug/distribution/leap/42.2/repo/non-oss/  |
     4 | repo-debug-update         | openSUSE-Leap-42.2-Update-Debug         | No      | ----      | Yes     |   99     | NONE   | http://download.opensuse.org/debug/update/leap/42.2/oss/                 |
     5 | repo-debug-update-non-oss | openSUSE-Leap-42.2-Update-Debug-Non-Oss | No      | ----      | Yes     |   99     | NONE   | http://download.opensuse.org/debug/update/leap/42.2/non-oss/             |
     6 | repo-non-oss              | openSUSE-Leap-42.2-Non-Oss              | Yes     | (r ) Yes  | Yes     |   99     | yast2  | http://download.opensuse.org/distribution/leap/42.2/repo/non-oss/        |
     7 | repo-oss                  | openSUSE-Leap-42.2-Oss                  | Yes     | (r ) Yes  | Yes     |   99     | yast2  | http://download.opensuse.org/distribution/leap/42.2/repo/oss/            |
     8 | repo-source               | openSUSE-Leap-42.2-Source               | No      | ----      | Yes     |   99     | NONE   | http://download.opensuse.org/source/distribution/leap/42.2/repo/oss/     |
     9 | repo-source-non-oss       | openSUSE-Leap-42.2-Source-Non-Oss       | No      | ----      | Yes     |   99     | NONE   | http://download.opensuse.org/source/distribution/leap/42.2/repo/non-oss/ |
    10 | repo-update               | openSUSE-Leap-42.2-Update               | Yes     | (r ) Yes  | Yes     |   99     | rpm-md | http://download.opensuse.org/update/leap/42.2/oss/                       |
    11 | repo-update-non-oss       | openSUSE-Leap-42.2-Update-Non-Oss       | Yes     | (r ) Yes  | Yes     |   99     | rpm-md | http://download.opensuse.org/update/leap/42.2/non-oss/                   |
    linux-77k0:~ #
    Leap 42.2
    KDE (mostly)

  5. #5
    Join Date
    May 2012
    Location
    Finland
    Posts
    2,004

    Default Re: mysql fails to start on initial installation of new system

    Those repositories look fine.

    Please do;
    zypper se -siv pcre
    and
    zypper se -siv mariadb

    If you are using MySQL Community Edition as opposed to MariaDB, that would be mysql naturally
    .: miuku #suse @ irc.freenode.net
    :: miuku@opensuse.org

    .: h​ttps://download.opensuse.org/repositories/home:/Miuku/

  6. #6
    Join Date
    May 2009
    Location
    Iowa, USA
    Posts
    38

    Default Re: mysql fails to start on initial installation of new system

    Quote Originally Posted by Miuku View Post
    Those repositories look fine.

    Please do;
    zypper se -siv pcre
    and
    zypper se -siv mariadb

    If you are using MySQL Community Edition as opposed to MariaDB, that would be mysql naturally

    I just ran zypper up too, but the outputs are:

    zypper se-siv pcre
    Code:
    linux-77k0:~ # zypper se -siv pcre
    Loading repository data...
    Reading installed packages...
    
    S  | Name           | Type    | Version  | Arch   | Repository
    ---+----------------+---------+----------+--------+--------------------------
    i+ | libpcre1       | package | 8.39-6.1 | x86_64 | openSUSE-Leap-42.2-Update
        name: libpcre1
    i+ | libpcre1       | package | 8.39-6.1 | x86_64 | (System Packages)
        name: libpcre1
    i+ | libpcre1-32bit | package | 8.39-6.1 | x86_64 | openSUSE-Leap-42.2-Update
        name: libpcre1-32bit
    i+ | libpcre1-32bit | package | 8.39-6.1 | x86_64 | (System Packages)
        name: libpcre1-32bit
    i+ | libpcre16-0    | package | 8.39-6.1 | x86_64 | openSUSE-Leap-42.2-Update
        name: libpcre16-0
    i+ | libpcre16-0    | package | 8.39-6.1 | x86_64 | (System Packages)
        name: libpcre16-0
    linux-77k0:~ #
    zypper se -siv mariadb
    Code:
    linux-77k0:~ # zypper se -siv mariadb
    Loading repository data...
    Reading installed packages...
    
    S  | Name                  | Type    | Version        | Arch   | Repository
    ---+-----------------------+---------+----------------+--------+--------------------------
    i  | mariadb               | package | 10.0.30-20.4.1 | x86_64 | openSUSE-Leap-42.2-Update
        name: mariadb
    i  | mariadb               | package | 10.0.30-20.4.1 | x86_64 | (System Packages)
        name: mariadb
    i  | mariadb-client        | package | 10.0.30-20.4.1 | x86_64 | openSUSE-Leap-42.2-Update
        name: mariadb-client
    i  | mariadb-client        | package | 10.0.30-20.4.1 | x86_64 | (System Packages)
        name: mariadb-client
    i  | mariadb-errormessages | package | 10.0.30-20.4.1 | x86_64 | openSUSE-Leap-42.2-Update
        name: mariadb-errormessages
    i  | mariadb-errormessages | package | 10.0.30-20.4.1 | x86_64 | (System Packages)
        name: mariadb-errormessages
    i+ | mariadb-tools         | package | 10.0.30-20.4.1 | x86_64 | openSUSE-Leap-42.2-Update
        name: mariadb-tools
    i+ | mariadb-tools         | package | 10.0.30-20.4.1 | x86_64 | (System Packages)
        name: mariadb-tools
    linux-77k0:~ #
    I also ran zypper se -siv mysql and got:
    Code:
    linux-77k0:~ # zypper se -siv mysql
    Loading repository data...
    Reading installed packages...
    
    S  | Name             | Type    | Version        | Arch   | Repository
    ---+------------------+---------+----------------+--------+--------------------------
    i  | libmysqlclient18 | package | 10.0.30-20.4.1 | x86_64 | openSUSE-Leap-42.2-Update
        name: libmysqlclient18
    i  | libmysqlclient18 | package | 10.0.30-20.4.1 | x86_64 | (System Packages)
        name: libmysqlclient18
    i  | perl-DBD-mysql   | package | 4.021-14.1     | x86_64 | openSUSE-Leap-42.2-Update
        name: perl-DBD-mysql
    i  | perl-DBD-mysql   | package | 4.021-14.1     | x86_64 | (System Packages)
        name: perl-DBD-mysql
    i+ | php7-mysql       | package | 7.0.7-14.6.1   | x86_64 | openSUSE-Leap-42.2-Update
        name: php7-mysql
    i+ | php7-mysql       | package | 7.0.7-14.6.1   | x86_64 | (System Packages)
        name: php7-mysql
    linux-77k0:~ #
    Of course, this is after rebooting from zypper up.
    Leap 42.2
    KDE (mostly)

  7. #7
    Join Date
    Jun 2008
    Location
    San Diego, Ca, USA
    Posts
    11,144
    Blog Entries
    2

    Default Re: mysql fails to start on initial installation of new system

    Is this an initial LAMP installation with nothing configured?
    Or, have you configured anything at all yet?

    A simple search suggests it's likely a bug in one of your libpcre packages, but only if you haven't started to configure anything at all (starting mysql/mariadb for the first time).

    You can try a more recent version (than what is generally available), for example libpcre1 v 8.41 is currently available in the security repo

    https://software.opensuse.org/package/libpcre1

    TSU
    Beginner Wiki Quickstart - https://en.opensuse.org/User:Tsu2/Quickstart_Wiki
    Solved a problem recently? Create a wiki page for future personal reference!
    Learn something new?
    Attended a computing event?
    Post and Share!

  8. #8
    Join Date
    May 2009
    Location
    Iowa, USA
    Posts
    38

    Default Re: mysql fails to start on initial installation of new system

    Quote Originally Posted by tsu2 View Post
    Is this an initial LAMP installation with nothing configured?
    Or, have you configured anything at all yet?

    A simple search suggests it's likely a bug in one of your libpcre packages, but only if you haven't started to configure anything at all (starting mysql/mariadb for the first time).

    You can try a more recent version (than what is generally available), for example libpcre1 v 8.41 is currently available in the security repo

    https://software.opensuse.org/package/libpcre1

    TSU
    After installing the OS I installed the the meta package patterns-openSUSE-lamp_server.
    After that I realized I needed more help so I turned to the guide referenced in my OP.
    Do you think it would be easier to start over? I've literally got no actual data on the server yet, just some sshd configuration and whatever I have done to mysql to tick it off.
    Leap 42.2
    KDE (mostly)

  9. #9
    Join Date
    May 2009
    Location
    Iowa, USA
    Posts
    38

    Thumbs up Re: mysql fails to start on initial installation of new system

    Since I had nothing to lose, I hosed the entire system and just reinstalled. I no longer have the problem and have a fully functioning LAMP server .
    I'm guessing I somehow messed up mysql/mariadb but since I was hadn't any data on the system yet I went for the easy route.
    Leap 42.2
    KDE (mostly)

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
  •