PHP, и апач вместе с ним, ждут ответа от mysql-сервера. Проблема не в nginx.<br><br><div class="gmail_quote">2008/12/18 Дмитрий Леоненко <span dir="ltr"><<a href="mailto:dmitry.leonenko@gmail.com">dmitry.leonenko@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Привет всем. Может быть тема обсуждалась и я спрашиваю "баян", но.<div>Стоит nginx за ним апач 2.2</div>
<div><br></div><div>через 5 минут накапливается под 300 процессов апача в состоянии sbwait. Атач к одному из них дает:</div>
<div><br></div><div><div>[root@customer-3891]/var/log#gdb /usr/local/sbin/httpd 60003</div><div>GNU gdb 6.1.1 [FreeBSD]</div><div>Copyright 2004 Free Software Foundation, Inc.</div><div>GDB is free software, covered by the GNU General Public License, and you are</div>
<div>welcome to change it and/or distribute copies of it under certain conditions.</div><div>Type "show copying" to see the conditions.</div><div>There is absolutely no warranty for GDB. Type "show warranty" for details.</div>
<div>This GDB was configured as "i386-marcel-freebsd"...(no debugging symbols found)...</div><div>Attaching to program: /usr/local/sbin/httpd, process 60003</div><div>Reading symbols from /lib/libm.so.3...(no debugging symbols found)...done.</div>
<div>Loaded symbols for /lib/libm.so.3</div><div>Reading symbols from /usr/local/lib/libpcre.so.0...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/lib/libpcre.so.0</div><div>Reading symbols from /usr/local/lib/libaprutil-1.so.3...(no debugging symbols found)...done.</div>
<div>Loaded symbols for /usr/local/lib/libaprutil-1.so.3</div><div>Reading symbols from /usr/local/lib/libexpat.so.6...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/lib/libexpat.so.6</div><div>
Reading symbols from /usr/local/lib/libiconv.so.3...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/lib/libiconv.so.3</div><div>Reading symbols from /usr/local/lib/libapr-1.so.3...(no debugging symbols found)...done.</div>
<div>Loaded symbols for /usr/local/lib/libapr-1.so.3</div><div>Reading symbols from /lib/libcrypt.so.2...(no debugging symbols found)...done.</div><div>Loaded symbols for /lib/libcrypt.so.2</div><div>Reading symbols from /usr/lib/libpthread.so.1...(no debugging symbols found)...done.</div>
<div>Loaded symbols for /usr/lib/libpthread.so.1</div><div>Reading symbols from /lib/libc.so.5...(no debugging symbols found)...done.</div><div>Loaded symbols for /lib/libc.so.5</div><div>Reading symbols from /usr/local/libexec/apache22/mod_authn_file.so...(no debugging symbols found)...done.</div>
<div>Loaded symbols for /usr/local/libexec/apache22/mod_authn_file.so</div><div>Reading symbols from /usr/local/libexec/apache22/mod_authn_dbm.so...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/libexec/apache22/mod_authn_dbm.so</div>
<div>Reading symbols from /usr/local/libexec/apache22/mod_authn_anon.so...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/libexec/apache22/mod_authn_anon.so</div><div>Reading symbols from /usr/local/libexec/apache22/mod_authn_default.so...(no debugging symbols found)...done.</div>
<div>Loaded symbols for /usr/local/libexec/apache22/mod_authn_default.so</div><div>Reading symbols from /usr/local/libexec/apache22/mod_authn_alias.so...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/libexec/apache22/mod_authn_alias.so</div>
<div>Reading symbols from /usr/local/libexec/apache22/mod_authz_host.so...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/libexec/apache22/mod_authz_host.so</div><div>Reading symbols from /usr/local/libexec/apache22/mod_authz_groupfile.so...(no debugging symbols found)...done.</div>
<div>Loaded symbols for /usr/local/libexec/apache22/mod_authz_groupfile.so</div><div>Reading symbols from /usr/local/libexec/apache22/mod_authz_user.so...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/libexec/apache22/mod_authz_user.so</div>
<div>Reading symbols from /usr/local/libexec/apache22/mod_authz_dbm.so...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/libexec/apache22/mod_authz_dbm.so</div><div>Reading symbols from /usr/local/libexec/apache22/mod_authz_owner.so...(no debugging symbols found)...done.</div>
<div>Loaded symbols for /usr/local/libexec/apache22/mod_authz_owner.so</div><div>Reading symbols from /usr/local/libexec/apache22/mod_authz_default.so...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/libexec/apache22/mod_authz_default.so</div>
<div>Reading symbols from /usr/local/libexec/apache22/mod_auth_basic.so...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/libexec/apache22/mod_auth_basic.so</div><div>Reading symbols from /usr/local/libexec/apache22/mod_auth_digest.so...(no debugging symbols found)...done.</div>
<div>Loaded symbols for /usr/local/libexec/apache22/mod_auth_digest.so</div><div>Reading symbols from /usr/local/libexec/apache22/mod_file_cache.so...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/libexec/apache22/mod_file_cache.so</div>
<div>Reading symbols from /usr/local/libexec/apache22/mod_cache.so...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/libexec/apache22/mod_cache.so</div><div>Reading symbols from /usr/local/libexec/apache22/mod_disk_cache.so...(no debugging symbols found)...done.</div>
<div>Loaded symbols for /usr/local/libexec/apache22/mod_disk_cache.so</div><div>Reading symbols from /usr/local/libexec/apache22/mod_dumpio.so...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/libexec/apache22/mod_dumpio.so</div>
<div>Reading symbols from /usr/local/libexec/apache22/mod_include.so...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/libexec/apache22/mod_include.so</div><div>Reading symbols from /usr/local/libexec/apache22/mod_filter.so...(no debugging symbols found)...done.</div>
<div>Loaded symbols for /usr/local/libexec/apache22/mod_filter.so</div><div>Reading symbols from /usr/local/libexec/apache22/mod_charset_lite.so...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/libexec/apache22/mod_charset_lite.so</div>
<div>Reading symbols from /usr/local/libexec/apache22/mod_deflate.so...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/libexec/apache22/mod_deflate.so</div><div>Reading symbols from /lib/libz.so.2...(no debugging symbols found)...done.</div>
<div>Loaded symbols for /lib/libz.so.2</div><div>Reading symbols from /usr/local/libexec/apache22/mod_log_config.so...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/libexec/apache22/mod_log_config.so</div>
<div>Reading symbols from /usr/local/libexec/apache22/mod_logio.so...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/libexec/apache22/mod_logio.so</div><div>Reading symbols from /usr/local/libexec/apache22/mod_env.so...(no debugging symbols found)...done.</div>
<div>Loaded symbols for /usr/local/libexec/apache22/mod_env.so</div><div>Reading symbols from /usr/local/libexec/apache22/mod_mime_magic.so...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/libexec/apache22/mod_mime_magic.so</div>
<div>Reading symbols from /usr/local/libexec/apache22/mod_cern_meta.so...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/libexec/apache22/mod_cern_meta.so</div><div>Reading symbols from /usr/local/libexec/apache22/mod_expires.so...(no debugging symbols found)...done.</div>
<div>Loaded symbols for /usr/local/libexec/apache22/mod_expires.so</div><div>Reading symbols from /usr/local/libexec/apache22/mod_headers.so...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/libexec/apache22/mod_headers.so</div>
<div>Reading symbols from /usr/local/libexec/apache22/mod_usertrack.so...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/libexec/apache22/mod_usertrack.so</div><div>Reading symbols from /usr/local/libexec/apache22/mod_unique_id.so...(no debugging symbols found)...done.</div>
<div>Loaded symbols for /usr/local/libexec/apache22/mod_unique_id.so</div><div>Reading symbols from /usr/local/libexec/apache22/mod_setenvif.so...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/libexec/apache22/mod_setenvif.so</div>
<div>Reading symbols from /usr/local/libexec/apache22/mod_version.so...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/libexec/apache22/mod_version.so</div><div>Reading symbols from /usr/local/libexec/apache22/mod_ssl.so...(no debugging symbols found)...done.</div>
<div>Loaded symbols for /usr/local/libexec/apache22/mod_ssl.so</div><div>Reading symbols from /usr/lib/libssl.so.3...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/lib/libssl.so.3</div><div>Reading symbols from /lib/libcrypto.so.3...(no debugging symbols found)...done.</div>
<div>Loaded symbols for /lib/libcrypto.so.3</div><div>Reading symbols from /usr/local/libexec/apache22/mod_mime.so...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/libexec/apache22/mod_mime.so</div>
<div>Reading symbols from /usr/local/libexec/apache22/mod_dav.so...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/libexec/apache22/mod_dav.so</div><div>Reading symbols from /usr/local/libexec/apache22/mod_status.so...(no debugging symbols found)...done.</div>
<div>Loaded symbols for /usr/local/libexec/apache22/mod_status.so</div><div>Reading symbols from /usr/local/libexec/apache22/mod_autoindex.so...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/libexec/apache22/mod_autoindex.so</div>
<div>Reading symbols from /usr/local/libexec/apache22/mod_asis.so...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/libexec/apache22/mod_asis.so</div><div>Reading symbols from /usr/local/libexec/apache22/mod_info.so...(no debugging symbols found)...done.</div>
<div>Loaded symbols for /usr/local/libexec/apache22/mod_info.so</div><div>Reading symbols from /usr/local/libexec/apache22/mod_cgi.so...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/libexec/apache22/mod_cgi.so</div>
<div>Reading symbols from /usr/local/libexec/apache22/mod_dav_fs.so...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/libexec/apache22/mod_dav_fs.so</div><div>Reading symbols from /usr/local/libexec/apache22/mod_vhost_alias.so...(no debugging symbols found)...done.</div>
<div>Loaded symbols for /usr/local/libexec/apache22/mod_vhost_alias.so</div><div>Reading symbols from /usr/local/libexec/apache22/mod_negotiation.so...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/libexec/apache22/mod_negotiation.so</div>
<div>Reading symbols from /usr/local/libexec/apache22/mod_dir.so...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/libexec/apache22/mod_dir.so</div><div>Reading symbols from /usr/local/libexec/apache22/mod_imagemap.so...(no debugging symbols found)...done.</div>
<div>Loaded symbols for /usr/local/libexec/apache22/mod_imagemap.so</div><div>Reading symbols from /usr/local/libexec/apache22/mod_actions.so...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/libexec/apache22/mod_actions.so</div>
<div>Reading symbols from /usr/local/libexec/apache22/mod_speling.so...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/libexec/apache22/mod_speling.so</div><div>Reading symbols from /usr/local/libexec/apache22/mod_userdir.so...(no debugging symbols found)...done.</div>
<div>Loaded symbols for /usr/local/libexec/apache22/mod_userdir.so</div><div>Reading symbols from /usr/local/libexec/apache22/mod_alias.so...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/libexec/apache22/mod_alias.so</div>
<div>Reading symbols from /usr/local/libexec/apache22/mod_rewrite.so...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/libexec/apache22/mod_rewrite.so</div><div>Reading symbols from /usr/local/libexec/apache22/libphp5.so...(no debugging symbols found)...done.</div>
<div>Loaded symbols for /usr/local/libexec/apache22/libphp5.so</div><div>Reading symbols from /usr/local/lib/libxml2.so.5...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/lib/libxml2.so.5</div>
<div>Reading symbols from /usr/local/lib/libz.so...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/lib/libz.so</div><div>Reading symbols from /usr/local/libexec/apache22/mod_rpaf.so...(no debugging symbols found)...done.</div>
<div>Loaded symbols for /usr/local/libexec/apache22/mod_rpaf.so</div><div>Reading symbols from /usr/local/libexec/apache22/mod_suexec.so...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/libexec/apache22/mod_suexec.so</div>
<div>Reading symbols from /usr/local/lib/php/20060613/eaccelerator.so...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/lib/php/20060613/eaccelerator.so</div><div>Reading symbols from /usr/local/lib/php/20060613/mysql.so...(no debugging symbols found)...done.</div>
<div>Loaded symbols for /usr/local/lib/php/20060613/mysql.so</div><div>Reading symbols from /usr/local/lib/mysql/libmysqlclient.so.16...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/lib/mysql/libmysqlclient.so.16</div>
<div>Reading symbols from /usr/local/lib/php/20060613/simplexml.so...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/lib/php/20060613/simplexml.so</div><div>Reading symbols from /usr/local/lib/php/20060613/spl.so...(no debugging symbols found)...done.</div>
<div>Loaded symbols for /usr/local/lib/php/20060613/spl.so</div><div>Reading symbols from /usr/local/lib/php/20060613/mysqli.so...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/lib/php/20060613/mysqli.so</div>
<div>Reading symbols from /usr/local/lib/php/20060613/session.so...(no debugging symbols found)...done.</div><div>Loaded symbols for /usr/local/lib/php/20060613/session.so</div><div>Reading symbols from /libexec/ld-elf.so.1...(no debugging symbols found)...done.</div>
<div>Loaded symbols for /libexec/ld-elf.so.1</div><div>[Switching to LWP 100663]</div><div>0x282dd447 in read () from /lib/libc.so.5</div><div>(gdb) where</div><div>#0 0x282dd447 in read () from /lib/libc.so.5</div><div>
#1 0x28272b5d in read () from /usr/lib/libpthread.so.1</div><div>#2 0x289eaf41 in vio_read () from /usr/local/lib/mysql/libmysqlclient.so.16</div><div>#3 0x289eafae in vio_read_buff () from /usr/local/lib/mysql/libmysqlclient.so.16</div>
<div>#4 0x289ebcf0 in my_real_read () from /usr/local/lib/mysql/libmysqlclient.so.16</div><div>#5 0x289ebeed in my_net_read () from /usr/local/lib/mysql/libmysqlclient.so.16</div><div>#6 0x289e5bfa in cli_safe_read () from /usr/local/lib/mysql/libmysqlclient.so.16</div>
<div>#7 0x289e86a4 in cli_read_query_result () from /usr/local/lib/mysql/libmysqlclient.so.16</div><div>#8 0x289e895b in mysql_real_query () from /usr/local/lib/mysql/libmysqlclient.so.16</div><div>#9 0x289b6025 in php_mysql_do_query_general () from /usr/local/lib/php/20060613/mysql.so</div>
<div>#10 0x289b6215 in php_mysql_do_query () from /usr/local/lib/php/20060613/mysql.so</div><div>#11 0x289b623c in zif_mysql_query () from /usr/local/lib/php/20060613/mysql.so</div><div>#12 0x2874be1b in zend_do_fcall_common_helper_SPEC () from /usr/local/libexec/apache22/libphp5.so</div>
<div>#13 0x28752254 in ZEND_DO_FCALL_SPEC_CONST_HANDLER () from /usr/local/libexec/apache22/libphp5.so</div><div>#14 0x2874b605 in execute () from /usr/local/libexec/apache22/libphp5.so</div><div>#15 0x2874bf18 in zend_do_fcall_common_helper_SPEC () from /usr/local/libexec/apache22/libphp5.so</div>
<div>#16 0x2874c2b9 in ZEND_DO_FCALL_BY_NAME_SPEC_HANDLER () from /usr/local/libexec/apache22/libphp5.so</div><div>#17 0x2874b605 in execute () from /usr/local/libexec/apache22/libphp5.so</div><div>#18 0x287257af in zend_call_function () from /usr/local/libexec/apache22/libphp5.so</div>
<div>#19 0x287247f0 in call_user_function_ex () from /usr/local/libexec/apache22/libphp5.so</div><div>#20 0x2869e7c0 in zif_call_user_func_array () from /usr/local/libexec/apache22/libphp5.so</div><div>#21 0x2874be1b in zend_do_fcall_common_helper_SPEC () from /usr/local/libexec/apache22/libphp5.so</div>
<div>#22 0x28752254 in ZEND_DO_FCALL_SPEC_CONST_HANDLER () from /usr/local/libexec/apache22/libphp5.so</div><div>#23 0x2874b605 in execute () from /usr/local/libexec/apache22/libphp5.so</div><div>#24 0x287257af in zend_call_function () from /usr/local/libexec/apache22/libphp5.so</div>
<div>#25 0x287247f0 in call_user_function_ex () from /usr/local/libexec/apache22/libphp5.so</div><div>#26 0x2869e7c0 in zif_call_user_func_array () from /usr/local/libexec/apache22/libphp5.so</div><div>#27 0x2874be1b in zend_do_fcall_common_helper_SPEC () from /usr/local/libexec/apache22/libphp5.so</div>
<div>#28 0x28752254 in ZEND_DO_FCALL_SPEC_CONST_HANDLER () from /usr/local/libexec/apache22/libphp5.so</div><div>#29 0x2874b605 in execute () from /usr/local/libexec/apache22/libphp5.so</div><div>#30 0x2874bf18 in zend_do_fcall_common_helper_SPEC () from /usr/local/libexec/apache22/libphp5.so</div>
<div>#31 0x2874c2b9 in ZEND_DO_FCALL_BY_NAME_SPEC_HANDLER () from /usr/local/libexec/apache22/libphp5.so</div><div>#32 0x2874b605 in execute () from /usr/local/libexec/apache22/libphp5.so</div><div>#33 0x2874bf18 in zend_do_fcall_common_helper_SPEC () from /usr/local/libexec/apache22/libphp5.so</div>
<div>#34 0x2874c2b9 in ZEND_DO_FCALL_BY_NAME_SPEC_HANDLER () from /usr/local/libexec/apache22/libphp5.so</div><div>#35 0x2874b605 in execute () from /usr/local/libexec/apache22/libphp5.so</div><div>#36 0x2874bf18 in zend_do_fcall_common_helper_SPEC () from /usr/local/libexec/apache22/libphp5.so</div>
<div>#37 0x2874c2b9 in ZEND_DO_FCALL_BY_NAME_SPEC_HANDLER () from /usr/local/libexec/apache22/libphp5.so</div><div>#38 0x2874b605 in execute () from /usr/local/libexec/apache22/libphp5.so</div><div>#39 0x2874bf18 in zend_do_fcall_common_helper_SPEC () from /usr/local/libexec/apache22/libphp5.so</div>
<div>#40 0x2874c2b9 in ZEND_DO_FCALL_BY_NAME_SPEC_HANDLER () from /usr/local/libexec/apache22/libphp5.so</div><div>#41 0x2874b605 in execute () from /usr/local/libexec/apache22/libphp5.so</div><div>#42 0x2874bf18 in zend_do_fcall_common_helper_SPEC () from /usr/local/libexec/apache22/libphp5.so</div>
<div>#43 0x2874c2b9 in ZEND_DO_FCALL_BY_NAME_SPEC_HANDLER () from /usr/local/libexec/apache22/libphp5.so</div><div>#44 0x2874b605 in execute () from /usr/local/libexec/apache22/libphp5.so</div><div>#45 0x28731ab4 in zend_execute_scripts () from /usr/local/libexec/apache22/libphp5.so</div>
<div>#46 0x286f64e2 in php_execute_script () from /usr/local/libexec/apache22/libphp5.so</div><div>#47 0x287b10e5 in php_handler () from /usr/local/libexec/apache22/libphp5.so</div><div>#48 0x0807419e in ap_run_handler ()</div>
<div>#49 0x080746be in ap_invoke_handler ()</div><div>---Type <return> to continue, or q <return> to quit---</div><div>#50 0x0807f31c in ap_process_request ()</div><div>#51 0x0807d066 in ap_process_http_connection ()</div>
<div>#52 0x08079ea6 in ap_run_process_connection ()</div><div>#53 0x0807a1a3 in ap_process_connection ()</div><div>#54 0x0808384f in child_main ()</div><div>#55 0x080839c5 in make_child ()</div><div>#56 0x08083be1 in perform_idle_server_maintenance ()</div>
<div>#57 0x08083fd9 in ap_mpm_run ()</div><div>#58 0x08063cdb in main ()</div><div>(gdb)</div><div><br></div><div><br></div><div><br></div><div>Конфига nginx следующая:</div><div>---------------- ............. --------------------</div>
<div><div> access_log off;</div><div> sendfile on;</div><div> tcp_nopush on;</div><div><br></div><div><br></div><div> client_header_timeout 1024;</div><div> client_body_timeout 1024;</div>
<div> send_timeout 9000;</div><div> proxy_read_timeout 4000;</div><div><br></div><div> connection_pool_size 256;</div><div> client_header_buffer_size 2k;</div>
<div>
client_max_body_size 10m;</div><div> large_client_header_buffers 2 8k;</div><div> request_pool_size 8k;</div><div> proxy_buffers 16 64k;</div><div> proxy_buffer_size 64k;</div>
<div><br></div><div> #keepalive_timeout 0;</div><div> keepalive_timeout 65;</div><div><br></div><div>----------- ........................... --------------------</div><div><br></div><div><br></div><div>Подскажите, почему все начинает загибаться? Мне кажется апач перестает передавать данные на nginx.</div>
<div><br></div></div></div>
</blockquote></div><br><br clear="all"><br>-- <br>С уважением, Борис Долгов.<br>icq 77556665<br>e-mail <a href="mailto:boris@dolgov.name">boris@dolgov.name</a><br>