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!

Message Parsing in SOCK

Introduction This blog post is part of an ongoing series on SOCK enablement. In this blog post, I will write ...

Exploring the OpenTelemetry Collector’s Kubernetes annotation-based discovery

We’ve already explored a few topics around observability in a Kubernetes environment -- Common Failures in a ...

Use ‘em or lose ‘em | Splunk training units do expire

Whether it’s hummus, a ham sandwich, or a human, almost everything in this world has an expiration date. And, ...