[2026-05-12T18:32:01.595680] Job 156465 queued by schedule:2026-05-12T18:32:00
Connection: pietrocoricelli (instagram)
Sync template: Instagram Graph - Incremental Sync
Queue class: foreground
Procrastinate queue: kpiper
Command: python instagram_graph_pipeline.py
[2026-05-12T18:32:01.726731] Queued via Procrastinate as job 155316 (queue=kpiper, priority=50).
[2026-05-12T18:32:02.764513] Starting job 156465 for connection pietrocoricelli (instagram) / sync template Instagram Graph - Incremental Sync (type=dlt)
Resolved command: cd /srv/kpiper && python instagram_graph_pipeline.py
Injected profile context env vars (tokens exported: 1).
Pipeline env overrides applied: DOWNLOAD_ASSETS, ENABLE_ACCOUNT_OBJECTS, ENABLE_ASSETS, ENABLE_COMMENTS, ENABLE_CONTENT_PUBLISHING_LIMITS, ENABLE_MEDIA_CHILD_OBJECTS, ENABLE_MEDIA_INSIGHTS, ENABLE_MEDIA_OBJECTS, ENABLE_STORY_INSIGHTS, ENABLE_STORY_OBJECTS, ENABLE_USER_INSIGHTS, ENABLE_WEBHOOK_SUBSCRIBED_APPS, IG_PAGE_ID, IG_USER_ID, MEDIA_INCREMENTAL_LOOKBACK_DAYS, MEDIA_PAGINATION, SOURCES__INSTAGRAM_GRAPH_REST_API_SOURCE__ACCESS_TOKEN, SYNC_MODE
Refreshed Meta Page Token at 2026-05-12T18:32:02.742628.
Forced unbuffered Python output for child process.
/usr/local/lib/python3.11/site-packages/dlt/pipeline/progress.py:27: UserWarning: psutil dependency is not installed and memory stats will not be available. Add psutil to your environment or pass dump_system_stats=False to disable this warning.
  return log()
------------------- Extract instagram_graph_rest_api_source --------------------
Resources: 0/6 (0.0%) | Time: 0.00s | Rate: 0.00/s

Retrying 17841400043394895 with a narrower field set after Graph error: {"error":{"message":"(#100) Tried accessing nonexisting field (account_type)","type":"OAuthException","code":100,"fbtrace_id":"AxIY2VL_U2NJ0Tyblch7c75"}}
------------------- Extract instagram_graph_rest_api_source --------------------
Resources: 0/6 (0.0%) | Time: 2.19s | Rate: 0.00/s
account_objects: 1  | Time: 0.00s | Rate: 85598.04/s

------------------- Extract instagram_graph_rest_api_source --------------------
Resources: 0/6 (0.0%) | Time: 2.20s | Rate: 0.00/s
account_objects: 1  | Time: 0.01s | Rate: 194.81/s
media_objects: 1  | Time: 0.00s | Rate: 104857.60/s

------------------- Extract instagram_graph_rest_api_source --------------------
Resources: 1/6 (16.7%) | Time: 2.20s | Rate: 0.45/s
account_objects: 1  | Time: 0.01s | Rate: 94.47/s
media_objects: 1  | Time: 0.01s | Rate: 183.10/s
story_objects: 1  | Time: 0.00s | Rate: 107546.26/s

------------------- Extract instagram_graph_rest_api_source --------------------
Resources: 1/6 (16.7%) | Time: 2.21s | Rate: 0.45/s
account_objects: 1  | Time: 0.02s | Rate: 64.13/s
media_objects: 1  | Time: 0.01s | Rate: 95.51/s
story_objects: 1  | Time: 0.01s | Rate: 199.26/s
content_assets: 1  | Time: 0.00s | Rate: 113359.57/s

------------------- Extract instagram_graph_rest_api_source --------------------
Resources: 1/6 (16.7%) | Time: 10.51s | Rate: 0.10/s
account_objects: 1  | Time: 8.32s | Rate: 0.12/s
media_objects: 1  | Time: 8.32s | Rate: 0.12/s
story_objects: 1  | Time: 8.31s | Rate: 0.12/s
content_assets: 1  | Time: 8.31s | Rate: 0.12/s
story_insight_values: 1  | Time: 0.00s | Rate: 87381.33/s

