Bug 1349377

Summary:	External Materialization MATVIEW_AFTER_LOAD_SCRIPT is not atomic operation
Product:	[JBoss] JBoss Data Virtualization 6	Reporter:	Jan Stastny <jstastny>
Component:	Teiid, Documentation	Assignee:	Van Halbert <vhalbert>
Status:	CLOSED NOTABUG	QA Contact:	Filip Elias <felias>
Severity:	urgent	Docs Contact:
Priority:	urgent
Version:	6.3.0	CC:	aszczucz, blafond, drieden, jolee, mbaluch, thauser, vhalbert
Target Milestone:	ER5	Keywords:	Documentation
Target Release:	6.3.0
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Known Issue
Doc Text:	Cause: The data source doesn't support XA transactions. Consequence: The before/load/after steps are not guaranteed to run as a single atomic unit. Workaround (if any): The commands can be put together in the same native call.	Story Points:	---
Clone Of:		Environment:
Last Closed:	2016-06-23 12:47:38 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 Jan Stastny 2016-06-23 10:52:41 UTC

There is a timing issue when using External Materialization. When a query on a matview is performed in certain time during matview loading, it might happen, that the materialized table does not exist, when in afterloadscript the primary and stage tables are being swapped using another temp table.
More info in attached JIRA.

Version:
DV 6.3.0 ER4.1

Comment 3 JBoss JIRA Server 2016-06-23 12:39:12 UTC

Steven Hawkins <shawkins> updated the status of jira TEIID-4294 to Resolved

Comment 5 JBoss JIRA Server 2016-10-05 13:36:47 UTC

Steven Hawkins <shawkins> updated the status of jira TEIID-4294 to Reopened