We have a VDB with cache db configured on Azure PostgreSQL v11.
Assume a scenario when a SELECT is already running on Denodo VDB, accessing data from the configured cache.
Now, if the Cache refresh job starts, at a set time, through Denodo Scheduler while this SELECT is running then the cache refresh job gets stuck and does not progress at all.
We end up killing either set of these queries to resolve this. This method is not sustainable.
Has this been observed before? What could be the potential issue and appropriate solution to handle it?
Appreciate a quicker response.