Splunk Search

Receiving error for external lookup (MySQL Connector)

splunkIT
Splunk Employee
Splunk Employee

Using the latest version (1.0) of MySQL Connector app for an external lookup. I can connect to the database, through the app, just fine. I can query the database from within Splunk, can enumerate the database structure, etc. However, if I perform a lookup against the database, I receive the following error:

[DALPMVIF0024] Script for lookup table 'muveLookup' returned error code 1. Results may be incorrect

This splunk setup two search heads and three indexers; so it is a distributed search environment.

0 Karma
1 Solution

splunkIT
Splunk Employee
Splunk Employee

The error appears to stem from the fact that we're using the MySQL
Connector in a distributed environment. By adding "head" in the search,
it effectively caused the lookup to happen locally. While this gave the
desired results, limiting the result set was not ideal. So, I've removed
the "head" directive from the search and added "local=1" to the lookup,
which also resolves the problem but without limiting the result set.

View solution in original post

splunkIT
Splunk Employee
Splunk Employee

The error appears to stem from the fact that we're using the MySQL
Connector in a distributed environment. By adding "head" in the search,
it effectively caused the lookup to happen locally. While this gave the
desired results, limiting the result set was not ideal. So, I've removed
the "head" directive from the search and added "local=1" to the lookup,
which also resolves the problem but without limiting the result set.

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 ...