报错【4016 - Internal error】

OceanBase 技术问题
#1

【 使用环境 】生产环境
【 OB or 其他组件 】OB
【 使用版本 】4.1.0
【问题描述】我们测试时，遇到一个问题，同样一个sql，通过obclient连接2881端口时执行没有问题，而用2883端口报错【4016 - Internal error】，这是为啥呢
【复现路径】问题出现前后相关操作
【问题现象及影响】

【附件】

#3

是只有这个特定sql吗？还是所有的sql通过2883执行都报错？把报错日志发出来

#4

不是所有，只有个别的sql
日志怎么看呢

#5

就是这个语句执行报错打印了什么

#6

日志和SQL语句，上一波瞅瞅

#7

ERROR 4016 (HY000): Internal error

#8

sql语句如下:

SELECT
		a.school_term_id ,
		h.his_obj_half_year ,
		kpi.YS ,
		kpi.YS_name ,
		kpi.YS_show_seq ,
		kpi.GCD ,
		kpi.GCD_name ,
		kpi.GCD_show_seq ,
		kpi.YZ ,
		kpi.YZ_name ,
		kpi.YZ_show_seq ,
		avg( a.score ) 得分,
		avg( a.score * 20 ) 得分（五转百分）,
		og.diag_obj_id ,
		og.diag_obj_name ,
		og.show_seq  
	FROM
		dw_naire_number_answer_tician_obj_yz_avg a
		JOIN dw_diag_obj o ON a.diag_obj_id = o.diag_obj_id
		JOIN dw_tician_grade g ON a.diagnostician_id = g.diagnostician_id
		JOIN dw_diagnostician d ON a.diagnostician_id = d.diagnostician_id
		JOIN dw_diag_obj_time_his h ON h.his_obj_id = g.grade_id
		JOIN dw_diag_obj og ON og.diag_obj_id = h.diag_obj_id
		JOIN v_diag_kpi kpi ON kpi.YZ = a.YZ
		JOIN dw_school_term st ON st.school_term_id = a.school_term_id
		JOIN dw_diag_obj_rpt_tag rt ON rt.diag_obj_id = o.diag_obj_id 
	WHERE
		o.school_term_id IN ( '2311', '2021' ) 
		AND o.school_code = 'sccdsslz' 
		AND a.school_code = 'sccdsslz' 
		AND a.school_term_id IN ( '2311', '2021' ) 
		AND a.school_term_id = o.school_term_id 
		AND o.diag_obj_type_id IN ( 'XX' ) 
		AND d.diagnostician_type_id IN ( 'XS' ) 
		AND rt.rpt_tag IN ( '全部' ) 
		AND og.school_code = 'sccdsslz' 
		AND og.school_term_id = '2311' 
		AND a.diag_module = '基础诊断' 
	GROUP BY
		a.school_term_id,
		kpi.yz,
		og.diag_obj_id
#9

通过trace id 把相关的日志都捞下，记得去多个节点捞，你的部署多少个节点为？租户配置多少？

#11

代理服务部署在61，3台ob server分别是61，62，63

#12

@大飞哥online @热海 @xuyu 麻烦看下日志，通过trace id找到的日志：
log.txt (28.0 KB)

#13

已知问题，升级到最新版本

#14

如果不方便升级，就绑定outline走hash join