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

**URL:** <https://discuss.elastic.co/t/logstash-jdbc-illegal-instant-due-to-time-zone-offset-transition-daylight-savings-time-gap-1979-03-21/332902>\
**Category:** Logstash\
**Created:** [May 9, 2023, 10:19am UTC](https://discuss.elastic.co/t/logstash-jdbc-illegal-instant-due-to-time-zone-offset-transition-daylight-savings-time-gap-1979-03-21/332902 "2023-05-09T10:19:49Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Indeed2000](https://avatars.discourse-cdn.com/v4/letter/i/dc4da7/32.png) [@Indeed2000](https://discuss.elastic.co/u/Indeed2000)\
**Post date:** [May 9, 2023, 10:19am UTC](https://discuss.elastic.co/t/logstash-jdbc-illegal-instant-due-to-time-zone-offset-transition-daylight-savings-time-gap-1979-03-21/332902/1 "2023-05-09T10:19:49Z")

</div>

Hi  
Here is the logstash jdbc input config:

Logstash conf:

```auto
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:

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

```

Any idea?  
Thanks

---

<div class="post-metadata">

**Author:** ![Indeed2000](https://avatars.discourse-cdn.com/v4/letter/i/dc4da7/32.png) [@Indeed2000](https://discuss.elastic.co/u/Indeed2000)\
**Post date:** [May 11, 2023, 5:59am UTC](https://discuss.elastic.co/t/logstash-jdbc-illegal-instant-due-to-time-zone-offset-transition-daylight-savings-time-gap-1979-03-21/332902/2 "2023-05-11T05:59:11Z")

</div>

After add jvm parameter to elasticsearch config file problem solved:

vi /etc/elasticsearch/jvm.options

Add this line:  
-Duser.timezone=+0330

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [June 8, 2023, 5:59am UTC](https://discuss.elastic.co/t/logstash-jdbc-illegal-instant-due-to-time-zone-offset-transition-daylight-savings-time-gap-1979-03-21/332902/3 "2023-06-08T05:59:56Z")

</div>

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