CloudQuery sync fails on one server but works on another with same config

CloudQuery Plugins
1

Hi folks!

I am encountering a weird behavior while running syncs. On one server running Docker, CloudQuery runs fine, whereas on another server for the same config and version, it fails. Can someone look into this anomaly?

Posting my config files here:

kind: source
spec:
  destinations: ["duckdb"]
  name: "postgresql"
  path: "cloudquery/postgresql"
  registry: "cloudquery"
  spec:
    connection_string: "<abcd>?sslmode=disable"
  tables: ["*"]
  version: "v3.0.7"
2

Hi @fun-griffon, can you share the error you’re getting when it fails?

3

Hi Erez, sure.

2023-11-24T14:02:39Z ERR exiting with error error="failed to start plugin .cq/plugins/source/cloudquery/postgresql/v3.0.7/plugin: fork/exec .cq/plugins/source/cloudquery/postgresql/v3.0.7/plugin: exec format error" module=cli
4

That usually means the plugin binary doesn’t match the architecture of the container, so I would verify the servers are using the same architecture.

5

Oh, I see. I was assuming it to be the case, but thanks for clarifying. Also, how did you interpret the error? It’s something I couldn’t understand just by reading it.

6

exec format error is the hint.

7

Understood, thanks again :slightly_smiling_face: