[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