I hope my title wasn't confusing -
we have 2 jdbc inputs in our logstash config, one that pulls a commentid and one that pulls a messageid from our application.
the messageid does not get added to logstash unless I put the id into logstash.conf directly; after running logstash in debug mode and sending the output to a file, the ouput shows that the messageid used by :sql_last_value is equal to the commentid, not the messagid.
What appears to be happening is, like a variable, logstash is using the first value of :sql_last_value, instead of 'updating' it on the next sql command/jdbc input.
I should still have this ouput saved, i just havent run logstash in debug mode in a while because it is in our production environment; dev doesn't have enough usable data.
I can include this output if need be, or re-run logstash in debug mode.
I hope this was clear...