a year ago
Hi, I am getting this issue on MySQL database. I am unable to query it anymore and am not sure how to resolve it. Please help, thank you!
0 Replies
a year ago
I would first upgrade to the hobby plan and then grow the volume
a year ago
is your project located within a pro workspace
a year ago
what's the size of the attached volume
a year ago
what's the total size
a year ago
it's completely offline?
⨯ PrismaClientUnknownRequestError:
Invalid `prisma.dataRoom.findMany()` 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 })
at DataRoomsPage (dashboard/page.tsx:49:23)
⨯ PrismaClientUnknownRequestError:
Invalid `prisma.dataRoom.findMany()` invocation:a year ago
to get it temporarily back online, have you tried to redeploy?
a year ago
unless you have severaly misconfigured something, no your data should be in tact
a year ago
that doesnt copy any data
a year ago
do you not take backups?
a year ago
wdym externally?
a year ago
that means you dont have any backups, since railway does not do backups for you
a year ago
go ahead and restart the database
a year ago
you said you cant access the database?
i think identical to this issue: https://discord.com/channels/713503345364697088/1128981546544668704/1128981546544668704
I'm gonna try and setup backups first before trying restart/redeploy and will come back if none of that fixes it, thanks for help thus far
a year ago
i dont think fragly's suggested fix would persist between deploys
a year ago
you can permanently double the sort buffer size by appending --sort_buffer_size=512K onto your mysql start command
a year ago
again, yes, unless you have severely missconfigured something
a year ago
ideally you would write a more efficient query, but increasing the sort buffer size is alright
a year ago
no problem