hi,here's my logstash&jdbc input logs.After then,there's only logstash logs,just like the jdbc input has been stoped or blocked.It has been normal before until 2020-04-27T16:34:35.I can't get the problem.
[2020-04-27T16:34:25,325][DEBUG][logstash.inputs.jdbc ] (0.000543s) select version from PRODUCT_COMPONENT_VERSION where lower(product) like 'oracle%' [2020-04-27T16:34:25,535][DEBUG][logstash.inputs.jdbc ] (0.209639s) SELECT * FROM (SELECT count(*) "COUNT" FROM (select * from V_IM where ID>15131756) "T1") "T1" WHERE (ROWNUM <= 1) [2020-04-27T16:34:25,536][DEBUG][logstash.inputs.jdbc ] Executing JDBC query {:statement=>"select * from V_IM where ID>:sql_last_value", :parameters=>{:sql_last_value=>15131756}, :count=>0} [2020-04-27T16:34:25,544][DEBUG][logstash.inputs.jdbc ] (0.008098s) select * from V_IM where ID>15131756 [2020-04-27T16:34:28,203][DEBUG][org.logstash.execution.PeriodicFlush] Pushing flush onto pipeline. [2020-04-27T16:34:28,594][DEBUG][logstash.instrument.periodicpoller.jvm] collector name {:name=>"ParNew"} [2020-04-27T16:34:28,595][DEBUG][logstash.instrument.periodicpoller.jvm] collector name {:name=>"ConcurrentMarkSweep"} [2020-04-27T16:34:29,625][DEBUG][org.logstash.execution.PeriodicFlush] Pushing flush onto pipeline. [2020-04-27T16:34:30,140][DEBUG][logstash.inputs.jdbc ] (0.001103s) select version from PRODUCT_COMPONENT_VERSION where lower(product) like 'oracle%' [2020-04-27T16:34:30,325][DEBUG][logstash.inputs.jdbc ] (0.183888s) SELECT * FROM (SELECT count(*) "COUNT" FROM (select * from V_IM where ID>15131756) "T1") "T1" WHERE (ROWNUM <= 1) [2020-04-27T16:34:30,325][DEBUG][logstash.inputs.jdbc ] Executing JDBC query {:statement=>"select * from V_IM where ID>:sql_last_value", :parameters=>{:sql_last_value=>15131756}, :count=>0} [2020-04-27T16:34:30,333][DEBUG][logstash.inputs.jdbc ] (0.008057s) select * from V_IM where ID>15131756 [2020-04-27T16:34:33,203][DEBUG][org.logstash.execution.PeriodicFlush] Pushing flush onto pipeline. [2020-04-27T16:34:33,261][DEBUG][logstash.inputs.metrics ] Metrics input: received a new snapshot {:created_at=>2020-04-27 16:34:33 +0800, :snapshot=>#<LogStash::Instrument::Snapshot:0x21ff1f3d>} [2020-04-27T16:34:33,597][DEBUG][logstash.instrument.periodicpoller.jvm] collector name {:name=>"ParNew"} [2020-04-27T16:34:33,598][DEBUG][logstash.instrument.periodicpoller.jvm] collector name {:name=>"ConcurrentMarkSweep"} [2020-04-27T16:34:34,625][DEBUG][org.logstash.execution.PeriodicFlush] Pushing flush onto pipeline. [2020-04-27T16:34:35,238][DEBUG][logstash.inputs.jdbc ] (0.000698s) select version from PRODUCT_COMPONENT_VERSION where lower(product) like 'oracle%' [2020-04-27T16:34:38,203][DEBUG][org.logstash.execution.PeriodicFlush] Pushing flush onto pipeline. [2020-04-27T16:34:38,601][DEBUG][logstash.instrument.periodicpoller.jvm] collector name {:name=>"ParNew"} [2020-04-27T16:34:38,601][DEBUG][logstash.instrument.periodicpoller.jvm] collector name {:name=>"ConcurrentMarkSweep"} [2020-04-27T16:34:39,625][DEBUG][org.logstash.execution.PeriodicFlush] Pushing flush onto pipeline. [2020-04-27T16:34:43,203][DEBUG][org.logstash.execution.PeriodicFlush] Pushing flush onto pipeline. [2020-04-27T16:34:43,264][DEBUG][logstash.inputs.metrics ] Metrics input: received a new snapshot {:created_at=>2020-04-27 16:34:43 +0800, :snapshot=>#<LogStash::Instrument::Snapshot:0x2aedadd8>} [2020-04-27T16:34:43,603][DEBUG][logstash.instrument.periodicpoller.jvm] collector name {:name=>"ParNew"} [2020-04-27T16:34:43,603][DEBUG][logstash.instrument.periodicpoller.jvm] collector name {:name=>"ConcurrentMarkSweep"} [2020-04-27T16:34:44,625][DEBUG][org.logstash.execution.PeriodicFlush] Pushing flush onto pipeline. [2020-04-27T16:34:48,203][DEBUG][org.logstash.execution.PeriodicFlush] Pushing flush onto pipeline. [2020-04-27T16:34:48,606][DEBUG][logstash.instrument.periodicpoller.jvm] collector name {:name=>"ParNew"} [2020-04-27T16:34:48,606][DEBUG][logstash.instrument.periodicpoller.jvm] collector name {:name=>"ConcurrentMarkSweep"} [2020-04-27T16:34:49,625][DEBUG][org.logstash.execution.PeriodicFlush] Pushing flush onto pipeline. [2020-04-27T16:34:53,203][DEBUG][org.logstash.execution.PeriodicFlush] Pushing flush onto pipeline. [2020-04-27T16:34:53,267][DEBUG][logstash.inputs.metrics ] Metrics input: received a new snapshot {:created_at=>2020-04-27 16:34:53 +0800, :snapshot=>#<LogStash::Instrument::Snapshot:0x184a58dd>} [2020-04-27T16:34:53,608][DEBUG][logstash.instrument.periodicpoller.jvm] collector name {:name=>"ParNew"} [2020-04-27T16:34:53,609][DEBUG][logstash.instrument.periodicpoller.jvm] collector name {:name=>"ConcurrentMarkSweep"} [2020-04-27T16:34:54,625][DEBUG][org.logstash.execution.PeriodicFlush] Pushing flush onto pipeline. [2020-04-27T16:34:58,203][DEBUG][org.logstash.execution.PeriodicFlush] Pushing flush onto pipeline. [2020-04-27T16:34:58,612][DEBUG][logstash.instrument.periodicpoller.jvm] collector name {:name=>"ParNew"} [2020-04-27T16:34:58,612][DEBUG][logstash.instrument.periodicpoller.jvm] collector name {:name=>"ConcurrentMarkSweep"} [2020-04-27T16:34:59,625][DEBUG][org.logstash.execution.PeriodicFlush] Pushing flush onto pipeline. [2020-04-27T16:35:03,203][DEBUG][org.logstash.execution.PeriodicFlush] Pushing flush onto pipeline. [2020-04-27T16:35:03,271][DEBUG][logstash.inputs.metrics ] Metrics input: received a new snapshot {:created_at=>2020-04-27 16:35:03 +0800, :snapshot=>#<LogStash::Instrument::Snapshot:0x12d8eb96>} [2020-04-27T16:35:03,614][DEBUG][logstash.instrument.periodicpoller.jvm] collector name {:name=>"ParNew"} [2020-04-27T16:35:03,614][DEBUG][logstash.instrument.periodicpoller.jvm] collector name {:name=>"ConcurrentMarkSweep"}
hi,here's my logstash&jdbc input logs.After then,there's only logstash logs,just like the jdbc input has been stoped or blocked.It has been normal before until 2020-04-27T16:34:35.I can't get the problem.
[2020-04-27T16:34:25,325][DEBUG][logstash.inputs.jdbc ] (0.000543s) select version from PRODUCT_COMPONENT_VERSION where lower(product) like 'oracle%' [2020-04-27T16:34:25,535][DEBUG][logstash.inputs.jdbc ] (0.209639s) SELECT * FROM (SELECT count(*) "COUNT" FROM (select * from V_IM where ID>15131756) "T1") "T1" WHERE (ROWNUM <= 1) [2020-04-27T16:34:25,536][DEBUG][logstash.inputs.jdbc ] Executing JDBC query {:statement=>"select * from V_IM where ID>:sql_last_value", :parameters=>{:sql_last_value=>15131756}, :count=>0} [2020-04-27T16:34:25,544][DEBUG][logstash.inputs.jdbc ] (0.008098s) select * from V_IM where ID>15131756 [2020-04-27T16:34:28,203][DEBUG][org.logstash.execution.PeriodicFlush] Pushing flush onto pipeline. [2020-04-27T16:34:28,594][DEBUG][logstash.instrument.periodicpoller.jvm] collector name {:name=>"ParNew"} [2020-04-27T16:34:28,595][DEBUG][logstash.instrument.periodicpoller.jvm] collector name {:name=>"ConcurrentMarkSweep"} [2020-04-27T16:34:29,625][DEBUG][org.logstash.execution.PeriodicFlush] Pushing flush onto pipeline. [2020-04-27T16:34:30,140][DEBUG][logstash.inputs.jdbc ] (0.001103s) select version from PRODUCT_COMPONENT_VERSION where lower(product) like 'oracle%' [2020-04-27T16:34:30,325][DEBUG][logstash.inputs.jdbc ] (0.183888s) SELECT * FROM (SELECT count(*) "COUNT" FROM (select * from V_IM where ID>15131756) "T1") "T1" WHERE (ROWNUM <= 1) [2020-04-27T16:34:30,325][DEBUG][logstash.inputs.jdbc ] Executing JDBC query {:statement=>"select * from V_IM where ID>:sql_last_value", :parameters=>{:sql_last_value=>15131756}, :count=>0} [2020-04-27T16:34:30,333][DEBUG][logstash.inputs.jdbc ] (0.008057s) select * from V_IM where ID>15131756 [2020-04-27T16:34:33,203][DEBUG][org.logstash.execution.PeriodicFlush] Pushing flush onto pipeline. [2020-04-27T16:34:33,261][DEBUG][logstash.inputs.metrics ] Metrics input: received a new snapshot {:created_at=>2020-04-27 16:34:33 +0800, :snapshot=>#<LogStash::Instrument::Snapshot:0x21ff1f3d>} [2020-04-27T16:34:33,597][DEBUG][logstash.instrument.periodicpoller.jvm] collector name {:name=>"ParNew"} [2020-04-27T16:34:33,598][DEBUG][logstash.instrument.periodicpoller.jvm] collector name {:name=>"ConcurrentMarkSweep"} [2020-04-27T16:34:34,625][DEBUG][org.logstash.execution.PeriodicFlush] Pushing flush onto pipeline. [2020-04-27T16:34:35,238][DEBUG][logstash.inputs.jdbc ] (0.000698s) select version from PRODUCT_COMPONENT_VERSION where lower(product) like 'oracle%' [2020-04-27T16:34:38,203][DEBUG][org.logstash.execution.PeriodicFlush] Pushing flush onto pipeline. [2020-04-27T16:34:38,601][DEBUG][logstash.instrument.periodicpoller.jvm] collector name {:name=>"ParNew"} [2020-04-27T16:34:38,601][DEBUG][logstash.instrument.periodicpoller.jvm] collector name {:name=>"ConcurrentMarkSweep"} [2020-04-27T16:34:39,625][DEBUG][org.logstash.execution.PeriodicFlush] Pushing flush onto pipeline. [2020-04-27T16:34:43,203][DEBUG][org.logstash.execution.PeriodicFlush] Pushing flush onto pipeline. [2020-04-27T16:34:43,264][DEBUG][logstash.inputs.metrics ] Metrics input: received a new snapshot {:created_at=>2020-04-27 16:34:43 +0800, :snapshot=>#<LogStash::Instrument::Snapshot:0x2aedadd8>} [2020-04-27T16:34:43,603][DEBUG][logstash.instrument.periodicpoller.jvm] collector name {:name=>"ParNew"} [2020-04-27T16:34:43,603][DEBUG][logstash.instrument.periodicpoller.jvm] collector name {:name=>"ConcurrentMarkSweep"} [2020-04-27T16:34:44,625][DEBUG][org.logstash.execution.PeriodicFlush] Pushing flush onto pipeline. [2020-04-27T16:34:48,203][DEBUG][org.logstash.execution.PeriodicFlush] Pushing flush onto pipeline. [2020-04-27T16:34:48,606][DEBUG][logstash.instrument.periodicpoller.jvm] collector name {:name=>"ParNew"} [2020-04-27T16:34:48,606][DEBUG][logstash.instrument.periodicpoller.jvm] collector name {:name=>"ConcurrentMarkSweep"} [2020-04-27T16:34:49,625][DEBUG][org.logstash.execution.PeriodicFlush] Pushing flush onto pipeline. [2020-04-27T16:34:53,203][DEBUG][org.logstash.execution.PeriodicFlush] Pushing flush onto pipeline. [2020-04-27T16:34:53,267][DEBUG][logstash.inputs.metrics ] Metrics input: received a new snapshot {:created_at=>2020-04-27 16:34:53 +0800, :snapshot=>#<LogStash::Instrument::Snapshot:0x184a58dd>} [2020-04-27T16:34:53,608][DEBUG][logstash.instrument.periodicpoller.jvm] collector name {:name=>"ParNew"} [2020-04-27T16:34:53,609][DEBUG][logstash.instrument.periodicpoller.jvm] collector name {:name=>"ConcurrentMarkSweep"} [2020-04-27T16:34:54,625][DEBUG][org.logstash.execution.PeriodicFlush] Pushing flush onto pipeline. [2020-04-27T16:34:58,203][DEBUG][org.logstash.execution.PeriodicFlush] Pushing flush onto pipeline. [2020-04-27T16:34:58,612][DEBUG][logstash.instrument.periodicpoller.jvm] collector name {:name=>"ParNew"} [2020-04-27T16:34:58,612][DEBUG][logstash.instrument.periodicpoller.jvm] collector name {:name=>"ConcurrentMarkSweep"} [2020-04-27T16:34:59,625][DEBUG][org.logstash.execution.PeriodicFlush] Pushing flush onto pipeline. [2020-04-27T16:35:03,203][DEBUG][org.logstash.execution.PeriodicFlush] Pushing flush onto pipeline. [2020-04-27T16:35:03,271][DEBUG][logstash.inputs.metrics ] Metrics input: received a new snapshot {:created_at=>2020-04-27 16:35:03 +0800, :snapshot=>#<LogStash::Instrument::Snapshot:0x12d8eb96>} [2020-04-27T16:35:03,614][DEBUG][logstash.instrument.periodicpoller.jvm] collector name {:name=>"ParNew"} [2020-04-27T16:35:03,614][DEBUG][logstash.instrument.periodicpoller.jvm] collector name {:name=>"ConcurrentMarkSweep"}