Apache/Perl/MySQL website hangs on local IP address but not on localhost

Letterpart
Letterpart used Ask the Experts™
on
Hi,

We have an Apache webserver running Perl + Template Toolkit and a MySQL database for user access on a VM running Windows 2012 R2.

We have recently made some tweaks to the Perl code, nothing big, just a few edits and extra templates and some design changes (CSS etc). this was tested for several months on an identical dev server and we didn't see any issues.

We went live with the changes and everything was fine for about a week but now we are seeing an odd issue where the site hangs when navigating between pages then works fine for a bit and then hangs again. No pattern to this at all. Sometimes its fine for a few minutes, other times its seconds before it hangs again.

CPU usage is about 15%, Ram is at 80% but always as been as we only have 2GB on here. Neither of them peak or change when the browser hangs.

The issue we are seeing is if we browse the website using the local IP then we see this issue.

If we browse the site using localhost in the same browser (different tab) we never see this issue.

So we can be sat with the site hanging on the IP tab but still able to browse about in the other tab on localhost.

Our db is tiny (only about 200 users, the site isn't hugely busy and nothing else has changed.

Before we go rolling the system back, should we be looking anywhere in particular that could cause this disparity between browsing using the local IP and localhost?

We've:

Reset the IP stack, reinstalled VMtool drivers and reset up the interface.
Disabled anti virus, checked all over for issues.

EDIT
We have stopped Apache and replaced our code with the original files and it was fine. No hangs. So we put the new files back in place and it is still working ok.

Seems the restart of Apache has cleared the issue for now but we expect it to come back at some stage. Will continue to test.


Thanks.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
How about the IP 127.0.0.1 ? Is it working fine ?

Author

Commented:
Hi,

Good question.

And no. 127.0.0.1 behaves the same as 10.149.1.11 and is intermittently slow while localhost is ok.
Top Expert 2014

Commented:
When you issue the command "ping localhost" what is the IP address that shows?  Typically localhost is 127.0.0.1, unless you have IP6 running and then it may return the IPV6 local host address.
Should you be charging more for IT Services?

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
Hi, Ping localhost gives me ::1

ping localhost

Pinging webserv1 [::1] with 32 bytes of data:
Reply from ::1: time<1ms
Reply from ::1: time<1ms
Reply from ::1: time<1ms
Reply from ::1: time<1ms

Ping statistics for ::1:
    Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
    Minimum = 0ms, Maximum = 0ms, Average = 0ms

ping -4 localhost

Pinging webserv1 [127.0.0.1] with 32 bytes of data:
Reply from 127.0.0.1: bytes=32 time<1ms TTL=128
Reply from 127.0.0.1: bytes=32 time<1ms TTL=128
Reply from 127.0.0.1: bytes=32 time<1ms TTL=128
Reply from 127.0.0.1: bytes=32 time<1ms TTL=128

Ping statistics for 127.0.0.1:
    Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
    Minimum = 0ms, Maximum = 0ms, Average = 0ms

Open in new window

We have resolved the issue.

I noticed we were getting the following errors in the logs:


[Mon Jan 22 12:23:20 2018] [warn] (OS 64)The specified network name is no longer available. : winnt_accept: Asynchronous AcceptEx failed.

Open in new window


Whether Apache had hung or was working fine. Looked into this in further details, and added:

Win32DisableAcceptEx

to the httpd.conf file, restarted Apache and we have been fine since.

Further details here: Article on Apache.org

Author

Commented:
We resolved the issue ourselves and have updated this thread in case anyone else has the same issue.

While we appreciated the input provided by others, it didn't answer the question nor help us in the correct direction so this time I won't be marking any answers as assisted.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial