[Openstack-operators] Queens metadata agent error 500
Ignazio Cassano
ignaziocassano at gmail.com
Mon Nov 12 22:05:50 UTC 2018
Hello again, ath the same time I tried to create an instance nova-api log
reports:
2018-11-12 21:30:42.225 4226 ERROR oslo_db.sqlalchemy.engines
[req-e4799f40-eeab-482d-9717-cb41be8ffde2 89f76bc5de5545f381da2c10c7df7f15
59f1f232ce28409593d66d8f6495e434 - default default] Database connection was
found disconnected; reconnecting: DBConnectionError:
(pymysql.err.OperationalError) (2013, 'Lost connection to MySQL server
during query') [SQL: u'SELECT 1'] (Background on this error at:
http://sqlalche.me/e/e3q8)
2018-11-12 21:30:42.225 4226 ERROR oslo_db.sqlalchemy.engines Traceback
(most recent call last):
2018-11-12 21:30:42.225 4226 ERROR oslo_db.sqlalchemy.engines File
"/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/engines.py", line 73,
in _connect_ping_listener
2018-11-12 21:30:42.225 4226 ERROR oslo_db.sqlalchemy.engines
connection.scalar(select([1]))
2018-11-12 21:30:42.225 4226 ERROR oslo_db.sqlalchemy.engines File
"/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 880,
in scalar
2018-11-12 21:30:42.225 4226 ERROR oslo_db.sqlalchemy.engines return
self.execute(object, *multiparams, **params).scalar()
2018-11-12 21:30:42.225 4226 ERROR oslo_db.sqlalchemy.engines File
"/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 948,
in execute
2018-11-12 21:30:42.225 4226 ERROR oslo_db.sqlalchemy.engines return
meth(self, multiparams, params)
2018-11-12 21:30:42.225 4226 ERROR oslo_db.sqlalchemy.engines File
"/usr/lib64/python2.7/site-packages/sqlalchemy/sql/elements.py", line 269,
in _execute_on_connection
2018-11-12 21:30:42.225 4226 ERROR oslo_db.sqlalchemy.engines return
connection._execute_clauseelement(self, multiparams, params)
2018-11-12 21:30:42.225 4226 ERROR oslo_db.sqlalchemy.engines File
"/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1060,
in _execute_clauseelement
2018-11-12 21:30:42.225 4226 ERROR oslo_db.sqlalchemy.engines
compiled_sql, distilled_params
2018-11-12 21:30:42.225 4226 ERROR oslo_db.sqlalchemy.engines File
"/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1200,
in _execute_context
2018-11-12 21:30:42.225 4226 ERROR oslo_db.sqlalchemy.engines context)
2018-11-12 21:30:42.225 4226 ERROR oslo_db.sqlalchemy.engines File
"/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1409,
in _handle_dbapi_exception
2018-11-12 21:30:42.225 4226 ERROR oslo_db.sqlalchemy.engines
util.raise_from_cause(newraise, exc_info)
2018-11-12 21:30:42.225 4226 ERROR oslo_db.sqlalchemy.engines File
"/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 203,
in raise_from_cause
2018-11-12 21:30:42.225 4226 ERROR oslo_db.sqlalchemy.engines
reraise(type(exception), exception, tb=exc_tb, cause=cause)
2018-11-12 21:30:42.225 4226 ERROR oslo_db.sqlalchemy.engines File
"/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1193,
in _execute_context
2018-11-12 21:30:42.225 4226 ERROR oslo_db.sqlalchemy.engines context)
2018-11-12 21:30:42.225 4226 ERROR oslo_db.sqlalchemy.engines File
"/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line
507, in do_execute
2018-11-12 21:30:42.225 4226 ERROR oslo_db.sqlalchemy.engines
cursor.execute(statement, parameters)
2018-11-12 21:30:42.225 4226 ERROR oslo_db.sqlalchemy.engines File
"/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 166, in execute
2018-11-12 21:30:42.225 4226 ERROR oslo_db.sqlalchemy.engines result =
self._query(query)
2018-11-12 21:30:42.225 4226 ERROR oslo_db.sqlalchemy.engines File
"/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 322, in _quer
I never lost connections to de db before upgrading
:-(
Il giorno lun 12 nov 2018 alle ore 22:40 Slawomir Kaplonski <
skaplons at redhat.com> ha scritto:
> Hi,
>
> From logs which You attached it looks that Your neutron-metadata-agent
> can’t connect to nova-api service. Please check if nova-metadata-api is
> reachable from node where Your neutron-metadata-agent is running.
>
> > Wiadomość napisana przez Ignazio Cassano <ignaziocassano at gmail.com> w
> dniu 12.11.2018, o godz. 22:34:
> >
> > Hello again,
> > I have another installation of ocata .
> > On ocata the metadata for a network id is displayed by ps -afe like this:
> > /usr/bin/python2 /bin/neutron-ns-metadata-proxy
> --pid_file=/var/lib/neutron/external/pids/c4731392-9b91-4663-adb3-b10b5ebcc4f1.pid
> --metadata_proxy_socket=/var/lib/neutron/metadata_proxy
> --network_id=c4731392-9b91-4663-adb3-b10b5ebcc4f1
> --state_path=/var/lib/neutron --metadata_port=80 --metadata_proxy_user=996
> --metadata_proxy_group=993
> --log-file=neutron-ns-metadata-proxy-c4731392-9b91-4663-adb3-b10b5ebcc4f1.log
> --log-dir=/var/log/neutron
> >
> > On queens like this:
> > haproxy -f
> /var/lib/neutron/ns-metadata-proxy/e8ba8c09-a7dc-4a22-876e-b8d4187a23fe.conf
> >
> > Is it the correct behaviour ?
>
> Yes, that is correct. It was changed some time ago, see
> https://bugs.launchpad.net/neutron/+bug/1524916
>
> >
> > Regards
> > Ignazio
> >
> >
> >
> > Il giorno lun 12 nov 2018 alle ore 21:37 Slawomir Kaplonski <
> skaplons at redhat.com> ha scritto:
> > Hi,
> >
> > Can You share logs from Your haproxy-metadata-proxy service which is
> running in qdhcp namespace? There should be some info about reason of those
> errors 500.
> >
> > > Wiadomość napisana przez Ignazio Cassano <ignaziocassano at gmail.com> w
> dniu 12.11.2018, o godz. 19:49:
> > >
> > > Hi All,
> > > I upgraded manually my centos 7 openstack ocata to pike.
> > > All worked fine.
> > > Then I upgraded from pike to Queens and instances stopped to reach
> metadata on 169.254.169.254 with error 500.
> > > I am using isolated metadata true in my dhcp conf and in dhcp
> namespace the port 80 is in listen.
> > > Please, anyone can help me?
> > > Regards
> > > Ignazio
> > >
> > > _______________________________________________
> > > OpenStack-operators mailing list
> > > OpenStack-operators at lists.openstack.org
> > >
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators
> >
> > —
> > Slawek Kaplonski
> > Senior software engineer
> > Red Hat
> >
>
> —
> Slawek Kaplonski
> Senior software engineer
> Red Hat
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-operators/attachments/20181112/e089e0d7/attachment.html>
More information about the OpenStack-operators
mailing list