Dec 5, 2025, 10:32 AM|3.52 MB|6,044 records extrac...
# ask-ai
s
Dec 5, 2025, 10:32 AM|3.52 MB|6,044 records extracted|no records loaded|Job id: 6322|5h 17m 12s I have this s3 source that takes 5 hours yet loads no files. I think it's reloaded files it's already seen?
k
Based on the information in the knowledge sources, I can’t see anything that directly confirms why your specific S3 source job is re‑reading files or taking 5+ hours with “no records loaded.” I can only infer likely causes, so please treat the following as informed but not definitive. A few relevant points: 1. “Extracted > 0, loaded = 0” can be normal when attempts fail mid‑sync Airbyte’s connection timeline aggregates metrics across all attempts in a sync. If an attempt fails after extraction but before loading, you can see many “extracted records” but “no records loaded” for that attempt. The overall sync can still eventually succeed on a later attempt. [[Connection timeline](https://docs.airbyte.com/platform/cloud/managing-airbyte-cloud/review-connection-timeline#syncs-refreshes-and-clears)] In your case, that single attempt shows 6,044 extracted and 0 loaded, which is consistent with a failure or stall during/after extraction. 2. Retries and multiple attempts can inflate “extracted” counts When Airbyte retries a job, it may re‑read the same data from the source, so the “extracted records” metric can be higher than what is ultimately loaded. [[Connection timeline](https://docs.airbyte.com/platform/cloud/managing-airbyte-cloud/review-connection-timeline#syncs-refreshes-and-clears)] This can look like “reloading files it’s already seen,” even though the destination may not get duplicates if the earlier attempts never loaded. 3. There are known issues with large/long‑running S3‑related syncs stalling For S3‑based connectors, there is an open issue where large or long‑running syncs stall with no obvious error, and the job sits at a fixed resource usage with no progress. [[S3 data lake stall](https://github.com/airbytehq/airbyte/issues/56926)] Your 5h+ runtime with no loaded records is consistent with a stall or failure rather than normal incremental behavior. 4. Duplicates / re‑reads can also come from pagination or cursor issues When building HTTP/API connectors, misconfigured pagination can cause duplicate records (e.g., wrong cursor/offset logic). [[Pagination troubleshooting](https://docs.airbyte.com/platform/connector-development/connector-builder-ui/pagination#troubleshooting)] However, the provided docs don’t describe this specifically for the S3 source, so I can’t say for sure that’s what’s happening in your case. Given these constraints, I cannot definitively confirm that your S3 source is re‑reading the same files, but the symptoms (long runtime, extracted > 0, loaded = 0) are consistent with: - A job that stalls or fails after extraction (so nothing is written), and/or - Retries that re‑read the same source data. What you can check next (within what the docs support): 1. Open the job details and look at attempts - See if there are multiple attempts under that sync, and whether each attempt shows extracted records but 0 loaded. [[Connection timeline](https://docs.airbyte.com/platform/cloud/managing-airbyte-cloud/review-connection-timeline#syncs-refreshes-and-clears)] 2. Inspect the logs for that job id (6322) - Look for messages like “Source process exited with non‑zero exit code 1” or similar, which indicate the source failed after extraction. [[Iterable failure example](https://github.com/airbytehq/airbyte/issues/69114)] 3. Check for known S3 connector issues - If you’re using
destination-s3-data-lake
or similar, compare your behavior with the stalling issue described in the GitHub ticket. [[S3 data lake stall](https://github.com/airbytehq/airbyte/issues/56926)] If you can share (outside this chat) the connector versions and a snippet of the job 6322 logs around where it stops making progress, that would be the next step to confirm whether it’s a stall/failed attempt vs. genuine re‑reading of files.
s
@kapa.ai It seems to overload my ec2 instance when I do the s3 thing In a previous run I read warnings about multi line json being slow or something This also hasn't ran in a long while so I thnk it's trying to process to many files at once
k
A message from kapa.ai
You’re likely running into a combination of resource exhaustion on EC2 and connector‑level performance limits, but the knowledge sources don’t give a precise recipe for S3 + multiline JSON, so I can’t be fully certain about the root cause. From what is documented: ### 1. EC2 instance overload Running many syncs or a heavy sync at once can easily overload a small EC2 instance. Airbyte jobs are resource‑hungry, and even for basic testing the team recommends at least a
t2.medium
, with larger instances for production. [[EC2 sizing](https://discuss.airbyte.io/t/2334)] If your instance is smaller than that, or you’re running many concurrent syncs, it’s expected that the machine becomes unresponsive. What you can tune: On self‑managed deployments you can limit concurrency and job resources: - Limit concurrent syncs (so you don’t “process too many files at once”):
Copy code
yaml   worker:     maxSyncWorkers: 5        # or lower, depending on your instance     maxCheckWorkers: 5
(Helm v2 example.) [[Scaling Airbyte](https://docs.airbyte.com/platform/enterprise-setup/scaling-airbyte)] - Reduce per‑job CPU/memory so each sync is lighter:
Copy code
yaml   global:     jobs:       resources:         limits:           cpu: 250m           memory: 500m         requests:           cpu: 75m           memory: 150m
[[Scaling Airbyte](https://docs.airbyte.com/platform/enterprise-setup/scaling-airbyte)] This prevents Airbyte from scheduling too many heavy pods at once and overwhelming the EC2 host. ### 2. Many connections / jobs = a lot of overhead Even when each dataset is small, a large number of connections or jobs creates significant overhead and can exhaust CPU/RAM. [[Airbyte resources](https://discuss.airbyte.io/t/995)] If you have many S3 connections or a single connection that spawns many streams, keep
MAX_SYNC_WORKERS
conservative so you don’t run dozens of jobs in parallel. Increasing
MAX_SYNC_WORKERS
increases parallelism and can speed things up, but only if your instance has enough headroom. [[MAX_SYNC_WORKERS](https://discuss.airbyte.io/t/1547); [Scaling Airbyte](https://docs.airbyte.com/platform/enterprise-setup/scaling-airbyte)] ### 3. Multiline JSON and S3 performance The docs and forum posts confirm that S3 JSON handling has been a pain point: - Historically, the S3 source did not support JSON/JSONL at all and needed a dedicated JSON parser to be added. [[S3 JSON enhancement](https://discuss.airbyte.io/t/1561); [S3 JSONL format](https://discuss.airbyte.io/t/539)] - There are also open performance concerns around S3‑based syncs being slow or stalling for larger volumes. [[Slow S3 sync](https://discuss.airbyte.io/t/3631)] However, the provided sources don’t explicitly mention a “multiline JSON is slow” warning, nor do they document specific tuning options for multiline JSON in the S3 source. So I can’t confirm from docs exactly how multiline JSON impacts performance in your version. Given what you’re seeing (long idle runs, EC2 overload, many files): - It’s plausible that parsing multiline JSON is CPU‑heavy, and - If the connection hasn’t run in a long time and is full refresh or has a loose file‑matching pattern, it may indeed be trying to process a very large backlog of files. ### 4. Practical steps within documented knobs Within what’s covered in the docs, you can: 1. Reduce concurrency and job size - Lower
MAX_SYNC_WORKERS
/
MAX_CHECK_WORKERS
. [[Scaling Airbyte](https://docs.airbyte.com/platform/enterprise-setup/scaling-airbyte)] - Reduce
jobs.resources.limits
in
values.yaml
so each sync uses less CPU/memory. [[Scaling Airbyte](https://docs.airbyte.com/platform/enterprise-setup/scaling-airbyte)] 2. Scale up the EC2 instance - Use at least a
t2.medium
for testing; larger for production or heavy S3 jobs. [[EC2 sizing](https://discuss.airbyte.io/t/2334)] 3. Check job logs for stalls / retries - Long jobs with “records extracted” but “0 loaded” often indicate the job stalled or failed after extraction, then retried, re‑reading the same data. The docs don’t show S3‑specific logs, but this pattern is consistent with other connectors. [[Connection timeline](https://docs.airbyte.com/platform/cloud/managing-airbyte-cloud/review-connection-timeline#syncs-refreshes-and-clears)] Because the knowledge sources don’t include your exact S3 + multiline JSON configuration, I can’t say more precisely why it’s overloading your instance. If you can, review the job logs for that S3 sync and consider: - Reducing the number of files matched (narrow the S3 path/prefix), and - Running a test on a subset of files to see if the job completes without overwhelming EC2.
k
I am having the same issue where I have 200,000 objects on s3 and suddenly one day the job starts failing and post then it just extracts and then loads 0 objects. It's been 5 days the pipeline is stuck please help.