Rodolfo
10/04/2024, 8:39 AMvroldanbet
10/04/2024, 10:48 AMvroldanbet
10/04/2024, 10:48 AMRodolfo
10/04/2024, 10:52 AMvroldanbet
10/04/2024, 10:59 AMRodolfo
10/04/2024, 4:45 PMdo $$ begin assert (select pg_xact_status(824::text::xid8) != 'in progress'), 'replica missing revision';end;$$;SELECT serialized_config, created_xid FROM namespace_config WHERE pg_visible_in_snapshot(created_xid, '825:825:' ) = 't' AND pg_visible_in_snapshot(deleted_xid, '825:825:' ) = 'f' AND (namespace = 'teste' )
and outputs no serialized config and` xid 823`
in v34 the query is a bit different
SELECT serialized_config, created_xid FROM namespace_config WHERE pg_visible_in_snapshot(created_xid, $1) = $2 AND pg_visible_in_snapshot(deleted_xid, $3) = $4 AND (namespace = $5)
2024-10-04 16:26:06.185 GMT [3056] DETAIL: parameters: $1 = '825:825:', $2 = 't', $3 = '825:825:', $4 = 'f', $5 = 'teste'
the output is the same.
From here v34, continues to a select from relation_tuple
but v35 does not.
Do you have any theory?vroldanbet
10/04/2024, 4:48 PMvroldanbet
10/04/2024, 4:49 PMvroldanbet
10/04/2024, 4:50 PMRodolfo
10/04/2024, 4:52 PMRodolfo
10/04/2024, 4:53 PMurl: "postgres://postgres:postgres@supreme-authorisation-service-postgresql:5432/myDatabase?sslmode=disable"
readonly_url: "postgres://postgres:postgres@supreme-authorisation-service-postgresql:5432/myDatabase?sslmode=disable"
Rodolfo
10/04/2024, 4:54 PMJoey
10/04/2024, 5:03 PMJoey
10/04/2024, 5:03 PMJoey
10/04/2024, 5:05 PMJoey
10/04/2024, 5:05 PMJoey
10/04/2024, 5:05 PMRodolfo
10/05/2024, 3:39 PMRodolfo
10/05/2024, 3:41 PMJoey
10/05/2024, 4:07 PMJoey
10/05/2024, 4:08 PMJoey
10/05/2024, 4:08 PM