Hi ,
thanks for your assistance ,
so - adding a file output in the input pipeline does generate the entries in the logs , which are as they should be ... also - we could tell that without that step because , as said , the issue is only when adding / removing the grok with the issue , so the issue is not at that stage ...
When trying to add the file output in the output section of the Kafka_DEV pipeline it doesn't write anything to a file (as we could have told also , as the issue is in the grok which comes before it)
the issue is only with that grok pattern and no idea how to debug it ...
the log entries in the file are as we told -
for example -
{"message":"[2022-07-03 13:46:54,477] ERROR Something happened during dequeue event, EventQueueManager.dequeueEvent() : (io.confluent.kafka.connect.IPMSourceConnector.util.EventQueueManager:90)\njava.sql.SQLException: ORA-01403: no data found\nORA-06512: at \"BIZ_EVENT_EXT_HANDLER\", line 88\nORA-06512: at \"EVENT_KAFKA_CONNECT_PCK\", line 94\nORA-06512: at line 1\n\n\tat oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:628)\n\tat oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:562)\n\tat oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1145)\n\tat oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:726)\n\tat oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:291)\n\tat oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:492)\n\tat oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:144)\n\tat oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1034)\n\tat oracle.jdbc.driver.OracleStatement.executeSQLStatement(OracleStatement.java:1507)\n\tat oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1287)\n\tat oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3735)\n\tat oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3933)\n\tat oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4279)\n\tat oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1010)\n\tat io.confluent.kafka.connect.IPMSourceConnector.util.EventQueueManager.dequeueEvent(EventQueueManager.java:85)\n\tat io.confluent.kafka.connect.IPMSourceConnector.QueueQueryRunner.removeCurrentEventFromQueueToLog(QueueQueryRunner.java:234)\n\tat io.confluent.kafka.connect.IPMSourceConnector.QueueQueryRunner.maybeStartQuery(QueueQueryRunner.java:223)\n\tat io.confluent.kafka.connect.IPMSourceConnector.JdbcQSourceTask.pollResults(JdbcQSourceTask.java:169)\n\tat io.confluent.kafka.connect.IPMSourceConnector.JdbcQSourceTask.poll(JdbcQSourceTask.java:138)\n\tat org.apache.kafka.connect.runtime.WorkerSourceTask.poll(WorkerSourceTask.java:308)\n\tat org.apache.kafka.connect.runtime.WorkerSourceTask.execute(WorkerSourceTask.java:263)\n\tat org.apache.kafka.connect.runtime.WorkerTask.doRun(WorkerTask.java:199)\n\tat org.apache.kafka.connect.runtime.WorkerTask.run(WorkerTask.java:254)\n\tat java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)\n\tat java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)\n\tat java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)\n\tat java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)\n\tat java.base/java.lang.Thread.run(Thread.java:829)\nCaused by: Error : 1403, Position : 0, Sql = BEGIN :1 := IPM.biz_event_kafka_connect_pck.dequeue_event(:2 ,:3 ,:4 ,:5 ,:6 ,:7 ); END;, OriginalSql = { ? = call IPM.biz_event_kafka_connect_pck.dequeue_event(?,?,?,?,?,?)}, Error Msg = ORA-01403: no data found\nORA-06512: at \"BIZ_EVENT_EXT_HANDLER\", line 88\nORA-06512: at \"KAFKA_CONNECT_PCK\", line 94\nORA-06512: at line 1\n\n\tat oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:632)\n\t... 27 more","fileset":{"name":"log"},"@timestamp":"2022-07-03T10:46:54.494Z","@version":"1","service":{"type":"kafka"},"tags":["beats_input_codec_plain_applied"],"host":{"mac":["00:50:56:ab:1c:96"],"ip":["10.54.0.48","fe80::250:56ff:feab:1c96"],"architecture":"x86_64","name":"server1.corp","os":{"codename":"Maipo","version":"7.9 (Maipo)","platform":"rhel","family":"redhat","type":"linux","name":"Red Hat Enterprise Linux Server","kernel":"3.10.0-1160.66.1.el7.x86_64"},"containerized":false,"id":"074182ff2fef46489c42724a019bef71","hostname":"server1.corp"},"event":{"timezone":"+03:00","module":"kafka","dataset":"kafka.log"},"input":{"type":"log"},"log":{"file":{"path":"/var/log/kafka-dev1/connect.log"},"flags":["multiline"],"offset":42469192},"agent":{"ephemeral_id":"2785784a-4a9c-4ef2-9670-729c1d89cb0b","version":"7.15.1","type":"filebeat","name":"server1.corp","hostname":"server1.corp","id":"35bf0a3c-4028-4035-8dc6-03cc8bfe9669"},"ecs":{"version":"1.11.0"}}
It's a 1 line and it does add some data from the filebeat agent
another example -
{"message":"[2022-07-03 13:46:54,469] ERROR maybeStartQuery() error : ORA-16000: database or pluggable database open for read-only access\nORA-06512: at \"BIZ_EVENT_EXT_HANDLER\", line 12\nORA-06512: at \"EVENT_KAFKA_CONNECT_PCK\", line 68\nORA-06512: at line 1\n (io.confluent.kafka.connect.IPMSourceConnector.QueueQueryRunner:222)","fileset":{"name":"log"},"@timestamp":"2022-07-03T10:46:54.494Z","@version":"1","service":{"type":"kafka"},"tags":["beats_input_codec_plain_applied"],"host":{"mac":["00:50:56:ab:1c:96"],"ip":["10.54.0.48","fe80::250:56ff:feab:1c96"],"architecture":"x86_64","name":"server1.corp","os":{"codename":"Maipo","version":"7.9 (Maipo)","platform":"rhel","family":"redhat","type":"linux","name":"Red Hat Enterprise Linux Server","kernel":"3.10.0-1160.66.1.el7.x86_64"},"hostname":"server1.corp","id":"074182ff2fef46489c42724a019bef71","containerized":false},"event":{"timezone":"+03:00","module":"kafka","dataset":"kafka.log"},"input":{"type":"log"},"log":{"file":{"path":"/var/log/kafka-dev1/connect.log"},"flags":["multiline"],"offset":42468864},"agent":{"ephemeral_id":"2785784a-4a9c-4ef2-9670-729c1d89cb0b","version":"7.15.1","type":"filebeat","name":"server1.corp","hostname":"server1.corp","id":"35bf0a3c-4028-4035-8dc6-03cc8bfe9669"},"ecs":{"version":"1.11.0"}}
Thanks