shell报错
alter tenant test set primary_zone=‘RANDOM’;
ERROR 1235 (0A000): tenant primary zone span regions not supported
ocp操作操作
操作OB失败，错误信息: (conn=3221490606) tenant primary zone span regions not supported
1 个赞
部署的架构、OB版本是什么样的呢？
可以先查下zone的设置看看吗？__all_server
mysql> select * from oceanbase.__all_server;
±---------------------------±---------------------------±--------------±---------±—±------±-----------±----------------±-------±----------------------±------------------------------------------------------------------------------------------±----------±-------------------±-------------±---------------+
| gmt_create | gmt_modified | svr_ip | svr_port | id | zone | inner_port | with_rootserver | status | block_migrate_in_time | build_version | stop_time | start_service_time | first_sessid | with_partition |
±---------------------------±---------------------------±--------------±---------±—±------±-----------±----------------±-------±----------------------±------------------------------------------------------------------------------------------±----------±-------------------±-------------±---------------+
| 2022-12-05 19:33:57.017685 | 2023-01-10 02:05:45.940036 | 192.168.3.100 | 2882 | 1 | zone1 | 2881 | 1 | ACTIVE | 0 | 4.0.0.0_100000282022112511-dd289d2407609a88b1fcdf2be9e7c384cb8e19d0(Nov 25 2022 11:58:08) | 0 | 1672987220075688 | 0 | 1 |
| 2022-12-05 19:33:57.804307 | 2023-01-10 02:05:45.905687 | 192.168.3.101 | 2882 | 3 | zone3 | 2881 | 0 | ACTIVE | 0 | 4.0.0.0_100000282022112511-dd289d2407609a88b1fcdf2be9e7c384cb8e19d0(Nov 25 2022 11:58:08) | 0 | 1672987473527131 | 0 | 1 |
| 2022-12-05 19:33:58.485947 | 2023-01-10 02:08:49.360053 | 192.168.3.98 | 2882 | 2 | zone2 | 2881 | 0 | ACTIVE | 0 | 4.0.0.0_100000282022112511-dd289d2407609a88b1fcdf2be9e7c384cb8e19d0(Nov 25 2022 11:58:08) | 0 | 1672987359558721 | 0 | 1 |
±---------------------------±---------------------------±--------------±---------±—±------±-----------±----------------±-------±----------------------±------------------------------------------------------------------------------------------±----------±-------------------±-------------±---------------+
3 rows in set (0.15 sec)
您创建的tenant语句是什么样的？OB的版本是哪个？我这边测一下先
这个提示很清楚， primary-zone 跨 region 了，这个不允许。改为具体的多数派所在的 region 里的一个或多个 zone。
测试可以参考这个。
没显示全，可以重查一下。
select * from __all_zone where name in ('idc','region','status');
