search

PeerDB-io / peerdb

Fast, Simple and a cost effective tool to replicate data from Postgres to Data Warehouses, Queues and Storage
https://peerdb.io
Other
2.19k stars 90 forks source link

DROP MIRROR doesn't end if the MIRROR is stuck in setup flow #119

Closed saisrirampur closed 3 months ago

saisrirampur commented 1 year ago

For example if the MIRROR is stuck in creating the slot/publication and I want to DROP THAT MIRROR. It doesn't finish with the below error in the dropflow:

{
  "message": "failed to cleanup source: error dropping publication: ERROR: publication \"peerflow_pub_test10\" does not exist (SQLSTATE 42704)",
  "source": "GoSDK",
  "stackTrace": "",
  "encodedAttributes": null,
  "cause": {
    "message": "error dropping publication: ERROR: publication \"peerflow_pub_test10\" does not exist (SQLSTATE 42704)",
    "source": "GoSDK",
    "stackTrace": "",
    "encodedAttributes": null,
    "cause": {
      "message": "ERROR: publication \"peerflow_pub_test10\" does not exist (SQLSTATE 42704)",
      "source": "GoSDK",
      "stackTrace": "",
      "encodedAttributes": null,
      "cause": null,
      "applicationFailureInfo": {
        "type": "PgError",
        "nonRetryable": false,
        "details": null
      }
    },
    "applicationFailureInfo": {
      "type": "wrapError",
      "nonRetryable": false,
      "details": null
    }
  },
  "applicationFailureInfo": {
    "type": "wrapError",
    "nonRetryable": false,
    "details": null
  }
}
heavycrystal commented 1 year ago

After support for initial load, DROP MIRROR will not work if a mirror is stuck in SnapshotFlow as well.