MySQL module: Configuration

Md_Saidur_Rahman · April 25, 2020, 11:17am

"mysql":common.MapStr{"status":common.MapStr{"aborted":common.MapStr{"clients":4455, "connects":40436}, "binlog":common.MapStr{"cache":common.MapStr{"disk_use":654, "use":5608}}, "bytes":common.MapStr{"received":273635898, "sent":609549224}, "command":common.MapStr{"delete":71, "insert":304352, "select":335184, "update":1394}, "connections":75527, "created":common.MapStr{"tmp":common.MapStr{"disk_tables":42392, "files":190, "tables":268100}}, "delayed":common.MapStr{"errors":0, "insert_threads":0, "writes":0}, "flush_commands":1, "max_used_connections":311, "open":common.MapStr{"files":6, "streams":0, "tables":64}, "opened_tables":52359, "threads":common.MapStr{"cached":21, "connected":139, "created":874, "running":6}}}, "service":common.MapStr{"address":"10.88.250.118:3306", "type":"mysql"}}, Private:interface {}(nil), TimeSeries:true}, Flags:0x0} (status=403): {"type":"cluster_block_exception","reason":"index [metricbeat-7.2.1-2020.04.16-000001] blocked by: [FORBIDDEN/12/index read-only / allow delete (api)];"}
2020-04-25T12:17:27.899+0600    WARN    elasticsearch/client.go:527     Cannot index event publisher.Event{Content:beat.Event{Timestamp:time.Time{wall:0xbfa1135daca19c36, ext:3138686933, loc:(*time.Location)(0x51442a0)}, Meta:common.MapStr(nil), Fields:common.MapStr{"agent":common.MapStr{"ephemeral_id":"924c5954-0b12-4247-aa55-d82f04d83361", "hostname":"ltdb.kpp.com", "id":"8fb83fcc-7a27-4d16-abbe-8d2997882b38", "type":"metricbeat", "version":"7.2.1"}, "ecs":common.MapStr{"version":"1.0.0"}, "event":common.MapStr{"dataset":"system.process.summary", "duration":132440882, "module":"system"}, "host":common.MapStr{"architecture":"x86_64", "containerized":false, "hostname":"ltdb.kpp.com", "id":"8e10311cf2a147a2ab615c47becc2358", "name":"ltdb.kpp.com", "os":common.MapStr{"family":"", "kernel":"4.1.12-124.33.4.el7uek.x86_64", "name":"Oracle Linux Server", "platform":"ol", "version":"7.8"}}, "metricset":common.MapStr{"name":"process_summary"}, "service":common.MapStr{"type":"system"}, "system":common.MapStr{"process":common.MapStr{"summary":common.MapStr{"dead":0, "idle":0, "running":2, "sleeping":331, "stopped":0, "total":333, "unknown":0, "zombie":0}}}}, Private:interface {}(nil), TimeSeries:true}, Flags:0x0} (status=403): {"type":"cluster_block_exception","reason":"index [metricbeat-7.2.1-2020.04.16-000001] blocked by: [FORBIDDEN/12/index read-only / allow delete (api)];"}
2020-04-25T12:17:27.899+0600    WARN    elasticsearch/client.go:527     Cannot index event publisher.Event{Content:beat.Event{Timestamp:time.Time{wall:0xbfa1135dac3a39c3, ext:3131911580, loc:(*time.Location)(0x51442a0)}, Meta:common.MapStr(nil), Fields:common.MapStr{"agent":common.MapStr{"ephemeral_id":"924c5954-0b12-4247-aa55-d82f04d83361", "hostname":"ltdb.kpp.com", "id":"8fb83fcc-7a27-4d16-abbe-8d2997882b38", "type":"metricbeat", "version":"7.2.1"}, "ecs":common.MapStr{"version":"1.0.0"}, "event":common.MapStr{"dataset":"system.socket.summary", "duration":191403016, "module":"system"}, "host":common.MapStr{"architecture":"x86_64", "containerized":false, "hostname":"ltdb.kpp.com", "id":"8e10311cf2a147a2ab615c47becc2358", "name":"ltdb.kpp.com", "os":common.MapStr{"family":"", "kernel":"4.1.12-124.33.4.el7uek.x86_64", "name":"Oracle Linux Server", "platform":"ol", "version":"7.8"}}, "metricset":common.MapStr{"name":"socket_summary"}, "service":common.MapStr{"type":"system"}, "system":common.MapStr{"socket":common.MapStr{"summary":common.MapStr{"all":common.MapStr{"count":240, "listening":17}, "tcp":common.MapStr{"all":common.MapStr{"close_wait":0, "count":233, "established":210, "listening":17, "orphan":0, "time_wait":6}, "memory":0}, "udp":common.MapStr{"all":common.MapStr{"count":7}, "memory":12288}}}}}, Private:interface {}(nil), TimeSeries:true}, Flags:0x0} (status=403): {"type":"cluster_block_exception","reason":"index [metricbeat-7.2.1-2020.04.16-000001] blocked by: [FORBIDDEN/12/index read-only / allow delete (api)];"}
2020-04-25T12:17:27.899+0600    WARN    elasticsearch/client.go:527     Cannot index event publisher.Event{Content:beat.Event{Timestamp:time.Time{wall:0xbfa1135dac260183, ext:3130586393, loc:(*time.Location)(0x51442a0)}, Meta:common.MapStr(nil), Fields:common.MapStr{"agent":common.MapStr{"ephemeral_id":"924c5954-0b12-4247-aa55-d82f04d83361", "hostname":"ltdb.kpp.com", "id":"8fb83fcc-7a27-4d16-abbe-8d2997882b38", "type":"metricbeat", "version":"7.2.1"}, "ecs":common.MapStr{"version":"1.0.0"}, "event":common.MapStr{"dataset":"system.process", "duration":369635668, "module":"system"}, "host":common.MapStr{"architecture":"x86_64", "containerized":false, "hostname":"ltdb.kpp.com", "id":"8e10311cf2a147a2ab615c47becc2358", "name":"ltdb.kpp.com", "os":common.MapStr{"family":"", "kernel":"4.1.12-124.33.4.el7uek.x86_64", "name":"Oracle Linux Server", "platform":"ol", "version":"7.8"}}, "metricset":common.MapStr{"name":"process"}, "process":common.MapStr{"args":[]string{"/usr/lib/systemd/systemd", "--system", "--deserialize", "25"}, "executable":"/usr/lib/systemd/systemd", "name":"systemd", "pgid":1, "pid":1, "ppid":0, "working_directory":"/"}, "service":common.MapStr{"type":"system"}, "system":common.MapStr{"process":common.MapStr{"cmdline":"/usr/lib/systemd/systemd --system --deserialize 25", "cpu":common.MapStr{"start_time":common.Time{wall:0x0, ext:63719640597, loc:(*time.Location)(nil)}, "total":common.MapStr{"norm":common.MapStr{"pct":0}, "pct":0, "value":0}}, "fd":common.MapStr{"limit":common.MapStr{"hard":0x100000, "soft":0x100000}, "open":0x82}, "memory":common.MapStr{"rss":common.MapStr{"bytes":0x7ba000, "pct":0.001}, "share":0x4bd000, "size":0xbdb8000}, "state":"sleeping"}}, "user":common.MapStr{"name":"root"}}, Private:interface {}(nil), TimeSeries:true}, Flags:0x0} (status=403): {"type":"cluster_block_exception","reason":"index [metricbeat-7.2.1-2020.04.16-000001] blocked by: [FORBIDDEN/12/index read-only / allow delete (api)];"}
2020-04-25T12:17:27.899+0600    WARN    elasticsearch/client.go:527     Cannot index event publisher.Event{Content:beat.Event{Timestamp:time.Time{wall:0xbfa1135dac260183, ext:3130586393, loc:(*time.Location)(0x51442a0)}, Meta:common.MapStr(nil), Fields:common.MapStr{"agent":common.MapStr{"ephemeral_id":"924c5954-0b12-4247-aa55-d82f04d83361", "hostname":"ltdb.kpp.com", "id":"8fb83fcc-7a27-4d16-abbe-8d2997882b38", "type":"metricbeat", "version":"7.2.1"}, "ecs":common.MapStr{"version":"1.0.0"}, "event":common.MapStr{"dataset":"system.process", "duration":369690549, "module":"system"}, "host":common.MapStr{"architecture":"x86_64", "containerized":false, "hostname":"ltdb.kpp.com", "id":"8e10311cf2a147a2ab615c47becc2358", "name":"ltdb.kpp.com", "os":common.MapStr{"family":"", "kernel":"4.1.12-124.33.4.el7uek.x86_64", "name":"Oracle Linux Server", "platform":"ol", "version":"7.8"}}, "metricset":common.MapStr{"name":"process"}, "process":common.MapStr{"name":"kthreadd", "pgid":0, "pid":2, "ppid":0}, "service":common.MapStr{"type":"system"}, "system":common.MapStr{"process":common.MapStr{"cpu":common.MapStr{"start_time":common.Time{wall:0x0, ext:63719640597, loc:(*time.Location)(nil)}, "total":common.MapStr{"norm":common.MapStr{"pct":0}, "pct":0, "value":0}}, "fd":common.MapStr{"limit":common.MapStr{"hard":0x1000, "soft":0x400}, "open":0x0}, "memory":common.MapStr{"rss":common.MapStr{"bytes":0x0, "pct":0}, "share":0x0, "size":0x0}, "state":"sleeping"}}, "user":common.MapStr{"name":"root"}}, Private:interface {}(nil), TimeSeries:true}, Flags:0x0} (status=403): {"type":"cluster_block_exception","reason":"index [metricbeat-7.2.1-2020.04.16-000001] blocked by: [FORBIDDEN/12/index read-only / allow delete (api)];"}
2020-04-25T12:17:27.900+0600    WARN    elasticsearch/client.go:527     Cannot index event publisher.Event{Content:beat.Event{Timestamp:time.Time{wall:0xbfa1135dac260183, ext:3130586393, loc:(*time.Location)(0x51442a0)}, Meta:common.MapStr(nil), Fields:common.MapStr{"agent":common.MapStr{"ephemeral_id":"924c5954-0b12-4247-aa55-d82f04d83361", "hostname":"ltdb.kpp.com", "id":"8fb83fcc-7a27-4d16-abbe-8d2997882b38", "type":"metricbeat", "version":"7.2.1"}, "ecs":common.MapStr{"version":"1.0.0"}, "event":common.MapStr{"dataset":"system.process", "duration":369703597, "module":"system"}, "host":common.MapStr{"architecture":"x86_64", "containerized":false, "hostname":"ltdb.kpp.com", "id":"8e10311cf2a147a2ab615c47becc2358", "name":"ltdb.kpp.com", "os":common.MapStr{"family":"", "kernel":"4.1.12-124.33.4.el7uek.x86_64", "name":"Oracle Linux Server", "platform":"ol", "version":"7.8"}}, "metricset":common.MapStr{"name":"process"}, "process":common.MapStr{"name":"ksoftirqd/0", "pgid":0, "pid":3, "ppid":2}, "service":common.MapStr{"type":"system"}, "system":common.MapStr{"process":common.MapStr{"cpu":common.MapStr{"start_time":common.Time{wall:0x0, ext:63719640597, loc:(*time.Location)(nil)}, "total":common.MapStr{"norm":common.MapStr{"pct":0}, "pct":0, "value":0}}, "fd":common.MapStr{"limit":common.MapStr{"hard":0x1000, "soft":0x400}, "open":0x0}, "memory":common.MapStr{"rss":common.MapStr{"bytes":0x0, "pct":0}, "share":0x0, "size":0x0}, "state":"sleeping"}}, "user":common.MapStr{"name":"root"}}, Private:interface {}(nil), TimeSeries:true}, Flags:0x0} (status=403): {"type":"cluster_block_exception","reason":"index [metricbeat-7.2.1-2020.04.16-000001] blocked by: [FORBIDDEN/12/index read-only / allow delete (api)];"}
2020-04-25T12:17:27.900+0600    WARN    elasticsearch/client.go:527     Cannot index event publisher.Event{Content:beat.Event{Timestamp:time.Time{wall:0xbfa1135dac260183, ext:3130586393, loc:(*time.Location)(0x51442a0)}, Meta:common.MapStr(nil), Fields:common.MapStr{"agent":common.MapStr{"ephemeral_id":"924c5954-0b12-4247-aa55-d82f04d83361", "hostname":"ltdb.kpp.com", "id":"8fb83fcc-7a27-4d16-abbe-8d2997882b38", "type":"metricbeat", "version":"7.2.1"}, "ecs":common.MapStr{"version":"1.0.0"}, "event":common.MapStr{"dataset":"system.process", "duration":370354567, "module":"system"}, "host":common.MapStr{"architecture":"x86_64", "containerized":false, "hostname":"ltdb.kpp.com", "id":"8e10311cf2a147a2ab615c47becc2358", "name":"ltdb.kpp.com", "os":common.MapStr{"family":"", "kernel":"4.1.12-124.33.4.el7uek.x86_64", "name":"Oracle Linux Server", "platform":"ol", "version":"7.8"}}, "metricset":common.MapStr{"name":"process"}, "process":common.MapStr{"name":"kworker/0:0H", "pgid":0, "pid":5, "ppid":2}, "service":common.MapStr{"type":"system"}, "system":common.MapStr{"process":common.MapStr{"cpu":common.MapStr{"start_time":common.Time{wall:0x0, ext:63719640597, loc:(*time.Location)(nil)}, "total":common.MapStr{"norm":common.MapStr{"pct":0}, "pct":0, "value":0}}, "fd":common.MapStr{"limit":common.MapStr{"hard":0x1000, "soft":0x400}, "open":0x0}, "memory":common.MapStr{"rss":common.MapStr{"bytes":0x0, "pct":0}, "share":0x0, "size":0x0}, "state":"sleeping"}}, "user":common.MapStr{"name":"root"}}, Private:interface {}(nil), TimeSeries:true}, Flags:0x0} (status=403): {"type":"cluster_block_exception","reason":"index [metricbeat-7.2.1-2020.04.16-000001] blocked by: [FORBIDDEN/12/index read-only / allow delete (api)];"}

