Hello, I'm deploying a readonly HMS on a replication DB to offload some traffic on the primary DB, however it fails with error message as below, although the default value for `datanucleus.transactionIsolation` is `read-committed`, we tried to set it as `repeatable-read`, same problem. ``` Caused by: org.postgresql.util.PSQLException: ERROR: cannot use serializable mode in a hot standby Detail: "default_transaction_isolation" is set to "serializable". Hint: You can use "SET default_transaction_isolation = 'repeatable read'" to change the default. ```
Has anybody seen similar problems and how to walkround it? ------ We're still in a very old version hive-2.3.4. From (datanucleus) code, it seems we're running into the issue mentioned https://github.com/datanucleus/datanucleus-rdbms/issues/336. If my path is valid, only db2 and oracle databases are good. Thanks! Mingmin