[Openstack] neutron database error in Icehouse
Felix Lee
zaknafein.lee at gmail.com
Wed Jun 18 08:45:06 UTC 2014
Hi,
That table is supposed to be created while you deploy
neutron(openstack-db --service neutron --init, install neutron agent
plugins, blah, blah), in particular, if you use RDO tool, everything
should be in place.
So, how did you manage to install your neutron?
Best regards,
Felix Lee ~
On 2014年06月18日 06:10, Raphael Ribeiro wrote:
> Hello, I have configured a multi node and neutron single flat network in
> CentOS OpenStack IceHouse version
>
> Have one controller, one compute and one network node. But when I try
> create a neutron network we are getting below error:
>
> # neutron net-create ext-net --shared --router:external=True
>
>
>
>
> Request Failed: internal server error while processing your request.
>
>
>
>
> *# tail /var/log/neutron/server.log (controller)*
>
> http://pastebin.com/AmcVxDMt
>
> *#��tail /var/log/neutron/dhcp-agent.log*
>
> http://pastebin.com/PbwwcL8F
>
> *#��tail /var/log/neutron/l3-agent.log*
>
> http://pastebin.com/WCW1mvqQ
>
>
> /"//2014-06-18 00:51:37.592 21709 ERROR
> neutron.openstack.common.rpc.common
> [req-18a7d388-7a8a-498c-ae6c-6182279dcecf None] Returning exception
> (ProgrammingError) (1146, "Table 'neutron.ipallocationpools' doesn't
> exist")" /(/var/log/neutron/server.log)
>
> Maybe a database error?
>
> I noticed that the database does not have this table "ipallocationpools":
>
> mysql> show tables;
>
> +-----------------------+
>
> | Tables_in_neutron � � |
>
> +-----------------------+
>
> | agents � � � � � � � �|
>
> | alembic_version � � � |
>
> | externalnetworks � � �|
>
> | ml2_flat_allocations �|
>
> | ml2_gre_allocations � |
>
> | ml2_gre_endpoints � � |
>
> | ml2_network_segments �|
>
> | ml2_vlan_allocations �|
>
> | ml2_vxlan_allocations |
>
> | ml2_vxlan_endpoints � |
>
> | networks � � � � � � �|
>
> | ports � � � � � � � � |
>
> | quotas � � � � � � � �|
>
> | securitygrouprules � �|
>
> | securitygroups � � � �|
>
> | subnets � � � � � � � |
>
> +-----------------------+
>
> 16 rows in set (0.00 sec)
>
>
> how �I create neutron db properly?
>
> Thanks!
>
> /
> Raphael Pereira Ribeiro
> /
>
>
> _______________________________________________
> Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
> Post to : openstack at lists.openstack.org
> Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
>
--
Felix H.T Lee Academia Sinica Grid & Cloud.
Tel: +886-2-27898308
Office: Room P111, Institute of Physics, 128 Academia Road, Section 2,
Nankang, Taipei 115, Taiwan
More information about the Openstack
mailing list