Fwd: [PostgreSQL 12.5] - Invalid memory alloc request size 8589934668

Olá pessoal,

Estou recebendo alguns erros de invalid memory alloc e acredito que possa
ser um bug.

Estou usando o *PostgreSQL 12..5* com as extensões

sgpa_gis=# \dx
List of installed extensions
Name | Version | Schema |
Description
------------+---------+------------+---------------------------------------------------------------------
btree_gist | 1.5 | public | support for indexing common datatypes
in GiST
oracle_fdw | 1.2 | public | foreign data wrapper for Oracle access
pg_cron | 1.3 | public | Job scheduler for PostgreSQL
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
*postgis | 3.0.1 | public | PostGIS geometry, geography, and
raster spatial types and functions*
(5 rows)

Banco de dados com *4Tb*

O erro acontece no *PostgreSQL 12.3 *tb, já testei no *Centos 7.8 e 7.9* e
mesma coisa, já foi feito DUMP/Restore e o mesmo erro acontece. Até o
momento não impacta no negócio, porém lança erro para algumas tabelas
sempre que um autovacuum roda, principalmente por causa do Analyze.

Segue estrutura da tabela

CREATE TABLE sgpa_map.ddn_pluviometro_cliente165_teste (
cd_id bigint DEFAULT
nextval('sgpa_map.ddn_pluviometro_cd_id_seq'::regclass) NOT NULL,
cd_cliente integer DEFAULT '-1'::integer NOT NULL,
cd_equipamento character varying(15),
cd_zona character varying(10),
cd_fazenda character varying(10),
cd_talhao character varying(10),
dt_hr_local timestamp without time zone NOT NULL,
dt_hr_utc timestamp without time zone,
dt_hr_servidor timestamp without time zone,
vl_latitude numeric(18,10),
vl_longitude numeric(18,10),
vl_velocidade_vento text,
vl_temperatura text,
vl_umidade text,
vl_ponto_orvalho text,
cd_id_origem bigint,
dt_created timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
*ponto public.geometry(Point,4326)*
);

Essa tabela é atachada em uma tabela pai. quando isso acontece o erro
começa.

sgpa_gis=# analyze sgpa_map.ddn_pluviometro_cliente165_teste;*
----------Tabela nova sem ser atachada na tabela pai*
ANALYZE

sgpa_gis=# ALTER TABLE ONLY sgpa_map.ddn_pluviometro ATTACH PARTITION
sgpa_map.ddn_pluviometro_cliente165_teste FOR VALUES IN (-1); *----
Atachando tabela filha a tabela pai*
ALTER TABLE

sgpa_gis=# analyze sgpa_map.ddn_pluviometro_cliente165_teste; *
------ Erro rolando*
ERROR: invalid memory alloc request size 8589934668

sgpa_gis=# truncate sgpa_map.ddn_pluviometro_cliente165_teste;
*-------------
Truncar a tabela*
TRUNCATE TABLE

sgpa_gis=# analyze sgpa_map.ddn_pluviometro_cliente165_teste; *--------------
Tabela zerada Analyze funciona*
ANALYZE

sgpa_gis=# insert into sgpa_map.ddn_pluviometro_cliente165_teste select *
from sgpa_map.ddn_pluviometro_cliente165; *----Repopulando a tabela já
particionada*
INSERT 0 225616

sgpa_gis=# analyze sgpa_map.ddn_pluviometro_cliente165_teste; *----- Erro
volta*
ERROR: invalid memory alloc request size 8589934668

O Erro só acontece com ANALYZE, então os comandos ANALYZE e VACUUM ANALYZE
geram esse erro. O Vacuum ou Vacuum FULL funcionam normalmente.

Também fiz o teste com ANALYZE passando campo por campo para ver qual
campos dava o erro. Percebi que somente os campos que geram TOAST davam o
erro, principalmente os GEOMETRY. Tentei aumentar o parâmetro
TOAST_TUPLE_THRESHOLD
para evitar fazer TOAST e tentar assim resolver, porém não rolou.

Abaixo segue log de erro com DEBUG 5, o log de erro é de *outra tabela que
reflete a mesma situação. *

