Hi,
after updating grafana from 6.0.2 to 6.1.3 with yum, I get the following errors :
t=2019-04-10T16:33:25+0200 lvl=eror msg=“Executing migration failed” logger=migrator id=“copy data_source v1 to v2” error=“pq: column “account_id” does not exist”
t=2019-04-10T16:33:25+0200 lvl=eror msg=“Exec failed” logger=migrator error=“pq: column “account_id” does not exist” sql="INSERT INTO “user” (“id”\n, “version”\n, “login”\n, “name”\n, “org_id”\n, “is_admin”\n, “created”\n, “email”\n, “password”\n, “salt”\n, “rands”\n, “company”\n, “updated”) SELECT “id”\n, “version”\n, “login”\n, “name”\n, “account_id”\n, “is_admin”\n, “created”\n, “email”\n, “password”\n, “salt”\n, “rands”\n, “company”\n, “updated” FROM “user_v1"”
t=2019-04-10T16:33:25+0200 lvl=eror msg=“Server shutdown” logger=server reason=“Service init failed: Migration failed err: pq: column “account_id” does not exist”
t=2019-04-10T16:33:25+0200 lvl=info msg=“Executing migration” logger=migrator id=“Rename table user to user_v1 - v1”
t=2019-04-10T16:33:25+0200 lvl=eror msg=“Executing migration failed” logger=migrator id=“Rename table user to user_v1 - v1” error=“pq: relation “user_v1” already exists”
t=2019-04-10T16:33:25+0200 lvl=eror msg=“Exec failed” logger=migrator error=“pq: relation “user_v1” already exists” sql="ALTER TABLE “user” RENAME TO “user_v1"”
t=2019-04-10T16:33:25+0200 lvl=eror msg=“Server shutdown” logger=server reason=“Service init failed: Migration failed err: pq: relation “user_v1” already exists”
I tried to rename user_v1 table before starting but it is not better. (maybe due to first error with account_id in user_v1 which is not existing … I think it should be org_id instead of account_id)
Could you help me : GAFANA is not starting any more.
some more infos : PostgreSQL 9.4.10 / CentOS Linux release 7.5.1804
same issue with applying grafana-6.1.4-1.x86_64.rpm on my upgraded version (6.0.2->6.1.3->6.1.4)
Regards