Juju-log Unable to find implementation for relation: requires of juju-info

HI.

I am studing in juju-log,

juju debug-log --level=ERROR

output is:

unit-glance-mysql-router-2: 14:26:43 ERROR unit.glance-mysql-router/2.juju-log Unable to find implementation for relation: requires of juju-info
unit-ntp-4: 14:26:43 ERROR unit.ntp/4.juju-log Unable to find implementation for relation: provides of ntp
unit-keystone-mysql-router-3: 14:26:47 ERROR unit.keystone-mysql-router/3.juju-log Unable to find implementation for relation: requires of juju-info
unit-masakari-mysql-router-2: 14:27:02 ERROR unit.masakari-mysql-router/2.juju-log Unable to find implementation for relation: requires of juju-info
unit-glance-mysql-router-1: 14:27:03 ERROR unit.glance-mysql-router/1.juju-log Unable to find implementation for relation: requires of juju-info
unit-masakari-mysql-router-1: 14:27:06 ERROR unit.masakari-mysql-router/1.juju-log Unable to find implementation for relation: requires of juju-info
unit-pacemaker-remote-0: 14:27:25 ERROR unit.pacemaker-remote/0.juju-log Unable to find implementation for relation: requires of juju-info
unit-pacemaker-remote-1: 14:27:25 ERROR unit.pacemaker-remote/1.juju-log Unable to find implementation for relation: requires of juju-info
unit-neutron-api-plugin-ovn-2: 14:27:27 ERROR unit.neutron-api-plugin-ovn/2.juju-log Unable to find implementation for relation: requires of juju-info
unit-nova-mysql-router-1: 14:27:42 ERROR unit.nova-mysql-router/1.juju-log Unable to find implementation for relation: requires of juju-info
unit-ntp-4: 14:26:43 ERROR unit.ntp/4.juju-log Unable to find implementation for relation: requires of ntp



unit-ntp-3: 14:27:51 ERROR unit.ntp/3.juju-log Unable to find implementation for relation: requires of ntp
unit-ntp-3: 14:27:51 ERROR unit.ntp/3.juju-log Unable to find implementation for relation: provides of ntp
unit-neutron-api-plugin-ovn-3: 14:27:54 ERROR unit.neutron-api-plugin-ovn/3.juju-log Unable to find implementation for relation: requires of juju-info
unit-masakari-mysql-router-0: 14:27:55 ERROR unit.masakari-mysql-router/0.juju-log Unable to find implementation for relation: requires of juju-info
unit-dashboard-mysql-router-1: 14:27:57 ERROR unit.dashboard-mysql-router/1.juju-log Unable to find implementation for relation: requires of juju-info
unit-cinder-mysql-router-1: 14:28:02 ERROR unit.cinder-mysql-router/1.juju-log Unable to find implementation for relation: requires of juju-info

Do I need correct it? And how can I correct it?

I have the same problem. have you resolved it yet?

