cinder_api报错

最新推荐文章于 2023-04-25 19:55:19 发布

原创

最新推荐文章于 2023-04-25 19:55:19 发布 · 1.1k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#openstack

在OpenStack Queens版本中安装Cinder组件时遇到数据库连接断开的问题，具体表现为cinder_api服务在尝试读取数据库时丢失了与MySQL服务器的连接。错误日志显示GSSAPI插件初始化失败，原因是未找到默认的principal且keytab文件不存在或为空。通过注释掉my.cnf.d/auth_gssapi.cnf中的auth_gssapi.so插件加载行并重启服务，问题得以解决。

OpenStack queens版本安装cinder后报错

1.cinder_api报错日志内容

2019-07-29 23:09:27.663 28685 INFO cinder.api.openstack.wsgi [req-d910b210-0bd0-4056-a5d2-3945937c4091 43c0ed7adb8d43deb278b93b39af8a70 cf080665b3e54c8b8456ee1b7f66cf9c - 20bec2a0f92c41aa8c74194cc7203ca0 20bec2a0f92c41aa8c74194cc7203ca0] GET http://controller:8776/v2/cf080665b3e54c8b8456ee1b7f66cf9c/os-volume-transfer/detail?bootable=1&status=available
2019-07-29 23:09:27.667 28685 ERROR oslo_db.sqlalchemy.engines [req-d910b210-0bd0-4056-a5d2-3945937c4091 43c0ed7adb8d43deb278b93b39af8a70 cf080665b3e54c8b8456ee1b7f66cf9c - 20bec2a0f92c41aa8c74194cc7203ca0 20bec2a0f92c41aa8c74194cc7203ca0] Database connection was found disconnected; reconnecting: DBConnectionError: (pymysql.err.OperationalError) (2013, 'Lost connection to MySQL server during query') [SQL: u'SELECT 1'] (Background on this error at: http://sqlalche.me/e/e3q8)
2019-07-29 23:09:27.667 28685 ERROR oslo_db.sqlalchemy.engines Traceback (most recent call last):
2019-07-29 23:09:27.667 28685 ERROR oslo_db.sqlalchemy.engines   File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/engines.py", line 73, in _connect_ping_listener
2019-07-29 23:09:27.667 28685 ERROR oslo_db.sqlalchemy.engines     connection.scalar(select([1]))
2019-07-29 23:09:27.667 28685 ERROR oslo_db.sqlalchemy.engines   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 880, in scalar
2019-07-29 23:09:27.667 28685 ERROR oslo_db.sqlalchemy.engines     return self.execute(object, *multiparams, **params).scalar()
2019-07-29 23:09:27.667 28685 ERROR oslo_db.sqlalchemy.engines   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 948, in execute
2019-07-29 23:09:27.667 28685 ERROR oslo_db.sqlalchemy.engines     return meth(self, multiparams, params)
2019-07-29 23:09:27.667 28685 ERROR oslo_db.sqlalchemy.engines   File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection
2019-07-29 23:09:27.667 28685 ERROR oslo_db.sqlalchemy.engines     return connection._execute_clauseelement(self, multiparams, params)
2019-07-29 23:09:27.667 28685 ERROR oslo_db.sqlalchemy.engines   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement
2019-07-29 23:09:27.667 28685 ERROR oslo_db.sqlalchemy.engines     compiled_sql, distilled_params
2019-07-29 23:09:27.667 28685 ERROR oslo_db.sqlalchemy.engines   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
2019-07-29 23:09:27.667 28685 ERROR oslo_db.sqlalchemy.engines     context)
2019-07-29 23:09:27.667 28685 ERROR oslo_db.sqlalchemy.engines   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1409, in _handle_dbapi_exception
2019-07-29 23:09:27.667 28685 ERROR oslo_db.sqlalchemy.engines     util.raise_from_cause(newraise, exc_info)
2019-07-29 23:09:27.667 28685 ERROR oslo_db.sqlalchemy.engines   File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
2019-07-29 23:09:27.667 28685 ERROR oslo_db.sqlalchemy.engines     reraise(type(exception), exception, tb=exc_tb, caus