Why am I getting this error for this login component?

I keep receiving this error, and there doesn't seem to be much documentation on it. Login component and error are below.

{
  code: '42P01',
  details: null,
  hint: null,
  message: 'relation "public.auth.users" does not exist'
}
RangeError [ERR_HTTP_INVALID_STATUS_CODE]: Invalid status code: 0
    at new NodeError (node:internal/errors:399:5)
    at ServerResponse.writeHead (node:_http_server:344:11)
    at ServerResponse._implicitHeader (node:_http_server:335:8)
    at ServerResponse.end (node:_http_outgoing:1035:10)
    at DevServer.handleCatchallMiddlewareRequest (C:\Immanuel\Coding\stack-overflow-clone\node_modules\next\dist\server\next-server.js:1113:38)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async DevServer.handleRequestImpl (C:\Immanuel\Coding\stack-overflow-clone\node_modules\next\dist\server\base-server.js:647:32) {
  code: 'ERR_HTTP_INVALID_STATUS_CODE'
}
{
  code: '42P01',
  details: null,
  hint: null,
  message: 'relation "public.auth.users" does not exist'
}
RangeError [ERR_HTTP_INVALID_STATUS_CODE]: Invalid status code: 0
    at new NodeError (node:internal/errors:399:5)
    at ServerResponse.writeHead (node:_http_server:344:11)
    at ServerResponse._implicitHeader (node:_http_server:335:8)
    at ServerResponse.end (node:_http_outgoing:1035:10)
    at DevServer.handleCatchallMiddlewareRequest (C:\Immanuel\Coding\stack-overflow-clone\node_modules\next\dist\server\next-server.js:1113:38)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async DevServer.handleRequestImpl (C:\Immanuel\Coding\stack-overflow-clone\node_modules\next\dist\server\base-server.js:647:32) {
  code: 'ERR_HTTP_INVALID_STATUS_CODE'
}

{
  code: '42P01',
  details: null,
  hint: null,
  message: 'relation "public.auth.users" does not exist'
}
RangeError [ERR_HTTP_INVALID_STATUS_CODE]: Invalid status code: 0
    at new NodeError (node:internal/errors:399:5)
    at ServerResponse.writeHead (node:_http_server:344:11)
    at ServerResponse._implicitHeader (node:_http_server:335:8)
    at ServerResponse.end (node:_http_outgoing:1035:10)
    at DevServer.handleCatchallMiddlewareRequest (C:\Immanuel\Coding\stack-overflow-clone\node_modules\next\dist\server\next-server.js:1113:38)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async DevServer.handleRequestImpl (C:\Immanuel\Coding\stack-overflow-clone\node_modules\next\dist\server\base-server.js:647:32) {
  code: 'ERR_HTTP_INVALID_STATUS_CODE'
}
{
  code: '42P01',
  details: null,
  hint: null,
  message: 'relation "public.auth.users" does not exist'
}
RangeError [ERR_HTTP_INVALID_STATUS_CODE]: Invalid status code: 0
    at new NodeError (node:internal/errors:399:5)
    at ServerResponse.writeHead (node:_http_server:344:11)
    at ServerResponse._implicitHeader (node:_http_server:335:8)
    at ServerResponse.end (node:_http_outgoing:1035:10)
    at DevServer.handleCatchallMiddlewareRequest (C:\Immanuel\Coding\stack-overflow-clone\node_modules\next\dist\server\next-server.js:1113:38)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async DevServer.handleRequestImpl (C:\Immanuel\Coding\stack-overflow-clone\node_modules\next\dist\server\base-server.js:647:32) {
  code: 'ERR_HTTP_INVALID_STATUS_CODE'
}

