returningId makes insert query fail, also auto increment value is weirdly high

[yooouuri]

When using returningId, it makes my query fail and timeout the Vercel functions I am using.

  const [ participant ] = await db.insert(participants).values({
    eventId: row.id,
    name: body.name,
    email: body.email,
    phone: body.phone,
    code,
    adults: body.adults,
    kids: body.kids,
    questions: body.questions,
    note: body.note,
    createdAt: new Date(),
    updatedAt: new Date(),
  }).$returningId()

Also, my auto increment value is weirdly around the 3060033 ish...

[shiyuhang0]

Seems you are using ORM in your code, could you provide the following thing:

• Which ORM are you using
• the version of ORM and serverless-js
• the schema of your table if possible

As for the auto increment value, it is normal in TiDB.
You can find the reason and the way to avoid it in this doc: https://docs.pingcap.com/tidb/stable/auto-increment/#auto_id_cache