I created a large data model with data sets and tried pivot, it worked for a couple of times, but then it started to fail with the following error.
The issue was that I am working with t2.micro AWS cloud instance with really limited RAM, the search job was causing the RAM requirements to shoot up, which was not a problem because behind the scenes it seems I was using my burstable memory credits.
Once I ran out of credit, the OOM killer kicked in and started to kill the Splunkd process that was running the job!
Changing the instance type of the Linux machine fixed the issue.
The issue was that I am working with t2.micro AWS cloud instance with really limited RAM, the search job was causing the RAM requirements to shoot up, which was not a problem because behind the scenes it seems I was using my burstable memory credits.
Once I ran out of credit, the OOM killer kicked in and started to kill the Splunkd process that was running the job!
Changing the instance type of the Linux machine fixed the issue.
