Project

General

Profile

Actions
Copy link

Bug #20788

closed

"ERROR: current transaction is aborted, commands ignored until end of transaction block" on katello_pools table query

Added by Brad Buckingham over 7 years ago. Updated over 6 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Justin Sherrill
Category:
Subscriptions
Target version:
Katello 3.5.0
Difficulty:
Triaged:
Bugzilla link:
1401455
Pull request:
https://github.com/Katello/katello/pull/6969
Fixed in Releases:
Found in Releases:
Red Hat JIRA:

Description

Cloned from https://bugzilla.redhat.com/show_bug.cgi?id=1401455

Description of problem:
There seems to be some error involving `katello_pools` table causing a transaction error, causing further queries to fail with:

  1. happened on product create
    2016-12-03 23:59:01 [app] [E] ForemanTasks::TaskError: Task 98445faf-2e97-480f-824c-258d98a1f359: ActiveRecord::StatementInvalid: PG::Error: ERROR: current transaction is aborted, commands ignored until end of transaction block | : SELECT "katello_pools".* FROM "katello_pools" WHERE "katello_pools"."cp_id" = '8a93a2a558c7956b0158c83313da12d6' ORDER BY "katello_pools"."id" ASC LIMIT 1

I've not been able to manually reproduce the issue, however our automation hits the issue quite often (at different places) so I'm attaching the foreman-debug tarball.
According the production.log, all the occurrences involve querying the `katello_pools` table and seem to happen during Product manipulation.

Version-Release number of selected component (if applicable):
satellite 6.2.5 snap2

How reproducible:
unsure

Actions
Copy link
 #1

Updated by Brad Buckingham over 7 years ago

  • Subject changed from "ERROR: current transaction is aborted, commands ignored until end of transaction block" on katello_pools table query to "ERROR: current transaction is aborted, commands ignored until end of transaction block" on katello_pools table query
  • Target version set to 213
Actions
Copy link
 #2

Updated by John Mitsch over 7 years ago

  • Translation missing: en.field_release set to 250
Actions
Copy link
 #3

Updated by Brad Buckingham over 7 years ago

  • Target version changed from 213 to 217
Actions
Copy link
 #4

Updated by Justin Sherrill over 7 years ago

  • Status changed from New to Assigned
  • Assignee set to Justin Sherrill
Actions
Copy link
 #5

Updated by The Foreman Bot over 7 years ago

  • Status changed from Assigned to Ready For Testing
  • Pull request https://github.com/Katello/katello/pull/6969 added
Actions
Copy link
 #6

Updated by Justin Sherrill over 7 years ago

  • Status changed from Ready For Testing to Closed
  • % Done changed from 0 to 100
Actions
Copy link

Also available in: Atom PDF