Actions
Bug #13011
closedWith Rails 4, job invocation index fails when searching based on started_at times
Status:
Closed
Priority:
Normal
Assignee:
Category:
-
Target version:
Difficulty:
Triaged:
Description
The following error message is displayed:
table name "foreman_tasks_tasks" specified more than once SELECT "job_invocations"."id" AS t0_r0, "job_invocations"."targeting_id" AS t0_r1, "job_invocations"."job_name" AS t0_r2, "job_invocations"."task_id" AS t0_r3, "job_invocat ions"."task_group_id" AS t0_r4, "job_invocations"."triggering_id" AS t0_r5, "job_invocati ons"."description" AS t0_r6, "foreman_tasks_tasks"."id" AS t1_r0, "foreman_tasks_tasks"." type" AS t1_r1, "foreman_tasks_tasks"."label" AS t1_r2, "foreman_tasks_tasks"."started_at " AS t1_r3, "foreman_tasks_tasks"."ended_at" AS t1_r4, "foreman_tasks_tasks"."state" AS t 1_r5, "foreman_tasks_tasks"."result" AS t1_r6, "foreman_tasks_tasks"."external_id" AS t1_ r7, "foreman_tasks_tasks"."parent_task_id" AS t1_r8, "foreman_tasks_tasks"."start_at" AS t1_r9, "foreman_tasks_tasks"."start_before" AS t1_r10 FROM "job_invocations" LEFT OUTER J OIN "foreman_tasks_tasks" ON "foreman_tasks_tasks"."id" = "job_invocations"."task_id" LEF T OUTER JOIN foreman_tasks_tasks ON foreman_tasks_tasks.id = job_invocations.task_id WHER E (("foreman_tasks_tasks"."started_at" >= '2016-01-05 11:08:27.590884')) ORDER BY job_in vocations.id DESC LIMIT 20 OFFSET 0):
Actions