DevOps, CI/CD and Automation

Hello,

The setup is Apache, PHP and Oracle 11 via OCI. The client requests a php page, the php logs into the database and starts a PL/SQL procedure, which in turn starts waiting on an AQ. If it gets a message it emits some output, but otherwise it just stays there. The problem is that the client is going to leave (navigate away from the page) and it does not matter how many timeout settings I try to change in Apache, the connections stay there. If I check the server status on Apache I see that the process stays there even after the client is long gone (I talk about hours). Status W.

I know that I could listen to AQ with nowait and sleep a bit between calls but I would prefer to leave it how it is. Any ideas how to set up a working timeout for this?

Thanks,

K