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

**URL:** <https://discuss.elastic.co/t/logstash-deleting-records-from-db-table-after-running-logstash-conf-file/154405>\
**Category:** Logstash\
**Created:** [October 29, 2018, 9:13am UTC](https://discuss.elastic.co/t/logstash-deleting-records-from-db-table-after-running-logstash-conf-file/154405 "2018-10-29T09:13:11Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![groverjatin17](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/groverjatin17/32/34657_2.png) [@groverjatin17](https://discuss.elastic.co/u/groverjatin17)\
**Post date:** [October 29, 2018, 9:13am UTC](https://discuss.elastic.co/t/logstash-deleting-records-from-db-table-after-running-logstash-conf-file/154405/1 "2018-10-29T09:13:11Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![balumurari1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/balumurari1/32/39203_2.png) [@balumurari1](https://discuss.elastic.co/u/balumurari1)\
**Post date:** [October 29, 2018, 11:46am UTC](https://discuss.elastic.co/t/logstash-deleting-records-from-db-table-after-running-logstash-conf-file/154405/2 "2018-10-29T11:46:45Z")

</div>

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

> [@Handling duplicates from SQL Dumps/json and API response in Logstash](https://discuss.elastic.co/t/handling-duplicates-from-sql-dumps-json-and-api-response-in-logstash/154351/3):
>
> use scheduler, so that it will update the data for every 1 minute as shown below, The input code is fine, in the output did you mention elasticsearch to get the result, Try this, input { jdbc { jdbc\_driver\_library =\> "xxxx\oracle-10g\ojdbc14.jar" jdbc\_driver\_class =\> "oracle.jdbc.driver.OracleDriver" jdbc\_connection\_string =\> "jdbc:oracle:thin:@localhost:1521:DATABASE" jdbc\_user =\> "ROMAINROM" jdbc\_password =\> "ROMAINROM" statement =\> "SELECT TOP 10 \* FROM TABLE" jdbc\_paging\_enabled =\>…

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [October 29, 2018, 9:50pm UTC](https://discuss.elastic.co/t/logstash-deleting-records-from-db-table-after-running-logstash-conf-file/154405/3 "2018-10-29T21:50:51Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [November 26, 2018, 9:50pm UTC](https://discuss.elastic.co/t/logstash-deleting-records-from-db-table-after-running-logstash-conf-file/154405/4 "2018-11-26T21:50:52Z")

</div>

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