GitHub user dosubot[bot] added a comment to the discussion: Superset db upgrade is not triggering upgrade
<!-- Answer --> When the pid changes in your pg_stat_activity query, it means the database connection handling the migration has changed. This can happen if the migration script closes and reopens connections, processes batches in separate transactions, or if connection pooling is in use. It's normal for long-running migrations—especially those that process many dashboards or charts—to cycle through multiple connections, each with its own pid. Unless you see errors or the migration is stuck, changing pids is expected and not a sign of a problem. <!-- 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/824bc456-6992-4e12-a7cd-563d0f498277?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/824bc456-6992-4e12-a7cd-563d0f498277?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/824bc456-6992-4e12-a7cd-563d0f498277?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/824bc456-6992-4e12-a7cd-563d0f498277?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/824bc456-6992-4e12-a7cd-563d0f498277?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/824bc456-6992-4e12-a7cd-563d0f498277?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/824bc456-6992-4e12-a7cd-563d0f498277?feedback_type=other)</sup> [](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=github) [](https://cursor.com/link/prompt?text=When%20the%20pid%20changes%20in%20your%20pg_stat_activity%20query%2C%20it%20means%20the%20database%20connection%20handling%20the%20migration%20has%20changed.%20This%20can%20happen%20if%20the%20migration%20script%20closes%20and%20reopens%20connections%2C%20processes%20batches%20in%20separate%20transactions%2C%20or%20if%20connection%20pooling%20is%20in%20use.%20It%27s%20normal%20for%20long-running%20migrations%E2%80%94especially%20those%20that%20process%20many%20dashboards%20or%20charts%E2%80%94to%20cycle%20through%20multiple%20connections%2C%20each%20with%20its%20own%20pid.%20Unless%20you%20see%20errors%20or%20the%20migration%20is%20stuck%2C%20changing%20pids%20is%20expected%20and%20not%20a%20sign%20of%20a%20problem.) [](https://go.dosu.dev/discord-bot) [](https://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-15544968 ---- 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]
