# Logstash jdbc ignore default last run folder

**URL:** <https://discuss.elastic.co/t/logstash-jdbc-ignore-default-last-run-folder/104180>\
**Category:** Logstash\
**Created:** [October 17, 2017, 5:53am UTC](https://discuss.elastic.co/t/logstash-jdbc-ignore-default-last-run-folder/104180 "2017-10-17T05:53:46Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![uLan](https://avatars.discourse-cdn.com/v4/letter/u/bb73d2/32.png) [@uLan](https://discuss.elastic.co/u/uLan)\
**Post date:** [October 17, 2017, 5:53am UTC](https://discuss.elastic.co/t/logstash-jdbc-ignore-default-last-run-folder/104180/1 "2017-10-17T05:53:46Z")

</div>

I am using the logstash jdbc plugin and everything is working fine, but it gives out an error every time the sql query is executed.  
The error is:

 ![Screenshot from 2017-10-17 13-50-57](https://us1.discourse-cdn.com/elastic/original/3X/9/0/9092d9b1098c812a4803d0c325185cf4fe42bcea.png)  
This causes no problem what so ever. It just floods the logs and it's annoying.  
I have set in my conf file the `last_run_metadata_path` and I don't know where it's taking that path.

```auto
input {
	jdbc {
		jdbc_connection_string => "jdbc:${PG_URI}${DB_NAME}?user=${DB_USER}"
		jdbc_user => "${DB_USER}"
		jdbc_driver_library => "${JDBC_DRIVER_DIR}/postgresql-42.1.4.jar"
		jdbc_driver_class => "org.postgresql.Driver"
		schedule => "* * * * *"
		# schedule => "0 0 * * *" #//Runs the scheduler every 12:00AM
		statement => "SELECT * FROM items where created_at > :sql_last_value"
		use_column_value => true
		tracking_column => created_at
		last_run_metadata_path => "${LAST_RUN_DIR}/.000_${DB_NAME}_jdbc_last_run"
		type => "created-items"
	}
}

```

---

<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:** [November 14, 2017, 5:53am UTC](https://discuss.elastic.co/t/logstash-jdbc-ignore-default-last-run-folder/104180/2 "2017-11-14T05:53:50Z")

</div>

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