MySQL software_versions is not stored when service is added via PMM GUI
General
Escalation
General
Escalation
Description
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 PMNone
Internal
Secure Custom Fields for Jira (Security & Permission)
updated the AFFECTED USER LEVELDecember 19, 2023 at 5:00 AMNone
This field doesn't support this UI

Maggie Suero
updated the WorkflowJuly 17, 2023 at 5:13 PMPercona 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 AMMySQL 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 AMNew
Open

aristotle.po
created the IssueMarch 21, 2023 at 3:02 AM
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.