[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