Hi bros, I am new comer with Meltano and trying to...
# troubleshooting
n
Hi bros, I am new comer with Meltano and trying to run a 1st test pipeline from tap-postgres to target-postgres. When running
meltano run tap-postgres target-postgres
(locally), I am getting the following error
Copy code
[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 🙏
âś… 1
Try the idea install with
uv
here but the same issue, any solutions ?
e
I don't think this is an installation issue, so using
uv
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 here
n
Totally agree with you that is not an installation issue by using
pip
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)
👍 1