Dear Vignesh, > a) Finding 9: A running sequence synchronization worker continues > processing after ALTER SUBSCRIPTION ... DISABLE. In this case the > leader apply worker only terminated its parallel apply workers on > detach, so a running sequencesync worker could outlive a DISABLE. > logicalrep_worker_detach() now also stops the sequencesync worker.
Hmm, but tablesync workers, which can connect to the publisher by itself are not terminated by the function. IIUC, tablesync workers can read the subscription catalog and recognize the catalog. I feel we should follow that approach. Note: I cannot find the place sequencesync worker calls maybe_reread_subscription(). It might mean that the worker cannot recognize alternations of the subscription. Best regards, Hayato Kuroda FUJITSU LIMITED
