执行查询sql报4013No memory or reach tenant memory limit

OceanBase 技术问题
#1

【 使用环境 测试环境
【 OB or 其他组件 】
【 使用版本 】 4.3.5
【问题描述】
问题sql：

SELECT

t.OBJECT_ID,

t.FK_ID,

t.FK_CODE,

t.DATA_ROOT_ID,

t.CREATE_USER,

t4.OBJECT_NAME AS CREATE_USER_DIM_objectName,

t4.OBJECT_CODE AS CREATE_USER_DIM_objectCode,

t4.PATH_NAME AS CREATE_USER_DIM_objectPath,

t.CREATE_TIME,

t.UPDATE_USER,

t6.OBJECT_NAME AS UPDATE_USER_DIM_objectName,

t6.OBJECT_CODE AS UPDATE_USER_DIM_objectCode,

t6.PATH_NAME AS UPDATE_USER_DIM_objectPath,

t.UPDATE_TIME,

t.MODULE_CODE,

t.BILLTYPE_CODE,

t.DATA_STATUS,

t10.OBJECT_NAME AS DATA_STATUS_DIM_objectName,

t10.OBJECT_CODE AS DATA_STATUS_DIM_objectCode,

t.DATA_VERSION,

t.DOC_NUMBER,

t.APPLICATION_ID,

t13.OBJECT_NAME AS APPLICATION_ID_DIM_objectName,

t13.OBJECT_CODE AS APPLICATION_ID_DIM_objectCode,

t13.PATH_NAME AS APPLICATION_ID_DIM_objectPath,

t.APPLICATION_DATE,

t.DEPARTMENT,

t15.OBJECT_NAME AS DEPARTMENT_DIM_objectName,

t15.OBJECT_CODE AS DEPARTMENT_DIM_objectCode,

t15.PATH_NAME AS DEPARTMENT_DIM_objectPath,

t.APPLY_LE,

t16.OBJECT_NAME AS APPLY_LE_DIM_objectName,

t16.OBJECT_CODE AS APPLY_LE_DIM_objectCode,

t.TITLE,

t.AMOUNT,

t.AMOUNT_CURRENCY,

t.APPROVAL_STATUS,

t19.OBJECT_NAME AS APPROVAL_STATUS_DIM_objectName,

t19.OBJECT_CODE AS APPROVAL_STATUS_DIM_objectCode,

t.COMMIT_TIME,

t.APPROVAL_TIME,

t.WF_INSTANCE_ID,

t.CURRENCY_ID,

t23.OBJECT_NAME AS CURRENCY_ID_DIM_objectName,

t23.OBJECT_CODE AS CURRENCY_ID_DIM_objectCode,

t23_exp.SIGN AS CURRENCY_ID_DIM_SIGN,

t.EXCHANGERATE_TYPE,

t24.OBJECT_NAME AS EXCHANGERATE_TYPE_DIM_objectName,

t24.OBJECT_CODE AS EXCHANGERATE_TYPE_DIM_objectCode,

t.AMOUNT_LOCAL,

t.AMOUNT_LOCAL_CURRENCY,

t.AMOUNT_RATE,

t.FIRST_COMMIT_TIME,

t.CURRENCY,

t28.OBJECT_CODE AS CURRENCY_DIM_objectCode,

t28.OBJECT_NAME AS CURRENCY_DIM_objectName,

t.ATTACHMENT,

t.EXPLANATION,

t.IMAGE_STATUS,

t31.OBJECT_CODE AS IMAGE_STATUS_DIM_objectCode,

t31.OBJECT_NAME AS IMAGE_STATUS_DIM_objectName,

t.EBS_VOUCHER,

t.BUDGET_DEPARTMENT,

t33.OBJECT_NAME AS BUDGET_DEPARTMENT_DIM_objectName,

t33.OBJECT_CODE AS BUDGET_DEPARTMENT_DIM_objectCode,

t.IS_PROJECT_BUDGET,

t34.OBJECT_NAME AS IS_PROJECT_BUDGET_DIM_objectName,

t34.OBJECT_CODE AS IS_PROJECT_BUDGET_DIM_objectCode,

t.PROJECT,

t35.NAME AS PROJECT_DATA_MODEL_NAME,

t35.CODE AS PROJECT_DATA_MODEL_CODE,

t.MATTER,

t36.OBJECT_NAME AS MATTER_DIM_objectName,

t36.OBJECT_CODE AS MATTER_DIM_objectCode,

t.OVERSEAS_TRAVEL_TYPE,

t37.OBJECT_NAME AS OVERSEAS_TRAVEL_TYPE_DIM_objectName,

t.PROJECT_MANAGER,

t38.OBJECT_NAME AS PROJECT_MANAGER_DIM_objectName,

t38.OBJECT_CODE AS PROJECT_MANAGER_DIM_objectCode,

t38.PATH_NAME AS PROJECT_MANAGER_DIM_objectPath,

t.RANK,

t39.OBJECT_NAME AS RANK_DIM_objectName,

t.POSITION,

t40.OBJECT_NAME AS POSITION_DIM_objectName,

t.FIXED_CAR_EMP,

t.RB_AMOUNT_LOCAL,

t.RB_AMOUNT_LOCAL_CURRENCY,

t.CLR_AMOUNT_LOCAL,

