Repeated registering/de-registering loop when upgrading to 0.43.4

Bug reports
1

Issue:
When upgrading from 0.41.4 to 0.43.4, I encountered repeated registering/de-registering targets. This was not an issue w/ upgrading to 0.42.4.

I'm using Convox CLI for docker image deployment (AWS RDS is the application database backup). The command that associated w/ this following output was: convox deploy --wait

34%20AM
34%20AM2868×426 109 KB

The convox.yml looks like this:

57%20AM
57%20AM974×1038 63.8 KB

Looking at the traceback of the error, occurring after installing various database drivers:

2022-06-28 14:16:48,671 INFO db.setup :: Running Database Migrations...
2022-06-28 14:16:48,673 INFO db.setup :: Setting up Liquibase...
2022-06-28 14:16:48,832 ERROR metabase.core :: Metabase Initialization FAILED
Traceback:
java.lang.NullPointerException
at liquibase.configuration.AbstractMapConfigurationValueProvider.keyMatches(AbstractMapConfigurationValueProvider.java:140)
at liquibase.configuration.pro.EnvironmentValueProvider.keyMatches(Unknown Source)
at liquibase.configuration.AbstractMapConfigurationValueProvider.lookupProvidedValue(AbstractMapConfigurationValueProvider.java:105)
at liquibase.configuration.pro.EnvironmentValueProvider.lookupProvidedValue(Unknown Source)
at liquibase.configuration.AbstractMapConfigurationValueProvider.getProvidedValue(AbstractMapConfigurationValueProvider.java:52)
at liquibase.configuration.LiquibaseConfiguration.getCurrentConfiguredValue(LiquibaseConfiguration.java:123)
at liquibase.configuration.ConfigurationDefinition.getCurrentConfiguredValue(ConfigurationDefinition.java:93)
at liquibase.license.pro.DaticalTrueLicenseService.licenseIsInstalled(Unknown Source)
at liquibase.license.pro.DaticalTrueLicenseService.licenseIsValid(Unknown Source)
at liquibase.configuration.pro.EnvironmentValueProvider.lookupProvidedValue(Unknown Source)
at liquibase.configuration.AbstractMapConfigurationValueProvider.getProvidedValue(AbstractMapConfigurationValueProvider.java:52)
at liquibase.configuration.LiquibaseConfiguration.getCurrentConfiguredValue(LiquibaseConfiguration.java:123)
at liquibase.configuration.ConfigurationDefinition.getCurrentConfiguredValue(ConfigurationDefinition.java:93)
at liquibase.configuration.ConfigurationDefinition.getCurrentValue(ConfigurationDefinition.java:61)
at liquibase.database.AbstractJdbcDatabase.getDatabaseChangeLogLockTableName(AbstractJdbcDatabase.java:641)
at liquibase.database.core.PostgresDatabase.getDatabaseChangeLogLockTableName(PostgresDatabase.java:162)
at liquibase.changelog.ChangeLogParameters.(ChangeLogParameters.java:45)
at liquibase.Liquibase.(Liquibase.java:119)
at metabase.db.liquibase$liquibase.invokeStatic(liquibase.clj:48)
at metabase.db.liquibase$liquibase.invoke(liquibase.clj:48)
at metabase.db.liquibase$fn__30492$do_with_liquibase__30497$fn__30498.invoke(liquibase.clj:59)
at metabase.db.liquibase$fn__30492$do_with_liquibase__30497.invoke(liquibase.clj:51)
at metabase.db.setup$fn__34835$migrate_BANG___34840$fn__34841.invoke(setup.clj:63)
at metabase.db.setup$fn__34835$migrate_BANG___34840.invoke(setup.clj:40)
at metabase.db.setup$fn__34894$run_schema_migrations_BANG___34899$fn__34900.invoke(setup.clj:121)
at metabase.db.setup$fn__34894$run_schema_migrations_BANG___34899.invoke(setup.clj:115)
at metabase.db.setup$fn__34946$setup_db_BANG___34951$fn__34952$fn__34955$fn__34956.invoke(setup.clj:147)
at metabase.util$do_with_us_locale.invokeStatic(util.clj:715)
at metabase.util$do_with_us_locale.invoke(util.clj:701)
at metabase.db.setup$fn__34946$setup_db_BANG___34951$fn__34952$fn__34955.invoke(setup.clj:145)
at metabase.db.setup$fn__34946$setup_db_BANG___34951$fn__34952.invoke(setup.clj:144)
at metabase.db.setup$fn__34946$setup_db_BANG___34951.invoke(setup.clj:138)
at metabase.db$setup_db_BANG_$fn__34981.invoke(db.clj:65)
at metabase.db$setup_db_BANG_.invokeStatic(db.clj:60)
at metabase.db$setup_db_BANG_.invoke(db.clj:51)
at metabase.core$init_BANG__STAR_.invokeStatic(core.clj:98)
at metabase.core$init_BANG__STAR_.invoke(core.clj:81)
at metabase.core$init_BANG_.invokeStatic(core.clj:138)
at metabase.core$init_BANG_.invoke(core.clj:133)
at metabase.core$start_normally.invokeStatic(core.clj:150)
at metabase.core$start_normally.invoke(core.clj:144)
at metabase.core$_main.invokeStatic(core.clj:183)
at metabase.core$_main.doInvoke(core.clj:177)
at clojure.lang.RestFn.invoke(RestFn.java:397)
at clojure.lang.AFn.applyToHelper(AFn.java:152)
at clojure.lang.RestFn.applyTo(RestFn.java:132)
at metabase.core.main(Unknown Source)

2

Hi @zhong
I'm not sure what is going on, but try including the logs from startup to failure. It looks like it is failure during migration script, but there isn't a lot of information why.
What is the format of your MB_DB_CONNECTION_URI?
https://www.metabase.com/docs/latest/operations-guide/environment-variables.html#mb_db_connection_uri

3

Hi @flamber, thanks for taking a look!

The MB_DB_CONNECTION_URI = postgres://redacted_user_name:edacted_password@production-metabase-resourcedatabase-redacted.csubuondvhua.us-east-1.rds.amazonaws.com:5432/app

Sure, here's the log output:

56%20PM
56%20PM2906×1678 1.06 MB
Screen Shot 2022-06-30 at 4.59.56 PM

4

@zhong I cannot see the Metabase logs, it's just showing convox logs. Change to this format:
https://www.metabase.com/docs/latest/operations-guide/environment-variables.html#mb_db_connection_uri

5

Hi @flamber,

Thanks. Just double-checking, was for the MB_DB_CONNECTION_URI, it' (I redacted credentials, it's RDS on AWS):
postgres://redacted_user_name:edacted_password@production-metabase-resourcedatabase-redacted.csubuondvhua.us-east-1.rds.amazonaws.com:5432/app

As for the metabase log, will the traceback in my original post satisfy your needs? It hints at issues when setting up Liquidbase, where a variable seemed not defined per java.lang.NullPointerException.

Or perhaps you're suspecting that some environment variables were not configured correctly?

6

@zhong
jdbc:postgresql://YOURHOST:5432/YOURDB?user=YOURUSER&password=YOURPASS

7

Thank you @flamber, I'll give it another try.