Where in the code is the User Session written to the database?

[MattHeslington]

Hi,

I'm trying to debug an error and I can't find where the user_session table is written to the db. Is it in one of the lucia functions such as 'lucia.createSession'? I don't understand why the query to create the auth_user is exposed, but not the session.

Framework: Sveltekit
Lucia: Lucia V3
Login: GitHub
DB Adapter: Postgres | Neon

When a user logs in for the first time everything works great. If they logout, and then try to login again, I'm catching an error in the callback:

NeonDbError: null value in column "user_id" of relation "user_session" violates not-null constraint

Cheers,
Matt

[pilcrowonpaper]

It's the adapter that's make the db query - Lucia.createSession() > Adapter.setSession()