连接中断。加载页面时重置与服务器的连接 [英] Connection Interrupted. The connection to the server was reset while the page was loading

问题描述

我使用FF3调用属于MySQL / PHP Web应用程序的PHP脚本。我在本地主机上运行XAMPP。我所得到的是：

连接中断

加载页面时重置了到服务器的连接。
协商连接时，网络连接中断。请尝试一次。

解决方案

有许多可能的解决方案...取决于为什么...所以最终有点反复试验。在全新的安装上，这是很难确定的。但是，如果你最近做了一个重大的改变，那就是开始寻找的地方 - 比如修改虚拟主机或者添加/启用XDebug。

这里列出了一些事情，已经使用/完成/尝试在过去

• 检查无限循环...特别是循环SQL提取结果99％的时间，除了1％没有。在一个例子中，我使用前面两个查询的结果作为for循环的上下界...偶尔也得到了一个UINT max的上界... har har har（ vomit




• 将./php/libmysql.dll复制到windows / system32目录（特别是如果您看到 Parent：child process退出状态3221225477 - 在日志文件中重新启动 ...检出： http://www.java-samples.com/showtutorial.php?tutorialid=1050 ）如果您在运行时修改PHP的error_reporting，则可以使用
  

• 。 ..在某些情况下，这可能会导致PHP退化到一个不稳定的状态，例如，如果在您的PHP代码中，您修改超全球或与其他深层和个人的后台系统变量（Nah，谁会做这种邪恶的hackery？ em> ahem ）

如果您将MySQL转换为MyISAM或mysqli以外的其他类型，则可以使用

MySQL有一个与MyISAM相关的bug，UTF8字符集和索引（http://bugs.mysql.com/bug.php？解决方案是使用InnoDB方言（例如，sql set GLOBAL storage_engine ='InnoDb'; ）

• 这样做会改变创建新表的方式......这可能会稍微改变结果返回到读取语句的方式...导致无限循环，格式错误的数据集等（尽管这种改变不应该挂起数据库本身）

其他有用的项目是增加PHP和Apache的调试报告在他们的配置文件，并重新启动服务器。日志文件有时会提供至少 问题可能存在的线索。如果它发生在你的页面内容完成后更有可能在PHP设置。如果在页面构建过程中，请检查您的PHP代码。等等等等。

希望以上的洗衣清单有助于某一天...当我再次遇到它时，可能是我自己，然后回到这里寻找我是怎么做的上次修复？ ...：）

I am calling a PHP-Script belonging to a MySQL/PHP web application using FF3. I run XAMPP on localhost. All I get is this:

Connection Interrupted
The connection to the server was reset while the page was loading. The network link was interrupted while negotiating a connection. Please try again.

解决方案

There are a number of possible solutions ... depends on the "why" ... so it ends up being a bit of trial and error. On a fresh install, that's tricky to determine. But, if you made a recent "major" change that's a place to start looking - like modifying virtual hosts or adding/enabling XDebug.

Here's a list of things I've used/done/tried in the past

• check for infinite loops ... in particular looping through a SQL fetch result which works 99% of the time except the 1% it doesn't. In one case, I was using the results of two previous queries as the upper and lower bounds of a for loop ... and occasionally got a upper bound of a UINT max ... har har har (vomit)

• copying the ./php/libmysql.dll to the windows/system32 directory (Particularly if you see Parent: child process exited with status 3221225477 -- Restarting in your log files ... check out: http://www.java-samples.com/showtutorial.php?tutorialid=1050)

• if you modify PHP's error_reporting at runtime ... in certain circumstances this can cause PHP to degenerate into an unstable state if, say, in your PHP code you modify the superglobals or fiddle around with other deep and personal background system variables (Nah, who would ever do such evil hackery? ahem)

• if you convert your MySQL to something other than MyISAM or mysqli

There is a known bug with MySQL related to MyISAM, the UTF8 character set and indexes (http://bugs.mysql.com/bug.php?id=4541) Solution is to use InnoDB dialect (eg sql set GLOBAL storage_engine='InnoDb';)

• Doing that changes how new tables are created ... which might slightly alter the way results are returned to a fetch statement ... leading to an infinite loop, a malformed dataset, etc. (although this change should not hang the database itself)

Other helpful items are to ramp up the debug reporting for PHP and apache in their config files and restart the servers. The log files sometimes give a clue as to at least where the problem might reside. If it happens after your page content was finished it's more likely in the php settings. If it's during page construction, check your PHP code. Etc. etc.

Hope the above laundry list helps somebody someday ... probably myself when I run into it again and come back here looking for "how the heck did I fix it last time?" ... :)

这篇关于连接中断。加载页面时重置与服务器的连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！