You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@phoenix.apache.org by sk...@apache.org on 2019/11/14 21:23:30 UTC
[phoenix] branch 4.14-HBase-1.4 updated: PHOENIX-5531:
IndexUpgradeTool crashes for tables without any indexes + sleep problems
(Priyank Porwal + Swaroopa Kadam)
This is an automated email from the ASF dual-hosted git repository.
skadam pushed a commit to branch 4.14-HBase-1.4
in repository https://gitbox.apache.org/repos/asf/phoenix.git
The following commit(s) were added to refs/heads/4.14-HBase-1.4 by this push:
new f451f27 PHOENIX-5531: IndexUpgradeTool crashes for tables without any indexes + sleep problems (Priyank Porwal + Swaroopa Kadam)
f451f27 is described below
commit f451f27d778c1ad2e31aa677ff36de67ec521fa2
Author: s.kadam <s....@salesforce.com>
AuthorDate: Thu Nov 14 11:02:02 2019 -0800
PHOENIX-5531: IndexUpgradeTool crashes for tables without any indexes + sleep problems (Priyank Porwal + Swaroopa Kadam)
---
.../end2end/ParameterizedIndexUpgradeToolIT.java | 14 ++
.../phoenix/mapreduce/index/IndexUpgradeTool.java | 159 +++++++++++----------
2 files changed, 101 insertions(+), 72 deletions(-)
diff --git a/phoenix-core/src/it/java/org/apache/phoenix/end2end/ParameterizedIndexUpgradeToolIT.java b/phoenix-core/src/it/java/org/apache/phoenix/end2end/ParameterizedIndexUpgradeToolIT.java
index f1cbb9a..1b164a4 100644
--- a/phoenix-core/src/it/java/org/apache/phoenix/end2end/ParameterizedIndexUpgradeToolIT.java
+++ b/phoenix-core/src/it/java/org/apache/phoenix/end2end/ParameterizedIndexUpgradeToolIT.java
@@ -304,6 +304,20 @@ public class ParameterizedIndexUpgradeToolIT extends BaseTest {
}
@Test
+ public void testToolWithNoIndex() throws Exception {
+ if (!upgrade || isNamespaceEnabled) {
+ return;
+ }
+ conn.createStatement().execute("CREATE TABLE TEST.NEW_TABLE (id bigint NOT NULL "
+ + "PRIMARY KEY, a.name varchar, sal bigint, address varchar)" + tableDDLOptions);
+ iut.setInputTables("TEST.NEW_TABLE");
+ iut.prepareToolSetup();
+ int status = iut.executeTool();
+ Assert.assertEquals(0, status);
+ conn.createStatement().execute("DROP TABLE TEST.NEW_TABLE");
+ }
+
+ @Test
public void testToolWithInputFileParameter() throws Exception {
BufferedWriter writer = new BufferedWriter(new FileWriter(new File(INPUT_FILE)));
writer.write(INPUT_LIST);
diff --git a/phoenix-core/src/main/java/org/apache/phoenix/mapreduce/index/IndexUpgradeTool.java b/phoenix-core/src/main/java/org/apache/phoenix/mapreduce/index/IndexUpgradeTool.java
index 8a36134..bdeaeec 100644
--- a/phoenix-core/src/main/java/org/apache/phoenix/mapreduce/index/IndexUpgradeTool.java
+++ b/phoenix-core/src/main/java/org/apache/phoenix/mapreduce/index/IndexUpgradeTool.java
@@ -330,29 +330,42 @@ public class IndexUpgradeTool extends Configured implements Tool {
try (Admin admin = queryServices.getAdmin()) {
PTable dataTable = PhoenixRuntime.getTableNoCache(conn, dataTableFullName);
- LOGGER.info("Executing " + operation + " for " + dataTableFullName);
+ LOGGER.info("Executing " + operation + " of " + dataTableFullName);
boolean mutable = !(dataTable.isImmutableRows());
+
+ disableTable(admin, dataTableFullName, indexes);
+ modifyTable(admin, dataTableFullName, indexes);
if (!mutable) {
LOGGER.info("Data table is immutable, waiting for "
+ (GLOBAL_INDEX_CHECKER_ENABLED_MAP_EXPIRATION_MIN + 1)
+ " minutes for client cache to expire");
- if (!test) {
- Thread.sleep(
- (GLOBAL_INDEX_CHECKER_ENABLED_MAP_EXPIRATION_MIN + 1) * 60 * 1000);
+ if (!(test || dryRun || indexes.isEmpty())) {
+ try {
+ Thread.sleep((GLOBAL_INDEX_CHECKER_ENABLED_MAP_EXPIRATION_MIN
+ + 1) * 60 * 1000);
+ } catch (InterruptedException e) {
+ LOGGER.warning("Sleep before starting index rebuild interrupted. "
+ + e.getMessage());
+ }
}
}
- disableTable(admin, dataTableFullName, indexes);
- modifyTable(admin, dataTableFullName, indexes);
enableTable(admin, dataTableFullName, indexes);
- rebuildIndexes(conn, conf, dataTableFullName);
- LOGGER.info("Completed " + operation + " for " + dataTableFullName);
- } catch (IOException | SQLException | InterruptedException e) {
+ LOGGER.info("Completed " + operation + " of " + dataTableFullName);
+ } catch (IOException | SQLException e) {
LOGGER.severe("Something went wrong while executing " + operation
+ " for " + dataTableFullName + " steps " + e);
return -1;
}
}
+ // Opportunistically kick-off index rebuilds after upgrade operation
+ if (upgrade) {
+ for (String dataTableFullName : tablesAndIndexes.keySet()) {
+ rebuildIndexes(conn, conf, dataTableFullName);
+ LOGGER.info("Started index rebuild post " + operation + " of "
+ + dataTableFullName);
+ }
+ }
return 0;
}
@@ -412,13 +425,23 @@ public class IndexUpgradeTool extends Configured implements Tool {
}
private void rebuildIndexes(Connection conn, Configuration conf, String dataTableFullName) {
- if (upgrade) {
- prepareToRebuildIndexes(conn, dataTableFullName);
+ try {
+ HashMap<String, IndexInfo> rebuildMap = prepareToRebuildIndexes(conn, dataTableFullName);
+
+ //for rebuilding indexes in case of upgrade and if there are indexes on the table/view.
+ if (rebuildMap.isEmpty()) {
+ LOGGER.info("No indexes to rebuild for table " + dataTableFullName);
+ return;
+ }
if(!test) {
indexingTool = new IndexTool();
+ indexingTool.setConf(conf);
}
- indexingTool.setConf(conf);
- rebuildIndexes(conn, dataTableFullName, indexingTool);
+ startIndexRebuilds(conn, dataTableFullName, rebuildMap, indexingTool);
+
+ } catch (SQLException e) {
+ LOGGER.severe("Failed to prepare the map for index rebuilds " + e);
+ throw new RuntimeException("Failed to prepare the map for index rebuilds");
}
}
@@ -478,10 +501,14 @@ public class IndexUpgradeTool extends Configured implements Tool {
}
}
- private int rebuildIndexes(Connection conn, String dataTable, IndexTool indexingTool) {
- for(Map.Entry<String, IndexInfo> indexMap : rebuildMap.get(dataTable).entrySet()) {
- String index = indexMap.getKey();
- IndexInfo indexInfo = indexMap.getValue();
+ private int startIndexRebuilds(Connection conn,
+ String dataTable,
+ HashMap<String, IndexInfo> indexInfos,
+ IndexTool indexingTool) {
+
+ for(Map.Entry<String, IndexInfo> entry : indexInfos.entrySet()) {
+ String index = entry.getKey();
+ IndexInfo indexInfo = entry.getValue();
String indexName = SchemaUtil.getTableNameFromFullName(index);
String tenantId = indexInfo.getTenantId();
String baseTable = indexInfo.getBaseTable();
@@ -588,68 +615,56 @@ public class IndexUpgradeTool extends Configured implements Tool {
}
}
- private void prepareToRebuildIndexes(Connection conn, String dataTableFullName) {
- try {
- Gson gson = new Gson();
- HashMap<String, IndexInfo> rebuildIndexes = new HashMap<>();
-
- HashSet<String> physicalIndexes = tablesAndIndexes.get(dataTableFullName);
-
- String viewIndexPhysicalName = MetaDataUtil
- .getViewIndexPhysicalName(dataTableFullName);
- boolean hasViewIndex = physicalIndexes.contains(viewIndexPhysicalName);
- String schemaName = SchemaUtil.getSchemaNameFromFullName(dataTableFullName);
- String tableName = SchemaUtil.getTableNameFromFullName(dataTableFullName);
+ private HashMap<String, IndexInfo> prepareToRebuildIndexes(Connection conn,
+ String dataTableFullName) throws SQLException {
- for (String physicalIndexName : physicalIndexes) {
- if (physicalIndexName.equals(viewIndexPhysicalName)) {
- continue;
- }
- String indexTableName = SchemaUtil.getTableNameFromFullName(physicalIndexName);
- String pIndexName = SchemaUtil.getTableName(schemaName, indexTableName);
- IndexInfo indexInfo = new IndexInfo(schemaName, tableName,
- GLOBAL_INDEX_ID, pIndexName, pIndexName);
- rebuildIndexes.put(physicalIndexName, indexInfo);
- }
-
- if (hasViewIndex) {
+ HashMap<String, IndexInfo> indexInfos = new HashMap<>();
- String viewSql = "SELECT DISTINCT TABLE_NAME, TENANT_ID FROM "
- + "SYSTEM.CATALOG "
- + "WHERE COLUMN_FAMILY = \'" + dataTableFullName + "\' "
- + (!StringUtil.EMPTY_STRING.equals(schemaName) ? "AND TABLE_SCHEM = \'"
- + schemaName + "\' " : "")
- + "AND LINK_TYPE = "
- + PTable.LinkType.PHYSICAL_TABLE.getSerializedValue();
+ HashSet<String> physicalIndexes = tablesAndIndexes.get(dataTableFullName);
- ResultSet rs = conn.createStatement().executeQuery(viewSql);
+ String viewIndexPhysicalName = MetaDataUtil
+ .getViewIndexPhysicalName(dataTableFullName);
+ boolean hasViewIndex = physicalIndexes.contains(viewIndexPhysicalName);
+ String schemaName = SchemaUtil.getSchemaNameFromFullName(dataTableFullName);
+ String tableName = SchemaUtil.getTableNameFromFullName(dataTableFullName);
- while (rs.next()) {
- String viewName = rs.getString(1);
- String tenantId = rs.getString(2);
-
- ArrayList<String> viewIndexes = findViewIndexes(conn, schemaName, viewName,
- tenantId);
- for (String viewIndex : viewIndexes) {
- IndexInfo indexInfo = new IndexInfo(schemaName, viewName,
- tenantId == null ? GLOBAL_INDEX_ID : tenantId, viewIndex, viewIndexPhysicalName);
- rebuildIndexes.put(viewIndex, indexInfo);
- }
- }
+ for (String physicalIndexName : physicalIndexes) {
+ if (physicalIndexName.equals(viewIndexPhysicalName)) {
+ continue;
}
- //for rebuilding indexes in case of upgrade and if there are indexes on the table/view.
- if (!rebuildIndexes.isEmpty()) {
- rebuildMap.put(dataTableFullName, rebuildIndexes);
- String json = gson.toJson(rebuildMap);
- LOGGER.info("Index rebuild map " + json);
- } else {
- LOGGER.info("No indexes to rebuild for table " + dataTableFullName);
+ String indexTableName = SchemaUtil.getTableNameFromFullName(physicalIndexName);
+ String pIndexName = SchemaUtil.getTableName(schemaName, indexTableName);
+ IndexInfo indexInfo = new IndexInfo(schemaName, tableName,
+ GLOBAL_INDEX_ID, pIndexName, pIndexName);
+ indexInfos.put(physicalIndexName, indexInfo);
+ }
+
+ if (hasViewIndex) {
+
+ String viewSql = "SELECT DISTINCT TABLE_NAME, TENANT_ID FROM "
+ + "SYSTEM.CATALOG "
+ + "WHERE COLUMN_FAMILY = \'" + dataTableFullName + "\' "
+ + (!StringUtil.EMPTY_STRING.equals(schemaName) ? "AND TABLE_SCHEM = \'"
+ + schemaName + "\' " : "")
+ + "AND LINK_TYPE = "
+ + PTable.LinkType.PHYSICAL_TABLE.getSerializedValue();
+
+ ResultSet rs = conn.createStatement().executeQuery(viewSql);
+
+ while (rs.next()) {
+ String viewName = rs.getString(1);
+ String tenantId = rs.getString(2);
+
+ ArrayList<String> viewIndexes = findViewIndexes(conn, schemaName, viewName,
+ tenantId);
+ for (String viewIndex : viewIndexes) {
+ IndexInfo indexInfo = new IndexInfo(schemaName, viewName,
+ tenantId == null ? GLOBAL_INDEX_ID : tenantId, viewIndex, viewIndexPhysicalName);
+ indexInfos.put(viewIndex, indexInfo);
+ }
}
-
- } catch (SQLException e) {
- LOGGER.severe("Failed to prepare the map for index rebuilds " + e);
- throw new RuntimeException("Failed to prepare the map for index rebuilds");
}
+ return indexInfos;
}
private ArrayList<String> findViewIndexes(Connection conn, String schemaName, String viewName,