Skip to content

Can't DROP COLUMN SelectSeries, migration failing #7098

@grantfitzsimmons

Description

@grantfitzsimmons

I am experiencing a migration failure consistently now after updating a database from v7.11.0 directly to main.

Possibly related to #6942

django.db.utils.OperationalError: (1091, "Can't DROP COLUMN SelectSeries; check that it exists")

When running docker compose up --build locally in a new copy of the naturkundemuseum database, I get the following:

2025-07-16 09:26:20 Updating static files in /volumes/static-files/.
2025-07-16 09:26:20 Applying Django migrations.
2025-07-16 09:26:24 Operations to perform:
2025-07-16 09:26:24   Apply all migrations: accounts, attachment_gw, auth, businessrules, contenttypes, notifications, patches, permissions, sessions, specify, workbench
2025-07-16 09:26:24 Running migrations:
2025-07-16 09:27:35   Applying specify.0032_add_quantities_gift... OK
2025-07-16 09:27:35   Applying specify.0033_update_paleo_desc... OK
2025-07-16 09:27:51   Applying specify.0034_accession_date_fields... OK
2025-07-16 09:30:04   Applying specify.0035_version_required... OK
2025-07-16 09:30:04   Applying patches.0004_add_title_tree_rank_fix... OK
2025-07-16 09:30:05   Applying patches.0005_chrono_start_end... OK
2025-07-16 09:31:43   Applying patches.0006_version_fix... OK
2025-07-16 09:31:43 Traceback (most recent call last):
2025-07-16 09:31:43   File "/opt/specify7/ve/lib/python3.9/site-packages/django/db/backends/utils.py", line 89, in _execute
2025-07-16 09:31:43     return self.cursor.execute(sql, params)
2025-07-16 09:31:43   File "/opt/specify7/ve/lib/python3.9/site-packages/django/db/backends/mysql/base.py", line 75, in execute
2025-07-16 09:31:43     return self.cursor.execute(query, args)
2025-07-16 09:31:43   File "/opt/specify7/ve/lib/python3.9/site-packages/MySQLdb/cursors.py", line 206, in execute
2025-07-16 09:31:43     res = self._query(query)
2025-07-16 09:31:43   File "/opt/specify7/ve/lib/python3.9/site-packages/MySQLdb/cursors.py", line 319, in _query
2025-07-16 09:31:43     db.query(q)
2025-07-16 09:31:43   File "/opt/specify7/ve/lib/python3.9/site-packages/MySQLdb/connections.py", line 254, in query
2025-07-16 09:31:43     _mysql.connection.query(self, query)
2025-07-16 09:31:43 MySQLdb.OperationalError: (1091, "Can't DROP COLUMN `SelectSeries`; check that it exists")
2025-07-16 09:31:43 
2025-07-16 09:31:43 The above exception was the direct cause of the following exception:
2025-07-16 09:31:43 
2025-07-16 09:31:43 Traceback (most recent call last):
2025-07-16 09:31:43   File "/opt/specify7/manage.py", line 25, in <module>
2025-07-16 09:31:43     execute_from_command_line(sys.argv)
2025-07-16 09:31:43   File "/opt/specify7/ve/lib/python3.9/site-packages/django/core/management/__init__.py", line 442, in execute_from_command_line
2025-07-16 09:31:43     utility.execute()
2025-07-16 09:31:43   File "/opt/specify7/ve/lib/python3.9/site-packages/django/core/management/__init__.py", line 436, in execute
2025-07-16 09:31:43     self.fetch_command(subcommand).run_from_argv(self.argv)
2025-07-16 09:31:43   File "/opt/specify7/ve/lib/python3.9/site-packages/django/core/management/base.py", line 412, in run_from_argv
2025-07-16 09:31:43     self.execute(*args, **cmd_options)
2025-07-16 09:31:43   File "/opt/specify7/ve/lib/python3.9/site-packages/django/core/management/base.py", line 458, in execute
2025-07-16 09:31:43     output = self.handle(*args, **options)
2025-07-16 09:31:43   File "/opt/specify7/ve/lib/python3.9/site-packages/django/core/management/base.py", line 106, in wrapper
2025-07-16 09:31:43     res = handle_func(*args, **kwargs)
2025-07-16 09:31:43   File "/opt/specify7/ve/lib/python3.9/site-packages/django/core/management/commands/migrate.py", line 356, in handle
2025-07-16 09:31:43     post_migrate_state = executor.migrate(
2025-07-16 09:31:43   File "/opt/specify7/ve/lib/python3.9/site-packages/django/db/migrations/executor.py", line 135, in migrate
2025-07-16 09:31:43     state = self._migrate_all_forwards(
2025-07-16 09:31:43   File "/opt/specify7/ve/lib/python3.9/site-packages/django/db/migrations/executor.py", line 167, in _migrate_all_forwards
2025-07-16 09:31:43     state = self.apply_migration(
2025-07-16 09:31:43   File "/opt/specify7/ve/lib/python3.9/site-packages/django/db/migrations/executor.py", line 252, in apply_migration
2025-07-16 09:31:43     state = migration.apply(state, schema_editor)
2025-07-16 09:31:43   File "/opt/specify7/ve/lib/python3.9/site-packages/django/db/migrations/migration.py", line 132, in apply
2025-07-16 09:31:43     operation.database_forwards(
2025-07-16 09:31:43   File "/opt/specify7/ve/lib/python3.9/site-packages/django/db/migrations/operations/fields.py", line 170, in database_forwards
2025-07-16 09:31:43     schema_editor.remove_field(
2025-07-16 09:31:43   File "/opt/specify7/ve/lib/python3.9/site-packages/django/db/backends/base/schema.py", line 767, in remove_field
2025-07-16 09:31:43     self.execute(sql)
2025-07-16 09:31:43   File "/opt/specify7/ve/lib/python3.9/site-packages/django/db/backends/base/schema.py", line 201, in execute
2025-07-16 09:31:43     cursor.execute(sql, params)
2025-07-16 09:31:43   File "/opt/specify7/ve/lib/python3.9/site-packages/django/db/backends/utils.py", line 102, in execute
2025-07-16 09:31:43     return super().execute(sql, params)
2025-07-16 09:31:43   File "/opt/specify7/ve/lib/python3.9/site-packages/django/db/backends/utils.py", line 67, in execute
2025-07-16 09:31:43     return self._execute_with_wrappers(
2025-07-16 09:31:43   File "/opt/specify7/ve/lib/python3.9/site-packages/django/db/backends/utils.py", line 80, in _execute_with_wrappers
2025-07-16 09:31:43     return executor(sql, params, many, context)
2025-07-16 09:31:43   File "/opt/specify7/ve/lib/python3.9/site-packages/django/db/backends/utils.py", line 89, in _execute
2025-07-16 09:31:43     return self.cursor.execute(sql, params)
2025-07-16 09:31:43   File "/opt/specify7/ve/lib/python3.9/site-packages/django/db/utils.py", line 91, in __exit__
2025-07-16 09:31:43     raise dj_exc_value.with_traceback(traceback) from exc_value
2025-07-16 09:31:43   File "/opt/specify7/ve/lib/python3.9/site-packages/django/db/backends/utils.py", line 89, in _execute
2025-07-16 09:31:43     return self.cursor.execute(sql, params)
2025-07-16 09:31:43   File "/opt/specify7/ve/lib/python3.9/site-packages/django/db/backends/mysql/base.py", line 75, in execute
2025-07-16 09:31:43     return self.cursor.execute(query, args)
2025-07-16 09:31:43   File "/opt/specify7/ve/lib/python3.9/site-packages/MySQLdb/cursors.py", line 206, in execute
2025-07-16 09:31:43     res = self._query(query)
2025-07-16 09:31:43   File "/opt/specify7/ve/lib/python3.9/site-packages/MySQLdb/cursors.py", line 319, in _query
2025-07-16 09:31:43     db.query(q)
2025-07-16 09:31:43   File "/opt/specify7/ve/lib/python3.9/site-packages/MySQLdb/connections.py", line 254, in query
2025-07-16 09:31:43     _mysql.connection.query(self, query)
2025-07-16 09:31:43 django.db.utils.OperationalError: (1091, "Can't DROP COLUMN `SelectSeries`; check that it exists")
2025-07-16 09:31:47 Watching for file changes with StatReloader

Metadata

Metadata

Assignees

No one assigned

    Labels

    MigrationPrs that contain migration

    Type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions