I'm using prebuild elastic integration to fetch mysql metrics and logs.
I'm able to fetch mysql status metrics and agent running healthy.
But when I enable MySQL performance metric it will become unhealthy and I got error logs of metricbeat below.
elastic_agent.metricbeat
[elastic_agent.metricbeat][error] Exiting: data path already locked by another beat. Please make sure that multiple beats are not sharing the same data path (path.data).
14:18:48.262
elastic_agent
[elastic_agent][error] metricbeat stderr: "Exiting: data path already locked by another beat. Please make sure that multiple beats are not sharing the same data path (path.data).\n"
14:18:48.588
elastic_agent.metricbeat
[elastic_agent.metricbeat][error] Exiting: data path already locked by another beat. Please make sure that multiple beats are not sharing the same data path (path.data).
14:18:48.595
elastic_agent
[elastic_agent][error] metricbeat stderr: "Exiting: data path already locked by another beat. Please make sure that multiple beats are not sharing the same data path (path.data).\n"
14:19:18.274
elastic_agent
[elastic_agent][error] Elastic Agent status changed to "error": "app metricbeat--8.5.0-22b02c28: 1 error occurred:\n\t* 1 error: Error creating runner from config: missing required field accessing 'hosts'\n\n"
14:19:18.275
elastic_agent
[elastic_agent][error] 2022-12-28T09:19:18Z - message: Application: metricbeat--8.5.0[1c0f65fb-eeff-4f06-bc78-31f632aec06f]: State changed to FAILED: 1 error occurred: * 1 error: Error creating runner from config: missing required field accessing 'hosts' - type: 'ERROR' - sub_type: 'FAILED'
Any solution?
Thanks