Errors after upgrading aws source plugin to v24.1.0 from v22.19.2

CloudQuery Plugins
1

Since upgrading the AWS source plugin to “v24.1.0” from “v22.19.2”, I’m getting errors such as (see in thread):

Failed to drop NOT NULL constraint error="ERROR: column \"request_account_id\" of relation \"aws_directconnect_gateways\" does not exist (SQLSTATE 42703)" column=request_account_id module=pg-dest table=aws_directconnect_gateways
2024-02-08T20:18:24Z INF finished call grpc.code=Canceled grpc.component=server grpc.error="rpc error: code = Canceled desc = plugin returned error: ERROR: column \"request_account_id\" of relation \"aws_directconnect_gateways\" does not exist (SQLSTATE 42703)" grpc.method=Write grpc.method_type=client_stream grpc.service=cloudquery.plugin.v3.Plugin grpc.start_time=2024-02-08T20:18:15Z grpc.time_ms=9691.511 module=cli peer.address=@ protocol=grpc

Did I update too aggressively?

2

What version of Postgres are you using?

3

Plugin?
Version: v7.3.1
I may have to delete everything and resync.

4

You can use migrate_mode: forced

5

so I had that initially

6

And that would handle dropping and recreating.
Interesting…
Ok! I am able to replicate it…

7

Alright, I’ll be out for a bit. I asked this in here to not continue to DM you because I get that. I’ll try any suggestions when I get back or wait for a fix.
@ben everything is working now. Thank you for all the work you’ve done to get this working for us.
Also, I’ve talked to my team about setting up a meeting with your guys, so that will probably happen before we go fully GA with our service.