|
|
2018-08-10 20:11:08.007 22951 WARNING py.warnings [-] /usr/lib64/python2.7/site-packages/sqlalchemy/util/langhelpers.py:74: SAWarning: An exception has occurred during handling of a previous exception. The previous exception is:
9 T! y p( x( H6 P <class 'oslo_db.exception.DBDeadlock'> (pymysql.err.InternalError) (1213, u'Deadlock found when trying to get lock; try restarting transaction') [SQL: u"\nCREATE TABLE service (\n\tid VARCHAR(64) NOT NULL, \n\ttype VARCHAR(255), \n\tenabled BOOL NOT NULL DEFAULT '1', \n\textra TEXT, \n\tPRIMARY KEY (id), \n\tCHECK (enabled IN (0, 1))\n)ENGINE=InnoDB CHARSET=utf8\n\n"]+ z, L, [9 q& e1 h& F
"is:\n %s %s\n" % (self._exc_info[0], self._exc_info[1]))7 X: O7 ^% h" q. D, P
: InternalError: (pymysql.err.InternalError) (1047, u'WSREP has not yet prepared node for application use'): K1 G, C% Z& d" R, s6 r) N
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool [-] Exception during reset or similar: InternalError: (1047, u'WSREP has not yet prepared node for application use')6 Q K/ t+ m8 \) O3 J; N
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool Traceback (most recent call last):
" }* O- ?/ n# e! n2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 687, in _finalize_fairy
6 ^0 X& W* {: D! ?8 Z5 b2 [2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool fairy._reset(pool)5 y0 z: S1 s8 q% H9 N
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 829, in _reset C; ~" o# g! Q% y r
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool pool._dialect.do_rollback(self)
. M$ s% L# W$ H& Z1 F2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool File "/usr/lib64/python2.7/site-packages/sqlalchemy/dialects/mysql/base.py", line 1598, in do_rollback
! N) O& t/ s( U+ K& u2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool dbapi_connection.rollback()* V+ |- \5 A+ @2 @
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 793, in rollback
) y) I% f( i' y: K! v2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool self._read_ok_packet()5 K/ n7 x7 l+ s7 z; v; O2 f
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 767, in _read_ok_packet+ A9 J3 A# `4 [- d0 G! S" Q
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool pkt = self._read_packet()) P5 s5 o: A4 U
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1014, in _read_packet/ W; w( A1 V- t4 [" m
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool packet.check_error()
% K" g4 V+ J3 t8 U: o7 W2 _% A2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 393, in check_error" y8 l% D5 @% G* x; d$ d$ l# {
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool err.raise_mysql_exception(self._data)6 r+ w; D, s8 g L
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception# g% K# v u l v3 a+ i6 R
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool raise errorclass(errno, errval)
$ {, e1 f# F* N2 }* E$ u, T2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool InternalError: (1047, u'WSREP has not yet prepared node for application use')
: X. {4 c/ d' Q; ]2 ?2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool & W! J1 |: r7 o
2018-08-10 20:11:08.011 22951 ERROR 067_kilo [-] Exception while creating table: Table('service', MetaData(bind=Engine(mysql+pymysql://keystone:***@controller/keystone)), Column('id', String(length=64), table=<service>, primary_key=True, nullable=False), Column('type', String(length=255), table=<service>), Column('enabled', Boolean(), table=<service>, nullable=False, default=ColumnDefault(True), server_default=DefaultClause('1', for_update=False)), Column('extra', Text(), table=<service>), schema=None): InternalError: (pymysql.err.InternalError) (1047, u'WSREP has not yet prepared node for application use')
" E/ y! S# @* u1 |2 h; O; P2018-08-10 20:11:08.011 22951 ERROR 067_kilo Traceback (most recent call last):
8 D& ]$ C9 r) I# w) ~: ~8 ]3 ^2018-08-10 20:11:08.011 22951 ERROR 067_kilo File "/usr/lib/python2.7/site-packages/keystone/common/sql/migrate_repo/versions/067_kilo.py", line 245, in upgrade& r3 S: V3 K( C3 z
2018-08-10 20:11:08.011 22951 ERROR 067_kilo table.create()
& i U% M& p' q" k4 A4 k2018-08-10 20:11:08.011 22951 ERROR 067_kilo File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/schema.py", line 756, in create
! |/ k5 L/ n0 h' X1 \2 a2018-08-10 20:11:08.011 22951 ERROR 067_kilo checkfirst=checkfirst)6 t: q/ g1 r! V/ @. ]3 K. z/ v
2018-08-10 20:11:08.011 22951 ERROR 067_kilo File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1929, in _run_visitor0 y$ f3 S+ K* @
2018-08-10 20:11:08.011 22951 ERROR 067_kilo conn._run_visitor(visitorcallable, element, **kwargs)7 [; [4 Z% n0 K- t6 D
2018-08-10 20:11:08.011 22951 ERROR 067_kilo File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1538, in _run_visitor
9 X5 H. ~; [; K7 j2 t2018-08-10 20:11:08.011 22951 ERROR 067_kilo **kwargs).traverse_single(element)
6 Q, i# W' N+ X8 b, E7 S2018-08-10 20:11:08.011 22951 ERROR 067_kilo File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single
* D; E3 r6 u# d2 p& Q7 O) Y" H2018-08-10 20:11:08.011 22951 ERROR 067_kilo return meth(obj, **kw)( d' O+ u3 P$ C' N- O9 o
2018-08-10 20:11:08.011 22951 ERROR 067_kilo File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 767, in visit_table
# q* n% W5 i" `- R+ C' D0 _. `2018-08-10 20:11:08.011 22951 ERROR 067_kilo include_foreign_key_constraints=include_foreign_key_constraints7 J' @$ X2 `/ R3 F* O
2018-08-10 20:11:08.011 22951 ERROR 067_kilo File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 945, in execute b6 f' z# T8 _4 a2 u# B- n b% |
2018-08-10 20:11:08.011 22951 ERROR 067_kilo return meth(self, multiparams, params)
+ g( N7 u( m0 c3 q$ I, d6 O9 u1 x2018-08-10 20:11:08.011 22951 ERROR 067_kilo File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection0 ?0 f7 e( P8 X6 `* X, f
2018-08-10 20:11:08.011 22951 ERROR 067_kilo return connection._execute_ddl(self, multiparams, params)" u+ ]9 |! X, A& o
2018-08-10 20:11:08.011 22951 ERROR 067_kilo File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1002, in _execute_ddl
Z$ `# w/ i" t; H( Q% c8 P2018-08-10 20:11:08.011 22951 ERROR 067_kilo compiled
' x# v% l; f/ P% V2 m2018-08-10 20:11:08.011 22951 ERROR 067_kilo File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1189, in _execute_context4 \/ p4 ?5 O1 R: E' q
2018-08-10 20:11:08.011 22951 ERROR 067_kilo context)
`/ v0 d& y* \( g2018-08-10 20:11:08.011 22951 ERROR 067_kilo File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1395, in _handle_dbapi_exception
2 @# T# k+ X7 _( \- a7 w2018-08-10 20:11:08.011 22951 ERROR 067_kilo self._autorollback()
8 B* Y; _% o/ A7 q! Q2018-08-10 20:11:08.011 22951 ERROR 067_kilo File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 76, in __exit__; f, O$ W6 ], O& J. h8 Z+ r! g
2018-08-10 20:11:08.011 22951 ERROR 067_kilo compat.reraise(type_, value, traceback)2 \, y4 N( H+ |# v8 @: F t' Q
2018-08-10 20:11:08.011 22951 ERROR 067_kilo File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1395, in _handle_dbapi_exception8 [9 v9 Y2 U+ J9 s1 S2 U
2018-08-10 20:11:08.011 22951 ERROR 067_kilo self._autorollback()
* L! I! }6 u7 O! c8 d1 g. {2018-08-10 20:11:08.011 22951 ERROR 067_kilo File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 824, in _autorollback: p0 T9 Q. }" k
2018-08-10 20:11:08.011 22951 ERROR 067_kilo self._root._rollback_impl()
5 a2 G, l' V4 {3 Q, t2018-08-10 20:11:08.011 22951 ERROR 067_kilo File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 703, in _rollback_impl
* P2 m0 a* y! T; a7 f0 P2018-08-10 20:11:08.011 22951 ERROR 067_kilo self._handle_dbapi_exception(e, None, None, None, None)
2 v5 ~, B, x4 z5 X+ @2018-08-10 20:11:08.011 22951 ERROR 067_kilo File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1323, in _handle_dbapi_exception
& e2 T7 H8 U5 J2018-08-10 20:11:08.011 22951 ERROR 067_kilo exc_info0 C0 I/ d% A. s4 |+ H
2018-08-10 20:11:08.011 22951 ERROR 067_kilo File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause. }. |- b0 u# A4 h
2018-08-10 20:11:08.011 22951 ERROR 067_kilo reraise(type(exception), exception, tb=exc_tb, cause=cause)
( Q, k3 v. ~7 s- ]3 b2018-08-10 20:11:08.011 22951 ERROR 067_kilo File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 701, in _rollback_impl
, z3 h# p; h9 B) z4 V' O# Z5 s2018-08-10 20:11:08.011 22951 ERROR 067_kilo self.engine.dialect.do_rollback(self.connection)
: c4 _* Q6 _0 o/ V8 ~: @( l' v9 }2018-08-10 20:11:08.011 22951 ERROR 067_kilo File "/usr/lib64/python2.7/site-packages/sqlalchemy/dialects/mysql/base.py", line 1598, in do_rollback1 O( H+ ?* L7 E I' \
2018-08-10 20:11:08.011 22951 ERROR 067_kilo dbapi_connection.rollback()
1 g# n% J/ N" Y3 A2018-08-10 20:11:08.011 22951 ERROR 067_kilo File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 793, in rollback9 F5 G) w8 y- u C/ \7 o; l: q
2018-08-10 20:11:08.011 22951 ERROR 067_kilo self._read_ok_packet()
! o! ^) D& V5 @# Y# W3 f7 s2 Y2018-08-10 20:11:08.011 22951 ERROR 067_kilo File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 767, in _read_ok_packet5 h4 x; S1 U7 @% H: {& d
2018-08-10 20:11:08.011 22951 ERROR 067_kilo pkt = self._read_packet()! R, Z6 j. d ], \5 C1 \
2018-08-10 20:11:08.011 22951 ERROR 067_kilo File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1014, in _read_packet$ X+ `+ y) l" F
2018-08-10 20:11:08.011 22951 ERROR 067_kilo packet.check_error()
- P5 @+ J; C. p) [8 S) ~2018-08-10 20:11:08.011 22951 ERROR 067_kilo File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 393, in check_error: F% x/ G' n6 \5 f" i0 S
2018-08-10 20:11:08.011 22951 ERROR 067_kilo err.raise_mysql_exception(self._data)7 a* m0 T8 \: ?6 O
2018-08-10 20:11:08.011 22951 ERROR 067_kilo File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
4 c; y" s% s- f+ a% c( d3 U2018-08-10 20:11:08.011 22951 ERROR 067_kilo raise errorclass(errno, errval)
' N. F: ]- F5 U: X' v* q2018-08-10 20:11:08.011 22951 ERROR 067_kilo InternalError: (pymysql.err.InternalError) (1047, u'WSREP has not yet prepared node for application use')
1 H1 r+ E3 G1 o! d6 y: P' Y2018-08-10 20:11:08.011 22951 ERROR 067_kilo
& Z7 r. Z0 I: M$ m2018-08-10 20:11:08.016 22951 CRITICAL keystone [-] Unhandled error: DbMigrationError: (pymysql.err.InternalError) (1047, u'WSREP has not yet prepared node for application use')9 Q/ g9 v5 E6 a
2018-08-10 20:11:08.016 22951 ERROR keystone Traceback (most recent call last):
. N6 U$ v' Z6 D+ U& M5 d2018-08-10 20:11:08.016 22951 ERROR keystone File "/usr/bin/keystone-manage", line 10, in <module>5 w) [6 @5 Y0 y; i0 s3 L$ ?) m, k
2018-08-10 20:11:08.016 22951 ERROR keystone sys.exit(main())$ z5 s- ^8 J" x) u5 U [6 K* Q
2018-08-10 20:11:08.016 22951 ERROR keystone File "/usr/lib/python2.7/site-packages/keystone/cmd/manage.py", line 44, in main
) L; R s5 p+ B5 b- B2018-08-10 20:11:08.016 22951 ERROR keystone cli.main(argv=sys.argv, config_files=config_files)
/ c/ _0 ?- C$ M) L2018-08-10 20:11:08.016 22951 ERROR keystone File "/usr/lib/python2.7/site-packages/keystone/cmd/cli.py", line 1331, in main4 I0 d0 U/ C$ G4 x2 v
2018-08-10 20:11:08.016 22951 ERROR keystone CONF.command.cmd_class.main()
2 M& P+ n, s! A# I) C, [2018-08-10 20:11:08.016 22951 ERROR keystone File "/usr/lib/python2.7/site-packages/keystone/cmd/cli.py", line 530, in main
' W; C9 X" w/ X( a1 b2018-08-10 20:11:08.016 22951 ERROR keystone CONF.command.version)
( m% q! h" m/ R! o& u* k2018-08-10 20:11:08.016 22951 ERROR keystone File "/usr/lib/python2.7/site-packages/keystone/common/sql/upgrades.py", line 250, in offline_sync_database_to_version4 @) b# v. k1 B+ I, Q6 t
2018-08-10 20:11:08.016 22951 ERROR keystone expand_schema()
4 u; e% Y: a. {& M2018-08-10 20:11:08.016 22951 ERROR keystone File "/usr/lib/python2.7/site-packages/keystone/common/sql/upgrades.py", line 321, in expand_schema) X5 w9 ]' N( Y; q) e
2018-08-10 20:11:08.016 22951 ERROR keystone _sync_common_repo(version=None). j- _: H/ q8 ` y$ U( o5 Z/ t
2018-08-10 20:11:08.016 22951 ERROR keystone File "/usr/lib/python2.7/site-packages/keystone/common/sql/upgrades.py", line 170, in _sync_common_repo8 g% l7 K4 }1 u; _
2018-08-10 20:11:08.016 22951 ERROR keystone init_version=init_version, sanity_check=False)
- d+ D3 ~7 W! e) G/ i8 `2018-08-10 20:11:08.016 22951 ERROR keystone File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/migration.py", line 81, in db_sync
+ X- l+ r3 y% ?9 j- X$ U: ?$ t2018-08-10 20:11:08.016 22951 ERROR keystone raise exception.DbMigrationError(ex)- I) n% `4 T; c5 z: g1 \5 N
2018-08-10 20:11:08.016 22951 ERROR keystone DbMigrationError: (pymysql.err.InternalError) (1047, u'WSREP has not yet prepared node for application use')( u+ S+ [9 `, L O5 _# m" b8 o# w
2018-08-10 20:11:08.016 22951 ERROR keystone ( g5 o& e) w D& \# |
|
|
发表于 2018-8-10 20:12:08