------------------- Extract instagram_graph_rest_api_source --------------------
Resources: 2/6 (33.3%) | Time: 10.52s | Rate: 0.19/s
account_objects: 1  | Time: 8.33s | Rate: 0.12/s
media_objects: 3  | Time: 8.32s | Rate: 0.36/s
story_objects: 3  | Time: 8.32s | Rate: 0.36/s
content_assets: 3  | Time: 8.31s | Rate: 0.36/s
story_insight_values: 2  | Time: 0.01s | Rate: 300.23/s
insight_fetch_skips: 1  | Time: 0.00s | Rate: 102300.10/s

------------------- Extract instagram_graph_rest_api_source --------------------
Resources: 3/6 (50.0%) | Time: 19.11s | Rate: 0.16/s
account_objects: 1  | Time: 16.92s | Rate: 0.06/s
media_objects: 3  | Time: 16.91s | Rate: 0.18/s
story_objects: 7  | Time: 16.91s | Rate: 0.41/s
content_assets: 7  | Time: 16.90s | Rate: 0.41/s
story_insight_values: 2  | Time: 8.60s | Rate: 0.23/s
insight_fetch_skips: 5  | Time: 8.59s | Rate: 0.58/s

------------------- Extract instagram_graph_rest_api_source --------------------
Resources: 4/6 (66.7%) | Time: 27.80s | Rate: 0.14/s
account_objects: 1  | Time: 25.60s | Rate: 0.04/s
media_objects: 3  | Time: 25.60s | Rate: 0.12/s
story_objects: 11  | Time: 25.59s | Rate: 0.43/s
content_assets: 13  | Time: 25.59s | Rate: 0.51/s
story_insight_values: 2  | Time: 17.28s | Rate: 0.12/s
insight_fetch_skips: 11  | Time: 17.28s | Rate: 0.64/s

------------------- Extract instagram_graph_rest_api_source --------------------
Resources: 4/6 (66.7%) | Time: 37.98s | Rate: 0.11/s
account_objects: 1  | Time: 35.78s | Rate: 0.03/s
media_objects: 3  | Time: 35.78s | Rate: 0.08/s
story_objects: 11  | Time: 35.77s | Rate: 0.31/s
content_assets: 19  | Time: 35.77s | Rate: 0.53/s
story_insight_values: 2  | Time: 27.46s | Rate: 0.07/s
insight_fetch_skips: 17  | Time: 27.46s | Rate: 0.62/s

------------------- Extract instagram_graph_rest_api_source --------------------
Resources: 4/6 (66.7%) | Time: 46.12s | Rate: 0.09/s
account_objects: 1  | Time: 43.93s | Rate: 0.02/s
media_objects: 3  | Time: 43.92s | Rate: 0.07/s
story_objects: 11  | Time: 43.92s | Rate: 0.25/s
content_assets: 25  | Time: 43.91s | Rate: 0.57/s
story_insight_values: 2  | Time: 35.61s | Rate: 0.06/s
insight_fetch_skips: 23  | Time: 35.60s | Rate: 0.65/s

------------------- Extract instagram_graph_rest_api_source --------------------
Resources: 5/6 (83.3%) | Time: 54.05s | Rate: 0.09/s
account_objects: 1  | Time: 51.86s | Rate: 0.02/s
media_objects: 3  | Time: 51.86s | Rate: 0.06/s
story_objects: 11  | Time: 51.85s | Rate: 0.21/s
content_assets: 26  | Time: 51.85s | Rate: 0.50/s
story_insight_values: 2  | Time: 43.54s | Rate: 0.05/s
insight_fetch_skips: 29  | Time: 43.53s | Rate: 0.67/s

------------------- Extract instagram_graph_rest_api_source --------------------
Resources: 5/6 (83.3%) | Time: 61.04s | Rate: 0.08/s
account_objects: 1  | Time: 58.85s | Rate: 0.02/s
media_objects: 3  | Time: 58.85s | Rate: 0.05/s
story_objects: 11  | Time: 58.84s | Rate: 0.19/s
content_assets: 26  | Time: 58.84s | Rate: 0.44/s
story_insight_values: 2  | Time: 50.53s | Rate: 0.04/s
insight_fetch_skips: 35  | Time: 50.52s | Rate: 0.69/s

