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

Mariadb segv in acl_reload in start after upgrade

Details

    Description

      ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=dumped, signal=SEGV)

      Attachments

        1. error.log
          4 kB
        2. mariadb-daemon.log
          30 kB
        3. mariadb-err.txt
          13 kB
        4. my.cnf
          11 kB
        5. mysql.conf.old
          8 kB
        6. mysql-upgrade--force.err
          7 kB
        7. table-mysql.err
          2 kB

        Activity

          You need definitions from MariaDB 10.x (whichever x you are using now, 10.7 or 10.6 or something else). E.g. for 10.7 you can find them here https://github.com/MariaDB/server/blob/2092881984117b9e10b5d2afc8d387ec90199287/scripts/mysql_system_tables.sql , same idea for 10.6.

          The easier way could be after dropping the tables to re-run mysql_upgrade (with --force if necessary), it should re-create the missing tables.

          elenst Elena Stepanova added a comment - You need definitions from MariaDB 10.x (whichever x you are using now, 10.7 or 10.6 or something else). E.g. for 10.7 you can find them here https://github.com/MariaDB/server/blob/2092881984117b9e10b5d2afc8d387ec90199287/scripts/mysql_system_tables.sql , same idea for 10.6. The easier way could be after dropping the tables to re-run mysql_upgrade (with --force if necessary), it should re-create the missing tables.

          Done, but with errors.
          mysql-upgrade--force.err

          michal25 Michal Vymazal added a comment - Done, but with errors. mysql-upgrade--force.err

          They didn't get dropped properly then.

          elenst Elena Stepanova added a comment - They didn't get dropped properly then.

          mysql> flush tables;

          is not helping.

          But I can start the mariadb environment without the

          /etc/mysql/my.cnf
          [mysqld]
          skip-grant-tables

          Thank you very much!

          michal25 Michal Vymazal added a comment - mysql> flush tables; is not helping. But I can start the mariadb environment without the /etc/mysql/my.cnf [mysqld] skip-grant-tables Thank you very much!

          SOLVED!

          systemctl stop mysql
          manually deleted all the broken database tables in
          /var/lib/mysql/mysql

          systemctl start mysql

          mysql_upgrade -u root -p --force

          Phase 4/7: Running 'mysql_fix_privilege_tables'
          Phase 5/7: Fixing table and database names
          Phase 6/7: Checking and upgrading tables
          Processing databases
          .....
          Phase 7/7: Running 'FLUSH PRIVILEGES'
          OK

          Broken tables in /var/lib/mysql/mysql
          has been recreated and mariadb is working fine.

          michal25 Michal Vymazal added a comment - SOLVED! systemctl stop mysql manually deleted all the broken database tables in /var/lib/mysql/mysql systemctl start mysql mysql_upgrade -u root -p --force Phase 4/7: Running 'mysql_fix_privilege_tables' Phase 5/7: Fixing table and database names Phase 6/7: Checking and upgrading tables Processing databases ..... Phase 7/7: Running 'FLUSH PRIVILEGES' OK Broken tables in /var/lib/mysql/mysql has been recreated and mariadb is working fine.

          People

            Unassigned Unassigned
            michal25 Michal Vymazal
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.