[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