------------------- Extract instagram_graph_rest_api_source --------------------
Resources: 5/6 (83.3%) | Time: 69.11s | Rate: 0.07/s
account_objects: 1  | Time: 66.91s | Rate: 0.01/s
media_objects: 3  | Time: 66.91s | Rate: 0.04/s
story_objects: 11  | Time: 66.90s | Rate: 0.16/s
content_assets: 26  | Time: 66.90s | Rate: 0.39/s
story_insight_values: 2  | Time: 58.59s | Rate: 0.03/s
insight_fetch_skips: 41  | Time: 58.59s | Rate: 0.70/s

------------------- Extract instagram_graph_rest_api_source --------------------
Resources: 5/6 (83.3%) | Time: 77.69s | Rate: 0.06/s
account_objects: 1  | Time: 75.49s | Rate: 0.01/s
media_objects: 3  | Time: 75.49s | Rate: 0.04/s
story_objects: 11  | Time: 75.48s | Rate: 0.15/s
content_assets: 26  | Time: 75.48s | Rate: 0.34/s
story_insight_values: 2  | Time: 67.17s | Rate: 0.03/s
insight_fetch_skips: 47  | Time: 67.17s | Rate: 0.70/s

------------------- Extract instagram_graph_rest_api_source --------------------
Resources: 5/6 (83.3%) | Time: 86.43s | Rate: 0.06/s
account_objects: 1  | Time: 84.24s | Rate: 0.01/s
media_objects: 3  | Time: 84.23s | Rate: 0.04/s
story_objects: 11  | Time: 84.23s | Rate: 0.13/s
content_assets: 26  | Time: 84.22s | Rate: 0.31/s
story_insight_values: 2  | Time: 75.92s | Rate: 0.03/s
insight_fetch_skips: 53  | Time: 75.91s | Rate: 0.70/s

------------------- Extract instagram_graph_rest_api_source --------------------
Resources: 5/6 (83.3%) | Time: 93.03s | Rate: 0.05/s
account_objects: 1  | Time: 90.84s | Rate: 0.01/s
media_objects: 3  | Time: 90.84s | Rate: 0.03/s
story_objects: 11  | Time: 90.83s | Rate: 0.12/s
content_assets: 26  | Time: 90.83s | Rate: 0.29/s
story_insight_values: 2  | Time: 82.52s | Rate: 0.02/s
insight_fetch_skips: 59  | Time: 82.51s | Rate: 0.72/s

------------------- Extract instagram_graph_rest_api_source --------------------
Resources: 6/6 (100.0%) | Time: 93.06s | Rate: 0.06/s
account_objects: 1  | Time: 90.87s | Rate: 0.01/s
media_objects: 3  | Time: 90.87s | Rate: 0.03/s
story_objects: 11  | Time: 90.86s | Rate: 0.12/s
content_assets: 26  | Time: 90.86s | Rate: 0.29/s
story_insight_values: 2  | Time: 82.55s | Rate: 0.02/s
insight_fetch_skips: 64  | Time: 82.54s | Rate: 0.78/s

------------------- Extract instagram_graph_rest_api_source --------------------
Resources: 0/1 (0.0%) | Time: 0.00s | Rate: 0.00/s

------------------- Extract instagram_graph_rest_api_source --------------------
Resources: 0/1 (0.0%) | Time: 0.00s | Rate: 0.00/s
_dlt_pipeline_state: 1  | Time: 0.00s | Rate: 139810.13/s

------------------- Extract instagram_graph_rest_api_source --------------------
Resources: 1/1 (100.0%) | Time: 0.02s | Rate: 54.34/s
_dlt_pipeline_state: 1  | Time: 0.01s | Rate: 71.25/s

-------- Normalize instagram_graph_rest_api_source in 1778610729.016633 --------
Files: 0/7 (0.0%) | Time: 0.00s | Rate: 0.00/s

-------- Normalize instagram_graph_rest_api_source in 1778610729.016633 --------
Files: 0/7 (0.0%) | Time: 0.02s | Rate: 0.00/s
account_objects: 0  | Time: 0.00s | Rate: 0.00/s

-------- Normalize instagram_graph_rest_api_source in 1778610729.016633 --------
Files: 1/7 (14.3%) | Time: 0.02s | Rate: 40.47/s
account_objects: 1  | Time: 0.01s | Rate: 184.02/s
media_objects: 0  | Time: 0.00s | Rate: 0.00/s

