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

            Ascending order - Click to sort in descending order
            tturenko Timofey Turenko created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            Assignee Elena Stepanova [ elenst ]
            elenst Elena Stepanova made changes -
            Description e.g. upgrade 10.2 -> latest 10.6 https://mdbe-buildbot.mariadb.net/#/builders/152/builds/1548
            {noformat}
            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
            {noformat}


            another example https://mdbe-buildbot.mariadb.net/#/builders/150/builds/1356             		e.g. upgrade 10.2 -> latest 10.6
            {noformat}
            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
            {noformat}
            elenst Elena Stepanova made changes -
            Component/s Storage Engine - Spider [ 10132 ]
            Component/s Upgrades [ 15807 ]
            Component/s Upgrades [ 16825 ]
            Key MENT-1363 MDEV-27103
            Issue Type Task [ 3 ] Bug [ 1 ]
            Project MariaDB Enterprise [ 11500 ] MariaDB Server [ 10000 ]
            elenst Elena Stepanova made changes -
            Fix Version/s 10.5 [ 23123 ]
            Fix Version/s 10.6 [ 24028 ]
            Fix Version/s 10.7 [ 24805 ]
            Affects Version/s 10.5 [ 23123 ]
            Affects Version/s 10.6 [ 24028 ]
            Affects Version/s 10.7 [ 24805 ]
            Assignee Elena Stepanova [ elenst ] Nayuta Yanagisawa [ JIRAUSER47117 ]
            elenst Elena Stepanova made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            elenst Elena Stepanova made changes -
            Summary mariadb-upgrade fails Can't create database 'performance_schema' mariadb-upgrade fails with 'System table spider_tables is different version' => Can't create database 'performance_schema'
            julien.fritsch Julien Fritsch made changes -
            Labels affects-tests
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 127872 ] MariaDB v4 [ 144431 ]
            julien.fritsch Julien Fritsch made changes -
            Priority Major [ 3 ] Critical [ 2 ]
            nayuta-yanagisawa Nayuta Yanagisawa (Inactive) made changes -
            Status Confirmed [ 10101 ] In Progress [ 3 ]
            nayuta-yanagisawa Nayuta Yanagisawa (Inactive) made changes -
            nayuta-yanagisawa Nayuta Yanagisawa (Inactive) made changes -
            Fix Version/s 10.4 [ 22408 ]
            Affects Version/s 10.4 [ 22408 ]
            nayuta-yanagisawa Nayuta Yanagisawa (Inactive) made changes -
            nayuta-yanagisawa Nayuta Yanagisawa (Inactive) made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]
            nayuta-yanagisawa Nayuta Yanagisawa (Inactive) made changes -
            nayuta-yanagisawa Nayuta Yanagisawa (Inactive) made changes -
            nayuta-yanagisawa Nayuta Yanagisawa (Inactive) made changes -
            nayuta-yanagisawa Nayuta Yanagisawa (Inactive) made changes -
            nayuta-yanagisawa Nayuta Yanagisawa (Inactive) made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            nayuta-yanagisawa Nayuta Yanagisawa (Inactive) made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]
            ycp Yuchen Pei made changes -
            Assignee Nayuta Yanagisawa [ JIRAUSER47117 ] Yuchen Pei [ JIRAUSER52627 ]
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 10.7 [ 24805 ]
            ycp Yuchen Pei made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            ycp Yuchen Pei made changes -
            ycp Yuchen Pei made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]
            ycp Yuchen Pei made changes -
            ycp Yuchen Pei made changes -
            ycp Yuchen Pei made changes -
            Fix Version/s 10.4.33 [ 29516 ]
            Fix Version/s 10.4 [ 22408 ]
            Fix Version/s 10.5 [ 23123 ]
            Fix Version/s 10.6 [ 24028 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            JIraAutomate JiraAutomate made changes -
            Fix Version/s 10.5.24 [ 29517 ]
            Fix Version/s 10.6.17 [ 29518 ]
            Fix Version/s 10.11.7 [ 29519 ]
            Fix Version/s 11.0.5 [ 29520 ]
            Fix Version/s 11.1.4 [ 29024 ]
            Fix Version/s 11.2.3 [ 29521 ]

            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.