{
  code: '42P01',
  details: null,
  hint: null,
  message: 'relation "public.auth.users" does not exist'
}
RangeError [ERR_HTTP_INVALID_STATUS_CODE]: Invalid status code: 0
    at new NodeError (node:internal/errors:399:5)
    at ServerResponse.writeHead (node:_http_server:344:11)
    at ServerResponse._implicitHeader (node:_http_server:335:8)
    at ServerResponse.end (node:_http_outgoing:1035:10)
    at DevServer.handleCatchallMiddlewareRequest (C:\Immanuel\Coding\stack-overflow-clone\node_modules\next\dist\server\next-server.js:1113:38)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async DevServer.handleRequestImpl (C:\Immanuel\Coding\stack-overflow-clone\node_modules\next\dist\server\base-server.js:647:32) {
  code: 'ERR_HTTP_INVALID_STATUS_CODE'
}
{
  code: '42P01',
  details: null,
  hint: null,
  message: 'relation "public.auth.users" does not exist'
}
RangeError [ERR_HTTP_INVALID_STATUS_CODE]: Invalid status code: 0
    at new NodeError (node:internal/errors:399:5)
    at ServerResponse.writeHead (node:_http_server:344:11)
    at ServerResponse._implicitHeader (node:_http_server:335:8)
    at ServerResponse.end (node:_http_outgoing:1035:10)
    at DevServer.handleCatchallMiddlewareRequest (C:\Immanuel\Coding\stack-overflow-clone\node_modules\next\dist\server\next-server.js:1113:38)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async DevServer.handleRequestImpl (C:\Immanuel\Coding\stack-overflow-clone\node_modules\next\dist\server\base-server.js:647:32) {
  code: 'ERR_HTTP_INVALID_STATUS_CODE'
}

{
  code: '42P01',
  details: null,
  hint: null,
  message: 'relation "public.auth.users" does not exist'
}
RangeError [ERR_HTTP_INVALID_STATUS_CODE]: Invalid status code: 0
    at new NodeError (node:internal/errors:399:5)
    at ServerResponse.writeHead (node:_http_server:344:11)
    at ServerResponse._implicitHeader (node:_http_server:335:8)
    at ServerResponse.end (node:_http_outgoing:1035:10)
    at DevServer.handleCatchallMiddlewareRequest (C:\Immanuel\Coding\stack-overflow-clone\node_modules\next\dist\server\next-server.js:1113:38)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async DevServer.handleRequestImpl (C:\Immanuel\Coding\stack-overflow-clone\node_modules\next\dist\server\base-server.js:647:32) {
  code: 'ERR_HTTP_INVALID_STATUS_CODE'
}
{
  code: '42P01',
  details: null,
  hint: null,
  message: 'relation "public.auth.users" does not exist'
}
RangeError [ERR_HTTP_INVALID_STATUS_CODE]: Invalid status code: 0
    at new NodeError (node:internal/errors:399:5)
    at ServerResponse.writeHead (node:_http_server:344:11)
    at ServerResponse._implicitHeader (node:_http_server:335:8)
    at ServerResponse.end (node:_http_outgoing:1035:10)
    at DevServer.handleCatchallMiddlewareRequest (C:\Immanuel\Coding\stack-overflow-clone\node_modules\next\dist\server\next-server.js:1113:38)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async DevServer.handleRequestImpl (C:\Immanuel\Coding\stack-overflow-clone\node_modules\next\dist\server\base-server.js:647:32) {
  code: 'ERR_HTTP_INVALID_STATUS_CODE'
}

message.txt4.64KB

ImmanuelOP•12/21/23, 5:41 PM

The JSX is in the txt file because it's a little big

garyaustin•12/21/23, 5:52 PM

Somewhere you are trying to access auth.users incorrectly is my guess. If you have a trigger function on auth. users you might check that. You can also look at Postgres logs.

ImmanuelOP•12/21/23, 6:14 PM

This is what I see in the logs:

{
  "file": null,
  "host": "db-{my_db}",
  "metadata": [],
  "parsed": [
    {
      "application_name": "postgrest",
      "backend_type": "client backend",
      "command_tag": "PARSE",
      "connection_from": "127.0.0.1:39302",
      "context": null,
      "database_name": "postgres",
      "detail": null,
      "error_severity": "ERROR",
      "hint": null,
      "internal_query": null,
      "internal_query_pos": null,
      "leader_pid": null,
      "location": null,
      "process_id": 100841,
      "query": "WITH pgrst_source AS ( SELECT \"public\".\"auth.users\".* FROM \"public\".\"auth.users\"  WHERE  \"public\".\"auth.users\".\"id\" = $1  LIMIT $2 OFFSET $3 )  SELECT null::bigint AS total_result_set, pg_catalog.count(_postgrest_t) AS page_total, coalesce(json_agg(_postgrest_t), '[]') AS body, nullif(current_setting('response.headers', true), '') AS response_headers, nullif(current_setting('response.status', true), '') AS response_status FROM ( SELECT * FROM pgrst_source ) _postgrest_t",
      "query_id": 0,
      "query_pos": 60,
      "session_id": "658477c5.189e9",
      "session_line_num": 3,
      "session_start_time": "2023-12-21 17:37:09 UTC",
      "sql_state_code": "42P01",
      "timestamp": "2023-12-21 17:37:12.470 UTC",
      "transaction_id": 0,
      "user_name": "authenticator",
      "virtual_transaction_id": "9/1680"
    }
  ],
  "parsed_from": null,
  "project": null,
  "source_type": null
}

