Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Issues

Select view

Select search mode

 
21 of 21

MySQL/MariaDB Schemaname is empty in QAN

Description

Hi Team,

If we run query without using the schema name, then in the QAN db we are seeing empty schema name.

Schema Name: bgrdb

Table Name: bgr_requests

Reproducible steps:

  1. mysql -uroot -p

  2. UPDATE bgrdb.bgr_requests SET status='close,rqst_status = 'completed',rqst_cmplt_dt = '2024-06-05 03:05:35.034240' WHERE bgr_uuid = '291bd0e2-ae57-4e93-ba6c-5d63ea4d8dc8';


Then we are getting the empty schemname in the pmm."metrics" schema(QAN),

How to test

Step 1: Install PMM 2.41.2 [Latest] using the following docker command:

Step 2: Add Node to PMM server:

Step 3: Start MySQL/MariaDB and Add service to the PMM server. Please note this issue is happening with slow_query_log as well as perfschema as query source:

Step 4: Prepare sample data set by running the following set of SQL:

Step 5: Run the following query on MySQL and Navigate to QAN. The query will appear in QAN:

Step 6: Run the following query on MySQL, and this time, do not select the schema and Navigate to QAN. The query will not appear in QAN:

How to document

None

Attachments

2

Details

Assignee

Reporter

Priority

Components

Labels

Needs QA

Yes

Needs Doc

Yes

Planned Version/s

Affects versions

Smart Checklist

Created June 5, 2024 at 12:32 PM
Updated January 9, 2025 at 9:51 AM
Configure

Activity

Show:

Naresh December 17, 2024 at 1:53 PM

Sure

Thanks for the update.

Nurlan Moldomurov December 17, 2024 at 8:23 AM

Hi very likely it won’t be included in the next release.

Naresh December 16, 2024 at 7:37 PM

Hi Can we expect to see this fixed in the next release?


Naresh June 7, 2024 at 3:29 PM

Sure

Thanks for the update.

Nurlan Moldomurov June 7, 2024 at 9:19 AM

if you mean 2.42.0, then we almost released that one, so no chance to include it there. We will discuss internally about including it to 2.43.0

Loading...