Unable to update to 0.44 JAVA

1

Hi,

I was able to update to 0.44 on my own computer.
But for a client i'm unable to upgrade. (same setup/java installation).

image

This is the last thing i see, "Verifying postgres database connection". it takes like 10 to 20 seconds, and then the window closes.

I was able to just put back the older metabase jar file.

This is the diagnostic info:

{
"browser-info": {
"language": "nl-NL",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.0.0 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "Cp1252",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.13+8",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.13",
"java.vm.name": "OpenJDK Client VM",
"java.vm.version": "11.0.13+8",
"os.name": "Windows 8.1",
"os.version": "6.3",
"user.language": "nl",
"user.timezone": "Europe/Paris"
},
"metabase-info": {
"databases": [
"postgres"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "14.2"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.3.2"
}
},
"run-mode": "prod",
"version": {
"date": "2022-07-29",
"tag": "v0.43.4.2",
"branch": "release-x.43.x",
"hash": "7809f82"
},
"settings": {
"report-timezone": "Europe/Brussels"
}
}
}

2

Hi @cobalt
Try not running in a window, but open the cmd and run the command, so the output stays at the end.
Which envvar are you using, MB_DB_CONNECTION_URI or the separated MB_DB_HOST/PORT/etc ?
Do you even see a connection from Metabase to Postgres in the Postgres logs?
Could it be some Windows firewall blocking, since it's a new JAR file?

3

Normally it's running in the background, but i opend it this way to see if I could see something.
This is the string to open:

start java -jar -DMB_DB_TYPE=postgres -DMB_DB_DBNAME=Metabase -DMB_DB_PORT=5433 -DMB_DB_USER=*** -DMB_DB_PASS=*** metabase.jar

In the PgAdmin server activity - sessions window, i don't see any new connection coming in.

4

@cobalt Where's MB_DB_HOST ? I would probably recommend using MB_DB_CONNECTION_URI instead of individual envvars.

5

As soon as i place in -MB_DB_HOST=localhost my batch file is not running anymore.
Not quite sure how to setup the [MB_DB_CONNECTION_URI ] for a local installation.

But it always worked the way I've posted here, also on my local laptop it works that way.

6

@cobalt Like with all the other envvars, you have to prefix with -D when using Java command line parameters.
-DMB_DB_CONNECTION_URI="jdbc:postgresql://localhost:5433/Metabase?user=YOURUSER&password=YOURPASS"

1 Like
7

Wow, i don't know how that can make such a difference.
Thanks a lot flamber! Changing it to that way, makes everything work again!
Really appreciate it! :smiling_face_with_three_hearts: