[2026-05-13T06:32:01.596323] Job 157288 queued by schedule:2026-05-13T06: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-13T06:32:01.691273] Queued via Procrastinate as job 156139 (queue=kpiper, priority=50).
[2026-05-13T06:39:53.279803] Starting job 157288 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-13T06:39:53.262537.
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":"AmNHrrBkNIh8S9ko2fAWrt5"}}
------------------- Extract instagram_graph_rest_api_source --------------------
Resources: 0/6 (0.0%) | Time: 0.75s | Rate: 0.00/s
account_objects: 1  | Time: 0.00s | Rate: 93206.76/s

------------------- Extract instagram_graph_rest_api_source --------------------
Resources: 0/6 (0.0%) | Time: 0.75s | Rate: 0.00/s
account_objects: 1  | Time: 0.00s | Rate: 241.16/s
media_objects: 1  | Time: 0.00s | Rate: 110376.42/s

------------------- Extract instagram_graph_rest_api_source --------------------
Resources: 1/6 (16.7%) | Time: 0.76s | Rate: 1.32/s
account_objects: 1  | Time: 0.01s | Rate: 104.65/s
media_objects: 1  | Time: 0.01s | Rate: 184.58/s
story_objects: 1  | Time: 0.00s | Rate: 80659.69/s

------------------- Extract instagram_graph_rest_api_source --------------------
Resources: 1/6 (16.7%) | Time: 0.76s | Rate: 1.31/s
account_objects: 1  | Time: 0.02s | Rate: 66.00/s
media_objects: 1  | Time: 0.01s | Rate: 90.79/s
story_objects: 1  | Time: 0.01s | Rate: 178.28/s
content_assets: 1  | Time: 0.00s | Rate: 102300.10/s

------------------- Extract instagram_graph_rest_api_source --------------------
Resources: 1/6 (16.7%) | Time: 9.04s | Rate: 0.11/s
account_objects: 1  | Time: 8.29s | Rate: 0.12/s
media_objects: 1  | Time: 8.28s | Rate: 0.12/s
story_objects: 1  | Time: 8.28s | Rate: 0.12/s
content_assets: 1  | Time: 8.27s | Rate: 0.12/s
story_insight_values: 1  | Time: 0.00s | Rate: 91180.52/s

------------------- Extract instagram_graph_rest_api_source --------------------
Resources: 2/6 (33.3%) | Time: 9.04s | Rate: 0.22/s
account_objects: 1  | Time: 8.29s | Rate: 0.12/s
media_objects: 3  | Time: 8.29s | Rate: 0.36/s
story_objects: 3  | Time: 8.29s | Rate: 0.36/s
content_assets: 3  | Time: 8.28s | Rate: 0.36/s
story_insight_values: 2  | Time: 0.01s | Rate: 333.58/s
insight_fetch_skips: 1  | Time: 0.00s | Rate: 85598.04/s

------------------- Extract instagram_graph_rest_api_source --------------------
Resources: 3/6 (50.0%) | Time: 16.62s | Rate: 0.18/s
account_objects: 1  | Time: 15.88s | Rate: 0.06/s
media_objects: 3  | Time: 15.87s | Rate: 0.19/s
story_objects: 7  | Time: 15.87s | Rate: 0.44/s
content_assets: 7  | Time: 15.86s | Rate: 0.44/s
story_insight_values: 2  | Time: 7.59s | Rate: 0.26/s
insight_fetch_skips: 5  | Time: 7.58s | Rate: 0.66/s

------------------- Extract instagram_graph_rest_api_source --------------------
Resources: 4/6 (66.7%) | Time: 24.90s | Rate: 0.16/s
account_objects: 1  | Time: 24.15s | Rate: 0.04/s
media_objects: 3  | Time: 24.14s | Rate: 0.12/s
story_objects: 11  | Time: 24.14s | Rate: 0.46/s
content_assets: 13  | Time: 24.13s | Rate: 0.54/s
story_insight_values: 2  | Time: 15.86s | Rate: 0.13/s
insight_fetch_skips: 11  | Time: 15.85s | Rate: 0.69/s

------------------- Extract instagram_graph_rest_api_source --------------------
Resources: 4/6 (66.7%) | Time: 34.38s | Rate: 0.12/s
account_objects: 1  | Time: 33.64s | Rate: 0.03/s
media_objects: 3  | Time: 33.63s | Rate: 0.09/s
story_objects: 11  | Time: 33.63s | Rate: 0.33/s
content_assets: 19  | Time: 33.62s | Rate: 0.57/s
story_insight_values: 2  | Time: 25.35s | Rate: 0.08/s
insight_fetch_skips: 17  | Time: 25.34s | Rate: 0.67/s

