I filed a case.
Here also the info:
steps to reproduce
1.) Create an Oracle database with a simple schema, six or seven field rows, but 33 million entries.
2.) Setup DBConnect v2 to access the database.
3.) Create a DB Lookup/Mapping based upon the database.
4.) Do a simple search that uses the lookup.
Example setup:
SQL statement out of the inputs.conf:
SELECT * FROM "DATA_HHDEV"."DATA_HHDEV"
transforms.conf:
[data_hhdev]
external_cmd = dblookup.py data_hhdev
fields_list = C_ID,CL_ID,FOOID,AA_ID,SOURCE_ID,ID
savedsearch.conf (contains the scheduled search that uses the dblookup):
search = index=myindex Id="*" foostring | lookup data_hhdev ID as Id OUTPUT SOURCE_ID as scid FOOID as FOOID | collect index=summary testmode=0 marker="type=\"foo_type\""
... View more