Update failed with error Error 1054: Unknown column 'account_id' in 'field list'"


#1

Update from grafana-4.4.2 TO grafana-5.4.2

INFO[01-11|14:44:57] Starting Grafana logger=server version=5.4.2 commit=d812109 branch=HEAD compiled=2018-12-13T20:49:23+0800
INFO[01-11|14:44:57] Config loaded from logger=settings file=/data/hawkeye/grafana/grafana-5.4.2/conf/defaults.ini
INFO[01-11|14:44:57] Path Home logger=settings path=/data/hawkeye/grafana/grafana-5.4.2
INFO[01-11|14:44:57] Path Data logger=settings path=/data/hawkeye/grafana/grafana-5.4.2/data
INFO[01-11|14:44:57] Path Logs logger=settings path=/data/logs/grafana/
INFO[01-11|14:44:57] Path Plugins logger=settings path=/data/hawkeye/grafana/grafana-5.4.2/data/plugins
INFO[01-11|14:44:57] Path Provisioning logger=settings path=/data/hawkeye/grafana/grafana-5.4.2/conf/provisioning
INFO[01-11|14:44:57] App mode production logger=settings
INFO[01-11|14:44:57] Initializing HTTPServer logger=server
INFO[01-11|14:44:57] Initializing SqlStore logger=server
INFO[01-11|14:44:57] Connecting to DB logger=sqlstore dbtype=mysql
INFO[01-11|14:44:57] Starting DB migration logger=migrator
INFO[01-11|14:44:57] Executing migration logger=migrator id=“create migration_log table”
INFO[01-11|14:44:57] Executing migration logger=migrator id=“create user table”
INFO[01-11|14:44:57] Executing migration logger=migrator id=“add unique index user.login”
INFO[01-11|14:44:57] Executing migration logger=migrator id=“add unique index user.email”
INFO[01-11|14:44:57] Executing migration logger=migrator id=“drop index UQE_user_login - v1”
INFO[01-11|14:44:57] Executing migration logger=migrator id=“drop index UQE_user_email - v1”
INFO[01-11|14:44:57] Executing migration logger=migrator id=“Rename table user to user_v1 - v1”
INFO[01-11|14:44:57] Executing migration logger=migrator id=“create user table v2”
INFO[01-11|14:44:57] Executing migration logger=migrator id=“create index UQE_user_login - v2”
INFO[01-11|14:44:57] Executing migration logger=migrator id=“create index UQE_user_email - v2”
INFO[01-11|14:44:57] Executing migration logger=migrator id=“copy data_source v1 to v2”
EROR[01-11|14:44:57] Executing migration failed logger=migrator id=“copy data_source v1 to v2” error=“Error 1054: Unknown column ‘account_id’ in ‘field list’”
EROR[01-11|14:44:57] Exec failed logger=migrator error=“Error 1054: Unknown column ‘account_id’ in ‘field list’” sql="INSERT INTO user (id\n, login\n, name\n, salt\n, company\n, org_id\n, is_admin\n, updated\n, version\n, email\n, password\n, rands\n, created) SELECT id\n, login\n, name\n, salt\n, company\n, account_id\n, is_admin\n, updated\n, version\n, email\n, password\n, rands\n, created FROM user_v1"
EROR[01-11|14:44:57] Server shutdown logger=server reason=“Service init failed: Migration failed err: Error 1054: Unknown column ‘account_id’ in ‘field list’”