Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

查询异常:latch already owned #25

Open
grapelet520 opened this issue Dec 13, 2019 · 3 comments
Open

查询异常:latch already owned #25

grapelet520 opened this issue Dec 13, 2019 · 3 comments

Comments

@grapelet520
Copy link

在执行查询时有时会抛出异常或卡住无法取消请求:
ERROR: node:dn004, backend_pid:32570, nodename:dn004,backend_pid:32570,message:node:dn002, backend_pid:16921, nodename:dn002,backend_pid:16921,message:Failed to read from SQueue p_1_3c93_9_58a551eb, consumer (node 3, pid 16921, status 2) - CONSUMER_ERROR set, err_msg "node:dn004, backend_pid:32522, nodename:dn001,backend_pid:29990,message:latch already owned",,
SQL语句:

select 
		vssd.f_stationcode,
		SUM(f_passenger) f_passenger,
		SUM(f_nodenumber) f_nodenumber 
from 
		(
			select 
					f_guid,
					f_stationcode,
					f_passenger 
			from 
					v_sendschedule
			where 	f_date='2018-12-01'
		)vss,
		(
			select 
					f_parentid,
					f_stationcode,
					SUM(f_nodenumber) f_nodenumber 
			from 
					v_sendschedule_detail
			where 	f_date='2018-12-01'
			group by f_stationcode,f_parentid
		) vssd
where 	vssd.f_parentid=vss.f_guid and vssd.f_stationcode=vss.f_stationcode
group by vssd.f_stationcode;

其中:
v_sendschedule记录数:19163112
v_sendschedule_detail记录数:48369630

@SuCuicui
Copy link
Collaborator

如果可以的话,麻烦提供一下表结构信息,还有尽量详细的复现信息,方便问题定位,谢谢

@mikewhb
Copy link
Collaborator

mikewhb commented Jan 18, 2021

麻烦提供下 explain verbose 信息

@izoyo
Copy link

izoyo commented Apr 21, 2021

如果可以的话,麻烦提供一下表结构信息,还有尽量详细的复现信息,方便问题定位,谢谢

在进行 tpc-ds 3.0 测试时候也遇到了

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants