【测试类型：工具功能】【测试版本：master】mysql在线创建复合分区表后reorganize partition，opengauss侧分区未重组，chameleon工具进程中断

【标题描述】:mysql在线创建任意复合分区表(range-hash分区表、range-key分区表、list-hash分区表、list-key分区表)后reorganize partition，执行reorganize partition语句后，opengauss侧分区未重组，chameleon工具进程中断

【操作系统和硬件信息】(查询命令: cat /etc/system-release, uname -a):
![输入图片说明](https://images.gitee.com/uploads/images/2022/0706/142103_f37927aa_10781039.png "屏幕截图.png")
【测试环境】(单机/1主x备x级联备):
单机
【被测功能】:

【测试类型】:

【数据库版本】(查询命令: gaussdb –V):
![输入图片说明](https://images.gitee.com/uploads/images/2022/0706/142120_631d3a51_10781039.png "屏幕截图.png")
【预置条件】:
MySQL5.7.37已安装，opengauss3.0.0已安装，pg_chameleon已安装并且可用
【操作步骤】(请填写详细的操作步骤):
1.开启在线迁移
chameleon start_replica --config config-example --source mysql --debug
2.MySQL侧建表
```
create table t_chameleon_ddl_2301 (
    salary int,
	birthday date
)
partition by range(salary)
	subpartition by hash(year(birthday))
	subpartitions 3
(
	partition p1 values less than (2000),
	partition p2 values less than (3000),
	partition p3 values less than (5000),
	partition p4 values less than (6000),
	partition p5 values less than (8000),
	partition p6 values less than maxvalue
);
```
3.mysql重组分区，查询建表语句
```
alter table t_chameleon_ddl_2301 reorganize partition p1 into (
    partition n0 values less than (1000),
    partition n1 values less than (2000)
);
show create table t_chameleon_ddl_2301;
```
4.opengauss侧查询表分区信息
```
select p.relname,partstrategy,boundaries from pg_partition p,pg_class c where p.parentid=c.oid and c.relname='t_chameleon_ddl_2301';
```
【预期输出】:
1.开启在线迁移成功
2.MySQL建表成功
3.MySQL重组分区成功，建表语句如下：
![输入图片说明](https://images.gitee.com/uploads/images/2022/0706/142827_89d50c0e_10781039.png "屏幕截图.png")
4.opengauss侧查询到表分区重组，一级分区数量增加1个，二级分区数量增加3个
【实际输出】:
1.开启在线迁移成功
2.MySQL建表成功
3.MySQL重组分区成功
4.opengauss侧分区未重组，一级分区和二级分区数量未增加
![输入图片说明](https://images.gitee.com/uploads/images/2022/0706/143018_5e38bf19_10781039.png "屏幕截图.png")
【原因分析】:

【日志信息】(请附上日志文件、截图、coredump信息):
chameleon日志如下：
![输入图片说明](https://images.gitee.com/uploads/images/2022/0706/150207_4bee646c_10781039.png "屏幕截图.png")
![输入图片说明](https://images.gitee.com/uploads/images/2022/0706/150320_2b363d8f_10781039.png "屏幕截图.png")
【测试代码】:

openGauss/openGauss-tools-chameleon

内容风险标识

评论 (10)

openGauss/openGauss-tools-chameleon .gitee-modal { width: 500px !important; }

内容风险标识