Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-16321

Postinstall script referencing a wrong PATH for /usr/bin/mysql_install_db and better solutions suggestion

Details

    Description

      Hi,
      script referenced by postinstall script is wrong '/usr/scripts/scripts/mysql_install_db':
      mysqld_safe[25030]: The problem could be conflicting information in an external
      mysqld_safe[25030]: my.cnf files. You can ignore these by doing:
      mysqld_safe[25030]:
      mysqld_safe[25030]: shell> /usr/scripts/scripts/mysql_install_db --defaults-file=~/.my.cnf

      Should be '/usr/bin/mysql_install_db'.

      Error was originallly caused by an apparmor old mysqld profile (https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=865534) and:
      mysqld_safe[25030]: #007/usr/sbin/mysqld: Can't read dir of '/etc/mysql/mariadb.conf.d/' (Errcode: 13 "Permission denied")

      Question: is it possible/do we want to - have more intelligent postinstall script that could suggest better solutions?

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          faust Faustin Lammler created issue -
          otto Otto Kekäläinen added a comment -

          I read this but from the top of my head I don't have an approach to suggest.

          otto Otto Kekäläinen added a comment - I read this but from the top of my head I don't have an approach to suggest.
          faust Faustin Lammler made changes -
          Field Original Value New Value
          Summary  Postinstall script referencing a wrong PATH for /usr/bin/mysql_install_db  Postinstall script referencing a wrong PATH for /usr/bin/mysql_install_db and better solutions suggestion
          faust Faustin Lammler added a comment -

          Ok keeping this in my todo list.

          I am also adding this FTR:
          https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=865534

          As suggestion from Michael Schaller seems relevant:
          > After that the retry of the postinst worked but took a while and there
          > wasn't any progress indicator and so some people might get the false
          > impression that the postinst hangs:
          >
          > $ sudo dpkg --configure mariadb-server-10.1 2>&1 | ts
          > Jul 05 05:21:09 Setting up mariadb-server-10.1 (10.1.23-9+deb9u1) ...
          > Jul 05 05:24:31 Created symlink /etc/systemd/system/mysql.service →
          > /lib/systemd/system/mariadb.service.
          > ...
          >
          > It turned out (re-run with strace) that this scans over all the users
          > (and we have a ton of users on the system) and that this can take a
          > while

          > 2) A message should be printed that this might take a while and to be patient.

          faust Faustin Lammler added a comment - Ok keeping this in my todo list. I am also adding this FTR: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=865534 As suggestion from Michael Schaller seems relevant: > After that the retry of the postinst worked but took a while and there > wasn't any progress indicator and so some people might get the false > impression that the postinst hangs: > > $ sudo dpkg --configure mariadb-server-10.1 2>&1 | ts > Jul 05 05:21:09 Setting up mariadb-server-10.1 (10.1.23-9+deb9u1) ... > Jul 05 05:24:31 Created symlink /etc/systemd/system/mysql.service → > /lib/systemd/system/mariadb.service. > ... > > It turned out (re-run with strace) that this scans over all the users > (and we have a ton of users on the system) and that this can take a > while > 2) A message should be printed that this might take a while and to be patient.
          elenst Elena Stepanova made changes -
          Fix Version/s 10.1 [ 16100 ]
          serg Sergei Golubchik made changes -
          Labels systemd
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 87542 ] MariaDB v4 [ 140798 ]
          vlad.radu Vlad Radu made changes -
          Labels systemd foundation systemd

          People

            faust Faustin Lammler
            faust Faustin Lammler
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.