TBase is an enterprise-level distributed HTAP database. Through a single database cluster to provide users with highly consistent distributed database services and high-performance data warehouse services, a set of integrated enterprise-level solutions is formed.
在执行查询时有时会抛出异常或卡住无法取消请求:
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;
在执行查询时有时会抛出异常或卡住无法取消请求:
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语句:其中: v_sendschedule记录数:19163112 v_sendschedule_detail记录数:48369630