Inner join and config of Logstash and JDBC

  1. The jdbc input (via the mixin) will, under some circumstances, attempt to count the number of rows the query will return

  2. My reading of the documentation for the sequel library that the input is based on is that it implements .count by doing a SELECT count(...) ... LIMIT 1

  3. Firebird does not support LIMIT 1, it uses FIRST 1 instead

  4. The jdbc mixin should be detecting that .count does not work and stop using it, so you should get this error once but everything works as expected

  5. I would expect you to be seeing these two warnings

"Attempting a count query raised an error, the generated count statement is most likely incorrect but check networking, authentication or your statement syntax"
"Ongoing count statement generation is being prevented"