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

1 files changed, 6 insertions, 4 deletions

diff --git a/cps-application/src/main/resources/application.yml b/cps-application/src/main/resources/application.yml
index 9b6f41ec23..56515df776 100644
--- a/cps-application/src/main/resources/application.yml
+++ b/cps-application/src/main/resources/application.yml
@@ -45,13 +45,12 @@ spring:
         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 @@ spring:
       default-property-inclusion: NON_NULL

       serialization:

         FAIL_ON_EMPTY_BEANS: false

+    sql:

+      init:

+        mode: ALWAYS

 app:

     ncmp:

         async-m2m: