同步keystone数据库的时候，出现的error

admin

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 ^- z; w5 s. d4 j4 W/ U( S0 C <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"]
2 r7 a, B$ d% Q+ w3 R$ ~# D5 N! X& `  "is:\n %s %s\n" % (self._exc_info[0], self._exc_info[1]))
: InternalError: (pymysql.err.InternalError) (1047, u'WSREP has not yet prepared node for application use')
+ |( Z0 i8 W7 K% Q( y2018-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')
4 m$ s! E( U$ E; N& p4 y6 I4 C8 c2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool Traceback (most recent call last):
8 t' H( ~1 P: Q2018-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
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool     fairy._reset(pool)
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
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool     pool._dialect.do_rollback(self)
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
. X+ W: e4 |5 D! l2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool     dbapi_connection.rollback()
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
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool     self._read_ok_packet()
' \) r5 P* L% |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
$ l7 `- i: h6 @# c4 }: c2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool     pkt = self._read_packet()
- w2 Z; Q. z, c+ f2018-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
* ]: T  n7 V! \, ~5 s2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool     packet.check_error()
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
3 _5 U/ C2 W! T' u$ I2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool     err.raise_mysql_exception(self._data)
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
- o7 |/ n, p2 e% Y1 x  `. e! v2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool     raise errorclass(errno, errval)
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool InternalError: (1047, u'WSREP has not yet prepared node for application use')
+ d( M1 A/ q) E. t7 w: K+ N2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool
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')
2018-08-10 20:11:08.011 22951 ERROR 067_kilo Traceback (most recent call last):
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
0 b" G# O6 }2 U' f2018-08-10 20:11:08.011 22951 ERROR 067_kilo     table.create()
8 V! p, M& ?' P$ D% L3 b9 g/ d2018-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
$ y9 _0 y) s" v2018-08-10 20:11:08.011 22951 ERROR 067_kilo     checkfirst=checkfirst)
/ V. q$ G* C5 i2 B. ?4 n2 C2018-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
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     conn._run_visitor(visitorcallable, element, **kwargs)
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
4 ~- ^8 Y5 |1 ?  ^2018-08-10 20:11:08.011 22951 ERROR 067_kilo     **kwargs).traverse_single(element)
# I$ M8 j. v7 p3 X" f% I/ \" j3 }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
0 q) {8 N. A2 @7 k1 M' w3 ~2018-08-10 20:11:08.011 22951 ERROR 067_kilo     return meth(obj, **kw)
! [& j1 E$ G2 ]9 |  k; e1 r. {% I2018-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
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     include_foreign_key_constraints=include_foreign_key_constraints
; I5 c. n& s" B- C2 f2018-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
! ?7 v1 f- f9 O; `2018-08-10 20:11:08.011 22951 ERROR 067_kilo     return meth(self, multiparams, params)
9 `! T! {; m  y7 U2 h  a/ g! K6 I! n' Y2018-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
. _2 ?7 R! N$ b: x, b+ {, z: l( G2018-08-10 20:11:08.011 22951 ERROR 067_kilo     return connection._execute_ddl(self, multiparams, params)
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
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     compiled
+ l0 a1 F, b+ o9 _& n/ 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_context
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     context)
# y& ^8 u" p& R1 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
9 J' I% |& \0 W$ w2018-08-10 20:11:08.011 22951 ERROR 067_kilo     self._autorollback()
2 }, `: U- N; B+ E/ h! f+ Z2018-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__
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     compat.reraise(type_, value, traceback)
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
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     self._autorollback()
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
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     self._root._rollback_impl()
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
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     self._handle_dbapi_exception(e, None, None, None, None)
2 f) }+ K' p3 F6 Z: t7 h0 r2018-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
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     exc_info
  M$ H+ F( P: _  s4 x2018-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
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     reraise(type(exception), exception, tb=exc_tb, cause=cause)
2 ]( |' m" N* ^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_impl
8 f6 n) `! \1 @1 V+ _# ^2018-08-10 20:11:08.011 22951 ERROR 067_kilo     self.engine.dialect.do_rollback(self.connection)
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
! x# t4 @4 I4 t: G5 z6 w2018-08-10 20:11:08.011 22951 ERROR 067_kilo     dbapi_connection.rollback()
# m: W* o, n3 ~% k2018-08-10 20:11:08.011 22951 ERROR 067_kilo   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 793, in rollback
/ B' c" P8 n) o' c$ z( d4 Y2018-08-10 20:11:08.011 22951 ERROR 067_kilo     self._read_ok_packet()
* O. y' F& r4 d  X$ i# G! A* g! Z: b2018-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
1 J$ w# K# G, M2018-08-10 20:11:08.011 22951 ERROR 067_kilo     pkt = self._read_packet()
) j7 X3 P) n8 u, h, b9 v  ?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
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     packet.check_error()
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
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     err.raise_mysql_exception(self._data)
$ U9 G# A# s+ C" T- N* J* Q1 K2018-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
, u" A/ J) p: I- U- a# O" K$ N$ m2018-08-10 20:11:08.011 22951 ERROR 067_kilo     raise errorclass(errno, errval)
( N" t. D+ {7 H1 k; f0 N: x2018-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')
8 s: Q- Z% f) o; }5 w$ C2018-08-10 20:11:08.011 22951 ERROR 067_kilo
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')
  Y! B# d8 S; h/ E  T3 m) J2018-08-10 20:11:08.016 22951 ERROR keystone Traceback (most recent call last):
% Q# P# c* X- i$ b. m1 Y6 g1 o+ \2018-08-10 20:11:08.016 22951 ERROR keystone   File "/usr/bin/keystone-manage", line 10, in <module>
2018-08-10 20:11:08.016 22951 ERROR keystone     sys.exit(main())
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
2018-08-10 20:11:08.016 22951 ERROR keystone     cli.main(argv=sys.argv, config_files=config_files)
* y& j9 j, v6 j2 q+ b; C+ G( x# N2018-08-10 20:11:08.016 22951 ERROR keystone   File "/usr/lib/python2.7/site-packages/keystone/cmd/cli.py", line 1331, in main
2018-08-10 20:11:08.016 22951 ERROR keystone     CONF.command.cmd_class.main()
$ x5 G: A5 I8 Q% `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
2018-08-10 20:11:08.016 22951 ERROR keystone     CONF.command.version)
0 U$ U& w  Q0 A/ g# v3 M2018-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
! B+ x7 G/ p0 e& Z9 |& |, i; L2018-08-10 20:11:08.016 22951 ERROR keystone     expand_schema()
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
2018-08-10 20:11:08.016 22951 ERROR keystone     _sync_common_repo(version=None)
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 a- g+ v4 y1 }  n3 S3 E4 O2 P2018-08-10 20:11:08.016 22951 ERROR keystone     init_version=init_version, sanity_check=False)
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
2018-08-10 20:11:08.016 22951 ERROR keystone     raise exception.DbMigrationError(ex)
: u  u% }! _6 b; Z1 |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')
$ H. ]8 T$ N! P: m! S2018-08-10 20:11:08.016 22951 ERROR keystone

admin

数据库出现脑裂导致的问题，需要好好看看什么原因

admin

莫名其妙的出现数据库脑裂，好奇怪哦，需要好好看看配置文件了，有地方配置有问题。