Hello Jose, I dont believe in a specific IP to be the culprit for exhausting your connection pool. This is a bit like thinking in terms of enemies out there on the hostile internet. I would follow the issue with you logfiles being owned by root though. That looks serious to me.
There are logfiles at different levels and you might find out more if you consult all of them e.g. the dspace log, tomcat log (not written by default), the apache logs, either access log or error log. postgres will also write logs. Another way is to take a look from the outside. Are you monitoring your machine? We use the most simplistic thing available, a free service called mon.itor.us which ticks our machine on port 80 every fifteen minutes or so and reports availybility and average round trip time, which is not much but gives me a baseline so that I know whether the measures I take are for better of for worse. You might find out that there is a time pat- tern, e.g. it gets slow every day at 10pm and you find similar pattern in the logs. That would be a better hint. I dont know your platform, but there has to be some basic facility to log cpu and memory usage or connection attempts at the network inter- face level. Maybe your firewall knows about that. There is cool new tool called dstat for Linux that I would like to use, but it is not available on MacOS. There Error message you posted does not tell me a thing. If you tell us some more about your system setup, then maybe, somebody can tell you more, how to track this down. Beside OS and version numbers of all parts of your software, regarding the SQL connection errors, dont forget to include the JDBC connector version. Is the DB on the same machine? You recently mentioned that you had issues with large files. Now you tell, that crawlers also load bitstreams. If your DB is not on the same machine but communicating over the same physical interface, the download of bitstreams might compete for bandwidth with your DB connection. Maybe this solution is much too complicated, but you might understand which kind of things are inter- esting to know about your setup to discuss the type of problems you reported. Bye, Christian ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
