Redshift SQL查询失败并出现断言错误

在此视图上运行选择查询时,我断言失败。

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]
  -----------------------------------------------
a198911 回答:Redshift SQL查询失败并出现断言错误

暂时没有好的解决方案,如果你有好的解决方案,请发邮件至:iooj@foxmail.com
本文链接:https://www.f2er.com/3162489.html

大家都在问