浏览此站
联系我们相册切换到窄版 Language

 找回密码
 注册
易陆发现论坛»论坛 › 云计算开源区 › OpenStack问题汇总 › keystone报错CRITICAL keystone [-] Unhandled error: P ...
返回列表 发新帖
查看: 5931|回复: 2

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

[复制链接]
admin

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'}]
/ J3 ]3 ?1 c1 D( M2018-08-10 20:05:32.197 22078 ERROR keystone Traceback (most recent call last):
1 \4 a4 @; E1 Z( O2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/bin/keystone-manage", line 10, in <module>9 S. u  ?7 t& t0 H! B" z% B; x
2018-08-10 20:05:32.197 22078 ERROR keystone     sys.exit(main())5 I- G' v+ j, n: a9 l
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, C( _; h0 R& V- ~3 x2 @
2018-08-10 20:05:32.197 22078 ERROR keystone     cli.main(argv=sys.argv, config_files=config_files)! l8 X5 z; O/ r2 z: n
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$ ]5 `3 X1 u$ E9 I7 Y0 M$ S3 G
2018-08-10 20:05:32.197 22078 ERROR keystone     CONF.command.cmd_class.main()" E) l9 O' ]' j9 E8 F1 ?
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
; P% b. j# [: z& A7 s$ G, h2018-08-10 20:05:32.197 22078 ERROR keystone     klass.do_bootstrap()
0 o8 e3 w6 ]8 k* B2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/keystone/cmd/cli.py", line 190, in do_bootstrap
- `9 |9 ], ]4 Z$ m+ }4 {6 F' K2018-08-10 20:05:32.197 22078 ERROR keystone     domain=default_domain)2 P* a% y( Q9 X+ B. R( 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# h6 e! M$ H) x# {. u' `, i
2018-08-10 20:05:32.197 22078 ERROR keystone     __ret_val = __f(*args, **kwargs)
9 E  C9 A0 _1 @& P+ `; o. b2 s2018-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
+ k& {/ Y; z: a  Z3 z2018-08-10 20:05:32.197 22078 ERROR keystone     domain_id, project_from_domain, initiator)
6 n" X. _* C  G- k$ H2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/keystone/common/manager.py", line 110, in wrapped$ A4 G! d& J$ P7 K8 `) j
2018-08-10 20:05:32.197 22078 ERROR keystone     __ret_val = __f(*args, **kwargs)0 A8 _2 m, _, k! B9 i# H8 {' T
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# j, j' f* f# O. J  X% X1 t& D
2018-08-10 20:05:32.197 22078 ERROR keystone     ret = self.driver.create_project(project_id, project)7 X8 b, H0 v+ i3 q
2018-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% J2 Y% X! C5 B8 R  u0 F
2018-08-10 20:05:32.197 22078 ERROR keystone     return method(*args, **kwargs)
5 q: L# k" F: {5 H2018-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_project  G4 X% w) V6 w/ q( g) K
2018-08-10 20:05:32.197 22078 ERROR keystone     return project_ref.to_dict()) E; W/ ]1 `0 d% y( W
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/contextlib.py", line 24, in __exit__8 L' D: m" S% L
2018-08-10 20:05:32.197 22078 ERROR keystone     self.gen.next()# t2 s2 ~& A& c
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_scope
0 {6 L2 A5 E1 |: c" m& t' l2018-08-10 20:05:32.197 22078 ERROR keystone     yield resource
6 M1 {2 C0 x) r9 r( Z* n2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/contextlib.py", line 24, in __exit__% A+ ?+ n, k( f' K
2018-08-10 20:05:32.197 22078 ERROR keystone     self.gen.next()% Z! c2 I" e; k0 u( E, w( 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 _session
5 @) J. D' H6 r% P- r9 S2 j2 q; N2018-08-10 20:05:32.197 22078 ERROR keystone     self.session.rollback()
6 ~! ]8 ~: |; p/ t3 G2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
! G% W0 g' {* X1 d2018-08-10 20:05:32.197 22078 ERROR keystone     self.force_reraise(); ]1 v+ s- a! r* W
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
5 y! y. q' a% H0 e2018-08-10 20:05:32.197 22078 ERROR keystone     six.reraise(self.type_, self.value, self.tb); [0 A1 S2 \$ W5 Q9 U
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 638, in _session/ B5 Q  D% M" k7 H0 G: l
2018-08-10 20:05:32.197 22078 ERROR keystone     self._end_session_transaction(self.session)
. r, r4 i* T; o- H2018-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_transaction2 s4 ~6 C  p! Z5 P, ?/ M
2018-08-10 20:05:32.197 22078 ERROR keystone     session.commit()
; B8 C  E5 j1 ]$ d4 h) D2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 906, in commit
2 Y- x' |: l6 ^/ ?- s" X2018-08-10 20:05:32.197 22078 ERROR keystone     self.transaction.commit()
6 b3 i. Y6 T1 F) J  I2 c& ?. Z2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 461, in commit
2 S0 h# m3 ^; G% m" R- H2018-08-10 20:05:32.197 22078 ERROR keystone     self._prepare_impl()
, b3 h2 f6 P3 F5 k! E2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 441, in _prepare_impl
3 B* I- T9 \0 b2018-08-10 20:05:32.197 22078 ERROR keystone     self.session.flush()
6 d2 K! R& u& L& m$ v" c; Q2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 2171, in flush, x8 L5 e7 @! |  q7 y6 r- s
2018-08-10 20:05:32.197 22078 ERROR keystone     self._flush(objects)" p3 ]7 h8 p# M( e7 C+ f
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
6 K2 n+ I9 q4 k( P& i/ w: m2018-08-10 20:05:32.197 22078 ERROR keystone     transaction.rollback(_capture_exception=True)" d, A: x/ b2 H
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__
+ p7 E  ?6 N( k1 T3 |9 I" j" S9 Q# v  o2018-08-10 20:05:32.197 22078 ERROR keystone     compat.reraise(exc_type, exc_value, exc_tb)
3 P: W- q4 \. |% [! P2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 2255, in _flush
5 ]7 N( M8 |, S( N9 ?$ s2018-08-10 20:05:32.197 22078 ERROR keystone     flush_context.execute()$ V' w( D4 n1 h7 f
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 389, in execute8 f; A) y: d# n# `; l+ Y1 `
2018-08-10 20:05:32.197 22078 ERROR keystone     rec.execute(self)
6 N2 p' L  p% ^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/ D  ]2 E7 K% }
2018-08-10 20:05:32.197 22078 ERROR keystone     uow+ ?$ T6 h9 h8 e0 F# H
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- W8 {& e6 {1 k$ `
2018-08-10 20:05:32.197 22078 ERROR keystone     mapper, table, insert)) z* C4 _5 G" R; [
2018-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_statements
$ T7 ^, Y2 [; L1 G2018-08-10 20:05:32.197 22078 ERROR keystone     execute(statement, multiparams)6 T! S7 b% H! w
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
  {$ h, M4 U7 R2018-08-10 20:05:32.197 22078 ERROR keystone     return meth(self, multiparams, params)
2 b( e" R% J" G2 N2018-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
3 Q( a( R4 W) X6 Z- A, i2 @5 ~8 |8 B2018-08-10 20:05:32.197 22078 ERROR keystone     return connection._execute_clauseelement(self, multiparams, params)5 L# m' a( B+ ^0 ~$ s
2018-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
+ \3 F6 ]  u6 d6 G2 W% M$ a2018-08-10 20:05:32.197 22078 ERROR keystone     compiled_sql, distilled_params
8 o0 W: x6 Z: t7 s* m4 K2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1189, in _execute_context2 v4 [4 [+ v1 \: H3 j! J
2018-08-10 20:05:32.197 22078 ERROR keystone     context)* \6 \$ f! u' ]
2018-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
: ^6 u. E+ f1 n" F2018-08-10 20:05:32.197 22078 ERROR keystone     util.raise_from_cause(newraise, exc_info)7 R2 r% ?% m: p8 i0 [2 a. D( B
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/ B: i  ], K; ^. k* J
2018-08-10 20:05:32.197 22078 ERROR keystone     reraise(type(exception), exception, tb=exc_tb, cause=cause)! i& O/ {$ C& }; j0 a* \8 F, U
2018-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' ]; C0 I! b; j- A/ ^+ ~" [
2018-08-10 20:05:32.197 22078 ERROR keystone     context)
: M0 C* K4 z9 m: Q8 u2018-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& l) i, Q  w9 n  t
2018-08-10 20:05:32.197 22078 ERROR keystone     cursor.execute(statement, parameters)
6 b2 n- j9 x( {" J3 _2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 166, in execute& y: W- L4 L; |2 U# Y' ^, P: w5 p
2018-08-10 20:05:32.197 22078 ERROR keystone     result = self._query(query)2 }- i) B3 ~7 Z, h* C! k! ]3 z, {
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 322, in _query4 I& A+ a) W4 @# s
2018-08-10 20:05:32.197 22078 ERROR keystone     conn.query(q)
5 D6 y7 a+ H1 a+ x2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 856, in query
  d0 g2 w4 D8 ]2 V( J0 |4 S# O* q2018-08-10 20:05:32.197 22078 ERROR keystone     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
9 O! }4 M; L8 `* F2018-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
: S+ w. w3 W/ c5 L! A2018-08-10 20:05:32.197 22078 ERROR keystone     result.read()
* f: v% [3 m" k! L2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1340, in read
* `5 z1 R" B, d. G$ Z# H% V2018-08-10 20:05:32.197 22078 ERROR keystone     first_packet = self.connection._read_packet()
( ^3 Q, i' [0 {  z2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1014, in _read_packet
4 @) d3 H' H+ b: I! |3 z& f% }2018-08-10 20:05:32.197 22078 ERROR keystone     packet.check_error()
) [+ s" a' V4 \: S2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 393, in check_error
- w. c# k. V" g2 T6 m% I2018-08-10 20:05:32.197 22078 ERROR keystone     err.raise_mysql_exception(self._data)0 P: u& S5 G2 ]7 D6 _9 w! m/ h
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_exception* t- f* T: N  H) W+ ?0 z9 n% U
2018-08-10 20:05:32.197 22078 ERROR keystone     raise errorclass(errno, errval)
: G6 T$ D" m) q' r' i( F3 g) |- }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'}]
# x) V/ q! I4 F2018-08-10 20:05:32.197 22078 ERROR keystone
- ]+ W) A: @( R$ B9 o# R, }' u
回复

举报

admin

1

主题

0

回帖

12

积分

管理员

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

举报

admin

1

主题

0

回帖

12

积分

管理员

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

举报

返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

本版积分规则

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

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

Powered by Discuz! X5.0

© 2001-2026 Discuz! Team.

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