|
|
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:. |" u1 i9 ~) q
<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"]
9 h: X' }9 a. j2 c: X6 h "is:\n %s %s\n" % (self._exc_info[0], self._exc_info[1]))8 h+ \8 l3 a* H
: InternalError: (pymysql.err.InternalError) (1047, u'WSREP has not yet prepared node for application use')* p) Y/ |" ?# j0 M# `2 }
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')
5 z: r/ ^4 U1 n& j0 A# {1 A2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool Traceback (most recent call last):
; `: Z9 o! f3 m9 K9 U$ Z. W2018-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. R+ l9 h, G! |$ X* X
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool fairy._reset(pool): b4 Q+ N; Q: I/ b9 z
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
* X& E0 U5 j. a2 F3 L2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool pool._dialect.do_rollback(self)
! [; l# i. x' ?! y2018-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- U( i7 J% ?# s" I6 T
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool dbapi_connection.rollback()
6 c. C& v; \" w7 n2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 793, in rollback3 z3 o @- u6 C- A
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool self._read_ok_packet()7 I3 q7 j1 G' {( P& z
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_packet6 [( q8 k' O [- S' e9 G' H0 u
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool pkt = self._read_packet()
6 p9 C. i4 @1 `4 R; [+ M6 u2018-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+ v' _; H, _% W6 }1 e3 r
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool packet.check_error()8 i* |3 E5 N3 m9 {. c# T+ J
2018-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
p X9 s F" a8 k2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool err.raise_mysql_exception(self._data)
$ b+ v- C; @# p9 }) j$ Y2018-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_exception9 T" l) f3 H+ j* o0 A; n F. q n- Z0 h
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool raise errorclass(errno, errval)6 T% l# `& s6 l2 `6 M
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool InternalError: (1047, u'WSREP has not yet prepared node for application use')2 x/ ^ z4 }3 K/ I2 T: L* |) V
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool
' I9 f" R. }8 i! A( v2018-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')4 V1 w: t! y# d( ]2 Z6 w
2018-08-10 20:11:08.011 22951 ERROR 067_kilo Traceback (most recent call last):
: [ u2 @: H0 w2018-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/ g7 `5 }$ w5 s- W
2018-08-10 20:11:08.011 22951 ERROR 067_kilo table.create()
9 _' U; l! i! a2018-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- M5 A- ~2 M4 n5 _* O: v
2018-08-10 20:11:08.011 22951 ERROR 067_kilo checkfirst=checkfirst)
' x+ R$ l; F. [4 H; q% y2018-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_visitor
5 J& G# ~5 @& ]: L7 ~+ G- m2018-08-10 20:11:08.011 22951 ERROR 067_kilo conn._run_visitor(visitorcallable, element, **kwargs)
8 y4 |3 ]6 k4 T" W1 f9 ^& B! ]" P2018-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% c" M7 {) q" A8 V
2018-08-10 20:11:08.011 22951 ERROR 067_kilo **kwargs).traverse_single(element)5 G7 [! h8 Q7 ]8 d0 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
7 y& B* F$ e1 A& w2018-08-10 20:11:08.011 22951 ERROR 067_kilo return meth(obj, **kw)
8 O, E( y3 o5 B/ R: m- k# |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, Z K& g- F+ s! s: L+ F
2018-08-10 20:11:08.011 22951 ERROR 067_kilo include_foreign_key_constraints=include_foreign_key_constraints4 l3 p) J7 u) L! j9 Z6 }# H/ c
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
1 `3 u4 v2 r4 P/ Y2018-08-10 20:11:08.011 22951 ERROR 067_kilo return meth(self, multiparams, params)) p* z) ?% w( ?: f# s' T, ~
2018-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_connection
5 ?/ S+ E) V _* F2018-08-10 20:11:08.011 22951 ERROR 067_kilo return connection._execute_ddl(self, multiparams, params)
9 B( D) ^7 y& w2018-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. V5 o8 Y0 s' h7 i; q
2018-08-10 20:11:08.011 22951 ERROR 067_kilo compiled, X1 w' M- m* U) k* E: M
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_context; h/ E8 g5 | v4 q
2018-08-10 20:11:08.011 22951 ERROR 067_kilo context)
" R+ {' W* P9 d) G; @: S- a2018-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
% s$ i; K& r" G: Q2018-08-10 20:11:08.011 22951 ERROR 067_kilo self._autorollback()
1 i7 J/ G. P; s* r |: N2018-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__- p1 M q: ~9 B2 w8 @
2018-08-10 20:11:08.011 22951 ERROR 067_kilo compat.reraise(type_, value, traceback)
3 t- s, x$ c( Y1 `' @* s2018-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
7 w7 l7 q. b0 t& h! T0 l* c2018-08-10 20:11:08.011 22951 ERROR 067_kilo self._autorollback()
' }7 Z6 t3 V# J" @6 K; w2018-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+ n5 f! p6 r; W, F2 |9 X. U( N1 x
2018-08-10 20:11:08.011 22951 ERROR 067_kilo self._root._rollback_impl()
# x2 ^5 b2 [& @ X4 c. O2018-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
( `3 _( @ [" X2 a- T2018-08-10 20:11:08.011 22951 ERROR 067_kilo self._handle_dbapi_exception(e, None, None, None, None)
; v; _( Y& ~3 O& \0 q; W% H D2018-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* s( C! _% j( X4 U( a9 K7 f3 P9 U# B
2018-08-10 20:11:08.011 22951 ERROR 067_kilo exc_info
6 l2 M) X) k4 @4 o2018-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- W" z% C2 s- S8 ^2 N
2018-08-10 20:11:08.011 22951 ERROR 067_kilo reraise(type(exception), exception, tb=exc_tb, cause=cause)
& e$ x u+ [ u9 i; E7 v2018-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
5 x: S ?2 z4 }$ F! d$ w3 V: }/ O, e2018-08-10 20:11:08.011 22951 ERROR 067_kilo self.engine.dialect.do_rollback(self.connection)
) n, Q+ l c7 ~/ L8 ^/ Y7 V2018-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_rollback2 f9 ?" u' {; j5 Z2 a
2018-08-10 20:11:08.011 22951 ERROR 067_kilo dbapi_connection.rollback()
$ A, S( Q& @; U* m! \3 k, K3 Q2018-08-10 20:11:08.011 22951 ERROR 067_kilo File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 793, in rollback! H: M* S# w4 o! p2 j
2018-08-10 20:11:08.011 22951 ERROR 067_kilo self._read_ok_packet(): I) L% z! k. @7 D7 F
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- O t1 U C" l) \* F
2018-08-10 20:11:08.011 22951 ERROR 067_kilo pkt = self._read_packet()
+ C7 O" A7 ~+ G7 ]# T/ ~ Z7 L4 N- r2018-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
4 L, T3 b" i5 n2018-08-10 20:11:08.011 22951 ERROR 067_kilo packet.check_error()
8 ?, P: k+ t9 _6 P( o2018-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
$ i9 f; i2 h! m, \+ U5 Y- W2018-08-10 20:11:08.011 22951 ERROR 067_kilo err.raise_mysql_exception(self._data)
# \. k9 ^% ^1 [: Q, Y2018-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* |) }/ i, L" S( F' K3 ^, Q
2018-08-10 20:11:08.011 22951 ERROR 067_kilo raise errorclass(errno, errval)) \2 h. s3 |% E! y, X
2018-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/ h: c( U& p& d$ c: n
2018-08-10 20:11:08.011 22951 ERROR 067_kilo
, A- r' Q4 s) a4 L) w2 D% ]. r2018-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')- C4 n6 g4 H- J% w7 d c
2018-08-10 20:11:08.016 22951 ERROR keystone Traceback (most recent call last):7 M0 m7 N6 x4 _6 ^/ E! z& R: J
2018-08-10 20:11:08.016 22951 ERROR keystone File "/usr/bin/keystone-manage", line 10, in <module>
: Q9 m$ w7 z, k. y- S) E6 w2018-08-10 20:11:08.016 22951 ERROR keystone sys.exit(main())
( s) P+ t) W) E5 u5 V' T2018-08-10 20:11:08.016 22951 ERROR keystone File "/usr/lib/python2.7/site-packages/keystone/cmd/manage.py", line 44, in main
* {6 Y3 V0 t1 A0 B2018-08-10 20:11:08.016 22951 ERROR keystone cli.main(argv=sys.argv, config_files=config_files)
) d$ S7 V1 E: I# Q( U; h, j2018-08-10 20:11:08.016 22951 ERROR keystone File "/usr/lib/python2.7/site-packages/keystone/cmd/cli.py", line 1331, in main! [' V! P) ^' q- o. Q, P" `, W" N0 v! W
2018-08-10 20:11:08.016 22951 ERROR keystone CONF.command.cmd_class.main(): z3 H( I3 L1 h1 V$ K
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
. m8 q( P# p- d @- x2018-08-10 20:11:08.016 22951 ERROR keystone CONF.command.version)
8 R4 Q& ^( U; }* U l1 g( r2018-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
- t/ _+ T+ t% r& i3 t! |! F7 I2018-08-10 20:11:08.016 22951 ERROR keystone expand_schema()
9 S! h( _ h2 h2018-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! A: n# v# B; @, d6 s4 W c
2018-08-10 20:11:08.016 22951 ERROR keystone _sync_common_repo(version=None)7 N9 g/ A4 U+ r. B5 [" s8 v( o/ d
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
8 {, t9 b7 ~$ i2018-08-10 20:11:08.016 22951 ERROR keystone init_version=init_version, sanity_check=False)
9 z( P* h8 n; f5 A; r0 {1 j2018-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. m+ Y" C, O1 h: T2 O% |( U
2018-08-10 20:11:08.016 22951 ERROR keystone raise exception.DbMigrationError(ex)
& k2 y$ ^" L' |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')
2 U2 x( R$ L$ h+ t' F7 `2018-08-10 20:11:08.016 22951 ERROR keystone
6 X: \+ j% d5 W4 [7 h" \" E' j |
|
发表于 2018-8-10 20:12:08