Fetch size for certain Postgres RDB queries is enabled

General
, ,
1

my tomcat installation with version 8.5.1. is not willing to start.

it gets stuck at:

2020-11-05 15:26:20,601 [server.azure.cloud] (rnal.access.CacheContainerImpl) INFO - Using the Dynamic Cache Probation Policy - cache after 2 accesses AND with a blob increment of 102400.
2020-11-05 15:26:20,679 [server.azure.cloud] (pcentric.RACacheAppCentricImpl) INFO - Prune threshold is 10000
2020-11-05 15:26:21,238 [StartUp-TaskExecutor] (ary.ClassMapDatabasePageReader) INFO - Read 6335 class definitions
2020-11-05 15:26:21,315 [server.azure.cloud] (ion.context.GlobalContextCache) INFO - LocalizedApplicationContext synchronization policy: traditional.
2020-11-05 15:26:21,317 [server.azure.cloud] (orization.SessionAuthorization) INFO - RSL Update Behavior: Eager
2020-11-05 15:26:22,735 [StartUp-TaskExecutor] (ternal.dictionary.ClassMapImpl) INFO - ClassMapData is preloaded
2020-11-05 15:26:23,081 [StartUp-TaskExecutor] (ternal.dictionary.ClassMapImpl) INFO - ClassMap initialization completed in 4905 ms
2020-11-05 15:26:23,084 [StartUp-TaskExecutor] ( internal.access.DatabaseImpl) INFO - Database product: PostgreSQL
2020-11-05 15:26:23,084 [StartUp-TaskExecutor] ( internal.access.DatabaseImpl) INFO - Database version: 9.6.19
2020-11-05 15:26:23,084 [StartUp-TaskExecutor] ( internal.access.DatabaseImpl) INFO - Driver: PostgreSQL Native Driver
2020-11-05 15:26:23,085 [StartUp-TaskExecutor] ( internal.access.DatabaseImpl) INFO - Driver version: PostgreSQL 9.4.1207.jre7
2020-11-05 15:26:23,085 [StartUp-TaskExecutor] ( internal.access.DatabaseImpl) INFO - Version of JDBC supported by driver: 4.0
2020-11-05 15:26:23,172 [StartUp-TaskExecutor] ( internal.access.DatabaseImpl) INFO - Using optimized batch ID generation. IDs will be generated in batches and may not be strictly sequential
2020-11-05 15:26:23,239 [StartUp-TaskExecutor] ( internal.access.Lister) INFO - Fetch size for certain Postgres RDB queries is enabled

2

Your jdbc driver does not seem to be right, use this link to download postgres driver JDBC 4.2 compliant: https://jdbc.postgresql.org/download.html

3

it worked when the driver was replaced.

Many thanks!

4

Hi Mate - I’m facing the same issue. Could you help me to know the driver you have used to resolve the issue. Kindly, share me the specs, please!

5

hi

Somehow the issue got back after restart, would you be able to assit?

[StartUp-TaskExecutor] (ternal.dictionary.ClassMapImpl) INFO - ClassMap initialization completed in 4475 ms
[StartUp-TaskExecutor] ( internal.access.DatabaseImpl) INFO - Database product: PostgreSQL
[StartUp-TaskExecutor] ( internal.access.DatabaseImpl) INFO - Database version: 9.6.10
[StartUp-TaskExecutor] ( internal.access.DatabaseImpl) INFO - Driver: PostgreSQL JDBC Driver
[StartUp-TaskExecutor] ( internal.access.DatabaseImpl) INFO - Driver version: 42.2.18
[StartUp-TaskExecutor] ( internal.access.DatabaseImpl) INFO - Version of JDBC supported by driver: 4.2
[StartUp-TaskExecutor] ( internal.access.DatabaseImpl) INFO - Using optimized batch ID generation. IDs will be generated in batches and may not be strictly sequential
[StartUp-TaskExecutor] ( internal.access.Lister) INFO - Fetch size for certain Postgres RDB queries is enabled

6

hi @venkat2929

i downloaded version 42.2.18 from https://jdbc.postgresql.org/download.html, however i am stuck again.

7

@mwb33730 No luck still stuck with the same issue. Someone from the @GCS team should support us on this.