Logstash jdbc Illegal instant due to time zone offset transition (daylight savings time 'gap'): 1979-03-21

Elastic Stack Logstash
1

Hi
Here is the logstash jdbc input config:

Logstash conf:

input {
  jdbc {
    jdbc_driver_library => "/opt/jdbc/ifxjdbc.jar"
    jdbc_driver_class => "com.informix.jdbc.IfxDriver"
    jdbc_connection_string => "jdbc:informix-sqli://192.168.1.1:12345/mydb:SERVER=srvname;user=user;password=pass"
    jdbc_user => "user"
    jdbc_password => "password"
    schedule => "* * * * *"
    tracking_column => "createdate"
    statement => " 
 select
     *
 from
     mytable field0_
 left outer join
     Data additional1_
         on field0_.ext=additional1_.ext
 left outer join
     Group groups2_
         on field0_.ext=groups2_.ext

Error message when i run logstash:

[WARN ] 2023-05-09 13:40:01.241 [Ruby-0-Thread-26@[main]|input|Jdbc|scheduler_worker-00: :1] jdbc - Exception when executing JDBC query {:exception=>Sequel::DatabaseError, :message=>"Java::OrgJodaTime::IllegalInstantException: Illegal instant due to time zone offset transition (daylight savings time 'gap'): 1979-03-21T00:00:00.000 (Asia/Aden)", :cause=>"#<Java::OrgJodaTime::IllegalInstantException: Illegal instant due to time zone offset transition (daylight savings time 'gap'): 1979-03-21T00:00:00.000 (Asia/Aden)>"}

when i run query on database return this:

id                                 alternatecurrency             createdate                     lastupdate
1234567891234564                   USD                           5/28/2022 4:02:57 PM           11/14/2022 3:19:26 PM

Any idea?
Thanks

2

After add jvm parameter to elasticsearch config file problem solved:

vi /etc/elasticsearch/jvm.options

Add this line:
-Duser.timezone=+0330

1 Like
3

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