in dbeam-core/src/main/java/com/spotify/dbeam/jobs/PsqlReplicationCheck.java [106:123]
static Instant queryReplication(final Connection connection, final String query)
throws SQLException {
final ResultSet resultSet = connection.createStatement().executeQuery(query);
Preconditions.checkState(
resultSet.next(),
"Replication query returned empty results, consider using jdbc-avro-job instead");
Instant lastReplication =
Preconditions.checkNotNull(
resultSet.getTimestamp("last_replication"),
"Empty last_replication, consider using jdbc-avro-job instead")
.toInstant();
Duration replicationDelay = Duration.ofSeconds(resultSet.getLong("replication_delay"));
LOGGER.info(
"Psql replication check lastReplication={} replicationDelay={}",
lastReplication,
replicationDelay);
return lastReplication;
}