René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Migration failing due to too many range table entries","articleBody":"On the upgrade from version 4.7 to 4.8 the migration [m_209_to_m_210_add_updated_at_to_network_flows_v2](https://github.com/stackrox/stackrox/tree/master/migrator/migrations/m_209_to_m_210_add_updated_at_to_network_flows_v2) fails with error \n\n```\n{\"level\":\"Info\",\"time\":\"2025-09-30T09:01:41.356469287Z\",\"name\":\"Migrator\",\"caller\":\"log.go:18\",\"msg\":\"unable to alter table network_flows_v2: unable to update column updatedat: ERROR: too many range table entries (SQLSTATE 54000)\"}\n{\"level\":\"Info\",\"time\":\"2025-09-30T09:01:41.357212389Z\",\"name\":\"Migrator\",\"caller\":\"log.go:18\",\"msg\":\"Migrator failed: ERROR: too many range table entries (SQLSTATE 54000)\\nunable to update column updatedat\\ngithub.com/stackrox/rox/migrator/migrations/m_209_to_m_210_add_updated_at_to_network_flows_v2.addColumnToTable\\n\\tgithub.com/stackrox/rox/migrator/migrations/m_209_to_m_210_add_updated_at_to_network_flows_v2/migration_impl.go:52\\ngithub.com/stackrox/rox/migrator/migrations/m_209_to_m_210_add_updated_at_to_network_flows_v2.migrate\\n\\tgithub.com/stackrox/rox/migrator/migrations/m_209_to_m_210_add_updated_at_to_network_flows_v2/migration_impl.go:23\\ngithub.com/stackrox/rox/migrator/runner.runMigrations\\n\\tgithub.com/stackrox/rox/migrator/runner/runner.go:103\\ngithub.com/stackrox/rox/migrator/runner.Run\\n\\tgithub.com/stackrox/rox/migrator/runner/runner.go:62\\nmain.upgrade\\n\\tgithub.com/stackrox/rox/migrator/upgrade.go:50\\nmain.run\\n\\tgithub.com/stackrox/rox/migrator/main.go:88\\nmain.main\\n\\tgithub.com/stackrox/rox/migrator/main.go:24\\nruntime.main\\n\\truntime/proc.go:272\\nruntime.goexit\\n\\truntime/asm_amd64.s:1700\\nerror running migration starting at 209\\ngithub.com/stackrox/rox/migrator/runner.runMigrations\\n\\tgithub.com/stackrox/rox/migrator/runner/runner.go:105\\ngithub.com/stackrox/rox/migrator/runner.Run\\n\\tgithub.com/stackrox/rox/migrator/runner/runner.go:62\\nmain.upgrade\\n\\tgithub.com/stackrox/rox/migrator/upgrade.go:50\\nmain.run\\n\\tgithub.com/stackrox/rox/migrator/main.go:88\\nmain.main\\n\\tgithub.com/stackrox/rox/migrator/main.go:24\\nruntime.main\\n\\truntime/proc.go:272\\nruntime.goexit\\n\\truntime/asm_amd64.s:1700\\nmigrations failed\\nmain.upgrade\\n\\tgithub.com/stackrox/rox/migrator/upgrade.go:55\\nmain.run\\n\\tgithub.com/stackrox/rox/migrator/main.go:88\\nmain.main\\n\\tgithub.com/stackrox/rox/migrator/main.go:24\\nruntime.main\\n\\truntime/proc.go:272\\nruntime.goexit\\n\\truntime/asm_amd64.s:1700\"}\n```\n\nChecking the network_flows_v2 table, it has 488 partitions, which I believe is causing the issue. \n\nThis blocks the upgrade.\n\nIs there a way to circumvent this issue? \nShould there be a cleanup process for this information?\n\nThanks\n","author":{"url":"https://github.com/luciamota","@type":"Person","name":"luciamota"},"datePublished":"2025-09-30T15:02:02.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":5},"url":"https://github.com/17075/stackrox/issues/17075"}