Results 1 to 5 of 5

Thread: Unable to start myql on Leap 42.2

  1. #1

    Default Unable to start myql on Leap 42.2

    Following the instructions from here https://en.opensuse.org/SDB:MySQL_installation I installed MySQL.

    mysql --version
    mysql Ver 15.1 Distrib 10.1.21-MariaDB

    Now I try to start the service using rcmysql start. It never succeeds.

    systemctl status mysql shows the following output:

    systemd[1]: Starting MySQL server...
    mysql-systemd-helper[13101]: Waiting for MySQL to start
    mysql-systemd-helper[13100]: /usr/sbin/mysqld: symbol lookup error: /usr/sbin/mysqld: undefined symbol: pcre_stack_guard
    systemd[1]: mysql.service: Main process exited, code=exited, status=127/n/a

    I updated the datadir and changed owner as descirbed in the link.

    How to fix this issue?

    Thanks,
    Supriti

  2. #2

    Default Re: Unable to start myql on Leap 42.2

    Quote Originally Posted by supriti View Post
    mysql-systemd-helper[13100]: /usr/sbin/mysqld: symbol lookup error: /usr/sbin/mysqld: undefined symbol: pcre_stack_guard
    Looks like you have incompatible packages installed.

    What repos are you using?
    Code:
    zypper lr -d
    And where do your mariadb and libpcre1 packages in particular come from?
    Code:
    rpm -qi mariadb libpcre1

  3. #3

    Default Re: Unable to start myql on Leap 42.2

    PS:
    Quote Originally Posted by supriti View Post
    mysql --version
    mysql Ver 15.1 Distrib 10.1.21-MariaDB
    That's not the standard 42.2 package.

    On my 42.2 system:
    Code:
    mysql --version
    mysql  Ver 15.1 Distrib 10.0.29-MariaDB, for Linux (x86_64) using readline 5.1

  4. #4

    Default Re: Unable to start myql on Leap 42.2

    Yes you are right.
    From some forum , I got idea to add this repo to get database: http://download.opensuse.org/reposit...p_42.2/x86_64/
    I removed this repo. I installed MariaDB from standard repo.

    Also I upgraded libpcre1 from 8.33 to 8.39.

    That resolved my issue.

    Thanks,
    Supriti

  5. #5

    Default Re: Unable to start myql on Leap 42.2

    Quote Originally Posted by supriti View Post
    Also I upgraded libpcre1 from 8.33 to 8.39.
    Ok, I think that this was the actual problem then.
    The server:database repo doesn't contain a libpcre package at all, and you apparently did use the repo for 42.2 (according to the URL you posted).
    So probably the newer mariadb from there would work now too.

    But if you don't have any particular reason/need to always get the latest version of mariadb, I would recommend to just stick to the standard package...

Posting Permissions

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