render-examples / metabase Goto Github PK
View Code? Open in Web Editor NEWMetabase on Render
Home Page: https://render.com/docs/deploy-metabase
License: MIT License
Metabase on Render
Home Page: https://render.com/docs/deploy-metabase
License: MIT License
Hey folks,
I just tried setting up a Metabase instance alongside a fresh Render Postgres DB instance per the install guide.
(https://render.com/docs/deploy-metabase)
I ran into the following deployment crash loop in the logs, where it seems like the Metabase server was trying to run its initial DB migrations on the first launch and complained it could not because the database was holding onto a migration lock:
Jan 11 03:53:05 PM 2021-01-11 07:53:05,573 INFO db.liquibase :: Checking if Database has unrun migrations...
Jan 11 03:53:16 PM 2021-01-11 07:53:16,268 INFO db.liquibase :: Database has unrun migrations. Waiting for migration lock to be cleared...
Jan 11 03:53:18 PM 2021-01-11 07:53:18,274 WARN metabase.util :: auto-retry metabase.db.liquibase$wait_for_migration_lock_to_be_cleared$fn__20958@4df6d39c: Database has migration lock; cannot run migrations. You can force-release these locks by running `java -jar metabase.jar migrate release-locks`.
Jan 11 03:53:20 PM 2021-01-11 07:53:20,277 WARN metabase.util :: auto-retry metabase.db.liquibase$wait_for_migration_lock_to_be_cleared$fn__20958@4df6d39c: Database has migration lock; cannot run migrations. You can force-release these locks by running `java -jar metabase.jar migrate release-locks`.
Jan 11 03:53:22 PM 2021-01-11 07:53:22,279 WARN metabase.util :: auto-retry metabase.db.liquibase$wait_for_migration_lock_to_be_cleared$fn__20958@4df6d39c: Database has migration lock; cannot run migrations. You can force-release these locks by running `java -jar metabase.jar migrate release-locks`.
Jan 11 03:53:24 PM 2021-01-11 07:53:24,281 WARN metabase.util :: auto-retry metabase.db.liquibase$wait_for_migration_lock_to_be_cleared$fn__20958@4df6d39c: Database has migration lock; cannot run migrations. You can force-release these locks by running `java -jar metabase.jar migrate release-locks`.
Jan 11 03:53:26 PM 2021-01-11 07:53:26,284 WARN metabase.util :: auto-retry metabase.db.liquibase$wait_for_migration_lock_to_be_cleared$fn__20958@4df6d39c: Database has migration lock; cannot run migrations. You can force-release these locks by running `java -jar metabase.jar migrate release-locks`.
Jan 11 03:53:28 PM 2021-01-11 07:53:28,289 ERROR metabase.core :: Metabase Initialization FAILED
Jan 11 03:53:28 PM liquibase.exception.LockException: Database has migration lock; cannot run migrations. You can force-release these locks by running `java -jar metabase.jar migrate release-locks`.
Has anyone else run into this issue on first deployment?
I was able to jump into the Shell in the Render dashboard for the Metabase service and run the java -jar metabase.jar migrate release-locks
command.
But the migration lock seems to be a red herring, and the real underlying issue seems to be that the 512 MB of memory available for starter instances is simply not enough to feed the hungry, hungry JVM. It seems like Metabase crashes due to OOM in the middle of the initial migration process.
Maybe the Deploy guide should mention starter-plus
as the minimum advisable plan to deploy a Metabase instance?
I had been running Metabase on Render based on this for a while without issue and had saved some dashboards. It has been a couple months since I last logged in and when I visit the URL it's acting like it's a brand new installation, and I had to create my user account again, my data source is missing, etc. What happened?
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.