Database Migration issues

General
1

Deployed latest lenses-hq and lenses-agent using community license. Seeing migration errors in agent. Can someone help me resolve this?

Caused by: liquibase.exception.MigrationFailedException: Migration failed for changeset io/lenses/store/jdbc/migration/4.1.0/05_rename_user_columns.xml::1::lenses:
Reason: liquibase.exception.DatabaseException: ERROR: column “user” does not exist [Failed SQL: (0) ALTER TABLE public.user_profiles RENAME COLUMN “user” TO username]
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:873)
at liquibase.changelog.visitor.UpdateVisitor.executeAcceptedChange(UpdateVisitor.java:127)
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:71)
at liquibase.changelog.ChangeLogIterator.lambda$run$0(ChangeLogIterator.java:133)
at liquibase.Scope.lambda$child$0(Scope.java:216)
at liquibase.Scope.child(Scope.java:225)
at liquibase.Scope.child(Scope.java:215)
at liquibase.Scope.child(Scope.java:194)
at liquibase.changelog.ChangeLogIterator.lambda$run$1(ChangeLogIterator.java:122)
at liquibase.Scope.lambda$child$0(Scope.java:216)
at liquibase.Scope.child(Scope.java:225)
at liquibase.Scope.child(Scope.java:215)
at liquibase.Scope.child(Scope.java:194)
at liquibase.Scope.child(Scope.java:282)
at liquibase.Scope.child(Scope.java:286)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:91)
… 53 common frames omitted

2

Hi nikhitha_chandana,

Can you please confirm your setup? The error comes from the lenses-agent. Did you already have 6.0 installed or you had an earlier version of Lenses (with a version earlier than 4.1.0) and used that state? If you already had 6.0 running, the migration should not be run again. What database are you using for the lenses-agent?