# JDBC input error when using schedule without last run

**URL:** <https://discuss.elastic.co/t/jdbc-input-error-when-using-schedule-without-last-run/335243>\
**Category:** Logstash\
**Tags:** jdbc\
**Created:** [June 5, 2023, 3:56pm UTC](https://discuss.elastic.co/t/jdbc-input-error-when-using-schedule-without-last-run/335243 "2023-06-05T15:56:35Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![ElasticLiver](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/elasticliver/32/64869_2.png) [@ElasticLiver](https://discuss.elastic.co/u/ElasticLiver)\
**Post date:** [June 5, 2023, 3:56pm UTC](https://discuss.elastic.co/t/jdbc-input-error-when-using-schedule-without-last-run/335243/1 "2023-06-05T15:56:36Z")

</div>

Hi, I need to query a database every 1 minute and get all the results of the query, so I use schedule but no last\_run\_metadata\_path.

logstash give an error, but still que the data indexed in ES.

logstash look for this file `/usr/share/logstash/.logstash_jdbc_last_run`

when I run the command `ll -a /usr/share/logstash/` to see hidden files the file is not there

altough the pipeline works, the error in the log bothers a lot

What can I do to avoid this error message?

```auto
{
    :exception=>Errno: :EACCES,
    :message=>"Permission denied - /usr/share/logstash/.logstash_jdbc_last_run",
    :backtrace=>[
        "org/jruby/RubyIO.java:1237:in `sysopen'",
        "org/jruby/RubyIO.java:3800:in `write'",
        "/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-integration-jdbc-5.2.3/lib/logstash/plugin_mixins/jdbc/value_tracking.rb:122:in `write'",
        "/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-integration-jdbc-5.2.3/lib/logstash/plugin_mixins/jdbc/value_tracking.rb:46:in `write'",
        "/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-integration-jdbc-5.2.3/lib/logstash/inputs/jdbc.rb:354:in `execute_query'",
        "/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-integration-jdbc-5.2.3/lib/logstash/inputs/jdbc.rb:308:in `block in run'",
        "/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/rufus-scheduler-3.0.9/lib/rufus/scheduler/jobs.rb:234:in `do_call'",
        "/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/rufus-scheduler-3.0.9/lib/rufus/scheduler/jobs.rb:258:in `do_trigger'",
        "/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/rufus-scheduler-3.0.9/lib/rufus/scheduler/jobs.rb:300:in `block in start_work_thread'",
        "/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/rufus-scheduler-3.0.9/lib/rufus/scheduler/jobs.rb:299:in `block in start_work_thread'",
        "org/jruby/RubyKernel.java:1442:in `loop'",
        "/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/rufus-scheduler-3.0.9/lib/rufus/scheduler/jobs.rb:289:in `block in start_work_thread'"
    ],
    :now=>"2023-06-05T11:26:01.045",
    :last_time=>"2023-06-05T11:26:00.807",
    :next_time=>"2023-06-05T11:27:00.000",
    :job=>#<Rufus: :Scheduler: :CronJob: 0xd11274b @last_at=nil, @tags=[], @scheduled_at=2023-06-05 10: 44: 42 -0400, @cron_line=#<Rufus: :Scheduler: :CronLine: 0x2576f21b @timezone=nil, @weekdays=nil, @days=nil, @seconds=[
        0
    ], @minutes=[
        0,
        1,
        2,
        ...
        58,
        59
    ], @hours=nil, @months=nil, @monthdays=nil, @original="*/1 * * * *">, @last_time=2023-06-05 11: 26: 00 -0400, @times=nil, @locals={}, @unscheduled_at=nil, @callable=#<Proc: 0x5f2fa38d@/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-integration-jdbc-5.2.3/lib/logstash/inputs/jdbc.rb: 307>, @next_time=2023-06-05 11: 27: 00 -0400, @local_mutex=#<Thread: :Mutex: 0x4ddb7459>, @mean_work_time=0.32294414634146335, @count=42, @last_work_time=0.232489, @scheduler=#<LogStash: :PluginMixins: :Jdbc: :Scheduler: 0x5a0359c1 @jobs=#<Rufus: :Scheduler: :JobArray: 0x63990fc @mutex=#<Thread: :Mutex: 0x24a8787d>, @array=[#<Rufus: :Scheduler: :CronJob: 0xd11274b ...>
    ]>, @scheduler_lock=#<Rufus: :Scheduler: :NullLock: 0x72ca23c5>, @started_at=2023-06-05 10: 44: 42 -0400, @thread=#<Thread: 0x2a5053e9@[
        4a4255846bcb2ba19b8e67827aff0b3ee0ea127e464f74d15aa158f5ccfa0840
    ]<jdbc__scheduler sleep>, @mutexes={}, @work_queue=#<Thread: :Queue: 0x383ef310>, @frequency=1.0, @_work_threads=[#<Thread: 0x5032dac0@[
            4a4255846bcb2ba19b8e67827aff0b3ee0ea127e464f74d15aa158f5ccfa0840
        ]<jdbc__scheduler_worker-00@/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-integration-jdbc-5.2.3/lib/logstash/plugin_mixins/jdbc/scheduler.rb: 113 run>
    ], @paused=false, @trigger_lock=#<Rufus: :Scheduler: :NullLock: 0x73451f08>, @opts={
        :max_work_threads=>1,
        :thread_name=>"[4a4255846bcb2ba19b8e67827aff0b3ee0ea127e464f74d15aa158f5ccfa0840]<jdbc__scheduler",
        :frequency=>1.0
    }, @thread_key="rufus_scheduler_2174", @max_work_threads=1, @stderr=#<IO:<STDERR>>>, @paused_at=nil, @first_at=2023-06-05 10: 44: 42 -0400, @opts={}, @id="cron_1685976282.6209729_8049722172939095725", @handler=#<Proc: 0x5f2fa38d@/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-integration-jdbc-5.2.3/lib/logstash/inputs/jdbc.rb: 307>, @original="*/1 * * * *">,
    :opts=>{
        :max_work_threads=>1,
        :thread_name=>"[4a4255846bcb2ba19b8e67827aff0b3ee0ea127e464f74d15aa158f5ccfa0840]<jdbc__scheduler",
        :frequency=>1.0
    },
    :started_at=>2023-06-05 10: 44: 42 -0400,
    :thread=>"#<Thread:0x2a5053e9@[4a4255846bcb2ba19b8e67827aff0b3ee0ea127e464f74d15aa158f5ccfa0840]<jdbc__scheduler sleep>",
    :jobs_size=>1,
    :work_threads_size=>1,
    :work_queue_size=>0
}  

