kvnam
04/19/2022, 11:44 PMpg_net background worker
error when trying to update / create rows in some tables. Any ideas on how I can fix this? Or what could be causing this? Should I just restart the server?
Also I checked no changes were made to internal tables or foreign keys added.
message: \"the pg_net background worker must be up when doing requests\",
detail: Some(\"the pg_net background worker is down due to an internal error and cannot process requests\"),
hint: Some(\"make sure that you didn't modify any of pg_net internal tables or used them for foreign key references\"),
position: None,
where_: Some(\"PL/pgSQL function _check_worker_is_up() line 4 at RAISE\\nSQL statement \\\"insert into net.http_request_queue(method, url, headers, body, timeout_milliseconds)\\n values (\\n 'POST',\\n net._encode_url_with_params_array(url, params_array),\\n headers,\\n convert_to(body::text, 'UTF8'),\\n timeout_milliseconds\\n )\\n returning id\\\"\\nPL/pgSQL function http_post(text,jsonb,jsonb,jsonb,integer) line 42 at SQL statement\\nSQL statement \\\"SELECT http_post FROM net.http_post(\\n url,\\n payload,\\n params,\\n headers,\\n timeout_ms\\n )\\\"\\nPL/pgSQL function http_request() line 54 at SQL statement\"), schema: None,
table: None,
column: None,
datatype: None,
constraint: None,
file: Some(\"pl_exec.c\"),
line: Some(3859),
routine: Some(\"exec_stmt_raise\")
Needle
04/19/2022, 11:44 PM/title
command!
We have solved your problem?
Click the button below to archive it.silentworks
04/20/2022, 2:53 AMpg_net
in your database anywhere?Needle
04/20/2022, 2:53 AMkvnam
04/20/2022, 10:59 AMinformation_schema.triggers
table in the first place after deletion, but not showing up in the UI..?silentworks
04/20/2022, 10:12 PMNeedle
04/27/2022, 12:39 AM