|
|
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:7 g3 p4 S8 n! R& R
<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"]
' G5 {0 o8 |& Q; H7 e. q# P "is:\n %s %s\n" % (self._exc_info[0], self._exc_info[1]))' l* b1 r, O( V& k7 T! G
: InternalError: (pymysql.err.InternalError) (1047, u'WSREP has not yet prepared node for application use')
8 S! K( H. X" d. n0 H2018-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')
3 S; C( P7 ?/ F/ P* e2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool Traceback (most recent call last):3 r5 K: B& g( x% _/ Z( A% q9 m
2018-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+ v9 G. r( Y& t; v4 ?, J9 ]
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool fairy._reset(pool)5 D+ v% c% [. t4 z9 Y
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 _reset1 I* ^" @# B6 u+ A, V, K& c
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool pool._dialect.do_rollback(self)7 {6 A9 ~4 y V
2018-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
$ m4 F$ W0 M- p/ @3 O2 E! Q% [2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool dbapi_connection.rollback()
6 Y3 [* b4 B9 u; r8 v3 o; l% h2018-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! s9 J+ a# j w0 c# t) W8 E
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool self._read_ok_packet()
* R, R1 W/ v) D0 n% n2018-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
) e0 N/ s" I9 F; V' J9 l2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool pkt = self._read_packet()- h2 u4 Z' _8 Q8 o3 X3 b- q
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
' s/ n/ C) w" g$ D9 Y2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool packet.check_error()
8 r5 M8 ~3 T' D9 y6 }: f2 c7 Y2018-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* R5 M( O7 @0 L' z- H: `
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool err.raise_mysql_exception(self._data): M8 M" m3 f. v- r( D
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
: T. F9 L1 b% {( f2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool raise errorclass(errno, errval)
) w" a; K& `, q- T; M2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool InternalError: (1047, u'WSREP has not yet prepared node for application use')
0 M0 O5 A! {6 y# s2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool
: p- K# O3 P h5 L) \% Y5 u2 t- S( `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')# }9 I) M) v% z* o* z
2018-08-10 20:11:08.011 22951 ERROR 067_kilo Traceback (most recent call last):
0 k1 r- l2 `5 {9 L6 n" l2018-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 upgrade9 p5 d& t* a8 C
2018-08-10 20:11:08.011 22951 ERROR 067_kilo table.create()+ S+ ^+ ]3 b5 B" c/ W# j
2018-08-10 20:11:08.011 22951 ERROR 067_kilo File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/schema.py", line 756, in create1 \2 R2 d" z0 z" j: c! s$ |" a
2018-08-10 20:11:08.011 22951 ERROR 067_kilo checkfirst=checkfirst)2 d! \0 m4 r" d* R3 I
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_visitor2 u, Y) [. v6 K$ s
2018-08-10 20:11:08.011 22951 ERROR 067_kilo conn._run_visitor(visitorcallable, element, **kwargs)+ y$ k9 I. A, x2 I
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
& O* f1 d* S* n+ @: h! {: t9 M5 {2018-08-10 20:11:08.011 22951 ERROR 067_kilo **kwargs).traverse_single(element)7 }/ s, i0 @3 ^8 E2 d" w
2018-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
6 o# ?) k% D5 {" T2018-08-10 20:11:08.011 22951 ERROR 067_kilo return meth(obj, **kw)
, u! k L+ B$ D9 ~/ Q( R. U5 ^5 X0 H2018-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; \& W& W2 F* _
2018-08-10 20:11:08.011 22951 ERROR 067_kilo include_foreign_key_constraints=include_foreign_key_constraints% A6 k4 S1 b0 U- P
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 execute6 j9 u! y0 ^* w- U6 h
2018-08-10 20:11:08.011 22951 ERROR 067_kilo return meth(self, multiparams, params)
3 a) C& P$ j+ x, L7 Z2018-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_connection5 {! R& L+ Z( b
2018-08-10 20:11:08.011 22951 ERROR 067_kilo return connection._execute_ddl(self, multiparams, params)% V# ?9 `4 w7 Z0 M
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
+ O# C* _( H* r3 c( l2018-08-10 20:11:08.011 22951 ERROR 067_kilo compiled
. @3 R2 j& Z( q6 y. Q) ?2018-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_context9 w( V4 D8 O! E" R9 T
2018-08-10 20:11:08.011 22951 ERROR 067_kilo context)0 _3 \ N: \7 M+ q# R
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_exception L( ^1 Z Q# S* f
2018-08-10 20:11:08.011 22951 ERROR 067_kilo self._autorollback()$ t2 w7 w& F: q, K" p6 _8 l) ~
2018-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+ ?; i" p' }$ |2018-08-10 20:11:08.011 22951 ERROR 067_kilo compat.reraise(type_, value, traceback)
5 @6 F) L* T K2018-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
: w6 v5 G) r4 Z9 R4 J2018-08-10 20:11:08.011 22951 ERROR 067_kilo self._autorollback()
; q* U: Z; k3 Z6 s- k9 ?% o2018-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
8 c0 F# [( P# K, Y! I$ U2018-08-10 20:11:08.011 22951 ERROR 067_kilo self._root._rollback_impl()2 O0 W! d& O0 ]7 p) v6 C0 u" }
2018-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) g# y6 n T, k/ k Z+ a0 H4 e
2018-08-10 20:11:08.011 22951 ERROR 067_kilo self._handle_dbapi_exception(e, None, None, None, None)
1 {8 i# \ n; R- S2018-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
. R; ~: y. o0 h( \' j2018-08-10 20:11:08.011 22951 ERROR 067_kilo exc_info h/ _: f! w# f2 g( B$ [, _
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. S- `% v! F- ]1 e# L, w/ e1 C& s0 M
2018-08-10 20:11:08.011 22951 ERROR 067_kilo reraise(type(exception), exception, tb=exc_tb, cause=cause). T# ^5 Y8 o* o0 L, U; C) L. B$ t
2018-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_impl5 Y# K7 U2 X- ?$ h' z- W$ n
2018-08-10 20:11:08.011 22951 ERROR 067_kilo self.engine.dialect.do_rollback(self.connection)
* z) n" H0 K. K) e! |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_rollback
# K* Q- F( l6 U8 d% V, H$ |, n2 E0 S2018-08-10 20:11:08.011 22951 ERROR 067_kilo dbapi_connection.rollback()
X, a6 w6 L* L# i6 P2018-08-10 20:11:08.011 22951 ERROR 067_kilo File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 793, in rollback/ `7 b D/ i. a$ f
2018-08-10 20:11:08.011 22951 ERROR 067_kilo self._read_ok_packet()- V( A1 l; s, e4 g! y8 V! w
2018-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_packet
6 a+ f8 s# w: m- ^! Z2018-08-10 20:11:08.011 22951 ERROR 067_kilo pkt = self._read_packet()
; @ H" E: Z- i$ U, E8 ~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
1 `8 s- U/ u1 J- \4 _2018-08-10 20:11:08.011 22951 ERROR 067_kilo packet.check_error()
8 } ]4 Z( `% h( |9 y2018-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
Q/ {$ W* z4 ?2 I1 ^, a1 Z0 H. e2018-08-10 20:11:08.011 22951 ERROR 067_kilo err.raise_mysql_exception(self._data)" b. @7 s$ x0 a/ {
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_exception6 ]0 d# ~+ |% L, r. u7 S
2018-08-10 20:11:08.011 22951 ERROR 067_kilo raise errorclass(errno, errval)
m( ~; Y8 e# ]& m" Y$ ?; v2018-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')$ q$ O6 n: |: w+ C. _* G1 F
2018-08-10 20:11:08.011 22951 ERROR 067_kilo
; }$ r+ N2 ?( b2 {, E* Q1 L2018-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'): @* K. V0 _! v. \! K" G
2018-08-10 20:11:08.016 22951 ERROR keystone Traceback (most recent call last):
" J+ U+ `2 ]# p7 Z( R2018-08-10 20:11:08.016 22951 ERROR keystone File "/usr/bin/keystone-manage", line 10, in <module>
, |1 I. G' }4 I/ P) ?/ z% H A2018-08-10 20:11:08.016 22951 ERROR keystone sys.exit(main())$ z* j1 E, I, `- F7 N% t
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
1 n; q/ F p: ^1 r2018-08-10 20:11:08.016 22951 ERROR keystone cli.main(argv=sys.argv, config_files=config_files)" P8 H, B6 J) k7 I
2018-08-10 20:11:08.016 22951 ERROR keystone File "/usr/lib/python2.7/site-packages/keystone/cmd/cli.py", line 1331, in main* g5 E; S9 T, @5 \
2018-08-10 20:11:08.016 22951 ERROR keystone CONF.command.cmd_class.main()
0 E3 O; u1 X* f1 x4 Z8 Q2018-08-10 20:11:08.016 22951 ERROR keystone File "/usr/lib/python2.7/site-packages/keystone/cmd/cli.py", line 530, in main8 H; `5 b& y2 u2 O1 h
2018-08-10 20:11:08.016 22951 ERROR keystone CONF.command.version)/ x5 j4 e8 d: ^* P- O) P
2018-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_version
. o+ H4 B* b. {+ H2018-08-10 20:11:08.016 22951 ERROR keystone expand_schema()
$ `! h) U. P0 R. d! y4 s ^2018-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
" l# n4 k: _+ p; i1 \( D9 S* |2018-08-10 20:11:08.016 22951 ERROR keystone _sync_common_repo(version=None)2 C* O2 @9 [- [ v. c2 ]
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_repo
0 r* j* X) _1 f( h& k2018-08-10 20:11:08.016 22951 ERROR keystone init_version=init_version, sanity_check=False)
% I! W7 [. Q V+ Z2 r# P2018-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% }4 r; g4 w2 f9 F8 s: D+ O
2018-08-10 20:11:08.016 22951 ERROR keystone raise exception.DbMigrationError(ex)
$ _ ?; O9 }4 N) i, U2018-08-10 20:11:08.016 22951 ERROR keystone DbMigrationError: (pymysql.err.InternalError) (1047, u'WSREP has not yet prepared node for application use')( t/ Q& { F& d' I# q" r
2018-08-10 20:11:08.016 22951 ERROR keystone
7 A1 E3 I9 h S0 l: [9 w! | |
|
发表于 2018-8-10 20:12:08