Getting Data In

DBconnect update data error

laiyongmao
Path Finder

I use DBconnect, when I update the data in the database, a fault occurs, the inside of the Splunk display information and database display different.i think it is a bug..

In the database.

mysql> update updatetest set ID=ID+1;

mysql> select * from updatetest;
+------+------+
| ID | name |
+------+------+
| 2 | jim |
| 3 | anny |
+------+------+
2 rows in set (0.00 sec)

on my splunk

search index=updatetest
13-12-5 下午07时12分19.000秒 id=3 name=anny
host = localhost source = dbmon-tail://updatetest/updatetest sourcetype = updatetest

13-12-5 下午07时07分05.000秒 id=2 name=anny
host = localhost source = dbmon-tail://updatetest/updatetest sourcetype = updatetest

13-12-5 下午07时07分05.000秒 id=1 name=jim
host = localhost source = dbmon-tail://updatetest/updatetest sourcetype = updatetes

I don't know why, I hope someone can help me

Tags (2)
0 Karma
1 Solution

laiyongmao
Path Finder

After creating an entry via either dbmon-dump or dbmon-tail inputs,
deleting the entry or creating a new entry does not remove the data from
the internal_index. This is due to a state caching issue. Workaround:
Clone the database input, then disable (or delete) the old input. (DBX-281)

View solution in original post

0 Karma

laiyongmao
Path Finder

After creating an entry via either dbmon-dump or dbmon-tail inputs,
deleting the entry or creating a new entry does not remove the data from
the internal_index. This is due to a state caching issue. Workaround:
Clone the database input, then disable (or delete) the old input. (DBX-281)

0 Karma

laiyongmao
Path Finder

Have to find a solution.

0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...