Database is locked error in grafana, database is set to postgresql

Grafana PostgreSQL
1

  • What Grafana version and what operating system are you using?
    Version 9.3.6

  • What are you trying to achieve?
    I want to get rid of database lock error

  • Can you copy/paste the configuration(s) that you are having problems with?
    Error: failed to build query ‘A’: database is locked

I installed Grafana with Postgresql 16. Tried to increase some memory parameters and connection parameters but still have same issue.
Please help here to resolve this issue. Appreciate help. Thanks.