Hi all. Does anyone know if it’s possible to have OS Logstash store more than one :sql_last_value if you’re using more than one JDBC input in the config file? If not, it seems we’re either limited to a single JDBC, or have to tolerate the :sql_last_value being captured only for the last JDBC it ran. That might be a substantial number of rows to miss.
I found where it stores that value. But it looks like it will only store one value–not one per JDBC input:
logstash@995dfd795f4d:~/data/plugins/inputs/jdbc$ cat logstash_jdbc_last_run --- 2023-11-13 20:40:00.891320000 Z