With credential provider xata adapter not storing session data in xata database

Adapter type

@auth/xata-adapter

Environment

System:
    OS: Windows 11 10.0.22631
    CPU: (12) x64 Intel(R) Core(TM) i7-8750H CPU @ 2.20GHz
    Memory: 13.71 GB / 23.88 GB
  Binaries:
    Node: 20.10.0 - C:\Program Files\nodejs\node.EXE
    Yarn: 3.3.1 - C:\Program Files\nodejs\yarn.CMD
    npm: 9.8.1 - C:\Program Files\nodejs\npm.CMD
    pnpm: 9.1.4 - ~\AppData\Local\pnpm\pnpm.CMD
  Browsers:
    Edge: Chromium (125.0.2535.67)
    Internet Explorer: 11.0.22621.3527
  npmPackages:
    @auth/xata-adapter: ^1.2.0 => 1.2.0
    next: 14.2.3 => 14.2.3
    next-auth: 5.0.0-beta.19 => 5.0.0-beta.19
    react: ^18 => 18.3.1

Reproduction URL

https://github.com/dwalker93/xata-auth-test

Describe the issue

Xata adapater not storing session data in the xata database when using credentials provider. But working fine with the github provider as I tested.

How to reproduce

download the repo
run command pnpm install
Create an account in xata.io
run command pnpm add -g @xata.io/cli
run command xata auth login
run command xata init --schema="schema.json"
run command pnpm dev

Expected behavior

You should be able to login using the credential provider and be redirected to the app and see the users session information.

No session was created in the database, can anyone help solve this?

https://github.com/nextauthjs/next-auth/tree/main/packages/core/src/lib/actions/callback/index.ts

else if (provider.type === "credentials" && method === "POST") {
    const credentials = body ?? {}

    // TODO: Forward the original request as is, instead of reconstructing it
    Object.entries(query ?? {}).forEach(([k, v]) =>
      url.searchParams.set(k, v)
    )
    const userFromAuthorize = await provider.authorize(
      credentials,
      // prettier-ignore
      new Request(url, { headers, method, body: JSON.stringify(body) })
    )
    const user = userFromAuthorize

    if (!user) {
      console.error(
        "Read more at https://errors.authjs.dev/#credentialssignin"
      )
      throw new CredentialsSignin()
    } else user.id = user.id?.toString() ?? crypto.randomUUID()

    const account = {
      providerAccountId: user.id,
      type: "credentials",
      provider: provider.id,
    } satisfies Account

    const redirect = await handleAuthorized(
      { user, account, credentials },
      options
    )
    if (redirect) return { redirect, cookies }

    const defaultToken = {
      name: user.name,
      email: user.email,
      picture: user.image,
      sub: user.id,
    }

    const token = await callbacks.jwt({
      token: defaultToken,
      user,
      account,
      isNewUser: false,
      trigger: "signIn",
    })

    // Clear cookies if token is null
    if (token === null) {
      cookies.push(...sessionStore.clean())
    } else {
      const salt = options.cookies.sessionToken.name
      // Encode token
      const newToken = await jwt.encode({ ...jwt, token, salt })

      // Set cookie expiry date
      const cookieExpires = new Date()
      cookieExpires.setTime(cookieExpires.getTime() + sessionMaxAge * 1000)

      const sessionCookies = sessionStore.chunk(newToken, {
        expires: cookieExpires,
      })

      cookies.push(...sessionCookies)
    }

    await events.signIn?.({ user, account })

    return { redirect: callbackUrl, cookies }
  }

Other providers include the following:

 const { user, session, isNewUser } = await handleLoginOrRegister(
        sessionStore.value,
        userFromProvider,
        account,
        options
      )

https://github.com/nextauthjs/next-auth/tree/main/packages/core/src/lib/actions/session.ts

When accessing “/api/auth/session”, the session could not be read,

let userAndSession = await getSessionAndUser(sessionToken)

and the following operations were performed.

response.cookies?.push(...sessionStore.clean())

@dwalker93

nextauthjs / next-auth