Bug 611726

Summary: Oracle: issue when uninventoring platform
Product: [Other] RHQ Project Reporter: Heiko W. Rupp <hrupp>
Component: Core ServerAssignee: RHQ Project Maintainer <rhq-maint>
Status: CLOSED CURRENTRELEASE QA Contact: Rajan Timaniya <rtimaniy>
Severity: medium Docs Contact:
Priority: low    
Version: 3.0.0CC: ccrouch, jshaughn, rtimaniy
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2014-04-04 19:44:07 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

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=10.65.193.1, name=10.65.193.1, 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=10.65.193.1,address=10.65.193.1,port=16163,remote-endpoint=socket://10.65.193.1:16163/?rhq.communications.connector.rhqtype=agent&numAcceptThreads=1&maxPoolSize=303&clientMaxPoolSize=304&socketTimeout=60000&enableTcpNoDelay=true&backlog=200,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=10.65.193.1,address=10.65.193.1,port=16163,remote-endpoint=socket://10.65.193.1:16163/?rhq.communications.connector.rhqtype=agent&numAcceptThreads=1&maxPoolSize=303&clientMaxPoolSize=304&socketTimeout=60000&enableTcpNoDelay=true&backlog=200,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=10.65.193.1,address=10.65.193.1,port=16163,remote-endpoint=socket://10.65.193.1:16163/?rhq.communications.connector.rhqtype=agent&numAcceptThreads=1&maxPoolSize=303&clientMaxPoolSize=304&socketTimeout=60000&enableTcpNoDelay=true&backlog=200,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=10.65.193.1,address=null,port=0,remote-endpoint=null,last-availability-report=null]]: Unknown Agent named [10.65.193.1] 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: 10.65.193.1[10.65.193.1:16163][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.