User is unable to retake the quiz about climatemind-backend HOT 3 CLOSED

it happens when we try to update scores for a user. it's a case when this quiz UUID is already associated with some user. My guess was that the frontend sends multiple requests for some reason and we try to assign quiz UUID to the user twice.
We trying to update user C34EAF2F-9E88-474E-9A03-EED62B5F5A5D with the quiz uuid a8d30ffc-9964-4730-af38-36aa31fb6e3b

@rodriguesk I see that at the current moment you already have some quiz assigned to you
854EB8D6-C972-4ED7-ACAF-3A44013FC83C

I've started checking with the following query to find all @rodriguesk quizzes. Maybe you had to take another quiz. So I had to check this

select * from scores sc
join sessions se on se.session_uuid = sc.quiz_uuid
join users u on u.user_uuid = se.user_uuid
where u.user_uuid = 'C34EAF2F-9E88-474E-9A03-EED62B5F5A5D'

And have no result.
then I've checked all your sessions with

select * from sessions where user_uuid = 'C34EAF2F-9E88-474E-9A03-EED62B5F5A5D'

and have no results
then I've realized that there are not a single link to a user from the session table.

SELECT TOP 501 t.*
                    FROM [sqldb-web-test-001].dbo.sessions t
                    WHERE user_uuid is not null

All sessions are anonymous! It's a huge issue.
As a result I unable to check user's history of q quizzes

from climatemind-backend.

@danmash I'm not sure I understand the issue here precisely, but perhaps it has been (at least partially) solved by #363, given that that PR addresses the anonymous session issue?

from climatemind-backend.

ok, let's see if it will happen on production

from climatemind-backend.