Bug 611726 - Oracle: issue when uninventoring platform
Summary: Oracle: issue when uninventoring platform
Alias: None
Product: RHQ Project
Classification: Other
Component: Core Server   
(Show other bugs)
Version: 3.0.0
Hardware: All
OS: Linux
medium vote
Target Milestone: ---
: ---
Assignee: RHQ Project Maintainer
QA Contact: Rajan Timaniya
Depends On:
TreeView+ depends on / blocked
Reported: 2010-07-06 09:52 UTC by Heiko W. Rupp
Modified: 2014-04-04 19:44 UTC (History)
3 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Last Closed: 2014-04-04 19:44:07 UTC
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Attachments (Terms of Use)

External Trackers
Tracker ID Priority Status Summary Last Updated
Red Hat Bugzilla 617577 None None None Never

Description Heiko W. Rupp 2010-07-06 09:52:35 UTC
Saw this flying by when uninventoring a platform on Perf env:

05:45:32,580 ERROR [ResourceManagerBean] Bulk named query delete error for 'ResourceConfigurationUpdate.deleteByResources2' for [11769]: org.hibernate.exception.SQLGrammarException: could not execute update query

No more details available.

Comment 1 Joseph Marques 2010-09-24 16:24:32 UTC
QE: uninventory any resource that has 2-3 resource configuration history elements when using oracle.  see if any errors still occur.

Comment 2 Rajan Timaniya 2010-09-29 11:13:15 UTC
Tested on JON 2.4 with Oracle 11g

1) Created configuration history for 'Memory Subsystem' and uninventory it.
   Observation: 'Memory Subsystem' uninventory successfully
   Server log:
2010-09-29 16:27:07,186 INFO  [org.rhq.enterprise.server.resource.ResourceManagerBean] User [org.rhq.core.domain.auth.Subject[id=2,name=rhqadmin]] is marking resource [Resource[id=10147, type=VM Memory System, key=java.lang:type=Memory, name=Memory Subsystem, parent=JVM]] for asynchronous uninventory
2010-09-29 16:27:10,925 WARN  [org.hibernate.hql.ast.QueryTranslatorImpl] firstResult/maxResults specified with collection fetch; applying in memory!

2) Uninventory (RHEL 5.5) platform
   Observation: Uninventoried platform successfully
   Server log:
2010-09-29 16:39:03,764 INFO  [org.rhq.enterprise.server.resource.ResourceManagerBean] User [org.rhq.core.domain.auth.Subject[id=2,name=rhqadmin]] is marking resource [Resource[id=10001, type=Linux, key=, name=, parent=<null>, version=Linux 2.6.18-194.11.1.el5PAE]] for asynchronous uninventory
2010-09-29 16:39:05,549 WARN  [org.rhq.enterprise.server.core.comm.ServerCommunicationsService] {Failed to truncate/delete spool for deleted agent [Agent[id=10001,name=,address=,port=16163,remote-endpoint=socket://,last-availability-report=1285758524490]] please manually remove the file: null}!!! missing resource message key=[Failed to truncate/delete spool for deleted agent [Agent[id=10001,name=,address=,port=16163,remote-endpoint=socket://,last-availability-report=1285758524490]] please manually remove the file: null] args=[java.lang.NullPointerException]
2010-09-29 16:39:05,562 INFO  [org.rhq.enterprise.server.core.AgentManagerBean] Removed agent: Agent[id=10001,name=,address=,port=16163,remote-endpoint=socket://,last-availability-report=1285758524490]
2010-09-29 16:39:05,789 ERROR [org.rhq.enterprise.server.discovery.DiscoveryServerServiceImpl] Received invalid inventory report from agent [Agent[id=0,name=,address=null,port=0,remote-endpoint=null,last-availability-report=null]]: Unknown Agent named [] sent an inventory report - that report will be ignored
2010-09-29 16:39:06,823 INFO  [org.rhq.enterprise.server.core.CoreServerServiceImpl] Got agent registration request for new agent:[][3.0.0.GA(8fb6059)]
2010-09-29 16:39:08,057 ERROR [org.rhq.enterprise.server.alert.engine.internal.AlertConditionCacheCoordinator] Could not find agent for scheduleId = 10008
2010-09-29 16:39:08,169 WARN  [org.hibernate.hql.ast.QueryTranslatorImpl] firstResult/maxResults specified with collection fetch; applying in memory!

Comment 3 Jay Shaughnessy 2014-04-04 19:44:07 UTC
Closing, unseen recently and the uninventory was actually successful.

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