Logstash.log

{:timestamp=>"2016-11-07T17:06:27.610000+0530", :message=>"Reading config file", :config_file=>"/home/user/logstash.txt", :level=>:debug, :file=>"logstash/config/loader.rb", :line=>"69", :method=>"local_config"} {:timestamp=>"2016-11-07T17:06:27.717000+0530", :message=>"Plugin not defined in namespace, checking for plugin file", :type=>"input", :name=>"jdbc", :path=>"logstash/inputs/jdbc", :level=>:debug, :file=>"logstash/plugin.rb", :line=>"86", :method=>"lookup"} {:timestamp=>"2016-11-07T17:06:27.744000+0530", :message=>"Plugin not defined in namespace, checking for plugin file", :type=>"codec", :name=>"plain", :path=>"logstash/codecs/plain", :level=>:debug, :file=>"logstash/plugin.rb", :line=>"86", :method=>"lookup"} {:timestamp=>"2016-11-07T17:06:27.748000+0530", :message=>"config LogStash::Codecs::Plain/@charset = \"UTF-8\"", :level=>:debug, :file=>"logstash/config/mixin.rb", :line=>"154", :method=>"config_init"} {:timestamp=>"2016-11-07T17:06:27.766000+0530", :message=>"config LogStash::Inputs::Jdbc/@jdbc_connection_string = \"jdbc:mysql://172.17.3.9:3306/test\"", :level=>:debug, :file=>"logstash/config/mixin.rb", :line=>"154", :method=>"config_init"} {:timestamp=>"2016-11-07T17:06:27.767000+0530", :message=>"config LogStash::Inputs::Jdbc/@jdbc_user = \"root\"", :level=>:debug, :file=>"logstash/config/mixin.rb", :line=>"154", :method=>"config_init"} {:timestamp=>"2016-11-07T17:06:27.768000+0530", :message=>"config LogStash::Inputs::Jdbc/@jdbc_password = <password>", :level=>:debug, :file=>"logstash/config/mixin.rb", :line=>"154", :method=>"config_init"} {:timestamp=>"2016-11-07T17:06:27.769000+0530", :message=>"config LogStash::Inputs::Jdbc/@jdbc_validate_connection = true", :level=>:debug, :file=>"logstash/config/mixin.rb", :line=>"154", :method=>"config_init"} {:timestamp=>"2016-11-07T17:06:27.770000+0530", :message=>"config LogStash::Inputs::Jdbc/@jdbc_driver_library = \"/home/user/mysql-connector-java-5.1.36.jar\"", :level=>:debug, :file=>"logstash/config/mixin.rb", :line=>"154", :method=>"config_init"} {:timestamp=>"2016-11-07T17:06:27.772000+0530", :message=>"config LogStash::Inputs::Jdbc/@jdbc_driver_class = \"com.mysql.jdbc.Driver\"", :level=>:debug, :file=>"logstash/config/mixin.rb", :line=>"154", :method=>"config_init"} {:timestamp=>"2016-11-07T17:06:27.773000+0530", :message=>"config LogStash::Inputs::Jdbc/@statement = \"SELECT * FROM test.test\"", :level=>:debug, :file=>"logstash/config/mixin.rb", :line=>"154", :method=>"config_init"} {:timestamp=>"2016-11-07T17:06:27.774000+0530", :message=>"config LogStash::Inputs::Jdbc/@codec = <LogStash::Codecs::Plain charset=>\"UTF-8\">", :level=>:debug, :file=>"logstash/config/mixin.rb", :line=>"154", :method=>"config_init"} {:timestamp=>"2016-11-07T17:06:27.790000+0530", :message=>"config LogStash::Inputs::Jdbc/@add_field = {}", :level=>:debug, :file=>"logstash/config/mixin.rb", :line=>"154", :method=>"config_init"} {:timestamp=>"2016-11-07T17:06:27.791000+0530", :message=>"config LogStash::Inputs::Jdbc/@jdbc_paging_enabled = false", :level=>:debug, :file=>"logstash/config/mixin.rb", :line=>"154", :method=>"config_init"} {:timestamp=>"2016-11-07T17:06:27.793000+0530", :message=>"config LogStash::Inputs::Jdbc/@jdbc_page_size = 100000", :level=>:debug, :file=>"logstash/config/mixin.rb", :line=>"154", :method=>"config_init"} {:timestamp=>"2016-11-07T17:06:27.794000+0530", :message=>"config LogStash::Inputs::Jdbc/@jdbc_validation_timeout = 3600", :level=>:debug, :file=>"logstash/config/mixin.rb", :line=>"154", :method=>"config_init"} {:timestamp=>"2016-11-07T17:06:27.795000+0530", :message=>"config LogStash::Inputs::Jdbc/@jdbc_pool_timeout = 5", :level=>:debug, :file=>"logstash/config/mixin.rb", :line=>"154", :method=>"config_init"} {:timestamp=>"2016-11-07T17:06:27.796000+0530", :message=>"config LogStash::Inputs::Jdbc/@sequel_opts = {}", :level=>:debug, :file=>"logstash/config/mixin.rb", :line=>"154", :method=>"config_init"} {:timestamp=>"2016-11-07T17:06:27.797000+0530", :message=>"config LogStash::Inputs::Jdbc/@sql_log_level = \"info\"", :level=>:debug, :file=>"logstash/config/mixin.rb", :line=>"154", :method=>"config_init"} {:timestamp=>"2016-11-07T17:06:27.798000+0530", :message=>"config LogStash::Inputs::Jdbc/@connection_retry_attempts = 1", :level=>:debug, :file=>"logstash/config/mixin.rb", :line=>"154", :method=>"config_init"} {:timestamp=>"2016-11-07T17:06:27.799000+0530", :message=>"config LogStash::Inputs::Jdbc/@connection_retry_attempts_wait_time = 0.5", :level=>:debug, :file=>"logstash/config/mixin.rb", :line=>"154", :method=>"config_init"} {:timestamp=>"2016-11-07T17:06:27.800000+0530", :message=>"config LogStash::Inputs::Jdbc/@parameters = {}", :level=>:debug, :file=>"logstash/config/mixin.rb", :line=>"154", :method=>"config_init"} {:timestamp=>"2016-11-07T17:06:27.817000+0530", :message=>"config LogStash::Inputs::Jdbc/@last_run_metadata_path = \"/home/user/.logstash_jdbc_last_run\"", :level=>:debug, :file=>"logstash/config/mixin.rb", :line=>"154", :method=>"config_init"} {:timestamp=>"2016-11-07T17:06:27.819000+0530", :message=>"config LogStash::Inputs::Jdbc/@use_column_value = false", :level=>:debug, :file=>"logstash/config/mixin.rb", :line=>"154", :method=>"config_init"} {:timestamp=>"2016-11-07T17:06:27.820000+0530", :message=>"config LogStash::Inputs::Jdbc/@clean_run = false", :level=>:debug, :file=>"logstash/config/mixin.rb", :line=>"154", :method=>"config_init"} {:timestamp=>"2016-11-07T17:06:27.821000+0530", :message=>"config LogStash::Inputs::Jdbc/@record_last_run = true", :level=>:debug, :file=>"logstash/config/mixin.rb", :line=>"154", :method=>"config_init"} {:timestamp=>"2016-11-07T17:06:27.822000+0530", :message=>"config LogStash::Inputs::Jdbc/@lowercase_column_names = true", :level=>:debug, :file=>"logstash/config/mixin.rb", :line=>"154", :method=>"config_init"} {:timestamp=>"2016-11-07T17:06:27.823000+0530", :message=>"config LogStash::Inputs::Jdbc/@columns_charset = {}", :level=>:debug, :file=>"logstash/config/mixin.rb", :line=>"154", :method=>"config_init"} {:timestamp=>"2016-11-07T17:06:27.824000+0530", :message=>"Plugin not defined in namespace, checking for plugin file", :type=>"output", :name=>"elasticsearch", :path=>"logstash/outputs/elasticsearch", :level=>:debug, :file=>"logstash/plugin.rb", :line=>"86", :method=>"lookup"} {:timestamp=>"2016-11-07T17:06:28.265000+0530", :message=>"starting agent", :level=>:info, :file=>"logstash/agent.rb", :line=>"213", :method=>"execute"} {:timestamp=>"2016-11-07T17:06:28.267000+0530", :message=>"starting pipeline", :id=>"main", :level=>:info, :file=>"logstash/agent.rb", :line=>"487", :method=>"start_pipeline"} {:timestamp=>"2016-11-07T17:06:29.350000+0530", :message=>"Unknown setting 'protocol' for elasticsearch", :level=>:error, :file=>"logstash/config/mixin.rb", :line=>"330", :method=>"validate_check_invalid_parameter_names"} {:timestamp=>"2016-11-07T17:06:29.355000+0530", :message=>"Pipeline aborted due to error", :exception=>"LogStash::ConfigurationError", :backtrace=>["/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.4.0-java/lib/logstash/config/mixin.rb:135:in `config_init'", "/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.4.0-java/lib/logstash/outputs/base.rb:79:in `initialize'", "/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.4.0-java/lib/logstash/output_delegator.rb:74:in `register'", "/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.4.0-java/lib/logstash/pipeline.rb:181:in `start_workers'", "org/jruby/RubyArray.java:1613:in `each'", "/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.4.0-java/lib/logstash/pipeline.rb:181:in `start_workers'", "/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.4.0-java/lib/logstash/pipeline.rb:136:in `run'", "/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.4.0-java/lib/logstash/agent.rb:491:in `start_pipeline'"], :level=>:error, :file=>"logstash/agent.rb", :line=>"493", :method=>"start_pipeline"} {:timestamp=>"2016-11-07T17:06:29.376000+0530", :message=>"(0.010000s) SELECT count(*) AS `count` FROM (SELECT * FROM test.test) AS `t1` LIMIT 1", :level=>:info, :file=>"sequel/database/logging.rb", :line=>"87", :method=>"log_each"} {:timestamp=>"2016-11-07T17:06:29.430000+0530", :message=>"Executing JDBC query", :statement=>"SELECT * FROM test.test", :parameters=>{:sql_last_value=>2016-11-07 11:11:17 UTC}, :count=>1, :level=>:debug, :file=>"logstash/plugin_mixins/jdbc.rb", :line=>"99", :method=>"execute_statement"} {:timestamp=>"2016-11-07T17:06:29.444000+0530", :message=>"(0.012000s) SELECT * FROM test.test", :level=>:info, :file=>"sequel/database/logging.rb", :line=>"87", :method=>"log_each"} {:timestamp=>"2016-11-07T17:06:32.366000+0530", :message=>"stopping pipeline", :id=>"main", :file=>"logstash/agent.rb", :line=>"406", :method=>"shutdown_pipelines"} {:timestamp=>"2016-11-07T17:06:32.385000+0530", :message=>"Closing inputs", :level=>:info, :file=>"logstash/pipeline.rb", :line=>"384", :method=>"shutdown"} {:timestamp=>"2016-11-07T17:06:32.386000+0530", :message=>"stopping", :plugin=>"LogStash::Inputs::Jdbc", :level=>:debug, :file=>"logstash/inputs/base.rb", :line=>"81", :method=>"do_stop"} {:timestamp=>"2016-11-07T17:06:32.387000+0530", :message=>"Closed inputs", :level=>:info, :file=>"logstash/pipeline.rb", :line=>"386", :method=>"shutdown"}