|
|
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 j n B6 g7 e) 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"]0 J+ @, h: `- ]; B' o! t
"is:\n %s %s\n" % (self._exc_info[0], self._exc_info[1]))
$ B$ a( z, l' T. O7 I: InternalError: (pymysql.err.InternalError) (1047, u'WSREP has not yet prepared node for application use'): ?6 }% C, {$ O" f0 @7 k! X8 v
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 [6 K! N$ w* h* U2 b5 J2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool Traceback (most recent call last):8 w$ o: `- M7 A7 `/ {
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_fairy8 A$ @5 K0 P7 m6 T6 K( R
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool fairy._reset(pool)* h2 D; X0 \; X3 l' z P+ w
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
- h7 |9 W' M c% ]$ K2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool pool._dialect.do_rollback(self)
2 V& w9 ~; q- y6 f. ~! g3 p2018-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_rollback1 O, L% Q( Q+ e- y% t
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool dbapi_connection.rollback()6 Z* l% r/ W& S& `) a
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
( w& R; X4 W% |' M/ B1 S. y2 }' R1 v2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool self._read_ok_packet()' A! s, F9 I$ H8 S
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
6 X6 p$ _9 q" `/ G% l/ }. k2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool pkt = self._read_packet()
3 N1 Y5 Y) b* Q, m" \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
' B' x2 d2 B/ Y3 F2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool packet.check_error()
! C7 ^( _, A9 J5 \' K/ `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
% I7 x: ~- O" F D Y1 F( W2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool err.raise_mysql_exception(self._data)4 M: l. C8 f4 {' v" q+ A5 j; {& b" 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 T5 O. M. W3 Y* T5 A8 s7 h
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool raise errorclass(errno, errval)0 }% b m0 V' V, q8 n; u2 b
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool InternalError: (1047, u'WSREP has not yet prepared node for application use')
9 l# r, C. I% J2 @3 R2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool
3 V; f! U( k. q5 c- V; h) q2018-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')
! I, [$ S9 t6 H% n1 Z2018-08-10 20:11:08.011 22951 ERROR 067_kilo Traceback (most recent call last):9 U& B7 t3 m% u- {6 a8 Z2 }# d1 g
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
9 i9 c' N3 n6 n) Q2018-08-10 20:11:08.011 22951 ERROR 067_kilo table.create()
1 X D! r4 Y; o" ?9 T2018-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' q2 X# n" `4 G6 W1 A4 M! x
2018-08-10 20:11:08.011 22951 ERROR 067_kilo checkfirst=checkfirst)
8 m" @7 `6 Q; c* }2 C& R, |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_visitor: W7 Q2 n9 Y4 ~: z
2018-08-10 20:11:08.011 22951 ERROR 067_kilo conn._run_visitor(visitorcallable, element, **kwargs)
5 e, k# ?) s; @! Z2018-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! w1 p( f, p- j
2018-08-10 20:11:08.011 22951 ERROR 067_kilo **kwargs).traverse_single(element)
$ V! Y9 e1 ~+ ~4 O2018-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
; P5 y$ I+ x- y4 p; H- c7 Y2018-08-10 20:11:08.011 22951 ERROR 067_kilo return meth(obj, **kw)
2 e$ F7 h8 I! ]* e- P6 g4 x" {: y2018-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
9 _2 q0 I! O- X6 @- @2018-08-10 20:11:08.011 22951 ERROR 067_kilo include_foreign_key_constraints=include_foreign_key_constraints9 }; b1 {4 o+ a3 I
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
* s; U/ y5 Q! a$ t; y2018-08-10 20:11:08.011 22951 ERROR 067_kilo return meth(self, multiparams, params)
5 }5 K3 z& w- N; O$ \, |% o2018-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
) Q% b8 `( r& |: j' j0 e o2018-08-10 20:11:08.011 22951 ERROR 067_kilo return connection._execute_ddl(self, multiparams, params)
9 C z7 o3 W3 Q& Z2018-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
0 ^ n0 c! }2 I1 I, [2018-08-10 20:11:08.011 22951 ERROR 067_kilo compiled8 ^& L# Y1 Z& w4 t- h5 u' e
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+ q! {6 S. t. `( p3 e
2018-08-10 20:11:08.011 22951 ERROR 067_kilo context)
9 F, ~$ D! [/ K0 J6 f; J/ Y2018-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& W& U7 \4 I0 `8 g4 U% |* j
2018-08-10 20:11:08.011 22951 ERROR 067_kilo self._autorollback()
/ ^% N$ L: [# \" H0 q8 B( h2018-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__
1 C. I+ _1 Z0 T- ^. B2018-08-10 20:11:08.011 22951 ERROR 067_kilo compat.reraise(type_, value, traceback)
. M7 p& C, I* ~, p% G5 l+ \4 x2018-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_exception7 H' G8 k0 O+ n5 N& M
2018-08-10 20:11:08.011 22951 ERROR 067_kilo self._autorollback()* }, C8 f, K5 `$ Q0 r& j+ y V% v7 ~
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# y$ w3 f0 {# z0 c
2018-08-10 20:11:08.011 22951 ERROR 067_kilo self._root._rollback_impl()( p3 \+ ]3 J+ ~* F( 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 703, in _rollback_impl; \. R; V6 |( O; V; ]' G0 w G
2018-08-10 20:11:08.011 22951 ERROR 067_kilo self._handle_dbapi_exception(e, None, None, None, None)- v# {. c& b* I+ c. h! g& a& o* J
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
* g, x {8 l; O8 \8 h& P2018-08-10 20:11:08.011 22951 ERROR 067_kilo exc_info6 |) p: B$ }" w0 q% I& M7 [
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# \9 d4 Q5 }2 s9 }1 Y( c: F
2018-08-10 20:11:08.011 22951 ERROR 067_kilo reraise(type(exception), exception, tb=exc_tb, cause=cause)
0 u9 l0 h9 I$ x, d8 @: w* J2018-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: h0 |9 u% t( J9 ~, O ?7 j
2018-08-10 20:11:08.011 22951 ERROR 067_kilo self.engine.dialect.do_rollback(self.connection)
% `7 Y$ [6 E# d- _/ Z' y2018-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, s* b S2 c1 }
2018-08-10 20:11:08.011 22951 ERROR 067_kilo dbapi_connection.rollback()
) u- G; o- p; M8 s5 [. t2018-08-10 20:11:08.011 22951 ERROR 067_kilo File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 793, in rollback$ k$ ^- `: v- f# S. w, C
2018-08-10 20:11:08.011 22951 ERROR 067_kilo self._read_ok_packet(). o) k9 K" W6 {" c1 G* r
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
\# U; ^! r% g; \2018-08-10 20:11:08.011 22951 ERROR 067_kilo pkt = self._read_packet()
/ M+ S0 [6 F) ?6 c2018-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
3 |7 @* ~, O& b/ m2018-08-10 20:11:08.011 22951 ERROR 067_kilo packet.check_error()/ h& g$ [/ k0 k5 A
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
5 x& R5 X4 q K% Y* ]- h2018-08-10 20:11:08.011 22951 ERROR 067_kilo err.raise_mysql_exception(self._data)
# o0 q6 c: L+ h8 q F2018-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# q9 _5 z& X1 y( s4 X9 S2 t5 ]2 s
2018-08-10 20:11:08.011 22951 ERROR 067_kilo raise errorclass(errno, errval)
6 S2 E; f" v/ B4 S2018-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')4 I; _9 M [# w V2 x! Q' N. e! c
2018-08-10 20:11:08.011 22951 ERROR 067_kilo ' y) y3 u" N2 f
2018-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 K' \' V* D) a8 D S" b. U2018-08-10 20:11:08.016 22951 ERROR keystone Traceback (most recent call last):, a8 l, Z5 {2 B4 y. G# Y
2018-08-10 20:11:08.016 22951 ERROR keystone File "/usr/bin/keystone-manage", line 10, in <module>
0 T0 ~' L/ c$ a G0 \2018-08-10 20:11:08.016 22951 ERROR keystone sys.exit(main())$ W5 I% L( {4 w5 b0 z
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
2 j1 q) v- A, q$ ?( `3 o# Q2018-08-10 20:11:08.016 22951 ERROR keystone cli.main(argv=sys.argv, config_files=config_files)* r' f- u2 c& v8 u
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: V6 \4 B* l& [9 }8 n
2018-08-10 20:11:08.016 22951 ERROR keystone CONF.command.cmd_class.main()
8 b3 L7 W; B1 d% S7 e2018-08-10 20:11:08.016 22951 ERROR keystone File "/usr/lib/python2.7/site-packages/keystone/cmd/cli.py", line 530, in main
! y z8 A7 T% \2018-08-10 20:11:08.016 22951 ERROR keystone CONF.command.version)7 M' o% T* Z$ s6 z- U- K' S
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
* a5 l, T- E4 K( r; w2018-08-10 20:11:08.016 22951 ERROR keystone expand_schema()
; v# j: P: p- j5 e$ f7 r2018-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
Q7 }* V! e. A! p$ |% I. }2018-08-10 20:11:08.016 22951 ERROR keystone _sync_common_repo(version=None). g. ]3 ~) W* a4 c% E* W' K) A
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_repo5 u- a! {) a" Z5 ?; p
2018-08-10 20:11:08.016 22951 ERROR keystone init_version=init_version, sanity_check=False)( L2 f" X k9 o7 `) O1 e" q
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( [" I6 p3 m0 t
2018-08-10 20:11:08.016 22951 ERROR keystone raise exception.DbMigrationError(ex)( q4 i' u! r1 d( M( G4 Y2 l9 H
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')
- H5 W" c+ d! |5 @! Y: P. G, p2018-08-10 20:11:08.016 22951 ERROR keystone
& g6 Z$ r* d* _' h: A, h |
|
发表于 2018-8-10 20:12:08