Mixing
Getting error “An operation on a socket could not be performed…” with XAMPP and Windows again and again
I have a PHP application which is running under XAMPP (Windows Environment : Windows server 2012).
Now very often I am getting an error while trying to login via a MySql web client (adminer https://www.adminer.org/) as follow;
An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full.
I've found one solution which describes restarting the physical server (not xampp). And it worked. But in the very next day it happened again. And once again I restarted it but in a few interval the error is coming again and again.
FYI;
- Restarting XAMPP is not working
- Restarting MySql server is not working
- Only if I restart physical server then it is working for a while.
- The server was working fine along with all current configuration from last 6 months and this problem starts to come from last few days only.
In the server;
- The CPU consumption is around 30% to 40% when top load
- RAM consumption on average 40% to 50%
- The HDD is 90GB in which 10GB to 12GB is free still (only one drive is there that is C)
I am not getting properly the reason of the error.
php mysql xampp
edited Jan 8 at 11:14
yivi
5,58872755
asked Jan 2 at 8:44
KOUSIK MANDALKOUSIK MANDAL
1,0891130
add a comment |
I have a PHP application which is running under XAMPP (Windows Environment : Windows server 2012).
Now very often I am getting an error while trying to login via a MySql web client (adminer https://www.adminer.org/) as follow;
An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full.
I've found one solution which describes restarting the physical server (not xampp). And it worked. But in the very next day it happened again. And once again I restarted it but in a few interval the error is coming again and again.
FYI;
- Restarting XAMPP is not working
- Restarting MySql server is not working
- Only if I restart physical server then it is working for a while.
- The server was working fine along with all current configuration from last 6 months and this problem starts to come from last few days only.
In the server;
- The CPU consumption is around 30% to 40% when top load
- RAM consumption on average 40% to 50%
- The HDD is 90GB in which 10GB to 12GB is free still (only one drive is there that is C)
I am not getting properly the reason of the error.
php mysql xampp
edited Jan 8 at 11:14
yivi
5,58872755
asked Jan 2 at 8:44
KOUSIK MANDALKOUSIK MANDAL
1,0891130
Seems like a port issue. Did you tried changing tcp port limit? support.microsoft.com/en-us/help/196271/…
– mim.
Jan 2 at 8:54
Apache is running on port 80 and mysql is 3306 which is by default. Do I need to change port limit for this default configuration? And if it is port limit issue then why is it not happening always rather becomes fine after physical server restart for few hours?
– KOUSIK MANDAL
Jan 2 at 8:59
1
In 2012 the port limit should not be the issue, your PC may be making too many outgoing requests causing port exhaustion, inspect your network requests, your PC may also be infected with a virus which is making the requests.
– Munim Munna
Jan 8 at 15:31
add a comment |
I have a PHP application which is running under XAMPP (Windows Environment : Windows server 2012).
Now very often I am getting an error while trying to login via a MySql web client (adminer https://www.adminer.org/) as follow;
An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full.
I've found one solution which describes restarting the physical server (not xampp). And it worked. But in the very next day it happened again. And once again I restarted it but in a few interval the error is coming again and again.
FYI;
- Restarting XAMPP is not working
- Restarting MySql server is not working
- Only if I restart physical server then it is working for a while.
- The server was working fine along with all current configuration from last 6 months and this problem starts to come from last few days only.
In the server;
- The CPU consumption is around 30% to 40% when top load
- RAM consumption on average 40% to 50%
- The HDD is 90GB in which 10GB to 12GB is free still (only one drive is there that is C)
I am not getting properly the reason of the error.
php mysql xampp
edited Jan 8 at 11:14
yivi
5,58872755
asked Jan 2 at 8:44
KOUSIK MANDALKOUSIK MANDAL
1,0891130
I have a PHP application which is running under XAMPP (Windows Environment : Windows server 2012).
Now very often I am getting an error while trying to login via a MySql web client (adminer https://www.adminer.org/) as follow;
An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full.
I've found one solution which describes restarting the physical server (not xampp). And it worked. But in the very next day it happened again. And once again I restarted it but in a few interval the error is coming again and again.
FYI;
- Restarting XAMPP is not working
- Restarting MySql server is not working
- Only if I restart physical server then it is working for a while.
- The server was working fine along with all current configuration from last 6 months and this problem starts to come from last few days only.
In the server;
- The CPU consumption is around 30% to 40% when top load
- RAM consumption on average 40% to 50%
- The HDD is 90GB in which 10GB to 12GB is free still (only one drive is there that is C)
I am not getting properly the reason of the error.
php mysql xampp
php mysql xampp
edited Jan 8 at 11:14
yivi
5,58872755
asked Jan 2 at 8:44
KOUSIK MANDALKOUSIK MANDAL
1,0891130
edited Jan 8 at 11:14
yivi
5,58872755
asked Jan 2 at 8:44
KOUSIK MANDALKOUSIK MANDAL
1,0891130
edited Jan 8 at 11:14
yivi
5,58872755
edited Jan 8 at 11:14
yivi
5,58872755
edited Jan 8 at 11:14
yivi
5,58872755
5,58872755
asked Jan 2 at 8:44
KOUSIK MANDALKOUSIK MANDAL
1,0891130
asked Jan 2 at 8:44
KOUSIK MANDALKOUSIK MANDAL
1,0891130
asked Jan 2 at 8:44
KOUSIK MANDALKOUSIK MANDAL
1,0891130
1,0891130
Seems like a port issue. Did you tried changing tcp port limit? support.microsoft.com/en-us/help/196271/…
– mim.
Jan 2 at 8:54
Apache is running on port 80 and mysql is 3306 which is by default. Do I need to change port limit for this default configuration? And if it is port limit issue then why is it not happening always rather becomes fine after physical server restart for few hours?
– KOUSIK MANDAL
Jan 2 at 8:59
1
In 2012 the port limit should not be the issue, your PC may be making too many outgoing requests causing port exhaustion, inspect your network requests, your PC may also be infected with a virus which is making the requests.
– Munim Munna
Jan 8 at 15:31
add a comment |
Seems like a port issue. Did you tried changing tcp port limit? support.microsoft.com/en-us/help/196271/…
– mim.
Jan 2 at 8:54
Apache is running on port 80 and mysql is 3306 which is by default. Do I need to change port limit for this default configuration? And if it is port limit issue then why is it not happening always rather becomes fine after physical server restart for few hours?
– KOUSIK MANDAL
Jan 2 at 8:59
1
In 2012 the port limit should not be the issue, your PC may be making too many outgoing requests causing port exhaustion, inspect your network requests, your PC may also be infected with a virus which is making the requests.
– Munim Munna
Jan 8 at 15:31
Seems like a port issue. Did you tried changing tcp port limit? support.microsoft.com/en-us/help/196271/…
– mim.
Jan 2 at 8:54
Seems like a port issue. Did you tried changing tcp port limit? support.microsoft.com/en-us/help/196271/…
– mim.
Jan 2 at 8:54
Apache is running on port 80 and mysql is 3306 which is by default. Do I need to change port limit for this default configuration? And if it is port limit issue then why is it not happening always rather becomes fine after physical server restart for few hours?
– KOUSIK MANDAL
Jan 2 at 8:59
Apache is running on port 80 and mysql is 3306 which is by default. Do I need to change port limit for this default configuration? And if it is port limit issue then why is it not happening always rather becomes fine after physical server restart for few hours?
– KOUSIK MANDAL
Jan 2 at 8:59
1
1
In 2012 the port limit should not be the issue, your PC may be making too many outgoing requests causing port exhaustion, inspect your network requests, your PC may also be infected with a virus which is making the requests.
– Munim Munna
Jan 8 at 15:31
In 2012 the port limit should not be the issue, your PC may be making too many outgoing requests causing port exhaustion, inspect your network requests, your PC may also be infected with a virus which is making the requests.
– Munim Munna
Jan 8 at 15:31
add a comment |
2 Answers
2
active
oldest
votes
Windows server 2012 has limit of outbound ports of 5000. The OS is trying to establish an outbound TCP connection from a port with a number greater than 5000 in your case.
Here's how to reconfigure OS to raise the limit https://support.microsoft.com/en-us/help/196271/when-you-try-to-connect-from-tcp-ports-greater-than-5000-you-receive-t
The real solution, though is to introduce connection pooling.
answered Jan 8 at 19:56
Sam DarkSam Dark
4,68712847
add a comment |
Are you running Skype and XAMPP at the same time? If yes, try disabling Skype and re-run XAMPP.
answered Jan 13 at 7:06
moreishimoreishi
234
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54003420%2fgetting-error-an-operation-on-a-socket-could-not-be-performed-with-xampp-an%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Windows server 2012 has limit of outbound ports of 5000. The OS is trying to establish an outbound TCP connection from a port with a number greater than 5000 in your case.
Here's how to reconfigure OS to raise the limit https://support.microsoft.com/en-us/help/196271/when-you-try-to-connect-from-tcp-ports-greater-than-5000-you-receive-t
The real solution, though is to introduce connection pooling.
answered Jan 8 at 19:56
Sam DarkSam Dark
4,68712847
add a comment |
Windows server 2012 has limit of outbound ports of 5000. The OS is trying to establish an outbound TCP connection from a port with a number greater than 5000 in your case.
Here's how to reconfigure OS to raise the limit https://support.microsoft.com/en-us/help/196271/when-you-try-to-connect-from-tcp-ports-greater-than-5000-you-receive-t
The real solution, though is to introduce connection pooling.
answered Jan 8 at 19:56
Sam DarkSam Dark
4,68712847
add a comment |
Windows server 2012 has limit of outbound ports of 5000. The OS is trying to establish an outbound TCP connection from a port with a number greater than 5000 in your case.
Here's how to reconfigure OS to raise the limit https://support.microsoft.com/en-us/help/196271/when-you-try-to-connect-from-tcp-ports-greater-than-5000-you-receive-t
The real solution, though is to introduce connection pooling.
answered Jan 8 at 19:56
Sam DarkSam Dark
4,68712847
Windows server 2012 has limit of outbound ports of 5000. The OS is trying to establish an outbound TCP connection from a port with a number greater than 5000 in your case.
Here's how to reconfigure OS to raise the limit https://support.microsoft.com/en-us/help/196271/when-you-try-to-connect-from-tcp-ports-greater-than-5000-you-receive-t
The real solution, though is to introduce connection pooling.
answered Jan 8 at 19:56
Sam DarkSam Dark
4,68712847
answered Jan 8 at 19:56
Sam DarkSam Dark
4,68712847
answered Jan 8 at 19:56
Sam DarkSam Dark
4,68712847
answered Jan 8 at 19:56
Sam DarkSam Dark
4,68712847
4,68712847
add a comment |
add a comment |
Are you running Skype and XAMPP at the same time? If yes, try disabling Skype and re-run XAMPP.
answered Jan 13 at 7:06
moreishimoreishi
234
add a comment |
Are you running Skype and XAMPP at the same time? If yes, try disabling Skype and re-run XAMPP.
answered Jan 13 at 7:06
moreishimoreishi
234
add a comment |
Are you running Skype and XAMPP at the same time? If yes, try disabling Skype and re-run XAMPP.
answered Jan 13 at 7:06
moreishimoreishi
234
Are you running Skype and XAMPP at the same time? If yes, try disabling Skype and re-run XAMPP.
answered Jan 13 at 7:06
moreishimoreishi
234
answered Jan 13 at 7:06
moreishimoreishi
234
answered Jan 13 at 7:06
moreishimoreishi
234
answered Jan 13 at 7:06
moreishimoreishi
234
234
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54003420%2fgetting-error-an-operation-on-a-socket-could-not-be-performed-with-xampp-an%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Seems like a port issue. Did you tried changing tcp port limit? support.microsoft.com/en-us/help/196271/…
– mim.
Jan 2 at 8:54
Apache is running on port 80 and mysql is 3306 which is by default. Do I need to change port limit for this default configuration? And if it is port limit issue then why is it not happening always rather becomes fine after physical server restart for few hours?
– KOUSIK MANDAL
Jan 2 at 8:59
1
In 2012 the port limit should not be the issue, your PC may be making too many outgoing requests causing port exhaustion, inspect your network requests, your PC may also be infected with a virus which is making the requests.
– Munim Munna
Jan 8 at 15:31