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/SpamFinder.pm
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.
--
Bob Walker
http://london.randomness.org.uk/
For great beery Justice!