Code Review / cps.git / commit
? search:
summary | shortlog | log | commit | commitdiff | review | tree
(parent: f0f4fd8) | patch
Drop temp table when transaction finishes 70/133570/1
authordanielhanrahan <daniel.hanrahan@est.tech>
Thu, 2 Mar 2023 23:27:09 +0000 (23:27 +0000)
committerDaniel Hanrahan <daniel.hanrahan@est.tech>
Tue, 7 Mar 2023 15:15:20 +0000 (15:15 +0000)
commit29b493f8859f1ce0eeadaba75462006499f6f26d
treeb067f76614053d92c8238318b49b834bf58a7e38tree | snapshot
parentf0f4fd810c9a249d78def4c2f10356fceb864b1fcommit | diff
Drop temp table when transaction finishes

By default, temp tables are persisted until the end of the session.
This causes "Out of shared memory" errors in the database, which then
auto-vacuums the orphaned temp tables to free memory. To fix this, we
drop temp tables when the transaction finishes, using ON COMMIT DROP.

Issue-ID: CPS-1533
Signed-off-by: danielhanrahan <daniel.hanrahan@est.tech>
Change-Id: Iac47d85e9621531a4a95b99c4becc8cc95242721
cps-ri/src/main/java/org/onap/cps/spi/repository/TempTableCreator.java diff | blob | history
"cps"