{
  "file": null,
  "host": "db-{my_db}",
  "metadata": [],
  "parsed": [
    {
      "application_name": "postgrest",
      "backend_type": "client backend",
      "command_tag": "PARSE",
      "connection_from": "127.0.0.1:39302",
      "context": null,
      "database_name": "postgres",
      "detail": null,
      "error_severity": "ERROR",
      "hint": null,
      "internal_query": null,
      "internal_query_pos": null,
      "leader_pid": null,
      "location": null,
      "process_id": 100841,
      "query": "WITH pgrst_source AS ( SELECT \"public\".\"auth.users\".* FROM \"public\".\"auth.users\"  WHERE  \"public\".\"auth.users\".\"id\" = $1  LIMIT $2 OFFSET $3 )  SELECT null::bigint AS total_result_set, pg_catalog.count(_postgrest_t) AS page_total, coalesce(json_agg(_postgrest_t), '[]') AS body, nullif(current_setting('response.headers', true), '') AS response_headers, nullif(current_setting('response.status', true), '') AS response_status FROM ( SELECT * FROM pgrst_source ) _postgrest_t",
      "query_id": 0,
      "query_pos": 60,
      "session_id": "658477c5.189e9",
      "session_line_num": 3,
      "session_start_time": "2023-12-21 17:37:09 UTC",
      "sql_state_code": "42P01",
      "timestamp": "2023-12-21 17:37:12.470 UTC",
      "transaction_id": 0,
      "user_name": "authenticator",
      "virtual_transaction_id": "9/1680"
    }
  ],
  "parsed_from": null,
  "project": null,
  "source_type": null
}

ImmanuelOP•12/21/23, 6:15 PM

I haven't created any triggers

ImmanuelOP•12/21/23, 6:17 PM

I have tried to access auth.id as a foreign key

garyaustin•12/21/23, 6:21 PM

You can’t do that normally thru the REST API

ImmanuelOP•12/21/23, 7:31 PM

Would removing the foreign key relation resolve the issue?

{ "file": null, "host": "db-{my_db}", "metadata": [], "parsed": [ { "application_name": "postgrest", "backend_type": "client backend", "command_tag": "PARSE", "connection_from": "127.0.0.1:39302", "context": null, "database_name": "postgres", "detail": null, "error_severity": "ERROR", "hint": null, "internal_query": null, "internal_query_pos": null, "leader_pid": null, "location": null, "process_id": 100841, "query": "WITH pgrst_source AS ( SELECT \"public\".\"auth.users\".* FROM \"public\".\"auth.users\" WHERE \"public\".\"auth.users\".\"id\" = $1 LIMIT $2 OFFSET $3 ) SELECT null::bigint AS total_result_set, pg_catalog.count(_postgrest_t) AS page_total, coalesce(json_agg(_postgrest_t), '[]') AS body, nullif(current_setting('response.headers', true), '') AS response_headers, nullif(current_setting('response.status', true), '') AS response_status FROM ( SELECT * FROM pgrst_source ) _postgrest_t", "query_id": 0, "query_pos": 60, "session_id": "658477c5.189e9", "session_line_num": 3, "session_start_time": "2023-12-21 17:37:09 UTC", "sql_state_code": "42P01", "timestamp": "2023-12-21 17:37:12.470 UTC", "transaction_id": 0, "user_name": "authenticator", "virtual_transaction_id": "9/1680" } ], "parsed_from": null, "project": null, "source_type": null }

Why am I getting this error for this login component?

Similar Threads

Similar Threads

Similar Threads