查询异常laravel 5.4 [英] Query exception laravel 5.4
问题描述
有时我会在laravel应用程序上进行登录时，遇到此错误:
When i will do a login sometimes on my laravel application i face this error:
有人知道这可能是什么吗?
Someone knows what could be this?
PS:这并非总是发生；
PS: this not happen all times;
我正在x64机器上使用xampp，该机器具有Windows 10家庭版，核心i5处理器和8 GB的RAM. 还使用虚拟服务器在开发模式下运行.
I'm using xampp on a x64 machine with windows 10 home, with a core i5 processor, and 8 GB of RAM. Also using a virtual server to run on development mode.
推荐答案
错误实际上并非来自MySQL，而是来自Windows本身:
The error actually does not come from MySQL, but from Windows itself:
关闭连接后，在关闭连接的一侧，元组{Protocol，Local IP，Local Port，Remote IP，Remote Port}默认进入TIME_WAIT状态，持续240秒.
When a connection is closed, on the side that is closing the connection, the tuple {Protocol, Local IP, Local Port, Remote IP, Remote Port} enters a TIME_WAIT state for 240 seconds by default.
在这种情况下，协议已更正-TCP
In this case, the protocol is corrected - TCP
本地IP，远程IP和远程PORT也通常是固定的.因此，该变量是本地端口.
Local IP, Remote IP, and Remote PORT are also typically fixed. Therefore, the variable is the local port.
发生的情况是，当您不绑定1024-5000范围内的端口时.因此，大约有4000个端口.如果您在4分钟内使用所有这些端口，这意味着您在4分钟内每秒进行16次Web服务调用，您将耗尽所有端口.这就是导致此异常的原因.
What happens is that when you do not bind a port in the range 1024-5000 is used. So, roughly, you have 4000 ports. If you use all of them in 4 minutes - meaning that you make 16 web service calls per second for 4 minutes, you will exhaust all ports. That is the cause of this exception.
换句话说，您在动态范围内跑出了门.这可能不应该发生.
In other words, you ran out of doors in the dynamic range. This probably should not be happening.
如何解决: 设置TcpTimedWaitDelay(TIME_WAIT):使用regedit命令访问HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ TCPIP \ Parameters注册表子项.创建一个新的REG_DWORD值，名为TcpTimedWaitDelay. ...停止并重新启动系统.
how to fix: To set TcpTimedWaitDelay (TIME_WAIT): Use the regedit command to access the HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\ Services\TCPIP\Parameters registry subkey. Create a new REG_DWORD value named TcpTimedWaitDelay. ... Stop and restart the system.
这篇关于查询异常laravel 5.4的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
