[Openstack] HEAT and MySQL 5.6

Steve Baker sbaker at redhat.com
Thu May 22 04:08:13 UTC 2014


On 21/05/14 16:28, Clint Dilks wrote:
> Hi
>
>
>     Does anyone have any suggestions as to how I get a working heat
>     database?
>
>
> As a follow up to this I ending up installing heat on another system
> with the default MySQL Server, mysql-server-5.1.73-3.el6_5.x86_64.
>
> It appears that 5.1 still has issues with the creation of indexes but
> reports it as a warning rather than an error. 
>
> When I looked at the tables generated there were definitely columns
> missing from my original heat database.
>
> Now I am at the point where all heat services start and commands like
> heat stack-list or heat stack-delete work, but creation fails.  The
> yaml file I am using appears valid if I run it through
> http://yaml-online-parser.appspot.com
>
> Currently I am out of ideas as to how to get HEAT working, any
> suggestions welcome.
>
> [root at comet ~]# nova net-list | awk '/ demo-net / { print $2}'
> 8faf95e8-5cc4-4369-9df1-3102928770a4
>
> [root at comet ~]# echo $NET_ID
> 8faf95e8-5cc4-4369-9df1-3102928770a4
>
>
> [root at comet ~]# heat stack-create -f test-stack.yml -P
> "ImageID=cirros-0.3.2-x86_64;NetID=$NET_ID" testStack
>
>
> 2014-05-21 16:05:20.633 33816 ERROR heat.engine.resource [-] CREATE :
> Server "server1" [717a33ef-8100-402c-8a62-a7bbf911391f] Stack
> "testStack" [2d8312d6-98d1-4c61-895a-5d169303bcc1]
> 2014-05-21 16:05:20.633 33816 TRACE heat.engine.resource Traceback
> (most recent call last):
> 2014-05-21 16:05:20.633 33816 TRACE heat.engine.resource   File
> "/usr/lib/python2.6/site-packages/heat/engine/resource.py", line 420,
> in _do_action
> 2014-05-21 16:05:20.633 33816 TRACE heat.engine.resource     while not
> check(handle_data):
> 2014-05-21 16:05:20.633 33816 TRACE heat.engine.resource   File
> "/usr/lib/python2.6/site-packages/heat/engine/resources/server.py",
> line 545, in check_create_complete
> 2014-05-21 16:05:20.633 33816 TRACE heat.engine.resource     return
> self._check_active(server)
> 2014-05-21 16:05:20.633 33816 TRACE heat.engine.resource   File
> "/usr/lib/python2.6/site-packages/heat/engine/resources/server.py",
> line 561, in _check_active
> 2014-05-21 16:05:20.633 33816 TRACE heat.engine.resource     raise exc
> 2014-05-21 16:05:20.633 33816 TRACE heat.engine.resource Error:
> Creation of server Test server failed.
>
> [root at comet ~]# cat test-stack.yml
> heat_template_version: 2013-05-23
>
> description: Test Template
>
> parameters:
>   ImageID:
>     type: string
>     description: Image use to boot a server
>   NetID:
>     type: string
>     description: Network ID for the server
>
> resources:
>   server1:
>     type: OS::Nova::Server
>     properties:
>       name: "Test server"
>       image: { get_param: ImageID }
>       flavor: "m1.tiny"
>       networks:
>       - network: { get_param: NetID }
>
> outputs:
>   server1_private_ip:
>     description: IP address of the server in the private network
>     value: { get_attr: [ server1, first_address ] }
>
You can find out whether your issue is heat or not by running:
* heat resource-show <stack_name> server1
  (look at the message in the status_reason)
* nova show <server_id>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20140522/c6369bf3/attachment.html>


More information about the Openstack mailing list