[Question]: Auth Admin Fails on Update Newly Created User

[psycotrompus]

General info

• I checked the troubleshooting page for similar problems

What is your question?

I'm running a local supabase instance using Docker and CLI. I'm getting this error whenever I call supabaseAdmin.auth.admin.updateUserById(String) function:

supabaseAdmin.auth.admin.updateUserById(uid = authId) {
  phone = Phone.fromString(data.model.mobileNumber).value
  phoneConfirm = true
}

io.github.jan.supabase.exceptions.UnknownRestException: Unknown Error

URL: http://192.168.100.200:54321/auth/v1/admin/users/a31cd2b7-411b-4322-9a4e-c8634e5f4144
Headers: [Authorization=[Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZS1kZW1vIiwicm9sZSI6InNlcnZpY2Vfcm9sZSIsImV4cCI6MTk4MzgxMjk5Nn0.EGIM96RAZx35lJzdJsyH-qQwv8Hdp7fsn3W0YpN81IU], apikey=[eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZS1kZW1vIiwicm9sZSI6InNlcnZpY2Vfcm9sZSIsImV4cCI6MTk4MzgxMjk5Nn0.EGIM96RAZx35lJzdJsyH-qQwv8Hdp7fsn3W0YpN81IU], X-Client-Info=[supabase-kt/3.2.6], X-Supabase-Client-Platform=[Android], X-Supabase-Client-Platform-Version=[15], Accept=[application/json], Accept-Charset=[UTF-8]]
Http Method: PUT

at io.github.jan.supabase.auth.AuthImpl.parseErrorResponse(AuthImpl.kt:577)
at io.github.jan.supabase.auth.AuthenticatedSupabaseApiKt$authenticatedSupabaseApi$3.invoke(AuthenticatedSupabaseApi.kt:60)
at io.github.jan.supabase.auth.AuthenticatedSupabaseApiKt$authenticatedSupabaseApi$3.invoke(AuthenticatedSupabaseApi.kt:60)
at io.github.jan.supabase.network.SupabaseApi.rawRequest$suspendImpl(SupabaseApi.kt:25)
at io.github.jan.supabase.network.SupabaseApi$rawRequest$1.invokeSuspend(Unknown Source:15)
at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:34)

Assume that the supabaseAdmin is a configured SupabaseClient using the service_role key.

This is the API Gateway log entry I found:

{
  "event_message": "172.19.0.1 - - [09/Nov/2025:09:26:44 +0000] \"PUT /auth/v1/admin/users/a31cd2b7-411b-4322-9a4e-c8634e5f4144 HTTP/1.1\" 500 149 \"-\" \"ktor-client\"",
  "id": "95b4380f-c590-42a3-9b7b-96ad43e36f0c",
  "metadata": [
    {
      "request": [
        {
          "headers": [
            {
              "cf_connecting_ip": "172.19.0.1",
              "user_agent": "ktor-client"
            }
          ],
          "method": "PUT",
          "path": "/auth/v1/admin/users/a31cd2b7-411b-4322-9a4e-c8634e5f4144",
          "protocol": "HTTP/1.1"
        }
      ],
      "response": [
        {
          "status_code": 500
        }
      ]
    }
  ],
  "timestamp": 1762680404000000
}

Let me know if you need anything else.

Relevant log output (optional)

{
  "event_message": "172.19.0.1 - - [09/Nov/2025:09:26:44 +0000] \"PUT /auth/v1/admin/users/a31cd2b7-411b-4322-9a4e-c8634e5f4144 HTTP/1.1\" 500 149 \"-\" \"ktor-client\"",
  "id": "95b4380f-c590-42a3-9b7b-96ad43e36f0c",
  "metadata": [
    {
      "request": [
        {
          "headers": [
            {
              "cf_connecting_ip": "172.19.0.1",
              "user_agent": "ktor-client"
            }
          ],
          "method": "PUT",
          "path": "/auth/v1/admin/users/a31cd2b7-411b-4322-9a4e-c8634e5f4144",
          "protocol": "HTTP/1.1"
        }
      ],
      "response": [
        {
          "status_code": 500
        }
      ]
    }
  ],
  "timestamp": 1762680404000000
}

[psycotrompus]

nevermind, I found the root cause of the issue:

{"component":"api","error":"ERROR: duplicate key value violates unique constraint \"users_phone_key\" (SQLSTATE 23505)","level":"error","method":"PUT","msg":"500: Error updating user","path":"/admin/users/a31cd2b7-411b-4322-9a4e-c8634e5f4144","referer":"onsitejobs://app","remote_addr":"172.19.0.1","request_id":"0241fa1b-ae9c-41f8-91f1-5a5525017f12","time":"2025-11-09T09:26:44Z","user_id":"a31cd2b7-411b-4322-9a4e-c8634e5f4144"}

I found this in the docker supabase_auth_ instance logs.

There's no logs showing in the dashboard Logs > Auth tab.