kafka-sink-after-ssh-restart.td 975 B

12345678910111213141516171819202122232425
  1. # Copyright Materialize, Inc. and contributors. All rights reserved.
  2. #
  3. # Use of this software is governed by the Business Source License
  4. # included in the LICENSE file at the root of this repository.
  5. #
  6. # As of the Change Date specified in that file, in accordance with
  7. # the Business Source License, use of this software will be governed
  8. # by the Apache License, Version 2.0.
  9. # Ensure that the sinks become healthy again.
  10. # ensure they all were marked as running correctly
  11. > SELECT status FROM mz_internal.mz_sink_statuses st
  12. JOIN mz_sinks s ON st.id = s.id
  13. WHERE s.name in ('sink_fixed', 'sink_dynamic')
  14. running
  15. running
  16. # Ensure we can maintain statistics after teh sink restarts
  17. > SELECT s.name, SUM(u.messages_staged), SUM(u.messages_committed), SUM(u.bytes_staged) > 0, SUM(bytes_staged) = SUM(bytes_committed)
  18. FROM mz_sinks s
  19. JOIN mz_internal.mz_sink_statistics_raw u ON s.id = u.id
  20. WHERE s.name IN ('sink_fixed')
  21. GROUP BY s.name
  22. sink_fixed 2 2 true true