#27180: Check for sql_mode fails during migration with special database
connections
----------------------------+--------------------
Reporter: gerricom | Owner: nobody
Type: Bug | Status: new
Component: Migrations | Version: 1.10
Severity: Normal | Keywords:
Triage Stage: Unreviewed | Has patch: 0
Easy pickings: 0 | UI/UX: 0
----------------------------+--------------------
I believe I found again a bug regarding some special database connections
(like #26991):
Running `migrate` raises this error:
{{{
Traceback (most recent call last):
File "manage.py", line 10, in <module>
execute_from_command_line(sys.argv)
File "/usr/local/lib/python2.7/site-
packages/django/core/management/__init__.py", line 367, in
execute_from_command_line
utility.execute()
File "/usr/local/lib/python2.7/site-
packages/django/core/management/__init__.py", line 359, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/usr/local/lib/python2.7/site-
packages/django/core/management/base.py", line 294, in run_from_argv
self.execute(*args, **cmd_options)
File "/usr/local/lib/python2.7/site-
packages/django/core/management/base.py", line 342, in execute
self.check()
File "/usr/local/lib/python2.7/site-
packages/django/core/management/base.py", line 374, in check
include_deployment_checks=include_deployment_checks,
File "/usr/local/lib/python2.7/site-
packages/django/core/management/commands/migrate.py", line 61, in
_run_checks
issues = run_checks(tags=[Tags.database])
File "/usr/local/lib/python2.7/site-
packages/django/core/checks/registry.py", line 81, in run_checks
new_errors = check(app_configs=app_configs)
File "/usr/local/lib/python2.7/site-
packages/django/core/checks/database.py", line 10, in
check_database_backends
issues.extend(conn.validation.check(**kwargs))
File "/usr/local/lib/python2.7/site-
packages/django/db/backends/mysql/validation.py", line 9, in check
issues.extend(self._check_sql_mode(**kwargs))
File "/usr/local/lib/python2.7/site-
packages/django/db/backends/mysql/validation.py", line 16, in
_check_sql_mode
modes = set(sql_mode[0].split(','))
TypeError: 'NoneType' object has no attribute '__getitem__'
}}}
The reason is, that `SELECT @@sql_mode` returns no results in my special
case.
Just a little side note: `migrate` runs database checks against all
database connections, no matter if a database is selected via the
`--database` parameter or if migrations are not allowed because of a
database router. I'm not quite sure if this works as intended.
--
Ticket URL: <https://code.djangoproject.com/ticket/27180>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/051.8492dc590a5f2e8fd99116168f1959b7%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
