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

易陆发现互联网技术论坛

 找回密码
 开始注册
易陆发现互联网技术论坛»首页 › 云计算开源区 › OpenStack问题汇总 › keystone报错CRITICAL keystone [-] Unhandled error: P ...
查看: 5926|回复: 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 P  x0 n8 r5 ]% b% l* Z2018-08-10 20:05:32.197 22078 ERROR keystone Traceback (most recent call last):2 ^2 K$ j, L7 D1 M; a
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/bin/keystone-manage", line 10, in <module>
/ I; d) n$ U0 s- `, e2018-08-10 20:05:32.197 22078 ERROR keystone     sys.exit(main())
# ]( g+ O" D' `, ~, ^% n$ a2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/keystone/cmd/manage.py", line 44, in main
5 o' ]( [* g5 r$ a2018-08-10 20:05:32.197 22078 ERROR keystone     cli.main(argv=sys.argv, config_files=config_files); \, r8 V. r  G) F, D6 v. B2 O. a3 y
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/ k6 D$ h3 _" D3 d6 ^! m' `  l
2018-08-10 20:05:32.197 22078 ERROR keystone     CONF.command.cmd_class.main()  P: c0 j# w' L0 P6 S# @) R- N4 R- M
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  V3 z0 M% b1 j/ e' n1 Q/ a
2018-08-10 20:05:32.197 22078 ERROR keystone     klass.do_bootstrap(). b& h* y8 p: v& b  L: F
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
+ d- D1 L2 e% Z+ O& q2 m7 D2018-08-10 20:05:32.197 22078 ERROR keystone     domain=default_domain)
3 n, v& q7 y7 K( C; b2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/keystone/common/manager.py", line 110, in wrapped
" _$ z* ]: }8 W$ _7 Z& U* s2018-08-10 20:05:32.197 22078 ERROR keystone     __ret_val = __f(*args, **kwargs)
9 Z: w  }6 d  [( e2018-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 g' b' t0 E2 i9 ?/ E8 V4 M# W( f) L2018-08-10 20:05:32.197 22078 ERROR keystone     domain_id, project_from_domain, initiator)
& ]9 n2 A7 S/ d! N2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/keystone/common/manager.py", line 110, in wrapped
, w2 q% p) c0 g7 O2018-08-10 20:05:32.197 22078 ERROR keystone     __ret_val = __f(*args, **kwargs)
1 |# O( U  Y, l. s. C, q; n3 ^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& Q4 a4 [4 J" O5 \. n6 {
2018-08-10 20:05:32.197 22078 ERROR keystone     ret = self.driver.create_project(project_id, project)
1 S2 t0 C$ p7 g9 k; z2018-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
7 Z  k; }( g8 {5 y5 r2018-08-10 20:05:32.197 22078 ERROR keystone     return method(*args, **kwargs)7 I4 D' V* W# s) C% O& W
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: o8 m2 M3 }' N
2018-08-10 20:05:32.197 22078 ERROR keystone     return project_ref.to_dict()/ l8 w9 L: k- e
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/contextlib.py", line 24, in __exit__& z- ]. B. ^2 S: e
2018-08-10 20:05:32.197 22078 ERROR keystone     self.gen.next()$ f) o5 C( k4 P* U9 ?7 E# ]
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+ ^: ?. o; L- f4 j- k
2018-08-10 20:05:32.197 22078 ERROR keystone     yield resource! R+ X; [, `. z& h% _: P5 p
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/contextlib.py", line 24, in __exit__
4 {" h+ R7 [3 y- F0 e& F/ Y/ y2018-08-10 20:05:32.197 22078 ERROR keystone     self.gen.next()9 H0 K$ `+ C" r: Q" t4 z1 @
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 _session8 S, ]  l1 m0 t! `; f
2018-08-10 20:05:32.197 22078 ERROR keystone     self.session.rollback()4 g0 ]) k( M$ S5 l. X' i9 `
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__0 |% ]# _6 o3 a7 K! a
2018-08-10 20:05:32.197 22078 ERROR keystone     self.force_reraise()
7 C- @$ s( `' M& H! j3 E0 f3 s2018-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
) T1 j/ g. L1 l7 i; I2018-08-10 20:05:32.197 22078 ERROR keystone     six.reraise(self.type_, self.value, self.tb)  }3 Q/ Z, m3 s1 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
% X2 _5 H0 U9 H3 t& Z2018-08-10 20:05:32.197 22078 ERROR keystone     self._end_session_transaction(self.session)
1 V" ^; ]. y$ {. R0 @: C2018-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
& m2 X; U1 E0 [2018-08-10 20:05:32.197 22078 ERROR keystone     session.commit()' @$ P' a; z/ i  G$ w3 ]0 B
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
; f5 `1 W3 J- q/ Z2018-08-10 20:05:32.197 22078 ERROR keystone     self.transaction.commit()
" o" X, f! {. }5 ]+ [( a2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 461, in commit
( }8 v. r) N6 x- h$ I; S- ^2018-08-10 20:05:32.197 22078 ERROR keystone     self._prepare_impl()
# Y! Z9 C0 y  i8 O+ L( ?( 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; m5 \3 _9 v  B
2018-08-10 20:05:32.197 22078 ERROR keystone     self.session.flush()
8 ]' O% X+ |! T" G5 e: x2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 2171, in flush  f" W/ k7 d% j" j! D
2018-08-10 20:05:32.197 22078 ERROR keystone     self._flush(objects)
( u( b# k* i3 ^; s, V2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 2291, in _flush/ d9 }) A- R7 M; G2 `, f% m# n" G
2018-08-10 20:05:32.197 22078 ERROR keystone     transaction.rollback(_capture_exception=True)
* U4 N1 N& A& X7 v& V& g2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 66, in __exit__/ Z) N5 k* b8 [4 b% _6 Y
2018-08-10 20:05:32.197 22078 ERROR keystone     compat.reraise(exc_type, exc_value, exc_tb); f2 a% H8 U# c( d2 O
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
) Y& q& b. Z& F% p3 r( a2018-08-10 20:05:32.197 22078 ERROR keystone     flush_context.execute()& o% X  U& m& b: m7 e  n
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 389, in execute5 D) w/ Q, l7 G9 [. @& U8 u; l* P
2018-08-10 20:05:32.197 22078 ERROR keystone     rec.execute(self)/ Y: c8 ~, e  y; z5 E
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
: z# [8 ?! \! J  X6 I' z0 ~# a2018-08-10 20:05:32.197 22078 ERROR keystone     uow0 Z$ f! M; S' k/ d$ z) g& o9 M8 z
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( y8 B3 K' |7 l# x' q3 F
2018-08-10 20:05:32.197 22078 ERROR keystone     mapper, table, insert)
) K1 V  h. @1 W" w, C( E3 J& [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! D6 o# Q; j( J  r1 f! \5 @8 J
2018-08-10 20:05:32.197 22078 ERROR keystone     execute(statement, multiparams)
+ I) l$ L8 @8 V% V0 o2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 945, in execute
" q/ N; ?9 p7 V/ i9 N- r6 Z* C% @* d' m2018-08-10 20:05:32.197 22078 ERROR keystone     return meth(self, multiparams, params)- u# |2 O+ v' l/ Z4 _: d
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
, t7 h. w+ h, u/ ?2018-08-10 20:05:32.197 22078 ERROR keystone     return connection._execute_clauseelement(self, multiparams, params)
$ \: F0 V) L- H. ~. O+ C2018-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- t3 F* U$ E/ _" C/ x0 R2018-08-10 20:05:32.197 22078 ERROR keystone     compiled_sql, distilled_params
# g4 i. R& X' v* O3 n& I2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1189, in _execute_context3 }! o. t! H5 u* l/ d0 X
2018-08-10 20:05:32.197 22078 ERROR keystone     context)( k! n+ q, H* l( v# H
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# m, K* b6 D1 Q6 s
2018-08-10 20:05:32.197 22078 ERROR keystone     util.raise_from_cause(newraise, exc_info)
! F6 I0 o  I5 w" |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_cause9 H, H# w& s  _
2018-08-10 20:05:32.197 22078 ERROR keystone     reraise(type(exception), exception, tb=exc_tb, cause=cause)
; y! P, W8 F/ \( {+ [/ Q8 r- {5 A2018-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
( h- M) S7 c1 Q9 l& G$ V. f& Q% t9 [2018-08-10 20:05:32.197 22078 ERROR keystone     context)
3 D# g4 ]$ d* f4 o7 e8 Y  M0 N2018-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! ^+ D! `8 N0 t6 e6 _$ U( w4 t
2018-08-10 20:05:32.197 22078 ERROR keystone     cursor.execute(statement, parameters)
2 |& q0 k8 H' M& U2 k# `. p! Z* C3 D2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 166, in execute
& x7 `5 _" Q' ^8 n2018-08-10 20:05:32.197 22078 ERROR keystone     result = self._query(query)
, J- A6 M; G8 V. x2 C/ \2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 322, in _query
5 C' Q5 E4 L, ~" h0 h2018-08-10 20:05:32.197 22078 ERROR keystone     conn.query(q)
. n" X: Z# x- h0 L; I7 q+ H' c. F  h2 w2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 856, in query
, K/ |8 P" w* h+ o, e2018-08-10 20:05:32.197 22078 ERROR keystone     self._affected_rows = self._read_query_result(unbuffered=unbuffered)/ T2 |# ^9 |* |0 M
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
: h0 n& ^7 d1 w: l: A2018-08-10 20:05:32.197 22078 ERROR keystone     result.read()9 u9 O0 B- ~. {+ q3 d: L& c
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1340, in read0 V. v; {6 i8 ]% ^4 x
2018-08-10 20:05:32.197 22078 ERROR keystone     first_packet = self.connection._read_packet()
- B9 W! R: \, x; l! X2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1014, in _read_packet# m4 ]& b. Z: T; a6 s# S
2018-08-10 20:05:32.197 22078 ERROR keystone     packet.check_error(); I% _1 d/ D3 d) \% @9 f
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; C# }. Q4 S; h( _  o
2018-08-10 20:05:32.197 22078 ERROR keystone     err.raise_mysql_exception(self._data)
0 Z" T& f- u4 d4 n" K" O2018-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
' a/ i/ A6 C0 [  j4 b2018-08-10 20:05:32.197 22078 ERROR keystone     raise errorclass(errno, errval)3 u4 w. u* P$ E( f, G) p& @! J
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'}]
: I+ M6 Q0 e6 q, f, K2018-08-10 20:05:32.197 22078 ERROR keystone ! R* p) K) L* h0 [( t" c
回复

使用道具 举报

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:19 , Processed in 0.069665 second(s), 22 queries .

Powered by Discuz! X3.4 Licensed

© 2012-2025 Discuz! Team.

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