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

 找回密码
 注册
易陆发现论坛»论坛 › 云计算开源区 › OpenStack问题汇总 › keystone报错CRITICAL keystone [-] Unhandled error: P ...
返回列表 发新帖
查看: 5928|回复: 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'}]
( P! ?0 \% `: |  |  q/ \3 p2018-08-10 20:05:32.197 22078 ERROR keystone Traceback (most recent call last):
+ X7 k- g( p3 T1 s9 N) Y$ P- D* i2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/bin/keystone-manage", line 10, in <module>$ j- A- q; s1 {8 |
2018-08-10 20:05:32.197 22078 ERROR keystone     sys.exit(main())4 E* \8 R! X% m% K' 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 main7 E# |- z, t; @/ f. k  @" u
2018-08-10 20:05:32.197 22078 ERROR keystone     cli.main(argv=sys.argv, config_files=config_files)( i$ x6 c% \: Q% G2 D, F3 t% 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! `% ^' f* Q& T8 ~. `8 ^
2018-08-10 20:05:32.197 22078 ERROR keystone     CONF.command.cmd_class.main()
# a; Y' z: [# D2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/keystone/cmd/cli.py", line 380, in main
% Y, F% ^( K) |- U+ V$ [3 V2018-08-10 20:05:32.197 22078 ERROR keystone     klass.do_bootstrap()
% h7 v: h! V% ^* |8 q$ 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, q+ L6 C3 [8 o$ N, M
2018-08-10 20:05:32.197 22078 ERROR keystone     domain=default_domain)$ |  H2 e; A/ q1 a/ S1 z  y
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% h: M' O  S' Q! U
2018-08-10 20:05:32.197 22078 ERROR keystone     __ret_val = __f(*args, **kwargs)( q" ^( x2 c* ^
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
$ L# \! Q6 b: X6 r0 ?, i! W2018-08-10 20:05:32.197 22078 ERROR keystone     domain_id, project_from_domain, initiator)
+ q: [$ \* L- d  Q7 D2018-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 H  G& ^8 S: f; u/ y2 a# O" [$ n2018-08-10 20:05:32.197 22078 ERROR keystone     __ret_val = __f(*args, **kwargs)
2 H( |. N3 ]( l) t2018-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  o  a+ I9 U: O$ P) e
2018-08-10 20:05:32.197 22078 ERROR keystone     ret = self.driver.create_project(project_id, project)9 `) \* e0 K; f# @- [
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 wrapper0 _5 b% J& i& k# \4 E  A
2018-08-10 20:05:32.197 22078 ERROR keystone     return method(*args, **kwargs)9 I8 M4 I0 R. M" {- ^
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" v. H1 h. `. S+ u5 ]! H5 H
2018-08-10 20:05:32.197 22078 ERROR keystone     return project_ref.to_dict()$ c) }9 Y6 B. j5 ?- ~8 X
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/contextlib.py", line 24, in __exit__
: @2 \# k- O+ M9 |) z2018-08-10 20:05:32.197 22078 ERROR keystone     self.gen.next()
/ Z6 k! l% e5 [0 E0 c2018-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
& w# w1 {3 O/ W& {4 u2018-08-10 20:05:32.197 22078 ERROR keystone     yield resource! x8 T! m* t! J  L/ W4 [
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/contextlib.py", line 24, in __exit__  G& P' a& A3 C$ C7 E, I! o
2018-08-10 20:05:32.197 22078 ERROR keystone     self.gen.next()
, Y7 c# z0 G" k( N$ N, u; |( `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 E# M. a2 S+ j+ [' r2018-08-10 20:05:32.197 22078 ERROR keystone     self.session.rollback()* W8 r3 J0 j6 M
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__6 ^# y6 R/ d$ M2 r3 B$ u  x9 E, z
2018-08-10 20:05:32.197 22078 ERROR keystone     self.force_reraise()
1 K% l8 U. c  F. w( i( i2018-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- e3 f% m  G/ D8 V$ W
2018-08-10 20:05:32.197 22078 ERROR keystone     six.reraise(self.type_, self.value, self.tb)
% C( [. ~8 W# S+ 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 _session
% b) V" b1 q' K( _& N$ j8 z2018-08-10 20:05:32.197 22078 ERROR keystone     self._end_session_transaction(self.session)
% v2 h1 M( d/ b) x2018-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
$ Z9 O9 I2 r% G2 r9 X. r8 f2018-08-10 20:05:32.197 22078 ERROR keystone     session.commit()" M. u. G6 u1 u* Z
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; x8 n/ n' i. j7 J
2018-08-10 20:05:32.197 22078 ERROR keystone     self.transaction.commit()
& w4 @, @6 I5 v2 J2 h6 C4 j4 c2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 461, in commit+ [% Y; Q& p, |9 W
2018-08-10 20:05:32.197 22078 ERROR keystone     self._prepare_impl()
3 ^, X3 p0 s* A# ?2018-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
4 B5 |' x! t4 Z  y! F, z2018-08-10 20:05:32.197 22078 ERROR keystone     self.session.flush()
+ e& M* i1 k" B# Q2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 2171, in flush7 W, y% N2 `' c/ x' P; v
2018-08-10 20:05:32.197 22078 ERROR keystone     self._flush(objects)& t- {$ e+ a; J9 Y" [
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/ m( q. F2 k& A
2018-08-10 20:05:32.197 22078 ERROR keystone     transaction.rollback(_capture_exception=True)
4 G- C. R( T% W& ~+ F  r2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 66, in __exit__
/ @6 J9 `% @# y2 `- }4 b& {% D2018-08-10 20:05:32.197 22078 ERROR keystone     compat.reraise(exc_type, exc_value, exc_tb)
- E6 u- v; ?$ {" z. m* y) S$ e2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 2255, in _flush* y& ~9 {1 `9 x. L; h( R" C% b
2018-08-10 20:05:32.197 22078 ERROR keystone     flush_context.execute()
: v9 Z" Z6 V* f4 d& D2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 389, in execute
+ k8 I/ n, B" U" N- i6 _+ s2018-08-10 20:05:32.197 22078 ERROR keystone     rec.execute(self)
4 f! w- Y* E1 f4 ]) t2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 548, in execute
8 `+ a0 `6 G* M3 C2018-08-10 20:05:32.197 22078 ERROR keystone     uow
6 M- N! B# h) S7 J$ m4 H$ n2018-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
5 T8 L+ X/ y) F, n' i2018-08-10 20:05:32.197 22078 ERROR keystone     mapper, table, insert)7 B! J, P. \2 g
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_statements2 X. s$ t! Q* X
2018-08-10 20:05:32.197 22078 ERROR keystone     execute(statement, multiparams)
# y9 M4 U) b; W5 H' M6 l+ ~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
0 R" p& J! c+ \4 c4 h2018-08-10 20:05:32.197 22078 ERROR keystone     return meth(self, multiparams, params)2 V/ `! y6 }' D4 L& b3 B; u7 k
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
5 ]% ?( T, v3 E2 d0 w1 V2018-08-10 20:05:32.197 22078 ERROR keystone     return connection._execute_clauseelement(self, multiparams, params)
# e; c$ v# c6 n: Q. N0 b8 l2018-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
; B1 L4 w3 I6 o' Y2018-08-10 20:05:32.197 22078 ERROR keystone     compiled_sql, distilled_params; k! X9 z% F8 H2 P7 R
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
$ u1 N6 R. q- p, ~- ?" {2018-08-10 20:05:32.197 22078 ERROR keystone     context)
3 M0 `" |. O1 s& Y: M2018-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
; L9 ?+ t4 m/ F1 V5 q) @  M2018-08-10 20:05:32.197 22078 ERROR keystone     util.raise_from_cause(newraise, exc_info)  U, p- T* w. T( ]+ p, k
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$ f, T: b. T; y$ `
2018-08-10 20:05:32.197 22078 ERROR keystone     reraise(type(exception), exception, tb=exc_tb, cause=cause)% R: X0 _: e  v( Q7 D9 [! L/ w
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; Y8 ~* g" t( ]; g9 g: {8 L' E
2018-08-10 20:05:32.197 22078 ERROR keystone     context)
* o" k! D0 }" j5 ~/ g" E# a, u( v2018-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
( f5 u* o( F2 `2018-08-10 20:05:32.197 22078 ERROR keystone     cursor.execute(statement, parameters)2 X" a+ C& _4 Y' J0 C
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 166, in execute. M+ E3 Y7 p7 V1 N+ @4 c! E
2018-08-10 20:05:32.197 22078 ERROR keystone     result = self._query(query)9 y- `+ t) _; R" |
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 322, in _query% Y% H# \% e2 T2 H. x* {+ [/ S* s% j. ^
2018-08-10 20:05:32.197 22078 ERROR keystone     conn.query(q)
! F3 T, {7 ~* _9 Z: d% a, s2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 856, in query
7 U) [' n6 w2 P1 ?* v( r' h( f2018-08-10 20:05:32.197 22078 ERROR keystone     self._affected_rows = self._read_query_result(unbuffered=unbuffered)5 U' M: c& p, G( `. u9 E' @* i
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% L( ~  H, i  n
2018-08-10 20:05:32.197 22078 ERROR keystone     result.read()
* n7 }& d5 U; L3 A' c2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1340, in read' ~+ v; h  P: C( a6 ]
2018-08-10 20:05:32.197 22078 ERROR keystone     first_packet = self.connection._read_packet()
$ ]; x# w* K; }2 H, m2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1014, in _read_packet* l" h- ~7 w8 o& y  ~
2018-08-10 20:05:32.197 22078 ERROR keystone     packet.check_error()+ `% M% O  N" }( s' r' V' H
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( D  q- O) ]9 |& I% O: u( s  V6 |& x
2018-08-10 20:05:32.197 22078 ERROR keystone     err.raise_mysql_exception(self._data)6 w; G+ ]8 U! t
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, n/ [. b8 R& s$ i
2018-08-10 20:05:32.197 22078 ERROR keystone     raise errorclass(errno, errval)
+ K6 y3 X7 d0 }# z7 B! M: s5 X2018-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'}]
, v8 }! k, p3 l0 [9 w$ o0 E2018-08-10 20:05:32.197 22078 ERROR keystone % P$ H, f+ |/ b% {' {, ]- V. H
回复

举报

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 01:27 , Processed in 0.026036 second(s), 22 queries .

Powered by Discuz! X5.0

© 2001-2026 Discuz! Team.

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