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

易陆发现互联网技术论坛

 找回密码
 开始注册
易陆发现互联网技术论坛»首页 › 云计算开源区 › OpenStack问题汇总 › keystone报错CRITICAL keystone [-] Unhandled error: P ...
查看: 5931|回复: 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'}]1 k; @+ \' S9 I( H
2018-08-10 20:05:32.197 22078 ERROR keystone Traceback (most recent call last):  d2 A; ~1 K. q6 L* o# ]
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/bin/keystone-manage", line 10, in <module>4 S1 ?+ O: J- t( i
2018-08-10 20:05:32.197 22078 ERROR keystone     sys.exit(main())
6 e& A! |# z' `6 o& _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
% o$ J1 m# {6 u2018-08-10 20:05:32.197 22078 ERROR keystone     cli.main(argv=sys.argv, config_files=config_files)! u1 s1 Z- P+ ?: |, p* t2 u
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' C$ {8 t# n. e% ^) V
2018-08-10 20:05:32.197 22078 ERROR keystone     CONF.command.cmd_class.main()6 J" Q# f  l& b8 s+ L9 A
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( G5 T4 l9 b% t( \
2018-08-10 20:05:32.197 22078 ERROR keystone     klass.do_bootstrap()
) h- @  p  Y' H0 k; u. k, Q  c- L2018-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# \+ ~* B/ R* o, P$ _
2018-08-10 20:05:32.197 22078 ERROR keystone     domain=default_domain)# U% A! W! w+ D8 t
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) s) P' W' u0 g0 t9 {4 F
2018-08-10 20:05:32.197 22078 ERROR keystone     __ret_val = __f(*args, **kwargs); ?+ j$ e4 G" n% 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_domain4 k2 {* J8 f/ X. j! B/ I
2018-08-10 20:05:32.197 22078 ERROR keystone     domain_id, project_from_domain, initiator)- E0 R! a1 u" O$ j' 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
9 p# K8 Z5 K/ C3 k: N& t2018-08-10 20:05:32.197 22078 ERROR keystone     __ret_val = __f(*args, **kwargs)/ ^( u. j% b, H8 b' x4 ^
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
; F) Y$ n- p/ x$ i: m8 V2018-08-10 20:05:32.197 22078 ERROR keystone     ret = self.driver.create_project(project_id, project)
/ s8 c/ j0 J6 l2018-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
# {9 N& e- j& O$ A' x4 A, X2 k2018-08-10 20:05:32.197 22078 ERROR keystone     return method(*args, **kwargs)
  y. z) G: @; x3 t$ {2 e9 o" _: m2018-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
+ U& g; E. I2 c2018-08-10 20:05:32.197 22078 ERROR keystone     return project_ref.to_dict()/ F" T7 ^8 W( ?* e
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/contextlib.py", line 24, in __exit__6 w4 K/ E9 q( q4 g
2018-08-10 20:05:32.197 22078 ERROR keystone     self.gen.next()# `% G2 [7 c3 |+ j
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_scope3 \* c& C5 q9 U" Z) e7 X( B$ P
2018-08-10 20:05:32.197 22078 ERROR keystone     yield resource+ j0 ~( A" F4 z( {% s$ A% |
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/contextlib.py", line 24, in __exit__: J/ @% M$ T" `2 C6 C
2018-08-10 20:05:32.197 22078 ERROR keystone     self.gen.next()
' ]% I! ~# i" I" T6 t" q; B3 F0 D2018-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
" a; @7 Z& r% r7 u5 K) e2018-08-10 20:05:32.197 22078 ERROR keystone     self.session.rollback()3 W2 `/ I" C7 B: s" }% |! N/ H1 [
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__; g6 q& s  d! p, O5 \9 _# C
2018-08-10 20:05:32.197 22078 ERROR keystone     self.force_reraise()
1 n9 ?7 H$ X6 A  \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/ h0 z. |+ u0 ~  d' \, @# @
2018-08-10 20:05:32.197 22078 ERROR keystone     six.reraise(self.type_, self.value, self.tb)
2 Q7 @" C* P5 g2018-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
1 [" s$ P# t0 V- w2018-08-10 20:05:32.197 22078 ERROR keystone     self._end_session_transaction(self.session)! m2 W" k7 G# R
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
8 q8 v" b) _, K- J4 }2018-08-10 20:05:32.197 22078 ERROR keystone     session.commit()7 k7 T% e' g$ R' @' 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 commit1 `8 s5 ]% P( \8 X+ d- v0 b
2018-08-10 20:05:32.197 22078 ERROR keystone     self.transaction.commit()3 W9 H( P; K/ }% r. b4 }5 l
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 461, in commit2 N) d; p/ p  @$ s3 ?/ d0 S8 [3 }
2018-08-10 20:05:32.197 22078 ERROR keystone     self._prepare_impl()
+ [. ^1 ]5 M0 \1 A* 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_impl6 U4 X8 J7 L" u% o
2018-08-10 20:05:32.197 22078 ERROR keystone     self.session.flush()
: R8 x8 h1 M8 p( V2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 2171, in flush0 d9 a0 K8 [8 F, s. U9 y
2018-08-10 20:05:32.197 22078 ERROR keystone     self._flush(objects)% u; w7 b9 |% ?! c
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. ^+ r% w) H5 v+ L
2018-08-10 20:05:32.197 22078 ERROR keystone     transaction.rollback(_capture_exception=True)
, r6 t2 j/ ?/ Z# x* C) T2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 66, in __exit__# E. x, W0 T* x( g- H
2018-08-10 20:05:32.197 22078 ERROR keystone     compat.reraise(exc_type, exc_value, exc_tb)* q5 R0 Y0 V% S) j8 K( R0 }
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
" Q( [' g2 K2 W. n) z% L2018-08-10 20:05:32.197 22078 ERROR keystone     flush_context.execute()5 J; M$ _) P, ], M2 a: U; E- i
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
$ Q! N8 |' y+ J8 s- i+ P  ^1 @2 c2018-08-10 20:05:32.197 22078 ERROR keystone     rec.execute(self)
, n; @$ b, ~5 a8 j2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 548, in execute, u- o. L" ~$ v) S
2018-08-10 20:05:32.197 22078 ERROR keystone     uow
" m" d9 u* X0 v5 h: D2018-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" T) k# B0 d2 V0 H/ Z- C
2018-08-10 20:05:32.197 22078 ERROR keystone     mapper, table, insert)5 F6 s* n- Q- w1 Q3 h7 t4 _
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
3 N5 e" S5 }; ?* N2018-08-10 20:05:32.197 22078 ERROR keystone     execute(statement, multiparams)
9 W, n5 I$ G) r2 Q2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 945, in execute' f# h  |; ?9 `9 L$ F3 z$ S9 B
2018-08-10 20:05:32.197 22078 ERROR keystone     return meth(self, multiparams, params)  B1 p% n, w% ?! }7 V7 D( 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_connection2 w1 S0 Q) l# b7 M" d4 q
2018-08-10 20:05:32.197 22078 ERROR keystone     return connection._execute_clauseelement(self, multiparams, params)0 L4 Q2 u! t8 t* v  `
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
9 C& n$ x# q# G! `! i2018-08-10 20:05:32.197 22078 ERROR keystone     compiled_sql, distilled_params
1 f) G( J: t8 R& o: R$ n2018-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
4 {- ?+ d* U$ K2018-08-10 20:05:32.197 22078 ERROR keystone     context)
) w5 v+ k. |* C2018-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
8 u( X8 t3 e2 I2018-08-10 20:05:32.197 22078 ERROR keystone     util.raise_from_cause(newraise, exc_info)9 f( t' z, j* T) t) H
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_cause4 R% I2 x* c5 ]* H! x+ @& B, g
2018-08-10 20:05:32.197 22078 ERROR keystone     reraise(type(exception), exception, tb=exc_tb, cause=cause); r3 B8 I! g4 |. u0 ?* o
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
$ W; {1 F& q, x( m# `2018-08-10 20:05:32.197 22078 ERROR keystone     context)
4 a. ]- d6 c! S7 ^3 Q8 W! d2 t8 m2018-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
$ ?  z! r+ i" N6 t, |2018-08-10 20:05:32.197 22078 ERROR keystone     cursor.execute(statement, parameters)
. w# z6 |, R, `) g& \+ q6 B2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 166, in execute
4 F) v" q5 q! D- ?: N2018-08-10 20:05:32.197 22078 ERROR keystone     result = self._query(query)
9 c, z/ f1 }1 U. u6 \. w9 Y2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 322, in _query3 L1 B8 E/ ~' B& H4 E( n# R
2018-08-10 20:05:32.197 22078 ERROR keystone     conn.query(q)
$ g  f8 W! w( k  M) J5 U# l- D2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 856, in query) b+ G# |+ ?) r( R1 _3 V! t
2018-08-10 20:05:32.197 22078 ERROR keystone     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
0 Y9 @2 N: Q9 y2018-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
, b. U' ?' t. i; q7 i2018-08-10 20:05:32.197 22078 ERROR keystone     result.read(); F# o) e* j3 T( Q5 U
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1340, in read# ?2 \/ k5 N8 Y8 W; E1 q
2018-08-10 20:05:32.197 22078 ERROR keystone     first_packet = self.connection._read_packet()
/ U! Z# w+ T3 k; ^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
2 a% Y2 @" [1 }4 n" ~" p+ `+ P, j8 f2018-08-10 20:05:32.197 22078 ERROR keystone     packet.check_error(); J7 C3 X$ ]. c& 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
' V% H: ?. ?/ O2018-08-10 20:05:32.197 22078 ERROR keystone     err.raise_mysql_exception(self._data)
; X# L1 {, R! w# p2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception1 y9 g6 J( D, @/ {" c3 P
2018-08-10 20:05:32.197 22078 ERROR keystone     raise errorclass(errno, errval)
4 Y( H. X$ O3 w4 l: }0 t2018-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'}]& _( X2 e- W1 t- i3 @: b, t3 ~
2018-08-10 20:05:32.197 22078 ERROR keystone
% |  v3 E  T( F! ]3 X' S
回复

使用道具 举报

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-8 15:21 , Processed in 0.045611 second(s), 22 queries .

Powered by Discuz! X3.4 Licensed

© 2012-2025 Discuz! Team.

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