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

mariadb-upgrade fails with 'System table spider_tables is different version' => Can't create database 'performance_schema'

Details

    Description

      e.g. upgrade 10.2 -> latest 10.6

      Phase 4/7: Running 'mysql_fix_privilege_tables'
      		 
      ERROR 12609 (HY000) at line 786: System table spider_tables is different version
      		 
      ERROR 12609 (HY000) at line 805: System table spider_tables is different version
      		 
      ERROR 1007 (HY000) at line 810: Can't create database 'performance_schema'; database exists

      Attachments

        Issue Links

          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29870 Backport fixes to spider init bugs to 10.4-10.6 once they have SQL service

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22979 "mysqld --bootstrap" / mysql_install_db hangs when Spider is installed

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27233 Server hangs when using --init-file which loads Spider and creates a Spider table

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            Transition Time In Source Status Execution Times
            Elena Stepanova made transition -
            Open Confirmed
            		1d 21h 6m 1
            Nayuta Yanagisawa (Inactive) made transition -
            Confirmed In Progress
            		77d 15h 34m 1
            Yuchen Pei made transition -
            Stalled In Progress
            		457d 12h 53m 2
            Yuchen Pei made transition -
            In Progress Stalled
            		176d 8h 15m 3
            Yuchen Pei made transition -
            Stalled Closed
            		48d 23h 9m 1

            People

              ycp Yuchen Pei
              tturenko Timofey Turenko
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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