Jdbcstreaming exception

Elastic Stack Logstash
1

Hi everyone.

I have an issue with jdbc_streaming filter.

My config like..

jdbc_streaming {
		jdbc_driver_library => "/usr/share/logstash/vendor/jar/jdbc/ojdbc6.jar"
		jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
		jdbc_connection_string => "..."	

		jdbc_user => "****"
		jdbc_password => "****"

		statement => "SELECT CID FROM TB_REN016_002 WHERE CID = 10011000001"
					
		target => "matchingCid"	
	}

but, the result come,

[WARN ] 2018-08-29 11:17:35.368 [Ruby-0-Thread-19@[main]>worker11: /usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:384] jdbcstreaming - Exception when executing JDBC query {:exception=>#<Sequel::DatabaseError: Java::JavaSql::SQLRecoverableException: No more data to read from socket>}
{
"headers" => {
"request_method" => "POST",
"request_path" => "/",
"http_connection" => "Keep-Alive",
"content_length" => "580",
"http_version" => "HTTP/1.1",
"content_type" => "application/vnd.onem2m-ntfy+xml;charset=UTF-8",
"request_uri" => "/",
"http_x_m2m_origin" => "00000168702c1ffffe4a2570",
"http_accept" => "application/xml",
"https" => "https",
"http_x_m2m_ri" => "685b0e25-799d-464a-999b-c5b66d725c95",
"http_host" => "218.145.52.139:12443"
},
"thingPlug_time" => [
[0] "2018-08-29T11:17:02+09:00"
],
"message" => "<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?><m2m:cin xmlns:m2m="http://www.onem2m.org/xml/protocols\" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance\"><ty>4</ty><ri>CI00000000003603939500</ri><rn>CI00000000003603939500</rn><pi>CT00000000000000235746</pi><ct>2018-08-29T11:17:02+09:00</ct><lt>2018-08-29T11:17:02+09:00</lt><sr>/0240771000000168/v1_0/remoteCSE-00000168702c1ffffe4a2570/container-LoRa//subscription-rems</sr><et>2018-08-30T11:17:02+09:00</et><st>12215</st><cr>RC00000000000000242315</cr><cnf>LoRa/Sensor</cnf><cs>10</cs><con>1401010039</con></m2m:cin>",
"tags" => [
[0] "_jdbcstreamingfailure",
[1] "_jdbcstreamingdefaultsused"
],
"parsed_sr" => [
[0] "/0240771000000168/v1_0/remoteCSE-00000168702c1ffffe4a2570/container-LoRa//subscription-rems"
],
"host" => "211.234.246.200",
"matchingCid" => [
[0] {}
],
"data_info" => {
"flag" => "0"
},
"@timestamp" => 2018-08-29T02:17:35.255Z,
"parsed_con" => [
[0] "1401010039"
]
}

it's end.. What can I do?

2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.