将设为首页浏览此站
收藏本站联系我们相册切换到窄版

易陆发现互联网技术论坛

 找回密码
 开始注册
易陆发现互联网技术论坛»首页 › 云计算开源区 › OpenStack问题汇总 › keystone报错CRITICAL keystone [-] Unhandled error: P ...
查看: 5933|回复: 2
收起左侧

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

[复制链接]
admin
发表于 2018-8-10 20:06:27 | 显示全部楼层 |阅读模式

马上注册，结交更多好友，享用更多功能，让你轻松玩转社区。

您需要 登录 才可以下载或查看，没有账号？开始注册

x
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'}]6 _$ T' Z/ T' H1 r, ^3 K& x. S
2018-08-10 20:05:32.197 22078 ERROR keystone Traceback (most recent call last):
9 R' Q2 Q; Q) x1 u8 w2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/bin/keystone-manage", line 10, in <module>3 T; i% f( ~+ y
2018-08-10 20:05:32.197 22078 ERROR keystone     sys.exit(main())- ]# j2 ?, M; s& k8 _0 K
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/keystone/cmd/manage.py", line 44, in main1 p2 h; F; {8 S) A$ `* T% b
2018-08-10 20:05:32.197 22078 ERROR keystone     cli.main(argv=sys.argv, config_files=config_files). }, Y: _. I- P  X5 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 main9 j) C! ]2 a6 _2 E. X! H* ]. U
2018-08-10 20:05:32.197 22078 ERROR keystone     CONF.command.cmd_class.main()
4 K- ]4 r- V" ?0 L8 k' A* n4 s2018-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 c0 f7 [1 A& T" O2018-08-10 20:05:32.197 22078 ERROR keystone     klass.do_bootstrap()
) b3 n. z' G2 R( M% [2018-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
+ p- u% V; C8 Y( n6 l2018-08-10 20:05:32.197 22078 ERROR keystone     domain=default_domain)" {! r" A! {* o) M
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
1 @  s: v9 D5 ~2018-08-10 20:05:32.197 22078 ERROR keystone     __ret_val = __f(*args, **kwargs)- V+ ^+ Y' b  V; M* Y
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
3 G) U, h  G+ G# `9 g2018-08-10 20:05:32.197 22078 ERROR keystone     domain_id, project_from_domain, initiator)# Q$ x" b6 X) p8 W7 n
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$ F( C. b5 O( E! r+ T8 s
2018-08-10 20:05:32.197 22078 ERROR keystone     __ret_val = __f(*args, **kwargs)
4 j# p4 w( j/ A0 r5 i$ ^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. `7 ]- f2 j7 M5 [
2018-08-10 20:05:32.197 22078 ERROR keystone     ret = self.driver.create_project(project_id, project)
& D8 b/ I& X; B( b$ u) B7 j) ~! f2018-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! W7 n; [6 p0 J$ w7 t6 A. r& A, @
2018-08-10 20:05:32.197 22078 ERROR keystone     return method(*args, **kwargs); Y$ z/ ?% c8 i) S
2018-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  i  |7 X: {" ^& B& [
2018-08-10 20:05:32.197 22078 ERROR keystone     return project_ref.to_dict()
; F! l5 {. T! I; ~2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/contextlib.py", line 24, in __exit__& ~9 C& U  S( T% w+ @( k2 R, x
2018-08-10 20:05:32.197 22078 ERROR keystone     self.gen.next(); i/ j5 b/ D; l
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( P8 z2 _- B4 o  ^1 X$ ]5 U. I' C
2018-08-10 20:05:32.197 22078 ERROR keystone     yield resource
0 B1 y" Q: `) ~" _4 ^( _$ r2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/contextlib.py", line 24, in __exit__7 w, G* q! g2 b, b8 Z5 R
2018-08-10 20:05:32.197 22078 ERROR keystone     self.gen.next()4 D) C, I  f; X2 v- u) N; i
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
- T# n* q4 y7 X% H2018-08-10 20:05:32.197 22078 ERROR keystone     self.session.rollback()
- S6 G0 \' z! s2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__( G2 i: j0 d, @, Q2 ~( K6 r
2018-08-10 20:05:32.197 22078 ERROR keystone     self.force_reraise()
" ~% o/ [! i- n) C5 ~1 Y/ x5 P$ U3 q2018-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) _; V" s$ b0 w4 P* D' ]' X
2018-08-10 20:05:32.197 22078 ERROR keystone     six.reraise(self.type_, self.value, self.tb)
( S% ]! U; s8 u, b. J  x( W+ q5 u2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 638, in _session5 v0 D0 ~/ G# K8 {4 I$ S! X9 w& S( G
2018-08-10 20:05:32.197 22078 ERROR keystone     self._end_session_transaction(self.session)2 W* o, K9 S$ \4 U5 @
2018-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* v7 E" }- {! v
2018-08-10 20:05:32.197 22078 ERROR keystone     session.commit()( v' |2 I. Y0 H3 V
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$ K3 o& z2 K5 ]0 k6 |
2018-08-10 20:05:32.197 22078 ERROR keystone     self.transaction.commit()
& l; e% C3 _; V3 ~& Z3 z  K7 L/ o2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 461, in commit4 J# E- _, l% C" U  ]2 i/ c
2018-08-10 20:05:32.197 22078 ERROR keystone     self._prepare_impl()
8 _" h) S( T7 ^, D2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 441, in _prepare_impl3 P4 N  o% J" s2 r  f" Q
2018-08-10 20:05:32.197 22078 ERROR keystone     self.session.flush()2 s4 p) M& a0 q: N, E2 S  `
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 2171, in flush
( T' s- t1 @% [9 i- _2018-08-10 20:05:32.197 22078 ERROR keystone     self._flush(objects)9 }, ^" y* ^! ~& e2 O, A9 d" t
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
* h  U+ Z, f' I- L  ]- `2018-08-10 20:05:32.197 22078 ERROR keystone     transaction.rollback(_capture_exception=True)1 `# X9 h6 `3 [( j$ ]2 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__* E7 w' x9 K/ h5 u- |  Q
2018-08-10 20:05:32.197 22078 ERROR keystone     compat.reraise(exc_type, exc_value, exc_tb). Y6 }, a- w: E3 U6 J  a
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 2255, in _flush: t' W9 S4 D* D( r/ l
2018-08-10 20:05:32.197 22078 ERROR keystone     flush_context.execute()* T2 |9 h- l0 |
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 389, in execute& L8 u- C# I" U6 C; I1 U: \. }
2018-08-10 20:05:32.197 22078 ERROR keystone     rec.execute(self)
* o# d5 ]$ f! b+ |4 e. q& U) z2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 548, in execute  `+ w3 i, @% _
2018-08-10 20:05:32.197 22078 ERROR keystone     uow3 Q' d4 W  h5 Z5 `2 n- C
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
: W- }2 e# l6 @  y2018-08-10 20:05:32.197 22078 ERROR keystone     mapper, table, insert)/ I7 a, n" a- V) A  z0 L* L
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
+ u. K6 A" k" E; [0 Z4 h2018-08-10 20:05:32.197 22078 ERROR keystone     execute(statement, multiparams)0 `" G3 N: ]9 X9 Y
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 945, in execute4 a9 A# m: {3 e2 x8 N( x# s
2018-08-10 20:05:32.197 22078 ERROR keystone     return meth(self, multiparams, params)
* G1 f- o8 u! y# B8 [$ \+ C5 S2018-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_connection2 Y) z3 s/ M- |; ~: B2 Y' N- n
2018-08-10 20:05:32.197 22078 ERROR keystone     return connection._execute_clauseelement(self, multiparams, params)) {% @) r' h+ R2 Y. T6 g8 X" U
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
* p0 J0 Y: z+ @( ]# D/ [9 L2018-08-10 20:05:32.197 22078 ERROR keystone     compiled_sql, distilled_params
  \: ^4 C$ Y' \: K" A* X2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1189, in _execute_context5 E) P% h1 i" y1 @" [9 p
2018-08-10 20:05:32.197 22078 ERROR keystone     context)* D# F% F' G5 H7 o8 K/ Z
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_exception2 S( T; E* E4 M
2018-08-10 20:05:32.197 22078 ERROR keystone     util.raise_from_cause(newraise, exc_info)- x7 k6 M. S9 O" I
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
% t) J4 k% L. L0 V2018-08-10 20:05:32.197 22078 ERROR keystone     reraise(type(exception), exception, tb=exc_tb, cause=cause)
: ~$ W% x" k6 ]2 j! G9 D9 W2018-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
5 `" ?+ ?! Q3 q( b6 F) ~2018-08-10 20:05:32.197 22078 ERROR keystone     context)
/ }  p- ^9 S, H8 v" t9 D2018-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
( w/ F* h4 |+ A7 t8 T7 n' O" [2018-08-10 20:05:32.197 22078 ERROR keystone     cursor.execute(statement, parameters)
3 W. V/ W1 R$ f% ?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) `2 F5 O2 J5 Z  P0 @, ^( V( b2018-08-10 20:05:32.197 22078 ERROR keystone     result = self._query(query)# g: g6 ?+ w" h- f
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 322, in _query+ H) p5 c' S0 z" T" h
2018-08-10 20:05:32.197 22078 ERROR keystone     conn.query(q)
! K' n7 P9 F" m4 L$ j' X8 u2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 856, in query5 @" ^5 x; Q0 h5 @. |# m
2018-08-10 20:05:32.197 22078 ERROR keystone     self._affected_rows = self._read_query_result(unbuffered=unbuffered)3 \, \5 c2 ~! p2 [' U$ Z2 d
2018-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; _! M( n% J; T4 X% F6 G$ p, Q
2018-08-10 20:05:32.197 22078 ERROR keystone     result.read()# H. y# I5 u. l$ g' X
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1340, in read1 M& K7 ~5 A6 [; e* T
2018-08-10 20:05:32.197 22078 ERROR keystone     first_packet = self.connection._read_packet()' s" S/ ]- G, e' o. ]+ V' t( Y* ]
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1014, in _read_packet$ J( f& d' W: [, |. v
2018-08-10 20:05:32.197 22078 ERROR keystone     packet.check_error()3 K( _: l" q% Y4 y
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 393, in check_error
* K& B5 ^( F" e1 l1 O, g. F1 O. a2018-08-10 20:05:32.197 22078 ERROR keystone     err.raise_mysql_exception(self._data)
3 Q- T4 ~+ M& b2 G& |( b2018-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* a7 s* t% m. K/ U  Y- O, v# d
2018-08-10 20:05:32.197 22078 ERROR keystone     raise errorclass(errno, errval)9 j( {: k% |/ x
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'}]! ^+ U, l! l: z7 N2 B1 _
2018-08-10 20:05:32.197 22078 ERROR keystone : l# w! a9 H# d
回复

使用道具 举报

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

使用道具 举报

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

使用道具 举报

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

本版积分规则

关闭

站长推荐上一条 /4 下一条

北京云银创陇科技有限公司以云计算运维，代码开发

QQ|返回首页|Archiver|小黑屋|易陆发现技术论坛 点击这里给我发消息

GMT+8, 2026-4-10 16:22 , Processed in 0.040905 second(s), 21 queries .

Powered by Discuz! X3.4 Licensed

© 2012-2025 Discuz! Team.

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