Getting Error 500 - Disk Full

Himanshu

An API that worked fine until yesterday now throws a Disk Full error.

Exception: SQLSTATE[53100]: Disk full: 7 ERROR: could not write to file “base/pgsql_tmp/pgsql_tmp743884.2”: No space left on device (SQL: select count(distinct “playlist”.*) as aggregate from “mvpw1_3” as “playlist” inner join “mvpw1_6” as “Followers” on true inner join “mvpw1_9” as “Ads_spend” on true where (“playlist”.“xdo”->>‘company_id’)::bigint = 1::bigint)

There are only 50k records and 28 MB of storage used till now.

What can be the issue and how to solve it?

Louis Machado - CSA

Hello @Himanshu,

Please reach out to the support team through the chat function for assistance with your issue. You can access the chat by clicking on "HELP" in the left navigation menu.

Himanshu

Thanks for the response Louis. I did that a while ago

Louis Machado - CSA

I have already reached out to you on the support chat. We can communicate there to get it resolved 👍