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

keystone报错CRITICAL keystone [-] Unhandled error: ProgrammingError

[复制链接]

1

主题

0

回帖

12

积分

管理员

积分
12
QQ
发表于 2018-8-10 20:06:27 | 显示全部楼层 |阅读模式
2018-08-10 20:05:32.197 22078 CRITICAL keystone [-] Unhandled error: ProgrammingError: (pymysql.err.ProgrammingError) (1146, u"Table 'keystone.project' doesn't exist") [SQL: u'INSERT INTO project (id, name, domain_id, description, enabled, extra, parent_id, is_domain) VALUES (%(id)s, %(name)s, %(domain_id)s, %(description)s, %(enabled)s, %(extra)s, %(parent_id)s, %(is_domain)s)'] [parameters: {'is_domain': 1, 'description': 'The default domain', 'extra': '{}', 'enabled': 1, 'domain_id': '<<keystone.domain.root>>', 'parent_id': None, 'id': 'default', 'name': 'Default'}]( F! Y) R6 G$ X  H: w4 O* f% T
2018-08-10 20:05:32.197 22078 ERROR keystone Traceback (most recent call last):
  m$ [4 ]0 |) R( {& p2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/bin/keystone-manage", line 10, in <module>
. l) `( E( C7 f! d) n2018-08-10 20:05:32.197 22078 ERROR keystone     sys.exit(main())6 m5 C0 K$ R5 R& Y1 N+ }
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/keystone/cmd/manage.py", line 44, in main
4 u; X% l/ c+ k( h' D2018-08-10 20:05:32.197 22078 ERROR keystone     cli.main(argv=sys.argv, config_files=config_files)5 _8 I% c) ^$ F' n) [" Y2 i' o
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/keystone/cmd/cli.py", line 1331, in main" T2 O5 B$ |8 P. U( k% H
2018-08-10 20:05:32.197 22078 ERROR keystone     CONF.command.cmd_class.main()1 u' H! A6 O* ~# [% D# v* \# e- W
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/keystone/cmd/cli.py", line 380, in main
6 J( b9 Q- n! g+ q2 m2018-08-10 20:05:32.197 22078 ERROR keystone     klass.do_bootstrap()
& S/ N& l# b4 V; {" M9 N8 r2 h2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/keystone/cmd/cli.py", line 190, in do_bootstrap2 ^: M% F) Y& i) q
2018-08-10 20:05:32.197 22078 ERROR keystone     domain=default_domain)$ [! w) w' A! p( Q# A* Z/ U; x# P
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/keystone/common/manager.py", line 110, in wrapped# |% @" `  A' q9 K- G8 y9 ?' S
2018-08-10 20:05:32.197 22078 ERROR keystone     __ret_val = __f(*args, **kwargs)$ Z9 f: W$ F9 g; G( ~4 F
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/keystone/resource/core.py", line 723, in create_domain
2 m% C! a0 R- U4 S! W2018-08-10 20:05:32.197 22078 ERROR keystone     domain_id, project_from_domain, initiator)
! \3 H$ m% E7 B  p9 |' u2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/keystone/common/manager.py", line 110, in wrapped
9 l, J7 z8 ^$ D2018-08-10 20:05:32.197 22078 ERROR keystone     __ret_val = __f(*args, **kwargs)2 F4 p, }# e! _+ }2 i4 }+ R* k3 R. s4 V* Z
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/keystone/resource/core.py", line 208, in create_project/ d: ~( [, L" ~! d. \
2018-08-10 20:05:32.197 22078 ERROR keystone     ret = self.driver.create_project(project_id, project)
7 u" l4 E) W8 y2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/keystone/common/sql/core.py", line 505, in wrapper
* p' A$ V0 k7 N* d3 {9 x1 J; d2018-08-10 20:05:32.197 22078 ERROR keystone     return method(*args, **kwargs)
9 }& H1 [, ^0 ]+ I2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/keystone/resource/backends/sql.py", line 181, in create_project5 H' I) M! B7 Z0 t& w0 c
2018-08-10 20:05:32.197 22078 ERROR keystone     return project_ref.to_dict()  Q5 `3 H9 B  z7 i/ K$ d
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/contextlib.py", line 24, in __exit__; ?! W1 @* P  n, h" y: U0 @
2018-08-10 20:05:32.197 22078 ERROR keystone     self.gen.next()1 h7 p. |2 p4 `' p
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 1029, in _transaction_scope6 T- c  N1 E. Y  Z" V2 \
2018-08-10 20:05:32.197 22078 ERROR keystone     yield resource
7 B! K5 J* v' q/ R- H3 }: n/ E2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/contextlib.py", line 24, in __exit__
7 P& R! ]" W  |" W* N2018-08-10 20:05:32.197 22078 ERROR keystone     self.gen.next()9 K7 ^2 w' Z- b) Z$ a
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 641, in _session1 H7 n. O  g) b2 ^' J& x) z4 b$ d1 j
2018-08-10 20:05:32.197 22078 ERROR keystone     self.session.rollback()
7 v+ \: ~" K$ U  k2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__" a; _  j! O9 y2 U1 h, v' u' b/ a
2018-08-10 20:05:32.197 22078 ERROR keystone     self.force_reraise()# y# p% q+ K: i/ A, M
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
8 B1 N+ u4 b' ^1 m8 }9 y- ]2018-08-10 20:05:32.197 22078 ERROR keystone     six.reraise(self.type_, self.value, self.tb)
) Q& W/ H' B# U8 D- p2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 638, in _session1 u, `4 L; D3 B$ q) k7 r
2018-08-10 20:05:32.197 22078 ERROR keystone     self._end_session_transaction(self.session)
* }4 S7 g$ q) D2 g, r2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 666, in _end_session_transaction
8 m3 J$ o  b' P! \1 s4 O4 x9 ?2018-08-10 20:05:32.197 22078 ERROR keystone     session.commit(). M; T$ B9 B6 i8 a4 R4 Z$ f  ^
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 906, in commit
( W; ?1 r% }' t+ O" H+ z. M& z) g2018-08-10 20:05:32.197 22078 ERROR keystone     self.transaction.commit()
' a% H! Y/ S1 N% D: ?( N' H2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 461, in commit( F+ w& p7 @5 Z5 L% Q0 v! p
2018-08-10 20:05:32.197 22078 ERROR keystone     self._prepare_impl()
  }$ \; ~. B' s1 Y: k2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 441, in _prepare_impl9 ~( x2 Z2 @: @( O/ m/ M
