How to solve Nginx Connection reset by peer and An error occurred errors?

Question

PHP

There is a site chelnyhoreca.ru this is WP with WooCommerce plugin. Server on a bunch of nginx + php + mysql. The bottom line is that when you restart full PHP and Nginx, everything is fine, after a while glitches begin, once every other time an An error occurred error occurs or the main page is loaded but not completely. Every update always different behavior.
In the nginx logs, the following entries are constantly written:

2017/01/18 12:28:23 [error] 26930#0: *4816 readv() failed (104: Connection reset by peer) while reading upstream, client: 141.8.132.63, server: chelnyhoreca.ru, request: "GET /2016/10/25/otkrytie-lime-fresh-cafe/ HTTP/1.1", upstream: "fastcgi://unix:/var/run/horeca.sock:", host: "chelnyhoreca.ru"
2017/01/18 12:28:56 [error] 26930#0: *4818 FastCGI sent in stderr: "PHP message: База данных WordPress возвратила ошибку Unknown column 'meta_id' in 'order clause' в ответ на запрос SELECT woocommerce_term_id, meta_key, meta_value FROM hr_woocommerce_termmeta WHERE woocommerce_term_id IN (91) ORDER BY meta_id ASC, выполненный require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, my_page_template_redirect, get_metadata, update_meta_cache" while reading response header from upstream, client: 141.8.132.63, server: chelnyhoreca.ru, request: "GET /product-category/inventar/ HTTP/1.1", upstream: "fastcgi://unix:/var/run/horeca.sock:", host: "chelnyhoreca.ru"
2017/01/18 12:28:56 [error] 26930#0: *4818 readv() failed (104: Connection reset by peer) while reading upstream, client: 141.8.132.63, server: chelnyhoreca.ru, request: "GET /product-category/inventar/ HTTP/1.1", upstream: "fastcgi://unix:/var/run/horeca.sock:", host: "chelnyhoreca.ru"
2017/01/18 12:29:32 [error] 26930#0: *4820 FastCGI sent in stderr: "PHP message: База данных WordPress возвратила ошибку Unknown column 'meta_id' in 'order clause' в ответ на запрос SELECT woocommerce_term_id, meta_key, meta_value FROM hr_woocommerce_termmeta WHERE woocommerce_term_id IN (292) ORDER BY meta_id ASC, выполненный require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, my_page_template_redirect, get_metadata, update_meta_cache" while reading response header from upstream, client: 141.8.132.63, server: chelnyhoreca.ru, request: "GET /product-category/posuda-i-stolovye-pribory/stolovye-pribory/ HTTP/1.1", upstream: "fastcgi://unix:/var/run/horeca.sock:", host: "chelnyhoreca.ru"
2017/01/18 12:29:32 [error] 26930#0: *4820 readv() failed (104: Connection reset by peer) while reading upstream, client: 141.8.132.63, server: chelnyhoreca.ru, request: "GET /product-category/posuda-i-stolovye-pribory/stolovye-pribory/ HTTP/1.1", upstream: "fastcgi://unix:/var/run/horeca.sock:", host: "chelnyhoreca.ru"
2017/01/18 12:30:39 [error] 26927#0: *4824 readv() failed (104: Connection reset by peer) while reading upstream, client: 187.163.194.10, server: chelnyhoreca.ru, request: "POST /xmlrpc.php HTTP/1.1", upstream: "fastcgi://unix:/var/run/horeca.sock:", host: "chelnyhoreca.ru"
2017/01/18 12:32:24 [error] 26927#0: *4834 readv() failed (104: Connection reset by peer) while reading upstream, client: 141.8.132.63, server: chelnyhoreca.ru, request: "GET /shop/page/11/ HTTP/1.1", upstream: "fastcgi://unix:/var/run/horeca.sock:", host: "chelnyhoreca.ru"
2017/01/18 12:32:29 [error] 26927#0: *4834 readv() failed (104: Connection reset by peer) while reading upstream, client: 141.8.132.63, server: chelnyhoreca.ru, request: "GET /shop/11/ HTTP/1.1", upstream: "fastcgi://unix:/var/run/horeca.sock:", host: "chelnyhoreca.ru"
2017/01/18 12:35:08 [error] 26927#0: *4843 readv() failed (104: Connection reset by peer) while reading upstream, client: 141.8.132.63, server: chelnyhoreca.ru, request: "GET /product/blyudo-pryamougolnoe-collage-250x170-mm/ HTTP/1.1", upstream: "fastcgi://unix:/var/run/horeca.sock:", host: "chelnyhoreca.ru"
2017/01/18 12:36:11 [error] 26927#0: *4845 readv() failed (104: Connection reset by peer) while reading upstream, client: 141.8.132.63, server: chelnyhoreca.ru, request: "GET /product/slajser-convito-hbs-250/ HTTP/1.1", upstream: "fastcgi://unix:/var/run/horeca.sock:", host: "chelnyhoreca.ru"
2017/01/18 12:37:18 [error] 26927#0: *4847 readv() failed (104: Connection reset by peer) while reading upstream, client: 141.8.132.63, server: chelnyhoreca.ru, request: "GET /product/plita-elektricheskaya-lotus-cf4-8et-chetyrexkonforochnaya-s-zharochnym-shkafom-65-seriya/ HTTP/1.1", upstream: "fastcgi://unix:/var/run/horeca.sock:", host: "chelnyhoreca.ru"
2017/01/18 12:52:11 [error] 26930#0: *4866 FastCGI sent in stderr: "PHP message: База данных WordPress возвратила ошибку Unknown column 'meta_id' in 'order clause' в ответ на запрос SELECT woocommerce_term_id, meta_key, meta_value FROM hr_woocommerce_termmeta WHERE woocommerce_term_id IN (246) ORDER BY meta_id ASC, выполненный require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, my_page_template_redirect, get_metadata, update_meta_cache" while reading response header from upstream, client: 141.8.132.63, server: chelnyhoreca.ru, request: "GET /product-category/posuda-i-stolovye-pribory/posuda-dlya-restoranov/page/6/ HTTP/1.1", upstream: "fastcgi://unix:/var/run/horeca.sock:", host: "chelnyhoreca.ru"
2017/01/18 12:52:11 [error] 26930#0: *4866 readv() failed (104: Connection reset by peer) while reading upstream, client: 141.8.132.63, server: chelnyhoreca.ru, request: "GET /product-category/posuda-i-stolovye-pribory/posuda-dlya-restoranov/page/6/ HTTP/1.1", upstream: "fastcgi://unix:/var/run/horeca.sock:", host: "chelnyhoreca.ru"
2017/01/18 12:52:15 [error] 26930#0: *4866 readv() failed (104: Connection reset by peer) while reading upstream, client: 141.8.132.63, server: chelnyhoreca.ru, request: "GET /product-category/posuda-i-stolovye-pribory/posuda-dlya-restoranov/6/ HTTP/1.1", upstream: "fastcgi://unix:/var/run/horeca.sock:", host: "chelnyhoreca.ru"
2017/01/18 12:56:49 [error] 26928#0: *4880 recv() failed (104: Connection reset by peer) while reading response header from upstream, client: 178.154.189.202, server: chelnyhoreca.ru, request: "GET /robots.txt HTTP/1.1", upstream: "fastcgi://unix:/var/run/horeca.sock:", host: "chelnyhoreca.ru"
2017/01/18 12:59:11 [error] 26928#0: *4887 recv() failed (104: Connection reset by peer) while reading response header from upstream, client: 141.8.132.63, server: chelnyhoreca.ru, request: "GET /product-category/posuda-i-stolovye-pribory/page/4/ HTTP/1.1", upstream: "fastcgi://unix:/var/run/horeca.sock:", host: "chelnyhoreca.ru"
2017/01/18 13:19:16 [error] 26928#0: *4923 readv() failed (104: Connection reset by peer) while reading upstream, client: 46.147.224.34, server: chelnyhoreca.ru, request: "GET / HTTP/1.1", upstream: "fastcgi://unix:/var/run/horeca.sock:", host: "chelnyhoreca.ru"
2017/01/18 13:19:21 [error] 26928#0: *4923 readv() failed (104: Connection reset by peer) while reading upstream, client: 46.147.224.34, server: chelnyhoreca.ru, request: "GET / HTTP/1.1", upstream: "fastcgi://unix:/var/run/horeca.sock:", host: "chelnyhoreca.ru"
2017/01/18 13:19:53 [error] 26928#0: *4923 readv() failed (104: Connection reset by peer) while reading upstream, client: 46.147.224.34, server: chelnyhoreca.ru, request: "GET /my-account/ HTTP/1.1", upstream: "fastcgi://unix:/var/run/horeca.sock:", host: "chelnyhoreca.ru", referrer: "http://chelnyhoreca.ru/"

I don’t know what to do anymore, I’ve climbed all the sites, tried everything, nothing helps.

Answer 1

As a result, I just demolished the system and reinstalled Ubuntu 14.04 and Nginx + Php-fpm + Mysql and everything became normal :)
I'll see what happens next.

Answer 2

your php closes the connection without sending all the data, in pool.d/www include catch_workers_output=yes and error_log, see what is written in the error log