------------------- Extract instagram_graph_rest_api_source --------------------
Resources: 4/6 (66.7%) | Time: 40.98s | Rate: 0.10/s
account_objects: 1  | Time: 40.23s | Rate: 0.02/s
media_objects: 3  | Time: 40.23s | Rate: 0.07/s
story_objects: 11  | Time: 40.22s | Rate: 0.27/s
content_assets: 25  | Time: 40.22s | Rate: 0.62/s
story_insight_values: 2  | Time: 31.94s | Rate: 0.06/s
insight_fetch_skips: 23  | Time: 31.94s | Rate: 0.72/s

------------------- Extract instagram_graph_rest_api_source --------------------
Resources: 5/6 (83.3%) | Time: 49.07s | Rate: 0.10/s
account_objects: 1  | Time: 48.32s | Rate: 0.02/s
media_objects: 3  | Time: 48.32s | Rate: 0.06/s
story_objects: 11  | Time: 48.31s | Rate: 0.23/s
content_assets: 26  | Time: 48.31s | Rate: 0.54/s
story_insight_values: 2  | Time: 40.04s | Rate: 0.05/s
insight_fetch_skips: 29  | Time: 40.03s | Rate: 0.72/s

------------------- Extract instagram_graph_rest_api_source --------------------
Resources: 5/6 (83.3%) | Time: 58.54s | Rate: 0.09/s
account_objects: 1  | Time: 57.79s | Rate: 0.02/s
media_objects: 3  | Time: 57.79s | Rate: 0.05/s
story_objects: 11  | Time: 57.78s | Rate: 0.19/s
content_assets: 26  | Time: 57.78s | Rate: 0.45/s
story_insight_values: 2  | Time: 49.51s | Rate: 0.04/s
insight_fetch_skips: 35  | Time: 49.50s | Rate: 0.71/s

------------------- Extract instagram_graph_rest_api_source --------------------
Resources: 5/6 (83.3%) | Time: 67.49s | Rate: 0.07/s
account_objects: 1  | Time: 66.75s | Rate: 0.01/s
media_objects: 3  | Time: 66.74s | Rate: 0.04/s
story_objects: 11  | Time: 66.74s | Rate: 0.16/s
content_assets: 26  | Time: 66.73s | Rate: 0.39/s
story_insight_values: 2  | Time: 58.46s | Rate: 0.03/s
insight_fetch_skips: 41  | Time: 58.45s | Rate: 0.70/s

------------------- Extract instagram_graph_rest_api_source --------------------
Resources: 5/6 (83.3%) | Time: 76.30s | Rate: 0.07/s
account_objects: 1  | Time: 75.56s | Rate: 0.01/s
media_objects: 3  | Time: 75.55s | Rate: 0.04/s
story_objects: 11  | Time: 75.55s | Rate: 0.15/s
content_assets: 26  | Time: 75.54s | Rate: 0.34/s
story_insight_values: 2  | Time: 67.27s | Rate: 0.03/s
insight_fetch_skips: 47  | Time: 67.26s | Rate: 0.70/s

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

------------------- Extract instagram_graph_rest_api_source --------------------
Resources: 5/6 (83.3%) | Time: 91.63s | Rate: 0.05/s
account_objects: 1  | Time: 90.88s | Rate: 0.01/s
media_objects: 3  | Time: 90.88s | Rate: 0.03/s
story_objects: 11  | Time: 90.87s | Rate: 0.12/s
content_assets: 26  | Time: 90.87s | Rate: 0.29/s
story_insight_values: 2  | Time: 82.59s | Rate: 0.02/s
insight_fetch_skips: 59  | Time: 82.59s | Rate: 0.71/s

------------------- Extract instagram_graph_rest_api_source --------------------
Resources: 6/6 (100.0%) | Time: 91.66s | Rate: 0.07/s
account_objects: 1  | Time: 90.91s | Rate: 0.01/s
media_objects: 3  | Time: 90.91s | Rate: 0.03/s
story_objects: 11  | Time: 90.90s | Rate: 0.12/s
content_assets: 26  | Time: 90.89s | Rate: 0.29/s
story_insight_values: 2  | Time: 82.62s | Rate: 0.02/s
insight_fetch_skips: 64  | Time: 82.61s | Rate: 0.77/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: 155344.59/s

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

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

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