```

---

<div class="post-metadata">

**Author:** ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)\
**Post date:** [June 5, 2023, 8:33pm UTC](https://discuss.elastic.co/t/jdbc-input-error-when-using-schedule-without-last-run/335243/2 "2023-06-05T20:33:04Z")

</div>

Set the [last\_run\_metadata\_path](https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html#plugins-inputs-jdbc-last_run_metadata_path) option to something that you have permission to write to.

---

<div class="post-metadata">

**Author:** ![ElasticLiver](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/elasticliver/32/64869_2.png) [@ElasticLiver](https://discuss.elastic.co/u/ElasticLiver)\
**Post date:** [June 5, 2023, 9:17pm UTC](https://discuss.elastic.co/t/jdbc-input-error-when-using-schedule-without-last-run/335243/3 "2023-06-05T21:17:12Z")

</div>

Hi Badger, thanks for you answer, it works, so as long I dont set:

```
use_column_value => true
record_last_run => true
tracking_column => "clock"

```

the value in last\_run\_metadata\_path wont be taking to account, so I can point multiples pipeline to the same dummy file, is that correct?

---

<div class="post-metadata">

**Author:** ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)\
**Post date:** [June 5, 2023, 10:19pm UTC](https://discuss.elastic.co/t/jdbc-input-error-when-using-schedule-without-last-run/335243/4 "2023-06-05T22:19:11Z")

</div>

If you set record\_last\_run =\> false the path is never looked at, so you should be OK sharing it in that case.

---

<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:** [July 3, 2023, 10:19pm UTC](https://discuss.elastic.co/t/jdbc-input-error-when-using-schedule-without-last-run/335243/5 "2023-07-03T22:19:45Z")

</div>

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