On Wed, 25 Jul 2007, Earle Martin wrote:
I'm sorry to hear that, Paul. Afraid the mechanics of why this is happening is beyond me. Can anyone on the list suggest methods I can use to investigate? However, my sysadmin skills are weak to non-existent, so please speak slowly and with small words and plenty of explanation (i.e. "use valgrind, man!!1!" won't be of much use to me).
a) use the latest code. (then you can use spam blocking stuff which may help)(http://svn.randomness.org.uk/trunk/london.randomness.org.uk/scripts/lib/RGL/... is rgls) b) provide us with a schema(no data) dump of the database. so we can check that the rigth indexes are in place. c) openguides is now mostly mod_perl safe. however i think there might be an issue with closing postgres db connections. so mod_perl might be an option. althogh i think it will stop working once it runs out of conenctions which will then need a restart so may not be the answer. d) if its google tell it to back off a bit at the google webmasters tools stuff or indeed use robots.txt to block search crawlers.
It could be waves of spam, rogue crawlers gone mad or who knows what, but unfortunately I do not have access to any Apache log files on stix, so trying to find out anything that way is a non-starter.
indeed the log files will help.