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

Olá Vinícius

Alguma coisa está extrapolando o limite de 1GB por tupla do PostgreSQL.
Algumas funções bugadas podem causar isso, mas, também, corrupção causada
por, por exemplo, pentes de memória com defeito.
Não deve ser só o analyze que solta o erro, um SELECT na tabela também.
Como você consegue reproduzir com precisão o problema, vamos tentar ver se
não está antes do que você está fazendo.
Pergunto: a tabela de origem dos dados, que você está usando para popular a
particionada, apresenta o mesmo problema? Pois ela pode estar na origem
caso esteja corrompida.
Um SELECT * FROM sgpa_map.ddn_pluviometro_cliente165; dá erro ?
Eu vi que você faz o INSERT INTO... SELECT * FROM que deveria dar erro, mas
o PostgreSQL tem uns mecanismos "físicos" para copiar uma tabela na outra
sem verificação de tupla.

[]s
Flavio Gurgel

Em qui., 4 de fev. de 2021 às 18:12, Vinícius Aquino do Vale <
aquino(dot)vale(at)gmail(dot)com> escreveu:

> 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
>