2018-08-10 20:05:32.197 22078 ERROR keystone     self.session.flush()
6 n5 c9 h. J5 b( w2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 2171, in flush; w5 H8 h+ B. P4 o
2018-08-10 20:05:32.197 22078 ERROR keystone     self._flush(objects)6 S1 j! N+ C+ I* `. p. V
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 2291, in _flush
9 ^: O9 P- d: `6 }3 t& m2018-08-10 20:05:32.197 22078 ERROR keystone     transaction.rollback(_capture_exception=True)! z5 Z5 p, N" }- u, v% N3 P
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 66, in __exit__# w: z" K, E: C1 f) E
2018-08-10 20:05:32.197 22078 ERROR keystone     compat.reraise(exc_type, exc_value, exc_tb)7 H. ~$ Y( q1 P1 x" s
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 2255, in _flush7 X' b& e! N/ f" S
2018-08-10 20:05:32.197 22078 ERROR keystone     flush_context.execute()
  U8 ^: N' y/ A/ l0 z+ @: t" h2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 389, in execute
3 A$ o; Z1 b+ N% R0 b- L2018-08-10 20:05:32.197 22078 ERROR keystone     rec.execute(self)- h) K! y' n6 U; k& O9 [
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 548, in execute
  p$ z2 G3 f6 w- E/ W2018-08-10 20:05:32.197 22078 ERROR keystone     uow1 ]7 K. Y) z4 ]( D
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 181, in save_obj) @6 b* }/ s( i
2018-08-10 20:05:32.197 22078 ERROR keystone     mapper, table, insert)
3 D& R, @* G' ~, }4 k2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 799, in _emit_insert_statements9 j1 x4 H6 Y, x$ v$ C
2018-08-10 20:05:32.197 22078 ERROR keystone     execute(statement, multiparams)
  ?$ @: F2 a; z* `2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 945, in execute
$ N) n% ]. T7 W% e9 ?; Q2018-08-10 20:05:32.197 22078 ERROR keystone     return meth(self, multiparams, params); n4 Z) W+ p! F5 J, b% T( X
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/elements.py", line 263, in _execute_on_connection; f& h# P' H7 F' r& y/ p
2018-08-10 20:05:32.197 22078 ERROR keystone     return connection._execute_clauseelement(self, multiparams, params)
; C$ X" G' ]% ?8 C- @. t2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1053, in _execute_clauseelement& U8 W2 i* m& K5 U9 K% w
2018-08-10 20:05:32.197 22078 ERROR keystone     compiled_sql, distilled_params* M8 z; D8 c# @) r5 h7 t4 ^
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1189, in _execute_context# m0 @: m7 ~9 ?/ r
2018-08-10 20:05:32.197 22078 ERROR keystone     context)
# y8 F; L8 n/ W2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1398, in _handle_dbapi_exception/ S! Q9 u2 v% S) I1 {' v
2018-08-10 20:05:32.197 22078 ERROR keystone     util.raise_from_cause(newraise, exc_info)
$ W* a% U9 C- v  ~3 f4 ?+ \2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
* q+ J# z, ?8 \1 x2018-08-10 20:05:32.197 22078 ERROR keystone     reraise(type(exception), exception, tb=exc_tb, cause=cause)
1 I- B( e" S! K. o/ \7 J2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1182, in _execute_context: x; F! ~! }( V" j+ o
2018-08-10 20:05:32.197 22078 ERROR keystone     context)
3 P. v/ y* G1 n: p0 c2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 470, in do_execute; d4 L7 f" @+ s+ x  W2 r
2018-08-10 20:05:32.197 22078 ERROR keystone     cursor.execute(statement, parameters), N( o" b2 w. y0 o  w
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 166, in execute% D- d/ C+ \  J
2018-08-10 20:05:32.197 22078 ERROR keystone     result = self._query(query)4 A: n% h! m, I3 m; i7 z
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 322, in _query
9 n* B. `' l& \0 W/ I2 I2018-08-10 20:05:32.197 22078 ERROR keystone     conn.query(q)3 A2 Z1 K( g; F  E2 \2 r
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 856, in query; l! E; f1 V/ B, {8 t; e" p/ _
2018-08-10 20:05:32.197 22078 ERROR keystone     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
. U0 x# H6 E) `3 {) O, p! f; n5 J2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1057, in _read_query_result$ ^( j* D- t- ^+ z
2018-08-10 20:05:32.197 22078 ERROR keystone     result.read()
6 u: R" A8 M3 |' `% Y2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1340, in read+ m! w% o" e: m( P- M
2018-08-10 20:05:32.197 22078 ERROR keystone     first_packet = self.connection._read_packet()
4 A# I- N* E; Q0 m1 t- S2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1014, in _read_packet
$ }' X+ j; t/ B. |2018-08-10 20:05:32.197 22078 ERROR keystone     packet.check_error()5 Y4 B( G& j( U* x
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 393, in check_error6 u/ {% D' H  A# t& b- b  J
2018-08-10 20:05:32.197 22078 ERROR keystone     err.raise_mysql_exception(self._data)
" C; v% u  b4 c  {: z+ c, @2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception2 y4 n" u6 X' [! q$ T$ c1 {1 r/ V
2018-08-10 20:05:32.197 22078 ERROR keystone     raise errorclass(errno, errval)- G3 ]* Z" X, e/ C9 w
2018-08-10 20:05:32.197 22078 ERROR keystone ProgrammingError: (pymysql.err.ProgrammingError) (1146, u"Table 'keystone.project' doesn't exist") [SQL: u'INSERT INTO project (id, name, domain_id, description, enabled, extra, parent_id, is_domain) VALUES (%(id)s, %(name)s, %(domain_id)s, %(description)s, %(enabled)s, %(extra)s, %(parent_id)s, %(is_domain)s)'] [parameters: {'is_domain': 1, 'description': 'The default domain', 'extra': '{}', 'enabled': 1, 'domain_id': '<<keystone.domain.root>>', 'parent_id': None, 'id': 'default', 'name': 'Default'}]
* G% M' B5 g0 q) ~1 k2018-08-10 20:05:32.197 22078 ERROR keystone
4 x# }+ ?* G% {6 g, e

1

主题

0

回帖

12

积分

管理员

积分
12
QQ
 楼主| 发表于 2018-8-10 21:29:28 | 显示全部楼层
原因就是数据库出现脑裂,导致数据库不一致导致的。很奇怪的现象,需要好好检查配置文件。

1

主题

0

回帖

12

积分

管理员

积分
12
QQ
 楼主| 发表于 2018-8-29 11:15:52 | 显示全部楼层
解决问题,可以不用纠结这个集群问题,可以先暂时停止掉数据库galera集群服务,只启动一个节点的数据库服务,既可以解决这个问题。
您需要登录后才可以回帖 登录 | 注册

本版积分规则

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

GMT+8, 2026-6-12 02:44 , Processed in 0.017570 second(s), 22 queries .

Powered by Discuz! X5.0

© 2001-2026 Discuz! Team.

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