t.CLR_AMOUNT_LOCAL_CURRENCY,

t.CREDIT_SCORE,

t.PAYMENT_METHOD,

t45.OBJECT_NAME AS PAYMENT_METHOD_DIM_objectName,

t.DEPARTMENT_ATTR,

t46.OBJECT_NAME AS DEPARTMENT_ATTR_DIM_objectName,

t46.OBJECT_CODE AS DEPARTMENT_ATTR_DIM_objectCode,

t.PAYEE_BANK_ACCT,

t.PAY_STATUS,

t48.OBJECT_NAME AS PAY_STATUS_DIM_objectName,

t.ACTUAL_PAYMENT_AMOUNT,

t.ACTUAL_PAYMENT_AMOUNT_CURRENCY,

t.ACTUAL_PAYMENT_DATE,

t.BANK_NUMBER,

t.EXP_PAY_DATE,

t.SIGNAGE,

t53.OBJECT_NAME AS SIGNAGE_DIM_objectName,

t.PAYMENT_CATEGORY,

t54.OBJECT_NAME AS PAYMENT_CATEGORY_DIM_objectName,

t.ACTUAL_PAYMENT_ACCOUNT,

t.ACTUAL_PAYMENT_BANK,

t.ACTUAL_PAYMENT_METHOD,

t57.OBJECT_NAME AS ACTUAL_PAYMENT_METHOD_DIM_objectName,

t.APPLY_NO,

t58.DOC_NUMBER AS APPLY_NO_DATA_MODEL_DOC_NUMBER,

t.RB_AMOUNT,

t.RB_AMOUNT_CURRENCY,

t.CLR_AMOUNT,

t.CLR_AMOUNT_CURRENCY,

t.PAY_AMOUNT,

t.PAY_AMOUNT_CURRENCY,

t.PAY_AMOUNT_LOCAL,

t.PAY_AMOUNT_LOCAL_CURRENCY,

t.NREPAY_AMT_SUM,

t.NREPAY_AMT_SUM_CURRENCY,

t.TRAVEL_REIMB_AMT,

t.TRAVEL_REIMB_AMT_CURRENCY,

t.BUS_REIMB_AMT,

t.BUS_REIMB_AMT_CURRENCY,

t.COST_CENTER1,

t66.OBJECT_NAME AS COST_CENTER1_DIM_objectName,

t66.OBJECT_CODE AS COST_CENTER1_DIM_objectCode,

t.REC_BANK_TYPE,

t67.OBJECT_NAME AS REC_BANK_TYPE_DIM_objectName,

t67.OBJECT_CODE AS REC_BANK_TYPE_DIM_objectCode,

t.REC_ANK_BRANCH,

t68.OBJECT_NAME AS REC_ANK_BRANCH_DIM_objectName,

t68.OBJECT_CODE AS REC_ANK_BRANCH_DIM_objectCode,

t.RCVG_ACCT_NAME,

t69.ACCOUNT_NAME AS RCVG_ACCT_NAME_DATA_MODEL_ACCOUNT_NAME,

t.TRAVEL_REIMB_AMT_LOCAL,

t.TRAVEL_REIMB_AMT_LOCAL_CURRENCY,

t.BUS_REIMB_AMT_LOCAL,

t.BUS_REIMB_AMT_LOCAL_CURRENCY,

t.SUBJECT_SEGMENT1,

t72.OBJECT_NAME AS SUBJECT_SEGMENT1_DIM_objectName,

t72.OBJECT_CODE AS SUBJECT_SEGMENT1_DIM_objectCode,

t.SOURCE_ID,

t.FUND_PLAN_PROJECT,

t74.OBJECT_NAME AS FUND_PLAN_PROJECT_DIM_objectName,

t74.OBJECT_CODE AS FUND_PLAN_PROJECT_DIM_objectCode,

t.REMAINING_USABLE_AMOUNT,

t.REMAINING_USABLE_AMOUNT_CURRENCY,

t.SUPPLIER,

t76.NAME AS SUPPLIER_DATA_MODEL_NAME,

t76.CODE AS SUPPLIER_DATA_MODEL_CODE,

t.ASSIST_DEPARTMENT,

t77.OBJECT_NAME AS ASSIST_DEPARTMENT_DIM_objectName,

t77.OBJECT_CODE AS ASSIST_DEPARTMENT_DIM_objectCode,

t77.PATH_NAME AS ASSIST_DEPARTMENT_DIM_objectPath,

t.CASH_FLOW_INDICATOR,

t78.OBJECT_NAME AS CASH_FLOW_INDICATOR_DIM_objectName,

t78.OBJECT_CODE AS CASH_FLOW_INDICATOR_DIM_objectCode,

t.PLATFORM,

t.IS_IMAGE_PUSHED,

t80.OBJECT_NAME AS IS_IMAGE_PUSHED_DIM_objectName,

t80.OBJECT_CODE AS IS_IMAGE_PUSHED_DIM_objectCode,

t.BUSINESS_SEGMENT1,

t81.OBJECT_NAME AS BUSINESS_SEGMENT1_DIM_objectName,

t81.OBJECT_CODE AS BUSINESS_SEGMENT1_DIM_objectCode,

t.GOVERNMENT_PROJECT,

t82.OBJECT_NAME AS GOVERNMENT_PROJECT_DIM_objectName,

