Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1202555

Summary: During deployment -error in reports: Execution of '/usr/bin/systemctl start openstack-nova-compute' returned 1: Job for openstack-nova-compute.service failed
Product: Red Hat OpenStack Reporter: Mike Burns <mburns>
Component: openstack-puppet-modulesAssignee: Ivan Chavero <ichavero>
Status: CLOSED WONTFIX QA Contact: Alexander Chuzhoy <sasha>
Severity: high Docs Contact:
Priority: high    
Version: unspecifiedCC: aberezin, ajeain, jguiditt, lbezdick, mburns, morazi, rhos-maint, sasha, sclewis, yeylon
Target Milestone: z2Keywords: ZStream
Target Release: 6.0 (Juno)   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: openstack-puppet-modules-2014.2.12-2.el7ost Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: 1202464 Environment:
Last Closed: 2015-03-20 13:45:01 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
Restore sql_connection option
none
Restore sql_connection option none

Description Mike Burns 2015-03-16 21:22:57 UTC 
Root cause of this issue is that a deprecated option broke in OPM.  Cloning to OPM so that they can address the parameter directly while we fix OFI to use the new parameter.  

The root cause is that sql_connection no longer works.  It has been replaced with database_connection, but the deprecated parameter no longer works.  

This was a change between A1 and A2.

+++ This bug was initially created as a clone of Bug #1202464 +++

rubygem-staypuft:  During deployment -error in reports: Execution of '/usr/bin/systemctl start openstack-nova-compute' returned 1: Job for openstack-nova-compute.service failed

Environment:
rhel-osp-installer-client-0.5.7-1.el7ost.noarch
openstack-foreman-installer-3.0.17-1.el7ost.noarch
rhel-osp-installer-0.5.7-1.el7ost.noarch
ruby193-rubygem-staypuft-0.5.21-1.el7ost.noarch
openstack-puppet-modules-2014.2.12-1.el7ost.noarch
ruby193-rubygem-foreman_openstack_simplify-0.0.6-8.el7ost.noarch


Steps to reproduce:
1. install rhel-osp-installer.
2. Create and run a single controller Neutron+vxlan deployment with 2 computes.


Result:

The deployment gets paused with errors. Checking the reports - there are errors during the compute nodes deployment:
Could not start Service[nova-compute]: Execution of '/usr/bin/systemctl start openstack-nova-compute' returned 1: Job for openstack-nova-compute.service failed. See 'systemctl status openstack-nova-compute.service' and 'journalctl -xn' for details. Wrapped exception: Execution of '/usr/bin/systemctl start openstack-nova-compute' returned 1: Job for openstack-nova-compute.service failed. See 'systemctl status openstack-nova-compute.service' and 'journalctl -xn' for details.


--- Additional comment from Alexander Chuzhoy on 2015-03-16 12:59:10 EDT ---

[root@maca25400702875 ~]# cat /var/log/nova/nova-manage.log
2015-03-16 11:27:08.093 1336 CRITICAL nova [-] OperationalError: (OperationalError) (1045, "Access denied for user 'nova'@'localhost' (using password: YES)") None None
2015-03-16 11:27:08.093 1336 TRACE nova Traceback (most recent call last):                                                                                             
2015-03-16 11:27:08.093 1336 TRACE nova   File "/usr/bin/nova-manage", line 10, in <module>                                                                            
2015-03-16 11:27:08.093 1336 TRACE nova     sys.exit(main())                                                                                                           
2015-03-16 11:27:08.093 1336 TRACE nova   File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 1401, in main                                               
2015-03-16 11:27:08.093 1336 TRACE nova     ret = fn(*fn_args, **fn_kwargs)                                                                                            
2015-03-16 11:27:08.093 1336 TRACE nova   File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 902, in sync                                                
2015-03-16 11:27:08.093 1336 TRACE nova     return migration.db_sync(version)                                                                                          
2015-03-16 11:27:08.093 1336 TRACE nova   File "/usr/lib/python2.7/site-packages/nova/db/migration.py", line 29, in db_sync                                            
2015-03-16 11:27:08.093 1336 TRACE nova     return IMPL.db_sync(version=version)                                                                                       
2015-03-16 11:27:08.093 1336 TRACE nova   File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/migration.py", line 41, in db_sync                                 
2015-03-16 11:27:08.093 1336 TRACE nova     current_version = db_version()                                                                                             
2015-03-16 11:27:08.093 1336 TRACE nova   File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/migration.py", line 53, in db_version                              
2015-03-16 11:27:08.093 1336 TRACE nova     return versioning_api.db_version(get_engine(), repository)                                                                 
2015-03-16 11:27:08.093 1336 TRACE nova   File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/api.py", line 97, in get_engine                                    
2015-03-16 11:27:08.093 1336 TRACE nova     facade = _create_facade_lazily()                                                                                           
2015-03-16 11:27:08.093 1336 TRACE nova   File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/api.py", line 92, in _create_facade_lazily                         
2015-03-16 11:27:08.093 1336 TRACE nova     _ENGINE_FACADE = db_session.EngineFacade.from_config(CONF)                                                                 
2015-03-16 11:27:08.093 1336 TRACE nova   File "/usr/lib/python2.7/site-packages/oslo/db/sqlalchemy/session.py", line 816, in from_config                              
2015-03-16 11:27:08.093 1336 TRACE nova     retry_interval=conf.database.retry_interval)                                                                               
2015-03-16 11:27:08.093 1336 TRACE nova   File "/usr/lib/python2.7/site-packages/oslo/db/sqlalchemy/session.py", line 732, in __init__                                 
2015-03-16 11:27:08.093 1336 TRACE nova     **engine_kwargs)                                                                                                           
2015-03-16 11:27:08.093 1336 TRACE nova   File "/usr/lib/python2.7/site-packages/oslo/db/sqlalchemy/session.py", line 409, in create_engine                            
2015-03-16 11:27:08.093 1336 TRACE nova     _test_connection(engine, max_retries, retry_interval)                                                                      
2015-03-16 11:27:08.093 1336 TRACE nova   File "/usr/lib/python2.7/site-packages/oslo/db/sqlalchemy/session.py", line 549, in _test_connection                         
2015-03-16 11:27:08.093 1336 TRACE nova     return exc_filters.handle_connect_error(engine)                                                                            
2015-03-16 11:27:08.093 1336 TRACE nova   File "/usr/lib/python2.7/site-packages/oslo/db/sqlalchemy/exc_filters.py", line 351, in handle_connect_error                 
2015-03-16 11:27:08.093 1336 TRACE nova     handler(ctx)                                                                                                               
2015-03-16 11:27:08.093 1336 TRACE nova   File "/usr/lib/python2.7/site-packages/oslo/db/sqlalchemy/exc_filters.py", line 323, in handler                              
2015-03-16 11:27:08.093 1336 TRACE nova     context.is_disconnect)                                                                                                     
2015-03-16 11:27:08.093 1336 TRACE nova   File "/usr/lib/python2.7/site-packages/oslo/db/sqlalchemy/exc_filters.py", line 254, in _raise_operational_errors_directly_filter
2015-03-16 11:27:08.093 1336 TRACE nova     raise operational_error                                                                                                        
2015-03-16 11:27:08.093 1336 TRACE nova OperationalError: (OperationalError) (1045, "Access denied for user 'nova'@'localhost' (using password: YES)") None None           
2015-03-16 11:27:08.093 1336 TRACE nova

--- Additional comment from Jason Guiditta on 2015-03-16 16:07:58 EDT ---

https://github.com/redhat-openstack/astapor/pull/494
Comment 4 Ivan Chavero 2015-03-17 21:43:58 UTC 
Created attachment 1002961 [details]
Restore sql_connection option
Comment 5 Ivan Chavero 2015-03-17 23:35:08 UTC 
Created attachment 1002978 [details]
Restore sql_connection option
Comment 6 Ivan Chavero 2015-03-18 00:55:34 UTC 
can i have acks for this bug please??

thanks!!
Comment 8 Alexander Chuzhoy 2015-03-19 15:24:43 UTC 
Verified:

FailedQA:

openstack-foreman-installer-3.0.19-1.el7ost.noarch
rhel-osp-installer-0.5.7-1.el7ost.noarch
ruby193-rubygem-foreman_openstack_simplify-0.0.6-8.el7ost.noarch
rhel-osp-installer-client-0.5.7-1.el7ost.noarch
ruby193-rubygem-staypuft-0.5.21-1.el7ost.noarch
openstack-puppet-modules-2014.2.12-2.el7ost.noarch


Get the following message:
Could not retrieve catalog from remote server: Error 400 on SERVER: Duplicate declaration: Nova_config[database/connection] is already declared in file /etc/puppet/environments/production/modules/nova/manifests/db.pp:53; cannot redeclare at /etc/puppet/environments/production/modules/nova/manifests/init.pp:539 on node maca25400702876.example.com
Comment 9 Jason Guiditta 2015-03-19 15:32:22 UTC 
You can see the error in the patch, it is here:

diff --git a/nova/manifests/init.pp b/nova/manifests/init.pp
index 40c8c79..85c4e05 100644
--- a/nova/manifests/init.pp
+++ b/nova/manifests/init.pp
@@ -265,9 +265,13 @@
 #   and you have multiple endpoints, you will get AmbiguousEndpoint
 #   exceptions in the nova API service.
 #   Defaults to undef
+# [*sql_connection*]
+#   (optional) Deprecated. Use database_connection instead.
+#   Defaults to false 
 class nova(
   $ensure_package           = 'present',
   $database_connection      = false,
+  $sql_connection           = false,

^^ the param was already present (just not used in the body of the class), so the patch makes it so there are 2, the rest of this patch is likely fine.