<div dir="ltr">Signal 13 is just a broken pipe, as it says. You need to find out why it’s broken. It’s probably running out of memory or taking too long. FastCGI in my experience likes to timeout and not tell anyone that it did. I find it strange that your idle timeout is only 3 seconds. It’ll likely timeout often while it waits for the database to produce the query results.</div>
<div class="gmail_extra"><br><br><div class="gmail_quote">On 3 February 2014 09:19, Alex Geo. <span dir="ltr"><<a href="mailto:alex@russian-cyprus.org" target="_blank">alex@russian-cyprus.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">Hi all,<div><br></div><div>Would really appreciate any help/advise on this.</div><div><br></div><div>Centos 6.4</div><div>Mysql</div><div>RT 4.0.10</div><div><br></div><div><div>here is what's in /etc/httpd/conf.d/rt.conf :</div>
</div><div><br></div><div><div><VirtualHost <a href="http://support.company.com" target="_blank">support.company.com</a>></div><div> ### Optional apache logs for RT</div><div> # Ensure that your log rotation scripts know about these files</div>
<div> # ErrorLog /opt/rt4/var/log/apache2.error</div><div> # TransferLog /opt/rt4/var/log/apache2.access</div><div> # LogLevel debug</div><div><br></div><div> AddDefaultCharset UTF-8</div><div><br></div><div> Alias /NoAuth/images/ /opt/rt4/share/html/NoAuth/images/</div>
<div> ScriptAlias / /opt/rt4/sbin/rt-server.fcgi/</div><div><br></div><div> DocumentRoot "/opt/rt4/share/html"</div><div> <Location /></div><div> Order allow,deny</div><div> Allow from all</div>
<div><br></div><div> Options +ExecCGI</div><div> AddHandler fastcgi-script fcgi</div><div> </Location></div><div></VirtualHost></div></div><div><br></div><div>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!</div>
<div><br></div><div>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. </div>
<div><br></div><div>Looking in the httpd log we have the following:</div><div><br></div><div>[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: <a href="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............" target="_blank">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............</a>..<br>
</div><div><br></div><div>And this above log line is very long listing all of the custom fields. Then one second later the following comes into the log:</div><div><br></div><div><div>[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)</div>
<div>[Mon Feb 03 16:55:34 2014] [warn] FastCGI: server "/opt/rt4/sbin/rt-server.fcgi" restarted (pid 16011)</div></div><div><br></div><div>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.</div>
<div><br></div><div>Thanks in advance for your assistance!</div><div><br></div><div>Kind regards,</div><div>Alex Geo.</div></div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr"><div><span style="font-family:arial;font-size:small">Landon Stewart :: </span><a href="mailto:lstewart@iweb.com" style="font-family:arial;font-size:small" target="_blank">lstewart@iweb.com</a><br>
</div><span style="font-family:arial;font-size:small">Lead Specialist, Abuse and Security Management</span><br style="font-family:arial;font-size:small"><span style="font-family:arial;font-size:small">Spécialiste principal, gestion des abus et sécurité</span><br style="font-family:arial;font-size:small">
<span style="font-family:arial;font-size:small"><a href="http://iweb.com" target="_blank">http://iweb.com</a> :: +1 (888) 909-4932</span><br><div><span style="font-family:arial;font-size:small"><br></span></div><div><span style="font-family:arial;font-size:small"><br>
</span></div></div>
</div>