Uploaded image for project: 'Percona XtraDB Cluster'
  1. Percona XtraDB Cluster
  2. PXC-2483

PXC-8.0 upgrade is not initiating mysql_upgrade script if not state transfer

Details

    • Bug
    • Status: Done
    • High
    • Resolution: Fixed
    • 8.0.x
    • 8.0.18-internal
    • None

    Description

      PXC-5.7 version : 5.7.24-26-31.33-debug
      PXC-8.0 version : 8.0.15-5-31.33-debug
      Testcase

      /dev/shm/qa/pxc57/bin/mysqld --no-defaults --defaults-group-suffix=.1 --basedir=/dev/shm/qa/pxc57 --datadir=/dev/shm/qa/node1 --innodb_file_per_table --log-error-verbosity=3 --wsrep-debug=1 --pxc_maint_transition_period=1 --innodb_autoinc_lock_mode=2 --wsrep-provider=/dev/shm/qa/pxc57/lib/libgalera_smm.so --wsrep_cluster_address=gcomm:// --wsrep_node_incoming_address=127.0.0.1 --wsrep_provider_options=gmcast.listen_addr=tcp://127.0.0.1:26108 --wsrep_sst_method=rsync --wsrep_sst_auth=root: --wsrep_node_address=127.0.0.1 --innodb_flush_method=O_DIRECT --core-file --sql-mode=no_engine_substitution --secure-file-priv= --loose-innodb-status-file=1 --log-error=/dev/shm/qa/node1/node1.err --socket=/dev/shm/qa/node1/socket.sock --log-output=none --port=26100 --server-id=11 --wsrep_slave_threads=2 &
      
      /dev/shm/qa/pxc57/bin/mysqld --no-defaults --defaults-group-suffix=.1 --basedir=/dev/shm/qa/pxc57 --datadir=/dev/shm/qa/node2 --innodb_file_per_table --log-error-verbosity=3 --wsrep-debug=1 --pxc_maint_transition_period=1 --innodb_autoinc_lock_mode=2 --wsrep-provider=/dev/shm/qa/pxc57/lib/libgalera_smm.so --wsrep_cluster_address=gcomm://127.0.0.1:26108,gcomm://127.0.0.1:26208 --wsrep_node_incoming_address=127.0.0.1 --wsrep_provider_options=gmcast.listen_addr=tcp://127.0.0.1:26208 --wsrep_sst_method=rsync --wsrep_sst_auth=root: --wsrep_node_address=127.0.0.1 --innodb_flush_method=O_DIRECT --core-file --sql-mode=no_engine_substitution --secure-file-priv= --loose-innodb-status-file=1 --log-error=/dev/shm/qa/node2/node2.err --socket=/dev/shm/qa/node2/socket.sock --log-output=none --port=26200 --server-id=12 --wsrep_slave_threads=2 &
      
      /dev/shm/qa/pxc57/bin/mysqld --no-defaults --defaults-group-suffix=.1 --basedir=/dev/shm/qa/pxc57 --datadir=/dev/shm/qa/node3 --innodb_file_per_table --log-error-verbosity=3 --wsrep-debug=1 --pxc_maint_transition_period=1 --innodb_autoinc_lock_mode=2 --wsrep-provider=/dev/shm/qa/pxc57/lib/libgalera_smm.so --wsrep_cluster_address=gcomm://127.0.0.1:26108,gcomm://127.0.0.1:26208,gcomm://127.0.0.1:26308 --wsrep_node_incoming_address=127.0.0.1 --wsrep_provider_options=gmcast.listen_addr=tcp://127.0.0.1:26308 --wsrep_sst_method=rsync --wsrep_sst_auth=root: --wsrep_node_address=127.0.0.1 --innodb_flush_method=O_DIRECT --core-file --sql-mode=no_engine_substitution --secure-file-priv= --loose-innodb-status-file=1 --log-error=/dev/shm/qa/node3/node3.err --socket=/dev/shm/qa/node3/socket.sock --log-output=none --port=26300 --server-id=13 --wsrep_slave_threads=2 &
      
      
      mysql  -A -uroot -S/dev/shm/qa/node1/socket.sock -e "create user [email protected]'%' identified with  mysql_native_password by 'test';"
      mysql  -A -uroot -S/dev/shm/qa/node1/socket.sock -e "grant all on *.* to [email protected]'%';"
      mysql  -A -uroot -S/dev/shm/qa/node1/socket.sock -e "drop database if exists sbtest;create database sbtest"
      
      
      sysbench /usr/share/sysbench/oltp_insert.lua --mysql-db=sbtest --mysql-user=sysbench --mysql-password=test --db-driver=mysql --mysql-socket=/dev/shm/qa/node1/socket.sock --threads=10 --tables=10 --table-size=1000 prepare
      
      sysbench /usr/share/sysbench/oltp_read_write.lua --mysql-db=sbtest --mysql-user=sysbench --mysql-password=test --db-driver=mysql --mysql-socket=/dev/shm/qa/node1/socket.sock --threads=10 --tables=10 --time=3000 --report-interval=10 run
      
      
      /dev/shm/qa/pxc80/bin/mysqld --no-defaults --defaults-group-suffix=.1 --basedir=/dev/shm/qa/pxc80 --datadir=/dev/shm/qa/node3 --innodb_file_per_table --log-error-verbosity=3 --wsrep-debug=1 --pxc_maint_transition_period=1 --innodb_autoinc_lock_mode=2 --wsrep-provider=/dev/shm/qa/pxc80/lib/libgalera_smm.so --wsrep_cluster_address=gcomm://127.0.0.1:26108,gcomm://127.0.0.1:26208,gcomm://127.0.0.1:26308 --wsrep_node_incoming_address=127.0.0.1 --wsrep_provider_options=gmcast.listen_addr=tcp://127.0.0.1:26308 --wsrep_sst_method=rsync --wsrep_node_address=127.0.0.1 --innodb_flush_method=O_DIRECT --core-file --sql-mode=no_engine_substitution --secure-file-priv= --loose-innodb-status-file=1 --log-error=/dev/shm/qa/node3/node3.err --socket=/dev/shm/qa/node3/socket.sock --log-output=none --port=26300 --server-id=13 --wsrep_slave_threads=2 &
      
      node3:[email protected]> show databases;
      ERROR 1449 (HY000): The user specified as a definer ('mysql.infoschema'@'localhost') does not exist
      node3:[email protected]>
      

      Attachments

        Issue Links

          Activity

            People

              kenn.takara Kenn Takara (Inactive)
              ramesh.sivaraman Ramesh Sivaraman (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 2 days, 7 hours, 5 minutes
                  2d 7h 5m

                  Smart Checklist