Errors during module enablement.

Description

When the module is being enabled for a tenant using DB_SHAREDMAXPOOLSIZE instead of DB_MAXPOOLSIZE env variable, we get errors.

 

2023-09-01 08:17:48.605,ospt/mod-kb-ebsco-java/9ff8dc8a1b694a24b91bf8fea606662f,08:17:48 [414588/eholdings] [diku20] [790e3476-2cbe-4e36-8819-5a7c036e4c5f] [mod_kb_ebsco_java] INFO  RestRouting          invoking getEholdingsKbCredentials
2023-09-01 08:17:48.688,ospt/mod-kb-ebsco-java/9ff8dc8a1b694a24b91bf8fea606662f,08:17:48 [414588/eholdings] [diku20] [790e3476-2cbe-4e36-8819-5a7c036e4c5f] [mod_kb_ebsco_java] INFO  LogUtils             Do select query = SELECT * FROM diku20_mod_kb_ebsco_java.kb_credentials t1; with params = []
2023-09-01 08:17:48.690,ospt/mod-kb-ebsco-java/9ff8dc8a1b694a24b91bf8fea606662f,08:17:48 [414588/eholdings] [diku20] [790e3476-2cbe-4e36-8819-5a7c036e4c5f] [mod_kb_ebsco_java] INFO  PostgresClient       DB config read from environment variables
2023-09-01 08:17:48.711,ospt/mod-kb-ebsco-java/9ff8dc8a1b694a24b91bf8fea606662f,"08:17:48 [414588/eholdings] [diku20] [790e3476-2cbe-4e36-8819-5a7c036e4c5f] [mod_kb_ebsco_java] INFO  PostgresClient       postgreSQLClientConfig = {""maxSharedPoolSize"":20,""port"":5432,""username"":""folio"",""host"":""db.ospt.folio-eis.us-west-2"",""database"":""folio"",""password"":""..."",""postgres_tester"":false}"
2023-09-01 08:17:48.836,ospt/mod-kb-ebsco-java/9ff8dc8a1b694a24b91bf8fea606662f,08:17:48 [414588/eholdings] [diku20] [790e3476-2cbe-4e36-8819-5a7c036e4c5f] [mod_kb_ebsco_java] ERROR PostgresClient       queryAndAnalyze: ERROR: permission denied for table kb_credentials (42501) - SELECT * FROM diku20_mod_kb_ebsco_java.kb_credentials t1;
2023-09-01 08:17:48.836,ospt/mod-kb-ebsco-java/9ff8dc8a1b694a24b91bf8fea606662f,io.vertx.pgclient.PgException: ERROR: permission denied for table kb_credentials (42501)
2023-09-01 08:17:48.836,ospt/mod-kb-ebsco-java/9ff8dc8a1b694a24b91bf8fea606662f,    at io.vertx.pgclient.impl.codec.ErrorResponse.toException(ErrorResponse.java:31) ~[ms.jar:?]

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None

Attachments

2

Checklist

hide

TestRail: Results

Activity

Show:

Khalilah Gambrell November 9, 2023 at 1:03 PM

Should we close this issue   and ?

Pavlo Smahin November 6, 2023 at 3:27 PM

Was tested on Rancher environment. Was not able to reproduce.

Natalia Zaitseva October 23, 2023 at 8:29 AM

marked as Poppy BugFix

Khalilah Gambrell October 17, 2023 at 5:00 PM

Hey and - should we do this work for Poppy Bugfix? 

Taras Spashchenko September 6, 2023 at 9:34 AM

Please reach  for details and in order to reproduce the issue.

Cannot Reproduce

Details

Assignee

Reporter

Priority

Story Points

Sprint

Development Team

Spitfire

Release

Poppy (R2 2023) Bug Fix

RCA Group

Not a bug

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs
Created September 6, 2023 at 9:28 AM
Updated December 1, 2023 at 9:30 AM
Resolved November 27, 2023 at 3:00 PM
TestRail: Cases
TestRail: Runs