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

PXC-8.0 upgrade is failing with SIG 6 assertion if the donor has encrypted table

Details

    • Bug
    • Status: Done
    • High
    • Resolution: Done
    • 8.0.15-experimental
    • None
    • None

    Description

      Error Info : Assertion failure: os0file.cc:8995:strlen(srv_uuid) != 0

      PXC-5.7 version : 5.7.25-28-31.35-debug
      PXC-8.0 version : 8.0.15-5-31.33-debug

      Testcase

      ./pxc57/bin/mysqld --no-defaults --initialize-insecure --datadir=/dev/shm/qa/node1
      ./pxc57/bin/mysqld --no-defaults --initialize-insecure --datadir=/dev/shm/qa/node2
      ./pxc57/bin/mysqld --no-defaults --initialize-insecure --datadir=/dev/shm/qa/node3
      
      ./pxc57/bin/mysqld --defaults-file=/dev/shm/qa/pxc57_n1.cnf --wsrep-new-cluster &
      ./pxc57/bin/mysqld --defaults-file=/dev/shm/qa/pxc57_n2.cnf &
      ./pxc57/bin/mysqld --defaults-file=/dev/shm/qa/pxc57_n3.cnf &
      
      Login to session node1:
      
      create database test;
      use test;
      CREATE TABLE `sbtest1` (
         `id` int(11) NOT NULL AUTO_INCREMENT,
         `k` int(11) NOT NULL DEFAULT '0',
         `c` char(120) NOT NULL DEFAULT '',
         `pad` char(60) NOT NULL DEFAULT '',
         PRIMARY KEY (`id`),
         KEY `k_1` (`k`)
       ) ENGINE=InnoDB;
      
      alter table sbtest1 encryption='y';
      
      CREATE TABLESPACE test_gen_ts1 ADD DATAFILE 'test_gen_ts1.ibd' ENCRYPTION='Y';
      
      alter table sbtest1 tablespace=test_gen_ts1;
      
      insert into sbtest1 values(1,222,'b','aaaaaaaaaaa');
      
      /dev/shm/qa/pxc57/bin/mysqladmin -uroot -S/dev/shm/qa/node3/socket.sock shutdown
      
      Login to session node1:
      
      insert into test.sbtest1 values(2,222,'b','aaaaaaaaaaa');
      
      ./pxc80/bin/mysqld --defaults-file=/dev/shm/qa/pxc80_n3.cnf &
      

      Attached config file and error log.

      Attachments

        1. pxc80_n3.cnf
          1 kB
        2. pxc57_n3.cnf
          1 kB
        3. pxc57_n2.cnf
          1 kB
        4. pxc57_n1.cnf
          1 kB
        5. node3.err
          50 kB

        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 hours, 24 minutes
                  2h 24m

                  Smart Checklist