private void executeIgnoringError(String sql, String errorToIgnore) { try { connectionSupplier.get().executeUnregisteredQuery(sql); } catch (PalantirSqlException e) { if (!e.getMessage().contains(errorToIgnore)) { log.error("Error occurred trying to execute the query {}", sql, e); throw e; } } } }
private void executeIgnoringError(String sql, String errorToIgnore) { try { connectionSupplier.get().executeUnregisteredQuery(sql); } catch (PalantirSqlException e) { if (!e.getMessage().contains(errorToIgnore)) { log.error("Error occurred trying to execute the Postgres query {}", sql, e); throw e; } } } }
private void executeIgnoringError(String sql, String errorToIgnore) { try { conns.get().executeUnregisteredQuery(sql); } catch (PalantirSqlException e) { if (!e.getMessage().contains(errorToIgnore)) { log.error("Error occurred trying to execute the Oracle query {}.", sql, e); throw e; } } }
@Override public void truncate() { conns.get().executeUnregisteredQuery("TRUNCATE TABLE " + prefixedTableName()); }
private void runCompactOnTable() { // VACUUM FULL is /really/ what we want here, but it takes out a table lock conns.get().executeUnregisteredQuery("VACUUM ANALYZE " + prefixedTableName()); }
private void executeIgnoringError(String sql, String errorToIgnore) { ignoringError(() -> conns.get().executeUnregisteredQuery(sql), e -> e.getMessage().contains(errorToIgnore)); }
@Override public void truncate() { try { conns.get().executeUnregisteredQuery( "TRUNCATE TABLE " + oracleTableNameGetter.getInternalShortTableName(conns, tableRef)); } catch (TableMappingNotFoundException | RuntimeException e) { throw new IllegalStateException( String.format( "Truncate called on a table (%s) that did not exist", oracleTableNameGetter.getPrefixedTableName(tableRef)), e); } truncateOverflowTableIfItExists(); }
private void dropTableInternal(String fullTableName, String shortTableName) { executeIgnoringError("DROP TABLE " + shortTableName + " PURGE", OracleErrorConstants.ORACLE_NOT_EXISTS_ERROR); if (config.useTableMapping()) { conns.get().executeUnregisteredQuery( "DELETE FROM " + AtlasDbConstants.ORACLE_NAME_MAPPING_TABLE + " WHERE table_name = ?", fullTableName); oracleTableNameGetter.clearCacheForTable(fullTableName); } }
@Override public void drop() { executeIgnoringError("DROP TABLE " + prefixedTableName(), "does not exist"); conns.get().executeUnregisteredQuery( String.format("DELETE FROM %s WHERE table_name = ?", config.metadataTable().getQualifiedName()), tableName.getQualifiedName()); }
private void clearTableSizeCacheAndDropTableMetadata() { valueStyleCache.clearCacheForTable(tableRef); conns.get().executeUnregisteredQuery( "DELETE FROM " + config.metadataTable().getQualifiedName() + " WHERE table_name = ?", tableRef.getQualifiedName()); }
private void assertThatVacuumWasNotPerformed(SqlConnection sqlConnection) { assertFalse(postgresDdlTable.shouldRunCompaction()); postgresDdlTable.compactInternally(false); verify(sqlConnection, times(2)).selectResultSetUnregisteredQuery(startsWith("SELECT FLOOR"), any()); verify(sqlConnection, never()).executeUnregisteredQuery( eq("VACUUM ANALYZE " + DbKvs.internalTableName(TEST_TABLE))); } }
private void truncateOverflowTableIfItExists() { TableValueStyle tableValueStyle = valueStyleCache.getTableType(conns, tableRef, config.metadataTable()); if (tableValueStyle.equals(TableValueStyle.OVERFLOW) && config.overflowMigrationState() != OverflowMigrationState.UNSTARTED) { try { conns.get().executeUnregisteredQuery( "TRUNCATE TABLE " + oracleTableNameGetter.getInternalShortOverflowTableName(conns, tableRef)); } catch (TableMappingNotFoundException | RuntimeException e) { throw new IllegalStateException( String.format( "Truncate called on a table (%s) that was supposed to have an overflow table (%s)," + " but that overflow table appears to not exist", oracleTableNameGetter.getPrefixedTableName(tableRef), oracleTableNameGetter.getPrefixedOverflowTableName(tableRef)), e); } } }
private void assertThatVacuumWasPerformed(SqlConnection sqlConnection, boolean assertThatTimestampsWereChecked) { assertTrue(postgresDdlTable.shouldRunCompaction()); postgresDdlTable.compactInternally(false); if (assertThatTimestampsWereChecked) { verify(sqlConnection, times(2)).selectResultSetUnregisteredQuery(startsWith("SELECT FLOOR"), any()); } verify(sqlConnection).executeUnregisteredQuery(eq("VACUUM ANALYZE " + DbKvs.internalTableName(TEST_TABLE))); }
getCompactionConnection().executeUnregisteredQuery( "ALTER TABLE " + oracleTableNameGetter.getInternalShortTableName(conns, tableRef) + " MOVE ONLINE"); if (inMaintenanceHours) { Stopwatch shrinkTimer = Stopwatch.createStarted(); getCompactionConnection().executeUnregisteredQuery( "ALTER TABLE " + oracleTableNameGetter.getInternalShortTableName(conns, tableRef) + " SHRINK SPACE"); } else { Stopwatch shrinkAndCompactTimer = Stopwatch.createStarted(); getCompactionConnection().executeUnregisteredQuery( "ALTER TABLE " + oracleTableNameGetter.getInternalShortTableName(conns, tableRef) + " SHRINK SPACE COMPACT");
conns.get().executeUnregisteredQuery( String.format("CREATE TABLE %s (" + " row_name BYTEA NOT NULL,"
private void executeIgnoringError(String sql, String errorToIgnore) { try { conns.get().executeUnregisteredQuery(sql); } catch (PalantirSqlException e) { if (!e.getMessage().contains(errorToIgnore)) { log.error("Error occurred trying to execute the Oracle query {}.", sql, e); throw e; } } }
private void executeIgnoringError(String sql, String errorToIgnore) { try { connectionSupplier.get().executeUnregisteredQuery(sql); } catch (PalantirSqlException e) { if (!e.getMessage().contains(errorToIgnore)) { log.error("Error occurred trying to execute the query {}", sql, e); throw e; } } } }
private void dropTableInternal(String fullTableName, String shortTableName) { executeIgnoringError("DROP TABLE " + shortTableName + " PURGE", OracleErrorConstants.ORACLE_NOT_EXISTS_ERROR); if (config.useTableMapping()) { conns.get().executeUnregisteredQuery( "DELETE FROM " + AtlasDbConstants.ORACLE_NAME_MAPPING_TABLE + " WHERE table_name = ?", fullTableName); oracleTableNameGetter.clearCacheForTable(fullTableName); } }
@Override public void drop() { executeIgnoringError("DROP TABLE " + prefixedTableName(), "does not exist"); conns.get().executeUnregisteredQuery( String.format("DELETE FROM %s WHERE table_name = ?", config.metadataTable().getQualifiedName()), tableName.getQualifiedName()); }
private void clearTableSizeCacheAndDropTableMetadata() { valueStyleCache.clearCacheForTable(tableRef); conns.get().executeUnregisteredQuery( "DELETE FROM " + config.metadataTable().getQualifiedName() + " WHERE table_name = ?", tableRef.getQualifiedName()); }