[Openstack] Cinder (OperationalError) unable to open database file
Stephen Davies
steve at base-it.co.uk
Fri Mar 13 17:28:21 UTC 2015
Hello all,
Can anyone offer any advice on this problem I am experiencing with Juno.
When I create a cinder block it results in an error status. I have tried
to trace the problem and it seems that Cinder cannot connect to the DB.
When I run 'cinder-manage service list' the following connection error
is shown. I have verified that I can connect to the DB using the cinder
user account. My cinder config is at the bottom of the mail. Many thanks
in advice for any pointers.
cinder-manage service list
2015-03-13 17:15:16.396 8616 CRITICAL cinder
[req-fc62f6e9-9f15-4758-bb4b-ef8edfbc6546 - - - - -] OperationalError:
(OperationalError) unable to open database file None None
2015-03-13 17:15:16.396 8616 TRACE cinder Traceback (most recent call last):
2015-03-13 17:15:16.396 8616 TRACE cinder File
"/usr/bin/cinder-manage", line 552, in <module>
2015-03-13 17:15:16.396 8616 TRACE cinder main()
2015-03-13 17:15:16.396 8616 TRACE cinder File
"/usr/bin/cinder-manage", line 549, in main
2015-03-13 17:15:16.396 8616 TRACE cinder fn(*fn_args)
2015-03-13 17:15:16.396 8616 TRACE cinder File
"/usr/bin/cinder-manage", line 423, in list
2015-03-13 17:15:16.396 8616 TRACE cinder services =
db.service_get_all(ctxt)
2015-03-13 17:15:16.396 8616 TRACE cinder File
"/usr/lib/python2.7/dist-packages/cinder/db/api.py", line 103, in
service_get_all
2015-03-13 17:15:16.396 8616 TRACE cinder return
IMPL.service_get_all(context, disabled)
2015-03-13 17:15:16.396 8616 TRACE cinder File
"/usr/lib/python2.7/dist-packages/cinder/db/sqlalchemy/api.py", line
154, in wrapper
2015-03-13 17:15:16.396 8616 TRACE cinder return f(*args, **kwargs)
2015-03-13 17:15:16.396 8616 TRACE cinder File
"/usr/lib/python2.7/dist-packages/cinder/db/sqlalchemy/api.py", line
354, in service_get_all
2015-03-13 17:15:16.396 8616 TRACE cinder query =
model_query(context, models.Service)
2015-03-13 17:15:16.396 8616 TRACE cinder File
"/usr/lib/python2.7/dist-packages/cinder/db/sqlalchemy/api.py", line
231, in model_query
2015-03-13 17:15:16.396 8616 TRACE cinder session =
kwargs.get('session') or get_session()
2015-03-13 17:15:16.396 8616 TRACE cinder File
"/usr/lib/python2.7/dist-packages/cinder/db/sqlalchemy/api.py", line 85,
in get_session
2015-03-13 17:15:16.396 8616 TRACE cinder facade =
_create_facade_lazily()
2015-03-13 17:15:16.396 8616 TRACE cinder File
"/usr/lib/python2.7/dist-packages/cinder/db/sqlalchemy/api.py", line 67,
in _create_facade_lazily
2015-03-13 17:15:16.396 8616 TRACE cinder **dict(CONF.database.iteritems())
2015-03-13 17:15:16.396 8616 TRACE cinder File
"/usr/lib/python2.7/dist-packages/oslo/db/sqlalchemy/session.py", line
711, in __init__
2015-03-13 17:15:16.396 8616 TRACE cinder **engine_kwargs)
2015-03-13 17:15:16.396 8616 TRACE cinder File
"/usr/lib/python2.7/dist-packages/oslo/db/sqlalchemy/session.py", line
396, in create_engine
2015-03-13 17:15:16.396 8616 TRACE cinder _test_connection(engine,
max_retries, retry_interval)
2015-03-13 17:15:16.396 8616 TRACE cinder File
"/usr/lib/python2.7/dist-packages/oslo/db/sqlalchemy/session.py", line
528, in _test_connection
2015-03-13 17:15:16.396 8616 TRACE cinder return
exc_filters.handle_connect_error(engine)
2015-03-13 17:15:16.396 8616 TRACE cinder File
"/usr/lib/python2.7/dist-packages/oslo/db/sqlalchemy/exc_filters.py",
line 351, in handle_connect_error
2015-03-13 17:15:16.396 8616 TRACE cinder handler(ctx)
2015-03-13 17:15:16.396 8616 TRACE cinder File
"/usr/lib/python2.7/dist-packages/oslo/db/sqlalchemy/exc_filters.py",
line 323, in handler
2015-03-13 17:15:16.396 8616 TRACE cinder context.is_disconnect)
2015-03-13 17:15:16.396 8616 TRACE cinder File
"/usr/lib/python2.7/dist-packages/oslo/db/sqlalchemy/exc_filters.py",
line 254, in _raise_operational_errors_directly_filter
2015-03-13 17:15:16.396 8616 TRACE cinder raise operational_error
2015-03-13 17:15:16.396 8616 TRACE cinder OperationalError:
(OperationalError) unable to open database file None None
2015-03-13 17:15:16.396 8616 TRACE cinder
cinder.conf
[DEFAULT]
rootwrap_config = /etc/cinder/rootwrap.conf
api_paste_confg = /etc/cinder/api-paste.ini
iscsi_helper = tgtadm
volume_name_template = volume-%s
volume_group = cinder-volumes
verbose = True
auth_strategy = keystone
state_path = /var/lib/cinder
lock_path = /var/lock/cinder
volumes_dir = /var/lib/cinder/volumes
rpc_backend = rabbit
rabbit_host = controller
rabbit_password = h4kde8md
auth_strategy = keystone
my_ip = 10.0.0.11
control_exchange = cinder
notification_driver = cinder.openstack.common.notifier.rpc_notifier
[database]
connection = mysql://cinder:ft74fs87@controller/cinder
[keystone_authtoken]
auth_uri = http://controller:5000/v2.0
identity_uri = http://controller:35357
admin_tenant_name = service
admin_user = cinder
admin_password = jd793fke
More information about the Openstack
mailing list