租户 table history 过多导致重启时 schema 刷新报错 -4013 的原因及解决方法

select tenant_id, count(*) from oceanbase.__all_virtual_table_history group by 1 having count(*) > 4000000;

select tenant_id, count(*) from oceanbase.__all_virtual_table group by 1 having count(*) > 2500000;

[2023-09-06 22:23:43.636622] WARN  common_alloc (ob_tenant_ctx_allocator.cpp:427) [9959][SerScheQueue1][T0][xxxxx-xxxxx-xxxxx-xxxxx] [lt=5][errcode=-4013] No memory or reach tenant memory limit([OOPS]="alloc failed reason", msg=single alloc size large than 4G is not allowed(alloc_size: 10223120000))
[2023-09-06 22:23:43.636631] WDIAG common_alloc (ob_tenant_ctx_allocator.cpp:432) [9959][SerScheQueue1][T0][xxxxx-xxxxx-xxxxx-xxxxx] [lt=7][errcode=-4013] oops, alloc failed, tenant_id=500, ctx_id=0, ctx_name=DEFAULT_CTX_ID, ctx_hold=6026690560, ctx_limit=9223372036854775807, tenant_hold=6340599808, tenant_limit=9223372036854775807

-- 若二语句查询有值，集群为未修复版本时，重启有风险
select tenant_id, count(*) from oceanbase.__all_virtual_table_history group by 1 having count(*) > 4000000;

select tenant_id, count(*) from oceanbase.__all_virtual_table group by 1 having count(*) > 2500000;