R
Railway•12mo ago
elis

Service saying "out of memory"

My project was on a Hobby plan and I've received errors on one of the services mentioning Out of Memory issue - upgraded to Team plan with 32gb but still getting the out of memory error message 
Invalid `prisma.published.findFirst()` invocation:
Error occurred during query execution:
ConnectorError(ConnectorError { user_facing_error: None, kind: QueryError(Server(ServerError { code: 1038, message: "Out of sort memory, consider increasing server sort buffer size", state: "HY001" })), transient: false })
Invalid `prisma.published.findFirst()` invocation:
Error occurred during query execution:
ConnectorError(ConnectorError { user_facing_error: None, kind: QueryError(Server(ServerError { code: 1038, message: "Out of sort memory, consider increasing server sort buffer size", state: "HY001" })), transient: false })
I've restarted and redeployed the service - still receiving the error - how can I debug/resolve that issue?
5 Replies
Percy
Percy•12mo ago
Project ID: f568f607-e4d1-4517-ba1a-537dc9a8be86
elis
elis•12mo ago
f568f607-e4d1-4517-ba1a-537dc9a8be86 please stand by - it might be unrelated
Fragly
Fragly•12mo ago
it says: Out of sort memory, consider increasing server sort buffer size meaning your sort_buffer_size isn't big enough so you just have to increase it to a bigger size so just pop this command in your SQL CLI SET sort_buffer_size = SIZE_IN_BYTES; the default size is 256Kb, so maybe try 400Kb 1024 * 1024 * 0.4 = 400 kb
elis
elis•12mo ago
thank you!
Fragly
Fragly•12mo ago
no problem :)
Want results from more Discord servers?
Add your server
More Posts
custom domain name not workingadd a custom domain to my project once i click on the link ig response "This site can’t be reached"Switch from usage-based subscription to prepaid subscription?I currently have a usage-based subscription for the Hobby plan. I cannot find the purchase credit opwhat is cidr for private network?we need config railway private network in our network, so what is cidr railway use?ffprobe error: `ffprobe was killed with signal SIGSEGV`I'm trying to use ffmpeg on my railway app and i've got ffmpeg itself installed and working correctlStrapi won't load on Railway AppI keep getting a message saying WARNING: An error occurred while requesting the API This is a freshAdd python to node.js deploymentIs there a way to add python to a deployment? I run code in untrusted code in an isolated vm in myIssuing a new TLS certificate taking a long timewill the title should be more than enough to understand what i need.plugincant start plugin after i set paymentDNS Error when using Fetch API only in RailwayI wrote a crawler using the crawlbase api. It runs fine in a container on my local machine, but in rReferralWhen will i be able to use my pending credits ?