![Invalid operation current transaction is aborted commands ignored until end of transaction block Invalid operation current transaction is aborted commands ignored until end of transaction block](/uploads/1/2/4/7/124787568/708913264.gif)
Roman Plevka2016-12-05 10:32:00 UTCDescription of problem:There seems to be some error involving `katellopools` table causing a transaction error, causing further queries to fail with:# happened on product create2016-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 'katellopools'. FROM 'katellopools' WHERE 'katellopools'.' Cpid' = '8a93a2a558c7956b0158c83313da12d6' ORDER BY 'katellopools'.' Id' ASC LIMIT 1I'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 `katellopools` table and seem to happen during Product manipulation.Version-Release number of selected component (if applicable):satellite 6.2.5 snap2How reproducible:unsure.
Re: CDO current transaction is aborted, commands ignored until end of transaction block message #760942 is a reply to message #760852 Mon, 05 December 2011 16:42 Eike Stepper. Dec 29, 2011 Current transaction is aborted, commands ignored until end of transaction block. Hi, Maybe there is a simple solution for PostgreSQL behaviour that is.