MySQL software_versions is not stored when service is added via PMM GUI

Description

MySQL software_versions is not stored when service is added via PMM GUI

How to repeat :

I have 2 MySQL(8.0.27) instance registered. PMM client/server version used is 2.35 :

1) Via CLI on MySQL server with PMM client installed :

 

shell> pmm-admin add mysql --username=pmm --password='Secret1!' --host=localhost --port=3306 --query-source=perfschema

 

2) Via GUI > Add Service (https://<pmm-server>/graph/add-instance) . 

 

Check from PMM server.

 

shell> docker exec -it pmm-server bash shell> su postgres shell> psql pmm-managed=# \x Expanded display is on. pmm-managed=# select service_id, service_type, software_versions from public.service_software_versions; -[ RECORD 1 ]-----+------------------------------------------------- service_id        | /service_id/9e391f8b-8983-4d55-ae6b-c0f9ed20923a service_type      | mysql software_versions | [{"name": "mysqld", "version": "8.0.27"}] -[ RECORD 2 ]-----+------------------------------------------------- service_id        | /service_id/22885237-b723-4442-abb9-9d4debc9678b service_type      | mysql software_versions | []

From above we can see that software_versions is not stored for service c7-172-mysql-gui.

List services from server with PMM client

 

# pmm-admin inventory list services --service-type=mysql Services list. Service type           Service name         Address and Port  Service ID MySQL                  c7-172-mysql-gui     192.168.122.172:3306 /service_id/22885237-b723-4442-abb9-9d4debc9678b MySQL                  c7-171-mysql         localhost:3306    /service_id/9e391f8b-8983-4d55-ae6b-c0f9ed20923a

Suggested fix :

Please ensure that software version get registered  regardless the method the DB is added.

 

How to test

None

How to document

None

Attachments

1
  • 21 Mar 2023, 02:57 AM

Activity

Show:
Percona Bot
updated the AFFECTED USER LEVELMarch 5, 2024 at 11:51 PM
None
Internal
Secure Custom Fields for Jira (Security & Permission)
updated the AFFECTED USER LEVELDecember 19, 2023 at 5:00 AM
None
This field doesn't support this UI
Maggie Suero
updated the WorkflowJuly 17, 2023 at 5:13 PM
Percona Open Source Software Default Workflow V1.8
Percona Open Source Software Default Workflow V1.9
aristotle.po
updated the DescriptionMarch 21, 2023 at 3:09 AM
MySQL software_versions is not stored when service is added via PMM GUI h2. How to repeat : I have 2 MySQL(8.0.27) instance registered. PMM client/server version used is 2.35 : 1) Via CLI on MySQL server with PMM client installed :   {code:java} shell> pmm-admin add mysql --username=pmm --password='Secret1!' --host=localhost --port=3306 --query-source=perfschema{code}   2) Via GUI > Add Service (https://<pmm-server>/graph/add-instance) .  !Screenshot from 2023-03-21 09-58-29.png!   Check from PMM server.   {code:java} shell> docker exec -it pmm-server bash shell> su postgres shell> psql pmm-managed=# \x Expanded display is on. pmm-managed=# select service_id, service_type, software_versions from public.service_software_versions; -[ RECORD 1 ]-----+------------------------------------------------- service_id        | /service_id/9e391f8b-8983-4d55-ae6b-c0f9ed20923a service_type      | mysql software_versions | [{"name": "mysqld", "version": "8.0.27"}] -[ RECORD 2 ]-----+------------------------------------------------- service_id        | /service_id/22885237-b723-4442-abb9-9d4debc9678b service_type      | mysql software_versions | [] {code} From above we can see that software_versions is not stored for service c7-172-mysql-gui. List services from server with PMM client   {noformat} # pmm-admin inventory list services --service-type=mysql Services list. Service type           Service name         Address and Port  Service ID MySQL                  c7-172-mysql-gui     192.168.122.172:3306 /service_id/22885237-b723-4442-abb9-9d4debc9678b MySQL                  c7-171-mysql         localhost:3306    /service_id/9e391f8b-8983-4d55-ae6b-c0f9ed20923a {noformat} h2. Suggested fix : Please ensure that software version get registered  regardless the method the DB is added.  
MySQL software_versions is not stored when service is added via PMM GUI h2. How to repeat : I have 2 MySQL(8.0.27) instance registered. PMM client/server version used is 2.35 : 1) Via CLI on MySQL server with PMM client installed :   {code:java} shell> pmm-admin add mysql --username=pmm --password='Secret1!' --host=localhost --port=3306 --query-source=perfschema{code}   2) Via GUI > Add Service (https://<pmm-server>/graph/add-instance) .  !Screenshot from 2023-03-21 09-58-29.png!   Check from PMM server.   {code:java} shell> docker exec -it pmm-server bash shell> su postgres shell> psql pmm-managed=# \x Expanded display is on. pmm-managed=# select service_id, service_type, software_versions from public.service_software_versions; -[ RECORD 1 ]-----+------------------------------------------------- service_id        | /service_id/9e391f8b-8983-4d55-ae6b-c0f9ed20923a service_type      | mysql software_versions | [{"name": "mysqld", "version": "8.0.27"}] -[ RECORD 2 ]-----+------------------------------------------------- service_id        | /service_id/22885237-b723-4442-abb9-9d4debc9678b service_type      | mysql software_versions | [] {code} From above we can see that software_versions is not stored for service {*}c7-172-mysql-gui{*}. List services from server with PMM client   {noformat} # pmm-admin inventory list services --service-type=mysql Services list. Service type           Service name         Address and Port  Service ID MySQL                  c7-172-mysql-gui     192.168.122.172:3306 /service_id/22885237-b723-4442-abb9-9d4debc9678b MySQL                  c7-171-mysql         localhost:3306    /service_id/9e391f8b-8983-4d55-ae6b-c0f9ed20923a {noformat} h2. Suggested fix : Please ensure that software version get registered  regardless the method the DB is added.  
aristotle.po
changed the StatusMarch 21, 2023 at 3:05 AM
New
Open
aristotle.po
created the IssueMarch 21, 2023 at 3:02 AM

Details

Assignee

Reporter

Priority

Components

Needs QA

Yes

Needs Doc

No

Affects versions

Smart Checklist

Created March 21, 2023 at 3:02 AM
Updated March 5, 2024 at 11:51 PM

Flag notifications