sgpa_gis=# VACUUM sgpa_map.ddn_pluviometro_cliente40;
VACUUM
sgpa_gis=# VACUUM FULL sgpa_map.ddn_pluviometro_cliente40;
VACUUM
sgpa_gis=# VACUUM ANALYZE sgpa_map.ddn_pluviometro_cliente40;
ERROR: invalid memory alloc request size 8589934668
sgpa_gis=# ANALYZE sgpa_map.ddn_pluviometro_cliente40;
ERROR: invalid memory alloc request size 8589934668

2021-01-24 04:07:02 -03 [42334]: [1]
db=[unknown],user=[unknown],host=[local] LOG: connection received:
host=[local]
2021-01-24 04:07:02 -03 [42334]: [2] db=sgpa_gis,user=postgres,host=[local]
LOG: connection authorized: user=postgres database=sgpa_gis
application_name=pg_cron
2021-01-24 04:07:02 -03 [42334]: [3] db=sgpa_gis,user=postgres,host=[local]
LOG: statement: /*(000022.01-PILOTO_BASEGRAOS)IMPORT CADASTROS ORACLE
(MOD3)*/call sgpa_map.prc_process_ora_cdt(22);
2021-01-24 04:07:02 -03 [42334]: [4] db=sgpa_gis,user=postgres,host=[local]
LOG: duration: 313.362 ms
2021-01-24 04:07:02 -03 [42334]: [5] db=sgpa_gis,user=postgres,host=[local]
LOG: disconnection: session time: 0:00:00.717 user=postgres
database=sgpa_gis host=[local]
2021-01-24 08:45:00 -03 [42334]: [1]
db=[unknown],user=[unknown],host=[local] LOG: connection received:
host=[local]
2021-01-24 08:45:00 -03 [42334]: [2] db=sgpa_gis,user=postgres,host=[local]
LOG: connection authorized: user=postgres database=sgpa_gis
application_name=pg_cron
2021-01-24 08:45:00 -03 [42334]: [4] db=sgpa_gis,user=postgres,host=[local]
NOTICE: SUCESS : 127 2021-01-24 08:45:00.797725-03
2021-01-24 08:45:00 -03 [42334]: [5] db=sgpa_gis,user=postgres,host=[local]
CONTEXT: PL/pgSQL function sgpa_map.prc_caida_semente(integer) line 103 at
RAISE
2021-01-24 08:45:00 -03 [42334]: [7] db=sgpa_gis,user=postgres,host=[local]
LOG: duration: 247.632 ms
2021-01-24 08:45:00 -03 [42334]: [8] db=sgpa_gis,user=postgres,host=[local]
LOG: disconnection: session time: 0:00:00.256 user=postgres
database=sgpa_gis host=[local]
2021-01-24 12:31:03 -03 [42334]: [1]
db=[unknown],user=[unknown],host=[local] LOG: connection received:
host=[local]
2021-01-24 12:31:03 -03 [42334]: [2] db=sgpa_gis,user=postgres,host=[local]
LOG: connection authorized: user=postgres database=sgpa_gis
application_name=pg_cron
2021-01-24 12:31:04 -03 [42334]: [4] db=sgpa_gis,user=postgres,host=[local]
LOG: duration: 550.232 ms
2021-01-24 12:31:04 -03 [42334]: [5] db=sgpa_gis,user=postgres,host=[local]
LOG: disconnection: session time: 0:00:00.561 user=postgres
database=sgpa_gis host=[local]
2021-01-24 17:16:42 -03 [42334]: [1]
db=[unknown],user=[unknown],host=[local] LOG: connection received:
host=[local]
2021-01-24 17:16:42 -03 [42334]: [2] db=sgpa_gis,user=postgres,host=[local]
DEBUG: postgres child[42334]: starting with (
2021-01-24 17:16:42 -03 [42334]: [3] db=sgpa_gis,user=postgres,host=[local]
DEBUG: postgres
2021-01-24 17:16:42 -03 [42334]: [4] db=sgpa_gis,user=postgres,host=[local]
DEBUG: )
2021-01-24 17:16:42 -03 [42334]: [5] db=sgpa_gis,user=postgres,host=[local]
DEBUG: InitPostgres
2021-01-24 17:16:42 -03 [42334]: [6] db=sgpa_gis,user=postgres,host=[local]
DEBUG: my backend ID is 10
2021-01-24 17:16:42 -03 [42334]: [7] db=sgpa_gis,user=postgres,host=[local]
DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state:
INPROGRESS, xid/subid/cid: 0/1/0
2021-01-24 17:16:42 -03 [42334]: [8] db=sgpa_gis,user=postgres,host=[local]
LOG: connection authorized: user=postgres database=sgpa_gis
application_name=psql
2021-01-24 17:16:42 -03 [42334]: [9] db=sgpa_gis,user=postgres,host=[local]
DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state:
INPROGRESS, xid/subid/cid: 0/1/0
2021-01-24 17:16:44 -03 [42334]: [10]
db=sgpa_gis,user=postgres,host=[local] DEBUG: StartTransaction(1) name:
unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2021-01-24 17:16:44 -03 [42334]: [11]
db=sgpa_gis,user=postgres,host=[local] LOG: statement: ANALYZE
sgpa_map.ddn_pluviometro_cliente40;
2021-01-24 17:16:44 -03 [42334]: [12]
db=sgpa_gis,user=postgres,host=[local] DEBUG: analyzing
"sgpa_map.ddn_pluviometro_cliente40"
2021-01-24 17:16:44 -03 [42334]: [13]
db=sgpa_gis,user=postgres,host=[local] DEBUG: "ddn_pluviometro_cliente40":
scanned 9037 of 9037 pages, containing 442388 live rows and 349 dead rows;
442388 rows in sample, 442388 estimated total rows
*2021-01-24 17:16:48 -03 [42334]: [14]
db=sgpa_gis,user=postgres,host=[local] ERROR: invalid memory alloc request
size 8589934668*
*2021-01-24 17:16:48 -03 [42334]: [15]
db=sgpa_gis,user=postgres,host=[local] STATEMENT: ANALYZE
sgpa_map.ddn_pluviometro_cliente40;*
2021-01-24 17:16:52 -03 [42334]: [16]
db=sgpa_gis,user=postgres,host=[local] DEBUG: StartTransaction(1) name:
unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2021-01-24 17:16:52 -03 [42334]: [17]
db=sgpa_gis,user=postgres,host=[local] LOG: statement: vacuum ANALYZE
sgpa_map.ddn_pluviometro_cliente40;
2021-01-24 17:16:52 -03 [42334]: [18]
db=sgpa_gis,user=postgres,host=[local] DEBUG: CommitTransaction(1) name:
unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2021-01-24 17:16:52 -03 [42334]: [19]
db=sgpa_gis,user=postgres,host=[local] DEBUG: StartTransaction(1) name:
unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2021-01-24 17:16:52 -03 [42334]: [20]
db=sgpa_gis,user=postgres,host=[local] DEBUG: vacuuming
"sgpa_map.ddn_pluviometro_cliente40"
2021-01-24 17:16:52 -03 [42334]: [21]
db=sgpa_gis,user=postgres,host=[local] DEBUG: scanned index
"ddn_pluviometro_cliente40_cluster_idx" to remove 307 row versions
2021-01-24 17:16:52 -03 [42334]: [22]
db=sgpa_gis,user=postgres,host=[local] DETAIL: CPU: user: 0.02 s, system:
0.00 s, elapsed: 0.02 s
2021-01-24 17:16:52 -03 [42334]: [23]
db=sgpa_gis,user=postgres,host=[local] DEBUG: scanned index
"ddn_pluviometro_cliente40_cd_cliente_cd_id_origem_key" to remove 307 row
versions
2021-01-24 17:16:52 -03 [42334]: [24]
db=sgpa_gis,user=postgres,host=[local] DETAIL: CPU: user: 0.02 s, system:
0.00 s, elapsed: 0.02 s
2021-01-24 17:16:52 -03 [42334]: [25]
db=sgpa_gis,user=postgres,host=[local] DEBUG: scanned index
"ddn_pluviometro_cliente40_cd_id_cd_cliente_key" to remove 307 row versions
2021-01-24 17:16:52 -03 [42334]: [26]
db=sgpa_gis,user=postgres,host=[local] DETAIL: CPU: user: 0.02 s, system:
0.00 s, elapsed: 0.02 s
2021-01-24 17:16:52 -03 [42334]: [27]
db=sgpa_gis,user=postgres,host=[local] DEBUG: scanned index
"ddn_pluviometro_cliente40_cd_cliente_cd_equipamento_idx" to remove 307 row
versions
2021-01-24 17:16:52 -03 [42334]: [28]
db=sgpa_gis,user=postgres,host=[local] DETAIL: CPU: user: 0.02 s, system:
0.00 s, elapsed: 0.03 s
2021-01-24 17:16:52 -03 [42334]: [29]
db=sgpa_gis,user=postgres,host=[local] DEBUG: scanned index
"ddn_pluviometro_cliente40_ponto_idx1" to remove 307 row versions
2021-01-24 17:16:52 -03 [42334]: [30]
db=sgpa_gis,user=postgres,host=[local] DETAIL: CPU: user: 0.02 s, system:
0.01 s, elapsed: 0.06 s
2021-01-24 17:16:52 -03 [42334]: [31]
db=sgpa_gis,user=postgres,host=[local] DEBUG: scanned index
"ddn_pluviometro_cliente40_cd_cliente_dt_hr_local_cd_equipam_idx" to remove
307 row versions
2021-01-24 17:16:52 -03 [42334]: [32]
db=sgpa_gis,user=postgres,host=[local] DETAIL: CPU: user: 0.02 s, system:
0.00 s, elapsed: 0.03 s
2021-01-24 17:16:52 -03 [42334]: [33]
db=sgpa_gis,user=postgres,host=[local] DEBUG: scanned index
"ddn_pluviometro_cliente40_ponto_idx" to remove 307 row versions
2021-01-24 17:16:52 -03 [42334]: [34]
db=sgpa_gis,user=postgres,host=[local] DETAIL: CPU: user: 0.02 s, system:
0.01 s, elapsed: 0.05 s
2021-01-24 17:16:52 -03 [42334]: [35]
db=sgpa_gis,user=postgres,host=[local] DEBUG: "ddn_pluviometro_cliente40":
removed 307 row versions in 95 pages
2021-01-24 17:16:52 -03 [42334]: [36]
db=sgpa_gis,user=postgres,host=[local] DETAIL: CPU: user: 0.00 s, system:
0.00 s, elapsed: 0.00 s
2021-01-24 17:16:52 -03 [42334]: [37]
db=sgpa_gis,user=postgres,host=[local] DEBUG: index
"ddn_pluviometro_cliente40_cluster_idx" now contains 442388 row versions in
1156 pages
2021-01-24 17:16:52 -03 [42334]: [38]
db=sgpa_gis,user=postgres,host=[local] DETAIL: 307 index row versions were
removed.
2021-01-24 17:16:52 -03 [42334]: [39]
db=sgpa_gis,user=postgres,host=[local] DEBUG: index
"ddn_pluviometro_cliente40_cd_cliente_cd_id_origem_key" now contains 442388
row versions in 1709 pages
2021-01-24 17:16:52 -03 [42334]: [40]
db=sgpa_gis,user=postgres,host=[local] DETAIL: 307 index row versions were
removed.
2021-01-24 17:16:52 -03 [42334]: [41]
db=sgpa_gis,user=postgres,host=[local] DEBUG: index
"ddn_pluviometro_cliente40_cd_id_cd_cliente_key" now contains 442388 row
versions in 1706 pages
2021-01-24 17:16:52 -03 [42334]: [42]
db=sgpa_gis,user=postgres,host=[local] DETAIL: 307 index row versions were
removed.
2021-01-24 17:16:52 -03 [42334]: [43]
db=sgpa_gis,user=postgres,host=[local] DEBUG: index
"ddn_pluviometro_cliente40_cd_cliente_cd_equipamento_idx" now contains
442388 row versions in 1712 pages
2021-01-24 17:16:52 -03 [42334]: [44]
db=sgpa_gis,user=postgres,host=[local] DETAIL: 307 index row versions were
removed.
2021-01-24 17:16:52 -03 [42334]: [45]
db=sgpa_gis,user=postgres,host=[local] DEBUG: index
"ddn_pluviometro_cliente40_ponto_idx1" now contains 442388 row versions in
5275 pages
2021-01-24 17:16:52 -03 [42334]: [46]
db=sgpa_gis,user=postgres,host=[local] DETAIL: 307 index row versions were
removed.
2021-01-24 17:16:52 -03 [42334]: [47]
db=sgpa_gis,user=postgres,host=[local] DEBUG: index
"ddn_pluviometro_cliente40_cd_cliente_dt_hr_local_cd_equipam_idx" now
contains 442388 row versions in 2196 pages
2021-01-24 17:16:52 -03 [42334]: [48]
db=sgpa_gis,user=postgres,host=[local] DETAIL: 307 index row versions were
removed.
2021-01-24 17:16:52 -03 [42334]: [49]
db=sgpa_gis,user=postgres,host=[local] DEBUG: index
"ddn_pluviometro_cliente40_ponto_idx" now contains 442388 row versions in
3366 pages
2021-01-24 17:16:52 -03 [42334]: [50]
db=sgpa_gis,user=postgres,host=[local] DETAIL: 307 index row versions were
removed.
2021-01-24 17:16:52 -03 [42334]: [51]
db=sgpa_gis,user=postgres,host=[local] DEBUG: "ddn_pluviometro_cliente40":
found 310 removable, 28822 nonremovable row versions in 597 out of 9037
pages
2021-01-24 17:16:52 -03 [42334]: [52]
db=sgpa_gis,user=postgres,host=[local] DETAIL: 0 dead row versions cannot
be removed yet, oldest xmin: 1908391
2021-01-24 17:16:52 -03 [42334]: [53]
db=sgpa_gis,user=postgres,host=[local] DEBUG: CommitTransaction(1) name:
unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0 (used)
2021-01-24 17:16:52 -03 [42334]: [54]
db=sgpa_gis,user=postgres,host=[local] DEBUG: StartTransaction(1) name:
unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2021-01-24 17:16:52 -03 [42334]: [55]
db=sgpa_gis,user=postgres,host=[local] DEBUG: vacuuming
"pg_toast.pg_toast_276915"
2021-01-24 17:16:52 -03 [42334]: [56]
db=sgpa_gis,user=postgres,host=[local] DEBUG: index
"pg_toast_276915_index" now contains 0 row versions in 1 pages
2021-01-24 17:16:52 -03 [42334]: [57]
db=sgpa_gis,user=postgres,host=[local] DETAIL: 0 index row versions were
removed.
2021-01-24 17:16:52 -03 [42334]: [58]
db=sgpa_gis,user=postgres,host=[local] DEBUG: "pg_toast_276915": found 0
removable, 0 nonremovable row versions in 0 out of 0 pages
2021-01-24 17:16:52 -03 [42334]: [59]
db=sgpa_gis,user=postgres,host=[local] DETAIL: 0 dead row versions cannot
be removed yet, oldest xmin: 1908391
2021-01-24 17:16:52 -03 [42334]: [60]
db=sgpa_gis,user=postgres,host=[local] DEBUG: CommitTransaction(1) name:
unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2021-01-24 17:16:52 -03 [42334]: [61]
db=sgpa_gis,user=postgres,host=[local] DEBUG: StartTransaction(1) name:
unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2021-01-24 17:16:52 -03 [42334]: [62]
db=sgpa_gis,user=postgres,host=[local] DEBUG: analyzing
"sgpa_map.ddn_pluviometro_cliente40"
2021-01-24 17:16:52 -03 [42334]: [63]
db=sgpa_gis,user=postgres,host=[local] DEBUG: "ddn_pluviometro_cliente40":
scanned 9037 of 9037 pages, containing 442388 live rows and 0 dead rows;
442388 rows in sample, 442388 estimated total rows
*2021-01-24 17:16:56 -03 [42334]: [64]
db=sgpa_gis,user=postgres,host=[local] ERROR: invalid memory alloc request
size 8589934668*
*2021-01-24 17:16:56 -03 [42334]: [65]
db=sgpa_gis,user=postgres,host=[local] STATEMENT: vacuum ANALYZE
sgpa_map.ddn_pluviometro_cliente40;*
2021-01-24 17:17:14 -03 [42334]: [66]
db=sgpa_gis,user=postgres,host=[local] DEBUG: StartTransaction(1) name:
unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2021-01-24 17:17:14 -03 [42334]: [67]
db=sgpa_gis,user=postgres,host=[local] LOG: statement: SELECT
pg_catalog.quote_ident(c.relname) FROM pg_catalog.pg_class c WHERE
c.relkind IN ('r', 'p', 'm', 'f') AND
substring(pg_catalog.quote_ident(c.relname),1,32)='sgpa_map.ddn_pluviometro_cliente'
AND pg_catalog.pg_table_is_visible(c.oid) AND c.relnamespace <> (SELECT oid
FROM pg_catalog.pg_namespace WHERE nspname = 'pg_catalog')
2021-01-24 17:17:14 -03 [42334]: [68]
db=sgpa_gis,user=postgres,host=[local] DEBUG: CommitTransaction(1) name:
unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2021-01-24 17:17:14 -03 [42334]: [69]
db=sgpa_gis,user=postgres,host=[local] LOG: duration: 104.190 ms
2021-01-24 17:17:14 -03 [42334]: [70]
db=sgpa_gis,user=postgres,host=[local] DEBUG: StartTransaction(1) name:
unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2021-01-24 17:17:14 -03 [42334]: [71]
db=sgpa_gis,user=postgres,host=[local] LOG: statement: SELECT
pg_catalog.quote_ident(c.relname) FROM pg_catalog.pg_class c WHERE
c.relkind IN ('r', 'p', 'm', 'f') AND
substring(pg_catalog.quote_ident(c.relname),1,32)='sgpa_map.ddn_pluviometro_cliente'
AND pg_catalog.pg_table_is_visible(c.oid) AND c.relnamespace <> (SELECT oid
FROM pg_catalog.pg_namespace WHERE nspname = 'pg_catalog')
2021-01-24 17:17:14 -03 [42334]: [72]
db=sgpa_gis,user=postgres,host=[local] DEBUG: CommitTransaction(1) name:
unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2021-01-24 17:17:14 -03 [42334]: [73]
db=sgpa_gis,user=postgres,host=[local] LOG: duration: 81.597 ms
2021-01-24 17:17:19 -03 [42334]: [74]
db=sgpa_gis,user=postgres,host=[local] DEBUG: StartTransaction(1) name:
unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2021-01-24 17:17:19 -03 [42334]: [75]
db=sgpa_gis,user=postgres,host=[local] LOG: statement: ANALYZE
sgpa_map.ddn_pluviometro_cliente112;
2021-01-24 17:17:19 -03 [42334]: [76]
db=sgpa_gis,user=postgres,host=[local] DEBUG: analyzing
"sgpa_map.ddn_pluviometro_cliente112"
2021-01-24 17:17:19 -03 [42334]: [77]
db=sgpa_gis,user=postgres,host=[local] DEBUG:
"ddn_pluviometro_cliente112": scanned 0 of 0 pages, containing 0 live rows
and 0 dead rows; 0 rows in sample, 0 estimated total rows
2021-01-24 17:17:19 -03 [42334]: [78]
db=sgpa_gis,user=postgres,host=[local] DEBUG: CommitTransaction(1) name:
unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2021-01-24 17:17:19 -03 [42334]: [79]
db=sgpa_gis,user=postgres,host=[local] LOG: duration: 3.752 ms
2021-01-24 17:17:25 -03 [42334]: [80]
db=sgpa_gis,user=postgres,host=[local] DEBUG: shmem_exit(0): 1
before_shmem_exit callbacks to make
2021-01-24 17:17:25 -03 [42334]: [81]
db=sgpa_gis,user=postgres,host=[local] DEBUG: shmem_exit(0): 6
on_shmem_exit callbacks to make
2021-01-24 17:17:25 -03 [42334]: [82]
db=sgpa_gis,user=postgres,host=[local] DEBUG: proc_exit(0): 4 callbacks to
make
2021-01-24 17:17:25 -03 [42334]: [83]
db=sgpa_gis,user=postgres,host=[local] LOG: disconnection: session time:
0:00:43.426 user=postgres database=sgpa_gis host=[local]
2021-01-24 17:17:25 -03 [42334]: [84]
db=sgpa_gis,user=postgres,host=[local] DEBUG: exit(0)
2021-01-24 17:17:25 -03 [42334]: [85]
db=sgpa_gis,user=postgres,host=[local] DEBUG: shmem_exit(-1): 0
before_shmem_exit callbacks to make
2021-01-24 17:17:25 -03 [42334]: [86]
db=sgpa_gis,user=postgres,host=[local] DEBUG: shmem_exit(-1): 0
on_shmem_exit callbacks to make
2021-01-24 17:17:25 -03 [42334]: [87]
db=sgpa_gis,user=postgres,host=[local] DEBUG: proc_exit(-1): 0 callbacks
to make

Penso que possa ser um bug, pelo status do acontecido.
O que acham?

Desde já agradeço.

Vinicius Vale
Sudoers