Bug 1419142

Summary:	pg_temp_15.vacuum_l Tables in inventory and marked as down
Product:	[JBoss] JBoss Operations Network	Reporter:	Filip Brychta <fbrychta>
Component:	Plugin - Postgres	Assignee:	Michael Burman <miburman>
Status:	CLOSED ERRATA	QA Contact:	Filip Brychta <fbrychta>
Severity:	medium	Docs Contact:
Priority:	high
Version:	JON 3.3.8	CC:	miburman, spinder
Target Milestone:	DR01	Keywords:	Triaged
Target Release:	JON 3.3.9
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2017-10-02 17:21:51 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Filip Brychta 2017-02-03 17:01:17 UTC

Description of problem:
pg_temp_15.vacuum_l Table probably created during new postgres plugin operation 'Remove orphan large objects' introduced in bz 1381720 are discovered and shown in inventory. But they are later removed so they are marked in inventory as down and agent.log contains warnings:
2017-02-03 11:52:24,377 WARN  [InventoryManager.availability-1] (rhq.core.pc.inventory.AvailabilityExecutor)- Availability collection failed with exception on Resource[id=12533, uuid=f1a4ff47-2e80-4c47-a4bd-7bf1ddb3a209, type={Postgres}Table, key=pg_temp_22.vacuum_l, name=pg_temp_22.vacuum_l, parent=rhq], availability will be reported as DOWN, reason=Failed to start component for Resource[id=12533, uuid=f1a4ff47-2e80-4c47-a4bd-7bf1ddb3a209, type={Postgres}Table, key=pg_temp_22.vacuum_l, name=pg_temp_22.vacuum_l, parent=rhq] - table does not exist


Version-Release number of selected component (if applicable):
JON3.3.8.ER02

Comment 1 Michael Burman 2017-04-04 12:05:18 UTC

This is because Postgres discovers temporary tables as normal tables.

Comment 2 Michael Burman 2017-04-04 12:19:45 UTC

Fixed in the master:

commit 129ca1caf7ff084f115f4c00244e8fede267ca50
Author: Michael Burman <miburman>
Date:   Tue Apr 4 15:18:02 2017 +0300

    [BZ 1419142] Do not discover tables in the pg_temp* namespace

Comment 4 Simeon Pinder 2017-09-01 15:34:20 UTC

Moving to ON_QA as available for test with the following binary:
http://download.eng.bos.redhat.com/brewroot/packages/org.jboss.on-jboss-on-parent/3.3.0.GA/133/maven/org/jboss/on/jon-server-patch/3.3.0.GA/jon-server-patch-3.3.0.GA.zip

*NOTE Build represents JON 3.3.9 DR01 build.

Please report issues as you encounter them.

Comment 6 errata-xmlrpc 2017-10-02 17:21:51 UTC

Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHEA-2017:2846