# Logstash $HOME/.logstash\_jdbc\_last\_run not created

**URL:** <https://discuss.elastic.co/t/logstash-home-logstash-jdbc-last-run-not-created/323936>\
**Category:** Logstash\
**Created:** [January 25, 2023, 2:56pm UTC](https://discuss.elastic.co/t/logstash-home-logstash-jdbc-last-run-not-created/323936 "2023-01-25T14:56:03Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![duffel](https://avatars.discourse-cdn.com/v4/letter/d/a88e4f/32.png) [@duffel](https://discuss.elastic.co/u/duffel)\
**Post date:** [January 25, 2023, 2:56pm UTC](https://discuss.elastic.co/t/logstash-home-logstash-jdbc-last-run-not-created/323936/1 "2023-01-25T14:56:03Z")

</div>

I am using logstash 7.14 and the jdbc plugin with the following settings

```json
  jdbc {
    type => "jdbc-audit"
    id => "dev-jdbc-audit"
    jdbc_driver_library => "/opt/appl/lib/postgresql-42.5.1.jar"
    jdbc_driver_class => "org.postgresql.Driver"
    jdbc_connection_string => "jdbc:postgresql://test.com:5432/dev"
    jdbc_user => "dev"
    jdbc_password => "pass"
    jdbc_fetch_size => 100000
    jdbc_page_size => 200000
    jdbc_paging_enabled => true
    tracking_column => "entity_timestamp"
    tracking_column_type => "timestamp"
    use_column_value => true
    schedule => "* * * * *"
    statement => 'SELECT * from "AO_C77861_AUDIT_ENTITY"'
  }

```

The file **.logstash\_jdbc\_last\_run** file is never created.  
It should be created by default according to the [documentation](https://www.elastic.co/guide/en/logstash/7.14/plugins-inputs-jdbc.html#plugins-inputs-jdbc-last_run_metadata_path).  
I find no permission denied errors or any mention of a \*last\_run file anywhere on the server.

---

<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:** [February 22, 2023, 2:56pm UTC](https://discuss.elastic.co/t/logstash-home-logstash-jdbc-last-run-not-created/323936/2 "2023-02-22T14:56:17Z")

</div>

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