Re: [Spacewalk-devel] spacewalk with oracle 11.2 has problems with the monitoring code

2011-08-24 Thread Miroslav Suchý
On 08/24/2011 01:05 PM, Michael Calmer wrote:
 Some monitoring code expect special columns with id 1 which fail if id 1 
 column does not exist.
 
 E.g:
 java/code/src/com/redhat/rhn/domain/monitoring/satcluster/SatClusterFactory.java
 private static final PhysicalLocation PHYSICAL_LOCATION =
 lookupPhysicalLocation(new Long(1));
 
 A quick fix is, to disable this feature in oracle with:
 
  alter system set deferred_segment_creation=FALSE;
 
 but a real fix would be better.

Requiring presence of row with id=1 is definitely bug.
I do not like that Oracle workaround. That code which lookup id=1 should
be replaced. Patches are welcome. :)

-- 
Miroslav Suchy
Red Hat Satellite Engineering

___
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel


Re: [Spacewalk-devel] spacewalk with oracle 11.2 has problems with the monitoring code

2011-08-24 Thread Michael Calmer
Hi,

Am Mittwoch, 24. August 2011, 13:29:30 schrieb Miroslav Suchý:
 On 08/24/2011 01:05 PM, Michael Calmer wrote:
  Some monitoring code expect special columns with id 1 which fail if id 1 
  column does not exist.
  
  E.g:
  
java/code/src/com/redhat/rhn/domain/monitoring/satcluster/SatClusterFactory.java
  private static final PhysicalLocation PHYSICAL_LOCATION =
  lookupPhysicalLocation(new Long(1));
  
  A quick fix is, to disable this feature in oracle with:
  
   alter system set deferred_segment_creation=FALSE;
  
  but a real fix would be better.
 
 Requiring presence of row with id=1 is definitely bug.

100% agree

 I do not like that Oracle workaround. That code which lookup id=1 should
 be replaced. Patches are welcome. :)

I agree. The problem is, that there are a lot more places where this happens. 
To find out all these is a lot of work :-)

-- 
Regards

Michael Calmer

--
Michael Calmer
SUSE LINUX Products GmbH, Maxfeldstr. 5, D-90409 Nuernberg
T: +49 (0) 911 74053 0
F: +49 (0) 911 74053575  - e-mail: michael.cal...@suse.com
--
SUSE LINUX Products GmbH, GF: Jeff Hawn, Jennifer Guild, Felix Imendörffer
HRB 16746 (AG Nürnberg)


signature.asc
Description: This is a digitally signed message part.
___
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel