Jar file stuck in a loop on upgrading

Upgrading to 0.29.2: Launched overnight and it went thru several loops by morning… Any idea of what could possibly be going on here would be appreciated. Thanks!

  1. filed the old jar file away and put the new one in it’s place
  2. ran command prompt as admin and cd to jar file location
  3. ran jar file: java -jar metabase.jar

Output repeats starting with:
05-11 05:50:00 ←[1mDEBUG sync.util←[0m :: Sync operations in flight: {:sync-meta
data #{1}}

And ending with the Server SQL db joined in:
05-11 06:00:01 ←[1mINFO sync.util←[0m :: FINISHED: Sync metadata for sqlserver D
atabase 65 ‘DashBase’ (2 s)

The only detectable issue is in between this step seems to take an inordinate amount of time:
05-11 05:50:00 ←[1mINFO sync.util←[0m :: STARTING: Sync metadata for h2 Database
1 ‘Sample Dataset’
05-11 05:50:00 ←[1mINFO sync.util←[0m :: FINISHED: Sync metadata for h2 Database
1 ‘Sample Dataset’ (191 ms)

Metabase: 0.28.1
Java: 1.8.0_45
Databases: H2 internal default, Server SQL external (joined in)
Localhost:3000
Microsoft Windows [Version 6.0.6002]

Hi, @mesquest. I saw your other post asking about how to stop a running process in the Windows command prompt, so I just wanted to double check that you’re sure you stopped the previous Metabase version from running before you swapped in the new Jar file.

If so, maybe @camsaul has ideas of what else could be going on here.

Thanks @maz, no I didn’t do anything special. I only moved the old jar file into another folder in the same directory and rebooted my machine to make certain everything started fresh. Are they bumping into each other even though the old one is in another folder?

I’ve been hesitant to post the opening apparently successful section of code due to it’s length but perhaps it could save time trying to reproduce the behavior:

Microsoft Windows [Version 6.0.6002]
Copyright © 2006 Microsoft Corporation. All rights reserved.

C:\Windows\system32>cd c:\Program Files\Metabase

c:\Program Files\Metabase>java -jar metabase.jar
05-11 10:18:43 ←[1mINFO metabase.util←[0m :: Loading Metabase…
05-11 10:18:57 ←[1mINFO util.encryption←[0m :: DB details encryption is DISABLED
for this Metabase instance.
See http://www.metabase.com/docs/latest/operations-guide/start.html#encrypting-y
our-database-connection-details-at-rest for more information.
java.io.FileNotFoundException: C:\Program%20Files\Metabase\metabase.jar (The sys
tem cannot find the path specified)
05-11 10:19:45 ←[1mINFO metabase.core←[0m :: Starting Metabase in STANDALONE mod
e
05-11 10:19:45 ←[1mINFO metabase.core←[0m :: Launching Embedded Jetty Webserver
with config:
{:port 3000}

05-11 10:19:46 ←[1mINFO metabase.core←[0m :: Starting Metabase version v0.29.2 (
db39083 release-0.29.2) …
05-11 10:19:46 ←[1mINFO metabase.core←[0m :: System timezone is ‘America/Los_Ang
eles’ …
05-11 10:19:53 ←[1mINFO metabase.core←[0m :: Setting up and migrating Metabase D
B. Please sit tight, this may take a minute…
05-11 10:19:53 ←[1mINFO metabase.db←[0m :: Verifying h2 Database Connection …
05-11 10:19:55 ←[1mINFO metabase.db←[0m :: Verify Database Connection …
05-11 10:19:55 ←[1mINFO metabase.db←[0m :: Running Database Migrations…
05-11 10:19:55 ←[1mINFO metabase.db←[0m :: Setting up Liquibase…
05-11 10:19:55 ←[1mINFO metabase.db←[0m :: Liquibase is ready.
05-11 10:19:55 ←[1mINFO metabase.db←[0m :: Checking if Database has unrun migrat
ions…
05-11 10:20:11 ←[1mINFO metabase.db←[0m :: Database Migrations Current …
com.mchange.v2.cfg.DelayedLogItem [ level -> FINE, text -> “The configuration fi
le for resource identifier ‘hocon:/reference,/application,/c3p0,/’ could not be
found. Skipping.”, exception -> null]
05-11 10:20:11 ←[1mINFO db.migrations←[0m :: Running all necessary data migratio
ns, this may take a minute.
05-11 10:20:11 ←[1mINFO db.migrations←[0m :: Finished running data migrations.
05-11 10:20:12 ←[1mINFO metabase.events←[0m :: Starting events listener: metabas
e.events.notifications
05-11 10:20:12 ←[1mINFO metabase.events←[0m :: Starting events listener: metabas
e.events.metabot-lifecycle
05-11 10:20:12 ←[1mINFO metabase.events←[0m :: Starting events listener: metabas
e.events.dependencies
05-11 10:20:12 ←[1mINFO metabase.events←[0m :: Starting events listener: metabas
e.events.activity-feed
05-11 10:20:13 ←[1mINFO metabase.events←[0m :: Starting events listener: metabas
e.events.last-login
05-11 10:20:13 ←[1mINFO metabase.events←[0m :: Starting events listener: metabas
e.events.revision
05-11 10:20:13 ←[1mINFO metabase.events←[0m :: Starting events listener: metabas
e.events.sync-database
05-11 10:20:13 ←[1mINFO metabase.events←[0m :: Starting events listener: metabas
e.events.view-log
05-11 10:20:13 ←[1mINFO metabase.events←[0m :: Starting events listener: metabas
e.events.driver-notifications
05-11 10:20:13 ←[1mINFO metabase.task←[0m :: Loading tasks namespace: metabase.t
ask.send-anonymous-stats
05-11 10:20:13 ←[1mINFO metabase.task←[0m :: Loading tasks namespace: metabase.t
ask.sync-databases
05-11 10:20:13 ←[1mINFO metabase.task←[0m :: Loading tasks namespace: metabase.t
ask.cleanup-temporary-computation-job-results
05-11 10:20:13 ←[1mINFO metabase.task←[0m :: Loading tasks namespace: metabase.t
ask.upgrade-checks
05-11 10:20:13 ←[1mINFO metabase.task←[0m :: Loading tasks namespace: metabase.t
ask.follow-up-emails
05-11 10:20:13 ←[1mINFO metabase.task←[0m :: Loading tasks namespace: metabase.t
ask.send-pulses
05-11 10:20:13 ←[1mINFO metabase.core←[0m :: Metabase Initialization COMPLETE

Issue apparently resolved itself on a third go. Now able to log-in via http://localhost:3000, the admin panel indicates v0.29.2, and everything appears to have migrated and is functional… No clue as to what could have possibly caused the loop issue… My apologies for having taken up everyone’s valuable time, thank you for your patience and input!

Spoke too soon, issue remains. Uninstalled Composer (installed few hours prior to all this) and trying again. If issue persists will open up a GitHub ticket.

Gave up, unable to re-establish even with the old jar file… Submitted GitHub ticket #7628

=====
ISSUE RESOLVED!

Double clicking the jar file THEN immediately launching from the command prompt w/ java -jar metabase.jar — That solves the problem! — This also applies w/ java -jar metabase.jar migrate release-locks.

Took a chance that it would do the trick because normally when downloading software in the form of exe files one simply double clicks to launch the installation process.

Nowhere in the Running the Metabase Jar File or elsewhere (that I can find) is this minor detail mentioned.