502 Bad Gateway - Clearing Application Vault Cache

[jnarvaez]

Hi, everytime I try to clear app cache on the App Vault I get:

502 Bad Gateway

nginx

tail /var/log/sw-cp-server/error_log

2014/04/15 12:23:25 [error] 1362#0: *192235 recv() failed (104: Connection reset by peer) while reading response header from upstream, client: 1.1.1.1, server: , request: "GET /admin/app/clear-cache HTTP/1.1", upstream: "fastcgi://unix:/var/run/sw-engine.sock:", host: "mihost.xxxxx.com:8443", referrer: "https://mihost.xxxxx.com:8443/admin/app/usage"
2014/04/15 12:23:29 [error] 1362#0: *192235 recv() failed (104: Connection reset by peer) while reading response header from upstream, client: 1.1.1.1, server: , request: "GET /admin/app/clear-cache HTTP/1.1", upstream: "fastcgi://unix:/var/run/sw-engine.sock:", host: "mihost.xxxxx.com:8443", referrer: "https://mihost.xxxxx.com:8443/admin/app/usage"
2014/04/15 12:23:39 [error] 1362#0: *192235 recv() failed (104: Connection reset by peer) while reading response header from upstream, client: 1.1.1.1, server: , request: "GET /admin/app/clear-cache HTTP/1.1", upstream: "fastcgi://unix:/var/run/sw-engine.sock:", host: "mihost.xxxxx.com:8443", referrer: "https://mihost.xxxxx.com:8443/admin/app/usage"
2014/04/15 12:24:04 [error] 1362#0: *192250 recv() failed (104: Connection reset by peer) while reading response header from upstream, client: 1.1.1.1, server: , request: "GET /admin/app/clear-cache HTTP/1.1", upstream: "fastcgi://unix:/var/run/sw-engine.sock:", host: "mihost.xxxxx.com:8443", referrer: "https://mihost.xxxxx.com:8443/admin/app/usage"
2014/04/15 12:24:14 [error] 1362#0: *192249 recv() failed (104: Connection reset by peer) while reading response header from upstream, client: 1.1.1.1, server: , request: "GET /admin/app/clear-cache HTTP/1.1", upstream: "fastcgi://unix:/var/run/sw-engine.sock:", host: "mihost.xxxxx.com:8443", referrer: "https://mihost.xxxxx.com:8443/admin/app/usage"
2014/04/15 12:24:21 [error] 1362#0: *192249 recv() failed (104: Connection reset by peer) while reading response header from upstream, client: 1.1.1.1, server: , request: "GET /admin/app/clear-cache HTTP/1.1", upstream: "fastcgi://unix:/var/run/sw-engine.sock:", host: "mihost.xxxxx.com:8443", referrer: "https://mihost.xxxxx.com:8443/admin/app/usage"

Any idea?

Thank you!

 

[Evilmachine]

Had the same.

This is the Maria DB Bug.
http://kb.parallels.com/en/120508

 

[jnarvaez]

Had the same.

This is the Maria DB Bug.
http://kb.parallels.com/en/120508

Thank you but that is not my problem. I don't use MariaDB.

Plesk is working fine, I only get the error when trying to clear the App Vault cache through the Plesk GUI.

Strace to the "php-fpm pool plesk" process return this:

setsockopt(10, SOL_SOCKET, SO_RCVTIMEO, "\2003\341\1\0\0\0\0\0\0\0\0\0\0\0\0", 16) = 0
setsockopt(10, SOL_SOCKET, SO_SNDTIMEO, "\2003\341\1\0\0\0\0\0\0\0\0\0\0\0\0", 16) = 0
setsockopt(10, SOL_IP, IP_TOS, [8], 4)  = 0
setsockopt(10, SOL_TCP, TCP_NODELAY, [1], 4) = 0
setsockopt(10, SOL_SOCKET, SO_KEEPALIVE, [1], 4) = 0
read(10, "N\0\0\0\n5.5.37-log\0\311\16F\0r3B3uvs]\0\377\367\10"..., 16384) = 82
write(10, "?\0\0\1\215\242\2\0\0\0\0@\10\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 67) = 67
read(10, "\7\0\0\2\0\0\0\2\0\0\0", 16384) = 11
poll([{fd=10, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout)
write(10, "\31\0\0\0\3SET SQL_AUTO_IS_NULL = 0", 29) = 29
read(10, "\7\0\0\1\0\0\0\2\0\0\0", 16384) = 11
poll([{fd=10, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout)
write(10, "\21\0\0\0\3SET AUTOCOMMIT=0", 21) = 21
read(10, "\7\0\0\1\0\0\0\0\0\0\0", 16384) = 11
semop(884755, 0x7fff427ece60, 2)        = 0
semop(884755, 0x7fff427ece60, 1)        = 0
poll([{fd=10, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout)
write(10, "=\0\0\0\3DELETE FROM `aps_package` W"..., 65) = 65
read(10, "\320\0\0\1\377\253\5#23000Cannot delete or up"..., 16384) = 212
writev(2, [{"sw-engine-fpm: pool plesk", 25}, {": ", 2}, {"relocation error", 16}, {": ", 2}, {"/usr/lib64/libmyodbc3.so", 24}, {": ", 2}, {"symbol strmov, version libmysqlc"..., 106}, {"", 0}, {"", 0}, {"\n", 1}], 10) = 178
exit_group(127)                         = ?
Process 30978 detached

rpm -qa | grep connector-odbc

mysql-connector-odbc-3.51.26r1127-2.el5

Any idea?