{"action":"opened","issue":{"url":"https://api.github.com/repos/logstash-plugins/logstash-input-jdbc/issues/227","repository_url":"https://api.github.com/repos/logstash-plugins/logstash-input-jdbc","labels_url":"https://api.github.com/repos/logstash-plugins/logstash-input-jdbc/issues/227/labels{/name}","comments_url":"https://api.github.com/repos/logstash-plugins/logstash-input-jdbc/issues/227/comments","events_url":"https://api.github.com/repos/logstash-plugins/logstash-input-jdbc/issues/227/events","html_url":"https://github.com/logstash-plugins/logstash-input-jdbc/issues/227","id":244250451,"number":227,"title":"MySql : undefined method `close_jdbc_connection'","user":{"login":"TitoVince35","id":3153978,"avatar_url":"https://avatars2.githubusercontent.com/u/3153978?v=4","gravatar_id":"","url":"https://api.github.com/users/TitoVince35","html_url":"https://github.com/TitoVince35","followers_url":"https://api.github.com/users/TitoVince35/followers","following_url":"https://api.github.com/users/TitoVince35/following{/other_user}","gists_url":"https://api.github.com/users/TitoVince35/gists{/gist_id}","starred_url":"https://api.github.com/users/TitoVince35/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/TitoVince35/subscriptions","organizations_url":"https://api.github.com/users/TitoVince35/orgs","repos_url":"https://api.github.com/users/TitoVince35/repos","events_url":"https://api.github.com/users/TitoVince35/events{/privacy}","received_events_url":"https://api.github.com/users/TitoVince35/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-07-20T05:37:51Z","updated_at":"2017-07-20T05:37:51Z","closed_at":null,"body":"Hello all, I'm new to Elastic stack and I'm having a problem with input-jdbc on Mysql.\r\n```\r\n20:13:26.528 [[main]<jdbc] ERROR logstash.pipeline - A plugin had an unrecoverable error. Will restart this plugin.\r\n  Plugin: <LogStash::Inputs::Jdbc jdbc_driver_library=>\"/usr/share/java/mysql-connector-java.jar\", jdbc_driver_class=>\"com.mysql.jdbc.Driver\", jdbc_connection_string=>\"jdbc:mysql://127.0.0.1:3036/wf_sg\", jdbc_user=>\"root\", jdbc_password=><password>, statement=>\"SELECT * from activity;\", id=>\"aa5a0b8b240d1c8d0b530919aba7fa7b73df3268-1\", enable_metric=>true, codec=><LogStash::Codecs::Plain id=>\"plain_725d48eb-2fab-4495-b148-9a3506252a89\", enable_metric=>true, charset=>\"UTF-8\">, jdbc_paging_enabled=>false, jdbc_page_size=>100000, jdbc_validate_connection=>false, jdbc_validation_timeout=>3600, jdbc_pool_timeout=>5, sql_log_level=>\"info\", connection_retry_attempts=>1, connection_retry_attempts_wait_time=>0.5, parameters=>{\"sql_last_value\"=>1970-01-01 00:00:00 UTC}, last_run_metadata_path=>\"/home/falaki/.logstash_jdbc_last_run\", use_column_value=>false, tracking_column_type=>\"numeric\", clean_run=>false, record_last_run=>true, lowercase_column_names=>true>\r\n  Error: undefined method `close_jdbc_connection' for #<Sequel::JDBC::Database:0x6a2350f1>\r\n```\r\nMost significant extract :\r\n```\r\nError: undefined method `close_jdbc_connection' for #<Sequel::JDBC::Database:0x6a2350f1>\r\n```\r\n\r\n- OS : Debian 7 (Wheezy) Linux 3.2.81-1 x86_64\r\n- Java : 1.8.0_31\r\n- Logstash : 5.5.0\r\n- Mysql 14.4\r\n\r\nI'm executing `/usr/share/logstash/bin/logstash -f simple-out.conf`, with this config :\r\n```\r\ninput {\r\n    jdbc {\r\n        jdbc_driver_library => \"/usr/share/java/mysql-connector-java.jar\"\r\n        jdbc_driver_class => \"com.mysql.jdbc.Driver\"\r\n        jdbc_connection_string => \"jdbc:mysql://127.0.0.1:3036/wf_sg\"\r\n        jdbc_user => \"root\"\r\n        jdbc_password => \"darootpassword\"\r\n        statement => \"SELECT * from activity\"\r\n    }\r\n}\r\noutput {\r\n    stdout { codec => json_lines }\r\n}\r\n```\r\n\r\nI've seen other people having this issue recently on StackOverflow.\r\nThanks for yout help"}}
{"actor":{"display_login":"TitoVince35"}}