Nguyen Phuc Buu Gia
02/06/2025, 6:23 AMmeltano run tap-postgres target-postgres
(locally), I am getting the following error
[error ] Block run completed. block_type=ExtractLoadBlocks err=RunnerError('Loader failed') exit_codes={<PluginType.LOADERS: 'loaders'>: 1} set_number=0 success=False
Need help fixing this problem? Visit <http://melta.no/> for troubleshooting steps, or to
join our friendly Slack community.
Run invocation could not be completed as block failed: Loader failed
I just try another version of environment (python3.11 >> 3.10 >> 3.9) but the same issues, don’t know how go through yet. Pls support.
P/S: I am using: python3.10, meltano==3.6.0, dbt 1.9.1
Thank you 🙏Nguyen Phuc Buu Gia
02/06/2025, 6:41 AMuv
here but the same issue, any solutions ?Edgar RamĂrez (Arch.dev)
02/06/2025, 7:30 PMuv
probably won't help fixing it. Here's a quick loader debugging tip that I hope to formalize or document at one point:
1. meltano invoke tap-postgres > tap-postgres.singer.jsonl
2. cat tap-postgres.singer.jsonl | meltano invoke target-postgres
And share the results hereNguyen Phuc Buu Gia
02/07/2025, 4:24 AMpip
or uv
. After logs exploration and debugging, I had found the root cause came from ingestion schema. Go through by adding catalog config catalog: ./extract/tap-local-postgres.json
(in meltano.yml
file) which describes the schema of tap-postgres source that serve for downstream loader.
Thank you for your comment @Edgar RamĂrez (Arch.dev)