There’s only one Pi per printer, which handles both streaming and octoprint.
I’m not entirely sure what you’re asking for, though. Octoprint has no way of knowing whether the print has failed or not. You are still required to monitor your print to ensure it is not failing. Octoprint also does not analyze the file (beyond showing you a pretty render of the g-code) at all. Its job is simply to shuffle the g-code out the serial port and let the printer handle it. Thus, the event log will show a successful print whether it actually printed or just spaghetti’d, unless you manually cancel the print.