877069 - 500 internal server errors a plenty

Status: RESOLVED WONTFIX

(Webtools Graveyard :: BzAPI, defect)

Description

[John Ford [:jhford] CET/CEST Berlin Time]

I'm trying to load and comment on bugs using bzapi and for a couple of hours, i've been seeing a bunch of 500 errors on the api requests.  They are taking a long time before finally returning 500.  Sometimes it works, sometimes it doesn't.

Example query: https://api-dev.bugzilla.mozilla.org/1.3/bug/869851?include_fields=_all

Comment 1

[Ashish Vijayaram [:ashish]]

I saw FastCGI errors in httpd error log but I haven't restarted apache:

[Tue May 28 21:58:15 2013] [error] [client <IP redacted> ] FastCGI: incomplete headers (0 bytes) received from server "/var/www/1.3/script/bugzilla_api_fastcgi.pl"
[Tue May 28 21:58:15 2013] [warn] FastCGI: server "/var/www/1.3/script/bugzilla_api_fastcgi.pl" (pid 25300) terminated by calling exit with status '1'
[Tue May 28 21:58:17 2013] [warn] FastCGI: server "/var/www/1.3/script/bugzilla_api_fastcgi.pl" restarted (pid 25308)

Comment 2

[Gervase Markham [:gerv]]

I'm looking into this right now.

Gerv

Comment 3

[Gervase Markham [:gerv]]

I think the 500 errors are caused by a timeout. BzAPI is having trouble processing the data.  jhford's query causes BzAPI to request all the data about the bug from Bugzilla, including the attachment data. In the case of the sample URL you give, this is 6Mb worth. Without having looked into it, I'm sure BzAPI is not as efficient as it could be in avoiding unnecessary decodes and copies of that data.

The query https://api-dev.bugzilla.mozilla.org/1.3/bug/869851 does not request attachment data, and returns much more quickly.

So I suggest that you are more careful about what fields you request, and your problem should go away :-)

Gerv

Comment 4

[Gervase Markham [:gerv]]

ashish: is that OK?

Gerv

Comment 5

[Ashish Vijayaram [:ashish]]

(In reply to Gervase Markham [:gerv] from comment #4)
> ashish: is that OK?
> 
> Gerv

Yep, that totally sounds fine to me. I've no objections to closing this bug out.