t82.OBJECT_CODE AS GOVERNMENT_PROJECT_DIM_objectCode,

t.PAY_ACCT_NAME,

t.IF_STD_OUT,

t84.OBJECT_NAME AS IF_STD_OUT_DIM_objectName,

t84.OBJECT_CODE AS IF_STD_OUT_DIM_objectCode,

t.IF_BG_OUT,

t85.OBJECT_NAME AS IF_BG_OUT_DIM_objectName,

t85.OBJECT_CODE AS IF_BG_OUT_DIM_objectCode,

t.LINK_BILL,

t86.DOC_NUMBER AS LINK_BILL_DATA_MODEL_DOC_NUMBER,

t.IF_HB,

t87.OBJECT_NAME AS IF_HB_DIM_objectName,

t87.OBJECT_CODE AS IF_HB_DIM_objectCode,

t.HB_TYPE,

t88.OBJECT_NAME AS HB_TYPE_DIM_objectName,

t88.OBJECT_CODE AS HB_TYPE_DIM_objectCode,

t.NUM,

t.TOTAL_CB,

t.TOTAL_CB_CURRENCY

FROM

SWD_MDFP_BUSINESS_EXP t

LEFT JOIN MDFP_BA_DIM_OBJECT t4 ON

t4.TYPE_ID = 44

AND t4.DELETE_FLAG = 0

AND t4.OBJECT_ID = t.CREATE_USER

LEFT JOIN MDFP_BA_DIM_OBJECT t6 ON

t6.TYPE_ID = 44

AND t6.DELETE_FLAG = 0

AND t6.OBJECT_ID = t.UPDATE_USER

LEFT JOIN MDFP_BA_DIM_OBJECT t10 ON

t10.TYPE_ID = 18

AND t10.DELETE_FLAG = 0

AND t10.OBJECT_ID = t.DATA_STATUS

LEFT JOIN MDFP_BA_DIM_OBJECT t13 ON

t13.TYPE_ID = 20

AND t13.DELETE_FLAG = 0

AND t13.OBJECT_ID = t.APPLICATION_ID

LEFT JOIN MDFP_BA_DIM_OBJECT t15 ON

t15.TYPE_ID = 14

AND t15.DELETE_FLAG = 0

AND t15.OBJECT_ID = t.DEPARTMENT

LEFT JOIN MDFP_BA_DIM_OBJECT t16 ON

t16.TYPE_ID = 21

AND t16.DELETE_FLAG = 0

AND t16.OBJECT_ID = t.APPLY_LE

LEFT JOIN MDFP_BA_DIM_OBJECT t19 ON

t19.TYPE_ID = 43

AND t19.DELETE_FLAG = 0

AND t19.OBJECT_ID = t.APPROVAL_STATUS

LEFT JOIN MDFP_BA_DIM_OBJECT t23 ON

t23.TYPE_ID = 27

AND t23.DELETE_FLAG = 0

AND t23.OBJECT_ID = t.CURRENCY_ID

LEFT JOIN DIM_TYPE_BA_CURR_00027 t23_exp ON

t23_exp.OBJECT_ID = t23.OBJECT_ID

LEFT JOIN MDFP_BA_DIM_OBJECT t24 ON

t24.TYPE_ID = 25

AND t24.DELETE_FLAG = 0

AND t24.OBJECT_ID = t.EXCHANGERATE_TYPE

LEFT JOIN MDFP_BA_DIM_OBJECT t28 ON

t28.TYPE_ID = 27

AND t28.DELETE_FLAG = 0

AND t28.OBJECT_ID = t.CURRENCY

LEFT JOIN MDFP_BA_DIM_OBJECT t31 ON

t31.TYPE_ID = 60009097

AND t31.DELETE_FLAG = 0

AND t31.OBJECT_ID = t.IMAGE_STATUS

LEFT JOIN MDFP_BA_DIM_OBJECT t33 ON

t33.TYPE_ID = 1620000637007945728

AND t33.DELETE_FLAG = 0

AND t33.OBJECT_ID = t.BUDGET_DEPARTMENT

LEFT JOIN MDFP_BA_DIM_OBJECT t34 ON

t34.TYPE_ID = 1733041904260538368

AND t34.DELETE_FLAG = 0

AND t34.OBJECT_ID = t.IS_PROJECT_BUDGET

LEFT JOIN MDFP_PROJECT_MASTER_DATA t35 ON

t35.OBJECT_ID = t.PROJECT

AND t35.DELETE_FLAG = 0

LEFT JOIN MDFP_BA_DIM_OBJECT t36 ON

t36.TYPE_ID = 1736633250358976512

AND t36.DELETE_FLAG = 0

AND t36.OBJECT_ID = t.MATTER

LEFT JOIN MDFP_BA_DIM_OBJECT t37 ON

t37.TYPE_ID = 1733041981372817408

AND t37.DELETE_FLAG = 0

AND t37.OBJECT_ID = t.OVERSEAS_TRAVEL_TYPE

LEFT JOIN MDFP_BA_DIM_OBJECT t38 ON

t38.TYPE_ID = 44

AND t38.DELETE_FLAG = 0

AND t38.OBJECT_ID = t.PROJECT_MANAGER

LEFT JOIN MDFP_BA_DIM_OBJECT t39 ON

t39.TYPE_ID = 30

AND t39.DELETE_FLAG = 0

