From Spacewalk list: Subject: [Spacewalk-list] Internal Server Error Date: Tue, 24 Jun 2008 15:52:14 +0200 From: Tobias Meier <tuxx> To: spacewalk-list Hello, I get an internal Server Error when i click on the Software->Packages->Install Button. This only happens if the subscribed x86_64 channel includes 2 packages with the same name , but for different architectures (ia32 an x86_64). The tomcat log says: ---snip--- 2008-06-24 17:47:17,776 [TP-Processor5] ERROR org.hibernate.transaction.JDBCTransaction - JDBC rollback failed java.sql.SQLException: No more data to read from socket ---snip--- The Host is an RHEL5.2 System with Oracle 10.2 xe. This page actually causes Oracle XE to crash. The only current workaround is to upgrade the database to Oracle 10.2.0.4 standard edition which is not Free.
You can reproduce it here on one of our internal systems: https://rlx-3-24.rhndev.redhat.com/rhn/systems/details/packages/InstallPackages.do?sid=1000010000 admin/redhat
Same error with Spacewalk hosted on CentOS / Oracle 10.2 XE. From catalina.out: ---snip--- [TP-Processor1] ERROR com.redhat.rhn.common.hibernate.ConnectionManager - org.hibernate.TransactionException: Transaction not successfully started [TP-Processor1] ERROR org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/rhn].[action] - Servlet.service() for servlet action threw exception java.sql.SQLException: No more data to read from socket ---snip--- This happens with any subscribed machine.
*** Bug 452928 has been marked as a duplicate of this bug. ***
I've done some additional testing, and it appears this happens somewhere past 500 packages. I loaded all the base RHEL RPM's alphabetically and the error occurred right after loading the "g"'s This also occurs when the packages are split among multiple channels. Has anyone found any work arounds for this yet?
Probably XE internal bug, see https://www.redhat.com/archives/spacewalk- list/2008-June/msg00054.html
Found two similar bugs filled against Oracle RDBMS 10.2.0.1, maybe one of workarounds will fix the issue even for XE: --------- Bug 4350392 - Dump (qkexrInitOpn or evapls) with unnested subqueries using object methods Subqueries involving object methods may dump in qkexrInitOpn or evapls when unnesting occurs. Workaround: Use /*+ NO_UNNEST */ hint for the sub query. Or _optimizer_cost_based_transformation=off This issue is fixed in 10.2.0.2 (Server Patch Set), 11.1.0.6 (Base Release) -------------- Bug No. 4626732 ORA-00600 [EVAPLS1] - WHEN SELECTS FROM A TABLE Customer encounters ORA-00600 [evapls1] when executing select against specific values with a function call within a select. WORKAROUND: alter session set optimizer_mode=rule; or alter session set "_optimizer_filter_pred_pullup"=false; This issue is fixed in 10.2.0.2 (Server Patch Set), 11.1.0.6 (Base Release)
If this is the solution, where can Oracle XE 10.2.0.2 be downloaded from?
Bugs mentioned above are Oracle RDBMS - not XE - bugs. XE 10.2.0.2 doesn't exist. As the core of both db engines share the same code I assume that workarounds for RDBMS *should* work for XE too. As a quick check try ORACLE_SID=XE sqlplus / as sysdba SQL> alter system set _optimizer_cost_based_transformation=off scope=memory; and likewise for the other workarounds (use alter system not only alter session).
Did the following: alter session set "_optimizer_filter_pred_pullup"=false; commit; alter system set "_optimizer_cost_based_transformation"=off scope=memory; commit; And the issue seems to be working again. Can list upgradeable packages, and installable packages for a channel that has ~2500 packages.
(In reply to comment #9) Worked here :D. You'll want to use scope=both or scope=spfile to make the change permanent.
Yeah, I realized my post was a bit vague. The fix did correct the issues I was having.
SUMMARY: This error is an Oracle XE internal error. It would be probably fixed in the next XE release. Known workaround: # su - oracle 'ORACLE_SID=XE ; sqlplus / as sysdba' SQL> alter system set _optimizer_cost_based_transformation=off scope=both; SQL> quit
Known workaround: # su - oracle 'ORACLE_SID=XE ; sqlplus / as sysdba' SQL> alter system set "_optimizer_cost_based_transformation"=off scope=both; SQL> quit Note the difference from comment #12 is the quote marks around the _optimizer... string.