Opencart Polska

[ZygaSMK]

Witam, mam problem dzisiaj na stronie sklepu wyskoczyło:

Service Temporarily Unavailable
The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.
Additionally, a 503 Service Temporarily Unavailable error was encountered while trying to use an ErrorDocument to handle the request.

Właściciel serwerów odpisał:

Witam
fragment debugu


access("/home/zygasmk/domains/zygasmk.vot.pl/public_html/abc/catalog/model/catalog/product.php", F_OK) = 0
stat("/home/zygasmk/domains/zygasmk.vot.pl/public_html/abc/catalog/model/catalog/product.php", {st_mode=S_IFREG|0644, st_size=29678, ...}) = 0
access("/home/zygasmk/domains/zygasmk.vot.pl/public_html/abc/vqmod/vqcache/vq2-catalog_model_catalog_product.php", F_OK) = 0
stat("/home/zygasmk/domains/zygasmk.vot.pl/public_html/abc/vqmod/vqcache/vq2-catalog_model_catalog_product.php", {st_mode=S_IFREG|0664, st_size=30707, ...}) = 0
sendto(4, "/\1\0\0\3SELECT * FROM oc_category c"..., 307, MSG_DONTWAIT, NULL, 0) = 307
poll([{fd=4, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=4, revents=POLLIN}])
recvfrom(4, "\1\0\0\1\21I\0\0\2\3def\21zygasmk_abcplytki\1"..., 16287, MSG_DONTWAIT, NULL, NULL) = 6676
sendto(4, "0\1\0\0\3SELECT * FROM oc_category c"..., 308, MSG_DONTWAIT, NULL, 0) = 308
poll([{fd=4, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=4, revents=POLLIN}])
recvfrom(4, "\1\0\0\1\21I\0\0\2\3def\21zygasmk_abcplytki\1"..., 9611, MSG_DONTWAIT, NULL, NULL) = 8578
sendto(4, "\317\1\0\0\3SELECT COUNT(DISTINCT p.pro"..., 467, MSG_DONTWAIT, NULL, 0) = 467
poll([{fd=4, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=4, revents=POLLIN}])
recvfrom(4, "\1\0\0\1\1\33\0\0\2\3def\0\0\0\5total\0\f?\0\25\0\0\0\10\201"..., 1033, MSG_DONTWAIT, NULL, NULL) = 62
sendto(4, "<\0\0\0\3SELECT * FROM oc_url_alias "..., 64, MSG_DONTWAIT, NULL, 0) = 64
poll([{fd=4, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=4, revents=POLLIN}])
recvfrom(4, "\1\0\0\1\3W\0\0\2\3def\21zygasmk_abcplytki\f"..., 971, MSG_DONTWAIT, NULL, NULL) = 314
sendto(4, "<\0\0\0\3SELECT * FROM oc_url_alias "..., 64, MSG_DONTWAIT, NULL, 0) = 64
poll([{fd=4, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=4, revents=POLLIN}])
recvfrom(4, "\1\0\0\1\3W\0\0\2\3def\21zygasmk_abcplytki\f"..., 657, MSG_DONTWAIT, NULL, NULL) = 322
sendto(4, "\317\1\0\0\3SELECT COUNT(DISTINCT p.pro"..., 467, MSG_DONTWAIT, NULL, 0) = 467
poll([{fd=4, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=4, revents=POLLIN}])
recvfrom(4, "\1\0\0\1\1\33\0\0\2\3def\0\0\0\5total\0\f?\0\25\0\0\0\10\201"..., 335, MSG_DONTWAIT, NULL, NULL) = 62
sendto(4, "<\0\0\0\3SELECT * FROM oc_url_alias "..., 64, MSG_DONTWAIT, NULL, 0) = 64
poll([{fd=4, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=4, revents=POLLIN}])
recvfrom(4, "\1\0\0\1\3W\0\0\2\3def\21zygasmk_abcplytki\f"..., 273, MSG_DONTWAIT, NULL, NULL) = 273
poll([{fd=4, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=4, revents=POLLIN}])
recvfrom(4, "category_id=59\21plytki-lazienkowe"..., 47390, MSG_DONTWAIT, NULL, NULL) = 41
sendto(4, "<\0\0\0\3SELECT * FROM oc_url_alias "..., 64, MSG_DONTWAIT, NULL, 0) = 64
poll([{fd=4, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=4, revents=POLLIN}])
recvfrom(4, "\1\0\0\1\3W\0\0\2\3def\21zygasmk_abcplytki\f"..., 47349, MSG_DONTWAIT, NULL, NULL) = 312
sendto(4, "\317\1\0\0\3SELECT COUNT(DISTINCT p.pro"..., 467, MSG_DONTWAIT, NULL, 0) = 467
poll([{fd=4, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=4, revents=POLLIN}])
recvfrom(4, "\1\0\0\1\1\33\0\0\2\3def\0\0\0\5total\0\f?\0\25\0\0\0\10\201"..., 47037, MSG_DONTWAIT, NULL, NULL) = 62
sendto(4, "<\0\0\0\3SELECT * FROM oc_url_alias "..., 64, MSG_DONTWAIT, NULL, 0) = 64
poll([{fd=4, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=4, revents=POLLIN}])
recvfrom(4, "\1\0\0\1\3W\0\0\2\3def\21zygasmk_abcplytki\f"..., 46975, MSG_DONTWAIT, NULL, NULL) = 314
sendto(4, "<\0\0\0\3SELECT * FROM oc_url_alias "..., 64, MSG_DONTWAIT, NULL, 0) = 64
poll([{fd=4, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=4, revents=POLLIN}])
recvfrom(4, "\1\0\0\1\3W\0\0\2\3def\21zygasmk_abcplytki\f"..., 46661, MSG_DONTWAIT, NULL, NULL) = 313
sendto(4, "\317\1\0\0\3SELECT COUNT(DISTINCT p.pro"..., 467, MSG_DONTWAIT, NULL, 0) = 467
poll([{fd=4, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=4, revents=POLLIN}])
recvfrom(4, "\1\0\0\1\1\33\0\0\2\3def\0\0\0\5total\0\f?\0\25\0\0\0\10\201"..., 46348, MSG_DONTWAIT, NULL, NULL) = 61
sendto(4, "<\0\0\0\3SELECT * FROM oc_url_alias "..., 64, MSG_DONTWAIT, NULL, 0) = 64
poll([{fd=4, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=4, revents=POLLIN}])
recvfrom(4, "\1\0\0\1\3W\0\0\2\3def\21zygasmk_abcplytki\f"..., 46287, MSG_DONTWAIT, NULL, NULL) = 314
sendto(4, "<\0\0\0\3SELECT * FROM oc_url_alias "..., 64, MSG_DONTWAIT, NULL, 0) = 64
poll([{fd=4, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=4, revents=POLLIN}])
recvfrom(4, "\1\0\0\1\3W\0\0\2\3def\21zygasmk_abcplytki\f"..., 45973, MSG_DONTWAIT, NULL, NULL) = 313
sendto(4, "\317\1\0\0\3SELECT COUNT(DISTINCT p.pro"..., 467, MSG_DONTWAIT, NULL, 0) = 467
poll([{fd=4, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=4, revents=POLLIN}])
recvfrom(4, "\1\0\0\1\1\33\0\0\2\3def\0\0\0\5total\0\f?\0\25\0\0\0\10\201"..., 45660, MSG_DONTWAIT, NULL, NULL) = 62
sendto(4, "<\0\0\0\3SELECT * FROM oc_url_alias "..., 64, MSG_DONTWAIT, NULL, 0) = 64
poll([{fd=4, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=4, revents=POLLIN}])
recvfrom(4, "\1\0\0\1\3W\0\0\2\3def\21zygasmk_abcplytki\f"..., 45598, MSG_DONTWAIT, NULL, NULL) = 314
sendto(4, "<\0\0\0\3SELECT * FROM oc_url_alias "..., 64, MSG_DONTWAIT, NULL, 0) = 64
poll([{fd=4, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=4, revents=POLLIN}])
recvfrom(4, "\1\0\0\1\3W\0\0\2\3def\21zygasmk_abcplytki\f"..., 45284, MSG_DONTWAIT, NULL, NULL) = 312
sendto(4, "\317\1\0\0\3SELECT COUNT(DISTINCT p.pro"..., 467, MSG_DONTWAIT, NULL, 0) = 467
poll([{fd=4, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=4, revents=POLLIN}])
recvfrom(4, "\1\0\0\1\1\33\0\0\2\3def\0\0\0\5total\0\f?\0\25\0\0\0\10\201"..., 44972, MSG_DONTWAIT, NULL, NULL) = 62
sendto(4, "<\0\0\0\3SELECT * FROM oc_url_alias "..., 64, MSG_DONTWAIT, NULL, 0) = 64
poll([{fd=4, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=4, revents=POLLIN}])
recvfrom(4, "\1\0\0\1\3W\0\0\2\3def\21zygasmk_abcplytki\f"..., 44910, MSG_DONTWAIT, NULL, NULL) = 314
sendto(4, "<\0\0\0\3SELECT * FROM oc_url_alias "..., 64, MSG_DONTWAIT, NULL, 0) = 64
poll([{fd=4, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=4, revents=POLLIN}])
recvfrom(4, "\1\0\0\1\3W\0\0\2\3def\21zygasmk_abcplytki\f"..., 44596, MSG_DONTWAIT, NULL, NULL) = 314
sendto(4, "\320\1\0\0\3SELECT COUNT(DISTINCT p.pro"..., 468, MSG_DONTWAIT, NULL, 0) = 468
poll([{fd=4, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=4, revents=POLLIN}])
recvfrom(4, "\1\0\0\1\1\33\0\0\2\3def\0\0\0\5total\0\f?\0\25\0\0\0\10\201"..., 44282, MSG_DONTWAIT, NULL, NULL) = 61
sendto(4, "<\0\0\0\3SELECT * FROM oc_url_alias "..., 64, MSG_DONTWAIT, NULL, 0) = 64
poll([{fd=4, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=4, revents=POLLIN}])
recvfrom(4, "\1\0\0\1\3W\0\0\2\3def\21zygasmk_abcplytki\f"..., 44221, MSG_DONTWAIT, NULL, NULL) = 314
sendto(4, "=\0\0\0\3SELECT * FROM oc_url_alias "..., 65, MSG_DONTWAIT, NULL, 0) = 65
poll([{fd=4, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=4, revents=POLLIN}])
recvfrom(4, "\1\0\0\1\3W\0\0\2\3def\21zygasmk_abcplytki\f"..., 43907, MSG_DONTWAIT, NULL, NULL) = 313
sendto(4, "\320\1\0\0\3SELECT COUNT(DISTINCT p.pro"..., 468, MSG_DONTWAIT, NULL, 0) = 468
poll([{fd=4, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=4, revents=POLLIN}])
recvfrom(4, "\1\0\0\1\1\33\0\0\2\3def\0\0\0\5total\0\f?\0\25\0\0\0\10\201"..., 43594, MSG_DONTWAIT, NULL, NULL) = 61
sendto(4, "<\0\0\0\3SELECT * FROM oc_url_alias "..., 64, MSG_DONTWAIT, NULL, 0) = 64
poll([{fd=4, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=4, revents=POLLIN}])
recvfrom(4, "\1\0\0\1\3W\0\0\2\3def\21zygasmk_abcplytki\f"..., 43533, MSG_DONTWAIT, NULL, NULL) = 314
sendto(4, "=\0\0\0\3SELECT * FROM oc_url_alias "..., 65, MSG_DONTWAIT, NULL, 0) = 65



skrpt odwołuje sie do wtyczki vqcache , która wykonuje bardzo duzo zapytan do bazy danych. przekracza to maksymalną ilośc requestów która wynosi 50 000.

Prosze tymczasowo wyłaczyc tą wtyczke i spróbowac ponownie.




Proszę o pomoc / info co w takiej sytuacji ?? Pozdrawiam

[staniapl]

Wtyczka z nazwy powinna ograniczać zapytania do bazy - swoją drogą co to za limit 50 000 ? Co to za hosting ?

[ZygaSMK]

linux.pl ....

[staniapl]

Wtyczka do wyłączenia, wyrzucenia - skoro generuje więcej zapytań niż bez niej.

linux.pl czy linuxpl.com ?

Na linuxpl.com mam sklep ~ 20 tyś produktów, ok 60 - 80 UU dziennie, + do tego kilka wordpressów - serwer nawet nie piardnie