AND t39.OBJECT_ID = t.RANK

LEFT JOIN MDFP_BA_DIM_OBJECT t40 ON

t40.TYPE_ID = 31

AND t40.DELETE_FLAG = 0

AND t40.OBJECT_ID = t.POSITION

LEFT JOIN MDFP_BA_DIM_OBJECT t41 ON

t41.TYPE_ID = 1733041904260538368

AND t41.DELETE_FLAG = 0

AND t41.OBJECT_ID = t.FIXED_CAR_EMP

LEFT JOIN MDFP_BA_DIM_OBJECT t45 ON

t45.TYPE_ID = 5

AND t45.DELETE_FLAG = 0

AND t45.OBJECT_ID = t.PAYMENT_METHOD

LEFT JOIN MDFP_BA_DIM_OBJECT t46 ON

t46.TYPE_ID = 1733038994336309248

AND t46.DELETE_FLAG = 0

AND t46.OBJECT_ID = t.DEPARTMENT_ATTR

LEFT JOIN MDFP_BA_DIM_OBJECT t48 ON

t48.TYPE_ID = 9

AND t48.DELETE_FLAG = 0

AND t48.OBJECT_ID = t.PAY_STATUS

LEFT JOIN MDFP_BA_DIM_OBJECT t53 ON

t53.TYPE_ID = 1733041904260538368

AND t53.DELETE_FLAG = 0

AND t53.OBJECT_ID = t.SIGNAGE

LEFT JOIN MDFP_BA_DIM_OBJECT t54 ON

t54.TYPE_ID = 1733041944358084608

AND t54.DELETE_FLAG = 0

AND t54.OBJECT_ID = t.PAYMENT_CATEGORY

LEFT JOIN MDFP_BA_DIM_OBJECT t57 ON

t57.TYPE_ID = 5

AND t57.DELETE_FLAG = 0

AND t57.OBJECT_ID = t.ACTUAL_PAYMENT_METHOD

LEFT JOIN SWD_MDFP_BUSINESS_APP t58 ON

t58.OBJECT_ID = t.APPLY_NO

AND t58.DELETE_FLAG = 0

LEFT JOIN MDFP_BA_DIM_OBJECT t66 ON

t66.TYPE_ID = 1716285830465478656

AND t66.DELETE_FLAG = 0

AND t66.OBJECT_ID = t.COST_CENTER1

LEFT JOIN MDFP_BA_DIM_OBJECT t67 ON

t67.TYPE_ID = 22

AND t67.DELETE_FLAG = 0

AND t67.OBJECT_ID = t.REC_BANK_TYPE

LEFT JOIN MDFP_BA_DIM_OBJECT t68 ON

t68.TYPE_ID = 1733039545694347264

AND t68.DELETE_FLAG = 0

AND t68.OBJECT_ID = t.REC_ANK_BRANCH

LEFT JOIN MDFP_AB_BANK t69 ON

t69.OBJECT_ID = t.RCVG_ACCT_NAME

AND t69.DELETE_FLAG = 0

LEFT JOIN MDFP_BA_DIM_OBJECT t72 ON

t72.TYPE_ID = 1738127849484390400

AND t72.DELETE_FLAG = 0

AND t72.OBJECT_ID = t.SUBJECT_SEGMENT1

LEFT JOIN MDFP_BA_DIM_OBJECT t74 ON

t74.TYPE_ID = 1733039627860762624

AND t74.DELETE_FLAG = 0

AND t74.OBJECT_ID = t.FUND_PLAN_PROJECT

LEFT JOIN MDFP_AB_BA_SUPPLIER t76 ON

t76.OBJECT_ID = t.SUPPLIER

AND t76.DELETE_FLAG = 0

LEFT JOIN MDFP_BA_DIM_OBJECT t77 ON

t77.TYPE_ID = 14

AND t77.DELETE_FLAG = 0

AND t77.OBJECT_ID = t.ASSIST_DEPARTMENT

LEFT JOIN MDFP_BA_DIM_OBJECT t78 ON

t78.TYPE_ID = 1733039670437142528

AND t78.DELETE_FLAG = 0

AND t78.OBJECT_ID = t.CASH_FLOW_INDICATOR

LEFT JOIN MDFP_BA_DIM_OBJECT t80 ON

t80.TYPE_ID = 1733041904260538368

AND t80.DELETE_FLAG = 0

AND t80.OBJECT_ID = t.IS_IMAGE_PUSHED

LEFT JOIN MDFP_BA_DIM_OBJECT t81 ON

t81.TYPE_ID = 1740210011388153856

AND t81.DELETE_FLAG = 0

AND t81.OBJECT_ID = t.BUSINESS_SEGMENT1

LEFT JOIN MDFP_BA_DIM_OBJECT t82 ON

t82.TYPE_ID = 1733041340613189632

AND t82.DELETE_FLAG = 0

AND t82.OBJECT_ID = t.GOVERNMENT_PROJECT

LEFT JOIN MDFP_BA_DIM_OBJECT t84 ON

t84.TYPE_ID = 1733041904260538368

AND t84.DELETE_FLAG = 0

AND t84.OBJECT_ID = t.IF_STD_OUT

LEFT JOIN MDFP_BA_DIM_OBJECT t85 ON

t85.TYPE_ID = 1733041904260538368

AND t85.DELETE_FLAG = 0

AND t85.OBJECT_ID = t.IF_BG_OUT

LEFT JOIN SWD_MDFP_BUSINESS_EXP t86 ON

t86.OBJECT_ID = t.LINK_BILL

AND t86.DELETE_FLAG = 0

LEFT JOIN MDFP_BA_DIM_OBJECT t87 ON

t87.TYPE_ID = 1733041904260538368

AND t87.DELETE_FLAG = 0

AND t87.OBJECT_ID = t.IF_HB

LEFT JOIN MDFP_BA_DIM_OBJECT t88 ON

t88.TYPE_ID = 1932708936197783552

AND t88.DELETE_FLAG = 0

AND t88.OBJECT_ID = t.HB_TYPE

WHERE

(t.DELETE_FLAG = 0)

ORDER BY

t.OBJECT_ID DESC

LIMIT 10

配置：memstore_limit_percentage：50、memory_limit：6G

1 个赞
#3

麻烦根据下面方法收集一下日志
1）设置trace信息
SET ob_enable_show_trace=‘ON’;

2）执行sql。

3）获取上个命令的trace
select last_trace_id();

4）获取trace对应的节点
select query_sql,svr_ip from gv$ob_sql_audit where trace_id=‘第三步获取的trace信息’；

5）取对应的svr_ip节点 过滤日志
grep “第三步获取的trace信息” observer.log*
grep “第三步获取的trace信息” rootservice.log*

6）提供日志信息即可。

1 个赞
#4

查询一下SQL_AUDIt过滤一下ret_code=’-4013’

1 个赞
#5

内存泄漏

1 个赞
#6

