Allowed memory size of 134217728 bytes exhausted
I've built an ecommerce website using Livewire and FilamentPHP for the admin panel.
Everything works fine but after using the website for some time (specifically order management) the error raises.
I have a doubt the issue is causing because of filamentphp 😥
Can anyone assist me to find the issue?
29 Replies
change your
memory_limit = 2048M
in php.ini
In the past I had the Filament debugbar causing this. Maybe quickly try disabling?
it is on production, debugbar is no issue here
yeah but that is not proper solution
memory_limit=256M should be enough
otherwise you may be loading to much data at once OR you have an infinite loop
This is happening on 1 page (resource index: table)
whats your table defintion
What kind of hosting environment? Are you using pulse? When local, what does debug bar show about your queries?
using DigitalOcean VPS (64$/month) and the problem is occurring after using the website for a while so there is nothing in the logs related to db queries
Are you running Octane?
no, I was thinking to use octane but decided not to
@Raziul Islam how big are you paginated sizes? just the default 10? something else is going on
here is another issue, I think it is for everyone
If my resource has badge then the queries are duplicated
I am doubting this, I use on 10 or 50 but the moderators may be using big size
you put 50 as your max, right?
@Dennis Koch Do you know anything about this?
dont allow sizes bigger than that
100 as max
i would reduce that to 50. Duplicate queries isnt necessarily an issue. Thats going to happen.
when you say used for awhile, what do you mean? How many simultaneous users do you have within the admin?
around 20 users at a time
I have seen this before. Not sure why it happens though
is there any way to set default pagination limit? I want to remove 'ALL' from the pagination list
all isnt even availably by default
also, its "Complaints", not "Complains" 😉
you added all, its not availably by default
it is from the model 😅 Will override it
no I did not
You can check the demo as well.
All is there by default
https://demo.filamentphp.com/shop/orders
Thanks, applied this
I had removed almost all the badges but had to keep a few
but I want to resolve the duplicate queries
i have the same proplem, are you solved ? @Raziul Islam