租户无法登录得问题

OceanBase 技术问题
#1

尝试登录租户无法登录，显示ERROR 4152(42000): Null value报错信息（版本为OceanBase_CE 4.0.0,0），目前无法登录，请各位大神指教，可能是登录超时得问题？？？

9a6000dbbbb528ce5a1aabca13e6b7b
9a6000dbbbb528ce5a1aabca13e6b7b1920×1440 213 KB

b08ca240fbc3282ef477191093b2377
b08ca240fbc3282ef477191093b23771920×1440 152 KB

#3

参考下这个帖子

OceanBase4.0 租户登录报错Error4152 Null Values2ue5e_gaMTIwMjU5NTAzNC4xNzE0OTc1MTY1_ga_T35KTM57DZ*MTczNTg4MjYwMC40NjMuMS4xNzM1ODk1MDc5LjYwLjAuMA…

image
image1032×374 36 KB

1 个赞
#4

已经采用了相同的办法，但是还是无法解决，修改后报timeout的错误

#5

麻烦发下observer.log

#6

observer.zip (13.5 MB)
采用上面方法的后的observer.log
image

#7

这个报错是1001租户clog空间不足，1002租户合并时空间不足，

1.麻烦发下yaml配置文件
2.df -h 看下磁盘空间情况

[2025-01-05 10:11:50.628463] ERROR [PALF] try_recycle_blocks (palf_env_impl.cpp:766) [738209][T1001_PalfGC][T1001][Y0-0000000000000000-0-0] [lt=1] clog disk space is almost full(total_size(MB)=614, used_size(MB)=583, used_percent(%)=95, warn_size(MB)=491, warn_percent(%)=80, limit_size(MB)=583, limit_percent(%)=95, maximum_used_size(MB)=583, maximum_log_stream=1, oldest_log_stream=1, oldest_timestamp=1735666473646449992) BACKTRACE:0xb61bbbb 0xb60d4f6 0x3d2bb93 0x3d2b871 0x3d2b65c 0x3d2b48e 0x3dc0933 0x3a3a675 0x3a3a29b 0x3a391f1 0xb5fc3ac 0xb5ffbb7 0xb5fa7ea 0x7f6a1c79bf1b 0x7f6a1c6d11c0
[2025-01-05 10:11:50.628519] ERROR [SHARE] alloc_block (ob_local_device.cpp:716) [738372][T1002_MINI_MERG][T1002][YB427F000001-00062AEBA9EF91A4-0-0] [lt=2] Fail to alloc block, (ret=-4184, free_block_cnt_=0, total_block_cnt_=40960) BACKTRACE:0xb61bbbb 0xb60d4f6 0x3c0be9f 0x3c0bba9 0x3c0b9b0 0x3c0b802 0xa8ec31a 0xa8ec068 0x8bdae8d 0x8c8e928 0x8c891b2 0x8c85c90 0x8c84908 0x8c84729 0x95f221d 0x95e465e 0x95f5e89 0x95f55f7 0x95f3dd3 0x962ed0e 0x99df2ec 0x3b0e734 0xb5fc3ac 0xb5ffbb7 0xb5fa7ea 0x7f6a1c79bf1b 0x7f6a1c6d11c0
#8

grep REFRESH_SCHEMA observer.log
发现报错超时相关信息

需要先解决上述clog空间不足问题，然后sys租户设置
alter system set internal_sql_execute_timeout = “2m”;

[2025-01-05 10:11:55.037945] WARN  [SHARE.SCHEMA] refresh_tenant_schema (ob_multi_version_schema_service.cpp:2605) [737704][SerScheQueue0][T0][YB427F000001-00062AEBA4BE5B7D-0-0] [lt=10] fail to get baseline schema version(ret=-4012, ret="OB_TIMEOUT", tenant_id=1001)
[2025-01-05 10:11:55.037954] INFO  [SHARE.SCHEMA] refresh_tenant_schema (ob_multi_version_schema_service.cpp:2674) [737704][SerScheQueue0][T0][YB427F000001-00062AEBA4BE5B7D-0-0] [lt=7] [REFRESH_SCHEMA] end refresh and add schema by tenant(ret=-4012, ret="OB_TIMEOUT", tenant_id=1001, cost=2000453)