You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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"}
The text was updated successfully, but these errors were encountered:
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"}
The text was updated successfully, but these errors were encountered: