[Django] #33827: Use of old MySQL version generate unknown default_storage_engine but no way to remove/replace parameter by storage_engine

30 views

Skip to first unread message

Django

unread,

Jul 6, 2022, 3:58:07 AM7/6/22

to django-...@googlegroups.com

#33827: Use of old MySQL version generate unknown default_storage_engine but no way
to remove/replace parameter by storage_engine
-------------------------------------+-------------------------------------
Reporter: rv2931 | Owner: nobody
Type: | Status: new
Uncategorized |
Component: | Version: 4.0
Uncategorized | Keywords: Mysql, database,
Severity: Normal | database.backends, storage_engine
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
Hi
I meet the error
{{{
(1193, "Unknown system variable 'default_storage_engine'")
}}}

because I'm using an old MySQL version that is waiting for storage_engine
and not default_storage_engine
I've tried to add storage_engine in configuration but the
default_storage_engin is still used, maybe in addition to storage_engine,
and so still generate the error

{{{
DATABASES:{
'default':{}
'mysqldb': {
'ENGINE': 'django.db.backends.mysql',
'HOST': '<url>',
'PORT': '3306',
'USER': '<user>',
'PASSWORD': '<password>',
'NAME': 'bi_entrepot',
'STORAGE_ENGINE': 'MyISAM',
'OPTIONS': {
'init_command': 'SET storage_engine=MyISAM',
}
}
}}}

I looked for solution but didn't find any way to solve my situation
because I have to use this old version of MySQL

--
Ticket URL: <https://code.djangoproject.com/ticket/33827>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

Django

unread,

Jul 6, 2022, 3:59:15 AM7/6/22

to django-...@googlegroups.com

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------