Hi, i have a long running meltano pull, +hours at ...
# troubleshooting
m
Hi, i have a long running meltano pull, +hours at this point. it has a replication key and i can see that it's updating the key. i keep seeing this
Copy code
Target sink for 'public-events' is full.
and this:
Copy code
Number of results in first chunk: 1"
i'm concerned that this is ingesting 1 entry for like 1M possibly entries and is the source of the long pull? any ideas. thanks
e
What tap is this? It may one with a parent-child relationship in which each parent stream record has 1 or 0 child records. A schema message is emitted for each to the target flushes the records. If it's done too frequently it can be a bottleneck. Can you confirm? • https://github.com/meltano/sdk/issues/1061
m
postgres tap; snowflake target
e
Both MeltanoLabs?
m
yes
e
Ok I think
Number of results in first chunk: 1"
is probably not relevant, it's coming from
snowflake.connector.cursor
?
m
yes
so any ideas what's happening?
e
Can you try increasing the batch size with the
batch_size_rows
setting?