Red Hat Bugzilla – Bug 739090
plugin config for a group w/ 1000+ members fails to load due to "ORA-01795: maximum number of expressions in a list is 1000" error
Last modified: 2013-08-05 20:40:59 EDT
This is all that's logged to the Server log (no stack trace):
10:37:40,012 WARN [JDBCExceptionReporter] SQL Error: 1795, SQLState: 42000
10:37:40,012 ERROR [JDBCExceptionReporter] ORA-01795: maximum number of expressions in a list is 1000
There is no error displayed in the GUI, but the config editor never loads. The only content for the subtab remains a button bar with a grayed out Save button.
I'm not seeing this and I have a compat group of 1020 members. However, this does cause timeouts as per bug #737196 and I will try to work on speeding that up.
lowering this to medium because I am not seeing this, however, I am going to leave it open. Once the issues are done with the plugin config views and we are sure this issue doesn't appear or re-appear, we can close it.
I have a unit test that tests for this - see bug #737196. This should no longer be a problem.
performed additional functional regression testing around groups.
changing status of VERIFIED BZs for JON 2.4.2 and JON 3.0 to CLOSED/CURRENTRELEASE