I am following the guide to connect Superset with Risingwave, but keep getting the error 'Failed to get/set session config: Unrecognized config entry transaction isolation level
'. Yuhao Su mentioned that the bug was due to a difference in the format of the transaction isolation level command between PostgreSQL and Risingwave. The fix will be released in Risingwave v1.5.1. How can I fix this error in the current version?
Jochen Christ
Asked on Dec 14, 2023
show transaction_isolation_level;
, while PostgreSQL allows both show transaction isolation level;
and show transaction_isolation_level;
.Example:
# Update the transaction isolation level command in the Superset configuration
config['SQLALCHEMY_EXTRAS'] = {
'engine_params': {
'isolation_level': 'READ COMMITTED'
}
}