Page 1 of 1

Помогите пожалуйста выяснить причину 500 ошибки

Posted: Mon Jan 29, 2018 12:55 pm
by artscripts
Всем привет, опишу ситуацию в кратце, если нужны будут другие подробности все предоставлю.
У меня VPS На Centos 7, php 7.1
Проблема появилась, когда обновил Xenforo 1.5 ветки на xenforo 2. При обновлении плагинов или перестраивании их данных появляется ошибка 500. Пример лога

Code: Select all

2018/01/24 19:32:44 [error] 430#430: *109208 upstream prematurely closed connection while reading response header from upstream, client: 91.210.206.202, server: soundmain.ru, request: "GET /css.php?css=public%3Aextra.less&s=0&l=3&d=1516807268&k=84ff833661cc60d542510b2491864757815d3cc1 HTTP/1.1", upstream: "https://95.183.13.135:8443/css.php?css=public%3Aextra.less&s=0&l=3&d=1516807268&k=84ff833661cc60d542510b2491864757815d3cc1", host: "soundmain.ru", referrer: "https://soundmain.ru/admin.php?tools/run-job&only_ids=84&_xfRedirect=https%3A%2F%2Fsoundmain.ru%2Fadmin.php%3Fadd-ons%2FThemeHouse-Nodes%2Ffinalize%26t%3D1516811554%252C541a55baf8658a04f9340fd768149117%26a%3Drebuild"
2018/01/24 19:36:04 [error] 430#430: *109287 upstream prematurely closed connection while reading response header from upstream, client: 91.210.206.202, server: soundmain.ru, request: "GET /css.php?css=public%3Aextra.less&s=0&l=3&d=1516811721&k=84ff833661cc60d542510b2491864757815d3cc1 HTTP/1.1", upstream: "https://95.183.13.135:8443/css.php?css=public%3Aextra.less&s=0&l=3&d=1516811721&k=84ff833661cc60d542510b2491864757815d3cc1", host: "soundmain.ru", referrer: "https://soundmain.ru/admin.php?tools/run-job&only_ids=85&_xfRedirect=https%3A%2F%2Fsoundmain.ru%2Fadmin.php%3Fadd-ons%2Fs9e-MediaSites%2Ffinalize%26t%3D1516811763%252C8a1658111692cf8d504fb596ffc3beab%26a%3Drebuild"
2018/01/24 19:36:13 [error] 430#430: *109207 upstream prematurely closed connection while reading response header from upstream, client: 91.210.206.202, server: soundmain.ru, request: "GET /css.php?css=public%3Anormalize.css%2Cpublic%3Acore.less%2Cadmin%3Aapp.less%2Cpublic%3Afont_awesome.css&s=0&l=3&d=1516811773&k=2b7c66c5172c8707626a155a2abcbcf2e4544572 HTTP/1.1", upstream: "https://95.183.13.135:8443/css.php?css=public%3Anormalize.css%2Cpublic%3Acore.less%2Cadmin%3Aapp.less%2Cpublic%3Afont_awesome.css&s=0&l=3&d=1516811773&k=2b7c66c5172c8707626a155a2abcbcf2e4544572", host: "soundmain.ru", referrer: "https://soundmain.ru/admin.php?tools/run-job"
2018/01/24 19:36:29 [error] 430#430: *109207 upstream prematurely closed connection while reading response header from upstream, client: 91.210.206.202, server: soundmain.ru, request: "POST /admin.php?add-ons/ThemeHouse-Nodes/rebuild HTTP/1.1", upstream: "https://95.183.13.135:8443/admin.php?add-ons/ThemeHouse-Nodes/rebuild", host: "soundmain.ru", referrer: "https://soundmain.ru/admin.php?add-ons/"
2018/01/24 19:36:51 [error] 430#430: *109208 upstream prematurely closed connection while reading response header from upstream, client: 91.210.206.202, server: soundmain.ru, request: "GET /css.php?css=public%3Aextra.less&s=0&l=3&d=1516811810&k=84ff833661cc60d542510b2491864757815d3cc1 HTTP/1.1", upstream: "https://95.183.13.135:8443/css.php?css=public%3Aextra.less&s=0&l=3&d=1516811810&k=84ff833661cc60d542510b2491864757815d3cc1", host: "soundmain.ru", referrer: "https://soundmain.ru/admin.php?tools/run-job"
2018/01/24 19:37:14 [error] 430#430: *109207 upstream prematurely closed connection while reading response header from upstream, client: 91.210.206.202, server: soundmain.ru, request: "POST /admin.php?add-ons/ThemeHouse-Nodes/rebuild HTTP/1.1", upstream: "https://95.183.13.135:8443/admin.php?add-ons/ThemeHouse-Nodes/rebuild", host: "soundmain.ru", referrer: "https://soundmain.ru/admin.php?add-ons/"
2018/01/24 19:38:25 [error] 431#431: *109206 upstream prematurely closed connection while reading response header from upstream, client: 91.210.206.202, server: soundmain.ru, request: "GET /css.php?css=public%3Aextra.less&s=0&l=3&d=1516811892&k=84ff833661cc60d542510b2491864757815d3cc1 HTTP/1.1", upstream: "https://95.183.13.135:8443/css.php?css=public%3Aextra.less&s=0&l=3&d=1516811892&k=84ff833661cc60d542510b2491864757815d3cc1", host: "soundmain.ru", referrer: "https://soundmain.ru/admin.php?tools/run-job&only_ids=88&_xfRedirect=https%3A%2F%2Fsoundmain.ru%2Fadmin.php%3Fadd-ons%2FThemeHouse-Nodes%2Ffinalize%26t%3D1516811905%252Ced8353b5f1e34ff52b22831de336fee9%26a%3Drebuild"
2018/01/24 19:38:46 [error] 430#430: *109287 upstream prematurely closed connection while reading response header from upstream, client: 91.210.206.202, server: soundmain.ru, request: "POST /admin.php?add-ons/s9e-MediaSites/rebuild HTTP/1.1", upstream: "https://95.183.13.135:8443/admin.php?add-ons/s9e-MediaSites/rebuild", host: "soundmain.ru", referrer: "https://soundmain.ru/admin.php?add-ons/"
Хостер говорит это проблема ксенфоро и у них нет специалистов по этому движку. Мои и же знакомые утверждают что это на сервере проблема. У многих стоит на весте этот форум и таких проблем нет. Такое ощущение что падает апач, при попытки обновить плагины(

Тогда я решил попробовать создать плагин через консоль ssh, н что в ответ получил.

Code: Select all

[root@p402292 public_html]# php cmd.php xf-addon:create

Enter an ID for this add-on: ART/yapod

[E_WARNING] Error while sending STMT_PREPARE packet. PID=10887

Enter an ID for this add-on: ART/yapod

MySQL statement prepare error [2006]: MySQL server has gone away

Enter an ID for this add-on:
Что уже настораживает и я не могу понять, что у меня отваливается(

Может кто может подсказать, в чем тут может быть проблема?

поставил в
/etc/my.cnf
wait_time_out=180
не помогает.

var/log/httpd

Code: Select all

[Thu Jan 25 12:20:59.898704 2018] [mpm_prefork:notice] [pid 21905] AH00163: Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips mod_fcgid/2.3.9 PHP/7.1.13 configured -- resuming normal operations
[Thu Jan 25 12:20:59.898734 2018] [core:notice] [pid 21905] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'[Thu Jan 25 12:20:11.267790 2018] [ssl:warn] [pid 21905] AH02292: Init: Name-based SSL virtual hosts only work for clients
[Thu Jan 25 12:20:11.270144 2018] [:notice] [pid 21905] mod_ruid2/0.9.8 enabled
[Thu Jan 25 12:20:15.459579 2018] [mpm_prefork:notice] [pid 21905] AH00163: Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips mod_fcgid/2.3.9 PHP/7.1.13 configured -- resuming normal operations
[Thu Jan 25 12:20:15.459619 2018] [core:notice] [pid 21905] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'
[Thu Jan 25 12:20:17.225359 2018] [mpm_prefork:notice] [pid 21905] AH00171: Graceful restart requested, doing restart
[Thu Jan 25 12:20:17.335526 2018] [so:warn] [pid 21905] AH01574: module ruid2_module is already loaded, skipping
[Thu Jan 25 12:20:17.344050 2018] [auth_digest:notice] [pid 21905] AH01757: generating secret for digest authentication ...
[Thu Jan 25 12:20:17.352784 2018] [ssl:warn] [pid 21905] AH02292: Init: Name-based SSL virtual hosts only work for clients with TLS server name indication support (RFC 4366)
[Thu Jan 25 12:20:17.354488 2018] [:notice] [pid 21905] mod_ruid2/0.9.8 enabled
[Thu Jan 25 12:20:17.441908 2018] [mpm_prefork:notice] [pid 21905] AH00163: Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips mod_fcgid/2.3.9 PHP/7.1.13 configured -- resuming normal operations
[Thu Jan 25 12:20:17.441939 2018] [core:notice] [pid 21905] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'
[Thu Jan 25 12:20:29.758931 2018] [mpm_prefork:notice] [pid 21905] AH00171: Graceful restart requested, doing restart
[Thu Jan 25 12:20:29.869613 2018] [so:warn] [pid 21905] AH01574: module ruid2_module is already loaded, skipping
[Thu Jan 25 12:20:29.877894 2018] [auth_digest:notice] [pid 21905] AH01757: generating secret for digest authentication ...
[Thu Jan 25 12:20:29.880604 2018] [ssl:warn] [pid 21905] AH02292: Init: Name-based SSL virtual hosts only work for clients with TLS server name indication support (RFC 4366)
[Thu Jan 25 12:20:29.882244 2018] [:notice] [pid 21905] mod_ruid2/0.9.8 enabled
[Thu Jan 25 12:20:29.964986 2018] [mpm_prefork:notice] [pid 21905] AH00163: Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips mod_fcgid/2.3.9 PHP/7.1.13 configured -- resuming normal operations
[Thu Jan 25 12:20:29.965023 2018] [core:notice] [pid 21905] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'
[Thu Jan 25 12:20:31.131279 2018] [mpm_prefork:notice] [pid 21905] AH00171: Graceful restart requested, doing restart
[Thu Jan 25 12:20:31.234556 2018] [so:warn] [pid 21905] AH01574: module ruid2_module is already loaded, skipping
[Thu Jan 25 12:20:31.242788 2018] [auth_digest:notice] [pid 21905] AH01757: generating secret for digest authentication ...
[Thu Jan 25 12:20:31.245649 2018] [ssl:warn] [pid 21905] AH02292: Init: Name-based SSL virtual hosts only work for clients with TLS server name indication support (RFC 4366)
[Thu Jan 25 12:20:31.248354 2018] [:notice] [pid 21905] mod_ruid2/0.9.8 enabled
[Thu Jan 25 12:20:31.330836 2018] [mpm_prefork:notice] [pid 21905] AH00163: Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips mod_fcgid/2.3.9 PHP/7.1.13 configured -- resuming normal operations
[Thu Jan 25 12:20:31.330872 2018] [core:notice] [pid 21905] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'
[Thu Jan 25 12:20:31.635122 2018] [mpm_prefork:notice] [pid 21905] AH00171: Graceful restart requested, doing restart
[Thu Jan 25 12:20:31.745823 2018] [so:warn] [pid 21905] AH01574: module ruid2_module is already loaded, skipping
[Thu Jan 25 12:20:31.754273 2018] [auth_digest:notice] [pid 21905] AH01757: generating secret for digest authentication ...
[Thu Jan 25 12:20:31.757273 2018] [ssl:warn] [pid 21905] AH02292: Init: Name-based SSL virtual hosts only work for clients with TLS server name indication support (RFC 4366)
[Thu Jan 25 12:20:31.758809 2018] [:notice] [pid 21905] mod_ruid2/0.9.8 enabled
[Thu Jan 25 12:20:31.817846 2018] [mpm_prefork:notice] [pid 21905] AH00163: Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips mod_fcgid/2.3.9 PHP/7.1.13 configured -- resuming normal operations
[Thu Jan 25 12:20:31.817876 2018] [core:notice] [pid 21905] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'
[Thu Jan 25 12:20:43.502077 2018] [mpm_prefork:notice] [pid 21905] AH00171: Graceful restart requested, doing restart
[Thu Jan 25 12:20:46.588219 2018] [so:warn] [pid 21905] AH01574: module ruid2_module is already loaded, skipping
[Thu Jan 25 12:20:46.596572 2018] [auth_digest:notice] [pid 21905] AH01757: generating secret for digest authentication ...
[Thu Jan 25 12:20:46.599496 2018] [ssl:warn] [pid 21905] AH02292: Init: Name-based SSL virtual hosts only work for clients with TLS server name indication support (RFC 4366)
[Thu Jan 25 12:20:46.604874 2018] [:notice] [pid 21905] mod_ruid2/0.9.8 enabled
[Thu Jan 25 12:20:46.667379 2018] [mpm_prefork:notice] [pid 21905] AH00163: Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips mod_fcgid/2.3.9 PHP/7.1.13 configured -- resuming normal operations
[Thu Jan 25 12:20:46.667413 2018] [core:notice] [pid 21905] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'
[Thu Jan 25 12:20:49.491530 2018] [mpm_prefork:notice] [pid 21905] AH00171: Graceful restart requested, doing restart
[Thu Jan 25 12:20:52.590283 2018] [so:warn] [pid 21905] AH01574: module ruid2_module is already loaded, skipping
[Thu Jan 25 12:20:52.614111 2018] [auth_digest:notice] [pid 21905] AH01757: generating secret for digest authentication ...
[Thu Jan 25 12:20:52.616976 2018] [ssl:warn] [pid 21905] AH02292: Init: Name-based SSL virtual hosts only work for clients with TLS server name indication support (RFC 4366)
[Thu Jan 25 12:20:52.618604 2018] [:notice] [pid 21905] mod_ruid2/0.9.8 enabled
[Thu Jan 25 12:20:52.749562 2018] [mpm_prefork:notice] [pid 21905] AH00163: Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips mod_fcgid/2.3.9 PHP/7.1.13 configured -- resuming normal operations
[Thu Jan 25 12:20:52.749592 2018] [core:notice] [pid 21905] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'
[Thu Jan 25 12:20:58.222854 2018] [mpm_prefork:notice] [pid 21905] AH00171: Graceful restart requested, doing restart
[Thu Jan 25 12:20:58.335465 2018] [so:warn] [pid 21905] AH01574: module ruid2_module is already loaded, skipping
[Thu Jan 25 12:20:58.344339 2018] [auth_digest:notice] [pid 21905] AH01757: generating secret for digest authentication ...
[Thu Jan 25 12:20:58.346685 2018] [ssl:warn] [pid 21905] AH02292: Init: Name-based SSL virtual hosts only work for clients with TLS server name indication support (RFC 4366)
[Thu Jan 25 12:20:58.348523 2018] [:notice] [pid 21905] mod_ruid2/0.9.8 enabled
[Thu Jan 25 12:20:58.427460 2018] [mpm_prefork:notice] [pid 21905] AH00163: Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips mod_fcgid/2.3.9 PHP/7.1.13 configured -- resuming normal operations
[Thu Jan 25 12:20:58.427491 2018] [core:notice] [pid 21905] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'
[Thu Jan 25 12:20:59.297186 2018] [mpm_prefork:notice] [pid 21905] AH00171: Graceful restart requested, doing restart
[Thu Jan 25 12:20:59.403664 2018] [so:warn] [pid 21905] AH01574: module ruid2_module is already loaded, skipping
[Thu Jan 25 12:20:59.415862 2018] [auth_digest:notice] [pid 21905] AH01757: generating secret for digest authentication ...
[Thu Jan 25 12:20:59.419547 2018] [ssl:warn] [pid 21905] AH02292: Init: Name-based SSL virtual hosts only work for clients with TLS server name indication support (RFC 4366)
[Thu Jan 25 12:20:59.421265 2018] [:notice] [pid 21905] mod_ruid2/0.9.8 enabled
[Thu Jan 25 12:20:59.505087 2018] [mpm_prefork:notice] [pid 21905] AH00163: Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips mod_fcgid/2.3.9 PHP/7.1.13 configured -- resuming normal operations
[Thu Jan 25 12:20:59.505123 2018] [core:notice] [pid 21905] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'
[Thu Jan 25 12:20:59.707498 2018] [mpm_prefork:notice] [pid 21905] AH00171: Graceful restart requested, doing restart
[Thu Jan 25 12:20:59.815813 2018] [so:warn] [pid 21905] AH01574: module ruid2_module is already loaded, skipping
[Thu Jan 25 12:20:59.822754 2018] [auth_digest:notice] [pid 21905] AH01757: generating secret for digest authentication ...
[Thu Jan 25 12:20:59.825916 2018] [ssl:warn] [pid 21905] AH02292: Init: Name-based SSL virtual hosts only work for clients with TLS server name indication support (RFC 4366)
[Thu Jan 25 12:20:59.827590 2018] [:notice] [pid 21905] mod_ruid2/0.9.8 enabled
[Thu Jan 25 12:20:59.898704 2018] [mpm_prefork:notice] [pid 21905] AH00163: Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips mod_fcgid/2.3.9 PHP/7.1.13 configured -- resuming normal operations
[Thu Jan 25 12:20:59.898734 2018] [core:notice] [pid 21905] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'
Вот я и не могу понять, проблема форума или сервера(

Re: Помогите пожалуйста выяснить причину 500 ошибки

Posted: Mon Jan 29, 2018 1:41 pm
by imperio
В рамках бесплатной поддержки мы не занимаемся настройкой серверов под конкретные cms. Данные вопросы решаются только на коммерческой основе нашими специалистами ну или можно обратится к сиадмину на фриланс.
MySQL server has gone away
Можно попробовать поднять лимиты в /etc/my.cnf

Code: Select all

wait_timeout
max_allowed_packet
Рестарт mysql не забываем.
[error] 430#430: *109208 upstream prematurely closed connection while reading response header from upstream
Попробовать поднастроить лимиты бэкенда. Менять шаблоны в настройках домена не пробовали?

Re: Помогите пожалуйста выяснить причину 500 ошибки

Posted: Mon Jan 29, 2018 1:52 pm
by artscripts
Можно попробовать поднять лимиты в /etc/my.cnf

Code: Select all
wait_timeout
max_allowed_packet
wait_timeout поставил 180
max_allowed_packet 64m
Это я попробовал поднять в первую очередь, не помогло.
Менять шаблоны в настройках домена не пробовали?
Нет это не пробовал, все стоит на дефолт шаблоне.

Re: Помогите пожалуйста выяснить причину 500 ошибки

Posted: Mon Jan 29, 2018 1:59 pm
by imperio
wait_timeout поставил 180
попробуйте поднять повыше, до 700-800

Re: Помогите пожалуйста выяснить причину 500 ошибки

Posted: Mon Jan 29, 2018 2:17 pm
by artscripts
попробуйте поднять повыше, до 700-800
Пробовал на 3-4 плагине при перестроении ошибка 500 все равно лезет.
Я понимаю конечно, что проще переустановить все с нуля, просто хотелось понять в чем причина.

Re: Помогите пожалуйста выяснить причину 500 ошибки

Posted: Mon Jan 29, 2018 4:32 pm
by imperio
Ошибка 500 у вас из-за этого, а не из-за mysql

Code: Select all

[error] 430#430: *109208 upstream prematurely closed connection while reading response header from upstream

Re: Помогите пожалуйста выяснить причину 500 ошибки

Posted: Thu Feb 01, 2018 11:51 am
by artscripts
Спасибо за советы, подумав решил перестановить все и использовать другую связку на Весте, все работает прекрасно.

Re: Помогите пожалуйста выяснить причину 500 ошибки

Posted: Thu Feb 01, 2018 12:32 pm
by imperio
Радикально, но тем не менее хорошо что проблема решена :)