Logstash deleting records from Db Table after running logstash.conf file

(Jatin) #1

HI all,
I am using ORACLE Db in my case.

I have created a sample table with user_id and names as the only 2 columns in them.

I inserted some 2 records with these values([(1,"sam"),(2,"smith") and so on ]).
I try to execute the logstash.conf file with this structure

input {
    jdbc {
        jdbc_connection_string => "jdbc:oracle:thin:@host:port/XE"
        jdbc_user => "username"
	jdbc_password => "password"
        jdbc_driver_library => "/home/tomadm/JatinSandbox/KibanaDbTry/ojdbc7.jar"
        jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
	#jdbc_validate_connection => true
        statement => "select * from metable"

output {
    stdout { codec => json_lines }
	elasticsearch {
	index => "batchre"
	hosts => "http://my_ip:port"
	document_type => "Batchdoc"

Now after I run this conf file. I see the table in database is rendered empty.
Can anyone suggest what could be the error?


try this, hope this helps, change the details to OracleDB connection details,

(Magnus Bäck) #3

Logstash is not emptying your database table. You should look elsewhere.

(system) #4

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