Problem with Logstash and Influxdb

Hi folks,

I read a mysql table by logstash and I want save output in influxdb.

The problem I've found is that timestamp generated by logstash matches whit any of them, then when the data is saved in Influx only saved those in which they are different, so I lose data. I upload a image.

My logstash config:

input {
    jdbc {
        jdbc_driver_library => "/opt/mysql-connector-java-5.1.36-bin.jar"
        jdbc_connection_string => "jdbc:mysql://172.16.90.192:3306/zabbix"
        jdbc_driver_class => "com.mysql.jdbc.Driver"
        jdbc_user => "root"
        jdbc_password => 'XXXX'
       statement => "SELECT priority, count(triggerid) as 'total' FROM zabbix.triggers where status = 0 and value=1 group by priority;"
        schedule => "*/1 * * * *"
        type => "zabbix_alertas"
    }
}
output {
    if [type] == "zabbix_alertas" {
        stdout  {codec => rubydebug}
        influxdb {
            host => "172.16.90.3"
            port => 8086
            db => "zabbix"
            measurement => "zabbix_alertas"
            send_as_tags => ["priority"]
            data_points => {
                "priority1" => "%{priority}"
                "total1" =>  "%{total}"
            }
        }
    }
}

I see 6 rows, but only save in influxdb 3 of them.


Someone have encountered this problem? how do I solve it? Help please.

Thank you so much!