grep “YB427F000001-000637D2AF2FA46C-0-0” observer.log*
observer.log.20250620102850247:[2025-06-20 10:19:43.870177] WDIAG [COMMON] check_stack_overflow (ob_common_utility.cpp:97) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=37][errcode=0] stack possible overflow(cur_stack=0x14c2b499f900, stack_eof=0x14c2b49f7c00, stack_start=0x14c2b4980000, stack_size=490496, reserved_size=131072, cur_stack_used=361216)
observer.log.20250620102850247:[2025-06-20 10:19:43.870225] WDIAG [COMMON] check_stack_overflow (ob_common_utility.cpp:97) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=38][errcode=0] stack possible overflow(cur_stack=0x14c2b499f9e0, stack_eof=0x14c2b49f7c00, stack_start=0x14c2b4980000, stack_size=490496, reserved_size=131072, cur_stack_used=360992)
observer.log.20250620102850247:[2025-06-20 10:19:43.870499] WDIAG [COMMON] check_stack_overflow (ob_common_utility.cpp:97) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=9][errcode=0] stack possible overflow(cur_stack=0x14c2b499f9e0, stack_eof=0x14c2b49f7c00, stack_start=0x14c2b4980000, stack_size=490496, reserved_size=131072, cur_stack_used=360992)
observer.log.20250620102850247:[2025-06-20 10:19:43.873773] WDIAG [COMMON] check_stack_overflow (ob_common_utility.cpp:97) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=22][errcode=0] stack possible overflow(cur_stack=0x14c2b499f900, stack_eof=0x14c2b49f7c00, stack_start=0x14c2b4980000, stack_size=490496, reserved_size=131072, cur_stack_used=361216)
observer.log.20250620102850247:[2025-06-20 10:19:43.873819] WDIAG [COMMON] check_stack_overflow (ob_common_utility.cpp:97) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=26][errcode=0] stack possible overflow(cur_stack=0x14c2b499f9e0, stack_eof=0x14c2b49f7c00, stack_start=0x14c2b4980000, stack_size=490496, reserved_size=131072, cur_stack_used=360992)
observer.log.20250620102850247:[2025-06-20 10:19:43.874121] WDIAG [COMMON] check_stack_overflow (ob_common_utility.cpp:97) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=9][errcode=0] stack possible overflow(cur_stack=0x14c2b499f9e0, stack_eof=0x14c2b49f7c00, stack_start=0x14c2b4980000, stack_size=490496, reserved_size=131072, cur_stack_used=360992)
observer.log.20250620102850247:[2025-06-20 10:19:43.886619] INFO [COMMON] handle (ob_io_struct.cpp:3057) [3458063][T1_DiskCB0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=69] callback runner call handle(get_queue_count()=0, req={is_inited_:true, tenant_id_:1, control_block_:0x14c2d7b23420, ref_cnt_:1, raw_buf_:0x14c23cdc8150, fd_:{first_id:1152921504606967585, second_id:4027, third_id:0, fd_id:-1, slot_version:-1, device_handle:0x14c2db595130}, is_object_device_req():false, trace_id_:YB427F000001-000637D2AF2FA46C-0-0, retry_count_:0, tenant_io_mgr_:{ptr:0x14c2dafd4030}, storage_accesser:{ptr:null}, io_result_:{is_inited_:true, is_finished_:false, is_canceled_:false, has_estimated_:false, complete_size_:20480, offset_:228409, size_:15865, timeout_us_:9968000, result_ref_cnt_:2, out_ref_cnt_:1, flag_:{mode:“READ”, group_id_:0, func_type_:0, wait_event_id_:1, is_sync_:false, is_unlimited_:false, is_detect_:false, is_write_through_:false, is_sealed_:true, is_time_detect_:false, need_close_dev_and_fd_:false, reserved_:0}, ret_code_:{io_ret_:0, fs_errno_:0}, tenant_id_:1, tenant_io_mgr_:{ptr:0x14c2dafd4030}, user_data_buf_:null, buf_:null, io_callback_:0x14c253f86160, time_log:{begin_ts:1750385983880003, enqueue_used:2, dequeue_used:37, submit_used:1, return_used:6540, callback_enqueue_used:7, callback_dequeue_used:26, callback_finish_used:-1, end_used:-1}}, part_id:-1})
observer.log.20250620102850247:[2025-06-20 10:19:44.175927] WDIAG [SQL.RESV] get_bitset_word (ob_raw_expr.h:362) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=25][errcode=-4016] bitmap word index exceeds scope(index=1, desc_.len_=1)
observer.log.20250620102850247:[2025-06-20 10:19:44.528285] WDIAG [SQL.RESV] get_bitset_word (ob_raw_expr.h:362) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=33][errcode=-4016] bitmap word index exceeds scope(index=1, desc_.len_=1)
observer.log.20250620102850247:[2025-06-20 10:19:44.885226] WDIAG [SQL.RESV] get_bitset_word (ob_raw_expr.h:362) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=27][errcode=-4016] bitmap word index exceeds scope(index=1, desc_.len_=1)
observer.log.20250620102850247:[2025-06-20 10:19:45.091391] INFO print_info (ob_kvcache_hazard_domain.cpp:137) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=37] [KVCACHE-HAZARD-POINTER] retired memory size: 0, blocks size: 50, free list size: 2703, memory_efficiency: 0.644012
observer.log.20250620102850247:[2025-06-20 10:19:45.091420] WDIAG print_tenant_memblock_info (ob_kvcache_store.cpp:1131) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=29][errcode=0] [CACHE-SYNC-WASH] len: 4058 tenant sync wash failed, cache memblock info:
observer.log.20250620102850247:[2025-06-20 10:19:45.091432] INFO [COMMON] try_flush_washable_mb (ob_kvcache_store.cpp:826) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=9] can not find enough memory block to wash(ret=-4273, size_washed=0, size_to_wash=6291456)
observer.log.20250620102850247:[2025-06-20 10:19:45.091442] INFO [COMMON] try_flush_washable_mb (ob_kvcache_store.cpp:845) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=8] ObKVCache try flush washable memblock details(ret=-4273, force_flush=false, tenant_id=1, cache_id=-1, size_washed=0, size_to_wash=6291456)
observer.log.20250620102850247:[2025-06-20 10:19:45.091458] WDIAG [COMMON] alloc_chunk (ob_resource_mgr.cpp:66) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=16][errcode=-4273] sync_wash_mbs failed(ret=-4273, tenant_id=1, wash_size=6291456)
observer.log.20250620102850247:[2025-06-20 10:19:45.091465] WDIAG [COMMON] alloc_chunk (ob_resource_mgr.cpp:93) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=7][errcode=-4273] after wash from cache, still can’t alloc chunk from chunk_mgr, maybe alloc by other thread(size=2080768, wash_size=6291456, ret=-4273)
observer.log.20250620102850247:[2025-06-20 10:19:45.091489] WDIAG alloc_block (ob_page_manager.h:139) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=22][errcode=0] oops, alloc failed, tenant_id=1 ctx_id=0 hold=672329728 limit=9223372036854775807
observer.log.20250620102850247:[2025-06-20 10:19:45.091750] INFO sync_wash_ (ob_tenant_ctx_allocator.cpp:442) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=6] [MEM][WASH] tenant_id: 1, ctx_id: 3, washed_size: 4030464
observer.log.20250620102850247:[2025-06-20 10:19:45.247118] INFO [COMMON] try_flush_washable_mb (ob_kvcache_store.cpp:826) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=19] can not find enough memory block to wash(ret=-4273, size_washed=0, size_to_wash=6291456)
observer.log.20250620102850247:[2025-06-20 10:19:45.247147] INFO [COMMON] try_flush_washable_mb (ob_kvcache_store.cpp:845) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=28] ObKVCache try flush washable memblock details(ret=-4273, force_flush=false, tenant_id=1, cache_id=-1, size_washed=0, size_to_wash=6291456)
observer.log.20250620102850247:[2025-06-20 10:19:45.247158] WDIAG [COMMON] alloc_chunk (ob_resource_mgr.cpp:66) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=10][errcode=-4273] sync_wash_mbs failed(ret=-4273, tenant_id=1, wash_size=6291456)
observer.log.20250620102850247:[2025-06-20 10:19:45.247239] WDIAG [COMMON] alloc_chunk (ob_resource_mgr.cpp:93) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=79][errcode=-4273] after wash from cache, still can’t alloc chunk from chunk_mgr, maybe alloc by other thread(size=2080768, wash_size=6291456, ret=-4273)
observer.log.20250620102850247:[2025-06-20 10:19:45.247250] WDIAG alloc_block (ob_page_manager.h:139) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=10][errcode=0] oops, alloc failed, tenant_id=1 ctx_id=0 hold=693301248 limit=9223372036854775807
observer.log.20250620102850247:[2025-06-20 10:19:45.247336] WARN [USING_LOG_PREFIX] print_alloc_failed_msg (alloc_failed_reason.cpp:141) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=13][errcode=-4013] [oops]: alloc failed reason is that tenant memory has reached the upper limit(tenant_id: 1, tenant_hold: 1073475584, tenant_limit: 1073741824, alloc_size: 2097152)
observer.log.20250620102850247:[2025-06-20 10:19:45.247354] WDIAG print_alloc_failed_msg (alloc_failed_reason.cpp:146) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=6][errcode=-4013] [OOPS]: alloc failed reason is that tenant memory has reached the upper limit(tenant_id: 1, tenant_hold: 1073475584, tenant_limit: 1073741824, alloc_size: 2097152). detailed info: tenant_id=1, ctx_id=0, ctx_name=DEFAULT_CTX_ID, ctx_hold=693301248, ctx_limit=9223372036854775807, tenant_hold=1073475584, tenant_limit=1073741824, backtrace=0x269eb08d 0xf9820db 0xf981b06 0x930769b 0x9305f66 0x93039a3 0x92f50f3 0x16a44cd9 0x16a39fd5 0x16a27ae7 0x9af74fb 0x16aa5ba7 0x1902ad82 0x9831d33 0x98309f8 0x18ed3f4e 0x1489e3ce 0x9a3be9d 0x9a1e6ae 0x9a1b8b6 0x92cad2e 0x928a579 0x927df13 0x9276fad 0x9264154 0x12c511b9 0x2665ebd2 0x14c2f2ba9f1b 0x14c2f2adf320
observer.log.20250620102850247:[2025-06-20 10:19:45.247371] WDIAG alloc_new_page (page_arena.h:331) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=9][errcode=-4013] cannot allocate memory.sz=245760, pages_=829,total_=204172384
observer.log.20250620102850247:[2025-06-20 10:19:45.247377] WDIAG extend_page (page_arena.h:356) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=6][errcode=-4013] extend_page sz =245760 cannot alloc new page
observer.log.20250620102850247:[2025-06-20 10:19:45.247383] WDIAG [SQL.OPT] inner_generate_join_order (ob_log_plan.cpp:2363) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=5][errcode=-4013] failed to create join tree(ret=-4013)
observer.log.20250620102850247:[2025-06-20 10:19:45.247390] WDIAG [SQL.OPT] generate_single_join_level_with_DP (ob_log_plan.cpp:2246) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=6][errcode=-4013] failed to generate join order(level=2, ret=-4013)
observer.log.20250620102850247:[2025-06-20 10:19:45.247398] WDIAG [SQL.OPT] do_one_round_idp (ob_log_plan.cpp:1927) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=7][errcode=-4013] failed to generate join order with dynamic program(ret=-4013)
observer.log.20250620102850247:[2025-06-20 10:19:45.247404] WDIAG [SQL.OPT] inner_generate_join_levels_with_IDP (ob_log_plan.cpp:1851) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=6][errcode=-4013] failed to do idp internal(ret=-4013)
observer.log.20250620102850247:[2025-06-20 10:19:45.247414] WDIAG [SQL.OPT] generate_join_levels_with_IDP (ob_log_plan.cpp:1767) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=5][errcode=-4013] failed to generate join level in generate_join_orders(ret=-4013, join_level=45)
observer.log.20250620102850247:[2025-06-20 10:19:45.247420] WDIAG [SQL.OPT] generate_join_orders (ob_log_plan.cpp:363) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=6][errcode=-4013] failed to generate join levels with dynamic program(ret=-4013)
observer.log.20250620102850247:[2025-06-20 10:19:45.247434] WDIAG [SQL.OPT] generate_plan_tree (ob_log_plan.cpp:7100) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=6][errcode=-4013] failed to generate the access path for the single-table query(ret=-4013, get_optimizer_context().get_query_ctx()->get_sql_stmt()=/* ApplicationName=DBeaver 23.0.5 - SQLEditor <Script-61.sql> / – EXPLAIN extended
observer.log.20250620102850247:[2025-06-20 10:19:45.247485] WDIAG [SQL.OPT] generate_raw_plan_for_plain_select (ob_select_log_plan.cpp:5480) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=49][errcode=-4013] failed to generate plan tree for plain select(ret=-4013)
observer.log.20250620102850247:[2025-06-20 10:19:45.247493] WDIAG [SQL.OPT] generate_raw_plan (ob_log_plan.cpp:11516) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=8][errcode=-4013] fail to generate normal raw plan(ret=-4013)
observer.log.20250620102850247:[2025-06-20 10:19:45.247498] WDIAG [SQL.OPT] generate_plan (ob_log_plan.cpp:11473) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=5][errcode=-4013] fail to generate raw plan(ret=-4013)
observer.log.20250620102850247:[2025-06-20 10:19:45.247504] WDIAG [SQL.OPT] optimize (ob_optimizer.cpp:53) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=5][errcode=-4013] failed to perform optimization(ret=-4013)
observer.log.20250620102850247:[2025-06-20 10:19:45.247514] WDIAG [SQL] optimize_stmt (ob_sql.cpp:3861) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=8][errcode=-4013] Failed to optimize logical plan(ret=-4013)
observer.log.20250620102850247:[2025-06-20 10:19:45.247530] WDIAG [SQL] generate_plan (ob_sql.cpp:3489) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=16][errcode=-4013] Failed to optimizer stmt(ret=-4013)
observer.log.20250620102850247:[2025-06-20 10:19:45.247536] INFO [SQL] generate_plan (ob_sql.cpp:3542) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=5] [SQL MEM USAGE] use too much memory(total_mem_used=204172384, ObString(parse_result.input_sql_len_, parse_result.input_sql_)=/ ApplicationName=DBeaver 23.0.5 - SQLEditor <Script-61.sql> / – EXPLAIN extended
observer.log.20250620102850247:[2025-06-20 10:19:45.247966] WDIAG [SQL] generate_physical_plan (ob_sql.cpp:3276) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=8][errcode=-4013] failed to generate plan(ret=-4013)
observer.log.20250620102850247:[2025-06-20 10:19:45.247995] WDIAG [SQL] handle_physical_plan (ob_sql.cpp:5264) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=19][errcode=-4013] Failed to generate plan(ret=-4013, result.get_exec_context().need_disconnect()=false)
observer.log.20250620102850247:[2025-06-20 10:19:45.248011] WDIAG [SQL] handle_text_query (ob_sql.cpp:2829) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=14][errcode=-4013] fail to handle physical plan(ret=-4013)
observer.log.20250620102850247:[2025-06-20 10:19:45.248023] WDIAG [SQL] stmt_query (ob_sql.cpp:174) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=7][errcode=-4013] fail to handle text query(stmt=/ ApplicationName=DBeaver 23.0.5 - SQLEditor <Script-61.sql> / – EXPLAIN extended
observer.log.20250620102850247:[2025-06-20 10:19:45.248045] WDIAG [SERVER] after_func (ob_query_retry_ctrl.cpp:1076) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=16][errcode=-4013] [RETRY] check if need retry(v={force_local_retry:false, stmt_retry_times:0, local_retry_times:0, err_:-4013, err_:“OB_ALLOCATE_MEMORY_FAILED”, retry_type:0, client_ret:-4013}, need_retry=false)
observer.log.20250620102850247:[2025-06-20 10:19:45.248066] WDIAG [SERVER] do_process (obmp_query.cpp:1090) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=19][errcode=-4013] run stmt_query failed, check if need retry(ret=-4013, cli_ret=-4013, retry_ctrl_.need_retry()=0, sql=/ ApplicationName=DBeaver 23.0.5 - SQLEditor <Script-61.sql> / – EXPLAIN extended
observer.log.20250620102850247:[2025-06-20 10:19:45.248086] WDIAG [SERVER] do_process (obmp_query.cpp:1216) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=17][errcode=-4013] query failed(ret=-4013, session={this:0x14c277817338, id:3221606548, deser:false, tenant:“sys”, tenant_id:1, effective_tenant:“sys”, effective_tenant_id:1, database:“idp”, user:“root@%”, consistency_level:3, session_state:2, autocommit:true, tx:0x14c2ad2923e0}, sql=/ ApplicationName=DBeaver 23.0.5 - SQLEditor <Script-61.sql> */ – EXPLAIN extended
observer.log.20250620102850247:[2025-06-20 10:19:45.248133] INFO [SERVER] send_error_packet (obmp_packet_sender.cpp:376) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=34] sending error packet(ob_error=-4013, client error=-4013, extra_err_info=NULL, lbt()=“0x269eb08d 0x12ee4200 0x12e8b79c 0x9292d25 0x927df13 0x9276fad 0x9264154 0x12c511b9 0x2665ebd2 0x14c2f2ba9f1b 0x14c2f2adf320”)
observer.log.20250620102850247:[2025-06-20 10:19:45.248166] WDIAG [SQL] move_to_sqlstat_cache (ob_sql_stat_record.cpp:366) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=17][errcode=0] the key is not valid which at plan cache mgr(ret=0, ret=“OB_SUCCESS”)
observer.log.20250620102850247:[2025-06-20 10:19:45.248443] WDIAG [SQL.PC] common_free (ob_lib_cache_object_manager.cpp:139) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=15][errcode=0] set logical del time(cache_obj->get_logical_del_time()=1294275768699, cache_obj->added_lc()=false, cache_obj->get_object_id()=421659, cache_obj->get_tenant_id()=1, lbt()=“0x269eb08d 0x153b034e 0x929a61c 0x928bdd5 0x927df13 0x9276fad 0x9264154 0x12c511b9 0x2665ebd2 0x14c2f2ba9f1b 0x14c2f2adf320”)
observer.log.20250620102850247:[2025-06-20 10:19:45.248614] WDIAG [SERVER.OMT] process_one (ob_worker_processor.cpp:82) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=5][errcode=-4013] process request fail(ret=-4013)
observer.log.20250620102850247:[2025-06-20 10:19:45.248625] WDIAG [SERVER.OMT] process (ob_worker_processor.cpp:160) [3458128][T1_L0_G0][T1][YB427F000001-000637D2AF2FA46C-0-0] [lt=10][errcode=-4013] process request fail(ret=-4013)

1 个赞
#7

租户内存规格是多大的。建议不要使用sys租户进行测试sql

1 个赞
#8

memory_limit设的6G

1 个赞
#9

学习，总结经验 :+1: :+1: :+1:

#10

oceanbase有连表查询的上限吗？

#11

返回多少行的数据，返回数据量很大？