pgr-services goes into a crashloop due to improper db migration scripts, not able to create businessService configuration for PGR

[shashwat-egov]

Upon checking pgr-services logs,

The pod is not able to find businessService config of PGR which is causing it to go into a crashloop.

Upon checking the persister service ( asynchronously inserts data into the database ) logs,

Seems like the db migration scripts are not in sync with the INSERT query that is getting executed to persist data onto the db. Adding this missing migration script ought to solve the issue - https://github.com/egovernments/DIGIT-Dev/blob/develop/core-services/egov-workflow-v2/src/main/resources/db/migration/main/V20210423102936__wf_alter_table_active_ddl.sql

[gajenc]

@shashwat-egov This is expected behaviour, we have already mentioned this in the document that initially the PGR-service will be in crash loop, you should run the post deployment scripts.

[shashwat-egov]

@gajendran-egov I followed the post deployment steps already but it did not come out of crashloop. The error does not go away. I suspect that it is pointing to persister configs which are later than v2.4 as the INSERT query getting executed seems to be out of sync with the tables of workflow service.

[shashwat-egov]

Update: This issue has been escalated to the urban team and will be fixed soon. Also, we should have a separate configs branch for quickstart too so that the queries that are getting executed and db tables do not go out of sync.