幽幽草
#1
【 使用环境 】 测试环境
【 使用版本 】oceanbase 4.0.0.0
【问题描述】
obclient [oceanbase]> CREATE tenant xctest resource_pool_list=(‘pool_mysql_01’), primary_zone=‘RANDOM’,comment ‘mysql tenant/instance’, charset=‘utf8’ set ob_tcp_invited_nodes=’%’, ob_compatibility_mode=‘mysql’;
ERROR 4263 (HY000): Minor freeze not allowed now
obproxy.log.tar.gz (9.0 MB)
observer.log.tar.gz (6.3 MB)
rootservice.log.tar.gz (1.7 MB)
和顺
#3
提供一下当前集群的配置:
cd /home/admin/oceanbase/etc && strings observer.config.bin
幽幽草
#4
__min_full_resource_pool_memory=2147483648
log_disk_size=64G
min_observer_version=4.0.0.0
enable_syslog_recycle=True
enable_syslog_wf=True
max_syslog_file_count=4
syslog_level=INFO
cluster_id=1
cluster=obcluster
rootservice_list=10.200.124.40:2882:2881
cpu_count=16
system_memory=10G
memory_limit=21G
zone=zone1
devname=eth0
mysql_port=2881
rpc_port=2882
datafile_size=169G
data_dir=/app/observer/store
cpu_quota_concurrency=10
和顺
#5
新建租户对应的规格提供一下看看
select u.* from DBA_OB_UNIT_CONFIGS u join DBA_OB_RESOURCE_POOLS p on u.UNIT_CONFIG_ID=p.UNIT_CONFIG_ID and p.name=‘pool_mysql_01’ \G
幽幽草
#6
obclient [oceanbase]> select u.* from DBA_OB_UNIT_CONFIGS u join DBA_OB_RESOURCE_POOLS p on u.UNIT_CONFIG_ID=p.UNIT_CONFIG_ID and p.name=‘pool_mysql_01’ \G
*************************** 1. row ***************************
UNIT_CONFIG_ID: 1002
NAME: my_unit_config
CREATE_TIME: 2022-11-24 10:52:07.960320
MODIFY_TIME: 2022-11-24 10:52:07.960320
MAX_CPU: 2
MIN_CPU: 2
MEMORY_SIZE: 8589934592
LOG_DISK_SIZE: 10737418240
MAX_IOPS: 10000
MIN_IOPS: 10000
IOPS_WEIGHT: 0
1 row in set (0.006 sec)
和顺
#7
看observer.log日志应该是已知问题,需要部署OB4.0.0.0-bp1版本。