fix: add missing transaction block on `CatalogService` #9889

Job	Run time
Javadoc	5m 9s
Checkstyle	4m 25s
Postgresql-Integration-Tests	7m 9s
Unit-Tests	15m 43s
API-Tests	8m 40s
Component-Tests	11m 21s
End-To-End-Tests	12m 10s
Kafka-Integration-Tests	4m 24s
Upload-Test-Report	39s
Upload-Coverage-Report-To-Codecov	31s
	1h 10m 11s

Provide feedback