Server Error

[seaneady]

Reporting a bug which I encountered when attempting to sign up to the mobile and web version of the MVP.

[LuchoTurtle]

🤔

Did this error occur when you logged in? I've tried logging in from an anonymous window and it seems to be working properly.

What steps did you do to get to this error?

[LuchoTurtle]

Hm, okay, when pushing changes to #280, it seems the CI errors when deploying it to Fly.io.

https://github.com/dwyl/mvp/actions/runs/3988547375/jobs/6839852547

This might be related. Let me see if I can figure out what's going on 👍

[LuchoTurtle]

Uhm. I re-ran that job and it seems to be working now.
https://github.com/dwyl/mvp/actions/runs/3988547375

Perhaps some networking issues on Fly.io's side?
Logs don't show anything out of the ordinary either -> https://fly.io/apps/mvp-pr-280/monitoring

Is your issue still occurring @seaneady ? Everything seems fine on my end 😄

[seaneady]

I tried it in two different browsers and still getting this error.

[seaneady]

also tried it on other computers too and I got the same thing.

[SimonLab]

I can see the following error on the logs, not sure yet if it's related:

[LuchoTurtle]

Database logs show this. https://fly.io/apps/mvp-db/monitoring

2023-01-23T17:26:07.005 app[12a3726f] lhr [info] keeper | 2023-01-23 17:26:07.002 UTC [32321] DETAIL: Key (person_id)=(209) is not present in table "people".

2023-01-23T17:26:08.021 app[12a3726f] lhr [info] keeper | 2023-01-23 17:26:08.021 UTC [32321] ERROR: insert or update on table "items" violates foreign key constraint "items_person_id_fkey"

This is probably the issue, perhaps Sean's person row was deleted from the database for whatever reason and can't properly login (?).

I don't really know how to access the database and make changes to it, going to leave it to the pros. @nelsonic @SimonLab

[SimonLab]

From #281 (comment) I think maybe an error has been created on Fly.io side. the auth.dwyl.com is accessible for me but it makes sense that the queries won't work on the mvp if the person_id is not retrieved from the auth app.

[nelsonic]

@seaneady thanks very much for reporting this. 👌 (😢)
I strongly suspect that this is a browser cookies issue. 🍪
Specifically that something went wrong in the auth process and the JWT is corrupt/outdated. 🙄
Please confirm which web browser you are using so we can help with clearing. 🙏

[seaneady]

No problem. I tried from Chrome and Safari on two separate computers and got the same error. Could it have something to do with the fact that I am trying to log in from South Africa maybe?

[nelsonic]

It's possible that CloudFlare is blocking the requests. Super lame if they are! 😢
Might need to fire up VPN to see if we can reproduce the error. 💭