Phenomena

When I run python manage.py migrate --database=mysql

sqlite3: it works

mysql: this error happened:


Running migrations:
Applying contenttypes.0001_initial... OK
Applying auth.0001_initial... OK
Applying admin.0001_initial... OK
Applying admin.0002_logentry_remove_auto_add... OK
Applying admin.0003_logentry_add_action_flag_choices... OK
Applying contenttypes.0002_remove_content_type_name... OK
Applying auth.0002_alter_permission_name_max_length... OK
Applying auth.0003_alter_user_email_max_length... OK
Applying auth.0004_alter_user_username_opts... OK
Applying auth.0005_alter_user_last_login_null... OK
Applying auth.0006_require_contenttypes_0002... OK
Applying auth.0007_alter_validators_add_error_messages... OK
Applying auth.0008_alter_user_username_max_length... OK
Applying auth.0009_alter_user_last_name_max_length... OK
Applying auth.0010_alter_group_name_max_length... OK
Applying auth.0011_update_proxy_permissions... OK
Applying auth.0012_alter_user_first_name_max_length... OK
Applying wagtailcore.0001_squashed_0016_change_page_url_path_to_text_field...Traceback (most recent call last):
File "/Users/jiahao.chen/workspace/opensource/bakerydemo/venv/lib/python3.11/site-packages/django/db/backends/utils.py", line 89, in _execute
return self.cursor.execute(sql, params)
       ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/jiahao.chen/workspace/opensource/bakerydemo/venv/lib/python3.11/site-packages/django/db/backends/sqlite3/base.py", line 328, in execute
return super().execute(query, params)
       ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
sqlite3.IntegrityError: NOT NULL constraint failed: wagtailcore_page.draft_title

The above exception was the direct cause of the following exception:

