All Apps and Add-ons

DB input stopped after changing rising column field type from int to bigint (DB connect v1.1.7 & MySQL)

Splunk Employee
Splunk Employee

Hi, the DB input was working well until I change rising column field type from int to bigint.

We found the following error message.

Find this error message:

2018-12-10 11:18:59.363 dbx2296:ERROR:TailDatabaseMonitor - DBMon Error while executing monitor=[dbmon-tail://host/table1]: com.splunk.dbx.monitor.DbmonException: Value of rising.column=status_id cannot be stored (not serializable)
com.splunk.dbx.monitor.DbmonException: Value of rising.column=status_id cannot be stored (not serializable)
    at com.splunk.dbx.monitor.impl.TailDatabaseMonitor.getNewValue(TailDatabaseMonitor.java:160)
    at com.splunk.dbx.monitor.impl.TailDatabaseMonitor.performMonitoring(TailDatabaseMonitor.java:136)
    at com.splunk.dbx.monitor.DatabaseMonitorExecutor.executeMonitor(DatabaseMonitorExecutor.java:126)

state.xml for this db input:

<list>
<value key="latest.id">
<value class="int">611538309</value>
</value>
</list>

What did I missed?

0 Karma
1 Solution

Splunk Employee
Splunk Employee

The root cause is class type changed so db input can't parse correctly.
Change state.xml as following works

<list>
 <value key="latest.id">
 <value class="big-decimal">611538309</value>
 </value>
 </list>

View solution in original post

0 Karma

Splunk Employee
Splunk Employee

You are aware that DBX 1.x reached End of Life in like 2016, correct?

0 Karma

Splunk Employee
Splunk Employee

The root cause is class type changed so db input can't parse correctly.
Change state.xml as following works

<list>
 <value key="latest.id">
 <value class="big-decimal">611538309</value>
 </value>
 </list>

View solution in original post

0 Karma