GitHub user dosubot[bot] added a comment to the discussion: Superset db upgrade is not triggering upgrade
<!-- Answer --> The best way to monitor a Superset upgrade is to tail the migration logs—Superset migration scripts log progress and warnings using the alembic.env logger. Look for messages like Progress: 1000/16000 (6.25%) or Upgraded X/Y charts in your logs; these indicate how far along the migration is and are especially useful for large metadata volumes. Not all migrations print detailed progress, but most major ones do, especially after recent updates for consistent logging ([details](https://github.com/apache/superset/pull/34521)). You can also monitor database activity with queries like SELECT * FROM pg_stat_activity WHERE query ILIKE '%alembic%'; to confirm the upgrade is running, but this won’t show percentage progress. To check if migrations have finished, inspect the alembic_version table in your metadata database—it should match the latest migration revision after a successful upgrade. If you don’t see progress logs, increase logging verbosity or check for errors or warnings in the logs. For long-running upgrades, monitoring both the logs and database activity is the most reliable way to track status and catch issues early. <!-- Dosu Comment Footer --> *To reply, just mention [@dosu](https://go.dosu.dev/dosubot).* --- <sup>How did I do? [Good](https://app.dosu.dev/response-feedback/e73d8690-3957-40d6-81cb-b22a8d35869b?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/e73d8690-3957-40d6-81cb-b22a8d35869b?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/e73d8690-3957-40d6-81cb-b22a8d35869b?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/e73d8690-3957-40d6-81cb-b22a8d35869b?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/e73d8690-3957-40d6-81cb-b22a8d35869b?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/e73d8690-3957-40d6-81cb-b22a8d35869b?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/e73d8690-3957-40d6-81cb-b22a8d35869b?feedback_type=other)</sup> [](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=github) [](https://cursor.com/link/prompt?text=The%20best%20way%20to%20monitor%20a%20Superset%20upgrade%20is%20to%20tail%20the%20migration%20logs%E2%80%94Superset%20migration%20scripts%20log%20progress%20and%20warnings%20using%20the%20alembic.env%20logger.%20Look%20for%20messages%20like%20Progress%3A%201000/16000%20%286.25%25%29%20or%20Upgraded%20X/Y%20charts%20in%20your%20logs%3B%20these%20indicate%20how%20far%20along%20the%20migration%20is%20and%20are%20especially%20useful%20for%20large%20metadata%20volumes.%20Not%20all%20migrations%20print%20detailed%20progress%2C%20but%20most%20major%20ones%20do%2C%20especially%20after%20recent%20updates%20for%20consistent%20logging%C2%A0%28%5Bdetails%5D%28https%3A//github.com/apache/superset/pull/34521%29%29.%0A%0AYou%20can%20also%20monitor%20database%20activ ity%20with%20queries%20like%20SELECT%20%2A%20FROM%20pg_stat_activity%20WHERE%20query%20ILIKE%20%27%25alembic%25%27%3B%20to%20confirm%20the%20upgrade%20is%20running%2C%20but%20this%20won%E2%80%99t%20show%20percentage%20progress.%20To%20check%20if%20migrations%20have%20finished%2C%20inspect%20the%20alembic_version%20table%20in%20your%20metadata%20database%E2%80%94it%20should%20match%20the%20latest%20migration%20revision%20after%20a%20successful%20upgrade.%0A%0AIf%20you%20don%E2%80%99t%20see%20progress%20logs%2C%20increase%20logging%20verbosity%20or%20check%20for%20errors%20or%20warnings%20in%20the%20logs.%20For%20long-running%20upgrades%2C%20monitoring%20both%20the%20logs%20and%20database%20activity%20is%20the%20most%20reliable%20way%20to%20track%20status%20and%20catch%20issues%20early.) [](https://go.dosu.dev/discord-bot) [](h ttps://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/discussions/37261) GitHub link: https://github.com/apache/superset/discussions/37261#discussioncomment-15545076 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
