[teiid-issues] [JBoss JIRA] Reopened: (TEIID-1256) Clear caches when VDB with same version re-deployed

[Steven Hawkins (JIRA)]

     [ https://jira.jboss.org/browse/TEIID-1256?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins reopened TEIID-1256:
-----------------------------------



Clearing the entire cache is much too coarse.  Deploying any vdb, regardless of whether it was an overwrite would cause a large negative performance impact across all vdbs.  This also cannot be resolved until the prior connections are also terminated.  Otherwise they may reintroduce invalid cache entries, or use new cache entries from new connections that would be invalid to them.

> Clear caches when VDB with same version re-deployed
> ---------------------------------------------------
>
>                 Key: TEIID-1256
>                 URL: https://jira.jboss.org/browse/TEIID-1256
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 7.1
>            Reporter: Ramesh Reddy
>            Assignee: Ramesh Reddy
>             Fix For: 7.1.1
>
>
> When a VDB with same name and version is re-deployed, the new re-deployed VDB may have its metadata changed. In this case if Teiid has any
> PreparedPlanCache 
> ResultSetCache
> they need to flushed for that VDB, otherwise it will produce wrong results. One issue is there could be active connections on VDB, those need to be terminated also. Based on how failover is configured they may re-connect on the next query automatically.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira