<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
</head>
<body>
Hi Francis,<br>
I think the MariaDB errors might not be connected Ted to the EPrint exportview errors.<br>
<br>
First, the MariaDB errors - this might be useful:<br>
https://serverfault.com/questions/393862/mysql-warning-ip-address-could-not-be-resolved<br>
<br>
Adjusting the MariaDB configuration and/or firewall setting on your server should help.<br>
<br>
For the exportview errors, this can be a result of someone (or some machine) making a request, but not waiting for a response. This can happen because the export views can take a bit of time to generate. If they take too long, a browser might timeout - and
the user might try again - increasing load on the server.<br>
<br>
If possible, try and match up the entries in the Apache error log with entries in the Apache access log. You may be able to see the parameters that are being requested - and then be able to recreate the issue.<br>
<br>
It may be that the exportview request contains many EPrints, with lots of authors (e.g. some physics papers might have thousands of authors), which will take time to generate.<br>
If we can understand exactly what causes the slow response, we may be able to fix it!<br>
<br>
There may even be robots visiting your repository that aren't behaving nicely - which you could block with firewall rules.<br>
<br>
I hope some of that helps!<br>
Cheers,<br>
John
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> eprints-tech-bounces@ecs.soton.ac.uk <eprints-tech-bounces@ecs.soton.ac.uk> on behalf of Francis Jayakanth via Eprints-tech <eprints-tech@ecs.soton.ac.uk><br>
<b>Sent:</b> 05 April 2019 19:09:21<br>
<b>To:</b> eprints-tech@ecs.soton.ac.uk<br>
<b>Subject:</b> [EP-tech] ePrints server is freezing very often</font>
<div> </div>
</div>
<div class="BodyFragment"><font size="2"><span style="font-size:11pt;">
<div class="PlainText">Hi Everyone, In the recent past, our eprints server,<br>
eprints.iisc.ac.in, in becoming unresponsive very frequently - i would<br>
say, once every 30 minutes. Restarting the httpd server brings back<br>
the server, but in less than 30 minutes it freezes again! I had a look<br>
at the httpd error log file, and was surprised to see that the log<br>
file is full of entries similar to the ones indicated below:<br>
<br>
[Fri Apr 05 22:44:43.717856 2019] [:error] [pid 114613] :Apache2 IO<br>
write: (32) Broken pipe at /opt/eprints3/cgi/exportview line 108<br>
[Fri Apr 05 22:44:52.392811 2019] [:error] [pid 114910] :Apache2 IO<br>
write: (32) Broken pipe at /opt/eprints3/cgi/exportview line 108<br>
[Fri Apr 05 22:44:58.314788 2019] [:error] [pid 114919] :Apache2 IO<br>
write: (32) Broken pipe at /opt/eprints3/cgi/exportview line 108<br>
<br>
I also had a look at the Mariadb log file, which is bombarded with<br>
entries indicated below:<br>
<br>
190405 23:23:59 [Warning] IP address '104.236.158.58' could not be<br>
resolved: Name or service not known<br>
190405 23:24:54 [Warning] IP address '104.248.56.116' could not be<br>
resolved: Name or service not known<br>
190405 23:25:25 [Warning] IP address '180.250.18.136' could not be<br>
resolved: Name or service not known<br>
190405 23:26:31 [Warning] IP address '157.230.33.59' could not be<br>
resolved: Name or service not known<br>
190405 23:26:59 [Warning] IP address '104.236.248.209' could not be<br>
resolved: Name or service not known<br>
<br>
All the IPs listed in the Mariadb log file have their origins in<br>
China, South Korea, and other places.<br>
<br>
Can someone help me to resolve the issue, please?.<br>
<br>
We are running, eprints version: 3.3.15 eps on CentOS Linux release<br>
7.4.1708 (Core)<br>
<br>
Thanks and regards, Francis<br>
*** Options: <a href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">
http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><br>
*** Archive: <a href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.eprints.org%2Ftech.php%2F&data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7Ccebc202f61cd47d9f05a08d6ba0b5ea8%7C4a5378f929f44d3ebe89669d03ada9d8%7C0&sdata=NMGxvVws72zKO3dOXfzNXZvMGXqLJfn55IcOIdukYRU%3D&reserved=0" originalSrc="http://www.eprints.org/tech.php/" shash="S1P6fNMxjb4FjFZGqT5Aret+jHNq+7eyHHNdibszTz1mCgiX+f1nh/FySp/w2VKDDaJURScDeyTJfr5F5v9wlVp7QwQxOvKqJ45eEHixTTdWKZbd38m/MRBmmTn5zu4D2bmrY5lpmjNlhT0Uz3kjG689oBN3p6kg3e1qfweHCoU=">http://www.eprints.org/tech.php/</a><br>
*** EPrints community wiki: <a href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwiki.eprints.org%2F&data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7Ccebc202f61cd47d9f05a08d6ba0b5ea8%7C4a5378f929f44d3ebe89669d03ada9d8%7C0&sdata=CYcBDRw2NEo5oHvu9X19TLMe8xnCaCS1C0tr32rNWfU%3D&reserved=0" originalSrc="http://wiki.eprints.org/" shash="EiNa0SsWxuXYUpjyLRLOzoj8dzOs1YJhBdh9UB+7h4zRDQr4J471TvlCOVjREA8UJjzqf4knrfJ24SF5yfDJeFVvcyEgOGWNNXQxOx0oqXGv83B1dfCHbdRilDiHSMlQiXo25p62nNhC3ozXwIVxoarvck+tVycgVuo1bM8AKqg=">http://wiki.eprints.org/</a><br>
*** EPrints developers Forum: <a href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fforum.eprints.org%2F&data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7Ccebc202f61cd47d9f05a08d6ba0b5ea8%7C4a5378f929f44d3ebe89669d03ada9d8%7C0&sdata=eeyXcagKn7D6qXuCvwbAAv7kCzmNTyI%2Bz7EEZ9E5WDw%3D&reserved=0" originalSrc="http://forum.eprints.org/" shash="ZMAESfy7WidEClNKYfMPT9xyL7LbXUQu2hKdIcN/VnvBKVP7LV3igIN9MMLCGP2ZVOQiuEXp0dSfIptI9bxkmljehEgtGqkajM9SblpaFn4EdXHF0mxbDpJjfpRc1iS8aFb9PnmxUKltjqQJaBxi92TQkBBHKMRC5O+hOH+FBRM=">http://forum.eprints.org/</a><br>
</div>
</span></font></div>
</body>
</html>