Skip to content

Out of control data transfer for assets #14061

@tao

Description

@tao

Bug description

I'm not really sure what to call the title of the bug report because I'm still trying to figure it out. I'll try provide more details soon if I can figure more out but it's a very expensive thing to debug.

Somehow since upgrading to Statamic 6? The queue..? or something transferred 2,851.887 GB of data (2,8 Tb) that cost an extra $256 to our AWS bill. Additionally it did 12 million (PUT,COPY,POST or List) Requests which cost an additional $60.

Image

It took a while to figure out how to read the bucket usage from Amazon S3 but each day it's been charging $18 of usage to my assets.llresearch.dev bucket which is the one I use exclusively for our Statamic CMS assets on the test website.

Image

So I think something went wrong with the queue if it made 12 million requests? I shut down the queue this morning and now it's only charging me $3 today.

It seems like the Statamic\Jobs\HandleEntrySchedule job runs every minute, so I'm not sure if that could be related somehow and causing the 12 million requests?

There are also some jobs in the queue related to Search that reference assets on AWS, the Statamic\Search\InsertMultipleJob one... but I'm not sure if that would be pinging AWS and trying to find or create metadata?

In the example payload for that job you can see it's full of my assets like asset::aws::archive\/images\/101_cover.jpg or asset::aws::audio\/101\/lesson_1.mp3

 id = 190
 queue = default
 payload = {"uuid":"dba5ab36-2152-441d-982b-2e3e9d458e1x","displayName":"Statamic\\Search\\InsertMultipleJob","job":"Illuminate\\Queue\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"Statamic\\Search\\InsertMultipleJob","command":"O:33:\"Statamic\\Search\\InsertMultipleJob\":3:{s:4:\"name\";s:7:\"default\";s:6:\"locale\";N;s:9:\"documents\";O:31:\"Statamic\\Assets\\AssetCollection\":2:{s:8:\"\u0000*\u0000items\";a:100:{i:0;s:30:\"asset::assets::don-quixote.svg\";i:1;s:30:\"asset::assets::icons\/about.svg\";i:2;s:34:\"asset::assets::icons\/beginners.svg\";i:3;s:30:\"asset::assets::icons\/books.svg\";i:4;s:37:\"asset::assets::icons\/carlas-niche.svg\";i:5;s:35:\"asset::assets::icons\/channeling.svg\";i:6;s:34:\"asset::assets::icons\/community.svg\";i:7;s:32:\"asset::assets::icons\/courses.svg\";i:8;s:28:\"asset::assets::icons\/faq.svg\";i:9;s:29:\"asset::assets::icons\/home.svg\";i:10;s:33:\"asset::assets::icons\/lawofone.svg\";i:11;s:32:\"asset::assets::icons\/library.svg\";i:12;s:41:\"asset::assets::icons\/magnifying-glass.svg\";i:13;s:30:\"asset::assets::icons\/media.svg\";i:14;s:36:\"asset::assets::icons\/meditations.svg\";i:15;s:33:\"asset::assets::icons\/navigate.svg\";i:16;s:33:\"asset::assets::icons\/podcasts.svg\";i:17;s:31:\"asset::assets::icons\/search.svg\";i:18;s:32:\"asset::assets::icons\/sidebar.svg\";i:19;s:30:\"asset::assets::icons\/study.svg\";i:20;s:31:\"asset::assets::icons\/topics.svg\";i:21;s:32:\"asset::assets::icons\/updates.svg\";i:22;s:31:\"asset::assets::icons\/videos.svg\";i:23;s:34:\"asset::assets::icons\/wanderers.svg\";i:24;s:29:\"asset::assets::icons\/wiki.svg\";i:25;s:42:\"asset::assets::team-photo-with-unicorn.png\";i:26;s:20:\"asset::aws::404.html\";i:27;s:34:\"asset::aws::archive\/images\/101.jpg\";i:28;s:40:\"asset::aws::archive\/images\/101_cover.jpg\";i:29;s:62:\"asset::aws::archive\/images\/A_Wanderers_Handbook_1024_x_768.jpg\";i:30;s:62:\"asset::aws::archive\/images\/A_Wanderers_Handbook_1152_x_864.jpg\";i:31;s:63:\"asset::aws::archive\/images\/A_Wanderers_Handbook_1280_x_1024.jpg\";i:32;s:63:\"asset::aws::archive\/images\/A_Wanderers_Handbook_1600_x_1200.jpg\";i:33;s:61:\"asset::aws::archive\/images\/A_Wanderers_Handbook_800_x_600.jpg\";i:34;s:57:\"asset::aws::archive\/images\/A_Wanderers_Handbook_image.jpg\";i:35;s:35:\"asset::aws::archive\/images\/Vol1.jpg\";i:36;s:35:\"asset::aws::archive\/images\/Vol2.jpg\";i:37;s:56:\"asset::aws::archive\/images\/a_book_of_days_1024_x_768.jpg\";i:38;s:56:\"asset::aws::archive\/images\/a_book_of_days_1152_x_864.jpg\";i:39;s:57:\"asset::aws::archive\/images\/a_book_of_days_1600_x_1200.jpg\";i:40;s:55:\"asset::aws::archive\/images\/a_book_of_days_800_x_600.jpg\";i:41;s:51:\"asset::aws::archive\/images\/a_book_of_days_cover.jpg\";i:42;s:57:\"asset::aws::archive\/images\/a_book_of_days_cover_image.jpg\";i:43;s:57:\"asset::aws::archive\/images\/a_wanderers_handbook_cover.jpg\";i:44;s:35:\"asset::aws::archive\/images\/abod.jpg\";i:45;s:34:\"asset::aws::archive\/images\/ach.jpg\";i:46;s:39:\"asset::aws::archive\/images\/archives.jpg\";i:47;s:34:\"asset::aws::archive\/images\/awh.jpg\";i:48;s:35:\"asset::aws::archive\/images\/crux.jpg\";i:49;s:46:\"asset::aws::archive\/images\/dialogues_cover.jpg\";i:50;s:56:\"asset::aws::archive\/images\/law_of_one_book_one_cover.jpg\";i:51;s:41:\"asset::aws::archive\/images\/lightlines.jpg\";i:52;s:67:\"asset::aws::archive\/images\/living_the_law_of_one_101_1024_x_768.jpg\";i:53;s:68:\"asset::aws::archive\/images\/living_the_law_of_one_101_1600_x_1200.jpg\";i:54;s:66:\"asset::aws::archive\/images\/living_the_law_of_one_101_800_x_600.jpg\";i:55;s:62:\"asset::aws::archive\/images\/living_the_law_of_one_101_cover.jpg\";i:56;s:64:\"asset::aws::archive\/images\/living_the_law_of_one_101_desktop.jpg\";i:57;s:58:\"asset::aws::archive\/images\/living_the_law_of_one_cover.jpg\";i:58;s:34:\"asset::aws::archive\/images\/loo.jpg\";i:59;s:35:\"asset::aws::archive\/images\/loo1.jpg\";i:60;s:35:\"asset::aws::archive\/images\/loo2.png\";i:61;s:35:\"asset::aws::archive\/images\/loo3.png\";i:62;s:35:\"asset::aws::archive\/images\/loo4.png\";i:63;s:35:\"asset::aws::archive\/images\/loo5.png\";i:64;s:38:\"asset::aws::archive\/images\/mosaics.jpg\";i:65;s:37:\"asset::aws::archive\/images\/poetry.jpg\";i:66;s:67:\"asset::aws::archive\/images\/pub_light_lines_first_25_years_cover.jpg\";i:67;s:61:\"asset::aws::archive\/images\/pub_the_alphabet_mosaics_cover.jpg\";i:68;s:39:\"asset::aws::archive\/images\/quixotic.jpg\";i:69;s:33:\"asset::aws::archive\/images\/rc.png\";i:70;s:34:\"asset::aws::archive\/images\/rc1.png\";i:71;s:41:\"asset::aws::archive\/images\/rc1_german.png\";i:72;s:40:\"asset::aws::archive\/images\/rc1french.png\";i:73;s:34:\"asset::aws::archive\/images\/rc2.png\";i:74;s:41:\"asset::aws::archive\/images\/rc2_german.png\";i:75;s:42:\"asset::aws::archive\/images\/rc_homepage.png\";i:76;s:38:\"asset::aws::archive\/images\/secrets.jpg\";i:77;s:66:\"asset::aws::archive\/images\/the_ll_research_channeling_archives.jpg\";i:78;s:73:\"asset::aws::archive\/images\/the_poetry_of_carla_lisbeth_rueckert_cover.jpg\";i:79;s:38:\"asset::aws::archive\/images\/tilting.jpg\";i:80;s:44:\"asset::aws::archive\/images\/tilting_cover.jpg\";i:81;s:37:\"asset::aws::archive\/images\/voices.png\";i:82;s:37:\"asset::aws::archive\/images\/voices.psd\";i:83;s:43:\"asset::aws::archive\/images\/voices_cover.jpg\";i:84;s:41:\"asset::aws::archive\/images\/whatislove.jpg\";i:85;s:34:\"asset::aws::audio\/101\/lesson_1.mp3\";i:86;s:35:\"asset::aws::audio\/101\/lesson_10.mp3\";i:87;s:35:\"asset::aws::audio\/101\/lesson_11.mp3\";i:88;s:35:\"asset::aws::audio\/101\/lesson_12.mp3\";i:89;s:34:\"asset::aws::audio\/101\/lesson_2.mp3\";i:90;s:34:\"asset::aws::audio\/101\/lesson_3.mp3\";i:91;s:34:\"asset::aws::audio\/101\/lesson_4.mp3\";i:92;s:34:\"asset::aws::audio\/101\/lesson_5.mp3\";i:93;s:34:\"asset::aws::audio\/101\/lesson_6.mp3\";i:94;s:34:\"asset::aws::audio\/101\/lesson_7.mp3\";i:95;s:34:\"asset::aws::audio\/101\/lesson_8.mp3\";i:96;s:34:\"asset::aws::audio\/101\/lesson_9.mp3\";i:97;s:27:\"asset::aws::audio\/jenny.mp3\";i:98;s:44:\"asset::aws::audio\/meditations\/1979.07.11.mp3\";i:99;s:44:\"asset::aws::audio\/meditations\/1981.05.17.mp3\";}s:28:\"\u0000*\u0000escapeWhenCastingToString\";b:0;}}","batchId":null},"createdAt":1771917542,"delay":null}
 attempts = 0
 reserved_at =
 available_at = 1771917542
 created_at = 1771917542

