找回密码
 注册
查看: 5929|回复: 2

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

[复制链接]

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'}]
: N8 Y! z) _7 R+ ]! y# W2018-08-10 20:05:32.197 22078 ERROR keystone Traceback (most recent call last):
% B* k7 R" T9 c, b8 [# b2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/bin/keystone-manage", line 10, in <module>( a; g) x, X* e8 }  \: H
2018-08-10 20:05:32.197 22078 ERROR keystone     sys.exit(main())
, b0 C! N0 r3 x, @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- e( M% T9 }( {: v7 ]
2018-08-10 20:05:32.197 22078 ERROR keystone     cli.main(argv=sys.argv, config_files=config_files), A8 D; J; u3 M4 q) \$ [/ ?
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! _; z' \  p' R) L8 y$ ~  Z2 k
2018-08-10 20:05:32.197 22078 ERROR keystone     CONF.command.cmd_class.main()
, [4 v$ m3 N: P+ x- M7 L: J4 N; `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
" B- p  I# H& Z! }. h" A/ v1 u- N2018-08-10 20:05:32.197 22078 ERROR keystone     klass.do_bootstrap()
4 v0 g# o( B3 i: R0 R9 l8 A2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/keystone/cmd/cli.py", line 190, in do_bootstrap6 C7 |2 M  b7 k" H5 G6 B8 Y1 }
2018-08-10 20:05:32.197 22078 ERROR keystone     domain=default_domain)6 M) S( J9 {1 s! Q( }/ }, V
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
, ?; F9 w; }/ p( T0 n4 Z2018-08-10 20:05:32.197 22078 ERROR keystone     __ret_val = __f(*args, **kwargs)1 O$ V, ^0 v6 Q
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
7 g: {! @8 w: \0 k2018-08-10 20:05:32.197 22078 ERROR keystone     domain_id, project_from_domain, initiator)
+ D$ M6 x) L9 i2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/keystone/common/manager.py", line 110, in wrapped
! d- {) q1 v9 D0 ^1 {2 _8 H2018-08-10 20:05:32.197 22078 ERROR keystone     __ret_val = __f(*args, **kwargs)& Q1 l* {/ ~; C) Z1 i; q5 _5 u
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
% _2 f5 T) \( C2018-08-10 20:05:32.197 22078 ERROR keystone     ret = self.driver.create_project(project_id, project)9 I& O5 i+ n' O. Q/ M
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 X* W6 L2 o* x
2018-08-10 20:05:32.197 22078 ERROR keystone     return method(*args, **kwargs)
. a# L3 _, T# u0 l0 x9 o, Z, R2018-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_project2 P# e% Z& \5 o, X
2018-08-10 20:05:32.197 22078 ERROR keystone     return project_ref.to_dict()3 R2 e8 w2 I( \
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/contextlib.py", line 24, in __exit__
4 a5 a# U0 e  E6 W. I: R2018-08-10 20:05:32.197 22078 ERROR keystone     self.gen.next()
4 U( C% |3 g4 H$ Q6 h2018-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
8 l. k9 ]) b( A" X2018-08-10 20:05:32.197 22078 ERROR keystone     yield resource
8 q3 n4 \2 t4 D1 N1 }4 @/ @  ~2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/contextlib.py", line 24, in __exit__
  m1 V0 D# L2 R/ q2018-08-10 20:05:32.197 22078 ERROR keystone     self.gen.next()
0 q" j6 s0 e0 a: h. r2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 641, in _session0 @; k. r; j5 ^$ d- b
2018-08-10 20:05:32.197 22078 ERROR keystone     self.session.rollback()- p0 }: c+ s! o: O* K' ?
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__4 d5 u1 `& t- e5 G/ G" {
2018-08-10 20:05:32.197 22078 ERROR keystone     self.force_reraise()
+ d8 j- g) h: Y+ h2018-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
* q+ w' X+ o& U3 m+ J1 m2018-08-10 20:05:32.197 22078 ERROR keystone     six.reraise(self.type_, self.value, self.tb)0 n; x" j7 G( i+ R& {
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: A* y( i  R6 d5 d* S; K) {! B
2018-08-10 20:05:32.197 22078 ERROR keystone     self._end_session_transaction(self.session)
5 f( C4 A" r: [6 j. s7 |: k2018-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 k! n7 l2 D8 P3 u8 h1 r2018-08-10 20:05:32.197 22078 ERROR keystone     session.commit()9 C& y% c7 @8 D
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
6 m% i0 n3 n% K4 [9 ^4 h8 l2 a2018-08-10 20:05:32.197 22078 ERROR keystone     self.transaction.commit()
7 ~) R0 I( J; G1 x3 p' G$ e2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 461, in commit+ Z/ l" S/ k. `7 }1 R
2018-08-10 20:05:32.197 22078 ERROR keystone     self._prepare_impl()
2 W8 k8 V) [8 P2018-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! s3 p" r% h: A8 u& T/ I  C( \7 g5 r
2018-08-10 20:05:32.197 22078 ERROR keystone     self.session.flush()
. g6 t3 W" o8 r2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 2171, in flush
6 {/ ^+ |+ B. r& @2018-08-10 20:05:32.197 22078 ERROR keystone     self._flush(objects)
/ X4 E" {$ q: v# c9 j2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 2291, in _flush
* z3 m# X7 Z  B+ X) r2018-08-10 20:05:32.197 22078 ERROR keystone     transaction.rollback(_capture_exception=True)3 v) {  W$ g1 @; _# F, n
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__- a# K5 t$ ]; i! X8 R1 M
2018-08-10 20:05:32.197 22078 ERROR keystone     compat.reraise(exc_type, exc_value, exc_tb)5 N9 M; {' c6 P  V
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
3 Y: N6 f# M4 H% m; F2018-08-10 20:05:32.197 22078 ERROR keystone     flush_context.execute()9 C' P3 P3 K" A0 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) N$ d" l  r( i
2018-08-10 20:05:32.197 22078 ERROR keystone     rec.execute(self)/ I/ ]" I- \6 ], {" A3 N  `% V- k
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
% M" d) r1 d8 f2018-08-10 20:05:32.197 22078 ERROR keystone     uow
) I# ]: j" E% j7 Q2018-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
4 n: w5 e3 o) N9 Y2018-08-10 20:05:32.197 22078 ERROR keystone     mapper, table, insert)2 n1 k7 D1 N( ]& a1 j1 f4 i4 }
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
: H4 U* i$ [7 o8 A2018-08-10 20:05:32.197 22078 ERROR keystone     execute(statement, multiparams)) C$ l+ N$ c& A0 m! [& S
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
* ]9 Z: X- p2 [& `2018-08-10 20:05:32.197 22078 ERROR keystone     return meth(self, multiparams, params)
# p' G( h4 |$ r  K2 L8 V7 l% m2018-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
6 R) y$ `" f6 t0 o0 ^5 G' x2018-08-10 20:05:32.197 22078 ERROR keystone     return connection._execute_clauseelement(self, multiparams, params)
) {8 W8 C, B& K; e' @- E2018-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
, v, c# X, n% F# @5 M5 |2018-08-10 20:05:32.197 22078 ERROR keystone     compiled_sql, distilled_params
5 R4 E# F: h5 H) E2018-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 s8 a% z: T! o' v8 I) f# _7 L
2018-08-10 20:05:32.197 22078 ERROR keystone     context)9 m, V! V$ l; n: m% Q
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  N* R5 Y) F: Y, g; }
2018-08-10 20:05:32.197 22078 ERROR keystone     util.raise_from_cause(newraise, exc_info)
! q. w7 V# a) f& f2018-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
6 C* b) B& Q4 o+ y2018-08-10 20:05:32.197 22078 ERROR keystone     reraise(type(exception), exception, tb=exc_tb, cause=cause)
  u* u' r% ]+ q# h& C6 _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
* _6 b' s1 {9 _6 }" E& R) t/ U2018-08-10 20:05:32.197 22078 ERROR keystone     context)8 f. |" l/ j, O4 `' n
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
( S" c  U: w8 D1 ]2018-08-10 20:05:32.197 22078 ERROR keystone     cursor.execute(statement, parameters)3 L0 [: C, @) q3 l& W) C( L+ T) @
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 166, in execute
$ ~& z# m( M0 H5 Q/ ?  K: y2018-08-10 20:05:32.197 22078 ERROR keystone     result = self._query(query)
  l6 j, C: c+ ~. H2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 322, in _query/ g: ?% n) l+ S- g- s7 O5 ?
2018-08-10 20:05:32.197 22078 ERROR keystone     conn.query(q)* V& ^! G! |: z% T7 ^
2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 856, in query
9 h7 L. ~" |! Q  B2018-08-10 20:05:32.197 22078 ERROR keystone     self._affected_rows = self._read_query_result(unbuffered=unbuffered)! W+ k- l7 n4 r# X! L1 E
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* H% F9 h* i" Q7 [
2018-08-10 20:05:32.197 22078 ERROR keystone     result.read()
0 J8 z1 N) H- ]+ [2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1340, in read
- P# i; q' K# F2018-08-10 20:05:32.197 22078 ERROR keystone     first_packet = self.connection._read_packet()
& P/ h' ^. @# F* q2 R2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1014, in _read_packet. k( G  U7 @1 S6 J9 e; G( [7 l2 n
2018-08-10 20:05:32.197 22078 ERROR keystone     packet.check_error()
  I, V5 K6 R' S2 Z' B! W2 n2018-08-10 20:05:32.197 22078 ERROR keystone   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 393, in check_error* b7 I& {) S; |4 Z
2018-08-10 20:05:32.197 22078 ERROR keystone     err.raise_mysql_exception(self._data)" a; T' a% H2 m3 r. V/ P
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
/ h/ t2 p% E' e2018-08-10 20:05:32.197 22078 ERROR keystone     raise errorclass(errno, errval)8 G" J, A) o6 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'}]
$ z) }1 A2 j7 I# d' l1 y, j; x2018-08-10 20:05:32.197 22078 ERROR keystone
- N' N' q7 _1 T5 s: R

1

主题

0

回帖

12

积分

管理员

积分
12
QQ
 楼主| 发表于 2018-8-10 21:29:28 | 显示全部楼层
原因就是数据库出现脑裂,导致数据库不一致导致的。很奇怪的现象,需要好好检查配置文件。

1

主题

0

回帖

12

积分

管理员

积分
12
QQ
 楼主| 发表于 2018-8-29 11:15:52 | 显示全部楼层
解决问题,可以不用纠结这个集群问题,可以先暂时停止掉数据库galera集群服务,只启动一个节点的数据库服务,既可以解决这个问题。
您需要登录后才可以回帖 登录 | 注册

本版积分规则

返回首页|Archiver|手机版|小黑屋|易陆发现技术论坛 ( 蜀ICP备2026014127号-1 )

GMT+8, 2026-6-12 02:23 , Processed in 0.022197 second(s), 22 queries .

Powered by Discuz! X5.0

© 2001-2026 Discuz! Team.

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