504 gateway time out

**GK User** Mon Dec 08, 2014 11:58 am

We have a template gavick at this address www.dazebaonews.it...we have problem with our dedicated server... Often appears in the site web a white page and then, after a long wait, appears 504 gateway time out, while we are working.
Server's team say that this erorr is in the gavick module...
Query SELECT COUNT(*) FROM gx9la_k2_items WHERE YEAR(created)=2014 AND MONTH(created)=12 AND DAY(created)=3 AND published=1 AND ( publish_user

Nobody can help me about???
Thanks
Ale

**GK User** Tue Dec 09, 2014 8:41 am

Hello,

For me it looks similar to K2 query - I don't remember any query in our modules which uses YEAR or MONTH function. Could you provide a full query or better - file which causes this issue?

**GK User** Tue Dec 09, 2014 12:08 pm

Thanks for answering.
The hosting support wrote me about many lines in error_log like this one:
82.145.211.122 - - [08/Dec/2014:05:42:17 +0100] "GET /modules/mod_news_pro_gk4/cache/k2.items.cache.63ad752af8043e830d49a27f0b260a72_Lnsp_224.jpg HTTP/1.0" 200 326 "http://dazebaonews.it/ahot/13g8.html" "Opera/9.80 (J2ME/MIDP; Opera Mini/8.0.35626/35.6050; U; en) Presto/2.8.119 Version/11.10"

They're saying it's all about news_gk4 and cache.
Is it true?
The cache is now disabled, even the smart search is off.

What can it be?

**GK User** Tue Dec 09, 2014 3:59 pm

Please check if you have set a cache time like 60 minutes for all NSP GK4 instances. Often generating of thumbnails can cause performance issues.

**GK User** Tue Dec 09, 2014 7:17 pm

I opened some modules and I saw that the cache time is 30. Is it ok?
The website is dazebaonews.it.

Thanks.

**GK User** Wed Dec 10, 2014 11:47 am

Please can you reply?????

**GK User** Wed Dec 10, 2014 12:54 pm

But all NSP instances has cache time larger than 0?

And what about the query mentioned in your first post?

**GK User** Wed Dec 10, 2014 4:16 pm

With "NSP instances" you mean all the gk news modules?
I installed the quickstart, so the instances should be all the same.
About the first query:
You think is a K2 problem?

**GK User** Wed Dec 10, 2014 4:39 pm

In this case all instances should have at least 30min cache.

Regarding the query - yes, in my opinion this query comes from the K2 code - if you will send me a full query, then probably I will be able to tell you more about this query.

**GK User** Wed Dec 10, 2014 5:09 pm

The server sent me this query:
SELECT COUNT(*) FROM gx9la_k2_items WHERE YEAR(created)=2014 AND MONTH(created)=12 AND DAY(created)=31 AND published=1 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2014-12-10 13:38:22' ) AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2014-12-10 13:38:22' ) AND trash=0 AND access IN(1,1) AND EXISTS(SELECT * FROM gx9la_k2_categories WHERE id= gx9la_k2_items.catid AND published=1 AND trash=0 AND access IN(1,1) )

They say it takes the 50% of the cpu. Is it true?

P.S.: thanks for the smart support!

**GK User** Wed Dec 10, 2014 7:22 pm

One additional question - how many articles and categories do you have in K2?

**GK User** Fri Dec 12, 2014 10:09 am

There are 30K articles and 150 categories.

**GK User** Fri Dec 12, 2014 12:19 pm

In my opinion you have to upgrade your hosting, because it is an issue with K2 performance.

**GK User** Sun Dec 28, 2014 5:11 pm

we have improve the server (we change hosting as well), but the problem persist...Here the results of the research of the systemist: as you see K2 is involved all the time.
When we are inserting new articles appear:
Service Temporarily Unavailable

The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.
Web Server at dazebaonews.it

In the server we increased the number of fcgi process workers and we have multiple notices and warnings for the website:Here it is:

[Wed Dec 24 14:25:18 2014] [warn] [client 173.209.49.242] mod_fcgid: stderr: PHP Notice: Undefined offset: 1 in /var/www/vhosts/dazebaonews.it/httpdocs/templates/gk_news/html/pagination.php on line 34
[Wed Dec 24 14:25:18 2014] [warn] [client 173.209.49.242] mod_fcgid: stderr: PHP Notice: Undefined offset: 2 in /var/www/vhosts/dazebaonews.it/httpdocs/templates/gk_news/html/pagination.php on line 34
[Wed Dec 24 14:25:18 2014] [warn] [client 173.209.49.242] mod_fcgid: stderr: PHP Notice: Undefined offset: 3 in /var/www/vhosts/dazebaonews.it/httpdocs/templates/gk_news/html/pagination.php on line 34
[Wed Dec 24 14:25:21 2014] [warn] [client 64.13.133.152] mod_fcgid: stderr: PHP Notice: Undefined property: stdClass::$numOfComments in /var/www/vhosts/dazebaonews.it/httpdocs/components/com_k2/views/item/view.html.php on line 264
[Wed Dec 24 14:25:21 2014] [warn] [client 54.193.185.31] mod_fcgid: stderr: PHP Notice: Undefined property: stdClass::$numOfComments in /var/www/vhosts/dazebaonews.it/httpdocs/components/com_k2/views/item/view.html.php on line 264
[Wed Dec 24 14:25:21 2014] [warn] [client 54.193.185.31] mod_fcgid: stderr: PHP Notice: Undefined property: stdClass::$numOfComments in /var/www/vhosts/dazebaonews.it/httpdocs/components/com_k2/views/item/view.html.php on line 264
[Wed Dec 24 14:25:22 2014] [warn] [client 128.242.249.13] mod_fcgid: stderr: PHP Strict Standards: Only variables should be assigned by reference in /var/www/vhosts/dazebaonews.it/httpdocs/plugins/system/bigshotgoogleanalytics/bigshotgoogleanalytics.php on line 29

You can find the logs under /var/www/vhosts/dazebaonews.it/logs/error_log .

**GK User** Mon Dec 29, 2014 4:11 pm

You have to definitely consult your issues with K2 team, because your issue is strictly connected with the efficiency of this component. I won't be able to help you more with it, because I'm a not author of this component.