Deploying Docker Grafana; Container Startup Errors; Database Migration Issues

Monitoring and Observability Grafana
1

Hi team,
I deployed docker grafana11 for a new program, the container failed to start, I got the error from docker logs Error: ✗ pq: relation "migration_log" does not exist, then I manual create the table in DB and start the container, another error shown below: level=error msg="Executing migration failed" id="drop index UQE_user_login - v1" error="pq: index \"UQE_user_login\" does not exist
My questions:

  1. How to fix the issue completely?
  2. In theory, shouldn’t the indexes and tables in the database be created automatically when a new container is started? Without any manual operations? If so, am I doing any of the steps wrong?
2

For database backend for Grafana, you need to load the schema first. That is how I fixed this error in my migration from SQLite to Postgres

3

Hi snk, What do you mean load the schema? The schema and tables can be created automatically in SQList3. How about in postgres?