#28804: mysql backend error: 1193, "Unknown system variable
'transaction_isolation'"
-------------------------------------+-------------------------------------
Reporter: Gene Sem | Owner: nobody
Type: | Status: new
Uncategorized |
Component: Database | Version: 2.0
layer (models, ORM) | Keywords: mysqldb, error,
Severity: Release | transaction_isolation, database,
blocker | backend
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
got this error: _mysql_exceptions.OperationalError
(1193, "Unknown system variable 'transaction_isolation'")
OS: Windows, mysql 10.1.28 MariaDB,
The codebase is fully tested and working fine under django 1.11
Python 3.6.3 installed in C:\Py3\
Full listing of error:
{{{
Traceback (most recent call last):
File "C:\Py3\lib\site-packages\django\db\backends\utils.py", line 83, in
_execute
return self.cursor.execute(sql)
File "C:\Py3\lib\site-packages\django\db\backends\mysql\base.py", line
71, in execute
return self.cursor.execute(query, args)
File "C:\Py3\lib\site-packages\MySQLdb\cursors.py", line 250, in execute
self.errorhandler(self, exc, value)
File "C:\Py3\lib\site-packages\MySQLdb\connections.py", line 50, in
defaulterrorhandler
raise errorvalue
File "C:\Py3\lib\site-packages\MySQLdb\cursors.py", line 247, in execute
res = self._query(query)
File "C:\Py3\lib\site-packages\MySQLdb\cursors.py", line 411, in _query
rowcount = self._do_query(q)
File "C:\Py3\lib\site-packages\MySQLdb\cursors.py", line 374, in
_do_query
db.query(q)
File "C:\Py3\lib\site-packages\MySQLdb\connections.py", line 277, in
query
_mysql.connection.query(self, query)
_mysql_exceptions.OperationalError: (1193, "Unknown system variable
'transaction_isolation'")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "core.py", line 9, in <module>
execute_from_command_line(sys.argv)
File "C:\Py3\lib\site-packages\django\core\management\__init__.py", line
371, in execute_from_command_line
utility.execute()
File "C:\Py3\lib\site-packages\django\core\management\__init__.py", line
365, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "C:\Py3\lib\site-packages\django\core\management\base.py", line
288, in run_from_argv
self.execute(*args, **cmd_options)
File "C:\Py3\lib\site-packages\django\core\management\base.py", line
332, in execute
self.check()
File "C:\Py3\lib\site-packages\django\core\management\base.py", line
364, in check
include_deployment_checks=include_deployment_checks,
File "C:\Py3\lib\site-packages\django\core\management\base.py", line
351, in _run_checks
return checks.run_checks(**kwargs)
File "C:\Py3\lib\site-packages\django\core\checks\registry.py", line 73,
in run_checks
new_errors = check(app_configs=app_configs)
File "C:\Py3\lib\site-packages\django\core\checks\model_checks.py", line
27, in check_all_models
errors.extend(model.check(**kwargs))
File "C:\Py3\lib\site-packages\django\db\models\base.py", line 1200, in
check
errors.extend(cls._check_fields(**kwargs))
File "C:\Py3\lib\site-packages\django\db\models\base.py", line 1272, in
_check_fields
errors.extend(field.check(**kwargs))
File "C:\Py3\lib\site-packages\django\db\models\fields\__init__.py",
line 894, in check
errors = super().check(**kwargs)
File "C:\Py3\lib\site-packages\django\db\models\fields\__init__.py",
line 206, in check
errors.extend(self._check_backend_specific_checks(**kwargs))
File "C:\Py3\lib\site-packages\django\db\models\fields\__init__.py",
line 303, in _check_backend_specific_checks
return connections[db].validation.check_field(self, **kwargs)
File "C:\Py3\lib\site-packages\django\db\backends\base\validation.py",
line 21, in check_field
field_type = field.db_type(self.connection)
File "C:\Py3\lib\site-packages\django\db\models\fields\__init__.py",
line 648, in db_type
return connection.data_types[self.get_internal_type()] % data
File "C:\Py3\lib\site-packages\django\utils\functional.py", line 36, in
__get__
res = instance.__dict__[self.name] = self.func(instance)
File "C:\Py3\lib\site-packages\django\db\backends\mysql\base.py", line
133, in data_types
if self.features.supports_microsecond_precision:
File "C:\Py3\lib\site-packages\django\utils\functional.py", line 36, in
__get__
res = instance.__dict__[self.name] = self.func(instance)
File "C:\Py3\lib\site-packages\django\db\backends\mysql\features.py",
line 65, in supports_microsecond_precision
return self.connection.mysql_version >= (5, 6, 4)
File "C:\Py3\lib\site-packages\django\utils\functional.py", line 36, in
__get__
res = instance.__dict__[self.name] = self.func(instance)
File "C:\Py3\lib\site-packages\django\db\backends\mysql\base.py", line
352, in mysql_version
with self.temporary_connection() as cursor:
File "C:\Py3\lib\contextlib.py", line 81, in __enter__
return next(self.gen)
File "C:\Py3\lib\site-packages\django\db\backends\base\base.py", line
576, in temporary_connection
cursor = self.cursor()
File "C:\Py3\lib\site-packages\django\db\backends\base\base.py", line
255, in cursor
return self._cursor()
File "C:\Py3\lib\site-packages\django\db\backends\base\base.py", line
232, in _cursor
self.ensure_connection()
File "C:\Py3\lib\site-packages\django\db\backends\base\base.py", line
216, in ensure_connection
self.connect()
File "C:\Py3\lib\site-packages\django\db\backends\base\base.py", line
196, in connect
self.init_connection_state()
File "C:\Py3\lib\site-packages\django\db\backends\mysql\base.py", line
259, in init_connection_state
cursor.execute('SET ' + ', '.join(assignments))
File "C:\Py3\lib\site-packages\django\db\backends\utils.py", line 100,
in execute
return super().execute(sql, params)
File "C:\Py3\lib\site-packages\django\db\backends\utils.py", line 68, in
execute
return self._execute_with_wrappers(sql, params, many=False,
executor=self._execute)
File "C:\Py3\lib\site-packages\django\db\backends\utils.py", line 77, in
_execute_with_wrappers
return executor(sql, params, many, context)
File "C:\Py3\lib\site-packages\django\db\backends\utils.py", line 85, in
_execute
return self.cursor.execute(sql, params)
File "C:\Py3\lib\site-packages\django\db\utils.py", line 89, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "C:\Py3\lib\site-packages\django\db\backends\utils.py", line 83, in
_execute
return self.cursor.execute(sql)
File "C:\Py3\lib\site-packages\django\db\backends\mysql\base.py", line
71, in execute
return self.cursor.execute(query, args)
File "C:\Py3\lib\site-packages\MySQLdb\cursors.py", line 250, in execute
self.errorhandler(self, exc, value)
File "C:\Py3\lib\site-packages\MySQLdb\connections.py", line 50, in
defaulterrorhandler
raise errorvalue
File "C:\Py3\lib\site-packages\MySQLdb\cursors.py", line 247, in execute
res = self._query(query)
File "C:\Py3\lib\site-packages\MySQLdb\cursors.py", line 411, in _query
rowcount = self._do_query(q)
File "C:\Py3\lib\site-packages\MySQLdb\cursors.py", line 374, in
_do_query
db.query(q)
File "C:\Py3\lib\site-packages\MySQLdb\connections.py", line 277, in
query
_mysql.connection.query(self, query)
django.db.utils.OperationalError: (1193, "Unknown system variable
'transaction_isolation'")
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/28804>
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 [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/050.bf2a8e3ddfb02fb79ca715ece409b0e0%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
