Helo, suddenly the supertokens that I deployed to my fly.io throw an error from backend ``` 2023-05...

muhajirdev

05/27/2023, 6:12 AM

Helo, suddenly the supertokens that I deployed to my fly.io throw an error from backend

Copy code

2023-05-27T06:06:15.831 app[148ed5d7a72e68] sin [info] {"level":50,"time":1685167575831,"pid":529,"hostname":"148ed5d7a72e68","reqId":"req-7k","err":{"type":"Error","message":"SuperTokens core threw an error for a POST request to path: '/recipe/session' with status code: 500 and message: Internal Error\n","stack":"Error: SuperTokens core threw an error for a POST request to path: '/recipe/session' with status code: 500 and message: Internal Error\n\n at Querier.<anonymous> (/app/node_modules/supertokens-node/lib/build/querier.js:252:31)\n at Generator.throw (<anonymous>)\n at rejected (/app/node_modules/supertokens-node/lib/build/querier.js:22:44)\n at runMicrotasks (<anonymous>)\n at processTicksAndRejections (node:internal/process/task_queues:96:5)"},"msg":"SuperTokens core threw an error for a POST request to path: '/recipe/session' with status code: 500 and message: Internal Error\n"}

2023-05-27T06:06:15.832 app[148ed5d7a72e68] sin [info] {"level":30,"time":16

and from supertokens-core

message

rp_st

05/27/2023, 6:12 AM

hey @muhajirdev

rp_st

05/27/2023, 6:13 AM

does this always happen?

muhajirdev

05/27/2023, 6:13 AM

hey @rp_st , any clue on what's happening

rp_st

05/27/2023, 6:13 AM

also, can you share the core logs?

muhajirdev

05/27/2023, 6:13 AM

so let me give a bigger context

muhajirdev

05/27/2023, 6:13 AM

so previously. I deployed this a few months ago

Copy code

"registry.supertokens.io/supertokens/supertokens-postgresql"

which default to latest

muhajirdev

05/27/2023, 6:13 AM

now because I don't want to mess with our backend code

muhajirdev

05/27/2023, 6:14 AM

I downgrade it it 4.6, but still not working, downgrade to 4.5, and now on 3.16

muhajirdev

05/27/2023, 6:14 AM

"registry.supertokens.io/supertokens/supertokens-postgresql:3.16"

muhajirdev

05/27/2023, 6:14 AM

previoulsy when i was on latest

rp_st

05/27/2023, 6:14 AM

right. Can you share the core logs please?

muhajirdev

05/27/2023, 6:14 AM

it shows error missing column use_static_key or something

muhajirdev

05/27/2023, 6:14 AM

sure

muhajirdev

05/27/2023, 6:14 AM

will copy paste full log here

rp_st

05/27/2023, 6:14 AM

yeaa.. this is tricky now

muhajirdev

05/27/2023, 6:15 AM

https://cdn.discordapp.com/attachments/1111899627982172210/1111900406252044298/message.txt

rp_st

05/27/2023, 6:15 AM

well, if you are downgrading it, then this column shouldn't be needed

muhajirdev

05/27/2023, 6:15 AM

what's happening?

rp_st

05/27/2023, 6:15 AM

which version are you running now?

muhajirdev

05/27/2023, 6:15 AM

3.16

rp_st

05/27/2023, 6:16 AM

whats is the db schema for the session_info table?

muhajirdev

05/27/2023, 6:17 AM

okay let me take a look

muhajirdev

05/27/2023, 6:21 AM

https://cdn.discordapp.com/attachments/1111899627982172210/1111902016256618606/image.png▾

muhajirdev

05/27/2023, 6:21 AM

it looks like this

muhajirdev

05/27/2023, 6:22 AM

something is wrong? @rp_st ?

rp_st

05/27/2023, 6:22 AM

im not sure. Downgrading the core will require manual verification of whats going on

rp_st

05/27/2023, 6:22 AM

i can help you sometime next week

rp_st

05/27/2023, 6:23 AM

but i would suggest to inspect our core code to see where the issue might be happening and figuring it out yourself

muhajirdev

05/27/2023, 6:23 AM

it does auto migration?

muhajirdev

05/27/2023, 6:23 AM

shuold I upgrade it back to 5.0?

rp_st

05/27/2023, 6:23 AM

auto migration is applied during core upgrades

rp_st

05/27/2023, 6:23 AM

see our changelog for the core please on our github

rp_st

05/27/2023, 6:23 AM

that may help

rp_st

05/27/2023, 6:23 AM

otherwise, we can help next week sometime

muhajirdev

05/27/2023, 6:24 AM

okay,

muhajirdev

05/27/2023, 6:24 AM

this is my staging environment

muhajirdev

05/27/2023, 6:24 AM

it's fine if it's broken

muhajirdev

05/27/2023, 6:24 AM

I have a prod one

muhajirdev

05/27/2023, 6:24 AM

that I haven't touched yet

muhajirdev

05/27/2023, 6:24 AM

what should I do with it?

rp_st

05/27/2023, 6:25 AM

you can ssh into the docker container and see which version of the core is installed in there, and replace then use that tag

rp_st

05/27/2023, 6:27 AM

you can ssh into the docker image, then run

supertokens --help

and show me the output

muhajirdev

05/27/2023, 6:28 AM

this is the prod

muhajirdev

05/27/2023, 6:28 AM

root@5683d906c79648:/# supertokens --help You are using SuperTokens Community Usage: supertokens [command] [--help] [--version] Commands: -> hashingCalibrate [options] Used to calibrate the settings for password hashing algorithms for a specific machine -> uninstall Uninstalls SuperTokens -> stop [options] Stops all (if no options are provided) or one specific instance of SuperTokens -> start [options] Start an instance of SuperTokens -> list List information about all currently running SuperTokens instances Files: Installation location /usr/lib/supertokens/ Default config file /usr/lib/supertokens/config.yaml Legal license /usr/lib/supertokens/LICENSE.md Thank you for checking out SuperTokens 🙂

muhajirdev

05/27/2023, 6:28 AM

root@5683d906c79648:/# supertokens --version You are using SuperTokens Community SuperTokens Core version: 5.0.0 Plugin Interface version: 2.23.0 Database Plugin name: postgresql Database Plugin version: 3.0.0 Java version: OpenJDK 15.0.1 Installation directory: /usr/lib/supertokens

muhajirdev

05/27/2023, 6:28 AM

I think the prod is on 5.0 as well

rp_st

05/27/2023, 6:28 AM

okay. So now change the tag of the docker image to

5.0

muhajirdev

05/27/2023, 6:28 AM

that's why it's also broken

rp_st

05/27/2023, 6:28 AM

so prod is broken too?

muhajirdev

05/27/2023, 6:28 AM

on prod?

muhajirdev

05/27/2023, 6:28 AM

yeap

muhajirdev

05/27/2023, 6:28 AM

prod is broken

rp_st

05/27/2023, 6:29 AM

then also update your backend and frontend SDKs

rp_st

05/27/2023, 6:29 AM

and see our changelog on github

rp_st

05/27/2023, 6:29 AM

for the core

rp_st

05/27/2023, 6:29 AM

it has commands to run on the db to migrate to 5.0

muhajirdev

05/27/2023, 6:29 AM

https://cdn.discordapp.com/attachments/1111899627982172210/1111904025122709524/image.png▾

rp_st

05/27/2023, 6:30 AM

see this: https://github.com/supertokens/supertokens-core/blob/master/CHANGELOG.md#migration-steps-for-sql

muhajirdev

05/27/2023, 6:32 AM

okay

muhajirdev

05/27/2023, 6:32 AM

let me try

rp_st

05/27/2023, 6:32 AM

actually, you don't need to change your backend and frontend sdks

muhajirdev

05/27/2023, 6:32 AM

I just need to run script?

rp_st

05/27/2023, 6:32 AM

just run the migration steps in the link above on your database

rp_st

05/27/2023, 6:32 AM

and it should be fine.

muhajirdev

05/27/2023, 6:32 AM

okay

muhajirdev

05/27/2023, 6:32 AM

what is access_token_signing_key_dynamic ?

muhajirdev

05/27/2023, 6:33 AM

it's true by default right

rp_st

05/27/2023, 6:33 AM

yes

muhajirdev

05/27/2023, 6:33 AM

okayy

muhajirdev

05/27/2023, 6:34 AM

I ran it on staging

muhajirdev

05/27/2023, 6:34 AM

it works

rp_st

05/27/2023, 6:34 AM

ok great

muhajirdev

05/27/2023, 6:34 AM

thanks god

muhajirdev

05/27/2023, 6:34 AM

thank you! @rp_st

rp_st

05/27/2023, 6:34 AM

👍

muhajirdev

05/27/2023, 6:36 AM

dude your support is 5/5 , very helpful

muhajirdev

05/27/2023, 6:36 AM

⭐

rp_st

05/27/2023, 6:36 AM

thanks 🙂

13 Views

Previous Next

SuperTokens.com

SuperTokens is an open source authentication solution offering features like: Different types of login: Email / password, Passwordless (OTP or Magic link based).