找回密码
 注册
查看: 5705|回复: 2

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

[复制链接]

1

主题

0

回帖

12

积分

管理员

积分
12
QQ
发表于 2018-8-10 20:12:08 | 显示全部楼层 |阅读模式
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:! a# l) W8 J% d
<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"]8 y1 D! p* U( j0 F2 b" p
  "is:\n %s %s\n" % (self._exc_info[0], self._exc_info[1]))* ^+ i" g$ n* S7 F/ W) c5 h6 e  E
: InternalError: (pymysql.err.InternalError) (1047, u'WSREP has not yet prepared node for application use')
  G, J8 W7 L$ n8 X6 B+ z7 c* @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')
! h" x0 i7 a: j: Z# @* g1 e2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool Traceback (most recent call last):' }0 J; d% \, p) A0 h' R- w
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
9 o- H4 r# ^6 R6 w" T2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool     fairy._reset(pool)
1 E& ]/ n2 U3 M; V2018-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
, o- Y( T7 ]! o3 t2 e0 L* P# V2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool     pool._dialect.do_rollback(self)3 X2 L$ {* g5 j2 v* s
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( D( k0 ^% U, @8 I1 A
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool     dbapi_connection.rollback()
3 _$ M+ ?% b7 C+ [6 b2018-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; O. C4 B' |. Q" @: {1 R2 n8 z2 d
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool     self._read_ok_packet()# W0 I0 S' p' c3 ?: G
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_packet2 l* c$ Y7 n* \) E% Q8 D7 B- i: g
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool     pkt = self._read_packet()
% E+ \8 a( _) I3 x3 B. p- 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
. G7 U6 F/ f* t; q: f" q' Q2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool     packet.check_error()- w* f5 w) _* F2 {
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
. w0 T6 h) B, R4 X/ m' Y& A! q7 M2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool     err.raise_mysql_exception(self._data)- Z2 |$ O& k; z, H) `% N
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
1 U6 ?3 P5 ^2 H. y2 ]2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool     raise errorclass(errno, errval)9 K- f# w  {' r0 f: Y
2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool InternalError: (1047, u'WSREP has not yet prepared node for application use')
: E. J4 u/ K8 \+ q6 I2018-08-10 20:11:08.008 22951 ERROR sqlalchemy.pool.QueuePool
( H& {6 d/ o, \+ o/ x* Q$ o" |9 k2018-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')* Y; l  q/ K- D5 j3 g( Y
2018-08-10 20:11:08.011 22951 ERROR 067_kilo Traceback (most recent call last):
# c* C1 Z  q* q4 @  h) R2018-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- ]: Y$ J! c9 c% l! e
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     table.create()
5 `, x- T$ ~( w' e) Q6 |2 ]( w3 c7 M2018-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
3 l+ }/ x5 y9 Q1 G; O4 m0 q2018-08-10 20:11:08.011 22951 ERROR 067_kilo     checkfirst=checkfirst)
  q$ u$ P) F- J4 s8 H; A. X" g' c4 ]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
# i( G& D$ Q- m4 q1 f2018-08-10 20:11:08.011 22951 ERROR 067_kilo     conn._run_visitor(visitorcallable, element, **kwargs)0 E+ b. U( K. L  y  J8 H* [9 `% s1 w/ Y
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
5 S5 f4 D( o' D+ [( g2018-08-10 20:11:08.011 22951 ERROR 067_kilo     **kwargs).traverse_single(element)3 X' c6 U* r( L  J7 N
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
" Z  y6 m# @/ F, ?/ |$ N& _. s2018-08-10 20:11:08.011 22951 ERROR 067_kilo     return meth(obj, **kw)" Z% L! @: N- X8 g! V# v5 B
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_table1 G' d, g! J2 ?. w( ~3 {1 e
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     include_foreign_key_constraints=include_foreign_key_constraints4 m4 I; m  V& ?; [, q' i; S
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 execute3 T! }2 C8 _( W  n2 U* g
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     return meth(self, multiparams, params)
$ r( f7 ?  e- ^( z! T$ c/ B2018-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
- M8 Y: {: F7 C1 O  ?1 Z- ?% y, m2018-08-10 20:11:08.011 22951 ERROR 067_kilo     return connection._execute_ddl(self, multiparams, params): M# C5 T& O3 @2 a. k
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
( ]6 z8 |7 O+ L2 [. o0 o2018-08-10 20:11:08.011 22951 ERROR 067_kilo     compiled
1 A( |1 z' U! w; @! ]9 _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
; Y4 {6 t5 L# N, {# s- e2018-08-10 20:11:08.011 22951 ERROR 067_kilo     context)
. f) G9 ~# O. k: f4 J2018-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; P9 L* G' e1 F
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     self._autorollback(): i1 ^6 A# C- w" Q/ g& f3 k/ p
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__
  y& h0 [% |2 ?  \2018-08-10 20:11:08.011 22951 ERROR 067_kilo     compat.reraise(type_, value, traceback): D" J8 z* b. G9 S: d
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
/ `/ u1 [$ ~" w6 A. p2 x2018-08-10 20:11:08.011 22951 ERROR 067_kilo     self._autorollback()! s4 u0 e& f, }$ w$ r8 K' r
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) z/ B" x0 t' j1 P7 c
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     self._root._rollback_impl()
- G" w1 M+ e, c6 ~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
+ h5 u# x/ j5 f6 Q  B' L) g9 W2018-08-10 20:11:08.011 22951 ERROR 067_kilo     self._handle_dbapi_exception(e, None, None, None, None)
& X$ ?, U1 A" I& V2 ]  k2018-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
) A& B/ o" |3 b+ c  w8 }% t2018-08-10 20:11:08.011 22951 ERROR 067_kilo     exc_info
9 ~$ o3 A2 ~/ q5 O4 }8 K2018-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$ \* v9 h6 s9 c5 W8 V7 ~3 T2 i
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     reraise(type(exception), exception, tb=exc_tb, cause=cause)
- X, N, C+ X' l; R4 C2018-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_impl6 Y( e, v, u1 ?' ~
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     self.engine.dialect.do_rollback(self.connection)% u" q  q0 ^5 J7 p2 o: t  y# V% P$ E, c
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
9 X1 d+ w/ P& a4 w) _! k5 S2018-08-10 20:11:08.011 22951 ERROR 067_kilo     dbapi_connection.rollback(): v; d# q4 X$ m5 e. a! x$ t
2018-08-10 20:11:08.011 22951 ERROR 067_kilo   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 793, in rollback
, P2 _- A+ V8 r, N2018-08-10 20:11:08.011 22951 ERROR 067_kilo     self._read_ok_packet()
) u  L/ W, _- \& w/ Y& T/ X2018-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" z# A5 K6 Q9 N5 f# t& n$ K
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     pkt = self._read_packet()
4 M" O5 |' Z. v! `5 G3 I- l6 U2018-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
2 O8 ]! P8 I# D2018-08-10 20:11:08.011 22951 ERROR 067_kilo     packet.check_error(), N) N$ r7 L& u" `
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( q& B  V/ n" B% f6 x6 F& M& k
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     err.raise_mysql_exception(self._data)* ?% j' Z2 T! U  Z
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_exception+ G  R+ H% W& _4 Z4 t" j
2018-08-10 20:11:08.011 22951 ERROR 067_kilo     raise errorclass(errno, errval)) g4 Y& c4 G. U: l% S0 ^
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')7 K3 @" W! g4 \) [: H- O
2018-08-10 20:11:08.011 22951 ERROR 067_kilo
. N8 P5 }1 }7 e8 ^3 M9 `+ w2018-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')
1 B! }; J# W# v0 C2018-08-10 20:11:08.016 22951 ERROR keystone Traceback (most recent call last):
& U( D6 S  X& V% z- c; M2018-08-10 20:11:08.016 22951 ERROR keystone   File "/usr/bin/keystone-manage", line 10, in <module>6 l, y& F9 }8 p3 O# ^- I
2018-08-10 20:11:08.016 22951 ERROR keystone     sys.exit(main()): O* h+ j2 v. v0 Y2 K, ~" r' r
2018-08-10 20:11:08.016 22951 ERROR keystone   File "/usr/lib/python2.7/site-packages/keystone/cmd/manage.py", line 44, in main7 r7 M7 ~! g/ F6 ?3 E! c' ?4 l
2018-08-10 20:11:08.016 22951 ERROR keystone     cli.main(argv=sys.argv, config_files=config_files)
- O9 ]' d& _2 @" o: z% w9 t2018-08-10 20:11:08.016 22951 ERROR keystone   File "/usr/lib/python2.7/site-packages/keystone/cmd/cli.py", line 1331, in main& c8 E0 [3 u! }" l0 P
2018-08-10 20:11:08.016 22951 ERROR keystone     CONF.command.cmd_class.main()' Y( p' N) [$ x  b6 F" h
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
6 z% B, X2 z! n) f2 d$ p% P- o6 J2018-08-10 20:11:08.016 22951 ERROR keystone     CONF.command.version)
( C- _: l, c- [) d6 U, T2018-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# I( U. N$ e! u( s3 M( w
2018-08-10 20:11:08.016 22951 ERROR keystone     expand_schema()
( V3 h" g2 d+ {7 V! ]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
& f2 D% |) d- l5 A: [2018-08-10 20:11:08.016 22951 ERROR keystone     _sync_common_repo(version=None)
0 r2 b; ~; E& z$ }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_repo8 ?1 F0 T1 L0 X6 H2 W8 p
2018-08-10 20:11:08.016 22951 ERROR keystone     init_version=init_version, sanity_check=False)! x$ k: B" A$ M& l* v3 \4 c  _5 u
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; @& K; {; A1 ?$ f9 {- L% c- u6 |9 r
2018-08-10 20:11:08.016 22951 ERROR keystone     raise exception.DbMigrationError(ex)
( I5 s9 H5 @9 S* M8 S2018-08-10 20:11:08.016 22951 ERROR keystone DbMigrationError: (pymysql.err.InternalError) (1047, u'WSREP has not yet prepared node for application use')
# g+ H4 W! C- h! r  a% e2018-08-10 20:11:08.016 22951 ERROR keystone * P! {6 ^4 B+ C$ U

1

主题

0

回帖

12

积分

管理员

积分
12
QQ
 楼主| 发表于 2018-8-10 20:36:33 | 显示全部楼层
数据库出现脑裂导致的问题,需要好好看看什么原因

1

主题

0

回帖

12

积分

管理员

积分
12
QQ
 楼主| 发表于 2018-8-10 21:28:15 | 显示全部楼层
莫名其妙的出现数据库脑裂,好奇怪哦,需要好好看看配置文件了,有地方配置有问题。
您需要登录后才可以回帖 登录 | 注册

本版积分规则

返回首页|Archiver|手机版|小黑屋|易陆发现技术论坛 ( 蜀ICP备2026014127号-1 )

GMT+8, 2026-6-12 03:48 , Processed in 0.019918 second(s), 22 queries .

Powered by Discuz! X5.0

© 2001-2026 Discuz! Team.

快速回复 返回顶部 返回列表