Logstash jdbc input plugin pagination not working on version 7.4.2

Elastic Stack Logstash
1

Using jdbc input plugin, pagination is not working on version 7.4.2. Using version 7.0.0 it works fine.

Any ideas what's missing?

Logstash config:

input {
  jdbc {
    jdbc_driver_library => "${LOGSTASH_LIB_DIR}/mysql-connector-java.jar"
    jdbc_driver_class => "com.mysql.jdbc.Driver"
    jdbc_connection_string => "jdbc:${DATABASE_URL}?sessionVariables=group_concat_max_len=1000000"
    jdbc_user => "${DATABASE_USER}"
    jdbc_password => "${DATABASE_PASSWORD}"
    statement_filepath => "${LOGSTASH_CFG_DIR}/sample.sql"
    jdbc_page_size => 100000
    jdbc_paging_enabled => true
  }
}

output {
  elasticsearch {
    hosts => [ "${ES_HOST}" ]
    index => "index"
    document_id => "%{id}"
  }
}
2

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