Filebeat+kafka+logstash+es data storage exception

the configuration file is as follows:

< hr > < H2 >-filebeat-< / H2 >
  • type: log
    enabled: true
    paths:

    • / var/log/nginx/userapi.access.log

json.message_key: true
json.keys_under_root: true
json.overwrite_keys: true
tail_files: true
fields:

log_topics: nginx_access.userapi
  • type: log
    enabled: true
    paths:

    • / var/log/nginx/openapi.access.log

json.message_key: true
json.keys_under_root: true
json.overwrite_keys: true
tail_files: true
fields:

log_topics: nginx_access.openapi
  • type: log
    enabled: true
    paths:

    • / var/log/nginx/productapi.access.log

json.message_key: true
json.keys_under_root: true
json.overwrite_keys: true
tail_files: true
fields:

log_topics: nginx_access.productapi

< hr > < H2 >-logstash-< / H2 >

1, openapi.conf
[root@staus conf.d]-sharp cat openapi.conf
input {

kafka {
    codec => "json"
    topics => ["nginx_access.openapi"]
    bootstrap_servers => "127.0.0.1:9092"
    enable_auto_commit => true
    auto_commit_interval_ms => "1000"
auto_offset_reset => "earliest"
}

}
output {

      elasticsearch {
            hosts => ["http://127.0.0.1:9200"]
            index => "nginx_access.openapi-%{+YYYY.MM.dd}"
      }

}

2, product.conf
[root@staus conf.d]-sharp cat product.conf
input {

kafka {
    codec => "json"
    topics => ["nginx_access.productapi"]
    bootstrap_servers => "127.0.0.1:9092"
    consumer_threads => 2
    enable_auto_commit => true
    auto_commit_interval_ms => "1000"
}

}
output {

      elasticsearch {
            hosts => ["http://127.0.0.1:9200"]
            index =>"nginx_access.productapi-%{+YYYY.MM.dd}"
            template_overwrite => true
      }

}

3, userapi.conf
input {

kafka {
    codec => "json"
    topics => ["nginx_access.userapi"]
    bootstrap_servers => "127.0.0.1:9092"
    consumer_threads => 2
    enable_auto_commit => true
    auto_commit_interval_ms => "1000"
}

}
output {

      elasticsearch {
            hosts => ["http://127.0.0.1:9200"]
            index =>"nginx_access.userapi-%{+YYYY.MM.dd}"
            template_overwrite => true
      }

}

-index storage exception is as follows

------- logstash

Elk
Apr.24,2021
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b2b7b2-2ba98.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b2b7b2-2ba98.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?