topic Re: Error in 'lookup' command: Failed to re-open lookup file in Splunk Search

Error in 'lookup' command: Why is it failing to re-open lookup file?

halu — Thu, 26 Jan 2023 19:00:22 GMT

Hello Splunker!

Sometimes my searches on Splunk Enterprise Security Search Head ran into following error (mostly) without any results, sometimes there are only a view results :

[idx1, idx4 ...] Streamed search execute failed because: Error in 'lookup' command: Failed to re-open lookup file: '/opt/splunk/var/run/searchpeers/splunksearchhead-1631016538/kvstore_s_SA-IdeRjww0FotymhlCIaS1cqkc05a_identix3UXVbINERGdyPwDBuI5US7E'.

Sometimes the searches work, somtimes they not. There is also a "normal" Splunk Search Head, the same search works all the time. If the error appears also the Incident Review needs about

I already checked the bundle size of both Search Heads and the ES bundle is about 800mb. The "normal" Search Head bundle is about 1,1gb.

Splunk Enterprise 8.2.1

Splunk Enterprise Security 6.6.0

Splunk Cluster with 2 sites, each site 8 idx.

I would greatly appreciate any help 🙂

Re: Error in 'lookup' command: Failed to re-open lookup file

sikder — Tue, 16 Nov 2021 14:08:51 GMT

Hello,

I have the same issue after upgrading to Splunk 8.2.3. Did you solve the issue?

Re: Error in 'lookup' command: Failed to re-open lookup file

halu — Mon, 22 Nov 2021 08:38:16 GMT

Sorry no I didn't resolv it yet. The error didn't appear 1-2 weeks, but its still happen user ran into this error

Re: Error in 'lookup' command: Failed to re-open lookup file

satishkompelly — Tue, 28 Dec 2021 19:43:00 GMT

@halu I'm getting the error and the searches are running and getting paused and resume after sometime we also upgraded to 8.2.3 recently, did you find any troubleshooting's to prevent this error.

Satish

Re: Error in 'lookup' command: Failed to re-open lookup file

ljramv — Tue, 04 Oct 2022 08:57:11 GMT

Hi, anybody managed to resolve this? Got a ticket open with Splunk for a month now...

Re: Error in 'lookup' command: Failed to re-open lookup file

amaithani — Thu, 24 Nov 2022 09:28:03 GMT

Please try increasing the max_memtable_bytes to higher than default i.e., 25 MB to 50MB.

Re: Error in 'lookup' command: Failed to re-open lookup file

ljramv — Thu, 24 Nov 2022 09:33:14 GMT

In the ES correlation set up page for Asset and Identity management ensure you have "enable selectively for source types" if used or disable if you don't.

Re: Error in 'lookup' command: Failed to re-open lookup file

wmuselle — Thu, 26 Jan 2023 12:16:35 GMT

could you elaborate on your answer.

The message seems replication bundle related (replication=true for kv store collection).

What is the link with your answer ?

thanks in advance