Unexpected exception occured while executing transactional block

Naranthiran · June 24, 2025, 6:48am

Problem: i am trying to upload the manifest through the foreman UI as well as through the command line but I am getting an error that “Unexpected exception occured while executing transactional block”.

Expected outcome: Manifest should uploaded successfully .

Foreman and Proxy versions: Foreman version-3.10.0 , Proxy version :- “3.10.0”

Foreman and Proxy plugin versions:

Distribution and version: RHEL8

Other relevant data:

List of package versions

ansible-collection-theforeman-foreman-4.0.0-2.el8.noarch
candlepin-4.3.12-1.el8.noarch
candlepin-selinux-4.3.12-1.el8.noarch
foreman-3.10.0-1.el8.noarch
foreman-cli-3.10.0-1.el8.noarch
foreman-debug-3.10.0-1.el8.noarch
foreman-dynflow-sidekiq-3.10.0-1.el8.noarch
foreman-installer-3.10.0-1.el8.noarch
foreman-installer-katello-3.10.0-1.el8.noarch
foreman-obsolete-packages-1.6-1.el8.noarch
foreman-postgresql-3.10.0-1.el8.noarch
foreman-proxy-3.10.0-1.el8.noarch
foreman-proxy-content-4.12.1-1.el8.noarch
foreman-redis-3.10.0-1.el8.noarch
foreman-release-3.10.0-1.el8.noarch
foreman-selinux-3.10.0-1.el8.noarch
foreman-service-3.10.0-1.el8.noarch
foreman-vmware-3.10.0-1.el8.noarch
ingbtcpic6vl324.code1.emi.philips.com-foreman-client-1.0-1.noarch
ingbtcpic6vl324.code1.emi.philips.com-foreman-proxy-1.0-1.noarch
ingbtcpic6vl324.code1.emi.philips.com-foreman-proxy-client-1.0-1.noarch
katello-4.12.1-1.el8.noarch
katello-certs-tools-2.9.0-2.el8.noarch
katello-client-bootstrap-1.7.9-2.el8.noarch
katello-common-4.12.1-1.el8.noarch
katello-debug-4.12.1-1.el8.noarch
katello-default-ca-1.0-1.noarch
katello-repos-4.12.1-1.el8.noarch
katello-selinux-5.0.2-1.el8.noarch
katello-server-ca-1.0-1.noarch
pulp-client-1.0-1.noarch
pulpcore-obsolete-packages-1.0-9.el8.noarch
pulpcore-selinux-2.0.1-1.el8.x86_64
python3.11-pulp-ansible-0.20.2-3.el8.noarch
python3.11-pulp-certguard-1.7.1-2.el8.noarch
python3.11-pulp-cli-0.21.2-5.el8.noarch
python3.11-pulp-container-2.16.8-1.el8.noarch
python3.11-pulp-deb-3.0.1-1.el8.noarch
python3.11-pulp-file-1.15.1-2.el8.noarch
python3.11-pulp-glue-0.21.2-3.el8.noarch
python3.11-pulp-ostree-2.1.3-3.el8.noarch
python3.11-pulp-python-3.10.0-3.el8.noarch
python3.11-pulp-rpm-3.23.3-1.el8.noarch
python3.11-pulpcore-3.39.11-1.el8.noarch
rubygem-foreman-tasks-9.1.1-1.fm3_11.el8.noarch
rubygem-foreman_ansible-14.0.0-1.fm3_11.el8.noarch
rubygem-foreman_discovery-24.0.1-1.fm3_10.el8.noarch
rubygem-foreman_maintain-1.5.1-1.el8.noarch
rubygem-foreman_openscap-7.1.1-2.fm3_10.el8.noarch
rubygem-foreman_puppet-6.2.0-1.fm3_10.el8.noarch
rubygem-foreman_remote_execution-13.0.0-1.fm3_11.el8.noarch
rubygem-foreman_remote_execution-cockpit-13.0.0-1.fm3_11.el8.noarch
rubygem-foreman_setup-8.0.1-2.fm3_9.el8.noarch
rubygem-hammer_cli-3.10.0-1.el8.noarch
rubygem-hammer_cli_foreman-3.10.0-1.el8.noarch
rubygem-hammer_cli_foreman_discovery-1.2.0-1.fm3_10.el8.noarch
rubygem-hammer_cli_foreman_puppet-0.0.7-1.fm3_10.el8.noarch
rubygem-hammer_cli_foreman_remote_execution-0.3.0-1.fm3_10.el8.noarch
rubygem-hammer_cli_foreman_tasks-0.0.20-1.fm3_10.el8.noarch
rubygem-hammer_cli_katello-1.12.0-0.1.pre.master.20240122184453git9a6ae05.el8.noarch
rubygem-katello-4.12.1-1.el8.noarch
rubygem-pulp_ansible_client-0.20.3-1.el8.noarch
rubygem-pulp_certguard_client-1.6.5-1.el8.noarch
rubygem-pulp_container_client-2.16.4-1.el8.noarch
rubygem-pulp_deb_client-3.0.1-1.el8.noarch
rubygem-pulp_file_client-1.15.1-1.el8.noarch
rubygem-pulp_ostree_client-2.1.3-1.el8.noarch
rubygem-pulp_python_client-3.10.0-1.el8.noarch
rubygem-pulp_rpm_client-3.23.2-1.el8.noarch
rubygem-pulpcore_client-3.39.9-1.el8.noarch
rubygem-smart_proxy_pulp-3.3.0-1.fm3_10.el8.noarch

