Cannot Reproduce
Details
Details
Assignee
Pavlo Smahin
Pavlo SmahinReporter
Taras Spashchenko
Taras SpashchenkoLabels
Priority
Story Points
1
Sprint
None
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
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:?]