But that's all I can figure out so far, I'm not sure what the problem is yet and I thought because it's costing so much I thought maybe someone else has some ideas on how to debug it or what to investigate more.

I do know there's an issue on Statamic v6 where I can't list my assets on S3 because it just times out? So maybe it's related too? I was able to make some progress on that one by importing the assets into eloquent on my production server, as we have a few thousand PDFs in there. But for the test website we've still been using the file driver instead of eloquent

Image

It just seems to timeout with a 504 error on the assets page, so if it was something related to the queue and it was timing out too or getting a 504 error then maybe the job is being replayed over and over?

I have no clue... any other ideas or things to try?

How to reproduce

I wish I knew

Logs

Environment

Environment
Laravel Version: 12.52.0
PHP Version: 8.4.16
Composer Version: 2.9.5
Environment: testing
Debug Mode: ENABLED
Maintenance Mode: OFF
Timezone: America/Kentucky/Louisville
Locale: en

Cache
Config: NOT CACHED
Events: CACHED
Routes: CACHED
Views: CACHED

Drivers
Broadcasting: pusher
Cache: database
Database: app
Logs: stack / single
Mail: log
Queue: database
Session: database

Storage
public/storage: LINKED

Livewire
Livewire: v4.1.4

Statamic
Addons: 2
Sites: 28 (English, Arabic, Bulgarian, and 25 more)
Stache Watcher: Enabled
Static Caching: Disabled
Version: 6.3.3 PRO

Statamic Addons
mikomagni/statamic-environment: 6.x-dev
statamic/eloquent-driver: 5.2.0

Statamic Eloquent Driver
Addon Settings: file
Asset Containers: file
Assets: file
Blueprints: file
Collection Trees: file
Collections: file
Entries: eloquent
Fieldsets: file
Form Submissions: file
Forms: file
Global Sets: file
Global Variables: file
Navigation Trees: file
Navigations: file
Revisions: eloquent
Sites: file
Taxonomies: file
Terms: file
Tokens: file

Installation

Existing Laravel app

Additional details

I will let you know if I figure anything else out.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions