同步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:
) V: Q( `" a+ r' w) z- G6 i+ X; Z <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"]
  "is:\n %s %s\n" % (self._exc_info[0], self._exc_info[1]))
# O, ?2 I2 |1 Z6 x# N" r: InternalError: (pymysql.err.InternalError) (1047, u'WSREP has not yet prepared node for application use')
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')
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool Traceback (most recent call last):
/ u, c! y$ t3 U2 L) \% A. ]" f2018-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
* d* I2 Q4 V* e) F; G1 R) W2018-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)
' i; I1 B' J$ O5 I$ F% 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
2018-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()
$ R2 ~+ n& |5 Y& u2018-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
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool     pkt = self._read_packet()
! G( E$ p3 }# ]( n4 d2018-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
2018-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
2018-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
2018-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')
& u* R2 ~2 L0 O, P: Y! K; l2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool
) O. \" [0 G9 I2018-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
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     table.create()
0 v( f: Y% r; [8 w2018-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
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     checkfirst=checkfirst)
) i% e" ~  p& E( Q% z# z2018-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
" l/ T& ]$ I- n& Y7 e# T8 S, m2018-08-10 20:11:08.011 22951 ERROR 067_kilo     conn._run_visitor(visitorcallable, element, **kwargs)
1 L; ^. b: R. z) `: j2018-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
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     **kwargs).traverse_single(element)
( p4 ]- i" D! B9 E4 O+ B1 l4 I2018-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 N# S6 e9 i3 a2018-08-10 20:11:08.011 22951 ERROR 067_kilo     return meth(obj, **kw)
& {* i8 [, M' ~) p9 S. z2018-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
8 q6 S4 Q& w" j0 O2018-08-10 20:11:08.011 22951 ERROR 067_kilo     include_foreign_key_constraints=include_foreign_key_constraints
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
: u+ Q" _4 l: l; o; \+ p  W2018-08-10 20:11:08.011 22951 ERROR 067_kilo     return meth(self, multiparams, params)
! [- y+ |" E1 i: }3 b2 v  S2018-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
) ?' o+ j7 `+ ~  ~2018-08-10 20:11:08.011 22951 ERROR 067_kilo     return connection._execute_ddl(self, multiparams, params)
: X/ ?0 c4 H0 B+ B2018-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
% y. c5 O( T4 z1 N4 S8 R# Q2018-08-10 20:11:08.011 22951 ERROR 067_kilo     compiled
. V1 L# f  V9 q2018-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)
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()
6 e5 @5 r  r7 A7 U6 y6 f2018-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__
, }9 |3 ~4 k$ D2018-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
3 {# x! w, ^6 F2 u, ^$ ~- A5 [2018-08-10 20:11:08.011 22951 ERROR 067_kilo     self._autorollback()
& b2 f9 D" z, A" E% ]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
! n) ^6 p# b- {0 y7 o2018-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
1 w* a+ {5 t* H% w2018-08-10 20:11:08.011 22951 ERROR 067_kilo     self._handle_dbapi_exception(e, None, None, None, None)
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
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     exc_info
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
; P+ k3 T$ M! e1 Q1 B! D/ E2018-08-10 20:11:08.011 22951 ERROR 067_kilo     reraise(type(exception), exception, tb=exc_tb, cause=cause)
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
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     self.engine.dialect.do_rollback(self.connection)
: h4 R+ ^5 A- u5 x+ X( [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
" u" p) t+ l) G6 I8 h$ i/ F2018-08-10 20:11:08.011 22951 ERROR 067_kilo     dbapi_connection.rollback()
% ?8 f7 i" Y" \' Z3 j2018-08-10 20:11:08.011 22951 ERROR 067_kilo   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 793, in rollback
, N6 u" g& B+ v7 K- H( k2018-08-10 20:11:08.011 22951 ERROR 067_kilo     self._read_ok_packet()
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
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     pkt = self._read_packet()
/ `3 \& ?5 M( a: ~4 Q, e2018-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
4 o* ~9 a6 |( h# \$ `3 |/ k6 ^2018-08-10 20:11:08.011 22951 ERROR 067_kilo     err.raise_mysql_exception(self._data)
& _  `" x6 l) W2018-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; h3 S$ U% R* H6 P  g: f2018-08-10 20:11:08.011 22951 ERROR 067_kilo     raise errorclass(errno, errval)
2 N+ h! l) K4 A8 t. t2018-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')
2018-08-10 20:11:08.011 22951 ERROR 067_kilo
8 k0 P8 l! d/ h3 ?- O. 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')
2018-08-10 20:11:08.016 22951 ERROR keystone Traceback (most recent call last):
- B+ k6 [3 ]% L8 {6 P4 g. P2018-08-10 20:11:08.016 22951 ERROR keystone   File "/usr/bin/keystone-manage", line 10, in <module>
7 v, L% `# k8 a8 N2018-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
" u1 l3 z1 d  [2 y' g: Z' v* I2018-08-10 20:11:08.016 22951 ERROR keystone     cli.main(argv=sys.argv, config_files=config_files)
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
2018-08-10 20:11:08.016 22951 ERROR keystone     CONF.command.cmd_class.main()
# L% y2 P7 ~0 W. I1 O7 X4 U6 D2018-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)
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
2018-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
( W! N2 J9 Z4 Y6 l, \7 c2018-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
) c0 u! `8 v+ I) Z2018-08-10 20:11:08.016 22951 ERROR keystone     raise exception.DbMigrationError(ex)
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')
2018-08-10 20:11:08.016 22951 ERROR keystone
; P7 Y+ @% Q: ], s1 O* \

admin

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

admin

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