Ask Your Question
0

Neutron error when running install in server

asked 2020-03-05 22:07:00 -0500

M Rizqi Alfian gravatar image

I have the same configuration tested in vm and the neutron is running successfully. but when I try the same configuration running on the UCS server I get an error like this. I had the same problem before. but i don't know how to fix it, i just removed and reinstalled it again and miraculously it can be fixed.

ERROR neutron.agent.dhcp.agent [u'Traceback (most recent call last):\n', u'  File "/usr/lib/python2.7/site-packages/oslo_messaging/rpc/server.py", line 166, in _process_incoming\n    res = self.dispatcher.dispatch(message)\n', u'  File "/usr/lib/python2.7/site-packages/oslo_messaging/rpc/dispatcher.py", line 265, in dispatch\n    return self._do_dispatch(endpoint, method, ctxt, args)\n', u'  File "/usr/lib/python2.7/site-packages/oslo_messaging/rpc/dispatcher.py", line 194, in _do_dispatch\n    result = func(ctxt, **new_args)\n', u'  File "/usr/lib/python2.7/site-packages/neutron/api/rpc/handlers/dhcp_rpc.py", line 142, in get_active_networks_info\n    networks = self._get_active_networks(context, **kwargs)\n', u'  File "/usr/lib/python2.7/site-packages/neutron/api/rpc/handlers/dhcp_rpc.py", line 86, in _get_active_networks\n    plugin.auto_schedule_networks(context, host)\n', u'  File "/usr/lib/python2.7/site-packages/neutron/db/agentschedulers_db.py", line 478, in auto_schedule_networks\n    self.network_scheduler.auto_schedule_networks(self, context, host)\n', u'  File "/usr/lib/python2.7/site-packages/neutron/scheduler/dhcp_agent_scheduler.py", line 46, in auto_schedule_networks\n    subnets = plugin.get_subnets(context, fields=fields)\n', u'  File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 123, in wrapped\n    return method(*args, **kwargs)\n', u'  File "/usr/lib/python2.7/site-packages/neutron/db/db_base_plugin_v2.py", line 1072, in get_subnets\n    marker, page_reverse)\n', u'  File "/usr/lib/python2.7/site-packages/neutron/db/db_base_plugin_common.py", line 291, in _get_subnets\n    **filters)\n', u'  File "/usr/lib/python2.7/site-packages/neutron/objects/base.py", line 644, in get_objects\n    cls, context, _pager=_pager, **cls.modify_fields_to_db(kwargs))\n', u'  File "/usr/lib/python2.7/site-packages/neutron/objects/db/api.py", line 53, in get_objects\n    **(_pager.to_kwargs(context, obj_cls) if _pager else {}))\n', u'  File "/usr/lib/python2.7/site-packages/neutron/db/_model_query.py", line 297, in get_collection\n    for c in query\n', u'  File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2995, in __iter__\n    return self._execute_and_instances(context)\n', u'  File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 3018, in _execute_and_instances\n    result = conn.execute(querycontext.statement, self._params)\n', u'  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 948, in execute\n    return meth(self, multiparams, params)\n', u'  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection\n    return connection._execute_clauseelement(self, multiparams, params)\n', u'  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement\n    compiled_sql, distilled_params\n', u'  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context\n    context)\n', u'  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1409 ...
(more)
edit retag flag offensive close merge delete

Comments

"Unknown column in field list" means that the DB schema does not correspond to the expectations of the software. Perhaps an older incompatible Neutron database existed on that system already, in which case delete and regenerate it. Or you installed an incompatible DHCP agent.

Bernd Bausch gravatar imageBernd Bausch ( 2020-03-05 23:08:47 -0500 )edit

i try to check the version of service. it is same version between server and vm. i try to drop and create again databases still same error.

M Rizqi Alfian gravatar imageM Rizqi Alfian ( 2020-03-06 22:58:11 -0500 )edit

You excluded one of the possible causes, namely that you work with an old database. Still the program that accesses the database doesn't expect this structure.

it is same version between server and vm.

Do the databases on VM and UCS server have the same structure? Which service did you check?

Bernd Bausch gravatar imageBernd Bausch ( 2020-03-07 03:35:15 -0500 )edit

I checked that all neutron packages have the same version, between vm and server ucs. I am trying to check one of the tables in the neutron that I am getting an error.

`[SQL: u'SELECT securitygroups.standard_attr_id AS securitygroups_s>`

they have same structure.

M Rizqi Alfian gravatar imageM Rizqi Alfian ( 2020-03-08 03:19:28 -0500 )edit

i try to check another tables; i looked the have different structured. how to fix this ?

M Rizqi Alfian gravatar imageM Rizqi Alfian ( 2020-03-09 02:44:40 -0500 )edit

1 answer

Sort by » oldest newest most voted
1

answered 2020-03-10 01:42:15 -0500

M Rizqi Alfian gravatar image

solved this issue after running this script

neutron-db-manage upgrade heads

which is i'm not running this command on vm or the ucs server. because this command is not listed in the official openstack rocky neutron documentation for opensuse / suse. but in other os documentation like ubuntu or centos this command is listed there.

edit flag offensive delete link more

Comments

Great solution. I have no idea what this command does :)

Bernd Bausch gravatar imageBernd Bausch ( 2020-03-10 01:47:10 -0500 )edit

yeah, me too. btw thanks you for the comment and answer this posts.

M Rizqi Alfian gravatar imageM Rizqi Alfian ( 2020-03-10 02:10:44 -0500 )edit

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower

Stats

Asked: 2020-03-05 22:07:00 -0500

Seen: 54 times

Last updated: Mar 10