· 9 years ago · Jan 20, 2017, 06:13 AM
1peoxy: 172.16.10.29:3128
2
3
4
5GRANT ALL PRIVILEGES ON heat.* TO 'heat'@'localhost' \
6 IDENTIFIED BY 'heat_db_secret';
7GRANT ALL PRIVILEGES ON heat.* TO 'heat'@'%' \
8 IDENTIFIED BY 'heat_db_secret';
9
10
11connection = mysql://heat:heat_db_secret@10.8.14.222/heat
12idle_timeout = 30
13use_db_reconnect = True
14pool_timeout = 10
15
16
17 mysql -uheat -pheat_db_secret -h 10.8.14.222 -D heat
18
19
20
21
22* Switch to the current security-supported stack by running:
23sudo apt-get install linux-image-generic-lts-xenial linux-generic-lts-xenial
24
25and reboot your system.
26Last login: Wed Jan 18 01:20:21 2017 from 10.2.117.250
27opnfv@pod8-jump:~$ ssh 10.1.0.500
28ssh: Could not resolve hostname 10.1.0.500: Name or service not known
29opnfv@pod8-jump:~$ ssh 10.1.0.50
30@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
31@ WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED! @
32@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
33IT IS POSSIBLE THAT SOMEONE IS DOING SOMETHING NASTY!
34Someone could be eavesdropping on you right now (man-in-the-middle attack)!
35It is also possible that a host key has just been changed.
36The fingerprint for the ECDSA key sent by the remote host is
371f:4d:26:ca:56:f3:1a:05:11:8a:36:2d:0c:c1:d4:24.
38Please contact your system administrator.
39Add correct host key in /home/opnfv/.ssh/known_hosts to get rid of this message.
40Offending ECDSA key in /home/opnfv/.ssh/known_hosts:1
41 remove with: ssh-keygen -f "/home/opnfv/.ssh/known_hosts" -R 10.1.0.50
42ECDSA host key for 10.1.0.50 has changed and you have requested strict checking.
43Host key verification failed.
44opnfv@pod8-jump:~$ ssh-keygen -f "/home/opnfv/.ssh/known_hosts" -R 10.1.0.50
45# Host 10.1.0.50 found: line 1 type ECDSA
46/home/opnfv/.ssh/known_hosts updated.
47Original contents retained as /home/opnfv/.ssh/known_hosts.old
48opnfv@pod8-jump:~$ ssh 10.1.0.50
49The authenticity of host '10.1.0.50 (10.1.0.50)' can't be established.
50ECDSA key fingerprint is 1f:4d:26:ca:56:f3:1a:05:11:8a:36:2d:0c:c1:d4:24.
51Are you sure you want to continue connecting (yes/no)? yes
52Warning: Permanently added '10.1.0.50' (ECDSA) to the list of known hosts.
53opnfv@10.1.0.50's password:
54Permission denied, please try again.
55opnfv@10.1.0.50's password:
56
57opnfv@pod8-jump:~$ ssh root@10.1.0.50
58root@10.1.0.50's password:
59Welcome to Ubuntu 16.04 LTS (GNU/Linux 4.4.0-21-generic x86_64)
60
61 * Documentation: https://help.ubuntu.com/
62root@host1:~# su -s /bin/sh -c "aodh-dbsync" aodh
632017-01-19 17:07:47.188 125514 DEBUG aodh.storage [-] looking for 'mysql' driver in 'aodh.storage' get_connection_from_config /usr/lib/python2.7/dist-packages/aodh/storage/__init__.py:68
642017-01-19 17:07:47.352 125514 DEBUG oslo_db.sqlalchemy.engines [-] MySQL server mode set to STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION _check_effective_sql_mode /usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/engines.py:261
652017-01-19 17:07:47.355 125514 INFO alembic.runtime.migration [-] Context impl MySQLImpl.
662017-01-19 17:07:47.355 125514 INFO alembic.runtime.migration [-] Will assume non-transactional DDL.
67CRITI [aodh] DBError: (pymysql.err.InternalError) (1135, u'Can\'t create a new thread (errno 11 "Resource temporarily unavailable"); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug')
68Traceback (most recent call last):
69 File "/usr/bin/aodh-dbsync", line 10, in <module>
70 sys.exit(dbsync())
71 File "/usr/lib/python2.7/dist-packages/aodh/cmd/storage.py", line 29, in dbsync
72 storage.get_connection_from_config(conf).upgrade()
73 File "/usr/lib/python2.7/dist-packages/aodh/storage/impl_sqlalchemy.py", line 106, in upgrade
74 command.stamp(cfg, "head")
75 File "/usr/lib/python2.7/dist-packages/alembic/command.py", line 356, in stamp
76 script.run_env()
77 File "/usr/lib/python2.7/dist-packages/alembic/script/base.py", line 407, in run_env
78 util.load_python_file(self.dir, 'env.py')
79 File "/usr/lib/python2.7/dist-packages/alembic/util/pyfiles.py", line 93, in load_python_file
80 module = load_module_py(module_id, path)
81 File "/usr/lib/python2.7/dist-packages/alembic/util/compat.py", line 79, in load_module_py
82 mod = imp.load_source(module_id, path, fp)
83 File "/usr/lib/python2.7/dist-packages/aodh/storage/sqlalchemy/alembic/env.py", line 92, in <module>
84 run_migrations_online()
85 File "/usr/lib/python2.7/dist-packages/aodh/storage/sqlalchemy/alembic/env.py", line 75, in run_migrations_online
86 with connectable.connect() as connection:
87 File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2018, in connect
88 return self._connection_cls(self, **kwargs)
89 File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 72, in __init__
90 if connection is not None else engine.raw_connection()
91 File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2104, in raw_connection
92 self.pool.unique_connection, _connection)
93 File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2078, in _wrap_pool_connect
94 e, dialect, self)
95 File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1401, in _handle_dbapi_exception_noconnection
96 util.raise_from_cause(newraise, exc_info)
97 File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause
98 reraise(type(exception), exception, tb=exc_tb)
99 File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2074, in _wrap_pool_connect
100 return fn()
101 File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 318, in unique_connection
102 return _ConnectionFairy._checkout(self)
103 File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 713, in _checkout
104 fairy = _ConnectionRecord.checkout(pool)
105 File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 480, in checkout
106 rec = pool._do_get()
107 File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 1060, in _do_get
108 self._dec_overflow()
109 File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__
110 compat.reraise(exc_type, exc_value, exc_tb)
111 File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 1057, in _do_get
112 return self._create_connection()
113 File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 323, in _create_connection
114 return _ConnectionRecord(self)
115 File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 449, in __init__
116 self.connection = self.__connect()
117 File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 607, in __connect
118 connection = self.__pool._invoke_creator(self)
119 File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/strategies.py", line 97, in connect
120 return dialect.connect(*cargs, **cparams)
121 File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 385, in connect
122 return self.dbapi.connect(*cargs, **cparams)
123 File "/usr/lib/python2.7/dist-packages/pymysql/__init__.py", line 88, in Connect
124 return Connection(*args, **kwargs)
125 File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 679, in __init__
126 self.connect()
127 File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 890, in connect
128 self._get_server_information()
129 File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1190, in _get_server_information
130 packet = self._read_packet()
131 File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 966, in _read_packet
132 packet.check_error()
133 File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 394, in check_error
134 err.raise_mysql_exception(self._data)
135 File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 120, in raise_mysql_exception
136 _check_mysql_exception(errinfo)
137 File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 115, in _check_mysql_exception
138 raise InternalError(errno, errorvalue)
139DBError: (pymysql.err.InternalError) (1135, u'Can\'t create a new thread (errno 11 "Resource temporarily unavailable"); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug')
140root@host1:~# /bin/sh -c "aodh-dbsync" aodh
1412017-01-19 17:08:16.883 125562 DEBUG aodh.storage [-] looking for 'mysql' driver in 'aodh.storage' get_connection_from_config /usr/lib/python2.7/dist-packages/aodh/storage/__init__.py:68
1422017-01-19 17:08:16.976 125562 DEBUG oslo_db.sqlalchemy.engines [-] MySQL server mode set to STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION _check_effective_sql_mode /usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/engines.py:261
1432017-01-19 17:08:16.979 125562 INFO alembic.runtime.migration [-] Context impl MySQLImpl.
1442017-01-19 17:08:16.980 125562 INFO alembic.runtime.migration [-] Will assume non-transactional DDL.
1452017-01-19 17:08:17.651 125562 ERROR oslo_db.sqlalchemy.exc_filters [-] DBAPIError exception wrapped from (pymysql.err.InternalError) (1050, u"Table 'alarm' already exists") [SQL: u'\nCREATE TABLE alarm (\n\talarm_id VARCHAR(128) NOT NULL, \n\tenabled BOOL, \n\tname TEXT, \n\ttype VARCHAR(50), \n\tseverity VARCHAR(50), \n\tdescription TEXT, \n\ttimestamp DECIMAL(20, 6), \n\tuser_id VARCHAR(128), \n\tproject_id VARCHAR(128), \n\tstate VARCHAR(255), \n\tstate_timestamp DECIMAL(20, 6), \n\tok_actions TEXT, \n\talarm_actions TEXT, \n\tinsufficient_data_actions TEXT, \n\trepeat_actions BOOL, \n\trule TEXT, \n\ttime_constraints TEXT, \n\tPRIMARY KEY (alarm_id), \n\tCHECK (enabled IN (0, 1)), \n\tCHECK (repeat_actions IN (0, 1))\n)\n\n']
1462017-01-19 17:08:17.651 125562 ERROR oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):
1472017-01-19 17:08:17.651 125562 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
1482017-01-19 17:08:17.651 125562 ERROR oslo_db.sqlalchemy.exc_filters context)
1492017-01-19 17:08:17.651 125562 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
1502017-01-19 17:08:17.651 125562 ERROR oslo_db.sqlalchemy.exc_filters cursor.execute(statement, parameters)
1512017-01-19 17:08:17.651 125562 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/pymysql/cursors.py", line 158, in execute
1522017-01-19 17:08:17.651 125562 ERROR oslo_db.sqlalchemy.exc_filters result = self._query(query)
1532017-01-19 17:08:17.651 125562 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/pymysql/cursors.py", line 308, in _query
1542017-01-19 17:08:17.651 125562 ERROR oslo_db.sqlalchemy.exc_filters conn.query(q)
1552017-01-19 17:08:17.651 125562 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 820, in query
1562017-01-19 17:08:17.651 125562 ERROR oslo_db.sqlalchemy.exc_filters self._affected_rows = self._read_query_result(unbuffered=unbuffered)
1572017-01-19 17:08:17.651 125562 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1002, in _read_query_result
1582017-01-19 17:08:17.651 125562 ERROR oslo_db.sqlalchemy.exc_filters result.read()
1592017-01-19 17:08:17.651 125562 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1285, in read
1602017-01-19 17:08:17.651 125562 ERROR oslo_db.sqlalchemy.exc_filters first_packet = self.connection._read_packet()
1612017-01-19 17:08:17.651 125562 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 966, in _read_packet
1622017-01-19 17:08:17.651 125562 ERROR oslo_db.sqlalchemy.exc_filters packet.check_error()
1632017-01-19 17:08:17.651 125562 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 394, in check_error
1642017-01-19 17:08:17.651 125562 ERROR oslo_db.sqlalchemy.exc_filters err.raise_mysql_exception(self._data)
1652017-01-19 17:08:17.651 125562 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 120, in raise_mysql_exception
1662017-01-19 17:08:17.651 125562 ERROR oslo_db.sqlalchemy.exc_filters _check_mysql_exception(errinfo)
1672017-01-19 17:08:17.651 125562 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 115, in _check_mysql_exception
1682017-01-19 17:08:17.651 125562 ERROR oslo_db.sqlalchemy.exc_filters raise InternalError(errno, errorvalue)
1692017-01-19 17:08:17.651 125562 ERROR oslo_db.sqlalchemy.exc_filters InternalError: (1050, u"Table 'alarm' already exists")
1702017-01-19 17:08:17.651 125562 ERROR oslo_db.sqlalchemy.exc_filters
171CRITI [aodh] DBError: (pymysql.err.InternalError) (1060, u"Duplicate column name 'severity'") [SQL: u'ALTER TABLE alarm_history ADD COLUMN severity VARCHAR(50)']
172Traceback (most recent call last):
173 File "/usr/bin/aodh-dbsync", line 10, in <module>
174 sys.exit(dbsync())
175 File "/usr/lib/python2.7/dist-packages/aodh/cmd/storage.py", line 29, in dbsync
176 storage.get_connection_from_config(conf).upgrade()
177 File "/usr/lib/python2.7/dist-packages/aodh/storage/impl_sqlalchemy.py", line 104, in upgrade
178 command.upgrade(cfg, "head")
179 File "/usr/lib/python2.7/dist-packages/alembic/command.py", line 174, in upgrade
180 script.run_env()
181 File "/usr/lib/python2.7/dist-packages/alembic/script/base.py", line 407, in run_env
182 util.load_python_file(self.dir, 'env.py')
183 File "/usr/lib/python2.7/dist-packages/alembic/util/pyfiles.py", line 93, in load_python_file
184 module = load_module_py(module_id, path)
185 File "/usr/lib/python2.7/dist-packages/alembic/util/compat.py", line 79, in load_module_py
186 mod = imp.load_source(module_id, path, fp)
187 File "/usr/lib/python2.7/dist-packages/aodh/storage/sqlalchemy/alembic/env.py", line 92, in <module>
188 run_migrations_online()
189 File "/usr/lib/python2.7/dist-packages/aodh/storage/sqlalchemy/alembic/env.py", line 82, in run_migrations_online
190 context.run_migrations()
191 File "<string>", line 8, in run_migrations
192 File "/usr/lib/python2.7/dist-packages/alembic/runtime/environment.py", line 797, in run_migrations
193 self.get_context().run_migrations(**kw)
194 File "/usr/lib/python2.7/dist-packages/alembic/runtime/migration.py", line 312, in run_migrations
195 step.migration_fn(**kw)
196 File "/usr/lib/python2.7/dist-packages/aodh/storage/sqlalchemy/alembic/versions/bb07adac380_add_severity_to_alarm_history.py", line 36, in upgrade
197 sa.Column('severity', sa.String(length=50), nullable=True))
198 File "<string>", line 8, in add_column
199 File "<string>", line 3, in add_column
200 File "/usr/lib/python2.7/dist-packages/alembic/operations/ops.py", line 1535, in add_column
201 return operations.invoke(op)
202 File "/usr/lib/python2.7/dist-packages/alembic/operations/base.py", line 318, in invoke
203 return fn(self, operation)
204 File "/usr/lib/python2.7/dist-packages/alembic/operations/toimpl.py", line 123, in add_column
205 schema=schema
206 File "/usr/lib/python2.7/dist-packages/alembic/ddl/impl.py", line 172, in add_column
207 self._exec(base.AddColumn(table_name, column, schema=schema))
208 File "/usr/lib/python2.7/dist-packages/alembic/ddl/impl.py", line 118, in _exec
209 return conn.execute(construct, *multiparams, **params)
210 File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 914, in execute
211 return meth(self, multiparams, params)
212 File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
213 return connection._execute_ddl(self, multiparams, params)
214 File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 968, in _execute_ddl
215 compiled
216 File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
217 context)
218 File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
219 util.raise_from_cause(newraise, exc_info)
220 File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause
221 reraise(type(exception), exception, tb=exc_tb)
222 File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
223 context)
224 File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
225 cursor.execute(statement, parameters)
226 File "/usr/lib/python2.7/dist-packages/pymysql/cursors.py", line 158, in execute
227 result = self._query(query)
228 File "/usr/lib/python2.7/dist-packages/pymysql/cursors.py", line 308, in _query
229 conn.query(q)
230 File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 820, in query
231 self._affected_rows = self._read_query_result(unbuffered=unbuffered)
232 File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1002, in _read_query_result
233 result.read()
234 File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1285, in read
235 first_packet = self.connection._read_packet()
236 File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 966, in _read_packet
237 packet.check_error()
238 File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 394, in check_error
239 err.raise_mysql_exception(self._data)
240 File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 120, in raise_mysql_exception
241 _check_mysql_exception(errinfo)
242 File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 115, in _check_mysql_exception
243 raise InternalError(errno, errorvalue)
244DBError: (pymysql.err.InternalError) (1060, u"Duplicate column name 'severity'") [SQL: u'ALTER TABLE alarm_history ADD COLUMN severity VARCHAR(50)']
245root@host1:~# "aodh-dbsync" aodh
246usage: aodh-dbsync [-h] [--config-dir DIR] [--config-file PATH] [--debug]
247 [--log-config-append PATH] [--log-date-format DATE_FORMAT]
248 [--log-dir LOG_DIR] [--log-file PATH] [--nodebug]
249 [--nouse-syslog] [--noverbose] [--nowatch-log-file]
250 [--syslog-log-facility SYSLOG_LOG_FACILITY] [--use-syslog]
251 [--verbose] [--watch-log-file]
252aodh-dbsync: error: unrecognized arguments: aodh
253root@host1:~# aodh-dbsync aodh
254usage: aodh-dbsync [-h] [--config-dir DIR] [--config-file PATH] [--debug]
255 [--log-config-append PATH] [--log-date-format DATE_FORMAT]
256 [--log-dir LOG_DIR] [--log-file PATH] [--nodebug]
257 [--nouse-syslog] [--noverbose] [--nowatch-log-file]
258 [--syslog-log-facility SYSLOG_LOG_FACILITY] [--use-syslog]
259 [--verbose] [--watch-log-file]
260aodh-dbsync: error: unrecognized arguments: aodh
261root@host1:~# aodh-dbsync
2622017-01-19 17:10:41.843 125778 DEBUG aodh.storage [-] looking for 'mysql' driver in 'aodh.storage' get_connection_from_config /usr/lib/python2.7/dist-packages/aodh/storage/__init__.py:68
2632017-01-19 17:10:41.941 125778 DEBUG oslo_db.sqlalchemy.engines [-] MySQL server mode set to STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION _check_effective_sql_mode /usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/engines.py:261
2642017-01-19 17:10:41.944 125778 INFO alembic.runtime.migration [-] Context impl MySQLImpl.
2652017-01-19 17:10:41.945 125778 INFO alembic.runtime.migration [-] Will assume non-transactional DDL.
266CRITI [aodh] DBError: (pymysql.err.InternalError) (1060, u"Duplicate column name 'severity'") [SQL: u'ALTER TABLE alarm_history ADD COLUMN severity VARCHAR(50)']
267Traceback (most recent call last):
268 File "/usr/bin/aodh-dbsync", line 10, in <module>
269 sys.exit(dbsync())
270 File "/usr/lib/python2.7/dist-packages/aodh/cmd/storage.py", line 29, in dbsync
271 storage.get_connection_from_config(conf).upgrade()
272 File "/usr/lib/python2.7/dist-packages/aodh/storage/impl_sqlalchemy.py", line 108, in upgrade
273 command.upgrade(cfg, "head")
274 File "/usr/lib/python2.7/dist-packages/alembic/command.py", line 174, in upgrade
275 script.run_env()
276 File "/usr/lib/python2.7/dist-packages/alembic/script/base.py", line 407, in run_env
277 util.load_python_file(self.dir, 'env.py')
278 File "/usr/lib/python2.7/dist-packages/alembic/util/pyfiles.py", line 93, in load_python_file
279 module = load_module_py(module_id, path)
280 File "/usr/lib/python2.7/dist-packages/alembic/util/compat.py", line 79, in load_module_py
281 mod = imp.load_source(module_id, path, fp)
282 File "/usr/lib/python2.7/dist-packages/aodh/storage/sqlalchemy/alembic/env.py", line 92, in <module>
283 run_migrations_online()
284 File "/usr/lib/python2.7/dist-packages/aodh/storage/sqlalchemy/alembic/env.py", line 82, in run_migrations_online
285 context.run_migrations()
286 File "<string>", line 8, in run_migrations
287 File "/usr/lib/python2.7/dist-packages/alembic/runtime/environment.py", line 797, in run_migrations
288 self.get_context().run_migrations(**kw)
289 File "/usr/lib/python2.7/dist-packages/alembic/runtime/migration.py", line 312, in run_migrations
290 step.migration_fn(**kw)
291 File "/usr/lib/python2.7/dist-packages/aodh/storage/sqlalchemy/alembic/versions/bb07adac380_add_severity_to_alarm_history.py", line 36, in upgrade
292 sa.Column('severity', sa.String(length=50), nullable=True))
293 File "<string>", line 8, in add_column
294 File "<string>", line 3, in add_column
295 File "/usr/lib/python2.7/dist-packages/alembic/operations/ops.py", line 1535, in add_column
296 return operations.invoke(op)
297 File "/usr/lib/python2.7/dist-packages/alembic/operations/base.py", line 318, in invoke
298 return fn(self, operation)
299 File "/usr/lib/python2.7/dist-packages/alembic/operations/toimpl.py", line 123, in add_column
300 schema=schema
301 File "/usr/lib/python2.7/dist-packages/alembic/ddl/impl.py", line 172, in add_column
302 self._exec(base.AddColumn(table_name, column, schema=schema))
303 File "/usr/lib/python2.7/dist-packages/alembic/ddl/impl.py", line 118, in _exec
304 return conn.execute(construct, *multiparams, **params)
305 File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 914, in execute
306 return meth(self, multiparams, params)
307 File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
308 return connection._execute_ddl(self, multiparams, params)
309 File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 968, in _execute_ddl
310 compiled
311 File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
312 context)
313 File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
314 util.raise_from_cause(newraise, exc_info)
315 File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause
316 reraise(type(exception), exception, tb=exc_tb)
317 File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
318 context)
319 File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
320 cursor.execute(statement, parameters)
321 File "/usr/lib/python2.7/dist-packages/pymysql/cursors.py", line 158, in execute
322 result = self._query(query)
323 File "/usr/lib/python2.7/dist-packages/pymysql/cursors.py", line 308, in _query
324 conn.query(q)
325 File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 820, in query
326 self._affected_rows = self._read_query_result(unbuffered=unbuffered)
327 File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1002, in _read_query_result
328 result.read()
329 File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1285, in read
330 first_packet = self.connection._read_packet()
331 File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 966, in _read_packet
332 packet.check_error()
333 File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 394, in check_error
334 err.raise_mysql_exception(self._data)
335 File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 120, in raise_mysql_exception
336 _check_mysql_exception(errinfo)
337 File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 115, in _check_mysql_exception
338 raise InternalError(errno, errorvalue)
339DBError: (pymysql.err.InternalError) (1060, u"Duplicate column name 'severity'") [SQL: u'ALTER TABLE alarm_history ADD COLUMN severity VARCHAR(50)']
340root@host1:~# aodh
341(aodh)
342(aodh) restart aodh service
343aodh: 'restart' is not an aodh command. See 'aodh --help'.
344Did you mean one of these?
345 alarm create
346 alarm delete
347 alarm list
348 alarm show
349 alarm state get
350 alarm state set
351 alarm update
352 alarm-history search
353 alarm-history show
354(aodh) exit
355root@host1:~#
356root@host1:~# su -s /bin/sh -c "aodh-dbsync" aodh
3572017-01-19 17:29:35.697 127315 DEBUG aodh.storage [-] looking for 'mysql' driver in 'aodh.storage' get_connection_from_config /usr/lib/python2.7/dist-packages/aodh/storage/__init__.py:68
3582017-01-19 17:29:35.785 127315 DEBUG oslo_db.sqlalchemy.engines [-] MySQL server mode set to STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION _check_effective_sql_mode /usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/engines.py:261
3592017-01-19 17:29:35.786 127315 INFO alembic.runtime.migration [-] Context impl MySQLImpl.
3602017-01-19 17:29:35.786 127315 INFO alembic.runtime.migration [-] Will assume non-transactional DDL.
361CRITI [aodh] DBError: (pymysql.err.InternalError) (1060, u"Duplicate column name 'severity'") [SQL: u'ALTER TABLE alarm_history ADD COLUMN severity VARCHAR(50)']
362Traceback (most recent call last):
363 File "/usr/bin/aodh-dbsync", line 10, in <module>
364 sys.exit(dbsync())
365 File "/usr/lib/python2.7/dist-packages/aodh/cmd/storage.py", line 29, in dbsync
366 storage.get_connection_from_config(conf).upgrade()
367 File "/usr/lib/python2.7/dist-packages/aodh/storage/impl_sqlalchemy.py", line 108, in upgrade
368 command.upgrade(cfg, "head")
369 File "/usr/lib/python2.7/dist-packages/alembic/command.py", line 174, in upgrade
370 script.run_env()
371 File "/usr/lib/python2.7/dist-packages/alembic/script/base.py", line 407, in run_env
372 util.load_python_file(self.dir, 'env.py')
373 File "/usr/lib/python2.7/dist-packages/alembic/util/pyfiles.py", line 93, in load_python_file
374 module = load_module_py(module_id, path)
375 File "/usr/lib/python2.7/dist-packages/alembic/util/compat.py", line 79, in load_module_py
376 mod = imp.load_source(module_id, path, fp)
377 File "/usr/lib/python2.7/dist-packages/aodh/storage/sqlalchemy/alembic/env.py", line 92, in <module>
378 run_migrations_online()
379 File "/usr/lib/python2.7/dist-packages/aodh/storage/sqlalchemy/alembic/env.py", line 82, in run_migrations_online
380 context.run_migrations()
381 File "<string>", line 8, in run_migrations
382 File "/usr/lib/python2.7/dist-packages/alembic/runtime/environment.py", line 797, in run_migrations
383 self.get_context().run_migrations(**kw)
384 File "/usr/lib/python2.7/dist-packages/alembic/runtime/migration.py", line 312, in run_migrations
385 step.migration_fn(**kw)
386 File "/usr/lib/python2.7/dist-packages/aodh/storage/sqlalchemy/alembic/versions/bb07adac380_add_severity_to_alarm_history.py", line 36, in upgrade
387 sa.Column('severity', sa.String(length=50), nullable=True))
388 File "<string>", line 8, in add_column
389 File "<string>", line 3, in add_column
390 File "/usr/lib/python2.7/dist-packages/alembic/operations/ops.py", line 1535, in add_column
391 return operations.invoke(op)
392 File "/usr/lib/python2.7/dist-packages/alembic/operations/base.py", line 318, in invoke
393 return fn(self, operation)
394 File "/usr/lib/python2.7/dist-packages/alembic/operations/toimpl.py", line 123, in add_column
395 schema=schema
396 File "/usr/lib/python2.7/dist-packages/alembic/ddl/impl.py", line 172, in add_column
397 self._exec(base.AddColumn(table_name, column, schema=schema))
398 File "/usr/lib/python2.7/dist-packages/alembic/ddl/impl.py", line 118, in _exec
399 return conn.execute(construct, *multiparams, **params)
400 File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 914, in execute
401 return meth(self, multiparams, params)
402 File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
403 return connection._execute_ddl(self, multiparams, params)
404 File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 968, in _execute_ddl
405 compiled
406 File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
407 context)
408 File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
409 util.raise_from_cause(newraise, exc_info)
410 File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause
411 reraise(type(exception), exception, tb=exc_tb)
412 File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
413 context)
414 File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
415 cursor.execute(statement, parameters)
416 File "/usr/lib/python2.7/dist-packages/pymysql/cursors.py", line 158, in execute
417 result = self._query(query)
418 File "/usr/lib/python2.7/dist-packages/pymysql/cursors.py", line 308, in _query
419 conn.query(q)
420 File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 820, in query
421 self._affected_rows = self._read_query_result(unbuffered=unbuffered)
422 File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1002, in _read_query_result
423 result.read()
424 File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1285, in read
425 first_packet = self.connection._read_packet()
426 File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 966, in _read_packet
427 packet.check_error()
428 File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 394, in check_error
429 err.raise_mysql_exception(self._data)
430 File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 120, in raise_mysql_exception
431 _check_mysql_exception(errinfo)
432 File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 115, in _check_mysql_exception
433 raise InternalError(errno, errorvalue)
434DBError: (pymysql.err.InternalError) (1060, u"Duplicate column name 'severity'") [SQL: u'ALTER TABLE alarm_history ADD COLUMN severity VARCHAR(50)']