-------- Normalize instagram_graph_rest_api_source in 1778654399.757705 --------
Files: 1/7 (14.3%) | Time: 0.05s | Rate: 22.00/s
account_objects: 1  | Time: 0.01s | Rate: 199.88/s
media_objects: 0  | Time: 0.00s | Rate: 0.00/s

-------- Normalize instagram_graph_rest_api_source in 1778654399.757705 --------
Files: 2/7 (28.6%) | Time: 0.05s | Rate: 40.27/s
account_objects: 1  | Time: 0.01s | Rate: 108.55/s
media_objects: 3  | Time: 0.00s | Rate: 711.62/s
story_objects: 0  | Time: 0.00s | Rate: 0.00/s

-------- Normalize instagram_graph_rest_api_source in 1778654399.757705 --------
Files: 3/7 (42.9%) | Time: 0.06s | Rate: 52.74/s
account_objects: 1  | Time: 0.02s | Rate: 60.83/s
media_objects: 3  | Time: 0.01s | Rate: 262.17/s
story_objects: 11  | Time: 0.01s | Rate: 1520.53/s
content_assets: 0  | Time: 0.00s | Rate: 0.00/s

-------- Normalize instagram_graph_rest_api_source in 1778654399.757705 --------
Files: 4/7 (57.1%) | Time: 0.06s | Rate: 62.55/s
account_objects: 1  | Time: 0.02s | Rate: 42.55/s
media_objects: 3  | Time: 0.02s | Rate: 162.11/s
story_objects: 11  | Time: 0.01s | Rate: 769.38/s
content_assets: 26  | Time: 0.01s | Rate: 3677.11/s
story_insight_values: 0  | Time: 0.00s | Rate: 0.00/s

-------- Normalize instagram_graph_rest_api_source in 1778654399.757705 --------
Files: 5/7 (71.4%) | Time: 0.07s | Rate: 73.57/s
account_objects: 1  | Time: 0.03s | Rate: 36.35/s
media_objects: 3  | Time: 0.02s | Rate: 133.23/s
story_objects: 11  | Time: 0.02s | Rate: 600.83/s
content_assets: 26  | Time: 0.01s | Rate: 2346.26/s
story_insight_values: 2  | Time: 0.00s | Rate: 497.69/s
insight_fetch_skips: 0  | Time: 0.00s | Rate: 0.00/s

-------- Normalize instagram_graph_rest_api_source in 1778654399.757705 --------
Files: 6/7 (85.7%) | Time: 0.08s | Rate: 76.50/s
account_objects: 1  | Time: 0.04s | Rate: 26.33/s
media_objects: 3  | Time: 0.03s | Rate: 90.94/s
story_objects: 11  | Time: 0.03s | Rate: 382.20/s
content_assets: 26  | Time: 0.02s | Rate: 1206.26/s
story_insight_values: 2  | Time: 0.01s | Rate: 138.01/s
insight_fetch_skips: 64  | Time: 0.01s | Rate: 6107.33/s
_dlt_pipeline_state: 0  | Time: 0.00s | Rate: 0.00/s

-------- Normalize instagram_graph_rest_api_source in 1778654399.757705 --------
Files: 7/7 (100.0%) | Time: 0.09s | Rate: 74.59/s
account_objects: 1  | Time: 0.05s | Rate: 18.73/s
media_objects: 3  | Time: 0.05s | Rate: 61.98/s
story_objects: 11  | Time: 0.04s | Rate: 248.89/s
content_assets: 26  | Time: 0.04s | Rate: 703.26/s
story_insight_values: 2  | Time: 0.03s | Rate: 66.87/s
insight_fetch_skips: 64  | Time: 0.03s | Rate: 2471.46/s
_dlt_pipeline_state: 1  | Time: 0.02s | Rate: 64.84/s

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

---------- Load instagram_graph_rest_api_source in 1778654399.757705 -----------
Jobs: 12/12 (100.0%) | Time: 0.55s | Rate: 21.79/s

Pipeline instagram_graph_pipeline load step completed in 0.55 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 1778654399.757705 is LOADED and contains no failed jobs
[2026-05-13T06:41:32.839981] Command completed successfully.
[2026-05-13T06:41:32.840317] Pipeline status payload: {"backfill_complete": true, "backfill_progress_mode": "incremental", "ig_user_id": "17841400043394895", "sync_mode": "incremental"}