id summary reporter owner description type status component version severity resolution keywords cc stage has_patch needs_docs needs_tests needs_better_patch easy ui_ux 28804 "MariaDB compatibility broken: ""Unknown system variable 'transaction_isolation'""" Gene Sem nobody "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 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'"") }}} " Bug closed Database layer (models, ORM) 2.0 Release blocker fixed mysqldb, error, transaction_isolation, database, backend Adam Johnson Sergey Fedoseev Ready for checkin 1 0 0 0 0 0