# Mysql slowquery pipeline fails if schema contains a dash

**URL:** https://discuss.elastic.co/t/mysql-slowquery-pipeline-fails-if-schema-contains-a-dash/300173
**Category:** Beats
**Tags:** beats-module, filebeat, ingest-pipeline
**Created:** [March 21, 2022, 9:16am UTC](https://discuss.elastic.co/t/mysql-slowquery-pipeline-fails-if-schema-contains-a-dash/300173 "2022-03-21T09:16:10Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Rasmus\_Breinholm\_Rom](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rasmus_breinholm_rom/32/79758_2.png) [@Rasmus\_Breinholm\_Rom](https://discuss.elastic.co/u/Rasmus_Breinholm_Rom)
#### Post date: [March 21, 2022, 9:16am UTC](https://discuss.elastic.co/t/mysql-slowquery-pipeline-fails-if-schema-contains-a-dash/300173/1 "2022-03-21T09:16:10Z")

</div>

The Grok patttern defined in the [mysql slowlog ingest pipeline](https://github.com/elastic/beats/blob/main/filebeat/module/mysql/slowlog/ingest/pipeline.json#L12) uses the [WORD](https://github.com/elastic/logstash/blob/v1.4.0/patterns/grok-patterns#L11) grok pattern to extract schema.  
This causes the pipeline to fail if schema contains a dash.

Using the same pattern as [USERNAME](https://github.com/elastic/logstash/blob/v1.4.0/patterns/grok-patterns#L1) seems to fix the issue.

My problem is that the module uses the "filebeat--mysql-slowlog-pipeline" which is changed eveytime I upgrade filebeat.

How can I make this change permanent?

---

<div class="post-metadata">

### Author: ![mtojek](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mtojek/32/63863_2.png) [@mtojek](https://discuss.elastic.co/u/mtojek)
#### Post date: [March 21, 2022, 3:13pm UTC](https://discuss.elastic.co/t/mysql-slowquery-pipeline-fails-if-schema-contains-a-dash/300173/2 "2022-03-21T15:13:38Z")

</div>

Maybe you could open a pull request to Beats to adjust the ingest pipeline?

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [April 18, 2022, 5:14pm UTC](https://discuss.elastic.co/t/mysql-slowquery-pipeline-fails-if-schema-contains-a-dash/300173/3 "2022-04-18T17:14:06Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
