[rt-users] RT crashes during spreadsheet export with "...rt-server.fcgi" aborted: idle timeout (3 sec)

[Alex Geo.]

Hi all,

Would really appreciate any help/advise on this.

Centos 6.4
Mysql
RT 4.0.10

here is what's in /etc/httpd/conf.d/rt.conf :

<VirtualHost support.company.com>
  ### Optional apache logs for RT
  # Ensure that your log rotation scripts know about these files
  # ErrorLog /opt/rt4/var/log/apache2.error
  # TransferLog /opt/rt4/var/log/apache2.access
  # LogLevel debug

  AddDefaultCharset UTF-8

  Alias /NoAuth/images/ /opt/rt4/share/html/NoAuth/images/
  ScriptAlias / /opt/rt4/sbin/rt-server.fcgi/

  DocumentRoot "/opt/rt4/share/html"
    <Location />
     Order allow,deny
     Allow from all

     Options +ExecCGI
     AddHandler fastcgi-script fcgi
    </Location>
</VirtualHost>

I have a queue called TOS with 34 "Ticket Custom Fields", which is
reproducing a spreadsheet in RT and each ticket is one shipment record. All
works good!

Now occasionally we need to export some "Saved searches" contents into a
spreadsheet. When the search contains little amount of results, i.e. 19
tickets or 36 tickets, the export works as expected. When it contains for
example 56 tickets - the "Internal Server Error" in the browser.

Looking in the httpd log we have the following:

[Mon Feb 03 16:55:30 2014] [error] [client 10.x.x.x] FastCGI: comm with
server "/opt/rt4/sbin/rt-server.fcgi" aborted: idle timeout (3 sec),
referer:
http://support.company.com/Search/Results.html?Format=%27%3Cb%3E%3Ca%20href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__id__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3A%23%27%2C%0A%27%3Ca%20href%3D%22%2FTicket%2FUpdate.html%3FAction%3DComment%26amp%3Bid%3D__id__%22%3E__CustomField.%7BShipper%7D__%3C%2Fa%3E%27%2C%0A%27__CustomField.%7BLoadport%7D__%27%2C%0A%27__CustomField.%7BI%7D__%2............
..

And this above log line is very long listing all of the custom fields. Then
one second later the following comes into the log:

[Mon Feb 03 16:55:34 2014] [warn] FastCGI: server
"/opt/rt4/sbin/rt-server.fcgi" (pid 4995) terminated due to uncaught signal
'13' (Broken pipe)
[Mon Feb 03 16:55:34 2014] [warn] FastCGI: server
"/opt/rt4/sbin/rt-server.fcgi" restarted (pid 16011)

Any clues how to overcome this issue? We will need to be exporting into
spreadsheets on a monthly basis, and the amount of tickets in the queue
will be growing approx 100 per month.

Thanks in advance for your assistance!

Kind regards,
Alex Geo.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20140203/f81be8d1/attachment.htm>