OpenStack DBaaS (Trove)

  1. Bug #1645921
  2. Activity log

Activity log for bug #1645921

Date Who What changed Old value New value Message
2016-11-30 00:37:53 Sam Morrison bug added bug
2016-11-30 00:38:53 Sam Morrison description The default mysql/my.cnf on xenial causes guest agent to not start Using trove stable/mitaka mysql-server 5.7.16-0ubuntu0.16.04.1 the config file contains only: !includedir /etc/mysql/conf.d/ !includedir /etc/mysql/mysql.conf.d/ This causes the following error: 2016-11-30 00:20:48.382 4225 CRITICAL root [-] MissingSectionHeaderError: File contains no section headers. file: <???>, line: 3 '!includedir /etc/mysql/conf.d/\n' 2016-11-30 00:20:48.382 4225 ERROR root Traceback (most recent call last): 2016-11-30 00:20:48.382 4225 ERROR root File "/usr/bin/trove-guestagent", line 10, in <module> 2016-11-30 00:20:48.382 4225 ERROR root sys.exit(main()) 2016-11-30 00:20:48.382 4225 ERROR root File "/usr/lib/python2.7/dist-packages/trove/cmd/guest.py", line 63, in main 2016-11-30 00:20:48.382 4225 ERROR root rpc_api_version=rpc_version.RPC_API_VERSION) 2016-11-30 00:20:48.382 4225 ERROR root File "/usr/lib/python2.7/dist-packages/trove/common/rpc/service.py", line 48, in __init__ 2016-11-30 00:20:48.382 4225 ERROR root self.manager_impl = profiler.trace_cls("rpc")(_manager) 2016-11-30 00:20:48.382 4225 ERROR root File "/usr/lib/python2.7/dist-packages/osprofiler/profiler.py", line 153, in decorator 2016-11-30 00:20:48.382 4225 ERROR root for attr_name, attr in inspect.getmembers(cls): 2016-11-30 00:20:48.382 4225 ERROR root File "/usr/lib/python2.7/inspect.py", line 253, in getmembers 2016-11-30 00:20:48.382 4225 ERROR root value = getattr(object, key) 2016-11-30 00:20:48.382 4225 ERROR root File "/usr/lib/python2.7/dist-packages/trove/guestagent/datastore/mysql_common/manager.py", line 77, in datastore_log_defs 2016-11-30 00:20:48.382 4225 ERROR root datastore_dir = self.mysql_app.get_data_dir() 2016-11-30 00:20:48.382 4225 ERROR root File "/usr/lib/python2.7/dist-packages/trove/guestagent/datastore/mysql_common/service.py", line 627, in get_data_dir 2016-11-30 00:20:48.382 4225 ERROR root MySQLConfParser.SERVER_CONF_SECTION).get('datadir') 2016-11-30 00:20:48.382 4225 ERROR root File "/usr/lib/python2.7/dist-packages/trove/guestagent/common/configuration.py", line 99, in get_value 2016-11-30 00:20:48.382 4225 ERROR root self._refresh_cache() 2016-11-30 00:20:48.382 4225 ERROR root File "/usr/lib/python2.7/dist-packages/trove/guestagent/common/configuration.py", line 198, in _refresh_cache 2016-11-30 00:20:48.382 4225 ERROR root self._value_cache = self.parse_configuration() 2016-11-30 00:20:48.382 4225 ERROR root File "/usr/lib/python2.7/dist-packages/trove/guestagent/common/configuration.py", line 112, in parse_configuration 2016-11-30 00:20:48.382 4225 ERROR root as_root=self._requires_root) 2016-11-30 00:20:48.382 4225 ERROR root File "/usr/lib/python2.7/dist-packages/trove/guestagent/common/operating_system.py", line 60, in read_file 2016-11-30 00:20:48.382 4225 ERROR root return _read_file_as_root(path, codec, decode=decode) 2016-11-30 00:20:48.382 4225 ERROR root File "/usr/lib/python2.7/dist-packages/trove/guestagent/common/operating_system.py", line 116, in _read_file_as_root 2016-11-30 00:20:48.382 4225 ERROR root return codec.deserialize(fp.read()) 2016-11-30 00:20:48.382 4225 ERROR root File "/usr/lib/python2.7/dist-packages/trove/common/stream_codecs.py", line 208, in deserialize 2016-11-30 00:20:48.382 4225 ERROR root parser.readfp(self._pre_parse(stream)) 2016-11-30 00:20:48.382 4225 ERROR root File "/usr/lib/python2.7/ConfigParser.py", line 324, in readfp 2016-11-30 00:20:48.382 4225 ERROR root self._read(fp, filename) 2016-11-30 00:20:48.382 4225 ERROR root File "/usr/lib/python2.7/ConfigParser.py", line 512, in _read 2016-11-30 00:20:48.382 4225 ERROR root raise MissingSectionHeaderError(fpname, lineno, line) 2016-11-30 00:20:48.382 4225 ERROR root MissingSectionHeaderError: File contains no section headers. 2016-11-30 00:20:48.382 4225 ERROR root file: <???>, line: 3 2016-11-30 00:20:48.382 4225 ERROR root '!includedir /etc/mysql/conf.d/\n' Adding a [default] at the top of the /etc/mysql/my.cnf file fixes this. The default mysql/my.cnf on xenial causes guest agent to not start Using trove stable/mitaka mysql-server 5.7.16-0ubuntu0.16.04.1 the config file contains only: ====================================== !includedir /etc/mysql/conf.d/ !includedir /etc/mysql/mysql.conf.d/ ====================================== This causes the following error: ====================================== 2016-11-30 00:20:48.382 4225 CRITICAL root [-] MissingSectionHeaderError: File contains no section headers. file: <???>, line: 3 '!includedir /etc/mysql/conf.d/\n' 2016-11-30 00:20:48.382 4225 ERROR root Traceback (most recent call last): 2016-11-30 00:20:48.382 4225 ERROR root File "/usr/bin/trove-guestagent", line 10, in <module> 2016-11-30 00:20:48.382 4225 ERROR root sys.exit(main()) 2016-11-30 00:20:48.382 4225 ERROR root File "/usr/lib/python2.7/dist-packages/trove/cmd/guest.py", line 63, in main 2016-11-30 00:20:48.382 4225 ERROR root rpc_api_version=rpc_version.RPC_API_VERSION) 2016-11-30 00:20:48.382 4225 ERROR root File "/usr/lib/python2.7/dist-packages/trove/common/rpc/service.py", line 48, in __init__ 2016-11-30 00:20:48.382 4225 ERROR root self.manager_impl = profiler.trace_cls("rpc")(_manager) 2016-11-30 00:20:48.382 4225 ERROR root File "/usr/lib/python2.7/dist-packages/osprofiler/profiler.py", line 153, in decorator 2016-11-30 00:20:48.382 4225 ERROR root for attr_name, attr in inspect.getmembers(cls): 2016-11-30 00:20:48.382 4225 ERROR root File "/usr/lib/python2.7/inspect.py", line 253, in getmembers 2016-11-30 00:20:48.382 4225 ERROR root value = getattr(object, key) 2016-11-30 00:20:48.382 4225 ERROR root File "/usr/lib/python2.7/dist-packages/trove/guestagent/datastore/mysql_common/manager.py", line 77, in datastore_log_defs 2016-11-30 00:20:48.382 4225 ERROR root datastore_dir = self.mysql_app.get_data_dir() 2016-11-30 00:20:48.382 4225 ERROR root File "/usr/lib/python2.7/dist-packages/trove/guestagent/datastore/mysql_common/service.py", line 627, in get_data_dir 2016-11-30 00:20:48.382 4225 ERROR root MySQLConfParser.SERVER_CONF_SECTION).get('datadir') 2016-11-30 00:20:48.382 4225 ERROR root File "/usr/lib/python2.7/dist-packages/trove/guestagent/common/configuration.py", line 99, in get_value 2016-11-30 00:20:48.382 4225 ERROR root self._refresh_cache() 2016-11-30 00:20:48.382 4225 ERROR root File "/usr/lib/python2.7/dist-packages/trove/guestagent/common/configuration.py", line 198, in _refresh_cache 2016-11-30 00:20:48.382 4225 ERROR root self._value_cache = self.parse_configuration() 2016-11-30 00:20:48.382 4225 ERROR root File "/usr/lib/python2.7/dist-packages/trove/guestagent/common/configuration.py", line 112, in parse_configuration 2016-11-30 00:20:48.382 4225 ERROR root as_root=self._requires_root) 2016-11-30 00:20:48.382 4225 ERROR root File "/usr/lib/python2.7/dist-packages/trove/guestagent/common/operating_system.py", line 60, in read_file 2016-11-30 00:20:48.382 4225 ERROR root return _read_file_as_root(path, codec, decode=decode) 2016-11-30 00:20:48.382 4225 ERROR root File "/usr/lib/python2.7/dist-packages/trove/guestagent/common/operating_system.py", line 116, in _read_file_as_root 2016-11-30 00:20:48.382 4225 ERROR root return codec.deserialize(fp.read()) 2016-11-30 00:20:48.382 4225 ERROR root File "/usr/lib/python2.7/dist-packages/trove/common/stream_codecs.py", line 208, in deserialize 2016-11-30 00:20:48.382 4225 ERROR root parser.readfp(self._pre_parse(stream)) 2016-11-30 00:20:48.382 4225 ERROR root File "/usr/lib/python2.7/ConfigParser.py", line 324, in readfp 2016-11-30 00:20:48.382 4225 ERROR root self._read(fp, filename) 2016-11-30 00:20:48.382 4225 ERROR root File "/usr/lib/python2.7/ConfigParser.py", line 512, in _read 2016-11-30 00:20:48.382 4225 ERROR root raise MissingSectionHeaderError(fpname, lineno, line) 2016-11-30 00:20:48.382 4225 ERROR root MissingSectionHeaderError: File contains no section headers. 2016-11-30 00:20:48.382 4225 ERROR root file: <???>, line: 3 2016-11-30 00:20:48.382 4225 ERROR root '!includedir /etc/mysql/conf.d/\n' ====================================== Adding a [default] at the top of the /etc/mysql/my.cnf file fixes this.
2017-08-15 09:51:59 Amrith Kumar trove: importance Undecided High
2017-09-24 14:10:55 Manoj Kumar trove: assignee Luke Browning (lukebrowning-y)
2017-11-17 21:09:03 Luke Browning trove: assignee Luke Browning (lukebrowning-y)
2018-01-22 15:43:05 Luke Browning trove: status New Fix Committed