Project

General

Profile

Actions

Bug #30807

closed

bulk search api fails with "PG::SyntaxError: ERROR: syntax error at or near

Added by Justin Sherrill about 4 years ago. Updated about 4 years ago.

Status:
Closed
Priority:
Normal
Category:
Foreman plugin
Target version:
Difficulty:
Triaged:
No
Fixed in Releases:
Found in Releases:

Description

"error": {"message":"PG::SyntaxError: ERROR: syntax error at or near \"DISTINCT\"\nLINE 1: ...ed_at, ended_at), current_timestamp) as duration, DISTINCT f...\n ^\n"}

The query getting generated:

SELECT DISTINCT foreman_tasks_tasks.*, coalesce(ended_at, current_timestamp) - coalesce(coalesce(started_at, ended_at), current_timestamp) as duration, DISTINCT foreman_tasks_tasks.*, foreman_tasks_tasks.*, coalesce(ended_at, current_timestamp) - coalesce(coalesce(started_at, ended_at), current_timestamp) as duration FROM "foreman_tasks_tasks" WHERE "foreman_tasks_tasks"."id" = '67b8d1dc-f0b2-4abb-8d20-dba2022a99c4' ORDER BY foreman_tasks_tasks.started_at DESC LIMIT 10 OFFSET 0


Related issues 1 (0 open1 closed)

Has duplicate Katello - Bug #30923: Content view tasks page returns 500 ISEDuplicateActions
Actions #1

Updated by The Foreman Bot about 4 years ago

  • Status changed from New to Ready For Testing
  • Pull request https://github.com/theforeman/foreman-tasks/pull/586 added
Actions #2

Updated by The Foreman Bot about 4 years ago

  • Fixed in Releases foreman-tasks-3.0.1 added
Actions #3

Updated by John Mitsch about 4 years ago

  • Has duplicate Bug #30923: Content view tasks page returns 500 ISE added
Actions #4

Updated by Justin Sherrill about 4 years ago

  • Status changed from Ready For Testing to Closed
Actions

Also available in: Atom PDF