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

Reply via email to