use of com.google.cloud.teleport.v2.templates.datastream.ChangeEventSequence in project DataflowTemplates by GoogleCloudPlatform.
the class SpannerTransactionWriterDoFn method processElement.
@ProcessElement
public void processElement(ProcessContext c) {
FailsafeElement<String, String> msg = c.element();
Ddl ddl = c.sideInput(ddlView);
processedEvents.inc();
/*
* Try Catch block to capture any exceptions that might occur while processing
* DataStream events while writing to Cloud Spanner. All Exceptions that are caught
* can be retried based on the exception type.
*/
try {
JsonNode changeEvent = mapper.readTree(msg.getPayload());
ChangeEventContext changeEventContext = ChangeEventContextFactory.createChangeEventContext(changeEvent, ddl, shadowTablePrefix, sourceType);
// Sequence information for the current change event.
ChangeEventSequence currentChangeEventSequence = ChangeEventSequenceFactory.createChangeEventSequenceFromChangeEventContext(changeEventContext);
// Start transaction
spannerAccessor.getDatabaseClient().readWriteTransaction().run((TransactionCallable<Void>) transaction -> {
ChangeEventSequence previousChangeEventSequence = ChangeEventSequenceFactory.createChangeEventSequenceFromShadowTable(transaction, changeEventContext);
if (previousChangeEventSequence != null && previousChangeEventSequence.compareTo(currentChangeEventSequence) >= 0) {
return null;
}
transaction.buffer(changeEventContext.getMutations());
return null;
});
com.google.cloud.Timestamp timestamp = com.google.cloud.Timestamp.now();
c.output(timestamp);
sucessfulEvents.inc();
} catch (InvalidChangeEventException e) {
// Errors that result from invalid change events.
outputWithErrorTag(c, msg, e, SpannerTransactionWriter.PERMANENT_ERROR_TAG);
skippedEvents.inc();
} catch (ChangeEventConvertorException e) {
// Errors that result during Event conversions are not retryable.
outputWithErrorTag(c, msg, e, SpannerTransactionWriter.PERMANENT_ERROR_TAG);
conversionErrors.inc();
} catch (SpannerException se) {
/* Errors that happen when writing to Cloud Spanner are considered retryable.
* Since all event convertion errors are caught beforehand as permanent errors,
* any other errors encountered while writing to Cloud Spanner can be retried.
* Examples include:
* 1. Deadline exceeded errors from Cloud Spanner.
* 2. Failures due to foreign key/interleaved table constraints.
* 3. Any transient errors in Cloud Spanner.
*/
outputWithErrorTag(c, msg, se, SpannerTransactionWriter.RETRYABLE_ERROR_TAG);
retryableErrors.inc();
} catch (Exception e) {
// Any other errors are considered severe and not retryable.
outputWithErrorTag(c, msg, e, SpannerTransactionWriter.PERMANENT_ERROR_TAG);
failedEvents.inc();
}
}
use of com.google.cloud.teleport.v2.templates.datastream.ChangeEventSequence in project DataflowTemplates by GoogleCloudPlatform.
the class ShadowTableCreator method constructShadowTable.
/*
* Constructs a shadow table for a data table in the information schema.
* Note: Shadow tables for interleaved tables are not interleaved to
* their shadow parent table.
*/
Table constructShadowTable(Ddl informationSchema, String dataTableName) {
// Create a new shadow table with the given prefix.
Table.Builder shadowTableBuilder = Table.builder();
String shadowTableName = shadowTablePrefix + dataTableName;
shadowTableBuilder.name(shadowTableName);
// Add key columns from the data table to the shadow table builder.
Table dataTable = informationSchema.table(dataTableName);
Set<String> primaryKeyColNames = dataTable.primaryKeys().stream().map(k -> k.name()).collect(Collectors.toSet());
List<Column> primaryKeyCols = dataTable.columns().stream().filter(col -> primaryKeyColNames.contains(col.name())).collect(Collectors.toList());
for (Column col : primaryKeyCols) {
shadowTableBuilder.addColumn(col);
}
// Add primary key constraints.
for (IndexColumn keyColumn : dataTable.primaryKeys()) {
if (keyColumn.order() == IndexColumn.Order.ASC) {
shadowTableBuilder.primaryKey().asc(keyColumn.name()).end();
} else if (keyColumn.order() == IndexColumn.Order.DESC) {
shadowTableBuilder.primaryKey().desc(keyColumn.name()).end();
}
}
// Add extra column to track ChangeEventSequence information
addChangeEventSequenceColumns(shadowTableBuilder);
return shadowTableBuilder.build();
}
Aggregations