Bug 462626

Summary:	500: Internal server error on query many bugs via XMLRPC
Product:	[Community] Bugzilla	Reporter:	Martin Bacovsky <mbacovsk>
Component:	WebService	Assignee:	PnT DevOps Devs <hss-ied-bugs>
Status:	CLOSED CURRENTRELEASE	QA Contact:
Severity:	medium	Docs Contact:
Priority:	medium
Version:	3.2	CC:	dkl
Target Milestone:	---
Target Release:	---
Hardware:	All
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2008-11-21 21:04:03 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Martin Bacovsky 2008-09-17 16:29:17 UTC

Description of problem:
I tried to get bugs in status other than CLOSED. This should be around 40k bugs. Despite the fact that limit for XMLRPC is set to 100k bugs my query fails with 500 Internal Server Error

Version-Release number of selected component (if applicable):
3.2

How reproducible:
Always

Steps to Reproduce:
1. Run query with following params
query = {
            'column_list': ['bug_id', 'changeddate', 'bug_status'],
            'bug_status': ['NEW','ASSIGNED','MODIFIED', 'ON_DEV', 'ON_QA', 'VERIFIED', 'FAILS_QA', 'RELEASE_PENDING', 'POST']
}
             
            
Additional info:
If I limit the query to return just 'NEW','ASSIGNED' it works. (roughly 23k bugs)

I met similar behaviour while requesting full bugs in multicall. So the problem might be in some size limit for XMLRPC response.

Comment 1 David Lawrence 2008-11-21 21:04:03 UTC

This worked for me now. This may have happened before due to the performance issues Bugzilla was experiencing during the time period this bug was filed. Please retry your test now and reopen this if it still occurs.

Dave