Bug 1226423 - Schedule - Cancel errata deployment with large number of systems fails with internal error
Summary: Schedule - Cancel errata deployment with large number of systems fails with i...
Keywords:
Status: CLOSED DUPLICATE of bug 1402522
Alias: None
Product: Spacewalk
Classification: Community
Component: Server
Version: 2.2
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
Assignee: Tomas Lestach
QA Contact: Red Hat Satellite QA List
URL:
Whiteboard:
Depends On:
Blocks: space27
TreeView+ depends on / blocked
 
Reported: 2015-05-29 17:59 UTC by Michael Hoffman
Modified: 2017-09-28 18:06 UTC (History)
1 user (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2017-05-25 13:57:32 UTC
Embargoed:


Attachments (Terms of Use)

Description Michael Hoffman 2015-05-29 17:59:07 UTC
Description of problem:
Internal Server Error while cancelling errata deployment

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

How reproducible:
1. schedule errata to be applied with large number of systems.
In this case 1500
2. cancel the deployment via the schedule screen
3. confirm cancel
4. error is raised

Actual results:
internal server error is raised

Expected results:
cancel errata deployment

Additional info:
tomcat localhost.log
SEVERE: Servlet.service() for servlet action threw exception
java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000

        at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:765)
        at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:662)
        at oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPreparedStatement.java:546)
        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3628)
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1493)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:440)
        at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
        at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
        at org.hibernate.loader.Loader.doQuery(Loader.java:674)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
        at org.hibernate.loader.Loader.doList(Loader.java:2220)
        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
        at org.hibernate.loader.Loader.list(Loader.java:2099)
        at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
        at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
        at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
        at com.redhat.rhn.domain.kickstart.KickstartFactory.failKickstartSessions(KickstartFactory.java:1080)
        at com.redhat.rhn.manager.action.ActionManager.cancelAction(ActionManager.java:275)
        at com.redhat.rhn.manager.action.ActionManager.cancelActions(ActionManager.java:234)
        at com.redhat.rhn.frontend.action.schedule.PendingActionsDel

Comment 1 Michael Hoffman 2015-05-29 18:03:55 UTC
This is technically an oracle bug but recommend in the code to chunk up the data into multiple where lines to work around this limitation.

where
blah in ('one', 'two', 'three') or
blah in ('four', 'five', 'six') or ..

Comment 2 Eric Herget 2017-05-25 13:57:32 UTC

*** This bug has been marked as a duplicate of bug 1402522 ***

Comment 3 Eric Herget 2017-09-28 18:06:11 UTC
This BZ closed some time during 2.5, 2.6 or 2.7.  Adding to 2.7 tracking bug.


Note You need to log in before you can comment on or make changes to this bug.