unit-vault-1: 08:59:13 ERROR unit.vault/1.juju-log Unable to find implementation for relation: peers of vault-ha unit-vault-mysql-router-1: 08:59:59 ERROR unit.vault-mysql-router/1.juju-log Unable to find implementation for relation: requires of juju-info unit-vault-mysql-router-1: 09:00:14 ERROR unit.vault-mysql-router/1.juju-log db-router:7: Unable to find implementation for relation: requires of juju-info unit-vault-mysql-router-1: 09:00:14 ERROR unit.vault-mysql-router/1.juju-log db-router:7: Failed to connect to database due to ‘(2003, “Can’t connect to MySQL server on ‘127.0.0.1:3306’ (111)”)’ unit-vault-mysql-router-1: 09:00:15 ERROR unit.vault-mysql-router/1.juju-log db-router:7: Failed to connect to database due to ‘(2003, “Can’t connect to MySQL server on ‘127.0.0.1:3306’ (111)”)’ unit-vault-1: 09:00:16 ERROR unit.vault/1.juju-log shared-db:8: Unable to find implementation for relation: peers of vault-ha unit-vault-1: 09:04:21 ERROR unit.vault/1.juju-log shared-db:8: Traceback (most recent call last): File “/var/lib/juju/agents/unit-vault-1/.venv/lib/python3.8/site-packages/urllib3/connection.py”, line 174, in _new_conn conn = connection.create_connection( File “/var/lib/juju/agents/unit-vault-1/.venv/lib/python3.8/site-packages/urllib3/util/connection.py”, line 96, in create_connection raise err File “/var/lib/juju/agents/unit-vault-1/.venv/lib/python3.8/site-packages/urllib3/util/connection.py”, line 86, in create_connection sock.connect(sa) ConnectionRefusedError: [Errno 111] Connection refused

During handling of the above exception, another exception occurred:

Traceback (most recent call last): File “/var/lib/juju/agents/unit-vault-1/.venv/lib/python3.8/site-packages/urllib3/connectionpool.py”, line 699, in urlopen httplib_response = self._make_request( File “/var/lib/juju/agents/unit-vault-1/.venv/lib/python3.8/site-packages/urllib3/connectionpool.py”, line 394, in _make_request conn.request(method, url, **httplib_request_kw) File “/var/lib/juju/agents/unit-vault-1/.venv/lib/python3.8/site-packages/urllib3/connection.py”, line 239, in request super(HTTPConnection, self).request(method, url, body=body, headers=headers) File “/usr/lib/python3.8/http/client.py”, line 1256, in request self._send_request(method, url, body, headers, encode_chunked) File “/usr/lib/python3.8/http/client.py”, line 1302, in _send_request self.endheaders(body, encode_chunked=encode_chunked) File “/usr/lib/python3.8/http/client.py”, line 1251, in endheaders self._send_output(message_body, encode_chunked=encode_chunked) File “/usr/lib/python3.8/http/client.py”, line 1011, in _send_output self.send(msg) File “/usr/lib/python3.8/http/client.py”, line 951, in send self.connect() File “/var/lib/juju/agents/unit-vault-1/.venv/lib/python3.8/site-packages/urllib3/connection.py”, line 205, in connect conn = self._new_conn() File “/var/lib/juju/agents/unit-vault-1/.venv/lib/python3.8/site-packages/urllib3/connection.py”, line 186, in _new_conn raise NewConnectionError( urllib3.exceptions.NewConnectionError: <urllib3.connection.HTTPConnection object at 0x7f1582ae4e80>: Failed to establish a new connection: [Errno 111] Connection refused

During handling of the above exception, another exception occurred:

Traceback (most recent call last): File “/var/lib/juju/agents/unit-vault-1/.venv/lib/python3.8/site-packages/requests/adapters.py”, line 439, in send resp = conn.urlopen( File “/var/lib/juju/agents/unit-vault-1/.venv/lib/python3.8/site-packages/urllib3/connectionpool.py”, line 755, in urlopen retries = retries.increment( File “/var/lib/juju/agents/unit-vault-1/.venv/lib/python3.8/site-packages/urllib3/util/retry.py”, line 574, in increment raise MaxRetryError(_pool, url, error or ResponseError(cause)) urllib3.exceptions.MaxRetryError: HTTPConnectionPool(host=‘127.0.0.1’, port=8220): Max retries exceeded with url: /v1/sys/health (Caused by NewConnectionError(’<urllib3.connection.HTTPConnection object at 0x7f1582ae4e80>: Failed to establish a new connection: [Errno 111] Connection refused’))

During handling of the above exception, another exception occurred:

Traceback (most recent call last): File “/var/lib/juju/agents/unit-vault-1/charm/reactive/vault_handlers.py”, line 765, in _assess_status health = vault.get_vault_health() File “/var/lib/juju/agents/unit-vault-1/.venv/lib/python3.8/site-packages/tenacity/init.py”, line 339, in wrapped_f return self(f, *args, **kw) File “/var/lib/juju/agents/unit-vault-1/.venv/lib/python3.8/site-packages/tenacity/init.py”, line 430, in call do = self.iter(retry_state=retry_state) File “/var/lib/juju/agents/unit-vault-1/.venv/lib/python3.8/site-packages/tenacity/init.py”, line 378, in iter raise retry_exc.reraise() File “/var/lib/juju/agents/unit-vault-1/.venv/lib/python3.8/site-packages/tenacity/init.py”, line 206, in reraise raise self.last_attempt.result() File “/usr/lib/python3.8/concurrent/futures/_base.py”, line 437, in result return self.__get_result() File “/usr/lib/python3.8/concurrent/futures/_base.py”, line 389, in __get_result raise self._exception File “/var/lib/juju/agents/unit-vault-1/.venv/lib/python3.8/site-packages/tenacity/init.py”, line 433, in call result = fn(*args, **kwargs) File “/var/lib/juju/agents/unit-vault-1/charm/lib/charm/vault.py”, line 267, in get_vault_health response = requests.get( File “/var/lib/juju/agents/unit-vault-1/.venv/lib/python3.8/site-packages/requests/api.py”, line 76, in get return request(‘get’, url, params=params, **kwargs) File “/var/lib/juju/agents/unit-vault-1/.venv/lib/python3.8/site-packages/requests/api.py”, line 61, in request return session.request(method=method, url=url, **kwargs) File “/var/lib/juju/agents/unit-vault-1/.venv/lib/python3.8/site-packages/requests/sessions.py”, line 542, in request resp = self.send(prep, **send_kwargs) File “/var/lib/juju/agents/unit-vault-1/.venv/lib/python3.8/site-packages/requests/sessions.py”, line 655, in send r = adapter.send(request, **kwargs) File “/var/lib/juju/agents/unit-vault-1/.venv/lib/python3.8/site-packages/requests/adapters.py”, line 516, in send raise ConnectionError(e, request=request) requests.exceptions.ConnectionError: HTTPConnectionPool(host=‘127.0.0.1’, port=8220): Max retries exceeded with url: /v1/sys/health (Caused by NewConnectionError(’<urllib3.connection.HTTPConnection object at 0x7f1582ae4e80>: Failed to establish a new connection: [Errno 111] Connection refused’))

unit-vault-mysql-router-1: 09:04:22 ERROR unit.vault-mysql-router/1.juju-log Unable to find implementation for relation: requires of juju-info unit-vault-mysql-router-1: 09:04:23 ERROR unit.vault-mysql-router/1.juju-log Failed to connect to database due to ‘(2003, “Can’t connect to MySQL server on ‘127.0.0.1:3306’ (111)”)’ unit-vault-1: 09:04:34 ERROR unit.vault/1.juju-log Unable to find implementation for relation: peers of vault-ha

every openstack service which has its own mysql-router get this error

please i need help

Same issue here. Getting this error on all mysql-router units.

I am trying to setup a brand new openstack installation and everyone of these is failing.

Anyone managed to get around this?

unit-placement-mysql-router-0: 14:47:27 ERROR unit.placement-mysql-router/0.juju-log Unable to find implementation for relation: requires of juju-info unit-neutron-mysql-router-2: 14:47:28 ERROR unit.neutron-mysql-router/2.juju-log Unable to find implementation for relation: requires of juju-info unit-neutron-mysql-router-2: 14:47:29 ERROR unit.neutron-mysql-router/2.juju-log Failed to connect to database due to ‘(1040, ‘Too many connections’)’ unit-keystone-mysql-router-2: 14:47:29 ERROR unit.keystone-mysql-router/2.juju-log Unable to find implementation for relation: requires of juju-info unit-neutron-api-plugin-ovn-2: 14:47:30 ERROR unit.neutron-api-plugin-ovn/2.juju-log Unable to find implementation for relation: requires of juju-info unit-keystone-mysql-router-2: 14:47:30 ERROR unit.keystone-mysql-router/2.juju-log Failed to connect to database due to ‘(1040, ‘Too many connections’)’ unit-vault-mysql-router-2: 14:47:38 ERROR unit.vault-mysql-router/2.juju-log Unable to find implementation for relation: requires of juju-info unit-neutron-api-plugin-ovn-1: 14:47:45 ERROR unit.neutron-api-plugin-ovn/1.juju-log Unable to find implementation for relation: requires of juju-info unit-vault-2: 14:48:00 ERROR unit.vault/2.juju-log Unable to find implementation for relation: peers of vault-ha unit-mysql-innodb-cluster-0: 14:48:09 ERROR unit.mysql-innodb-cluster/0.juju-log Failed checking cluster status: Cannot set LC_ALL to locale en_US.UTF-8: No such file or directory WARNING: Cluster error connecting to target: MySQL Error 1040 (HY000): Too many connections Traceback (most recent call last): File “”, line 2, in mysqlsh.DBError: MySQL Error (1040): Dba.get_cluster: Too many connections

unit-cinder-mysql-router-2: 14:48:15 ERROR unit.cinder-mysql-router/2.juju-log Unable to find implementation for relation: requires of juju-info unit-cinder-mysql-router-0: 14:48:19 ERROR unit.cinder-mysql-router/0.juju-log Unable to find implementation for relation: requires of juju-info unit-neutron-mysql-router-0: 14:48:20 ERROR unit.neutron-mysql-router/0.juju-log Unable to find implementation for relation: requires of juju-info unit-cinder-mysql-router-0: 14:48:20 ERROR unit.cinder-mysql-router/0.juju-log Failed to connect to database due to ‘(1040, ‘Too many connections’)’ unit-cinder-mysql-router-1: 14:48:32 ERROR unit.cinder-mysql-router/1.juju-log Unable to find implementation for relation: requires of juju-info unit-nova-mysql-router-0: 14:48:37 ERROR unit.nova-mysql-router/0.juju-log Unable to find implementation for relation: requires of juju-info unit-openstack-dashboard-mysql-router-1: 14:48:38 ERROR unit.openstack-dashboard-mysql-router/1.juju-log Unable to find implementation for relation: requires of juju-info unit-nova-mysql-router-2: 14:49:06 ERROR unit.nova-mysql-router/2.juju-log Unable to find implementation for relation: requires of juju-info unit-openstack-dashboard-mysql-router-2: 14:49:07 ERROR unit.openstack-dashboard-mysql-router/2.juju-log Unable to find implementation for relation: requires of juju-info unit-vault-mysql-router-1: 14:49:39 ERROR unit.vault-mysql-router/1.juju-log Unable to find implementation for relation: requires of juju-info

same issue here. please help

same here. Seems that mysql-router 8.0 has a new dependency that the keystone charm does not know how to meet, although in another thread I read that juju-info is an implicit relationship…in which case the bug could be that mysql-router lists it at all.

unit-keystone-mysql-router-0: 18:44:27 ERROR unit.keystone-mysql-router/0.juju-log db-router:51: Unable to find implementation for relation: requires of juju-info

 $ juju info mysql-router 
   ...
 relations:
     ...
   requires:
    certificates: tls-certificates
    db-router: mysql-router
    juju-info: juju-info

$ juju info keystonename: keystone
   ...
relations:
  provides:
    identity-admin: keystone-admin
    identity-credentials: keystone-credentials
    identity-notifications: keystone-notifications
    identity-service: keystone
    nrpe-external-master: nrpe-external-master
  requires:
   ...


$ juju status keystone mysql-innodb-cluster 
Model      Controller     Cloud/Region   Version  SLA          Timestamp
engstack4  maas3-default  maas3/default  2.9.31   unsupported  19:15:51Z

App                    Version  Status   Scale  Charm                 Channel      Rev  Exposed  Message
keystone               20.0.0   waiting      1  keystone              yoga/stable  572  no  Allowed_units list provided but this unit not present
keystone-mysql-router  8.0.29   waiting      1  mysql-router          8.0/stable    30  no       'db-router' incomplete, MySQL Router not yet bootstrapped
mysql-innodb-cluster   8.0.29   active       3  mysql-innodb-cluster  8.0/stable    26  no       Unit is ready: Mode: R/O, Cluster is ONLINE and can tolerate up to ONE failure.

bump…

Seems like this is a real issue seen by multiple people and yet nobody is providing any guidance on a solution.

Does anyone really understand what juju_info is and whether or not it is really required? Do I need to dig into the mysql-cluster source code?