commit 86b5cee2920672726bd66df0775198f57f29b8cc
author sourabh_sourabh <sourabh.sourabh@est.tech> Thu Sep 08 12:35:04 2022 +0100
committer Sourabh Sourabh <sourabh.sourabh@est.tech> Tue Sep 13 15:06:23 2022 +0000
tree 011c9e0dd122c61cee832fb9ac943d7f3fa67bfb
parent ae5a47388dae38c51b437e448ae6a23fa9a77591

CmHandle registration/module sync watchdog performance improvment

- Tuned CPS DB parameters
- Removed deprecated CPS DB parameter
- Modified module sync watch logic
- Added aditional logs
- Removed logic to get FragmentEntities as stream
- Removed detaching of fragment entity as it was causing NCMP to break with an exception "SQLSTATE(08006)"

Issue-ID: CPS-1126
Signed-off-by: sourabh_sourabh <sourabh.sourabh@est.tech>
Change-Id: I0bde11895f754602dece132efde701d82b377f12

cps-application/src/main/resources/application.yml

diff --git a/cps-application/src/main/resources/application.yml b/cps-application/src/main/resources/application.yml
index 9b6f41e..56515df 100644
--- a/cps-application/src/main/resources/application.yml
+++ b/cps-application/src/main/resources/application.yml
@@ -45,13 +45,12 @@
         username: ${DB_USERNAME}

         password: ${DB_PASSWORD}

         driverClassName: org.postgresql.Driver

-        initialization-mode: always

         hikari:

             minimumIdle: 5

             maximumPoolSize: 80

-            idleTimeout: 120000

-            connectionTimeout: 300000

-            leakDetectionThreshold: 300000

+            idleTimeout: 60000

+            connectionTimeout: 120000

+            leakDetectionThreshold: 2000

             pool-name: CpsDatabasePool

 

     cache:

@@ -91,6 +90,9 @@
       default-property-inclusion: NON_NULL

       serialization:

         FAIL_ON_EMPTY_BEANS: false

+    sql:

+      init:

+        mode: ALWAYS

 app:

     ncmp:

         async-m2m: