Skip to content

stop without any error logs #380

@liuxiaolinlxl

Description

@liuxiaolinlxl

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"}

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions