All H2 tests pass, but there are 6 production bugs — MySQL, Redis, and Kafka integration tests with Testcontainers

Six bugs that pass H2 and mock tests but break only on production MySQL, Redis, and Kafka—reproduced and fixed one by one with Testcontainers integration tests. Plus container singletons and reuse, CI, and flaky test diagnosis.