This is not fixed in ER2.

To reproduce:

1. Start a h2 instance and create the following tables:

    CREATE TABLE t1(id integer, name varchar(255));
    CREATE TABLE t1stage(id integer, name varchar(255));
    CREATE TABLE t2(id integer, name varchar(255));
    CREATE TABLE t2stage(id integer, name varchar(255));
    CREATE TABLE DV_MATVIEWS_STATUSTABLE (VDBName varchar(50) not null, VDBVersion integer not null, SchemaName varchar(50) not null, Name varchar(256) not null, TargetSchemaName varchar(50), TargetName varchar(256), Valid boolean not null, LoadState varchar(25) not null, Cardinality bigint, Updated timestamp not null, LoadNumber bigint not null, primary key (VDBName, VDBVersion, SchemaName, Name));


2. create an xa datasource on the server for this database
3. deploy the attached VDB

As soon as the vdb is deployed, the same errors as in the original jira are logged, i. e.

09:58:22,357 ERROR [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue14) TEIID30019 Unexpected exception for request 9HNbATnMLpP7.-7422392265667569664: java.lang.AssertionError: Transaction already associated with request.

and

09:58:22,375 WARN  [org.teiid.MATVIEWS] (Worker2_QueryProcessorQueue17) org.teiid.jdbc.TeiidSQLException: TEIID30328 Unable to evaluate (SELECT mvstatus('View', 'v1', Valid, LoadState, 'WAIT') FROM (SELECT 1) AS x LEFT OUTER JOIN h2.DB.PUBLIC.DV_MATVIEWS_STATUSTABLE ON VDBName = 'teiid4960' AND VDBVersion = 1 AND SchemaName = 'View' AND Name = 'v1' LIMIT 2): TEIID30328 Unable to evaluate mvstatus('View', 'v1', DV_MATVIEWS_STATUSTABLE__1.VALID, DV_MATVIEWS_STATUSTABLE__1.LOADSTATE, 'WAIT'): TEIID30384 Error while evaluating function mvstatus


(full server log attached)

Created attachment 1327784 [details]
VDB