Interesting, when I downgrade from 0.40.7 to 0.40.6(dropped database & created a new one), workers could startup but servers failed with following issue:

2022-09-20 09:03:58 INFO i.a.s.ServerApp(migrateExistingConnectionsToTemporalScheduler):283 - Start migration to the new scheduler...
2022-09-20 09:03:58 ERROR i.a.s.ServerApp(main):320 - Server failed
io.grpc.StatusRuntimeException: INTERNAL: ListOpenWorkflowExecutions operation failed. Select failed: pq: relation "executions_visibility" does not exist
        at io.grpc.stub.ClientCalls.toStatusRuntimeException(ClientCalls.java:262) ~[grpc-stub-1.44.1.jar:1.44.1]
        at io.grpc.stub.ClientCalls.getUnchecked(ClientCalls.java:243) ~[grpc-stub-1.44.1.jar:1.44.1]
        at io.grpc.stub.ClientCalls.blockingUnaryCall(ClientCalls.java:156) ~[grpc-stub-1.44.1.jar:1.44.1]
        at io.temporal.api.workflowservice.v1.WorkflowServiceGrpc$WorkflowServiceBlockingStub.listOpenWorkflowExecutions(WorkflowServiceGrpc.java:2894) ~[temporal-serviceclient-1.8.1.jar:?]
        at io.airbyte.workers.temporal.TemporalClient.refreshRunningWorkflow(TemporalClient.java:223) ~[io.airbyte-airbyte-workers-0.40.6.jar:?]
        at io.airbyte.workers.temporal.TemporalClient.migrateSyncIfNeeded(TemporalClient.java:184) ~[io.airbyte-airbyte-workers-0.40.6.jar:?]
        at io.airbyte.scheduler.client.TemporalEventRunner.migrateSyncIfNeeded(TemporalEventRunner.java:52) ~[io.airbyte.airbyte-scheduler-client-0.40.6.jar:?]
        at io.airbyte.server.ServerApp.migrateExistingConnectionsToTemporalScheduler(ServerApp.java:288) ~[io.airbyte-airbyte-server-0.40.6.jar:?]
        at io.airbyte.server.ServerApp.getServer(ServerApp.java:248) ~[io.airbyte-airbyte-server-0.40.6.jar:?]
        at io.airbyte.server.ServerApp.main(ServerApp.java:317) [io.airbyte-airbyte-server-0.40.6.jar:?]

also same issue