[Buildbot] #3421: OperationalError "Unknown system variable 'storage_engine'" when using MySQL 5.7
Buildbot trac
trac at buildbot.net
Sat Jan 30 23:12:06 UTC 2016
#3421: OperationalError "Unknown system variable 'storage_engine'" when using
MySQL 5.7
----------------------+------------------------
Reporter: rutsky | Owner: dustin
Type: undecided | Status: assigned
Priority: major | Milestone: undecided
Version: master | Resolution:
Keywords: |
----------------------+------------------------
Comment (by dustin):
{{{
!diff
diff --git a/master/buildbot/db/enginestrategy.py
b/master/buildbot/db/enginestrategy.py
index 0bd22af..ee0cc42 100644
--- a/master/buildbot/db/enginestrategy.py
+++ b/master/buildbot/db/enginestrategy.py
@@ -129,17 +129,17 @@ class
BuildbotEngineStrategy(strategies.ThreadLocalEngineStrategy):
charset to be True and 'utf8', failing if they were set to
anything else."""
kwargs['pool_recycle'] = int(u.query.pop('max_idle', 3600))
# default to the MyISAM storage engine; InnoDB is not supported
storage_engine = u.query.pop('storage_engine', 'MyISAM')
kwargs['connect_args'] = {
- 'init_command': 'SET storage_engine=%s' % storage_engine,
+ 'init_command': 'SET default_storage_engine=%s' %
storage_engine,
}
if 'use_unicode' in u.query:
if u.query['use_unicode'] != "True":
raise TypeError("Buildbot requires use_unicode=True " +
"(and adds it automatically)")
else:
u.query['use_unicode'] = True
}}}
seems to help, but the warnings about blob columns having default values
are now errors :(
--
Ticket URL: <http://trac.buildbot.net/ticket/3421#comment:4>
Buildbot <http://buildbot.net/>
Buildbot: build/test automation
More information about the bugs
mailing list