[jira] [Updated] (PHOENIX-5404) Move check to client side to see if there are any child views that need to be dropped while receating a table/view
[ https://issues.apache.org/jira/browse/PHOENIX-5404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Geoffrey Jacoby updated PHOENIX-5404: - Fix Version/s: 5.3.0 (was: 4.17.0) (was: 5.2.0) (was: 4.16.2) > Move check to client side to see if there are any child views that need to be > dropped while receating a table/view > -- > > Key: PHOENIX-5404 > URL: https://issues.apache.org/jira/browse/PHOENIX-5404 > Project: Phoenix > Issue Type: Sub-task >Affects Versions: 5.0.0, 4.15.0 >Reporter: Thomas D'Silva >Priority: Major > Fix For: 5.3.0 > > > Remove {{ViewUtil.dropChildViews(env, tenantIdBytes, schemaName, > tableName);}} call in MetdataEndpointImpl.createTable > While creating a table or view we need to ensure that are not any child views > that haven't been clean up by the DropChildView task yet. Move this check to > the client (issue a scan against SYSTEM.CHILD_LINK to see if a single linking > row exists). -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (PHOENIX-5404) Move check to client side to see if there are any child views that need to be dropped while receating a table/view
[ https://issues.apache.org/jira/browse/PHOENIX-5404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ankit Singhal updated PHOENIX-5404: --- Fix Version/s: (was: 5.1.2) > Move check to client side to see if there are any child views that need to be > dropped while receating a table/view > -- > > Key: PHOENIX-5404 > URL: https://issues.apache.org/jira/browse/PHOENIX-5404 > Project: Phoenix > Issue Type: Sub-task >Affects Versions: 5.0.0, 4.15.0 >Reporter: Thomas D'Silva >Priority: Major > Fix For: 4.17.0, 5.2.0, 4.16.2 > > > Remove {{ViewUtil.dropChildViews(env, tenantIdBytes, schemaName, > tableName);}} call in MetdataEndpointImpl.createTable > While creating a table or view we need to ensure that are not any child views > that haven't been clean up by the DropChildView task yet. Move this check to > the client (issue a scan against SYSTEM.CHILD_LINK to see if a single linking > row exists). -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (PHOENIX-5404) Move check to client side to see if there are any child views that need to be dropped while receating a table/view
[ https://issues.apache.org/jira/browse/PHOENIX-5404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Viraj Jasani updated PHOENIX-5404: -- Fix Version/s: 4.16.2 5.1.2 5.2.0 4.17.0 > Move check to client side to see if there are any child views that need to be > dropped while receating a table/view > -- > > Key: PHOENIX-5404 > URL: https://issues.apache.org/jira/browse/PHOENIX-5404 > Project: Phoenix > Issue Type: Sub-task >Affects Versions: 5.0.0, 4.15.0 >Reporter: Thomas D'Silva >Priority: Major > Fix For: 4.17.0, 5.2.0, 5.1.2, 4.16.2 > > > Remove {{ViewUtil.dropChildViews(env, tenantIdBytes, schemaName, > tableName);}} call in MetdataEndpointImpl.createTable > While creating a table or view we need to ensure that are not any child views > that haven't been clean up by the DropChildView task yet. Move this check to > the client (issue a scan against SYSTEM.CHILD_LINK to see if a single linking > row exists). -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (PHOENIX-5404) Move check to client side to see if there are any child views that need to be dropped while receating a table/view
[ https://issues.apache.org/jira/browse/PHOENIX-5404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Viraj Jasani updated PHOENIX-5404: -- Fix Version/s: (was: 4.16.1) > Move check to client side to see if there are any child views that need to be > dropped while receating a table/view > -- > > Key: PHOENIX-5404 > URL: https://issues.apache.org/jira/browse/PHOENIX-5404 > Project: Phoenix > Issue Type: Sub-task >Affects Versions: 5.0.0, 4.15.0 >Reporter: Thomas D'Silva >Priority: Major > > Remove {{ViewUtil.dropChildViews(env, tenantIdBytes, schemaName, > tableName);}} call in MetdataEndpointImpl.createTable > While creating a table or view we need to ensure that are not any child views > that haven't been clean up by the DropChildView task yet. Move this check to > the client (issue a scan against SYSTEM.CHILD_LINK to see if a single linking > row exists). -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (PHOENIX-5404) Move check to client side to see if there are any child views that need to be dropped while receating a table/view
[ https://issues.apache.org/jira/browse/PHOENIX-5404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chinmay Kulkarni updated PHOENIX-5404: -- Fix Version/s: (was: 4.16.0) 4.16.1 > Move check to client side to see if there are any child views that need to be > dropped while receating a table/view > -- > > Key: PHOENIX-5404 > URL: https://issues.apache.org/jira/browse/PHOENIX-5404 > Project: Phoenix > Issue Type: Sub-task >Affects Versions: 5.0.0, 4.15.0 >Reporter: Thomas D'Silva >Assignee: Chinmay Kulkarni >Priority: Major > Fix For: 5.1.0, 4.16.1 > > > Remove {{ViewUtil.dropChildViews(env, tenantIdBytes, schemaName, > tableName);}} call in MetdataEndpointImpl.createTable > While creating a table or view we need to ensure that are not any child views > that haven't been clean up by the DropChildView task yet. Move this check to > the client (issue a scan against SYSTEM.CHILD_LINK to see if a single linking > row exists). -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (PHOENIX-5404) Move check to client side to see if there are any child views that need to be dropped while receating a table/view
[ https://issues.apache.org/jira/browse/PHOENIX-5404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chinmay Kulkarni updated PHOENIX-5404: -- Description: Remove {{ViewUtil.dropChildViews(env, tenantIdBytes, schemaName, tableName);}} call in MetdataEndpointImpl.createTable While creating a table or view we need to ensure that are not any child views that haven't been clean up by the DropChildView task yet. Move this check to the client (issue a scan against SYSTEM.CHILD_LINK to see if a single linking row exists). was: When we issue a {{DROP TABLE/VIEW}}, if the table/view being dropped has child views (and {{CASCADE}} is provided), we add a {{[DropChildViewsTask|https://github.com/apache/phoenix/blob/1d844950bb4ec8221873ecd2b094c20f427cd984/phoenix-core/src/main/java/org/apache/phoenix/coprocessor/tasks/DropChildViewsTask.java]}} in the {{SYSTEM.TASK}} table (see [this|https://github.com/apache/phoenix/blob/1d844950bb4ec8221873ecd2b094c20f427cd984/phoenix-core/src/main/java/org/apache/phoenix/coprocessor/MetaDataEndpointImpl.java#L2479]). This means that *while holding the row lock* for the table/view’s header row ([here|https://github.com/apache/phoenix/blob/1d844950bb4ec8221873ecd2b094c20f427cd984/phoenix-core/src/main/java/org/apache/phoenix/coprocessor/MetaDataEndpointImpl.java#L2253]) we do the following: # Make an [RPC|https://github.com/apache/phoenix/blob/1d844950bb4ec8221873ecd2b094c20f427cd984/phoenix-core/src/main/java/org/apache/phoenix/coprocessor/MetaDataEndpointImpl.java#L2459-L2461] to the region hosting {{SYSTEM.CHILD_LINK}} to scan it in order to find child views. # If any child views are found in the step above, we make additional RPCs to the region hosting {{SYSTEM.TASK}} to {{[UPSERT|https://github.com/apache/phoenix/blob/1d844950bb4ec8221873ecd2b094c20f427cd984/phoenix-core/src/main/java/org/apache/phoenix/coprocessor/MetaDataEndpointImpl.java#L2479-L2484]}} a {{DropChildViewsTask}} for immediate child views. # We [send remote mutations|https://github.com/apache/phoenix/blob/1d844950bb4ec8221873ecd2b094c20f427cd984/phoenix-core/src/main/java/org/apache/phoenix/coprocessor/MetaDataEndpointImpl.java#L2298-L2302] to drop parent→child links from the {{SYSTEM.CHILD_LINK}} table. Of the above extra RPCs, note that even if the table/view has no child views or if {{CASCADE}} is not provided, we will still do the first RPC from the server while holding a row lock. We should move this check to the client (issue a scan against SYSTEM.CHILD_LINK to see if a single linking row exists) and also add the task from the client. > Move check to client side to see if there are any child views that need to be > dropped while receating a table/view > -- > > Key: PHOENIX-5404 > URL: https://issues.apache.org/jira/browse/PHOENIX-5404 > Project: Phoenix > Issue Type: Sub-task >Affects Versions: 5.0.0, 4.15.0 >Reporter: Thomas D'Silva >Assignee: Chinmay Kulkarni >Priority: Major > Fix For: 5.1.0, 4.16.0 > > > Remove {{ViewUtil.dropChildViews(env, tenantIdBytes, schemaName, > tableName);}} call in MetdataEndpointImpl.createTable > While creating a table or view we need to ensure that are not any child views > that haven't been clean up by the DropChildView task yet. Move this check to > the client (issue a scan against SYSTEM.CHILD_LINK to see if a single linking > row exists). -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (PHOENIX-5404) Move check to client side to see if there are any child views that need to be dropped while receating a table/view
[ https://issues.apache.org/jira/browse/PHOENIX-5404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chinmay Kulkarni updated PHOENIX-5404: -- Description: When we issue a {{DROP TABLE/VIEW}}, if the table/view being dropped has child views (and {{CASCADE}} is provided), we add a {{[DropChildViewsTask|https://github.com/apache/phoenix/blob/1d844950bb4ec8221873ecd2b094c20f427cd984/phoenix-core/src/main/java/org/apache/phoenix/coprocessor/tasks/DropChildViewsTask.java]}} in the {{SYSTEM.TASK}} table (see [this|https://github.com/apache/phoenix/blob/1d844950bb4ec8221873ecd2b094c20f427cd984/phoenix-core/src/main/java/org/apache/phoenix/coprocessor/MetaDataEndpointImpl.java#L2479]). This means that *while holding the row lock* for the table/view’s header row ([here|https://github.com/apache/phoenix/blob/1d844950bb4ec8221873ecd2b094c20f427cd984/phoenix-core/src/main/java/org/apache/phoenix/coprocessor/MetaDataEndpointImpl.java#L2253]) we do the following: # Make an [RPC|https://github.com/apache/phoenix/blob/1d844950bb4ec8221873ecd2b094c20f427cd984/phoenix-core/src/main/java/org/apache/phoenix/coprocessor/MetaDataEndpointImpl.java#L2459-L2461] to the region hosting {{SYSTEM.CHILD_LINK}} to scan it in order to find child views. # If any child views are found in the step above, we make additional RPCs to the region hosting {{SYSTEM.TASK}} to {{[UPSERT|https://github.com/apache/phoenix/blob/1d844950bb4ec8221873ecd2b094c20f427cd984/phoenix-core/src/main/java/org/apache/phoenix/coprocessor/MetaDataEndpointImpl.java#L2479-L2484]}} a {{DropChildViewsTask}} for immediate child views. # We [send remote mutations|https://github.com/apache/phoenix/blob/1d844950bb4ec8221873ecd2b094c20f427cd984/phoenix-core/src/main/java/org/apache/phoenix/coprocessor/MetaDataEndpointImpl.java#L2298-L2302] to drop parent→child links from the {{SYSTEM.CHILD_LINK}} table. Of the above extra RPCs, note that even if the table/view has no child views or if {{CASCADE}} is not provided, we will still do the first RPC from the server while holding a row lock. We should move this check to the client (issue a scan against SYSTEM.CHILD_LINK to see if a single linking row exists) and also add the task from the client. was: Remove {{ViewUtil.dropChildViews(env, tenantIdBytes, schemaName, tableName);}} call in MetdataEndpointImpl.createTable While creating a table or view we need to ensure that are not any child views that haven't been clean up by the DropChildView task yet. Move this check to the client (issue a scan against SYSTEM.CHILD_LINK to see if a single linking row exists). > Move check to client side to see if there are any child views that need to be > dropped while receating a table/view > -- > > Key: PHOENIX-5404 > URL: https://issues.apache.org/jira/browse/PHOENIX-5404 > Project: Phoenix > Issue Type: Sub-task >Affects Versions: 5.0.0, 4.15.0 >Reporter: Thomas D'Silva >Assignee: Chinmay Kulkarni >Priority: Major > Fix For: 5.1.0, 4.16.0 > > > When we issue a {{DROP TABLE/VIEW}}, if the table/view being dropped has > child views (and {{CASCADE}} is provided), we add a > {{[DropChildViewsTask|https://github.com/apache/phoenix/blob/1d844950bb4ec8221873ecd2b094c20f427cd984/phoenix-core/src/main/java/org/apache/phoenix/coprocessor/tasks/DropChildViewsTask.java]}} > in the {{SYSTEM.TASK}} table (see > [this|https://github.com/apache/phoenix/blob/1d844950bb4ec8221873ecd2b094c20f427cd984/phoenix-core/src/main/java/org/apache/phoenix/coprocessor/MetaDataEndpointImpl.java#L2479]). > This means that *while holding the row lock* for the table/view’s header row > ([here|https://github.com/apache/phoenix/blob/1d844950bb4ec8221873ecd2b094c20f427cd984/phoenix-core/src/main/java/org/apache/phoenix/coprocessor/MetaDataEndpointImpl.java#L2253]) > we do the following: > # Make an > [RPC|https://github.com/apache/phoenix/blob/1d844950bb4ec8221873ecd2b094c20f427cd984/phoenix-core/src/main/java/org/apache/phoenix/coprocessor/MetaDataEndpointImpl.java#L2459-L2461] > to the region hosting {{SYSTEM.CHILD_LINK}} to scan it in order to find > child views. > # If any child views are found in the step above, we make additional RPCs to > the region hosting {{SYSTEM.TASK}} to > {{[UPSERT|https://github.com/apache/phoenix/blob/1d844950bb4ec8221873ecd2b094c20f427cd984/phoenix-core/src/main/java/org/apache/phoenix/coprocessor/MetaDataEndpointImpl.java#L2479-L2484]}} > a {{DropChildViewsTask}} for immediate child views. > # We [send remote > mutations|https://github.com/apache/phoenix/blob/1d844950bb4ec8221873ecd2b094c20f427cd984/phoenix-core/src/main/java/org/apache/phoenix/coprocessor/MetaDataEndpointImpl.java#L2298-L2302] > to drop parent→
[jira] [Updated] (PHOENIX-5404) Move check to client side to see if there are any child views that need to be dropped while receating a table/view
[ https://issues.apache.org/jira/browse/PHOENIX-5404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chinmay Kulkarni updated PHOENIX-5404: -- Priority: Major (was: Blocker) > Move check to client side to see if there are any child views that need to be > dropped while receating a table/view > -- > > Key: PHOENIX-5404 > URL: https://issues.apache.org/jira/browse/PHOENIX-5404 > Project: Phoenix > Issue Type: Sub-task >Affects Versions: 5.0.0, 4.15.0 >Reporter: Thomas D'Silva >Assignee: Chinmay Kulkarni >Priority: Major > Fix For: 5.1.0, 4.16.0 > > > Remove {{ViewUtil.dropChildViews(env, tenantIdBytes, schemaName, > tableName);}} call in MetdataEndpointImpl.createTable > While creating a table or view we need to ensure that are not any child views > that haven't been clean up by the DropChildView task yet. Move this check to > the client (issue a scan against SYSTEM.CHILD_LINK to see if a single linking > row exists). -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (PHOENIX-5404) Move check to client side to see if there are any child views that need to be dropped while receating a table/view
[ https://issues.apache.org/jira/browse/PHOENIX-5404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chinmay Kulkarni updated PHOENIX-5404: -- Priority: Blocker (was: Major) > Move check to client side to see if there are any child views that need to be > dropped while receating a table/view > -- > > Key: PHOENIX-5404 > URL: https://issues.apache.org/jira/browse/PHOENIX-5404 > Project: Phoenix > Issue Type: Sub-task >Affects Versions: 5.0.0, 4.15.0 >Reporter: Thomas D'Silva >Assignee: Chinmay Kulkarni >Priority: Blocker > Fix For: 5.1.0, 4.16.0 > > > Remove {{ViewUtil.dropChildViews(env, tenantIdBytes, schemaName, > tableName);}} call in MetdataEndpointImpl.createTable > While creating a table or view we need to ensure that are not any child views > that haven't been clean up by the DropChildView task yet. Move this check to > the client (issue a scan against SYSTEM.CHILD_LINK to see if a single linking > row exists). -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (PHOENIX-5404) Move check to client side to see if there are any child views that need to be dropped while receating a table/view
[ https://issues.apache.org/jira/browse/PHOENIX-5404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chinmay Kulkarni updated PHOENIX-5404: -- Fix Version/s: (was: 4.16.1) (was: 4.15.1) 4.16.0 5.1.0 > Move check to client side to see if there are any child views that need to be > dropped while receating a table/view > -- > > Key: PHOENIX-5404 > URL: https://issues.apache.org/jira/browse/PHOENIX-5404 > Project: Phoenix > Issue Type: Sub-task >Reporter: Thomas D'Silva >Priority: Major > Fix For: 5.1.0, 4.16.0 > > > Remove {{ViewUtil.dropChildViews(env, tenantIdBytes, schemaName, > tableName);}} call in MetdataEndpointImpl.createTable > While creating a table or view we need to ensure that are not any child views > that haven't been clean up by the DropChildView task yet. Move this check to > the client (issue a scan against SYSTEM.CHILD_LINK to see if a single linking > row exists). -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (PHOENIX-5404) Move check to client side to see if there are any child views that need to be dropped while receating a table/view
[ https://issues.apache.org/jira/browse/PHOENIX-5404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chinmay Kulkarni updated PHOENIX-5404: -- Affects Version/s: 5.0.0 4.15.0 > Move check to client side to see if there are any child views that need to be > dropped while receating a table/view > -- > > Key: PHOENIX-5404 > URL: https://issues.apache.org/jira/browse/PHOENIX-5404 > Project: Phoenix > Issue Type: Sub-task >Affects Versions: 5.0.0, 4.15.0 >Reporter: Thomas D'Silva >Priority: Major > Fix For: 5.1.0, 4.16.0 > > > Remove {{ViewUtil.dropChildViews(env, tenantIdBytes, schemaName, > tableName);}} call in MetdataEndpointImpl.createTable > While creating a table or view we need to ensure that are not any child views > that haven't been clean up by the DropChildView task yet. Move this check to > the client (issue a scan against SYSTEM.CHILD_LINK to see if a single linking > row exists). -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (PHOENIX-5404) Move check to client side to see if there are any child views that need to be dropped while receating a table/view
[ https://issues.apache.org/jira/browse/PHOENIX-5404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Xinyi Yan updated PHOENIX-5404: --- Fix Version/s: (was: 4.16.0) 4.16.1 > Move check to client side to see if there are any child views that need to be > dropped while receating a table/view > -- > > Key: PHOENIX-5404 > URL: https://issues.apache.org/jira/browse/PHOENIX-5404 > Project: Phoenix > Issue Type: Sub-task >Reporter: Thomas D'Silva >Priority: Major > Fix For: 4.15.1, 4.16.1 > > > Remove {{ViewUtil.dropChildViews(env, tenantIdBytes, schemaName, > tableName);}} call in MetdataEndpointImpl.createTable > While creating a table or view we need to ensure that are not any child views > that haven't been clean up by the DropChildView task yet. Move this check to > the client (issue a scan against SYSTEM.CHILD_LINK to see if a single linking > row exists). -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (PHOENIX-5404) Move check to client side to see if there are any child views that need to be dropped while receating a table/view
[ https://issues.apache.org/jira/browse/PHOENIX-5404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Xinyi Yan updated PHOENIX-5404: --- Fix Version/s: 4.16.0 > Move check to client side to see if there are any child views that need to be > dropped while receating a table/view > -- > > Key: PHOENIX-5404 > URL: https://issues.apache.org/jira/browse/PHOENIX-5404 > Project: Phoenix > Issue Type: Sub-task >Reporter: Thomas D'Silva >Priority: Major > Fix For: 4.15.1, 4.16.0 > > > Remove {{ViewUtil.dropChildViews(env, tenantIdBytes, schemaName, > tableName);}} call in MetdataEndpointImpl.createTable > While creating a table or view we need to ensure that are not any child views > that haven't been clean up by the DropChildView task yet. Move this check to > the client (issue a scan against SYSTEM.CHILD_LINK to see if a single linking > row exists). -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (PHOENIX-5404) Move check to client side to see if there are any child views that need to be dropped while receating a table/view
[ https://issues.apache.org/jira/browse/PHOENIX-5404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chinmay Kulkarni updated PHOENIX-5404: -- Fix Version/s: 4.15.1 > Move check to client side to see if there are any child views that need to be > dropped while receating a table/view > -- > > Key: PHOENIX-5404 > URL: https://issues.apache.org/jira/browse/PHOENIX-5404 > Project: Phoenix > Issue Type: Sub-task >Reporter: Thomas D'Silva >Priority: Major > Fix For: 4.15.1 > > > Remove {{ViewUtil.dropChildViews(env, tenantIdBytes, schemaName, > tableName);}} call in MetdataEndpointImpl.createTable > While creating a table or view we need to ensure that are not any child views > that haven't been clean up by the DropChildView task yet. Move this check to > the client (issue a scan against SYSTEM.CHILD_LINK to see if a single linking > row exists). -- This message was sent by Atlassian Jira (v8.3.4#803005)