Md_Saidur_Rahman · April 25, 2020, 11:21am

@shaunak Thank you for your investigation regarding this issue. If you find any issue please let me know.

2020-04-25T12:17:27.900+0600    WARN    elasticsearch/client.go:527     Cannot index event publisher.Event{Content:beat.Event{Timestamp:time.Time{wall:0xbfa1135dac260183, ext:3130586393, loc:(*time.Location)(0x51442a0)}, Meta:common.MapStr(nil), Fields:common.MapStr{"agent":common.MapStr{"ephemeral_id":"924c5954-0b12-4247-aa55-d82f04d83361", "hostname":"ltdb.kpp.com", "id":"8fb83fcc-7a27-4d16-abbe-8d2997882b38", "type":"metricbeat", "version":"7.2.1"}, "ecs":common.MapStr{"version":"1.0.0"}, "event":common.MapStr{"dataset":"system.process", "duration":370673092, "module":"system"}, "host":common.MapStr{"architecture":"x86_64", "containerized":false, "hostname":"ltdb.kpp.com", "id":"8e10311cf2a147a2ab615c47becc2358", "name":"ltdb.kpp.com", "os":common.MapStr{"family":"", "kernel":"4.1.12-124.33.4.el7uek.x86_64", "name":"Oracle Linux Server", "platform":"ol", "version":"7.8"}}, "metricset":common.MapStr{"name":"process"}, "process":common.MapStr{"name":"rcu_sched", "pgid":0, "pid":7, "ppid":2}, "service":common.MapStr{"type":"system"}, "system":common.MapStr{"process":common.MapStr{"cpu":common.MapStr{"start_time":common.Time{wall:0x0, ext:63719640597, loc:(*time.Location)(nil)}, "total":common.MapStr{"norm":common.MapStr{"pct":0}, "pct":0, "value":0}}, "fd":common.MapStr{"limit":common.MapStr{"hard":0x1000, "soft":0x400}, "open":0x0}, "memory":common.MapStr{"rss":common.MapStr{"bytes":0x0, "pct":0}, "share":0x0, "size":0x0}, "state":"running"}}, "user":common.MapStr{"name":"root"}}, Private:interface {}(nil), TimeSeries:true}, Flags:0x0} (status=403): {"type":"cluster_block_exception","reason":"index [metricbeat-7.2.1-2020.04.16-000001] blocked by: [FORBIDDEN/12/index read-only / allow delete (api)];"}
2020-04-25T12:17:27.900+0600    WARN    elasticsearch/client.go:527     Cannot index event publisher.Event{Content:beat.Event{Timestamp:time.Time{wall:0xbfa1135dac260183, ext:3130586393, loc:(*time.Location)(0x51442a0)}, Meta:common.MapStr(nil), Fields:common.MapStr{"agent":common.MapStr{"ephemeral_id":"924c5954-0b12-4247-aa55-d82f04d83361", "hostname":"ltdb.kpp.com", "id":"8fb83fcc-7a27-4d16-abbe-8d2997882b38", "type":"metricbeat", "version":"7.2.1"}, "ecs":common.MapStr{"version":"1.0.0"}, "event":common.MapStr{"dataset":"system.process", "duration":370923902, "module":"system"}, "host":common.MapStr{"architecture":"x86_64", "containerized":false, "hostname":"ltdb.kpp.com", "id":"8e10311cf2a147a2ab615c47becc2358", "name":"ltdb.kpp.com", "os":common.MapStr{"family":"", "kernel":"4.1.12-124.33.4.el7uek.x86_64", "name":"Oracle Linux Server", "platform":"ol", "version":"7.8"}}, "metricset":common.MapStr{"name":"process"}, "process":common.MapStr{"args":[]string{"ora_dbw0_ltdb"}, "executable":"/u01/app/oracle/product/12.2.0/dbhome_1/bin/oracle", "name":"ora_dbw0_ltdb", "pgid":9253, "pid":9253, "ppid":1, "working_directory":"/u01/app/oracle/product/12.2.0/dbhome_1/dbs"}, "service":common.MapStr{"type":"system"}, "system":common.MapStr{"process":common.MapStr{"cmdline":"ora_dbw0_ltdb", "cpu":common.MapStr{"start_time":common.Time{wall:0x0, ext:63719671888, loc:(*time.Location)(nil)}, "total":common.MapStr{"norm":common.MapStr{"pct":0}, "pct":0, "value":0}}, "fd":common.MapStr{"limit":common.MapStr{"hard":0x10000, "soft":0x10000}, "open":0x10}, "memory":common.MapStr{"rss":common.MapStr{"bytes":0x628e9000, "pct":0.2041}, "share":0x620db000, "size":0xac953000}, "state":"sleeping"}}, "user":common.MapStr{"name":"oracle"}}, Private:interface {}(nil), TimeSeries:true}, Flags:0x0} (status=403): {"type":"cluster_block_exception","reason":"index [metricbeat-7.2.1-2020.04.16-000001] blocked by: [FORBIDDEN/12/index read-only / allow delete (api)];"}
2020-04-25T12:17:27.901+0600    WARN    elasticsearch/client.go:527     Cannot index event publisher.Event{Content:beat.Event{Timestamp:time.Time{wall:0xbfa1135dac260183, ext:3130586393, loc:(*time.Location)(0x51442a0)}, Meta:common.MapStr(nil), Fields:common.MapStr{"agent":common.MapStr{"ephemeral_id":"924c5954-0b12-4247-aa55-d82f04d83361", "hostname":"ltdb.kpp.com", "id":"8fb83fcc-7a27-4d16-abbe-8d2997882b38", "type":"metricbeat", "version":"7.2.1"}, "ecs":common.MapStr{"version":"1.0.0"}, "event":common.MapStr{"dataset":"system.process", "duration":371196458, "module":"system"}, "host":common.MapStr{"architecture":"x86_64", "containerized":false, "hostname":"ltdb.kpp.com", "id":"8e10311cf2a147a2ab615c47becc2358", "name":"ltdb.kpp.com", "os":common.MapStr{"family":"", "kernel":"4.1.12-124.33.4.el7uek.x86_64", "name":"Oracle Linux Server", "platform":"ol", "version":"7.8"}}, "metricset":common.MapStr{"name":"process"}, "process":common.MapStr{"args":[]string{"ora_mman_ltdb"}, "executable":"/u01/app/oracle/product/12.2.0/dbhome_1/bin/oracle", "name":"ora_mman_ltdb", "pgid":9229, "pid":9229, "ppid":1, "working_directory":"/u01/app/oracle/product/12.2.0/dbhome_1/dbs"}, "service":common.MapStr{"type":"system"}, "system":common.MapStr{"process":common.MapStr{"cmdline":"ora_mman_ltdb", "cpu":common.MapStr{"start_time":common.Time{wall:0x0, ext:63719671888, loc:(*time.Location)(nil)}, "total":common.MapStr{"norm":common.MapStr{"pct":0}, "pct":0, "value":0}}, "fd":common.MapStr{"limit":common.MapStr{"hard":0x10000, "soft":0x10000}, "open":0x9}, "memory":common.MapStr{"rss":common.MapStr{"bytes":0x56dac000, "pct":0.1799}, "share":0x56d61000, "size":0xaba01000}, "state":"sleeping"}}, "user":common.MapStr{"name":"oracle"}}, Private:interface {}(nil), TimeSeries:true}, Flags:0x0} (status=403): {"type":"cluster_block_exception","reason":"index [metricbeat-7.2.1-2020.04.16-000001] blocked by: [FORBIDDEN/12/index read-only / allow delete (api)];"}
2020-04-25T12:17:27.901+0600    WARN    elasticsearch/client.go:527     Cannot index event publisher.Event{Content:beat.Event{Timestamp:time.Time{wall:0xbfa1135dac260183, ext:3130586393, loc:(*time.Location)(0x51442a0)}, Meta:common.MapStr(nil), Fields:common.MapStr{"agent":common.MapStr{"ephemeral_id":"924c5954-0b12-4247-aa55-d82f04d83361", "hostname":"ltdb.kpp.com", "id":"8fb83fcc-7a27-4d16-abbe-8d2997882b38", "type":"metricbeat", "version":"7.2.1"}, "ecs":common.MapStr{"version":"1.0.0"}, "event":common.MapStr{"dataset":"system.process", "duration":371524230, "module":"system"}, "host":common.MapStr{"architecture":"x86_64", "containerized":false, "hostname":"ltdb.kpp.com", "id":"8e10311cf2a147a2ab615c47becc2358", "name":"ltdb.kpp.com", "os":common.MapStr{"family":"", "kernel":"4.1.12-124.33.4.el7uek.x86_64", "name":"Oracle Linux Server", "platform":"ol", "version":"7.8"}}, "metricset":common.MapStr{"name":"process"}, "process":common.MapStr{"args":[]string{"ora_cjq0_ltdb"}, "executable":"/u01/app/oracle/product/12.2.0/dbhome_1/bin/oracle", "name":"ora_cjq0_ltdb", "pgid":9348, "pid":9348, "ppid":1, "working_directory":"/u01/app/oracle/product/12.2.0/dbhome_1/dbs"}, "service":common.MapStr{"type":"system"}, "system":common.MapStr{"process":common.MapStr{"cmdline":"ora_cjq0_ltdb", "cpu":common.MapStr{"start_time":common.Time{wall:0x0, ext:63719671894, loc:(*time.Location)(nil)}, "total":common.MapStr{"norm":common.MapStr{"pct":0}, "pct":0, "value":0}}, "fd":common.MapStr{"limit":common.MapStr{"hard":0x10000, "soft":0x10000}, "open":0xc}, "memory":common.MapStr{"rss":common.MapStr{"bytes":0x47e8d000, "pct":0.1489}, "share":0x47a77000, "size":0xabf39000}, "state":"sleeping"}}, "user":common.MapStr{"name":"oracle"}}, Private:interface {}(nil), TimeSeries:true}, Flags:0x0} (status=403): {"type":"cluster_block_exception","reason":"index [metricbeat-7.2.1-2020.04.16-000001] blocked by: [FORBIDDEN/12/index read-only / allow delete (api)];"}
2020-04-25T12:17:27.902+0600    WARN    elasticsearch/client.go:527     Cannot index event publisher.Event{Content:beat.Event{Timestamp:time.Time{wall:0xbfa1135dac260183, ext:3130586393, loc:(*time.Location)(0x51442a0)}, Meta:common.MapStr(nil), Fields:common.MapStr{"agent":common.MapStr{"ephemeral_id":"924c5954-0b12-4247-aa55-d82f04d83361", "hostname":"ltdb.kpp.com", "id":"8fb83fcc-7a27-4d16-abbe-8d2997882b38", "type":"metricbeat", "version":"7.2.1"}, "ecs":common.MapStr{"version":"1.0.0"}, "event":common.MapStr{"dataset":"system.process", "duration":371779609, "module":"system"}, "host":common.MapStr{"architecture":"x86_64", "containerized":false, "hostname":"ltdb.kpp.com", "id":"8e10311cf2a147a2ab615c47becc2358", "name":"ltdb.kpp.com", "os":common.MapStr{"family":"", "kernel":"4.1.12-124.33.4.el7uek.x86_64", "name":"Oracle Linux Server", "platform":"ol", "version":"7.8"}}, "metricset":common.MapStr{"name":"process"}, "process":common.MapStr{"args":[]string{"/usr/sbin/mysqld"}, "executable":"/usr/sbin/mysqld", "name":"mysqld", "pgid":32113, "pid":32113, "ppid":1, "working_directory":"/var/lib/mysql"}, "service":common.MapStr{"type":"system"}, "system":common.MapStr{"process":common.MapStr{"cmdline":"/usr/sbin/mysqld", "cpu":common.MapStr{"start_time":common.Time{wall:0x0, ext:63722988016, loc:(*time.Location)(nil)}, "total":common.MapStr{"norm":common.MapStr{"pct":0}, "pct":0, "value":0}}, "fd":common.MapStr{"limit":common.MapStr{"hard":0x3fec, "soft":0x3fec}, "open":0x188}, "memory":common.MapStr{"rss":common.MapStr{"bytes":0x35e99000, "pct":0.1117}, "share":0xb98000, "size":0xabb3d000}, "state":"sleeping"}}, "user":common.MapStr{"name":"mysql"}}, Private:interface {}(nil), TimeSeries:true}, Flags:0x0} (status=403): {"type":"cluster_block_exception","reason":"index [metricbeat-7.2.1-2020.04.16-000001] blocked by: [FORBIDDEN/12/index read-only / allow delete (api)];"}
2020-04-25T12:17:27.902+0600    WARN    elasticsearch/client.go:527     Cannot index event publisher.Event{Content:beat.Event{Timestamp:time.Time{wall:0xbfa1135dac260183, ext:3130586393, loc:(*time.Location)(0x51442a0)}, Meta:common.MapStr(nil), Fields:common.MapStr{"agent":common.MapStr{"ephemeral_id":"924c5954-0b12-4247-aa55-d82f04d83361", "hostname":"ltdb.kpp.com", "id":"8fb83fcc-7a27-4d16-abbe-8d2997882b38", "type":"metricbeat", "version":"7.2.1"}, "ecs":common.MapStr{"version":"1.0.0"}, "event":common.MapStr{"dataset":"system.process", "duration":372032222, "module":"system"}, "host":common.MapStr{"architecture":"x86_64", "containerized":false, "hostname":"ltdb.kpp.com", "id":"8e10311cf2a147a2ab615c47becc2358", "name":"ltdb.kpp.com", "os":common.MapStr{"family":"", "kernel":"4.1.12-124.33.4.el7uek.x86_64", "name":"Oracle Linux Server", "platform":"ol", "version":"7.8"}}, "metricset":common.MapStr{"name":"process"}, "process":common.MapStr{"args":[]string{"ora_smon_ltdb"}, "executable":"/u01/app/oracle/product/12.2.0/dbhome_1/bin/oracle", "name":"ora_smon_ltdb", "pgid":9267, "pid":9267, "ppid":1, "working_directory":"/u01/app/oracle/product/12.2.0/dbhome_1/dbs"}, "service":common.MapStr{"type":"system"}, "system":common.MapStr{"process":common.MapStr{"cmdline":"ora_smon_ltdb", "cpu":common.MapStr{"start_time":common.Time{wall:0x0, ext:63719671888, loc:(*time.Location)(nil)}, "total":common.MapStr{"norm":common.MapStr{"pct":0}, "pct":0, "value":0}}, "fd":common.MapStr{"limit":common.MapStr{"hard":0x10000, "soft":0x10000}, "open":0xd}, "memory":common.MapStr{"rss":common.MapStr{"bytes":0x265ac000, "pct":0.0794}, "share":0x26337000, "size":0xabce5000}, "state":"sleeping"}}, "user":common.MapStr{"name":"oracle"}}, Private:interface {}(nil), TimeSeries:true}, Flags:0x0} (status=403): {"type":"cluster_block_exception","reason":"index [metricbeat-7.2.1-2020.04.16-000001] blocked by: [FORBIDDEN/12/index read-only / allow delete (api)];"}
2020-04-25T12:17:27.942+0600    DEBUG   [publisher]     memqueue/ackloop.go:160 ackloop: receive ack [0: 0, 25]
2020-04-25T12:17:27.942+0600    DEBUG   [publisher]     memqueue/eventloop.go:535       broker ACK events: count=19, start-seq=1, end-seq=19

2020-04-25T12:17:27.942+0600    DEBUG   [publisher]     memqueue/eventloop.go:535       broker ACK events: count=1, start-seq=1, end-seq=1

2020-04-25T12:17:27.942+0600    DEBUG   [publisher]     memqueue/eventloop.go:535       broker ACK events: count=4, start-seq=1, end-seq=4

2020-04-25T12:17:27.942+0600    DEBUG   [publisher]     memqueue/eventloop.go:535       broker ACK events: count=1, start-seq=1, end-seq=1

2020-04-25T12:17:27.942+0600    DEBUG   [publisher]     memqueue/ackloop.go:128 ackloop: return ack to broker loop:25
2020-04-25T12:17:27.942+0600    DEBUG   [publisher]     memqueue/ackloop.go:131 ackloop:  done send ack
2020-04-25T12:17:36.742+0600    DEBUG   [processors]    processing/processors.go:183    Publish event: {
  "@timestamp": "2020-04-25T06:17:36.742Z",

Best Regards,
Md. Saidur Rahman

Md_Saidur_Rahman · May 6, 2020, 8:31pm

@shaunak Thank you for your support. SQL module is working properly after deleting dashboard and creating new one.

system · June 3, 2020, 8:31pm

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

Topic		Replies	Views
Metricbeat/mysql module data not showing Beats metricbeat	3	490	February 27, 2021
Mysql Module not retrieving data Beats metricbeat	7	775	January 13, 2020
Configure MySQL module Beats filebeat	3	740	March 22, 2018
Packetbeat mysql only works if metricbeat mysql enabled? Beats packetbeat , metricbeat	3	199	February 28, 2024
MySQL metricbeat module error Beats metricbeat	1	609	October 29, 2021

MySQL module: Configuration

Related topics