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

易陆发现互联网技术论坛

 找回密码
 开始注册
易陆发现互联网技术论坛»首页 › 云计算开源区 › OpenStack问题汇总 › keystone报错CRITICAL keystone [-] Unhandled error: P ...
查看: 5927|回复: 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'}]
7 V( @, r: h/ l1 w4 R2018-08-10 20:05:32.197 22078 ERROR keystone Traceback (most recent call last):; `+ ?" v  v' Q( a7 j8 e4 K$ s
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/bin/keystone-manage", line 10, in <module>/ L/ D; Y! O3 {: s
2018-08-10 20:05:32.197 22078 ERROR keystone     sys.exit(main())7 ]3 c& ?! {7 X* a$ l% u7 P
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/keystone/cmd/manage.py", line 44, in main9 d9 c  {1 n0 f
2018-08-10 20:05:32.197 22078 ERROR keystone     cli.main(argv=sys.argv, config_files=config_files)  R5 r/ S/ E7 w6 I) n' @, X- F4 T
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- W) ?( Q. T, D3 u, N! @
2018-08-10 20:05:32.197 22078 ERROR keystone     CONF.command.cmd_class.main(): G! a0 M; h% Z
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- r+ B4 B+ u4 J0 v9 T! a5 ?
2018-08-10 20:05:32.197 22078 ERROR keystone     klass.do_bootstrap(), Q4 U7 O) E, n3 T. E& G( p3 g
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
/ g7 ~; j' G7 g* B; b2018-08-10 20:05:32.197 22078 ERROR keystone     domain=default_domain)* w# @% ^% `3 p2 i4 c+ D7 q
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
7 z+ D+ Q) d2 }6 Q9 ]; W2018-08-10 20:05:32.197 22078 ERROR keystone     __ret_val = __f(*args, **kwargs)& Q- h) H7 Z4 O3 E
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
# f5 E; b7 _, w" I2018-08-10 20:05:32.197 22078 ERROR keystone     domain_id, project_from_domain, initiator)+ z: k; K2 [! \( Z% ]% B
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
+ `* Q0 R* d; L2018-08-10 20:05:32.197 22078 ERROR keystone     __ret_val = __f(*args, **kwargs)
+ s. P1 S6 U7 D2 F$ \$ a8 S! V2018-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
. f1 f) B8 V  m- Y1 q9 m/ C2018-08-10 20:05:32.197 22078 ERROR keystone     ret = self.driver.create_project(project_id, project)
9 v0 C5 D% H- x$ L+ e( x2018-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: n7 J* T, r% s/ V- e
2018-08-10 20:05:32.197 22078 ERROR keystone     return method(*args, **kwargs)  p& g1 w' |/ f( _) e
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
0 H' ?  K/ u8 H! x5 Z  t, U2018-08-10 20:05:32.197 22078 ERROR keystone     return project_ref.to_dict()( B9 \( s1 z& W$ Q& {" S& F3 C" n$ H
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/contextlib.py", line 24, in __exit__& A7 j- d# J3 c# i' O3 r
2018-08-10 20:05:32.197 22078 ERROR keystone     self.gen.next()
+ f' ]' Y' _; J1 D, q( k0 T5 |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_scope8 D$ m) W* T& W0 T2 Q
2018-08-10 20:05:32.197 22078 ERROR keystone     yield resource
( b5 \3 I" X' s2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/contextlib.py", line 24, in __exit__) I  `+ Q9 j) c/ z- [  s# U/ R( u
2018-08-10 20:05:32.197 22078 ERROR keystone     self.gen.next()
' n, Q% k% O/ _5 p# B( F$ R- Z# I. z2018-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
! R* x' `2 L7 A* v- d2018-08-10 20:05:32.197 22078 ERROR keystone     self.session.rollback()
0 W* B$ U" V: M2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
: U/ m% e, @) s% K5 R2018-08-10 20:05:32.197 22078 ERROR keystone     self.force_reraise()
  y6 W' P) C% D- z4 Z+ U" R2018-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: _+ Q8 X- ?( K5 Y