-------- Normalize instagram_graph_rest_api_source in 1778610729.016633 --------
Files: 2/7 (28.6%) | Time: 0.03s | Rate: 68.82/s
account_objects: 1  | Time: 0.01s | Rate: 102.19/s
media_objects: 3  | Time: 0.00s | Rate: 688.46/s
story_objects: 0  | Time: 0.00s | Rate: 0.00/s

-------- Normalize instagram_graph_rest_api_source in 1778610729.016633 --------
Files: 3/7 (42.9%) | Time: 0.03s | Rate: 88.29/s
account_objects: 1  | Time: 0.01s | Rate: 68.00/s
media_objects: 3  | Time: 0.01s | Rate: 323.38/s
story_objects: 11  | Time: 0.00s | Rate: 2232.96/s
content_assets: 0  | Time: 0.00s | Rate: 0.00/s

-------- Normalize instagram_graph_rest_api_source in 1778610729.016633 --------
Files: 4/7 (57.1%) | Time: 0.07s | Rate: 54.74/s
account_objects: 1  | Time: 0.05s | Rate: 18.59/s
media_objects: 3  | Time: 0.05s | Rate: 62.02/s
story_objects: 11  | Time: 0.04s | Rate: 249.86/s
content_assets: 26  | Time: 0.04s | Rate: 664.85/s
story_insight_values: 0  | Time: 0.00s | Rate: 0.00/s

-------- Normalize instagram_graph_rest_api_source in 1778610729.016633 --------
Files: 5/7 (71.4%) | Time: 0.08s | Rate: 64.02/s
account_objects: 1  | Time: 0.06s | Rate: 17.00/s
media_objects: 3  | Time: 0.05s | Rate: 56.19/s
story_objects: 11  | Time: 0.05s | Rate: 224.29/s
content_assets: 26  | Time: 0.04s | Rate: 589.22/s
story_insight_values: 2  | Time: 0.01s | Rate: 397.83/s
insight_fetch_skips: 0  | Time: 0.00s | Rate: 0.00/s

-------- Normalize instagram_graph_rest_api_source in 1778610729.016633 --------
Files: 6/7 (85.7%) | Time: 0.09s | Rate: 66.26/s
account_objects: 1  | Time: 0.07s | Rate: 14.03/s
media_objects: 3  | Time: 0.07s | Rate: 45.55/s
story_objects: 11  | Time: 0.06s | Rate: 178.85/s
content_assets: 26  | Time: 0.06s | Rate: 459.48/s
story_insight_values: 2  | Time: 0.02s | Rate: 114.37/s
insight_fetch_skips: 64  | Time: 0.01s | Rate: 5133.59/s
_dlt_pipeline_state: 0  | Time: 0.00s | Rate: 0.00/s

-------- Normalize instagram_graph_rest_api_source in 1778610729.016633 --------
Files: 7/7 (100.0%) | Time: 0.11s | Rate: 65.98/s
account_objects: 1  | Time: 0.09s | Rate: 11.52/s
media_objects: 3  | Time: 0.08s | Rate: 36.86/s
story_objects: 11  | Time: 0.08s | Rate: 142.78/s
content_assets: 26  | Time: 0.07s | Rate: 360.48/s
story_insight_values: 2  | Time: 0.03s | Rate: 60.56/s
insight_fetch_skips: 64  | Time: 0.03s | Rate: 2285.22/s
_dlt_pipeline_state: 1  | Time: 0.02s | Rate: 64.32/s

---------- Load instagram_graph_rest_api_source in 1778610729.016633 -----------
Jobs: 0/7 (0.0%) | Time: 0.00s | Rate: 0.00/s

---------- Load instagram_graph_rest_api_source in 1778610729.016633 -----------
Jobs: 12/12 (100.0%) | Time: 0.51s | Rate: 23.38/s

Pipeline instagram_graph_pipeline load step completed in 0.51 seconds
1 load package(s) were loaded to destination postgres and into dataset instagram_graph
The postgres destination used postgresql://kpiper_dlt_app:***@[/cloudsql/pacelab-487114:europe-west4:pacelab-pg18-ew4]:5432/kpiper_data location to store data
Load package 1778610729.016633 is LOADED and contains no failed jobs
[2026-05-12T18:33:43.414324] Command completed successfully.
[2026-05-12T18:33:43.414538] Pipeline status payload: {"backfill_complete": true, "backfill_progress_mode": "incremental", "ig_user_id": "17841400043394895", "sync_mode": "incremental"}