Traceback (most recent call last): File "/Users/jiahao.chen/workspace/opensource/bakerydemo/manage.py", line 14, in execute_from_command_line(sys.argv) File "/Users/jiahao.chen/workspace/opensource/bakerydemo/venv/lib/python3.11/site-packages/django/core/management/init.py", line 442, in execute_from_command_line utility.execute() File "/Users/jiahao.chen/workspace/opensource/bakerydemo/venv/lib/python3.11/site-packages/django/core/management/init.py", line 436, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "/Users/jiahao.chen/workspace/opensource/bakerydemo/venv/lib/python3.11/site-packages/django/core/management/base.py", line 412, in run_from_argv self.execute(*args, cmd_options) File "/Users/jiahao.chen/workspace/opensource/bakerydemo/venv/lib/python3.11/site-packages/django/core/management/base.py", line 458, in execute output = self.handle(*args, *options) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/Users/jiahao.chen/workspace/opensource/bakerydemo/venv/lib/python3.11/site-packages/django/core/management/base.py", line 106, in wrapper res = handle_func(args, kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/Users/jiahao.chen/workspace/opensource/bakerydemo/venv/lib/python3.11/site-packages/django/core/management/commands/migrate.py", line 356, in handle post_migrate_state = executor.migrate( ^^^^^^^^^^^^^^^^^ File "/Users/jiahao.chen/workspace/opensource/bakerydemo/venv/lib/python3.11/site-packages/django/db/migrations/executor.py", line 135, in migrate state = self._migrate_all_forwards( ^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/Users/jiahao.chen/workspace/opensource/bakerydemo/venv/lib/python3.11/site-packages/django/db/migrations/executor.py", line 167, in _migrate_all_forwards state = self.apply_migration( ^^^^^^^^^^^^^^^^^^^^^ File "/Users/jiahao.chen/workspace/opensource/bakerydemo/venv/lib/python3.11/site-packages/django/db/migrations/executor.py", line 252, in apply_migration state = migration.apply(state, schema_editor) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/Users/jiahao.chen/workspace/opensource/bakerydemo/venv/lib/python3.11/site-packages/django/db/migrations/migration.py", line 127, in apply operation.database_forwards( File "/Users/jiahao.chen/workspace/opensource/bakerydemo/venv/lib/python3.11/site-packages/django/db/migrations/operations/special.py", line 193, in database_forwards self.code(from_state.apps, schema_editor) File "/Users/jiahao.chen/workspace/opensource/bakerydemo/venv/lib/python3.11/site-packages/wagtail/migrations/0001_squashed_0016_change_page_url_path_to_text_field.py", line 21, in initial_data root = Page.objects.create( ^^^^^^^^^^^^^^^^^^^^ File "/Users/jiahao.chen/workspace/opensource/bakerydemo/venv/lib/python3.11/site-packages/django/db/models/manager.py", line 87, in manager_method return getattr(self.get_queryset(), name)(*args, *kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/Users/jiahao.chen/workspace/opensource/bakerydemo/venv/lib/python3.11/site-packages/django/db/models/query.py", line 658, in create obj.save(force_insert=True, using=self.db) File "/Users/jiahao.chen/workspace/opensource/bakerydemo/venv/lib/python3.11/site-packages/django/db/models/base.py", line 814, in save self.save_base( File "/Users/jiahao.chen/workspace/opensource/bakerydemo/venv/lib/python3.11/site-packages/django/db/models/base.py", line 877, in save_base updated = self._save_table( ^^^^^^^^^^^^^^^^^ File "/Users/jiahao.chen/workspace/opensource/bakerydemo/venv/lib/python3.11/site-packages/django/db/models/base.py", line 1020, in _save_table results = self._do_insert( ^^^^^^^^^^^^^^^^ File "/Users/jiahao.chen/workspace/opensource/bakerydemo/venv/lib/python3.11/site-packages/django/db/models/base.py", line 1061, in _do_insert return manager._insert( ^^^^^^^^^^^^^^^^ File "/Users/jiahao.chen/workspace/opensource/bakerydemo/venv/lib/python3.11/site-packages/django/db/models/manager.py", line 87, in manager_method return getattr(self.get_queryset(), name)(args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/Users/jiahao.chen/workspace/opensource/bakerydemo/venv/lib/python3.11/site-packages/django/db/models/query.py", line 1805, in _insert return query.get_compiler(using=using).execute_sql(returning_fields) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/Users/jiahao.chen/workspace/opensource/bakerydemo/venv/lib/python3.11/site-packages/django/db/models/sql/compiler.py", line 1822, in execute_sql cursor.execute(sql, params) File "/Users/jiahao.chen/workspace/opensource/bakerydemo/venv/lib/python3.11/site-packages/django/db/backends/utils.py", line 102, in execute return super().execute(sql, params) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/Users/jiahao.chen/workspace/opensource/bakerydemo/venv/lib/python3.11/site-packages/django/db/backends/utils.py", line 67, in execute return self._execute_with_wrappers( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/Users/jiahao.chen/workspace/opensource/bakerydemo/venv/lib/python3.11/site-packages/django/db/backends/utils.py", line 80, in _execute_with_wrappers return executor(sql, params, many, context) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/Users/jiahao.chen/workspace/opensource/bakerydemo/venv/lib/python3.11/site-packages/django/db/backends/utils.py", line 84, in _execute with self.db.wrap_database_errors: File "/Users/jiahao.chen/workspace/opensource/bakerydemo/venv/lib/python3.11/site-packages/django/db/utils.py", line 91, in exit raise dj_exc_value.with_traceback(traceback) from exc_value File "/Users/jiahao.chen/workspace/opensource/bakerydemo/venv/lib/python3.11/site-packages/django/db/backends/utils.py", line 89, in _execute return self.cursor.execute(sql, params) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/Users/jiahao.chen/workspace/opensource/bakerydemo/venv/lib/python3.11/site-packages/django/db/backends/sqlite3/base.py", line 328, in execute return super().execute(query, params) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ django.db.utils.IntegrityError: NOT NULL constraint failed: wagtailcore_page.draft_title

wagtail / bakerydemo

migration failed #472

ENV

Phenomena