检测到您已登录华为云国际站账号,为了您更好的体验,建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
例如: 在coordinator1执行一条语句之后长时间没有响应。可以创建另外一个连接到coordinator1上,查询coordinator1上的线程状态。
例如: 在coordinator1执行一条语句之后长时间没有响应。可以创建另外一个连接到coordinator1上,查询coordinator1上的线程状态。
S_NATIONKEY_4 VALUES LESS THAN(4), PARTITION S_NATIONKEY_5 VALUES LESS THAN(5), PARTITION S_NATIONKEY_6 VALUES LESS THAN(6), PARTITION S_NATIONKEY
and o_orderkey = l_orderkey and c_custkey = o_custkey and s_nationkey = n1.n_nationkey and c_nationkey = n2.n_nationkey and ( (n1.n_name = '
region where c_custkey = o_custkey and l_orderkey = o_orderkey and l_suppkey = s_suppkey and c_nationkey = s_nationkey and s_nationkey
SQLSTATE: 42601 错误原因:语法错误,创建的coordinator数量超过设置的max_coordinators数量。 解决办法:调大max_coordinators配置参数。
word part, letters and digits") (10,hword_part,"Hyphenated word part, all letters") (11,hword_asciipart,"Hyphenated word part, all ASCII")
word part, letters and digits") (10,hword_part,"Hyphenated word part, all letters") (11,hword_asciipart,"Hyphenated word part, all ASCII")
42 43 44 45 46 47 48 49 50 51 52 53 CREATE TABLE prod ( prod_no number(6) not null unique, prod_name national
LO_ORDERDATE >= 19920101 AND LO_ORDERDATE <= 19971231 GROUP BY C_NATION, S_NATION, YEAR ORDER BY YEAR ASC, revenue DESC; Q3.2 1 2 3 4
word part, letters and digits 10 | hword_part | Hyphenated word part, all letters 11 | hword_asciipart | Hyphenated word part,
word part, letters and digits 10 | hword_part | Hyphenated word part, all letters 11 | hword_asciipart | Hyphenated word part,
1 2 FATAL: terminating connection due to administrator command FATAL: terminating connection due to administrator command gsql客户端使用PG_TERMINATE_BACKEND
1 2 FATAL: terminating connection due to administrator command FATAL: terminating connection due to administrator command gsql客户端使用PG_TERMINATE_BACKEND
GAUSS-02237: "The CREATE BARRIER END message is expected to arrive at a Coordinator from another Coordinator" SQLSTATE: XX000 错误原因:系统内部错误。
-------+---------+-----------+------------+--------------+---------------+--------------+---------------+-------------+-------------- coordinator2
-------+---------+-----------+------------+--------------+---------------+--------------+---------------+-------------+-------------- coordinator2
(0); pg_terminate_query -------------------- f (1 row) pgxc_terminate_query(queryId int) 描述:终止当前集群下正在执行的查询。
(0); pg_terminate_query -------------------- f (1 row) pgxc_terminate_query(queryId int) 描述:终止当前集群下正在执行的查询。
| 516096 | 384 1744684969.139761390696120.coordinator1 | postgres | SysCacheMemoryContext | 516096 | 6000 (3 rows)