在此视图上运行选择查询时,我断言失败。
dev=# \d+ query_vw
View "public.query_vw"
Column | Type | Modifiers | Storage | Description
------------------+-----------------------------+-----------+----------+-------------
query | integer | | plain |
queue_start_time | timestamp without time zone | | plain |
queue_end_time | timestamp without time zone | | plain |
queuetime_ms | bigint | | plain |
exec_start_time | timestamp without time zone | | plain |
exec_end_time | timestamp without time zone | | plain |
exectime_ms | bigint | | plain |
querytxt | text | | extended |
View definition:
SELECT q.query,w.queue_start_time,w.queue_end_time,w.total_queue_time / 1000 AS queuetime_ms,w.exec_start_time,w.exec_end_time,w.total_exec_time / 1000 AS exectime_ms,btrim(q.querytxt::character varying::text) AS querytxt
FROM stl_query q,stl_wlm_query w
WHERE q.userid <> 1 AND q.userid <> 100 AND q.query = w.query;
以下查询是由pg_tail实用程序生成的-我无法更改其生成查询的方式。错误似乎是间歇性的,有指针吗?
SELECT
*
FROM
(SELECT
query,queue_start_time,queue_end_time,queuetime_ms,exec_start_time,exec_end_time,exectime_ms,querytxt
FROM
query_vw
ORDER BY
query DESC LIMIT 5) AS tmp
ORDER BY
query ASC;
ERROR: Assert
DetaIL:
-----------------------------------------------
error: Assert
code: 1000
context: mod == -1 && size == 0 - type: 1114,mod: 0,size: 0
query: 7801463
location: pg_utils.cpp:1335
process: padbmaster [pid=15775]
-----------------------------------------------