FastCGI problem

[fanta00]

I have a database that runs on Joomla 2.5.5 (Don't remember fabrik version but it hasn't been updated for a year), last month all the front end tables stopped working, subpages with those tables stopped loading and throw 500 Internal Server Error. I checked the logs and it looks like there is suddenly problem with FastCGI. There were no php or other upgrades to a server recently. Nothing changed on a server for last few months, nothing was changed in the code, it just suddenly stopped working. When I switch the domain to run in Apache mode, it loads pages with tables, but is very very slow, and due to permissions issues I want to use FastCGI.

this is from log file:

[warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request function
[warn] RSA server certificate CommonName (CN) `plesk' does NOT match server name!?

I guess the problems are caused by server, not joomla/fabrik?
Have anyone get similar problem? What can be causing this and how to resolve?

 

[jfquestiaux]

Well, if you have not changed anything yourself, maybe somebody else did. Joomla 2.5.5 has security issues and you should really upgrade to the latest version. You can then upgrade the other extensions also, Fabrik included. Remember to back up everything first!
You should also check the files on the server to find out if something has been modified/added recently.

 

[felixkat]

DO you control your own server? Maybe your host changed something?

 

[fanta00]

I have VPS with full control, nothing has been changed, my host also confirmed that they haven't changed anything.

I have moved the site to new server, 500 Error disappeared, but it take about 30 sec to load a page with table view (it has about 400 rows). Can the size of that table be a problem?

The 500 errors and slow loading - can it be caused by DB overloading, bug in the code, or maybe the hosting package is simply too weak? What are your thoughts?

 

[jfquestiaux]

Do you have an URL to this page (with the table view)? What are your server settings (PHP, apache, mysql,.. versions)?

If you have a 500 error, what is the actual error. What you posted are only warnings, not real errors.
You should look in the php error log.

 

[fanta00]

Settings are:

PHP 5.3.3
Mysql 5.0.77
Operating system Linux 2.6.32-042stab085.20
CPU GenuineIntel, Intel(R) Xeon(R) CPU E5-2665 0 @ 2.40GHz
Apache/2.2.3 (CentOS)

Here is more from my error_log:

Fri Jul 11 12:26:39 2014] [error] Premature end of script headers: index.php, referer: https://domain.com/

[Fri Jul 11 12:29:14 2014] [warn] RSA server certificate CommonName (CN) `plesk' does NOT match server name!?

[Fri Jul 11 12:29:35 2014] [error] PHP Notice: Undefined variable: tabs in /var/www/vhosts/domain.com/httpsdocs/templates/xxxx/index.php on line 111

[Fri Jul 11 12:30:25 2014] [error] PHP Fatal error: Maximum execution time of 60 seconds exceeded in /var/www/vhosts/domain.com/httpsdocs/components/com_fabrik/models/list.php on line 8569

[Fri Jul 11 12:37:56 2014] [error] PHP Fatal error: Maximum execution time of 60 seconds exceeded in /var/www/vhosts/domain.com/httpsdocs/libraries/joomla/database/database/mysqli.php on line 382

[Fri Jul 11 15:11:57 2014] [warn] RSA server certificate CommonName (CN) `plesk' does NOT match server name!?

[Fri Jul 11 15:16:36 2014] [warn] mod_fcgid: stderr: PHP Notice: Undefined variable: tabs in /var/www/vhosts/domain.com/httpsdocs/templates/xxxx/index.php on line 111

[Fri Jul 11 15:17:28 2014] [error]  Premature end of script headers: index.php, referer: https://domain.com/

[Fri Jul 11 15:31:11 2014] [error]  Premature end of script headers: index.php

[Sat Jul 12 22:35:46 2014] [warn] mod_fcgid: stderr: PHP Notice: Undefined variable: tabs in /var/www/vhosts/domain.com/httpsdocs/templates/xxxx/index.php on line 111

[Sat Jul 12 22:35:47 2014] [warn] mod_fcgid: stderr: PHP Notice: Undefined variable: tabs in /var/www/vhosts/domain.com/httpsdocs/templates/xxxx/index.php on line 111

[Sat Jul 12 23:13:48 2014] [error]  File does not exist: /var/www/vhosts/domain.com/httpsdocs/administrator/images, referer: https://domain.com/administrator/index.php?option=com_fabrik&task=details.view&formid=2&listid=2&rowid=210

[Sun Jul 13 00:03:04 2014] [warn] RSA server certificate CommonName (CN) `plesk' does NOT match server name!?

Some of those errors are new, earlier logs were showing mostly warns.

After increasing PHP_FCGI_MAX_REQUESTS to 5000 for a test, some tables are loading, but the table that has 400 rows still throws
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

On new server that table works but loads for 40 sec.

 

[fanta00]

Also this might be important, this site is eating a lot of memory, On current server I have 4GB so it should be ok, but when I moved it to another server to test that server has only 1GB and this single website used already 130% ! I just have default Joomla template with few tables, one with 400 rows. Can this be causing problems with another host (even with 4GB)?

 

[jfquestiaux]

Do you try do display all the 400 rows at once?
How many elements do you have in the assoicated form?
Have you tried with a regular http connection instead of https?

 

[fanta00]

Do you try do display all the 400 rows at once?
The table doesn't display now so I can't remember, but in backend, under Lists -> Navigation it is set to show 100 rows at once (is this correct setting for front end lists display?)

How many elements do you have in the assoicated form?There are about 30 elements for each record, including file upload (don't think this one is used much), notes fields, and few joints

Have you tried with a regular http connection instead of https? Yes I tried, still the same effect. Recently even on completly new server the 500 Internal Server Errors appeared. If I use backup from May it works on another server, recent backup throws 500 Internal Server Error. The only thing that changed since May is 10 more records.

 

[jfquestiaux]

Have you tried to dispaly only 10 records at a time? Careful, if you have a menu item pointing to your list, the number of rows displayed is set in the menu options.

30 elements is not too much, but if you have joins or user elements, their elements add up.

You still have not told what are actually these errors. Have you found something in the php error log?

When dealing with this kind of problem, I usually unpublish all the elements in the list (except the id), try to display the list (it usually does), then re-publish elements one at a time untill I find a culprit.