We have a web page on our server that we use to run administrative scripts. For example, we might run the script "unenrolStudents()" which runs 5,000 SQL SET commands one after another and sets 5000 student entries in an SQL database to unenrolled. However, we are finding that after running a few thousand queries (it is not totally consistent) we will be "locked out" by our server.
SYMPTOMS OF LOCKING OUT:
- unable to connect to server with winSCP
- opening putty with that connection shows a blank screen (no login / pass)
- clearing cookies / cache in chrome does NOT fix locking out
- other computers in the office ALSO become locked out
- locking out can be triggered with a high frequency of requests (10000 in 1 second) or by less over time (10000 in 500 seconds - this will still cause a lockout even though the frequency is much less)
We believe this is a security feature of our own Apache. I know we are using Suhosin but I didn't configure it so I don't know.
How can I disable this locking effect so that I can confidently run all my SQL requests and they will go through? Has anyone else dealt with this and found workarounds?