How to debug Splunk DB Connect 2?

[wegscd]

I am getting some inputs converted from Splunk DB Connect 1 to Splunk DB Connect 2.

I have a tail rising column query (using a timestamp field in the database) that I got into V2 and got it working. I did some refinements, but now no more data is showing up in the index.

I can see the query running in rpc.log, though I have no idea of how many rows are getting returned. The tail_rising_column_checkpoint_value is such that I would be expecting more data.

Is there some logging I can crank up on the Splunk end to determine if the data is getting returned from the query and lost on the way to the index, or if the query is not returning any rows???

[jcoates_splunk · Accepted solution]

http://docs.splunk.com/Documentation/DBX/2.0.5/DeployDBX/Troubleshooting

[woodcock]

There is a dbx2.log in the $SPLUNK_HOME/var/log*/ directory on the server where you are running the app. Tjis log is not forwarded so you have to go CLI.

[wegscd]

dbx2.log has even less information in it than rpc.log. Just shows database errors and websocket timeouts.