# java.lang.OutOfMemoryError: Java heap space with proc statement

**URL:** <https://discuss.elastic.co/t/java-lang-outofmemoryerror-java-heap-space-with-proc-statement/269230>\
**Category:** Logstash\
**Created:** [April 5, 2021, 11:59am UTC](https://discuss.elastic.co/t/java-lang-outofmemoryerror-java-heap-space-with-proc-statement/269230 "2021-04-05T11:59:33Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![schmitt\_kevin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/schmitt_kevin/32/86553_2.png) [@schmitt\_kevin](https://discuss.elastic.co/u/schmitt_kevin)\
**Post date:** [April 5, 2021, 11:59am UTC](https://discuss.elastic.co/t/java-lang-outofmemoryerror-java-heap-space-with-proc-statement/269230/1 "2021-04-05T11:59:34Z")

</div>

Hello,

I use logstash with sql procedure statement to insert json in elastic, no problem here.  
But when i use server with less RAM i have error  
java.lang.OutOfMemoryError: Java heap space with proc statement CALL get\_search\_data()  
What parameter i can change for work with server with less capatcities, jdbc\_fetch\_size ?

```
input {

  jdbc {

    jdbc_driver_library => "/usr/share/logstash/bin/mysql-connector-java-8.0.23.jar"

    jdbc_driver_class => "com.mysql.cj.jdbc.Driver"

    jdbc_connection_string => "jdbc:mysql://${DB_HOST}:${DB_PORT}/${DB_NAME}"

    jdbc_user => "${DB_USER}"

    jdbc_password => "${DB_PASSWORD}"

    use_column_value => false

    last_run_metadata_path => "/usr/share/logstash/.logstash_jdbc_last_run"

    jdbc_page_size => 1000

    jdbc_fetch_size => 1000

    clean_run => false

    # schedule => "*/10 * * * * *"

    statement => "CALL get_search_data('${DATE_SQL}')"

    jdbc_default_timezone => "Europe/Paris"

  }

}

filter {

  json {

    source => "availabilities"

    target => "availabilities"

  }

  json {

    source => "results"

    target => "results"

  }

  json {

    source => "boolean_facets"

    target => "booleanFacets"

    remove_field => ["boolean_facets"]

  }

  json {

    source => "string_facets"

    target => "stringFacets"

    remove_field => ["string_facets"]

  }

  json {

    source => "location_facets"

    target => "locationFacets"

    remove_field => ["location_facets"]

  }

  json {

    source => "integer_facets"

    target => "integerFacets"

    remove_field => ["integer_facets"]

  }

  json {

    source => "decimal_facets"

    target => "decimalFacets"

    remove_field => ["decimal_facets"]

  }

  json {

    source => "datetime_facets"

    target => "datetimeFacets"

    remove_field => ["datetime_facets"]

  }

}

output {

  # stdout { codec => rubydebug }

  elasticsearch {

    hosts => ["${ES_HOST}"]

    user => "${ES_USER}"

    password => "${ES_PASSWORD}"

    index => "${ES_INDEX}"

    action => "%{action}"

    document_id => "%{id}"

    manage_template => false

    ssl => true

    ilm_enabled => false

  }

}

```

Thanks

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [April 6, 2021, 1:19am UTC](https://discuss.elastic.co/t/java-lang-outofmemoryerror-java-heap-space-with-proc-statement/269230/2 "2021-04-06T01:19:09Z")

</div>

Welcome to our community! 😃

Yes, I would reduce the page and fetch size to start with.

---

<div class="post-metadata">

**Author:** ![schmitt\_kevin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/schmitt_kevin/32/86553_2.png) [@schmitt\_kevin](https://discuss.elastic.co/u/schmitt_kevin)\
**Post date:** [April 6, 2021, 7:35pm UTC](https://discuss.elastic.co/t/java-lang-outofmemoryerror-java-heap-space-with-proc-statement/269230/3 "2021-04-06T19:35:00Z")

</div>

Thanks,

But same problem with less size

```
`2021-04-06 16:50:00.779501236 +0000 logstash.preprod: {"source":"stdout","log":"{\"level\":\"ERROR\",\"loggerName\":\"logstash.inputs.jdbc\",\"timeMillis\":1617727800778,\"thread\":\"[main]<jdbc\",\"logEvent\":{\"message\":\"Java::JavaSql::SQLException: Java heap space: CALL get_search_data('2021-01-01 00:00:00')\"}}\r","container_id":"7fca54e57b7b8b925c1b2ce57cc5779d9ba7aec6abc2e444200edce28a35b1a3","container_name":"/serene_noether","level":"ERROR","loggerName":"logstash.inputs.jdbc","timeMillis":1617727800778,"thread":"[main]<jdbc","logEvent":{"message":"Java::JavaSql::SQLException: Java heap space: CALL get_search_data('2021-01-01 00:00:00')"}}`

```

with

```
jdbc {

    jdbc_driver_library => "/usr/share/logstash/bin/mysql-connector-java-8.0.23.jar"

    jdbc_driver_class => "com.mysql.cj.jdbc.Driver"

    jdbc_connection_string => "jdbc:mysql://${DB_HOST}:${DB_PORT}/${DB_NAME}"

    jdbc_user => "${DB_USER}"

    jdbc_password => "${DB_PASSWORD}"

    use_column_value => false

    last_run_metadata_path => "/usr/share/logstash/.logstash_jdbc_last_run"

    clean_run => true

    # schedule => "*/10 * * * * *"

    statement => "CALL get_search_data('${DATE_SQL}')"

    jdbc_page_size => 300

    jdbc_fetch_size => 300

    clean_run => false

    jdbc_default_timezone => "Europe/Paris"

  }

```

How i can resolve please?  
Thanks

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [April 6, 2021, 9:32pm UTC](https://discuss.elastic.co/t/java-lang-outofmemoryerror-java-heap-space-with-proc-statement/269230/4 "2021-04-06T21:32:11Z")

</div>

Try reducing it again?

---

<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:** [May 4, 2021, 9:32pm UTC](https://discuss.elastic.co/t/java-lang-outofmemoryerror-java-heap-space-with-proc-statement/269230/5 "2021-05-04T21:32:54Z")

</div>

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