We currently use Actian PSQL Database in our core business application for more than 10 years. In the las few days, users actions using the application, randomly trigger error 46, which is related with "permissions issues", but what really happens is that for unknown reasons, a table becomes "locked" with a Read-Only lock. We normally have to disconnect users by killing the task, ion order for the lock to be released.
This error, if not solved, causes a domino effect for every user that tries to concurrently access the table, causing lots of inconveniences in our daily operations.
We ease the effects of the problem, performing a manual rebuild of the table involved, at times also stop and restart services, and even reboot the server.
The error keeps appearinf for no apparent reason. Any help would be appreciated