<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><head><title></title>
<META http-equiv=Content-Type content="text/html; charset=koi8-r">
<meta http-equiv="Content-Style-Type" content="text/css">
<style type="text/css"><!--
body {
margin: 5px 5px 5px 5px;
background-color: #ffffff;
}
/* ========== Text Styles ========== */
hr { color: #000000}
body, table /* Normal text */
{
font-size: 9pt;
font-family: 'Courier New';
font-style: normal;
font-weight: normal;
color: #000000;
text-decoration: none;
}
span.rvts1 /* Heading */
{
font-size: 10pt;
font-family: 'Arial';
font-weight: bold;
color: #0000ff;
}
span.rvts2 /* Subheading */
{
font-size: 10pt;
font-family: 'Arial';
font-weight: bold;
color: #000080;
}
span.rvts3 /* Keywords */
{
font-size: 10pt;
font-family: 'Arial';
font-style: italic;
color: #800000;
}
a.rvts4, span.rvts4 /* Jump 1 */
{
font-size: 10pt;
font-family: 'Arial';
color: #008000;
text-decoration: underline;
}
a.rvts5, span.rvts5 /* Jump 2 */
{
font-size: 10pt;
font-family: 'Arial';
color: #008000;
text-decoration: underline;
}
span.rvts6
{
font-size: 11pt;
font-family: 'tahoma';
font-weight: bold;
color: #ffffff;
background-color: #0000ff;
}
span.rvts7
{
font-size: 11pt;
font-family: 'tahoma';
}
a.rvts8, span.rvts8
{
font-size: 11pt;
font-family: 'tahoma';
color: #0000ff;
text-decoration: underline;
}
span.rvts9
{
font-size: 8pt;
font-family: 'arial';
font-style: italic;
color: #c0c0c0;
}
a.rvts10, span.rvts10
{
font-size: 8pt;
font-family: 'arial';
color: #0000ff;
text-decoration: underline;
}
/* ========== Para Styles ========== */
p,ul,ol /* Paragraph Style */
{
text-align: left;
text-indent: 0px;
padding: 0px 0px 0px 0px;
margin: 0px 0px 0px 0px;
}
.rvps1 /* Centered */
{
text-align: center;
}
--></style>
</head>
<body>
<p>Здравствуйте.</p>
<p><br></p>
<p>Раньше намного.</p>
<p>я написал:</p>
<p><span class=rvts7>client_max_body_size 1024M;</span></p>
<p><br></p>
<div><table border=0 cellpadding=1 cellspacing=2>
<tr valign=top>
<td width=12 style="background-color: #0000ff;">
<p><span class=rvts6>></span></p>
</td>
<td width=739 style="background-color: #ffffff;">
<p><span class=rvts7>ошибка появляется через 300 секунд или много раньше? </span></p>
<p><br></p>
<p><br></p>
<p><span class=rvts7>2007/9/18, Alexey Bobok <</span><a class=rvts8 href="mailto:alexey.bobok@gmail.com">alexey.bobok@gmail.com</a><span class=rvts7>>:</span></p>
<p><span class=rvts7>Здравствуйте.</span></p>
<p><br></p>
<p><span class=rvts7>Поставил нереальные цифры</span></p>
<p><span class=rvts7> proxy_send_timeout 300;</span></p>
<p><span class=rvts7> proxy_read_timeout 300;</span></p>
<p><br></p>
<p><span class=rvts7>то же самое...</span></p>
<p><span class=rvts7>502 Bad Gateway</span></p>
<p><br></p>
<p><span class=rvts7>> не оно ли?</span></p>
<p><br></p>
<p><br></p>
<p><br></p>
<p><span class=rvts7>> </span><a class=rvts8 href="http://sysoev.ru/nginx/docs">http://sysoev.ru/nginx/docs</a><span class=rvts7>/http/ngx_http_proxy_module.html#proxy_send_timeout</span></p>
<p><br></p>
<p><span class=rvts7>> </span><a class=rvts8 href="http://sysoev.ru/nginx/docs">http://sysoev.ru/nginx/docs</a><span class=rvts7>/http/ngx_http_proxy_module.html#proxy_read_timeout</span></p>
<p><br></p>
<p><span class=rvts7>> </span><a class=rvts8 href="http://sysoev.ru/nginx/docs">http://sysoev.ru/nginx/docs</a><span class=rvts7>/http/ngx_http_proxy_module.html#proxy_connect_timeout</span></p>
<p><br></p>
<p><br></p>
<p><br></p>
<p><br></p>
<p><br></p>
<p><span class=rvts7>> предполагаю, что возникает длительный таймаут чтения ответа от</span></p>
<p><span class=rvts7>> апстрима (от апача). Посколько апачу нечего ответить,</span></p>
<p><span class=rvts7>> пока выполняется рестор из дампа.</span></p>
<p><br></p>
<p><br></p>
<p><br></p>
<p><span class=rvts7>> 18.09.07, 11:35, Alexey Bobok (</span><a class=rvts8 href="mailto:alexey.bobok@gmail.com">alexey.bobok@gmail.com</a><span class=rvts7>):</span></p>
<p><br></p>
<p><br></p>
<p><br></p>
<p><span class=rvts7>>> Здравствуйте.</span></p>
<p><br></p>
<p><span class=rvts7>>> Есть связка Inet - nginx (внешний IP) - Apache(</span><a class=rvts8 href="http://127.0.0.2">127.0.0.2</a><span class=rvts7>)</span></p>
<p><br></p>
<p><span class=rvts7>>> При аплоаде файла дампа sql-баз (2,65 Mb) возникает ошибка</span></p>
<p><br></p>
<p><span class=rvts7>>> 502 Bad Gateway</span></p>
<p><br></p>
<p><span class=rvts7>>> вот что в логах nginx:</span></p>
<p><br></p>
<p><span class=rvts7>>> ##############</span></p>
<p><br></p>
<p><span class=rvts7>>> 2007/09/18 10:18:53 [warn] 85681#0: *172 a client request body is buffered to a temporary file</span></p>
<p><br></p>
<p><span class=rvts7>>> /var/tmp/nginx/client_body _temp/0000000003, client: 89.252.*.52, server: phpma.*.*.kiev.ua,</span></p>
<p><br></p>
<p><span class=rvts7>>> URL: "/import.php", host: "phpma.*.*.kiev.ua",</span></p>
<p><br></p>
<p><span class=rvts7>>> referrer: "</span><a class=rvts8 href="http://phpma.*.*.kiev.ua">http://phpma.*.*.kiev.ua </a><span class=rvts7>/server_import.php?token=7dcc2f606674b18493a80bc1fec69d50"</span></p>
<p><br></p>
<p><span class=rvts7>>> 2007/09/18 10:19:29 [error] 85681#0: *172 upstream prematurely closed connection while</span></p>
<p><br></p>
<p><span class=rvts7>>> reading response header from upstream, client: 89.252.*.52, server:</span></p>
<p><br></p>
<p><span class=rvts7>>> phpma.*.*.kiev.ua, URL: "/import.php", upstream: "</span><a class=rvts8 href="http://127.0.0.2:80/import.php">http://127.0.0.2:80/import.php</a><span class=rvts7>", host: "phpma.*.*.kiev.ua", referrer: </span></p>
<p><br></p>
<p><span class=rvts7>>> "</span><a class=rvts8 href="http://phpma.*.*.kiev.ua">http://phpma.*.*.kiev.ua</a><span class=rvts7>/server_import.php?token=7dcc2f606674b18493a80bc1fec69d50"</span></p>
<p><br></p>
<p><span class=rvts7>>> ###############</span></p>
<p><br></p>
<p><span class=rvts7>>> Логи Апача в примерно ето время: </span></p>
<p><br></p>
<p><span class=rvts7>>> ################</span></p>
<p><br></p>
<p><span class=rvts7>>> 89.252.*.52 - root [18/Sep/2007:10:18:35 +0300] "GET /server_import.php?token=7dcc2f606674b18493a80bc1fec69d50</span></p>
<p><span class=rvts7>>> HTTP/1.0" 200 11890</span></p>
<p><br></p>
<p><span class=rvts7>>> 89.252.*.52 - root [18/Sep/2007:10:19:29 +0300] "POST /import.php HTTP/1.0" 200 -</span></p>
<p><br></p>
<p><span class=rvts7>>> ################</span></p>
<p><br></p>
<p><span class=rvts7>>> в php.ini:</span></p>
<p><br></p>
<p><span class=rvts7>>> post_max_size = 512M</span></p>
<p><br></p>
<p><span class=rvts7>>> upload_max_filesize = 512M</span></p>
<p><br></p>
<p><span class=rvts7>>> **********************</span></p>
<p><br></p>
<p><span class=rvts7>>> в httpd.conf:</span></p>
<p><br></p>
<p><span class=rvts7>>> Timeout 15</span></p>
<p><br></p>
<p><span class=rvts7>>> KeepAlive On</span></p>
<p><br></p>
<p><span class=rvts7>>> MaxKeepAliveRequests 1000</span></p>
<p><br></p>
<p><span class=rvts7>>> KeepAliveTimeout 15</span></p>
<p><br></p>
<p><span class=rvts7>>> MinSpareServers 5 </span></p>
<p><br></p>
<p><span class=rvts7>>> MaxSpareServers 5</span></p>
<p><br></p>
<p><span class=rvts7>>> StartServers 10</span></p>
<p><br></p>
<p><span class=rvts7>>> MaxClients 100</span></p>
<p><br></p>
<p><span class=rvts7>>> MaxRequestsPerChild 15000</span></p>
<p><br></p>
<p><span class=rvts7>>> **********************</span></p>
<p><br></p>
<p><span class=rvts7>>> в nginx.conf:</span></p>
<p><br></p>
<p><span class=rvts7>>> ## Секция http </span></p>
<p><br></p>
<p><span class=rvts7>>> keepalive_timeout 90;</span></p>
<p><br></p>
<p><span class=rvts7>>> send_timeout 90;</span></p>
<p><br></p>
<p><span class=rvts7>>> tcp_nodelay on;</span></p>
<p><br></p>
<p><span class=rvts7>>> proxy_buffering on;</span></p>
<p><br></p>
<p><span class=rvts7>>> proxy_connect_timeout 75;</span></p>
<p><br></p>
<p><span class=rvts7>>> proxy_ignore_client_abort on; </span></p>
<p><br></p>
<p><span class=rvts7>>> gzip on;</span></p>
<p><br></p>
<p><span class=rvts7>>> server_names_hash_bucket_size 64;</span></p>
<p><br></p>
<p><span class=rvts7>>> client_max_body_size 1024M;</span></p>
<p><br></p>
<p><span class=rvts7>>> client_header_timeout 90;</span></p>
<p><br></p>
<p><span class=rvts7>>> gzip_buffers 4 4k;</span></p>
<p><br></p>
<p><span class=rvts7>>> gzip_proxied any;</span></p>
<p><br></p>
<p><span class=rvts7>>> gzip_comp_level 5;</span></p>
<p><br></p>
<p><span class=rvts7>>> ## в субдомене:</span></p>
<p><br></p>
<p><span class=rvts7>>> location ~ \.php$ {</span></p>
<p><br></p>
<p><span class=rvts7>>> proxy_pass </span><a class=rvts8 href="http://127.0.0.2:80">http://127.0.0.2:80 </a><span class=rvts7>;</span></p>
<p><br></p>
<p><span class=rvts7>>> proxy_redirect off;</span></p>
<p><br></p>
<p><span class=rvts7>>> proxy_set_header Host $host;</span></p>
<p><br></p>
<p><span class=rvts7>>> proxy_set_header X-Real-IP $remote_addr;</span></p>
<p><br></p>
<p><span class=rvts7>>> proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for; </span></p>
<p><br></p>
<p><span class=rvts7>>> ############################</span></p>
<p><br></p>
<p><span class=rvts7>>> В чем может быть трабла?</span></p>
<p><br></p>
<p><br></p>
<p><br></p>
<p><span class=rvts7>--</span></p>
<p><span class=rvts7>С уважением,</span></p>
<p><span class=rvts7>Алексей Бобок mailto:</span><a class=rvts8 href="mailto:alexey.bobok@gmail.com">alexey.bobok@gmail.com </a></p>
<p><br></p>
<p><br></p>
</td>
</tr>
</table>
</div>
<p><br></p>
<p><br></p>
<p><br></p>
<p><br></p>
<p><span class=rvts9>-- </span></p>
<p><span class=rvts9>С уважением,</span></p>
<p><span class=rvts9> Алексей Бобок </span><a class=rvts10 href="mailto:alexey.bobok@gmail.com">mailto:alexey.bobok@gmail.com</a></p>
</body></html>