|Summary:||search and fix remaining places in the code where SQL queries containing IN clauses need to be broken into batches of <= 1000 IN clause items to avoid "ORA-01795 maximum number of expressions in a list is 1000" errors from Oracle|
|Product:||[Other] RHQ Project||Reporter:||Ian Springer <ian.springer>|
|Component:||Core Server||Assignee:||RHQ Project Maintainer <rhq-maint>|
|Status:||NEW ---||QA Contact:||Mike Foley <mfoley>|
|Version:||4.0.1||CC:||hbrock, hrupp, jshaughn|
|Target Milestone:||---||Keywords:||Reopened, Tracking|
|Fixed In Version:||Doc Type:||Bug Fix|
|Doc Text:||Story Points:||---|
|Last Closed:||2013-02-26 21:30:18 UTC||Type:||---|
|oVirt Team:||---||RHEL 7.3 requirements from Atomic Host:|
|Bug Depends On:||737190, 737193, 719734, 738799, 739090|
|Bug Blocks:||620933, 678340, 729848|
Description Ian Springer 2011-07-12 17:14:44 UTC
Joe fixed most of these a while back, but I recently encountered one he missed - Resource import. We should search for any remaining instances that need to be fixed. There are two ways to look for these: 1) grep through the code base looking for them 2) try to do various actions on 1000 or more items via the GUI of the perf environment, which contains 1000s of Resources, looking for ones that bomb I think there will be many queries with IN clauses in the code base that would never be passed more than 1000 items in a realistic use case, so I think 2) will be an better way to find the important ones that need to be fixed.
Comment 1 Jay Shaughnessy 2013-02-26 21:30:18 UTC
Closing this. This will eventually fall out of perf testing. Specific instances should be tracked in specific BZs.
Comment 2 Charles Crouch 2013-02-27 22:19:57 UTC
Reopening this, since its a tracker bug. Actually added the keyword this time. The specific instances of this problem which jay mentions are listed in the Depends On field of this bug.