Candlepin logs:
org.candlepin.async.JobExecutionException: Unexpected exception occured while executing transactional block
at org.candlepin.async.tasks.ImportJob.execute(ImportJob.java:255)
at org.candlepin.async.JobManager.executeJob(JobManager.java:1282)
at org.candlepin.async.JobMessageReceiver$MessageListener.handleMessage(JobMessageReceiver.java:350)
at org.candlepin.messaging.impl.artemis.ArtemisConsumer$ArtemisMessageForwarder.onMessage(ArtemisConsumer.java:59)
at org.apache.activemq.artemis.core.client.impl.ClientConsumerImpl.callOnMessage(ClientConsumerImpl.java:982)
at org.apache.activemq.artemis.core.client.impl.ClientConsumerImpl$Runner.run(ClientConsumerImpl.java:1134)
at org.apache.activemq.artemis.utils.actors.OrderedExecutor.doTask(OrderedExecutor.java:57)
at org.apache.activemq.artemis.utils.actors.OrderedExecutor.doTask(OrderedExecutor.java:32)
at org.apache.activemq.artemis.utils.actors.ProcessorBase.executePendingTasks(ProcessorBase.java:68)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at org.apache.activemq.artemis.utils.ActiveMQThreadFactory$1.run(ActiveMQThreadFactory.java:118)
Caused by: org.candlepin.util.TransactionExecutionException: Unexpected exception occured while executing transactional block
at org.candlepin.util.Transactional.executeNested(Transactional.java:379)
at org.candlepin.util.Transactional.execute(Transactional.java:501)
at org.candlepin.controller.CandlepinPoolManager.refreshPoolsWithRegeneration(CandlepinPoolManager.java:325)
at org.candlepin.controller.Refresher.run(Refresher.java:168)
at org.candlepin.sync.Importer.importObjects(Importer.java:591)
at com.google.inject.persist.jpa.JpaLocalTxnInterceptor.invoke(JpaLocalTxnInterceptor.java:58)
at org.candlepin.sync.Importer.doExport(Importer.java:419)
at org.candlepin.sync.Importer.loadStoredExport(Importer.java:199)
at org.candlepin.controller.ManifestManager.importStoredManifest(ManifestManager.java:220)
at com.google.inject.persist.jpa.JpaLocalTxnInterceptor.invoke(JpaLocalTxnInterceptor.java:66)
at org.candlepin.async.tasks.ImportJob.execute(ImportJob.java:234)
… 11 common frames omitted
Caused by: java.lang.IllegalStateException: One or more pools was left in an undefined state: [21dc53c19073a7f0019074a0a600000c]
at org.candlepin.controller.CandlepinPoolManager.lambda$refreshPoolsWithRegeneration$0(CandlepinPoolManager.java:294)
at org.candlepin.util.Transactional.executeNested(Transactional.java:376)
… 21 common frames omitted
2025-06-24 02:20:55,210 [thread=https-openssl-nio-127.0.0.1-23443-exec-9] [req=c53155dc-8243-4766-b50f-7adfbe3459a2, org=, csid=4821ca27-87e1-4328-bd28-a1aa83f3b5d2] INFO org.candlepin.servlet.filter.logging.LoggingFilter - Request: verb=GET, uri=/candlepin/jobs/21dc53c1979ff55f0197a098a7763053?
2025-06-24 02:20:55,212 [thread=https-openssl-nio-127.0.0.1-23443-exec-9] [req=c53155dc-8243-4766-b50f-7adfbe3459a2, org=, csid=4821ca27-87e1-4328-bd28-a1aa83f3b5d2] INFO org.candlepin.servlet.filter.logging.LoggingFilter - Response: status=200, content-type=“application/json”, time=2
2025-06-24 02:20:55,320 [thread=https-openssl-nio-127.0.0.1-23443-exec-2] [req=ec0d27f6-ed7c-4429-9240-0fb991f245db, org=, csid=4821ca27-87e1-4328-bd28-a1aa83f3b5d2] INFO org.candlepin.servlet.filter.logging.LoggingFilter - Request: verb=GET, uri=/candlepin/owners/COT/products/?include=id&include=name&include=multiplier&include=productContent
2025-06-24 02:20:55,371 [thread=https-openssl-nio-127.0.0.1-23443-exec-2] [req=ec0d27f6-ed7c-4429-9240-0fb991f245db, org=COT, csid=4821ca27-87e1-4328-bd28-a1aa83f3b5d2] INFO org.candlepin.servlet.filter.logging.LoggingFilter - Response: status=200, content-type=“application/json”, time=51
2025-06-24 02:20:56,238 [thread=https-openssl-nio-127.0.0.1-23443-exec-5] [req=f57e2191-bac0-4d2c-be47-3fa04a89c1aa, org=, csid=4821ca27-87e1-4328-bd28-a1aa83f3b5d2] INFO org.candlepin.servlet.filter.logging.LoggingFilter - Request: verb=GET, uri=/candlepin/owners/COT/products/?
2025-06-24 02:20:56,284 [thread=https-openssl-nio-127.0.0.1-23443-exec-5] [req=f57e2191-bac0-4d2c-be47-3fa04a89c1aa, org=COT, csid=4821ca27-87e1-4328-bd28-a1aa83f3b5d2] INFO org.candlepin.servlet.filter.logging.LoggingFilter - Response: status=200, content-type=“application/json”, time=46
2025-06-24 02:20:56,526 [thread=https-openssl-nio-127.0.0.1-23443-exec-7] [req=0f4fc4bc-e699-4597-a3bf-755be4e16554, org=, csid=4821ca27-87e1-4328-bd28-a1aa83f3b5d2] INFO org.candlepin.servlet.filter.logging.LoggingFilter - Request: verb=GET, uri=/candlepin/owners/COT/products/393074046365/?
2025-06-24 02:20:56,530 [thread=https-openssl-nio-127.0.0.1-23443-exec-7] [req=0f4fc4bc-e699-4597-a3bf-755be4e16554, org=COT, csid=4821ca27-87e1-4328-bd28-a1aa83f3b5d2] INFO org.candlepin.servlet.filter.logging.LoggingFilter - Response: status=200, content-type=“application/json”, time=4
2025-06-24 02:20:56,550 [thread=https-openssl-nio-127.0.0.1-23443-exec-4] [req=225e7a30-8772-48ea-bfdd-512a4718f039, org=, csid=4821ca27-87e1-4328-bd28-a1aa83f3b5d2] INFO org.candlepin.servlet.filter.logging.LoggingFilter - Request: verb=GET, uri=/candlepin/owners/COT/products/975818919017/?
2025-06-24 02:20:56,553 [thread=https-openssl-nio-127.0.0.1-23443-exec-4] [req=225e7a30-8772-48ea-bfdd-512a4718f039, org=COT, csid=4821ca27-87e1-4328-bd28-a1aa83f3b5d2] INFO org.candlepin.servlet.filter.logging.LoggingFilter - Response: status=200, content-type=“application/json”, time=3
2025-06-24 02:20:56,575 [thread=https-openssl-nio-127.0.0.1-23443-exec-9] [req=dd774db4-bb8d-496f-b91b-6005e0dfe82e, org=, csid=4821ca27-87e1-4328-bd28-a1aa83f3b5d2] INFO org.candlepin.servlet.filter.logging.LoggingFilter - Request: verb=GET, uri=/candlepin/owners/COT/products/548762609603/?
2025-06-24 02:20:56,578 [thread=https-openssl-nio-127.0.0.1-23443-exec-9] [req=dd774db4-bb8d-496f-b91b-6005e0dfe82e, org=COT, csid=4821ca27-87e1-4328-bd28-a1aa83f3b5d2] INFO org.candlepin.servlet.filter.logging.LoggingFilter - Response: status=200, content-type=“application/json”, time=3
2025-06-24 02:20:56,599 [thread=https-openssl-nio-127.0.0.1-23443-exec-2] [req=11418cc0-639d-46ad-ac61-2ae0e2ff95e9, org=, csid=4821ca27-87e1-4328-bd28-a1aa83f3b5d2] INFO org.candlepin.servlet.filter.logging.LoggingFilter - Request: verb=GET, uri=/candlepin/owners/COT/products/246905443682/?
2025-06-24 02:20:56,603 [thread=https-openssl-nio-127.0.0.1-23443-exec-2] [req=11418cc0-639d-46ad-ac61-2ae0e2ff95e9, org=COT, csid=4821ca27-87e1-4328-bd28-a1aa83f3b5d2] INFO org.candlepin.servlet.filter.logging.LoggingFilter - Response: status=200, content-type=“application/json”, time=4
2025-06-24 02:20:56,624 [thread=https-openssl-nio-127.0.0.1-23443-exec-5] [req=667fb947-d652-486f-9275-34dc52708203, org=, csid=4821ca27-87e1-4328-bd28-a1aa83f3b5d2] INFO org.candlepin.servlet.filter.logging.LoggingFilter - Request: verb=GET, uri=/candlepin/owners/COT/products/506702687145/?
2025-06-24 02:20:56,627 [thread=https-openssl-nio-127.0.0.1-23443-exec-5] [req=667fb947-d652-486f-9275-34dc52708203, org=COT, csid=4821ca27-87e1-4328-bd28-a1aa83f3b5d2] INFO org.candlepin.servlet.filter.logging.LoggingFilter - Response: status=200, content-type=“application/json”, time=3
2025-06-24 02:20:56,646 [thread=https-openssl-nio-127.0.0.1-23443-exec-7] [req=87cadf27-9057-49b9-acc8-ccc4fa12fcf8, org=, csid=4821ca27-87e1-4328-bd28-a1aa83f3b5d2] INFO org.candlepin.servlet.filter.logging.LoggingFilter - Request: verb=GET, uri=/candlepin/owners/COT/products/611879105578/?
2025-06-24 02:20:56,650 [thread=https-openssl-nio-127.0.0.1-23443-exec-7] [req=87cadf27-9057-49b9-acc8-ccc4fa12fcf8, org=COT, csid=4821ca27-87e1-4328-bd28-a1aa83f3b5d2] INFO org.candlepin.servlet.filter.logging.LoggingFilter - Response: status=200, content-type=“application/json”, time=4
2025-06-24 02:20:56,667 [thread=https-openssl-nio-127.0.0.1-23443-exec-4] [req=9e9facb3-a4e0-437b-9a9c-e2953dbdb87c, org=, csid=4821ca27-87e1-4328-bd28-a1aa83f3b5d2] INFO org.candlepin.servlet.filter.logging.LoggingFilter - Request: verb=GET, uri=/candlepin/owners/COT/products/889696036491/?
2025-06-24 02:20:56,670 [thread=https-openssl-nio-127.0.0.1-23443-exec-4] [req=9e9facb3-a4e0-437b-9a9c-e2953dbdb87c, org=COT, csid=4821ca27-87e1-4328-bd28-a1aa83f3b5d2] INFO org.candlepin.servlet.filter.logging.LoggingFilter - Response: status=200, content-type=“application/json”, time=3
2025-06-24 02:20:56,689 [thread=https-openssl-nio-127.0.0.1-23443-exec-9] [req=36721cce-a1d4-45ff-9f8f-c087d9f9f9f4, org=, csid=4821ca27-87e1-4328-bd28-a1aa83f3b5d2] INFO org.candlepin.servlet.filter.logging.LoggingFilter - Request: verb=GET, uri=/candlepin/owners/COT/products/137659345922/?