Red Hat Bugzilla – Bug 998435
first access to Install page produces ISE with: com.redhat.rhn.common.db.WrappedSQLException: ERROR: query returned no rows
Last modified: 2017-07-19 07:24:53 EDT
Description of problem:
I have registered RHEL5-Server-GOLD system and when I wanted to access page listing packages available for installation I got ISE
Version-Release number of selected component (if applicable):
one of many attempts, seen it only for the first time accessing that page, but that could be coincidence
Steps to Reproduce:
1. Register RHEL5-Server-GOLD system into full RHEL5 channel
2. Go to System details -> Software -> Packages -> Install
Forgot to provide versions:
The trouble isn't really the page itself, but the DB exception you're getting.
According to the attached log an attempt to store packageEvr with values (epoch=0, version=0, release=0) fails and consequently (and not sure why) the appropriate lookup_evr function returns no rows. The other tomcat logs are just consequences of the exception.
There're more open questions, so let's start with the easy one:
What is the package you use with epoch=0, version=0, release=0 and where did you get it?
Was there any other thread running in parallel like satellite-sync, rhnpush, any other test?
Actually the DB exception isn't really expected, so it would be really interesting for us to know, how you achieved that and to have the chance to reproduce it.
We tried to create several tests, but the lookup_evr behaves like expected and not like on your machine.
I have tried to reproduce but was not successful. I do not know what is the special step needed to get the ISE again. Sorry.
Based on Comment 4 I'm closing the BZ with INSUFFICIENT_DATA.