2023-09-25 [Link] CEST [19442-1] spl_status_admin@spl_info_services LOG:

unexpected EOF on client connection with an open transaction

2023-09-25 [Link] CEST [19441-1] spl_status_admin@spl_info_services LOG:
unexpected EOF on client connection with an open transaction
2023-09-25 [Link] CEST [19438-1] spl_status_admin@spl_info_services LOG:
unexpected EOF on client connection with an open transaction
2023-09-25 [Link] CEST [19440-1] spl_status_admin@spl_info_services LOG:
unexpected EOF on client connection with an open transaction
2023-09-25 [Link] CEST [19443-1] spl_status_admin@spl_info_services LOG:
unexpected EOF on client connection with an open transaction
2023-09-25 [Link] CEST [28461-1] spl_status_admin@spl_info_services LOG:
unexpected EOF on client connection with an open transaction
2023-09-25 [Link] CEST [19439-1] spl_status_admin@spl_info_services LOG:
unexpected EOF on client connection with an open transaction
2023-09-25 [Link] CEST [19430-1] spl_status_admin@spl_info_services LOG:
unexpected EOF on client connection with an open transaction
2023-09-25 [Link] CEST [6284-1] postgres@etl_sanctions ERROR: missing FROM-
clause entry for table "dm_spl" at character 8
2023-09-25 [Link] CEST [6284-2] postgres@etl_sanctions STATEMENT: SELECT
dm_spl.ent_entity where program in (SELECT id FROM dm_spl.pro_program where code
Like 'TRAR%')
2023-09-25 [Link] CEST [6284-3] postgres@etl_sanctions ERROR: invalid input
syntax for type boolean: "UNAQA" at character 299
2023-09-25 [Link] CEST [6284-4] postgres@etl_sanctions STATEMENT: SELECT id as
"ent_id",tocustomerid, authorityid, originid, TO_CHAR(date, 'yyyy-MM-dd') as
"entrydate", TO_CHAR(validfrom, 'yyyy-MM-dd') as "validFrom" , TO_CHAR(validto,
'yyyy-MM-dd') as "validTo"
FROM dm_spl.ent_entity where program in (SELECT id FROM dm_spl.pro_program
where code = 'UNTAL' or 'UNAQA') order by authorityid
2023-09-25 [Link] CEST [7462-143] etl_update_user@etl_sanctions ERROR:
permission denied for relation idbfi_list
2023-09-25 [Link] CEST [7462-144] etl_update_user@etl_sanctions STATEMENT:
delete from dm_spl_IDBFI.IDBFI_LIST
2023-09-25 [Link] CEST [16822-1] etl_update_user@etl_sanctions LOG: unexpected
EOF on client connection with an open transaction
2023-09-25 [Link] CEST [16734-1] etl_update_user@etl_sanctions LOG: unexpected
EOF on client connection with an open transaction
2023-09-25 [Link] CEST [16547-1] etl_update_user@etl_sanctions LOG: unexpected
EOF on client connection with an open transaction
2023-09-25 [Link] CEST [16642-1] etl_update_user@etl_sanctions LOG: unexpected
EOF on client connection with an open transaction
2023-09-25 [Link] CEST [16451-1] etl_update_user@etl_sanctions LOG: unexpected
EOF on client connection with an open transaction
2023-09-25 [Link] CEST [16362-1] etl_update_user@etl_sanctions LOG: unexpected
EOF on client connection with an open transaction
2023-09-25 [Link] CEST [16098-1] etl_update_user@etl_sanctions LOG: unexpected
EOF on client connection with an open transaction
2023-09-25 [Link] CEST [15996-1] etl_update_user@etl_sanctions LOG: unexpected
EOF on client connection with an open transaction
2023-09-25 [Link] CEST [15553-1] etl_update_user@etl_sanctions LOG: unexpected
EOF on client connection with an open transaction
2023-09-25 [Link] CEST [16269-1] etl_update_user@etl_sanctions LOG: unexpected
EOF on client connection with an open transaction
2023-09-25 [Link] CEST [15459-1] etl_update_user@etl_sanctions LOG: unexpected
EOF on client connection with an open transaction
2023-09-25 [Link] CEST [15911-1] etl_update_user@etl_sanctions LOG: unexpected
EOF on client connection with an open transaction
2023-09-25 [Link] CEST [16178-1] etl_update_user@etl_sanctions LOG: unexpected
EOF on client connection with an open transaction
2023-09-25 [Link] CEST [13395-1] etl_update_user@etl_sanctions LOG: unexpected
EOF on client connection with an open transaction
2023-09-25 [Link] CEST [15727-1] etl_update_user@etl_sanctions LOG: unexpected
EOF on client connection with an open transaction
2023-09-25 [Link] CEST [15819-1] etl_update_user@etl_sanctions LOG: unexpected
EOF on client connection with an open transaction
2023-09-25 [Link] CEST [13339-1] etl_update_user@etl_sanctions LOG: unexpected
EOF on client connection with an open transaction
2023-09-25 [Link] CEST [15647-1] etl_update_user@etl_sanctions LOG: unexpected
EOF on client connection with an open transaction
2023-09-25 [Link] CEST [15334-1] etl_update_user@etl_sanctions LOG: unexpected
EOF on client connection with an open transaction
2023-09-25 [Link] CEST [15248-1] etl_update_user@etl_sanctions LOG: unexpected
EOF on client connection with an open transaction
2023-09-25 [Link] CEST [14092-1] etl_update_user@etl_info_services LOG:
unexpected EOF on client connection with an open transaction
2023-09-25 [Link] CEST [13226-1] etl_update_user@etl_sanctions LOG: unexpected
EOF on client connection with an open transaction
2023-09-25 [Link] CEST [13274-1] etl_update_user@etl_sanctions LOG: unexpected
EOF on client connection with an open transaction
2023-09-25 [Link] CEST [2376-1] spl_status_admin@spl_info_services WARNING:
there is no transaction in progress
2023-09-25 [Link] CEST [28569-1] etl_update_user@etl_info_services LOG:
unexpected EOF on client connection with an open transaction
2023-09-25 [Link] CEST [21578-1] etl_update_user@etl_info_services LOG:
unexpected EOF on client connection with an open transaction
2023-09-25 [Link] CEST [27589-1] _kuser@edc LOG: unexpected EOF on client
connection with an open transaction
2023-09-25 [Link] CEST [27544-1] etl_update_user@etl_sanctions LOG: unexpected
EOF on client connection with an open transaction
2023-09-25 [Link] CEST [7460-121] etl_update_user@etl_sanctions ERROR:
permission denied for relation usfdadp_list
2023-09-25 [Link] CEST [7460-122] etl_update_user@etl_sanctions STATEMENT:
delete from dm_spl_USFDADP.USFDADP_LIST
2023-09-25 [Link] CEST [7460-123] etl_update_user@etl_sanctions ERROR:
permission denied for relation usfdafi_list
2023-09-25 [Link] CEST [7460-124] etl_update_user@etl_sanctions STATEMENT:
delete from dm_spl_USFDAFI.USFDAFI_LIST
2023-09-26 [Link] CEST [2019-1] spl_status_admin@spl_info_services LOG:
unexpected EOF on client connection with an open transaction
2023-09-26 [Link] CEST [7460-125] etl_update_user@etl_sanctions ERROR:
permission denied for relation idbfi_list
2023-09-26 [Link] CEST [7460-126] etl_update_user@etl_sanctions STATEMENT:
delete from dm_spl_IDBFI.IDBFI_LIST
2023-09-26 [Link] CEST [2178-1] [unknown]@[unknown] LOG: invalid length of
startup packet
2023-09-26 [Link] CEST [4224-1] [unknown]@[unknown] LOG: invalid length of
startup packet
2023-09-26 [Link] CEST [4301-1] etl_read_user@etl_sanctions ERROR: column
"wait_event_type" does not exist at character 194
2023-09-26 [Link] CEST [4301-2] etl_read_user@etl_sanctions STATEMENT:
/*pga4dash*/
SELECT
pid,
datname,
usename,
application_name,
client_addr,
 pg_catalog.to_char(backend_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS
backend_start,
state,
wait_event_type || ': ' || wait_event AS wait_event,
array_to_string(pg_catalog.pg_blocking_pids(pid), ', ') AS blocking_pids,
query,
pg_catalog.to_char(state_change, 'YYYY-MM-DD HH24:MI:SS TZ') AS
state_change,
pg_catalog.to_char(query_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS
query_start,
pg_catalog.to_char(xact_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS xact_start,
backend_type,
CASE WHEN state = 'active' THEN ROUND((extract(epoch from now() -
query_start) / 60)::numeric, 2) ELSE 0 END AS active_since
FROM
pg_catalog.pg_stat_activity
ORDER BY pid
2023-09-26 [Link] CEST [4301-3] etl_read_user@etl_sanctions ERROR: function
pg_is_wal_replay_paused() does not exist at character 187
2023-09-26 [Link] CEST [4301-4] etl_read_user@etl_sanctions HINT: No function
matches the given name and argument types. You might need to add explicit type
casts.
2023-09-26 [Link] CEST [4301-5] etl_read_user@etl_sanctions STATEMENT: SELECT
CASE WHEN usesuper
THEN pg_catalog.pg_is_in_recovery()
ELSE FALSE
END as inrecovery,
CASE WHEN usesuper AND pg_catalog.pg_is_in_recovery()
THEN pg_is_wal_replay_paused()
ELSE FALSE
END as isreplaypaused
FROM pg_catalog.pg_user WHERE usename=current_user
2023-09-26 [Link] CEST [4591-1] etl_read_user@etl_sanctions ERROR: function
pg_is_wal_replay_paused() does not exist at character 187
2023-09-26 [Link] CEST [4591-2] etl_read_user@etl_sanctions HINT: No function
matches the given name and argument types. You might need to add explicit type
casts.
2023-09-26 [Link] CEST [4591-3] etl_read_user@etl_sanctions STATEMENT: SELECT
CASE WHEN usesuper
THEN pg_catalog.pg_is_in_recovery()
ELSE FALSE
END as inrecovery,
CASE WHEN usesuper AND pg_catalog.pg_is_in_recovery()
THEN pg_is_wal_replay_paused()
ELSE FALSE
END as isreplaypaused
FROM pg_catalog.pg_user WHERE usename=current_user
2023-09-26 [Link] CEST [4591-4] etl_read_user@etl_sanctions ERROR: column
"wait_event_type" does not exist at character 194
2023-09-26 [Link] CEST [4591-5] etl_read_user@etl_sanctions STATEMENT:
/*pga4dash*/
SELECT
pid,
datname,
usename,
application_name,
client_addr,
pg_catalog.to_char(backend_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS
backend_start,
 state,
wait_event_type || ': ' || wait_event AS wait_event,
array_to_string(pg_catalog.pg_blocking_pids(pid), ', ') AS blocking_pids,
query,
pg_catalog.to_char(state_change, 'YYYY-MM-DD HH24:MI:SS TZ') AS
state_change,
pg_catalog.to_char(query_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS
query_start,
pg_catalog.to_char(xact_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS xact_start,
backend_type,
CASE WHEN state = 'active' THEN ROUND((extract(epoch from now() -
query_start) / 60)::numeric, 2) ELSE 0 END AS active_since
FROM
pg_catalog.pg_stat_activity
ORDER BY pid
2023-09-26 [Link] CEST [4591-6] etl_read_user@etl_sanctions ERROR: column
"wait_event_type" does not exist at character 194
2023-09-26 [Link] CEST [4591-7] etl_read_user@etl_sanctions STATEMENT:
/*pga4dash*/
SELECT
pid,
datname,
usename,
application_name,
client_addr,
pg_catalog.to_char(backend_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS
backend_start,
state,
wait_event_type || ': ' || wait_event AS wait_event,
array_to_string(pg_catalog.pg_blocking_pids(pid), ', ') AS blocking_pids,
query,
pg_catalog.to_char(state_change, 'YYYY-MM-DD HH24:MI:SS TZ') AS
state_change,
pg_catalog.to_char(query_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS
query_start,
pg_catalog.to_char(xact_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS xact_start,
backend_type,
CASE WHEN state = 'active' THEN ROUND((extract(epoch from now() -
query_start) / 60)::numeric, 2) ELSE 0 END AS active_since
FROM
pg_catalog.pg_stat_activity
ORDER BY pid
2023-09-26 [Link] CEST [4591-8] etl_read_user@etl_sanctions ERROR: column
"wait_event_type" does not exist at character 194
2023-09-26 [Link] CEST [4591-9] etl_read_user@etl_sanctions STATEMENT:
/*pga4dash*/
SELECT
pid,
datname,
usename,
application_name,
client_addr,
pg_catalog.to_char(backend_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS
backend_start,
state,
wait_event_type || ': ' || wait_event AS wait_event,
array_to_string(pg_catalog.pg_blocking_pids(pid), ', ') AS blocking_pids,
query,
pg_catalog.to_char(state_change, 'YYYY-MM-DD HH24:MI:SS TZ') AS
state_change,
pg_catalog.to_char(query_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS
query_start,
pg_catalog.to_char(xact_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS xact_start,
backend_type,
CASE WHEN state = 'active' THEN ROUND((extract(epoch from now() -
query_start) / 60)::numeric, 2) ELSE 0 END AS active_since
FROM
pg_catalog.pg_stat_activity
ORDER BY pid
2023-09-26 [Link] CEST [4591-10] etl_read_user@etl_sanctions ERROR: column
"wait_event_type" does not exist at character 194
2023-09-26 [Link] CEST [4591-11] etl_read_user@etl_sanctions STATEMENT:
/*pga4dash*/
SELECT
pid,
datname,
usename,
application_name,
client_addr,
pg_catalog.to_char(backend_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS
backend_start,
state,
wait_event_type || ': ' || wait_event AS wait_event,
array_to_string(pg_catalog.pg_blocking_pids(pid), ', ') AS blocking_pids,
query,
pg_catalog.to_char(state_change, 'YYYY-MM-DD HH24:MI:SS TZ') AS
state_change,
pg_catalog.to_char(query_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS
query_start,
pg_catalog.to_char(xact_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS xact_start,
backend_type,
CASE WHEN state = 'active' THEN ROUND((extract(epoch from now() -
query_start) / 60)::numeric, 2) ELSE 0 END AS active_since
FROM
pg_catalog.pg_stat_activity
WHERE
datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid =
51500)ORDER BY pid
2023-09-26 [Link] CEST [4591-12] etl_read_user@etl_sanctions ERROR: column
"wait_event_type" does not exist at character 194
2023-09-26 [Link] CEST [4591-13] etl_read_user@etl_sanctions STATEMENT:
/*pga4dash*/
SELECT
pid,
datname,
usename,
application_name,
client_addr,
pg_catalog.to_char(backend_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS
backend_start,
state,
wait_event_type || ': ' || wait_event AS wait_event,
array_to_string(pg_catalog.pg_blocking_pids(pid), ', ') AS blocking_pids,
query,
pg_catalog.to_char(state_change, 'YYYY-MM-DD HH24:MI:SS TZ') AS
state_change,
pg_catalog.to_char(query_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS
query_start,
 pg_catalog.to_char(xact_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS xact_start,
backend_type,
CASE WHEN state = 'active' THEN ROUND((extract(epoch from now() -
query_start) / 60)::numeric, 2) ELSE 0 END AS active_since
FROM
pg_catalog.pg_stat_activity
WHERE
datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid =
51500)ORDER BY pid
2023-09-26 [Link] CEST [4591-14] etl_read_user@etl_sanctions ERROR: column
"wait_event_type" does not exist at character 194
2023-09-26 [Link] CEST [4591-15] etl_read_user@etl_sanctions STATEMENT:
/*pga4dash*/
SELECT
pid,
datname,
usename,
application_name,
client_addr,
pg_catalog.to_char(backend_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS
backend_start,
state,
wait_event_type || ': ' || wait_event AS wait_event,
array_to_string(pg_catalog.pg_blocking_pids(pid), ', ') AS blocking_pids,
query,
pg_catalog.to_char(state_change, 'YYYY-MM-DD HH24:MI:SS TZ') AS
state_change,
pg_catalog.to_char(query_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS
query_start,
pg_catalog.to_char(xact_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS xact_start,
backend_type,
CASE WHEN state = 'active' THEN ROUND((extract(epoch from now() -
query_start) / 60)::numeric, 2) ELSE 0 END AS active_since
FROM
pg_catalog.pg_stat_activity
WHERE
datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid =
51500)ORDER BY pid
2023-09-26 [Link] CEST [4591-16] etl_read_user@etl_sanctions ERROR: column
[Link] does not exist at character 833
2023-09-26 [Link] CEST [4591-17] etl_read_user@etl_sanctions STATEMENT: SELECT
[Link], [Link] AS name,
(SELECT count(*) FROM pg_catalog.pg_trigger WHERE tgrelid=[Link] AND
tgisinternal = FALSE) AS triggercount,
(SELECT count(*) FROM pg_catalog.pg_trigger WHERE tgrelid=[Link] AND
tgisinternal = FALSE AND tgenabled = 'O') AS has_enable_triggers,
(CASE WHEN [Link] = 'p' THEN true ELSE false END) AS is_partitioned,
(SELECT count(1) FROM pg_catalog.pg_inherits WHERE inhrelid=[Link] LIMIT
1) as is_inherits,
(SELECT count(1) FROM pg_catalog.pg_inherits WHERE inhparent=[Link]
LIMIT 1) as is_inherited,
[Link]
FROM pg_catalog.pg_class rel
LEFT OUTER JOIN pg_catalog.pg_description des ON ([Link]=[Link] AND
[Link]=0 AND [Link]='pg_class'::regclass)
WHERE [Link] IN ('r','s','t','p') AND [Link] = 2200::oid
AND NOT [Link]
ORDER BY [Link];
2023-09-26 [Link] CEST [4591-18] etl_read_user@etl_sanctions ERROR: column
"wait_event_type" does not exist at character 194
2023-09-26 [Link] CEST [4591-19] etl_read_user@etl_sanctions STATEMENT:
/*pga4dash*/
SELECT
pid,
datname,
usename,
application_name,
client_addr,
pg_catalog.to_char(backend_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS
backend_start,
state,
wait_event_type || ': ' || wait_event AS wait_event,
array_to_string(pg_catalog.pg_blocking_pids(pid), ', ') AS blocking_pids,
query,
pg_catalog.to_char(state_change, 'YYYY-MM-DD HH24:MI:SS TZ') AS
state_change,
pg_catalog.to_char(query_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS
query_start,
pg_catalog.to_char(xact_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS xact_start,
backend_type,
CASE WHEN state = 'active' THEN ROUND((extract(epoch from now() -
query_start) / 60)::numeric, 2) ELSE 0 END AS active_since
FROM
pg_catalog.pg_stat_activity
WHERE
datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid =
51500)ORDER BY pid
2023-09-26 [Link] CEST [4591-20] etl_read_user@etl_sanctions ERROR: column
"wait_event_type" does not exist at character 194
2023-09-26 [Link] CEST [4591-21] etl_read_user@etl_sanctions STATEMENT:
/*pga4dash*/
SELECT
pid,
datname,
usename,
application_name,
client_addr,
pg_catalog.to_char(backend_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS
backend_start,
state,
wait_event_type || ': ' || wait_event AS wait_event,
array_to_string(pg_catalog.pg_blocking_pids(pid), ', ') AS blocking_pids,
query,
pg_catalog.to_char(state_change, 'YYYY-MM-DD HH24:MI:SS TZ') AS
state_change,
pg_catalog.to_char(query_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS
query_start,
pg_catalog.to_char(xact_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS xact_start,
backend_type,
CASE WHEN state = 'active' THEN ROUND((extract(epoch from now() -
query_start) / 60)::numeric, 2) ELSE 0 END AS active_since
FROM
pg_catalog.pg_stat_activity
WHERE
datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid =
51500)ORDER BY pid
2023-09-26 [Link] CEST [4591-22] etl_read_user@etl_sanctions ERROR: column
"wait_event_type" does not exist at character 194
2023-09-26 [Link] CEST [4591-23] etl_read_user@etl_sanctions STATEMENT:
/*pga4dash*/
SELECT
pid,
datname,
usename,
application_name,
client_addr,
pg_catalog.to_char(backend_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS
backend_start,
state,
wait_event_type || ': ' || wait_event AS wait_event,
array_to_string(pg_catalog.pg_blocking_pids(pid), ', ') AS blocking_pids,
query,
pg_catalog.to_char(state_change, 'YYYY-MM-DD HH24:MI:SS TZ') AS
state_change,
pg_catalog.to_char(query_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS
query_start,
pg_catalog.to_char(xact_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS xact_start,
backend_type,
CASE WHEN state = 'active' THEN ROUND((extract(epoch from now() -
query_start) / 60)::numeric, 2) ELSE 0 END AS active_since
FROM
pg_catalog.pg_stat_activity
WHERE
datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid =
51500)ORDER BY pid
2023-09-26 [Link] CEST [4591-24] etl_read_user@etl_sanctions ERROR: column
[Link] does not exist at character 833
2023-09-26 [Link] CEST [4591-25] etl_read_user@etl_sanctions STATEMENT: SELECT
[Link], [Link] AS name,
(SELECT count(*) FROM pg_catalog.pg_trigger WHERE tgrelid=[Link] AND
tgisinternal = FALSE) AS triggercount,
(SELECT count(*) FROM pg_catalog.pg_trigger WHERE tgrelid=[Link] AND
tgisinternal = FALSE AND tgenabled = 'O') AS has_enable_triggers,
(CASE WHEN [Link] = 'p' THEN true ELSE false END) AS is_partitioned,
(SELECT count(1) FROM pg_catalog.pg_inherits WHERE inhrelid=[Link] LIMIT
1) as is_inherits,
(SELECT count(1) FROM pg_catalog.pg_inherits WHERE inhparent=[Link]
LIMIT 1) as is_inherited,
[Link]
FROM pg_catalog.pg_class rel
LEFT OUTER JOIN pg_catalog.pg_description des ON ([Link]=[Link] AND
[Link]=0 AND [Link]='pg_class'::regclass)
WHERE [Link] IN ('r','s','t','p') AND [Link] = 2200::oid
AND NOT [Link]
ORDER BY [Link];
2023-09-26 [Link] CEST [4591-26] etl_read_user@etl_sanctions ERROR: column
[Link] does not exist at character 833
2023-09-26 [Link] CEST [4591-27] etl_read_user@etl_sanctions STATEMENT: SELECT
[Link], [Link] AS name,
(SELECT count(*) FROM pg_catalog.pg_trigger WHERE tgrelid=[Link] AND
tgisinternal = FALSE) AS triggercount,
(SELECT count(*) FROM pg_catalog.pg_trigger WHERE tgrelid=[Link] AND
tgisinternal = FALSE AND tgenabled = 'O') AS has_enable_triggers,
(CASE WHEN [Link] = 'p' THEN true ELSE false END) AS is_partitioned,
(SELECT count(1) FROM pg_catalog.pg_inherits WHERE inhrelid=[Link] LIMIT
1) as is_inherits,
(SELECT count(1) FROM pg_catalog.pg_inherits WHERE inhparent=[Link]
LIMIT 1) as is_inherited,
[Link]
FROM pg_catalog.pg_class rel
LEFT OUTER JOIN pg_catalog.pg_description des ON ([Link]=[Link] AND
[Link]=0 AND [Link]='pg_class'::regclass)
WHERE [Link] IN ('r','s','t','p') AND [Link] = 2200::oid
AND NOT [Link]
ORDER BY [Link];
2023-09-26 [Link] CEST [4591-28] etl_read_user@etl_sanctions ERROR: column
"wait_event_type" does not exist at character 194
2023-09-26 [Link] CEST [4591-29] etl_read_user@etl_sanctions STATEMENT:
/*pga4dash*/
SELECT
pid,
datname,
usename,
application_name,
client_addr,
pg_catalog.to_char(backend_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS
backend_start,
state,
wait_event_type || ': ' || wait_event AS wait_event,
array_to_string(pg_catalog.pg_blocking_pids(pid), ', ') AS blocking_pids,
query,
pg_catalog.to_char(state_change, 'YYYY-MM-DD HH24:MI:SS TZ') AS
state_change,
pg_catalog.to_char(query_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS
query_start,
pg_catalog.to_char(xact_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS xact_start,
backend_type,
CASE WHEN state = 'active' THEN ROUND((extract(epoch from now() -
query_start) / 60)::numeric, 2) ELSE 0 END AS active_since
FROM
pg_catalog.pg_stat_activity
WHERE
datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid =
51500)ORDER BY pid
2023-09-26 [Link] CEST [4591-30] etl_read_user@etl_sanctions ERROR: column
"wait_event_type" does not exist at character 194
2023-09-26 [Link] CEST [4591-31] etl_read_user@etl_sanctions STATEMENT:
/*pga4dash*/
SELECT
pid,
datname,
usename,
application_name,
client_addr,
pg_catalog.to_char(backend_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS
backend_start,
state,
wait_event_type || ': ' || wait_event AS wait_event,
array_to_string(pg_catalog.pg_blocking_pids(pid), ', ') AS blocking_pids,
query,
pg_catalog.to_char(state_change, 'YYYY-MM-DD HH24:MI:SS TZ') AS
state_change,
pg_catalog.to_char(query_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS
query_start,
pg_catalog.to_char(xact_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS xact_start,
backend_type,
 CASE WHEN state = 'active' THEN ROUND((extract(epoch from now() -
query_start) / 60)::numeric, 2) ELSE 0 END AS active_since
FROM
pg_catalog.pg_stat_activity
WHERE
datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid =
51500)ORDER BY pid
2023-09-26 [Link] CEST [4591-32] etl_read_user@etl_sanctions ERROR: column
"wait_event_type" does not exist at character 194
2023-09-26 [Link] CEST [4591-33] etl_read_user@etl_sanctions STATEMENT:
/*pga4dash*/
SELECT
pid,
datname,
usename,
application_name,
client_addr,
pg_catalog.to_char(backend_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS
backend_start,
state,
wait_event_type || ': ' || wait_event AS wait_event,
array_to_string(pg_catalog.pg_blocking_pids(pid), ', ') AS blocking_pids,
query,
pg_catalog.to_char(state_change, 'YYYY-MM-DD HH24:MI:SS TZ') AS
state_change,
pg_catalog.to_char(query_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS
query_start,
pg_catalog.to_char(xact_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS xact_start,
backend_type,
CASE WHEN state = 'active' THEN ROUND((extract(epoch from now() -
query_start) / 60)::numeric, 2) ELSE 0 END AS active_since
FROM
pg_catalog.pg_stat_activity
WHERE
datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid =
51500)ORDER BY pid
2023-09-26 [Link] CEST [4591-34] etl_read_user@etl_sanctions ERROR: column
[Link] does not exist at character 837
2023-09-26 [Link] CEST [4591-35] etl_read_user@etl_sanctions STATEMENT: SELECT
[Link], [Link] AS name,
(SELECT count(*) FROM pg_catalog.pg_trigger WHERE tgrelid=[Link] AND
tgisinternal = FALSE) AS triggercount,
(SELECT count(*) FROM pg_catalog.pg_trigger WHERE tgrelid=[Link] AND
tgisinternal = FALSE AND tgenabled = 'O') AS has_enable_triggers,
(CASE WHEN [Link] = 'p' THEN true ELSE false END) AS is_partitioned,
(SELECT count(1) FROM pg_catalog.pg_inherits WHERE inhrelid=[Link] LIMIT
1) as is_inherits,
(SELECT count(1) FROM pg_catalog.pg_inherits WHERE inhparent=[Link]
LIMIT 1) as is_inherited,
[Link]
FROM pg_catalog.pg_class rel
LEFT OUTER JOIN pg_catalog.pg_description des ON ([Link]=[Link] AND
[Link]=0 AND [Link]='pg_class'::regclass)
WHERE [Link] IN ('r','s','t','p') AND [Link] =
41502072::oid
AND NOT [Link]
ORDER BY [Link];
2023-09-26 [Link] CEST [4591-36] etl_read_user@etl_sanctions ERROR: column
"wait_event_type" does not exist at character 194
2023-09-26 [Link] CEST [4591-37] etl_read_user@etl_sanctions STATEMENT:
/*pga4dash*/
SELECT
pid,
datname,
usename,
application_name,
client_addr,
pg_catalog.to_char(backend_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS
backend_start,
state,
wait_event_type || ': ' || wait_event AS wait_event,
array_to_string(pg_catalog.pg_blocking_pids(pid), ', ') AS blocking_pids,
query,
pg_catalog.to_char(state_change, 'YYYY-MM-DD HH24:MI:SS TZ') AS
state_change,
pg_catalog.to_char(query_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS
query_start,
pg_catalog.to_char(xact_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS xact_start,
backend_type,
CASE WHEN state = 'active' THEN ROUND((extract(epoch from now() -
query_start) / 60)::numeric, 2) ELSE 0 END AS active_since
FROM
pg_catalog.pg_stat_activity
WHERE
datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid =
51500)ORDER BY pid
2023-09-26 [Link] CEST [4591-38] etl_read_user@etl_sanctions ERROR: column
[Link] does not exist at character 837
2023-09-26 [Link] CEST [4591-39] etl_read_user@etl_sanctions STATEMENT: SELECT
[Link], [Link] AS name,
(SELECT count(*) FROM pg_catalog.pg_trigger WHERE tgrelid=[Link] AND
tgisinternal = FALSE) AS triggercount,
(SELECT count(*) FROM pg_catalog.pg_trigger WHERE tgrelid=[Link] AND
tgisinternal = FALSE AND tgenabled = 'O') AS has_enable_triggers,
(CASE WHEN [Link] = 'p' THEN true ELSE false END) AS is_partitioned,
(SELECT count(1) FROM pg_catalog.pg_inherits WHERE inhrelid=[Link] LIMIT
1) as is_inherits,
(SELECT count(1) FROM pg_catalog.pg_inherits WHERE inhparent=[Link]
LIMIT 1) as is_inherited,
[Link]
FROM pg_catalog.pg_class rel
LEFT OUTER JOIN pg_catalog.pg_description des ON ([Link]=[Link] AND
[Link]=0 AND [Link]='pg_class'::regclass)
WHERE [Link] IN ('r','s','t','p') AND [Link] =
41502072::oid
AND NOT [Link]
ORDER BY [Link];
2023-09-26 [Link] CEST [4591-40] etl_read_user@etl_sanctions ERROR: column
"wait_event_type" does not exist at character 194
2023-09-26 [Link] CEST [4591-41] etl_read_user@etl_sanctions STATEMENT:
/*pga4dash*/
SELECT
pid,
datname,
usename,
application_name,
client_addr,
pg_catalog.to_char(backend_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS
backend_start,
state,
wait_event_type || ': ' || wait_event AS wait_event,
array_to_string(pg_catalog.pg_blocking_pids(pid), ', ') AS blocking_pids,
query,
pg_catalog.to_char(state_change, 'YYYY-MM-DD HH24:MI:SS TZ') AS
state_change,
pg_catalog.to_char(query_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS
query_start,
pg_catalog.to_char(xact_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS xact_start,
backend_type,
CASE WHEN state = 'active' THEN ROUND((extract(epoch from now() -
query_start) / 60)::numeric, 2) ELSE 0 END AS active_since
FROM
pg_catalog.pg_stat_activity
WHERE
datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid =
51500)ORDER BY pid
2023-09-26 [Link] CEST [4591-42] etl_read_user@etl_sanctions ERROR: column
"wait_event_type" does not exist at character 194
2023-09-26 [Link] CEST [4591-43] etl_read_user@etl_sanctions STATEMENT:
/*pga4dash*/
SELECT
pid,
datname,
usename,
application_name,
client_addr,
pg_catalog.to_char(backend_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS
backend_start,
state,
wait_event_type || ': ' || wait_event AS wait_event,
array_to_string(pg_catalog.pg_blocking_pids(pid), ', ') AS blocking_pids,
query,
pg_catalog.to_char(state_change, 'YYYY-MM-DD HH24:MI:SS TZ') AS
state_change,
pg_catalog.to_char(query_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS
query_start,
pg_catalog.to_char(xact_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS xact_start,
backend_type,
CASE WHEN state = 'active' THEN ROUND((extract(epoch from now() -
query_start) / 60)::numeric, 2) ELSE 0 END AS active_since
FROM
pg_catalog.pg_stat_activity
WHERE
datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid =
51500)ORDER BY pid
2023-09-26 [Link] CEST [8551-1] etl_read_user@etl_sanctions LOG: could not
receive data from client: Connection reset by peer
2023-09-26 [Link] CEST [7935-1] etl_read_user@etl_sanctions LOG: could not
receive data from client: Connection reset by peer
2023-09-26 [Link] CEST [8423-1] etl_read_user@etl_sanctions LOG: could not
receive data from client: Connection reset by peer
2023-09-26 [Link] CEST [4591-44] etl_read_user@etl_sanctions LOG: could not
receive data from client: Connection reset by peer
2023-09-26 [Link] CEST [7460-127] etl_update_user@etl_sanctions ERROR:
permission denied for relation usfdadp_list
2023-09-26 [Link] CEST [7460-128] etl_update_user@etl_sanctions STATEMENT:
delete from dm_spl_USFDADP.USFDADP_LIST
2023-09-26 [Link] CEST [7460-129] etl_update_user@etl_sanctions ERROR:
permission denied for relation usfdafi_list
2023-09-26 [Link] CEST [7460-130] etl_update_user@etl_sanctions STATEMENT:
delete from dm_spl_USFDAFI.USFDAFI_LIST
2023-09-27 [Link] CEST [31295-1] etl_read_user@etl_sanctions LOG: could not
receive data from client: Connection reset by peer
2023-09-27 [Link] CEST [2087-1] etl_read_user@etl_sanctions LOG: could not
receive data from client: Connection reset by peer
2023-09-27 [Link] CEST [31294-1] etl_read_user@etl_sanctions LOG: could not
receive data from client: Connection reset by peer
2023-09-27 [Link] CEST [31299-1] etl_read_user@etl_sanctions LOG: could not
receive data from client: Connection reset by peer
2023-09-27 [Link] CEST [31296-1] etl_read_user@etl_sanctions LOG: could not
receive data from client: Connection reset by peer
2023-09-27 [Link] CEST [31298-1] etl_read_user@etl_sanctions LOG: could not
receive data from client: Connection reset by peer
2023-09-27 [Link] CEST [2086-1] etl_read_user@etl_sanctions LOG: could not
receive data from client: Connection reset by peer
2023-09-27 [Link] CEST [31297-1] etl_read_user@etl_sanctions LOG: could not
receive data from client: Connection reset by peer
2023-09-27 [Link] CEST [11439-1] spl_status_admin@spl_info_services LOG:
unexpected EOF on client connection with an open transaction
2023-09-27 [Link] CEST [7458-115] etl_update_user@etl_sanctions ERROR:
permission denied for relation idbfi_list
2023-09-27 [Link] CEST [7458-116] etl_update_user@etl_sanctions STATEMENT:
delete from dm_spl_IDBFI.IDBFI_LIST
2023-09-27 [Link] CEST [7458-117] etl_update_user@etl_sanctions ERROR:
permission denied for relation usfdadp_list
2023-09-27 [Link] CEST [7458-118] etl_update_user@etl_sanctions STATEMENT:
delete from dm_spl_USFDADP.USFDADP_LIST
2023-09-27 [Link] CEST [7458-119] etl_update_user@etl_sanctions ERROR:
permission denied for relation usfdafi_list
2023-09-27 [Link] CEST [7458-120] etl_update_user@etl_sanctions STATEMENT:
delete from dm_spl_USFDAFI.USFDAFI_LIST
2023-09-28 [Link] CEST [8624-1] spl_status_admin@spl_info_services WARNING:
there is no transaction in progress
2023-09-28 [Link] CEST [7459-123] etl_update_user@etl_sanctions ERROR:
permission denied for relation idbfi_list
2023-09-28 [Link] CEST [7459-124] etl_update_user@etl_sanctions STATEMENT:
delete from dm_spl_IDBFI.IDBFI_LIST
2023-09-28 [Link] CEST [26095-1] spl_status_admin@spl_info_services LOG:
unexpected EOF on client connection with an open transaction
2023-09-28 [Link] CEST [7459-125] etl_update_user@etl_sanctions ERROR:
permission denied for relation usfdadp_list
2023-09-28 [Link] CEST [7459-126] etl_update_user@etl_sanctions STATEMENT:
delete from dm_spl_USFDADP.USFDADP_LIST
2023-09-28 [Link] CEST [7459-127] etl_update_user@etl_sanctions ERROR:
permission denied for relation usfdafi_list
2023-09-28 [Link] CEST [7459-128] etl_update_user@etl_sanctions STATEMENT:
delete from dm_spl_USFDAFI.USFDAFI_LIST
2023-09-29 [Link] CEST [7458-121] etl_update_user@etl_sanctions ERROR:
permission denied for relation idbfi_list
2023-09-29 [Link] CEST [7458-122] etl_update_user@etl_sanctions STATEMENT:
delete from dm_spl_IDBFI.IDBFI_LIST
2023-09-29 [Link] CEST [9629-1] spl_status_admin@spl_info_services LOG:
unexpected EOF on client connection with an open transaction
2023-09-29 [Link] CEST [7458-123] etl_update_user@etl_sanctions ERROR:
permission denied for relation usfdadp_list
2023-09-29 [Link] CEST [7458-124] etl_update_user@etl_sanctions STATEMENT:
delete from dm_spl_USFDADP.USFDADP_LIST
2023-09-29 [Link] CEST [7458-125] etl_update_user@etl_sanctions ERROR:
permission denied for relation usfdafi_list
2023-09-29 [Link] CEST [7458-126] etl_update_user@etl_sanctions STATEMENT:
delete from dm_spl_USFDAFI.USFDAFI_LIST
2023-09-30 [Link] CEST [7458-127] etl_update_user@etl_sanctions ERROR:
permission denied for relation idbfi_list
2023-09-30 [Link] CEST [7458-128] etl_update_user@etl_sanctions STATEMENT:
delete from dm_spl_IDBFI.IDBFI_LIST
2023-09-30 [Link] CEST [25646-1] spl_status_admin@spl_info_services LOG: could
not send data to client: Connection reset by peer
2023-09-30 [Link] CEST [25646-2] spl_status_admin@spl_info_services STATEMENT:
select this_.id as id1_1_8_, this_.insertTS as insertTS2_1_8_, this_.updateTS as
updateTS3_1_8_, this_.version as version4_1_8_, this_.createdBy as createdB5_1_8_,
this_.cronJob as cronJob6_1_8_, this_.cssSelector as cssSelec7_1_8_,
this_.description as descript8_1_8_, this_.description_code as descript9_1_8_,
this_.email as email10_1_8_, this_.filteredXpaths as filtere11_1_8_,
this_.reTryCount as reTryCo12_1_8_, this_.reTryTimeOut as reTryTi13_1_8_,
this_.seleniumScript as seleniu14_1_8_, this_.timeout as timeout15_1_8_,
this_.updatedBy as updated16_1_8_, this_.use_tor as use_tor17_1_8_, this_.uuid as
uuid18_1_8_, this_.xpath as xpath19_1_8_, jobtrigert2_.jobDetailsID as
jobDetai4_5_10_, jobtrigert2_.id as id1_5_10_, jobtrigert2_.id as id1_5_0_,
jobtrigert2_.RestJobTriggerID as RestJobT2_5_0_, jobtrigert2_.emailJobTriggerID as
emailJob3_5_0_, jobtrigert2_.jobDetailsID as jobDetai4_5_0_,
jobtrigert2_.kafkaJobTriggerID as kafkaJob5_5_0_, restjobtri3_.id as id1_4_1_,
restjobtri3_.description as descript2_4_1_, restjobtri3_.restCallUrl as
restCall3_4_1_, emailjobtr4_.id as id1_0_2_, emailjobtr4_.description as
descript2_0_2_, emailjobtr4_.email as email3_0_2_, kafkajobtr5_.id as id1_2_3_,
kafkajobtr5_.broker as broker2_2_3_, kafkajobtr5_.description as descript3_2_3_,
kafkajobtr5_.topic as topic4_2_3_, urls6_.jobDetailID as jobDeta15_6_11_, urls6_.id
as id1_6_11_, urls6_.id as id1_6_4_, urls6_.insertTS as insertTS2_6_4_,
urls6_.updateTS as updateTS3_6_4_, urls6_.version as version4_6_4_,
urls6_.accessCount as accessCo5_6_4_, urls6_.is_archived as is_archi6_6_4_,
urls6_.info_Email as info_Ema7_6_4_, urls6_.pt_isredirect as pt_isred8_6_4_,
urls6_.jobDetailID as jobDeta15_6_4_, urls6_.LastChecked as LastChec9_6_4_,
urls6_.http_status as http_st10_6_4_, urls6_.md5 as md11_6_4_, urls6_.redirected_id
as redirec16_6_4_, urls6_.url as url12_6_4_, urls6_.uuid as uuid13_6_4_,
urls6_.WebPageNotAvailableDate as WebPage14_6_4_, urlid7_.URLID_id as
URLID_id2_9_12_, urlid7_.id as id1_9_12_, urlid7_.id as id1_9_5_, urlid7_.URLID_id
as URLID_id2_9_5_, urlid7_.warcArchiveId as warcArch3_9_5_, warcarchiv8_.id as
id1_7_6_, warcarchiv8_.insertTS as insertTS2_7_6_, warcarchiv8_.updateTS as
updateTS3_7_6_, warcarchiv8_.version as version4_7_6_, warcarchiv8_.date as
date5_7_6_, warcarchiv8_.dynamic_url as dynamic_6_7_6_, warcarchiv8_.path as
path7_7_6_, warcarchiv8_.screenShotimage as screenSh8_7_6_, warcarchiv8_.uuid as
uuid9_7_6_, url9_.id as id1_6_7_, url9_.insertTS as insertTS2_6_7_, url9_.updateTS
as updateTS3_6_7_, url9_.version as version4_6_7_, url9_.accessCount as
accessCo5_6_7_, url9_.is_archived as is_archi6_6_7_, url9_.info_Email as
info_Ema7_6_7_, url9_.pt_isredirect as pt_isred8_6_7_, url9_.jobDetailID as
jobDeta15_6_7_, url9_.LastChecked as LastChec9_6_7_, url9_.http_status as
http_st10_6_7_, url9_.md5 as md11_6_7_, url9_.redirected_id as redirec16_6_7_,
url9_.url as url12_6_7_, url9_.uuid as uuid13_6_7_, url9_.WebPageNotAvailableDate
as WebPage14_6_7_ from link_mon.jobDetails this_ left outer join
link_mon.TrigerTo_JobDetails jobtrigert2_ on this_.id=jobtrigert2_.jobDetailsID
left outer join link_mon.RestJobTrigger restjobtri3_ on
jobtrigert2_.RestJobTriggerID=restjobtri3_.id left outer join
link_mon.EmailJobTrigger emailjobtr4_ on
jobtrigert2_.emailJobTriggerID=emailjobtr4_.id left outer join
link_mon.KafkaJobTrigger kafkajobtr5_ on
jobtrigert2_.kafkaJobTriggerID=kafkajobtr5_.id left outer join link_mon.URL urls6_
on this_.id=urls6_.jobDetailID left outer join link_mon.WARCTo_URL urlid7_ on
urls6_.id=urlid7_.URLID_id left outer join link_mon.WARC_ARCHIVE warcarchiv8_ on
urlid7_.warcArchiveId=warcarchiv8_.id left outer join link_mon.URL url9_ on
urls6_.redirected_id=url9_.id where this_.uuid=$1
2023-09-30 [Link] CEST [25646-3] spl_status_admin@spl_info_services FATAL:
connection to client lost
2023-09-30 [Link] CEST [25646-4] spl_status_admin@spl_info_services STATEMENT:
select this_.id as id1_1_8_, this_.insertTS as insertTS2_1_8_, this_.updateTS as
updateTS3_1_8_, this_.version as version4_1_8_, this_.createdBy as createdB5_1_8_,
this_.cronJob as cronJob6_1_8_, this_.cssSelector as cssSelec7_1_8_,
this_.description as descript8_1_8_, this_.description_code as descript9_1_8_,
this_.email as email10_1_8_, this_.filteredXpaths as filtere11_1_8_,
this_.reTryCount as reTryCo12_1_8_, this_.reTryTimeOut as reTryTi13_1_8_,
this_.seleniumScript as seleniu14_1_8_, this_.timeout as timeout15_1_8_,
this_.updatedBy as updated16_1_8_, this_.use_tor as use_tor17_1_8_, this_.uuid as
uuid18_1_8_, this_.xpath as xpath19_1_8_, jobtrigert2_.jobDetailsID as
jobDetai4_5_10_, jobtrigert2_.id as id1_5_10_, jobtrigert2_.id as id1_5_0_,
jobtrigert2_.RestJobTriggerID as RestJobT2_5_0_, jobtrigert2_.emailJobTriggerID as
emailJob3_5_0_, jobtrigert2_.jobDetailsID as jobDetai4_5_0_,
jobtrigert2_.kafkaJobTriggerID as kafkaJob5_5_0_, restjobtri3_.id as id1_4_1_,
restjobtri3_.description as descript2_4_1_, restjobtri3_.restCallUrl as
restCall3_4_1_, emailjobtr4_.id as id1_0_2_, emailjobtr4_.description as
descript2_0_2_, emailjobtr4_.email as email3_0_2_, kafkajobtr5_.id as id1_2_3_,
kafkajobtr5_.broker as broker2_2_3_, kafkajobtr5_.description as descript3_2_3_,
kafkajobtr5_.topic as topic4_2_3_, urls6_.jobDetailID as jobDeta15_6_11_, urls6_.id
as id1_6_11_, urls6_.id as id1_6_4_, urls6_.insertTS as insertTS2_6_4_,
urls6_.updateTS as updateTS3_6_4_, urls6_.version as version4_6_4_,
urls6_.accessCount as accessCo5_6_4_, urls6_.is_archived as is_archi6_6_4_,
urls6_.info_Email as info_Ema7_6_4_, urls6_.pt_isredirect as pt_isred8_6_4_,
urls6_.jobDetailID as jobDeta15_6_4_, urls6_.LastChecked as LastChec9_6_4_,
urls6_.http_status as http_st10_6_4_, urls6_.md5 as md11_6_4_, urls6_.redirected_id
as redirec16_6_4_, urls6_.url as url12_6_4_, urls6_.uuid as uuid13_6_4_,
urls6_.WebPageNotAvailableDate as WebPage14_6_4_, urlid7_.URLID_id as
URLID_id2_9_12_, urlid7_.id as id1_9_12_, urlid7_.id as id1_9_5_, urlid7_.URLID_id
as URLID_id2_9_5_, urlid7_.warcArchiveId as warcArch3_9_5_, warcarchiv8_.id as
id1_7_6_, warcarchiv8_.insertTS as insertTS2_7_6_, warcarchiv8_.updateTS as
updateTS3_7_6_, warcarchiv8_.version as version4_7_6_, warcarchiv8_.date as
date5_7_6_, warcarchiv8_.dynamic_url as dynamic_6_7_6_, warcarchiv8_.path as
path7_7_6_, warcarchiv8_.screenShotimage as screenSh8_7_6_, warcarchiv8_.uuid as
uuid9_7_6_, url9_.id as id1_6_7_, url9_.insertTS as insertTS2_6_7_, url9_.updateTS
as updateTS3_6_7_, url9_.version as version4_6_7_, url9_.accessCount as
accessCo5_6_7_, url9_.is_archived as is_archi6_6_7_, url9_.info_Email as
info_Ema7_6_7_, url9_.pt_isredirect as pt_isred8_6_7_, url9_.jobDetailID as
jobDeta15_6_7_, url9_.LastChecked as LastChec9_6_7_, url9_.http_status as
http_st10_6_7_, url9_.md5 as md11_6_7_, url9_.redirected_id as redirec16_6_7_,
url9_.url as url12_6_7_, url9_.uuid as uuid13_6_7_, url9_.WebPageNotAvailableDate
as WebPage14_6_7_ from link_mon.jobDetails this_ left outer join
link_mon.TrigerTo_JobDetails jobtrigert2_ on this_.id=jobtrigert2_.jobDetailsID
left outer join link_mon.RestJobTrigger restjobtri3_ on
jobtrigert2_.RestJobTriggerID=restjobtri3_.id left outer join
link_mon.EmailJobTrigger emailjobtr4_ on
jobtrigert2_.emailJobTriggerID=emailjobtr4_.id left outer join
link_mon.KafkaJobTrigger kafkajobtr5_ on
jobtrigert2_.kafkaJobTriggerID=kafkajobtr5_.id left outer join link_mon.URL urls6_
on this_.id=urls6_.jobDetailID left outer join link_mon.WARCTo_URL urlid7_ on
urls6_.id=urlid7_.URLID_id left outer join link_mon.WARC_ARCHIVE warcarchiv8_ on
urlid7_.warcArchiveId=warcarchiv8_.id left outer join link_mon.URL url9_ on
urls6_.redirected_id=url9_.id where this_.uuid=$1
2023-09-30 [Link] CEST [7458-129] etl_update_user@etl_sanctions ERROR:
permission denied for relation usfdadp_list
2023-09-30 [Link] CEST [7458-130] etl_update_user@etl_sanctions STATEMENT:
delete from dm_spl_USFDADP.USFDADP_LIST
2023-09-30 [Link] CEST [7458-131] etl_update_user@etl_sanctions ERROR:
permission denied for relation usfdafi_list
2023-09-30 [Link] CEST [7458-132] etl_update_user@etl_sanctions STATEMENT:
delete from dm_spl_USFDAFI.USFDAFI_LIST
2023-10-01 [Link] CEST [660-1] spl_status_admin@spl_info_services WARNING: there
is no transaction in progress
2023-10-01 [Link] CEST [664-1] spl_status_admin@spl_info_services WARNING: there
is no transaction in progress