Railway•17mo ago

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•17mo ago

Project ID: f568f607-e4d1-4517-ba1a-537dc9a8be86

elisOP•17mo ago

f568f607-e4d1-4517-ba1a-537dc9a8be86 please stand by - it might be unrelated

Fragly•17mo 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

elisOP•17mo ago

thank you!

Fragly•17mo ago

no problem :)

Gaming

Programming

Service saying "out of memory"