Description of problem: Add a new kickstart script (specifying a snippet), try to change order, get an internal server error. catalina.out shows the following: 2017-11-21 08:50:35,755 [TP-Processor12] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: 23505 2017-11-21 08:50:35,756 [TP-Processor12] ERROR org.hibernate.util.JDBCExceptionReporter - ERROR: duplicate key value violates unique constraint "rhn_ksscript_ksid_pos_uq" 2017-11-21 08:50:35,760 [TP-Processor12] ERROR com.redhat.rhn.frontend.servlets.SessionFilter - Error during transaction. Rolling back org.hibernate.exception.ConstraintViolationException: could not update: [com.redhat.rhn.domain.kickstart.KickstartScript#50] Version-Release number of selected component (if applicable): 2.7 How reproducible: Michael Mráka reproduced it and asked me to open this bug. Steps to Reproduce: See the following thread for more details: https://www.redhat.com/archives/spacewalk-list/2017-November/msg00048.html Actual results: Internal Server Error Expected results: Script re-ordering should work like it did on Spacewalk 2.6 and prior releases. Additional info:
Any updates on someone taking this bug and providing a fix via nightly build so I can test? Thanks.
Brian, Please follow to bz1520664 in order to get more information. spacewalk 517e9fd1ab8cb6ec749c8876cb87d1c82bdbd620
Can I upgrade just the spacewalk-java RPM on my Spacewalk 2.7 server to get the fix? Or would I need to upgrade to spacewalk 2.8-nightly?
Well, if you upgraded only spacewalk-java you would definitely need spacewalk-schema as well (this option may not be the safest). Or you can fork 2.7 repo and cherry-pick my commit mention above and rebuild spacewalk-java rpm. You can always upgrade to nightly. Just remember to have a valid backup.
To keep my production Spacewalk environment stable, would you consider backporting the fix to Spacewalk 2.7's spacewalk-java RPM and providing me a COPR build? I could test and then the new build could be placed in 2.7's production repos. I believe other users will benefit from this bugfix and could use it before Spacewalk 2.8 is released. Thank you.
Specifically, I need the updated package for RHEL 6 platform. Thanks.
Since you only backport Spacewalk security patches, how much of the development environment documented at the following URL do I need to setup in order to cherry-pick your Git commit and build a new spacewalk-java RPM for Spacewalk 2.7? https://github.com/spacewalkproject/spacewalk/wiki/DevelopmentWorkstationSetup Or are their alternative instructions I can use to rebuild this one RPM with the fix? Thanks.
Please follow instructions on how to scratch build - https://github.com/spacewalkproject/spacewalk/wiki/HowToScratchBuild
The cherry-picked fix works great on my spacewalk 2.7 server. Thanks!
Moving ON_QA
Spacewalk 2.8 has been released. https://github.com/spacewalkproject/spacewalk/wiki/ReleaseNotes28