Error in Recreating CDCsync with PostgreSQL

[miyamoto]

I am performing CDCsync with PostgreSQL.

When starting the build with the “start” command shown above, an error occurs. This error did not occur previously when I was performing CDCsync using a similar method. However, it appeared after I deleted the sync and recreated it.

Could you help identify the cause of this issue and provide a solution?

[michaelt]

Hi @miyamoto ,

I would advise you to reach out to Support on this question, via your usual method. It may be hard to solve on the Community.

Thanks.

[sandpiper]

@miyamoto

When starting the build with the “start” command shown above, an error occurs. This error did not occur previously when I was performing CDCsync using a similar method. However, it appeared after I deleted the sync and recreated it.

With CDC syncs, I believe that all of the syncs created for a single source will get “bundled” together into a single multi-output job. This means that if you delete one of the sync output datasets (without deleting the sync itself with the “Delete” button on the source configuration page), it is expected (though perhaps non-intuitive) behavior that you will not be able to re-start the CDC stream job for the source, because a subset of the output datasets are in the trash. It sounds from your description that this may be what happened in your case.

However, if you in fact deleted the sync itself (rather than just the output dataset) but are still getting this error when trying to re-start the job, that is not expected behavior, so you should ask your Palantir support representative to help investigate what may be going on in your environment.