2018-08-10 20:05:32.197 22078 ERROR keystone     six.reraise(self.type_, self.value, self.tb)1 G6 u+ U# c' l
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 _session3 J1 F$ K7 M) @
2018-08-10 20:05:32.197 22078 ERROR keystone     self._end_session_transaction(self.session): ]4 E6 ^4 d( y. z  }: b
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_transaction0 d1 z( q  M8 s& ^5 N$ ]. o
2018-08-10 20:05:32.197 22078 ERROR keystone     session.commit()* Z+ I* ~& b$ t
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
% j  Z# |; [5 ~2018-08-10 20:05:32.197 22078 ERROR keystone     self.transaction.commit()' Y. t& N  w* H, `( Q% P' [! I
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 461, in commit" Q; Y8 s5 |4 O3 Z. i& w
2018-08-10 20:05:32.197 22078 ERROR keystone     self._prepare_impl()
$ ]$ E, G' R3 Z. r- L2018-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# Y# S; _3 @2 q' f% n' S
2018-08-10 20:05:32.197 22078 ERROR keystone     self.session.flush(); L& q" p% Q' ^5 ~9 r, G4 [
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
8 B6 v+ z+ N' l8 w% o2018-08-10 20:05:32.197 22078 ERROR keystone     self._flush(objects)& P; R" W! ?9 @, i- M, u, b
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- W  K- U$ U: I8 Z( c
2018-08-10 20:05:32.197 22078 ERROR keystone     transaction.rollback(_capture_exception=True)
3 z: I/ M  q& X& b- y& E, Z+ u$ W2 d2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 66, in __exit__( F6 Z/ A+ h+ u1 d4 y1 t; j
2018-08-10 20:05:32.197 22078 ERROR keystone     compat.reraise(exc_type, exc_value, exc_tb)
: g( o! H, z! E: [9 D2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 2255, in _flush+ s3 W9 G/ J! J) `: T$ E
2018-08-10 20:05:32.197 22078 ERROR keystone     flush_context.execute()
& L3 J$ l" L5 x6 J$ S$ Y7 k) z2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 389, in execute
, O& |" ?( A; Z2018-08-10 20:05:32.197 22078 ERROR keystone     rec.execute(self)
. o. Y0 t7 t, Y2 F2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 548, in execute
. L5 }8 W/ r0 p8 M/ `2018-08-10 20:05:32.197 22078 ERROR keystone     uow6 i. h$ X" e# t6 [
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" W6 y9 u8 z1 ~) S2 A6 `
2018-08-10 20:05:32.197 22078 ERROR keystone     mapper, table, insert)7 ^+ w; o7 D" b  e
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
1 ?: K# T% N' r- f2018-08-10 20:05:32.197 22078 ERROR keystone     execute(statement, multiparams)
7 O: G  E; P+ v/ t! |6 S2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 945, in execute' N4 J, c9 G0 n* b: W; R1 P
2018-08-10 20:05:32.197 22078 ERROR keystone     return meth(self, multiparams, params): _7 K; }' O4 Z* T
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( w: k4 M9 P' |/ E
2018-08-10 20:05:32.197 22078 ERROR keystone     return connection._execute_clauseelement(self, multiparams, params)7 Y7 n$ P! D/ }  _- @
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
- A. z9 {9 n) R# a' T: N6 k+ `& Y2018-08-10 20:05:32.197 22078 ERROR keystone     compiled_sql, distilled_params0 S3 Y: d6 G7 D$ A0 Y
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
$ ]9 L7 {3 H8 h, \) e* S, Z9 R2018-08-10 20:05:32.197 22078 ERROR keystone     context)# z* [! o/ u# t8 \! p. C
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_exception5 w0 o- z, j9 s6 q; C+ h
2018-08-10 20:05:32.197 22078 ERROR keystone     util.raise_from_cause(newraise, exc_info)) J1 v% c( F8 B  b  ~' E5 M
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. k4 k5 d' _3 n: O( P9 P
2018-08-10 20:05:32.197 22078 ERROR keystone     reraise(type(exception), exception, tb=exc_tb, cause=cause)
9 E' P  I1 W& x+ l2 K8 C. q2018-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) e' Y/ l* r8 v5 d
2018-08-10 20:05:32.197 22078 ERROR keystone     context)" z/ k4 _4 J( y! g3 ]
2018-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
$ `8 n5 G. w' p7 c% X/ M5 x2018-08-10 20:05:32.197 22078 ERROR keystone     cursor.execute(statement, parameters)
$ T7 ~% D8 p9 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
0 ]4 M( k- \) ]' e% b& C' [8 w2018-08-10 20:05:32.197 22078 ERROR keystone     result = self._query(query)# t" S9 E2 J; I3 o5 G, O1 @  l; _
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 322, in _query' ]  v; }1 {) t
2018-08-10 20:05:32.197 22078 ERROR keystone     conn.query(q)
  s6 k8 Q* k0 I( k# y) r2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 856, in query
4 L, h/ U6 t+ I' X" I% T% @  i& n2018-08-10 20:05:32.197 22078 ERROR keystone     self._affected_rows = self._read_query_result(unbuffered=unbuffered)3 G. s0 n& ]. p' X% i! v
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" A5 ~7 y0 F/ Q- s+ [
2018-08-10 20:05:32.197 22078 ERROR keystone     result.read()  g# F2 _, P7 U& b7 E
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1340, in read3 i5 v0 q8 R5 c9 Z8 v7 X- b/ w+ h- w
2018-08-10 20:05:32.197 22078 ERROR keystone     first_packet = self.connection._read_packet()
) ^7 R* E. k( ?0 |) ~+ b; i6 F2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1014, in _read_packet
) Z8 A  G: B" o3 C2018-08-10 20:05:32.197 22078 ERROR keystone     packet.check_error()( P7 \& R2 {$ q7 w1 B$ A, ^
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 H$ q( p5 G" s! T) K+ Y
2018-08-10 20:05:32.197 22078 ERROR keystone     err.raise_mysql_exception(self._data)2 d5 \/ j8 G* L' R6 t* L+ j
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% u  l8 Q% [+ k) |/ F1 j% ]. @
2018-08-10 20:05:32.197 22078 ERROR keystone     raise errorclass(errno, errval)7 y( a$ M6 ]! }5 l  i2 V
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'}], V" }1 P% b5 X
2018-08-10 20:05:32.197 22078 ERROR keystone
  W: @$ P& h# x; Y2 c. t
回复

使用道具 举报

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|小黑屋|易陆发现技术论坛 ( 蜀ICP备2026014127号-1 )点击这里给我发消息

GMT+8, 2026-4-8 21:23 , Processed in 0.047347 second(s), 21 queries .

Powered by Discuz! X3.4 Licensed

© 2012-2025 Discuz! Team.

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