We have analyzed the logs and compared the timings with the screenshot shared by bank . We found the below log messages printing in flux-Server1Engine1-5-Jul-2023.log.6 –
05-Jul-2023 15:08:53.235 EDT Server1Engine1 flow_chart FINEST admin [Server1Engine1-Flux Executor Thread [pool-2-thread-47]] SELECT * FROM FLUX_READY WHERE FLUX_READY.PK = 717792082;
05-Jul-2023 15:08:53.251 EDT Server1Engine1 flow_chart FINEST admin [Server1Engine1-Flux Executor Thread [pool-2-thread-47]] SELECT PK FROM FLUX_FLOW_CHART WITH (READPAST) WHERE PK = 717792071;
05-Jul-2023 15:08:53.251 EDT Server1Engine1 flow_chart INFO admin [Server1Engine1-Flux Executor Thread [pool-2-thread-47]] Job has been deleted.
As per above highlighted queries we checked the entries in FLUX_READY (for PK=717792082) and FLUX_FLOWCHART (PK=717792071) but there are no entries in these tables corresponding to these values.
It then prints a message of Job deleted but it is not clear which job. Apart from this we have not found log messages around this timing .