Stats Statistics of JavaMelody monitoring taken at 9/29/25, 6:09 PM from 9/29/25, 6:08 PM on _ip-10-0-6-204.ec2.internal (application)

Update Update     PDF PDF     Online help Online help     Monitoring with a Rich Desktop Application Desktop     Choice of period :  Day Day  Week Week  Month Month  Year Year  All All  Customized Customized


           (m/d/yy)     


Used memory % CPU Http sessions
Active threads Active jdbc connections Used jdbc connections
Http hits per minute Http mean times (ms) % of http errors
Sql hits per minute Sql mean times (ms) % of sql errors
Spring hits per minute Spring mean times (ms) % of spring errors
Other charts
% Garbage Collector time Threads count Loaded classes count
Used buffered memory Used non heap memory Used physical memory
Used swap space System load % System CPU
Nb of opened files Mean age of http sessions (min) Transactions per minute
Free disk space Usable disk space

http Statistics http - all

Request% of cumulative timeHitsMean time (ms)Max time (ms)Standard deviation% of cumulative cpu timeMean cpu time (ms)Mean allocated Kb% of system errorMean size (Kb)Mean hits sqlMean time sql (ms)
http global 100 5 1,874 9,147 4,065 100 63 9,377 20.00 47 0 1,786
http warning 97 1 9,147 9,147 0 64 206 37,191 0.00 236 1 8,930
http severe 0 0 -1 0 -1 0 -1 -1 0.00 0 -1 -1
6 hits/min on 3 requests       Details       Clear
Request% of cumulative timeHitsMean time (ms)Max time (ms)Standard deviation% of cumulative cpu timeMean cpu time (ms)Mean allocated Kb% of system errorMean size (Kb)Mean hits sqlMean time sql (ms)
graph/api/nfe/credito-tese-artigo-426a/{cnpj}/period POST 97 1 9,147 9,147 0 64 206 37,191 0.00 236 1 8,930
graph/actuator/health GET 2 3 73 82 15 33 35 2,965 0.00 0 0 0
graphError404 0 1 7 7 0 1 6 801 100.00 0 0 0

sql Statistics sql - all

Request% of cumulative timeHitsMean time (ms)Max time (ms)Standard deviation% of system error
sql global 100 228 41 8,930 591 0.00
sql warning 0 0 -1 0 -1 0.00
sql severe 94 1 8,930 8,930 0 0.00
254 hits/min on 52 requests       Details       Clear
Request% of cumulative timeHitsMean time (ms)Max time (ms)Standard deviation% of system error
graphSELECT d.cnpj_issuer as cnpj, to_date(to_char(d.data_emissao, 'yyyy-MM-dd'), 'yyyy-MM-dd') as dataEmissao, d.key AS chaveNfe, d.data -> 'nfe' -> 'infNFe' -> 'ide' ->> 'nnf' AS numeroNfe, item.produto -> 'prod' ->> 'cprod' as codigoProduto, item.produto -> 'prod' ->> 'xprod' AS descricaoProduto, item.produto -> 'prod' ->> 'ncm' as codigoNcm, item.produto -> 'prod' ->> 'cfop' as cfop, CAST(item.produto -> 'prod' ->> 'vprod' AS NUMERIC) as valorProduto FROM document d , jsonb_array_elements(d.data -> 'nfe' -> 'infNFe' -> 'det') WITH ORDINALITY item(produto) WHERE d.cnpj_issuer IN (?) AND d.type IN ('NFE_2_0','NFE_3_1','NFE_4_0') AND data_emissao BETWEEN ? and ? AND item.produto -> 'prod' ->> 'cfop' IN ('5405', '5409') AND item.produto -> 'prod' ->> 'ncm' IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)ORDER BY d.key limit ? offset ? 94 1 8,930 8,930 0 0.00
graphSET ROLE 'postgres' 1 55 1 8 0 0.00
graphSELECT version() 0 23 2 7 1 0.00
graph/*NO LOAD BALANCE*/
SELECT "installed_rank","version","description","type","script","checksum","installed_on","installed_by","execution_time","success" FROM "public"."flyway_schema_history" WHERE "installed_rank" > ? ORDER BY "installed_rank"		 0 22 2 11 1 0.00
graphSELECT EXISTS (
SELECT 1
FROM pg_catalog.pg_class c
JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
WHERE n.nspname = ?
AND c.relname = ?
AND c.relkind = 'r'
)		 0 23 1 3 0 0.00
graphCREATE TABLE IF NOT EXISTS nfe_cte (
chave_nfe VARCHAR(44) NOT NULL,
chave_cte VARCHAR(44) NOT NULL,
created_at TIMESTAMP NOT NULL,
PRIMARY KEY (chave_nfe, chave_cte)
)		 0 1 36 36 0 0.00
graphCREATE OR REPLACE VIEW public.document_obrigacoes_view
AS SELECT document.key,
document.protocol,
document.cnpj_issuer,
document.nsu,
document.type,
document.cnpj,
document.imported_at,
document.name_file,
(CAST((document.data -> 'header'::text) ->> 'startsDate'::text as date)) AS starts_date,
(CAST((document.data -> 'header'::text) ->> 'endsDate'::text as date)) AS ends_date,
(document.data -> 'header'::text) ->> 'finalType'::text AS final_type,
(CAST(((document.data -> 'header'::text) ->> 'deliveryDate'::text) as timestamp)) AS delivery_date,
document.data ->> 'originalFileName'::text AS original_file_name,
document.data_emissao,
document.inscricao_estadual,
cast(document.data -> 'header' ->> 'parcial' as boolean) as parcial
FROM document		 0 1 23 23 0 0.00
graphSELECT pg_try_advisory_lock(77433833903597) 0 11 2 3 0 0.00
graphdrop view if exists document_obrigacoes_view 0 2 11 19 11 0.00
graphSELECT pg_advisory_unlock(77433833903597) 0 11 2 3 0 0.00
graphSELECT COUNT(*) FROM pg_namespace WHERE nspname=? 0 11 1 3 0 0.00
graphSELECT set_config('search_path', ?, false) 0 11 1 2 0 0.00
graphINSERT INTO "public"."flyway_schema_history" ("installed_rank", "version", "description", "type", "script", "checksum", "installed_by", "execution_time", "success") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) 0 10 1 2 0 0.00
graphDROP view IF EXISTS public.document_cte_completo_view 0 1 11 11 0 0.00
graphCREATE OR REPLACE VIEW public.document_cte_completo_view
AS SELECT doc.key,
ds.manifestation,
doc.type,
doc.protocol,
doc.nsu,
ds.status,
doc.data_emissao,
(((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) ->> 'nct'::text AS numero_cte,
(doc.info -> 'value'::text)::numeric AS value,
(((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) ->> 'serie'::text AS serial,
doc.cnpj_issuer,
(((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'emit'::text) ->> 'id'::text AS issuer_inscricao_estadual,
doc.info ->> 'issuerName'::text AS issuer_name,
doc.cnpj_addressee AS addressee_cnpj_cpf,
(((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'dest'::text) ->> 'ie'::text AS addressee_inscricao_estadual,
doc.info ->> 'addresseeName'::text AS addressee_name,
(((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'exped'::text) ->> 'cnpj'::text AS expedidor_cnpj,
(((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'exped'::text) ->> 'ie'::text AS expedidor_inscricao_estadual,
(((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'exped'::text) ->> 'xnome'::text AS expedidor_nome,
COALESCE((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'receb'::text) ->> 'cnpj'::text, (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'receb'::text) ->> 'cpf'::text) AS recebedor_cnpj_cpf,
(((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'receb'::text) ->> 'ie'::text AS recebedor_inscricao_estadual,
(((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'receb'::text) ->> 'xnome'::text AS recebedor_nome,
COALESCE((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'rem'::text) ->> 'cnpj'::text, (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'rem'::text) ->> 'cpf'::text) AS remetente_cnpj_cpf,
(((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'rem'::text) ->> 'ie'::text AS remetente_inscricao_estadual,
(((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'rem'::text) ->> 'xnome'::text AS remetente_nome,
((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma3'::text) ->> 'toma'::text AS tipo_tomador_servico,
doc.cnpj_cpf_tomador AS tomador4_cnpj,
CASE
WHEN (((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma3'::text) ->> 'toma'::text) = '0'::text THEN (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'rem'::text) ->> 'ie'::text
WHEN (((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma3'::text) ->> 'toma'::text) = '1'::text THEN (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'exped'::text) ->> 'ie'::text
WHEN (((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma3'::text) ->> 'toma'::text) = '2'::text THEN (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'receb'::text) ->> 'ie'::text
WHEN (((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma3'::text) ->> 'toma'::text) = '3'::text THEN (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'dest'::text) ->> 'ie'::text
ELSE ((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma4'::text) ->> 'ie'::text
END AS tomador4_inscricao_estadual,
CASE
WHEN (((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma3'::text) ->> 'toma'::text) = '0'::text THEN (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'rem'::text) ->> 'xNome'::text
WHEN (((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma3'::text) ->> 'toma'::text) = '1'::text THEN (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'exped'::text) ->> 'xNome'::text
WHEN (((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma3'::text) ->> 'toma'::text) = '2'::text THEN (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'receb'::text) ->> 'xNome'::text
WHEN (((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma3'::text) ->> 'toma'::text) = '3'::text THEN doc.info ->> 'addresseeName'::text
ELSE ((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma4'::text) ->> 'xNome'::text
END AS tomador4_nome,
doc.cnpj_carrier,
((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) ->> 'tpCTe'::text)::integer AS tipo_cte,
ds.available_at,
ds.canceled_at,
doc.name_file,
doc.cnpj_cpf_remetente,
doc.schema,
(doc.data -> 'cte' -> 'infCte' -> 'imp' -> 'icms' -> 'icms00' ->> 'cst') AS cst,
(doc.data -> 'cte' -> 'infCte' -> 'imp' -> 'icms' -> 'icms00' ->> 'vbc') AS vbc,
(doc.data -> 'cte' -> 'infCte' -> 'imp' -> 'icms' -> 'icms00' ->> 'picms') AS picms,
(doc.data -> 'cte' -> 'infCte' -> 'imp' -> 'icms' -> 'icms00' ->> 'vicms') AS vicms
FROM document doc
JOIN document_status ds ON doc.key::text = ds.key::text AND doc.cnpj_issuer::text = ds.cnpj_issuer::text		 0 1 9 9 0 0.00
graphSHOW search_path 0 4 2 2 0 0.00
graphDROP view IF EXISTS public.document_cte_view 0 2 4 6 2 0.00
graphCREATE OR REPLACE VIEW document_nfe_view (
key, type, cnpj, cnpj_issuer, cnpj_addressee, cnpj_carrier, data_emissao, nsu, protocol, value,
issuer_name, addressee_name, nfe_number, manifestation, cce_events, available_at, canceled_at, status,
name_file, carta_correcao, duplicatas, fatura, data, cfops, etiquetas, notas_referencia, cte_key
) AS
SELECT
doc.key,
doc.type,
doc.cnpj,
doc.cnpj_issuer,
doc.cnpj_addressee,
doc.cnpj_carrier,
doc.data_emissao,
doc.nsu,
doc.protocol,
(doc.info ->> 'value')::double precision AS value,
doc.info ->> 'issuerName' AS issuer_name,
doc.info ->> 'addresseeName' AS addressee_name,
doc.data #>> '{nfe,infNFe,ide,nnf}' AS nfe_number,

-- Manifestação
COALESCE((
SELECT CASE
WHEN ds.manifestation IS NOT NULL THEN ds.manifestation
WHEN item.historico ->> 'eventCode' IN ('210200','210210','210220','210240')
THEN item.historico ->> 'eventCode'
WHEN regexp_replace(item.historico ->> 'description', '[^0-9]', '', 'gi') IN ('210200','210210','210220','210240')
THEN regexp_replace(item.historico ->> 'description', '[^0-9]', '', 'gi')
END
FROM jsonb_array_elements(ds.history) WITH ORDINALITY item(historico, ordinality)
WHERE item.historico ->> 'eventType' IN ('NFE_EVENT_MANIFESTATION','NFE_EVENT')
ORDER BY item.historico ->> 'eventAt' DESC
LIMIT 1
), ds.manifestation) AS manifestation,

ds.cce_events,
ds.available_at,

-- Cancelamento
COALESCE((
SELECT CASE
WHEN ds.canceled_at IS NOT NULL THEN ds.canceled_at
WHEN item.historico ->> 'eventCode' = '110111'
THEN (item.historico ->> 'eventAt')::timestamp AT TIME ZONE 'UTC'
WHEN regexp_replace(item.historico ->> 'description','[^0-9]','','gi') = '110111'
THEN (item.historico ->> 'eventAt')::timestamp AT TIME ZONE 'UTC'
END
FROM jsonb_array_elements(ds.history) WITH ORDINALITY item(historico, ordinality)
WHERE item.historico ->> 'eventCode' = '110111'
OR regexp_replace(item.historico ->> 'description','[^0-9]','','gi') = '110111'
ORDER BY item.historico ->> 'eventAt' DESC
LIMIT 1
), ds.canceled_at) AS canceled_at,

-- Status
COALESCE((
SELECT CASE
WHEN item.historico ->> 'eventCode' = '110111' THEN '3'
WHEN regexp_replace(item.historico ->> 'description','[^0-9]','','gi') = '110111' THEN '3'
WHEN ds.status IS NOT NULL THEN ds.status
ELSE '1'
END
FROM jsonb_array_elements(ds.history) WITH ORDINALITY item(historico, ordinality)
ORDER BY item.historico ->> 'eventAt' DESC
LIMIT 1
), ds.status) AS status,

doc.name_file,

-- Carta de correção
(
SELECT json_agg(consulta.*)
FROM (
SELECT
d.data #>> '{procEventoNFe,evento,infEvento,dhEvento}' AS data_evento,
d.data #>> '{procEventoNFe,evento,infEvento,detEvento,xCorrecao}' AS correcao_evento
FROM document d
WHERE doc.key = d.key
AND doc.cnpj_issuer = d.cnpj_issuer
AND d.data #>> '{procEventoNFe,retEvento,infEvento,tpEvento}' = '110110'
AND d.data_emissao = doc.data_emissao
) consulta
) AS carta_correcao,

doc.data #> '{nfe,infNFe,cobr,dup}' AS duplicatas,
doc.data #> '{nfe,infNFe,cobr,fat}' AS fatura,

doc.data,

-- CFOPs
(SELECT string_agg(DISTINCT item.value #>> '{prod,cfop}', ',')
FROM jsonb_array_elements(doc.data #> '{nfe,infNFe,det}') item(value)
) AS cfops,

-- Etiquetas
(SELECT jsonb_agg(jsonb_build_object(
'id', e.id,
'nome_etiqueta', e.nome_etiqueta,
'cor_etiqueta', e.cor_etiqueta,
'etiqueta_padrao', e.etiqueta_padrao,
'cnpj_empresa', e.cnpj_empresa))
FROM etiqueta_documento ed
JOIN etiqueta e ON e.id = ed.id_etiqueta_atual
WHERE ed.chave_nfe = doc.key
) AS etiquetas,

-- Notas Referenciadas
(SELECT string_agg(DISTINCT nota.referencia ->> 'refNFe', ', ')
FROM jsonb_array_elements(doc.data #> '{nfe,infNFe,ide,nfref}') WITH ORDINALITY nota(referencia, ordinality)
) AS notas_referencia,

nct.chave_cte AS cte_key
FROM document doc
JOIN document_status ds ON doc.key = ds.key AND doc.cnpj_issuer = ds.cnpj_issuer
LEFT JOIN nfe_cte nct O
Details

CREATE OR REPLACE VIEW document_nfe_view (
key, type, cnpj, cnpj_issuer, cnpj_addressee, cnpj_carrier, data_emissao, nsu, protocol, value,
issuer_name, addressee_name, nfe_number, manifestation, cce_events, available_at, canceled_at, status,
name_file, carta_correcao, duplicatas, fatura, data, cfops, etiquetas, notas_referencia, cte_key
) AS
SELECT
doc.key,
doc.type,
doc.cnpj,
doc.cnpj_issuer,
doc.cnpj_addressee,
doc.cnpj_carrier,
doc.data_emissao,
doc.nsu,
doc.protocol,
(doc.info ->> 'value')::double precision AS value,
doc.info ->> 'issuerName' AS issuer_name,
doc.info ->> 'addresseeName' AS addressee_name,
doc.data #>> '{nfe,infNFe,ide,nnf}' AS nfe_number,

-- Manifestação
COALESCE((
SELECT CASE
WHEN ds.manifestation IS NOT NULL THEN ds.manifestation
WHEN item.historico ->> 'eventCode' IN ('210200','210210','210220','210240')
THEN item.historico ->> 'eventCode'
WHEN regexp_replace(item.historico ->> 'description', '[^0-9]', '', 'gi') IN ('210200','210210','210220','210240')
THEN regexp_replace(item.historico ->> 'description', '[^0-9]', '', 'gi')
END
FROM jsonb_array_elements(ds.history) WITH ORDINALITY item(historico, ordinality)
WHERE item.historico ->> 'eventType' IN ('NFE_EVENT_MANIFESTATION','NFE_EVENT')
ORDER BY item.historico ->> 'eventAt' DESC
LIMIT 1
), ds.manifestation) AS manifestation,

ds.cce_events,
ds.available_at,

-- Cancelamento
COALESCE((
SELECT CASE
WHEN ds.canceled_at IS NOT NULL THEN ds.canceled_at
WHEN item.historico ->> 'eventCode' = '110111'
THEN (item.historico ->> 'eventAt')::timestamp AT TIME ZONE 'UTC'
WHEN regexp_replace(item.historico ->> 'description','[^0-9]','','gi') = '110111'
THEN (item.historico ->> 'eventAt')::timestamp AT TIME ZONE 'UTC'
END
FROM jsonb_array_elements(ds.history) WITH ORDINALITY item(historico, ordinality)
WHERE item.historico ->> 'eventCode' = '110111'
OR regexp_replace(item.historico ->> 'description','[^0-9]','','gi') = '110111'
ORDER BY item.historico ->> 'eventAt' DESC
LIMIT 1
), ds.canceled_at) AS canceled_at,

-- Status
COALESCE((
SELECT CASE
WHEN item.historico ->> 'eventCode' = '110111' THEN '3'
WHEN regexp_replace(item.historico ->> 'description','[^0-9]','','gi') = '110111' THEN '3'
WHEN ds.status IS NOT NULL THEN ds.status
ELSE '1'
END
FROM jsonb_array_elements(ds.history) WITH ORDINALITY item(historico, ordinality)
ORDER BY item.historico ->> 'eventAt' DESC
LIMIT 1
), ds.status) AS status,

doc.name_file,

-- Carta de correção
(
SELECT json_agg(consulta.*)
FROM (
SELECT
d.data #>> '{procEventoNFe,evento,infEvento,dhEvento}' AS data_evento,
d.data #>> '{procEventoNFe,evento,infEvento,detEvento,xCorrecao}' AS correcao_evento
FROM document d
WHERE doc.key = d.key
AND doc.cnpj_issuer = d.cnpj_issuer
AND d.data #>> '{procEventoNFe,retEvento,infEvento,tpEvento}' = '110110'
AND d.data_emissao = doc.data_emissao
) consulta
) AS carta_correcao,

doc.data #> '{nfe,infNFe,cobr,dup}' AS duplicatas,
doc.data #> '{nfe,infNFe,cobr,fat}' AS fatura,

doc.data,

-- CFOPs
(SELECT string_agg(DISTINCT item.value #>> '{prod,cfop}', ',')
FROM jsonb_array_elements(doc.data #> '{nfe,infNFe,det}') item(value)
) AS cfops,

-- Etiquetas
(SELECT jsonb_agg(jsonb_build_object(
'id', e.id,
'nome_etiqueta', e.nome_etiqueta,
'cor_etiqueta', e.cor_etiqueta,
'etiqueta_padrao', e.etiqueta_padrao,
'cnpj_empresa', e.cnpj_empresa))
FROM etiqueta_documento ed
JOIN etiqueta e ON e.id = ed.id_etiqueta_atual
WHERE ed.chave_nfe = doc.key
) AS etiquetas,

-- Notas Referenciadas
(SELECT string_agg(DISTINCT nota.referencia ->> 'refNFe', ', ')
FROM jsonb_array_elements(doc.data #> '{nfe,infNFe,ide,nfref}') WITH ORDINALITY nota(referencia, ordinality)
) AS notas_referencia,

nct.chave_cte AS cte_key
FROM document doc
JOIN document_status ds ON doc.key = ds.key AND doc.cnpj_issuer = ds.cnpj_issuer
LEFT JOIN nfe_cte nct ON doc.key = nct.chave_nfe
WHERE doc.group_type = 'NFE'
 0 1 7 7 0 0.00
graphCREATE OR REPLACE VIEW public.document_cte_view
AS SELECT doc.key,
ds.manifestation,
doc.type,
doc.protocol,
doc.nsu,
ds.status,
doc.data_emissao,
(((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) ->> 'nct'::text AS numero_cte,
(doc.info -> 'value'::text)::numeric AS value,
(((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) ->> 'serie'::text AS serial,
doc.cnpj_issuer,
(((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'emit'::text) ->> 'id'::text AS issuer_inscricao_estadual,
doc.info ->> 'issuerName'::text AS issuer_name,
doc.cnpj_addressee AS addressee_cnpj_cpf,
(((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'dest'::text) ->> 'ie'::text AS addressee_inscricao_estadual,
doc.info ->> 'addresseeName'::text AS addressee_name,
(((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'exped'::text) ->> 'cnpj'::text AS expedidor_cnpj,
(((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'exped'::text) ->> 'ie'::text AS expedidor_inscricao_estadual,
(((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'exped'::text) ->> 'xnome'::text AS expedidor_nome,
COALESCE((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'receb'::text) ->> 'cnpj'::text, (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'receb'::text) ->> 'cpf'::text) AS recebedor_cnpj_cpf,
(((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'receb'::text) ->> 'ie'::text AS recebedor_inscricao_estadual,
(((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'receb'::text) ->> 'xnome'::text AS recebedor_nome,
COALESCE((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'rem'::text) ->> 'cnpj'::text, (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'rem'::text) ->> 'cpf'::text) AS remetente_cnpj_cpf,
(((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'rem'::text) ->> 'ie'::text AS remetente_inscricao_estadual,
(((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'rem'::text) ->> 'xnome'::text AS remetente_nome,
((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma3'::text) ->> 'toma'::text AS tipo_tomador_servico,
doc.cnpj_cpf_tomador AS tomador4_cnpj,
CASE
WHEN (((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma3'::text) ->> 'toma'::text) = '0'::text THEN (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'rem'::text) ->> 'ie'::text
WHEN (((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma3'::text) ->> 'toma'::text) = '1'::text THEN (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'exped'::text) ->> 'ie'::text
WHEN (((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma3'::text) ->> 'toma'::text) = '2'::text THEN (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'receb'::text) ->> 'ie'::text
WHEN (((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma3'::text) ->> 'toma'::text) = '3'::text THEN (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'dest'::text) ->> 'ie'::text
ELSE ((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma4'::text) ->> 'ie'::text
END AS tomador4_inscricao_estadual,
CASE
WHEN (((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma3'::text) ->> 'toma'::text) = '0'::text THEN (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'rem'::text) ->> 'xNome'::text
WHEN (((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma3'::text) ->> 'toma'::text) = '1'::text THEN (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'exped'::text) ->> 'xNome'::text
WHEN (((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma3'::text) ->> 'toma'::text) = '2'::text THEN (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'receb'::text) ->> 'xNome'::text
WHEN (((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma3'::text) ->> 'toma'::text) = '3'::text THEN doc.info ->> 'addresseeName'::text
ELSE ((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma4'::text) ->> 'xNome'::text
END AS tomador4_nome,
doc.cnpj_carrier,
((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) ->> 'tpCTe'::text)::integer AS tipo_cte,
ds.available_at,
ds.canceled_at,
doc.name_file,
doc.cnpj_cpf_remetente,
doc.schema,
(doc.data -> 'cte' -> 'infCte' -> 'imp' -> 'icms' -> 'icms00' ->> 'cst') AS cst,
(doc.data -> 'cte' -> 'infCte' -> 'imp' -> 'icms' -> 'icms00' ->> 'vbc') AS vbc,
(doc.data -> 'cte' -> 'infCte' -> 'imp' -> 'icms' -> 'icms00' ->> 'picms') AS picms,
(doc.data -> 'cte' -> 'infCte' -> 'imp' -> 'icms' -> 'icms00' ->> 'vicms') AS vicms
FROM document doc
JOIN document_status ds ON doc.key::text = ds.key::text AND doc.cnpj_issuer::text = ds.cnpj_issuer::text		 0 1 7 7 0 0.00
graphCREATE OR REPLACE VIEW document_nfe_canhoto_view (
key, type, cnpj, cnpj_issuer, cnpj_addressee, cnpj_carrier, data_emissao, nsu, protocol, value,
issuer_name, addressee_name, nfe_number, manifestation, cce_events, available_at, canceled_at, status,
name_file, carta_correcao, duplicatas, fatura, canhoto_id, canhoto_associado_at, canhoto_numero_nota,
canhoto_diferenca_dias_associacao, data, cfops, etiquetas, notas_referencia, cte_key
) AS
SELECT
doc.key,
doc.type,
doc.cnpj,
doc.cnpj_issuer,
doc.cnpj_addressee,
doc.cnpj_carrier,
doc.data_emissao,
doc.nsu,
doc.protocol,
(doc.info ->> 'value')::double precision AS value,
doc.info ->> 'issuerName' AS issuer_name,
doc.info ->> 'addresseeName' AS addressee_name,
doc.data #>> '{nfe,infNFe,ide,nnf}' AS nfe_number,

-- Manifestação
COALESCE((
SELECT CASE
WHEN ds.manifestation IS NOT NULL THEN ds.manifestation
WHEN item.historico ->> 'eventCode' IN ('210200','210210','210220','210240')
THEN item.historico ->> 'eventCode'
WHEN regexp_replace(item.historico ->> 'description', '[^0-9]', '', 'gi') IN ('210200','210210','210220','210240')
THEN regexp_replace(item.historico ->> 'description', '[^0-9]', '', 'gi')
ELSE NULL
END
FROM jsonb_array_elements(ds.history) WITH ORDINALITY item(historico, ordinality)
WHERE item.historico ->> 'eventType' IN ('NFE_EVENT_MANIFESTATION', 'NFE_EVENT')
ORDER BY item.historico ->> 'eventAt' DESC
LIMIT 1
), ds.manifestation) AS manifestation,

ds.cce_events,
ds.available_at,

-- Cancelamento
COALESCE((
SELECT CASE
WHEN ds.canceled_at IS NOT NULL THEN ds.canceled_at
WHEN item.historico ->> 'eventCode' = '110111'
THEN (item.historico ->> 'eventAt')::timestamp
WHEN regexp_replace(item.historico ->> 'description', '[^0-9]', '', 'gi') = '110111'
THEN (item.historico ->> 'eventAt')::timestamp
ELSE NULL
END
FROM jsonb_array_elements(ds.history) WITH ORDINALITY item(historico, ordinality)
WHERE item.historico ->> 'eventCode' = '110111'
OR regexp_replace(item.historico ->> 'description', '[^0-9]', '', 'gi') = '110111'
ORDER BY item.historico ->> 'eventAt' DESC
LIMIT 1
), ds.canceled_at) AS canceled_at,

-- Status
COALESCE((
SELECT CASE
WHEN ds.status IS NOT NULL THEN ds.status
WHEN item.historico ->> 'eventCode' = '110111' THEN '3'
WHEN regexp_replace(item.historico ->> 'description', '[^0-9]', '', 'gi') = '110111' THEN '3'
ELSE '1'
END
FROM jsonb_array_elements(ds.history) WITH ORDINALITY item(historico, ordinality)
ORDER BY item.historico ->> 'eventAt' DESC
LIMIT 1
), ds.status) AS status,

doc.name_file,

-- Carta de Correção
(
SELECT json_agg(consulta.*)
FROM (
SELECT
d.data #>> '{procEventoNFe,evento,infEvento,dhEvento}' AS data_evento,
d.data #>> '{procEventoNFe,evento,infEvento,detEvento,xCorrecao}' AS correcao_evento
FROM document d
WHERE doc.key = d.key
AND doc.cnpj_issuer = d.cnpj_issuer
AND d.data #>> '{procEventoNFe,retEvento,infEvento,tpEvento}' = '110110'
) consulta
) AS carta_correcao,

doc.data #> '{nfe,infNFe,cobr,dup}' AS duplicatas,
doc.data #> '{nfe,infNFe,cobr,fat}' AS fatura,

cn.canhoto_importacao_id AS canhoto_id,
cn.created_at AS canhoto_associado_at,
cn.numero_nota AS canhoto_numero_nota,
COALESCE(cn.created_at, CURRENT_TIMESTAMP)::date - doc.data_emissao::date AS canhoto_diferenca_dias_associacao,

doc.data,

-- CFOPs
(
SELECT string_agg(DISTINCT item.value ->> 'cfop', ',')
FROM jsonb_array_elements(doc.data #> '{nfe,infNFe,det}') item(value)
) AS cfops,

-- Etiquetas
(
SELECT jsonb_agg(
jsonb_build_object(
'id', e.id,
'nome_etiqueta', e.nome_etiqueta,
'cor_etiqueta', e.cor_etiqueta,
'etiqueta_padrao', e.etiqueta_padrao,
'cnpj_empresa', e.cnpj_empresa
)
)
FROM etiqueta_documento ed
JOIN etiqueta e ON e.id = ed.id_etiqueta_atual
WHERE ed.chave_nfe = doc.key
) AS etiquetas,

-- Notas Referenciadas
(
SELECT string_agg(DISTINCT nota.referencia ->> 'refNFe', ', ')
FROM jsonb_array_elements(doc.data #> '{nfe,infNFe,ide,nfref}') WITH ORDINALITY nota(referencia, ordinality)
) AS notas_referencia,
nct.chave_cte AS cte_key
FROM document doc
JOIN document_status ds ON doc.key = ds.key AND doc.cnpj_issuer = ds.cnpj_issuer
LEFT JOIN canhoto_nota cn ON doc.key = cn.documento_chave AND doc.cnpj_issuer
Details

CREATE OR REPLACE VIEW document_nfe_canhoto_view (
key, type, cnpj, cnpj_issuer, cnpj_addressee, cnpj_carrier, data_emissao, nsu, protocol, value,
issuer_name, addressee_name, nfe_number, manifestation, cce_events, available_at, canceled_at, status,
name_file, carta_correcao, duplicatas, fatura, canhoto_id, canhoto_associado_at, canhoto_numero_nota,
canhoto_diferenca_dias_associacao, data, cfops, etiquetas, notas_referencia, cte_key
) AS
SELECT
doc.key,
doc.type,
doc.cnpj,
doc.cnpj_issuer,
doc.cnpj_addressee,
doc.cnpj_carrier,
doc.data_emissao,
doc.nsu,
doc.protocol,
(doc.info ->> 'value')::double precision AS value,
doc.info ->> 'issuerName' AS issuer_name,
doc.info ->> 'addresseeName' AS addressee_name,
doc.data #>> '{nfe,infNFe,ide,nnf}' AS nfe_number,

-- Manifestação
COALESCE((
SELECT CASE
WHEN ds.manifestation IS NOT NULL THEN ds.manifestation
WHEN item.historico ->> 'eventCode' IN ('210200','210210','210220','210240')
THEN item.historico ->> 'eventCode'
WHEN regexp_replace(item.historico ->> 'description', '[^0-9]', '', 'gi') IN ('210200','210210','210220','210240')
THEN regexp_replace(item.historico ->> 'description', '[^0-9]', '', 'gi')
ELSE NULL
END
FROM jsonb_array_elements(ds.history) WITH ORDINALITY item(historico, ordinality)
WHERE item.historico ->> 'eventType' IN ('NFE_EVENT_MANIFESTATION', 'NFE_EVENT')
ORDER BY item.historico ->> 'eventAt' DESC
LIMIT 1
), ds.manifestation) AS manifestation,

ds.cce_events,
ds.available_at,

-- Cancelamento
COALESCE((
SELECT CASE
WHEN ds.canceled_at IS NOT NULL THEN ds.canceled_at
WHEN item.historico ->> 'eventCode' = '110111'
THEN (item.historico ->> 'eventAt')::timestamp
WHEN regexp_replace(item.historico ->> 'description', '[^0-9]', '', 'gi') = '110111'
THEN (item.historico ->> 'eventAt')::timestamp
ELSE NULL
END
FROM jsonb_array_elements(ds.history) WITH ORDINALITY item(historico, ordinality)
WHERE item.historico ->> 'eventCode' = '110111'
OR regexp_replace(item.historico ->> 'description', '[^0-9]', '', 'gi') = '110111'
ORDER BY item.historico ->> 'eventAt' DESC
LIMIT 1
), ds.canceled_at) AS canceled_at,

-- Status
COALESCE((
SELECT CASE
WHEN ds.status IS NOT NULL THEN ds.status
WHEN item.historico ->> 'eventCode' = '110111' THEN '3'
WHEN regexp_replace(item.historico ->> 'description', '[^0-9]', '', 'gi') = '110111' THEN '3'
ELSE '1'
END
FROM jsonb_array_elements(ds.history) WITH ORDINALITY item(historico, ordinality)
ORDER BY item.historico ->> 'eventAt' DESC
LIMIT 1
), ds.status) AS status,

doc.name_file,

-- Carta de Correção
(
SELECT json_agg(consulta.*)
FROM (
SELECT
d.data #>> '{procEventoNFe,evento,infEvento,dhEvento}' AS data_evento,
d.data #>> '{procEventoNFe,evento,infEvento,detEvento,xCorrecao}' AS correcao_evento
FROM document d
WHERE doc.key = d.key
AND doc.cnpj_issuer = d.cnpj_issuer
AND d.data #>> '{procEventoNFe,retEvento,infEvento,tpEvento}' = '110110'
) consulta
) AS carta_correcao,

doc.data #> '{nfe,infNFe,cobr,dup}' AS duplicatas,
doc.data #> '{nfe,infNFe,cobr,fat}' AS fatura,

cn.canhoto_importacao_id AS canhoto_id,
cn.created_at AS canhoto_associado_at,
cn.numero_nota AS canhoto_numero_nota,
COALESCE(cn.created_at, CURRENT_TIMESTAMP)::date - doc.data_emissao::date AS canhoto_diferenca_dias_associacao,

doc.data,

-- CFOPs
(
SELECT string_agg(DISTINCT item.value ->> 'cfop', ',')
FROM jsonb_array_elements(doc.data #> '{nfe,infNFe,det}') item(value)
) AS cfops,

-- Etiquetas
(
SELECT jsonb_agg(
jsonb_build_object(
'id', e.id,
'nome_etiqueta', e.nome_etiqueta,
'cor_etiqueta', e.cor_etiqueta,
'etiqueta_padrao', e.etiqueta_padrao,
'cnpj_empresa', e.cnpj_empresa
)
)
FROM etiqueta_documento ed
JOIN etiqueta e ON e.id = ed.id_etiqueta_atual
WHERE ed.chave_nfe = doc.key
) AS etiquetas,

-- Notas Referenciadas
(
SELECT string_agg(DISTINCT nota.referencia ->> 'refNFe', ', ')
FROM jsonb_array_elements(doc.data #> '{nfe,infNFe,ide,nfref}') WITH ORDINALITY nota(referencia, ordinality)
) AS notas_referencia,
nct.chave_cte AS cte_key
FROM document doc
JOIN document_status ds ON doc.key = ds.key AND doc.cnpj_issuer = ds.cnpj_issuer
LEFT JOIN canhoto_nota cn ON doc.key = cn.documento_chave AND doc.cnpj_issuer = cn.empresa_cnpj
LEFT JOIN nfe_cte nct ON doc.key = nct.chave_nfe
WHERE doc.group_type = 'NFE'
 0 1 7 7 0 0.00
graphCREATE OR REPLACE VIEW public.document_cte_view
AS SELECT doc.key,
ds.manifestation,
doc.type,
doc.protocol,
doc.nsu,
ds.status,
doc.data_emissao,
doc.data #>> '{cte,infCte,ide,nct}' AS numero_cte,
(doc.info #>> '{value}')::numeric AS value,
doc.data #>> '{cte,infCte,ide,serie}' AS serial,
doc.cnpj_issuer,
doc.data #>> '{cte,infCte,emit,id}' AS issuer_inscricao_estadual,
doc.info #>> '{issuerName}' AS issuer_name,
doc.cnpj_addressee AS addressee_cnpj_cpf,
doc.data #>> '{cte,infCte,dest,ie}' AS addressee_inscricao_estadual,
doc.info #>> '{addresseeName}' AS addressee_name,
doc.data #>> '{cte,infCte,exped,cnpj}' AS expedidor_cnpj,
doc.data #>> '{cte,infCte,exped,ie}' AS expedidor_inscricao_estadual,
doc.data #>> '{cte,infCte,exped,xnome}' AS expedidor_nome,
-- Recebedor pode ser CNPJ ou CPF
COALESCE(
doc.data #>> '{cte,infCte,receb,cnpj}',
doc.data #>> '{cte,infCte,receb,cpf}'
) AS recebedor_cnpj_cpf,
doc.data #>> '{cte,infCte,receb,ie}' AS recebedor_inscricao_estadual,
doc.data #>> '{cte,infCte,receb,xnome}' AS recebedor_nome,
-- Remetente pode ser CNPJ ou CPF
COALESCE(
doc.data #>> '{cte,infCte,rem,cnpj}',
doc.data #>> '{cte,infCte,rem,cpf}'
) AS remetente_cnpj_cpf,
doc.data #>> '{cte,infCte,rem,ie}' AS remetente_inscricao_estadual,
doc.data #>> '{cte,infCte,rem,xnome}' AS remetente_nome,
doc.data #>> '{cte,infCte,ide,toma3,toma}' AS tipo_tomador_servico,
doc.cnpj_cpf_tomador AS tomador4_cnpj,
-- Tomador4 pode ser Remetente, Expedidor, Recebedor, Destinatário ou outro
CASE
WHEN doc.data #>> '{cte,infCte,ide,toma3,toma}' = '0' THEN doc.data #>> '{cte,infCte,rem,ie}'
WHEN doc.data #>> '{cte,infCte,ide,toma3,toma}' = '1' THEN doc.data #>> '{cte,infCte,exped,ie}'
WHEN doc.data #>> '{cte,infCte,ide,toma3,toma}' = '2' THEN doc.data #>> '{cte,infCte,receb,ie}'
WHEN doc.data #>> '{cte,infCte,ide,toma3,toma}' = '3' THEN doc.data #>> '{cte,infCte,dest,ie}'
ELSE doc.data #>> '{cte,infCte,ide,toma4,ie}'
END AS tomador4_inscricao_estadual,
-- Tomador4 pode ser Remetente, Expedidor, Recebedor, Destinatário ou outro
CASE
WHEN doc.data #>> '{cte,infCte,ide,toma3,toma}' = '0' THEN doc.data #>> '{cte,infCte,rem,xNome}'
WHEN doc.data #>> '{cte,infCte,ide,toma3,toma}' = '1' THEN doc.data #>> '{cte,infCte,exped,xNome}'
WHEN doc.data #>> '{cte,infCte,ide,toma3,toma}' = '2' THEN doc.data #>> '{cte,infCte,receb,xNome}'
WHEN doc.data #>> '{cte,infCte,ide,toma3,toma}' = '3' THEN doc.info #>> '{addresseeName}'
ELSE doc.data #>> '{cte,infCte,ide,toma4,xNome}'
END AS tomador4_nome,
doc.cnpj_carrier,
(doc.data #>> '{cte,infCte,ide,tpCTe}')::integer AS tipo_cte,
ds.available_at,
ds.canceled_at,
doc.name_file,
doc.cnpj_cpf_remetente,
doc.schema,
COALESCE(
doc.data #>> '{cte,infCte,imp,icms,icms00,cst}',
doc.data #>> '{cte,infCte,imp,icms,icms20,cst}',
doc.data #>> '{cte,infCte,imp,icms,icms45,cst}',
doc.data #>> '{cte,infCte,imp,icms,icms60,cst}',
doc.data #>> '{cte,infCte,imp,icms,icms90,cst}',
doc.data #>> '{cte,infCte,imp,icms,icmsOutraUF,cst}',
doc.data #>> '{cte,infCte,imp,icms,icmssn,cst}'
) AS cst,
doc.data #>> '{cte,infCte,imp,icms,icms00,vbc}' AS vbc,
doc.data #>> '{cte,infCte,imp,icms,icms00,picms}' AS picms,
doc.data #>> '{cte,infCte,imp,icms,icms00,vicms}' AS vicms,
ARRAY(
SELECT infnfe ->> 'chave'
FROM jsonb_array_elements(doc.data #> '{cte,infCte,infCTeNorm,infDoc,infNFe}') infnfe
) AS chaves_nfe_documento,
nfe_assoc.chaves_nfe_associadas_sistema
FROM document doc
JOIN document_status ds ON doc.key::text = ds.key::text AND doc.cnpj_issuer::text = ds.cnpj_issuer::text
LEFT JOIN LATERAL (
SELECT array_agg(chave_nfe) AS chaves_nfe_associadas_sistema
FROM nfe_cte
WHERE nfe_cte.chave_cte = doc.key
) nfe_assoc ON TRUE
where doc.group_type = 'CTE'		 0 1 6 6 0 0.00
graphalter table public.configuracao_consolidacao
ADD COLUMN IF NOT EXISTS origem_contribuicoes boolean default false not null		 0 1 6 6 0 0.00
graphSELECT current_schema 0 3 2 2 0 0.00
graphalter table public.cnpj_consolidation
ADD COLUMN IF NOT EXISTS versao_consolidacao integer default 1 not null		 0 1 4 4 0 0.00
graphCREATE INDEX IF NOT EXISTS resumo_nfe_c_idx ON public.resumo_nfe USING btree (cnpj) 0 1 4 4 0 0.00
graphSELECT current_user 0 2 1 2 0 0.00
graphDROP VIEW IF EXISTS public.document_nfe_view 0 1 3 3 0 0.00
graph-- ============================
-- SPED ICMS / IPI
-- ============================
UPDATE configuracao_consolidacao
SET origem_icms_ipi = true
WHERE tipo_consolidacao IN (
'ANALISE_VENDA_PRODUTO',--OK
'ANALISE_VENDA_ESTADO_REGIAO',--OK XML - DEPENDE DE CONSOLIDAÇÃO ANALISE_VENDA_ESTADO_REGIAO --> SPED_EFD_ICMS_IPI
'ANALISE_COMPRA_ESTADO_REGIAO',--OK XML - DEPENDE DE CONSOLIDAÇÃO ANALISE_COMPRA_ESTADO_REGIAO --> SPED_EFD_ICMS_IPI
'ANALISE_REPRESENTATIVIDADE',--OK DEPENDE DE XML E SPED_EFD_ICMS_IPI
'CREDITO_ICMS_OPERACAO_ST_SUBSTITUIDO',--OK DEPENDE DE XML E SPED_EFD_ICMS_IPI
'EXCLUSAO_ICMS_BC_IPI',--OK DEPENDE DE XML E SPED_EFD_ICMS_IPI
'CONTRATACAO_FRETE_OPERACAO_ACUMULO_CREDITO',--OK DEPENDE DE XML E SPED_EFD_ICMS_IPI
'EXCLUSAO_DIFERENCIAL_ALIQUOTAS_ICMS_CALCULO_PIS_COFINS',--OK DEPENDE DE SPED_EFD_ICMS_IPI E SPED_EF_CONTRIBUIÇÕES
'EXCLUSAO_PIS_COFINS_BC_IPI',--OK DEPENDE DE XML E SPED_EFD_ICMS_IPI
'OPORTUNIDADE_DOCUMENT_CNPJ',--OK DEPENDE DE CONSOLIDACOES:
-- 1.ANALISE_EXCLUSAO_ICMS_BC_PIS_COFINS_RESTITUIR,
-- 2.ANALISE_PIS_COFINS_RESTITUIR_ISS,
-- 3.ANALISE_NAO_INCIDENCIA_SOBRE_CONTRATOS_EMPREITADA_GLOBAL,
-- 4.OPORTUNIDADE_RESSARCIMENTO_CIGARROS,
-- 5.EXCLUSAO_IPI_BASE_CALCULO_PIS_COFINS_ST,
-- 6.INCONSTITUCIONALIDADE_DIFAL_SIMPLES_NACIONAL,
-- 7.CREDITO_PIS_COFINS_AQUISICAO_INSUMOS_MATERIAL_RECICLADO,
-- 8.CREDITO_ICMS_OPERACAO_ST_SUBSTITUIDO,
-- 9.VALIDACAO_TRIBUTACAO_SAIDA_PRODUTOS_MONOFASICOS,
-- 10.RECALCULO_EXCLUSAO_GROSSUP_ICMS,
-- 11.EXCLUSAO_ICMSST_BASE_PIS_COFINS,
-- 12.EXCLUSAO_PIS_COFINS_BC_ICMS_RESTITUIR,
-- 13.EXCLUSAO_DIFERENCIAL_ALIQUOTAS_ICMS_CALCULO_PIS_COFINS,
-- 14.EXCLUSAO_ADICIONAL_ICMS_PIS_COFINS,
-- 15.EXCLUSAO_BASE_CALCULO_BENEFICIO_FISCAL,
-- 16.SIMPLES_NACIONAL_VENDAS_BRUTAS_X_COMPRAS_BRUTAS,
-- 17.ICMS_ST_SIMPLES_NACIONAL_CONSUMIDOR_FINAL,
-- 18.SIMPLES_NACIONAL_CREDITO_PIS_COFINS_MONOFASICO,
-- 19.EXCLUSAO_ICMS_BC_IPI,
-- 20.EXCLUSAO_PIS_COFINS_BC_IPI
'OPORTUNIDADE_TESE_JURIDICA_CNPJ' -- DEPENDE DE XML, DEPENDE DE SPED_EFD_ICMS_IPI E DEPENDE DE ANALISES:
-- 1.CREDITOS_POSSIVEIS_ICMS
)		 0 1 3 3 0 0.00
graphDROP VIEW IF EXISTS public.document_nfe_canhoto_view 0 1 3 3 0 0.00
graphCREATE OR REPLACE VIEW public.document_obrigacoes_view
AS SELECT document.key,
document.protocol,
document.cnpj_issuer,
document.nsu,
document.type,
document.cnpj,
document.imported_at,
document.name_file,
(CAST((document.data -> 'header'::text) ->> 'startsDate'::text as date)) AS starts_date,
(CAST((document.data -> 'header'::text) ->> 'endsDate'::text as date)) AS ends_date,
(document.data -> 'header'::text) ->> 'finalType'::text AS final_type,
(CAST(((document.data -> 'header'::text) ->> 'deliveryDate'::text) as timestamp)) AS delivery_date,
document.data ->> 'originalFileName'::text AS original_file_name,
document.data_emissao,
document.inscricao_estadual,
cast(coalesce(document.data -> 'header' ->> 'parcial', 'false') as boolean) as parcial
FROM document		 0 1 3 3 0 0.00
graph-- ============================
-- SPED CONTRIBUIÇÕES
-- ============================
UPDATE configuracao_consolidacao
SET origem_contribuicoes = true
WHERE tipo_consolidacao IN (
'CREDITO_PIS_COFINS_AQUISICAO_INSUMOS_MATERIAL_RECICLADO',--OK
'EXCLUSAO_ICMSST_BASE_PIS_COFINS',--OK DEPENDE DE XML E SPED_EF_CONTRIBUIÇÕES
'EXCLUSAO_PIS_COFINS_BC_ICMS_RESTITUIR',--OK DEPENDE DE XML E SPED_EF_CONTRIBUIÇÕES
'EXCLUSAO_DIFERENCIAL_ALIQUOTAS_ICMS_CALCULO_PIS_COFINS',--OK DEPENDE DE SPED_EFD_ICMS_IPI E SPED_EF_CONTRIBUIÇÕES
'OPORTUNIDADE_DOCUMENT_CNPJ',--OK DEPENDE DE CONSOLIDACOES:
-- 1.ANALISE_EXCLUSAO_ICMS_BC_PIS_COFINS_RESTITUIR,
-- 2.ANALISE_PIS_COFINS_RESTITUIR_ISS,
-- 3.ANALISE_NAO_INCIDENCIA_SOBRE_CONTRATOS_EMPREITADA_GLOBAL,
-- 4.OPORTUNIDADE_RESSARCIMENTO_CIGARROS,
-- 5.EXCLUSAO_IPI_BASE_CALCULO_PIS_COFINS_ST,
-- 6.INCONSTITUCIONALIDADE_DIFAL_SIMPLES_NACIONAL,
-- 7.CREDITO_PIS_COFINS_AQUISICAO_INSUMOS_MATERIAL_RECICLADO,
-- 8.CREDITO_ICMS_OPERACAO_ST_SUBSTITUIDO,
-- 9.VALIDACAO_TRIBUTACAO_SAIDA_PRODUTOS_MONOFASICOS,
-- 10.RECALCULO_EXCLUSAO_GROSSUP_ICMS,
-- 11.EXCLUSAO_ICMSST_BASE_PIS_COFINS,
-- 12.EXCLUSAO_PIS_COFINS_BC_ICMS_RESTITUIR,
-- 13.EXCLUSAO_DIFERENCIAL_ALIQUOTAS_ICMS_CALCULO_PIS_COFINS,
-- 14.EXCLUSAO_ADICIONAL_ICMS_PIS_COFINS,
-- 15.EXCLUSAO_BASE_CALCULO_BENEFICIO_FISCAL,
-- 16.SIMPLES_NACIONAL_VENDAS_BRUTAS_X_COMPRAS_BRUTAS,
-- 17.ICMS_ST_SIMPLES_NACIONAL_CONSUMIDOR_FINAL,
-- 18.SIMPLES_NACIONAL_CREDITO_PIS_COFINS_MONOFASICO,
-- 19.EXCLUSAO_ICMS_BC_IPI,
-- 20.EXCLUSAO_PIS_COFINS_BC_IPI
'OPORTUNIDADE_TESE_JURIDICA_CNPJ' -- DEPENDE DE XML, DEPENDE DE SPED_EFD_ICMS_IPI E DEPENDE DE ANALISES:
-- 1.CREDITOS_POSSIVEIS_ICMS


)		 0 1 3 3 0 0.00
graphalter table public.configuracao_consolidacao
ADD COLUMN IF NOT EXISTS versao_consolidacao integer default 1 not null		 0 1 3 3 0 0.00
graphalter table public.configuracao_consolidacao
ADD COLUMN IF NOT EXISTS origem_ecd boolean default false not null		 0 1 2 2 0 0.00
graph-- ============================
-- eSocial
-- ============================
UPDATE configuracao_consolidacao
SET origem_esocial = true
WHERE tipo_consolidacao IN (
'SIMPLES_NACIONAL_VENDAS_BRUTAS_X_COMPRAS_BRUTAS',--OK DEPENDE DE XML E ESOCIAL
'OPORTUNIDADE_DOCUMENT_CNPJ'--OK DEPENDE DE CONSOLIDACOES:
-- 1.ANALISE_EXCLUSAO_ICMS_BC_PIS_COFINS_RESTITUIR,
-- 2.ANALISE_PIS_COFINS_RESTITUIR_ISS,
-- 3.ANALISE_NAO_INCIDENCIA_SOBRE_CONTRATOS_EMPREITADA_GLOBAL,
-- 4.OPORTUNIDADE_RESSARCIMENTO_CIGARROS,
-- 5.EXCLUSAO_IPI_BASE_CALCULO_PIS_COFINS_ST,
-- 6.INCONSTITUCIONALIDADE_DIFAL_SIMPLES_NACIONAL,
-- 7.CREDITO_PIS_COFINS_AQUISICAO_INSUMOS_MATERIAL_RECICLADO,
-- 8.CREDITO_ICMS_OPERACAO_ST_SUBSTITUIDO,
-- 9.VALIDACAO_TRIBUTACAO_SAIDA_PRODUTOS_MONOFASICOS,
-- 10.RECALCULO_EXCLUSAO_GROSSUP_ICMS,
-- 11.EXCLUSAO_ICMSST_BASE_PIS_COFINS,
-- 12.EXCLUSAO_PIS_COFINS_BC_ICMS_RESTITUIR,
-- 13.EXCLUSAO_DIFERENCIAL_ALIQUOTAS_ICMS_CALCULO_PIS_COFINS,
-- 14.EXCLUSAO_ADICIONAL_ICMS_PIS_COFINS,
-- 15.EXCLUSAO_BASE_CALCULO_BENEFICIO_FISCAL,
-- 16.SIMPLES_NACIONAL_VENDAS_BRUTAS_X_COMPRAS_BRUTAS,
-- 17.ICMS_ST_SIMPLES_NACIONAL_CONSUMIDOR_FINAL,
-- 18.SIMPLES_NACIONAL_CREDITO_PIS_COFINS_MONOFASICO,
-- 19.EXCLUSAO_ICMS_BC_IPI,
-- 20.EXCLUSAO_PIS_COFINS_BC_IPI
)		 0 1 2 2 0 0.00
graphalter table public.configuracao_consolidacao
ADD COLUMN IF NOT EXISTS origem_esocial boolean default false not null		 0 1 2 2 0 0.00
graphcomment on column public.configuracao_consolidacao.origem_contribuicoes is 'Identificar se dados consolidados são oriundos do SPED Contribuições.' 0 1 2 2 0 0.00
graphalter table public.configuracao_consolidacao
ADD COLUMN IF NOT EXISTS origem_xml boolean default false not null		 0 1 2 2 0 0.00
graphalter table public.configuracao_consolidacao
ADD COLUMN IF NOT EXISTS origem_ecf boolean default false not null		 0 1 2 2 0 0.00
graphcomment on column public.configuracao_consolidacao.origem_esocial is 'Identificar se dados consolidados são oriundos do eSocial.' 0 1 2 2 0 0.00
graph-- ============================
-- XML
-- ============================
UPDATE configuracao_consolidacao
SET origem_xml = true
WHERE tipo_consolidacao IN (
-- 'ANALISE_ICMS_BASE_PIS_COFINS',--DESATIVADO
'ANALISE_VENDA_PRODUTO',--OK
'ANALISE_VENDA_ESTADO_REGIAO',--OK XML - DEPENDE DE CONSOLIDAÇÃO ANALISE_VENDA_ESTADO_REGIAO --> SPED_EFD_ICMS_IPI
'ANALISE_COMPRA_ESTADO_REGIAO',--OK XML - DEPENDE DE CONSOLIDAÇÃO ANALISE_COMPRA_ESTADO_REGIAO --> SPED_EFD_ICMS_IPI|
'ANALISE_PIS_COFINS_RESTITUIR_ICMS_ST',--OK
-- 'ANALISE_PIS_COFINS_RESTITUIR_ISS',--DESATIVADO
'ANALISE_REPRESENTATIVIDADE',--OK DEPENDE DE XML E SPED_EFD_ICMS_IPI
'ANALISE_NAO_INCIDENCIA_SOBRE_CONTRATOS_EMPREITADA_GLOBAL',--OK
'ANALISE_EXCLUSAO_ICMS_BC_PIS_COFINS_RESTITUIR',--OK
'ANALISE_SERVICO_PRESTADO_NFSE',--OK
'ANALISE_CLIENTE_NFSE',--OK
'ANALISE_SERVICOS_TOMADOS_NFSE',--OK
'ANALISE_FORNECEDORES_NFSE',--OK
'OPORTUNIDADE_RESSARCIMENTO_CIGARROS',--OK
'EXCLUSAO_IPI_BASE_CALCULO_PIS_COFINS_ST',--OK
'INCONSTITUCIONALIDADE_DIFAL_SIMPLES_NACIONAL',--OK
'CREDITO_PIS_COFINS_AQUISICAO_INSUMOS_MATERIAL_RECICLADO',--OK
'ANALISE_PM_PF',--OK DEPENDE DE XML E CONFAZ
'CREDITO_ICMS_OPERACAO_ST_SUBSTITUIDO',--OK DEPENDE DE XML E SPED_EFD_ICMS_IPI
'CHECAGEM_ALIQUOTA_ICMS',--OK
'VALIDACAO_TRIBUTACAO_SAIDA_PRODUTOS_MONOFASICOS', --OK
'CONTRATACAO_FRETE_OPERACAO_ACUMULO_CREDITO',--OK DEPENDE DE XML E SPED_EFD_ICMS_IPI
'RECALCULO_EXCLUSAO_GROSSUP_ICMS',--OK
'EXCLUSAO_ICMSST_BASE_PIS_COFINS',--OK DEPENDE DE XML E SPED_EF_CONTRIBUIÇÕES
'EXCLUSAO_PIS_COFINS_BC_ICMS_RESTITUIR',--OK DEPENDE DE XML E SPED_EF_CONTRIBUIÇÕES
'EXCLUSAO_ADICIONAL_ICMS_PIS_COFINS',--OK DEPENDE XML
'EXCLUSAO_BASE_CALCULO_BENEFICIO_FISCAL',--OK DEPENDE XML
'SIMPLES_NACIONAL_VENDAS_BRUTAS_X_COMPRAS_BRUTAS',--OK DEPENDE DE XML E ESOCIAL
'ICMS_ST_SIMPLES_NACIONAL_CONSUMIDOR_FINAL',--OK DEPENDE XML
'SIMPLES_NACIONAL_CREDITO_PIS_COFINS_MONOFASICO',--OK DEPENDE XML
'EXCLUSAO_ICMS_BC_IPI',--OK DEPENDE DE XML E SPED_EFD_ICMS_IPI
'EXCLUSAO_PIS_COFINS_BC_IPI',--OK DEPENDE DE XML E SPED_EFD_ICMS_IPI
'OPORTUNIDADE_DOCUMENT_CNPJ',--OK DEPENDE DE CONSOLIDACOES:
-- 1.ANALISE_EXCLUSAO_ICMS_BC_PIS_COFINS_RESTITUIR,
-- 2.ANALISE_PIS_COFINS_RESTITUIR_ISS,
-- 3.ANALISE_NAO_INCIDENCIA_SOBRE_CONTRATOS_EMPREITADA_GLOBAL,
-- 4.OPORTUNIDADE_RESSARCIMENTO_CIGARROS,
-- 5.EXCLUSAO_IPI_BASE_CALCULO_PIS_COFINS_ST,
-- 6.INCONSTITUCIONALIDADE_DIFAL_SIMPLES_NACIONAL,
-- 7.CREDITO_PIS_COFINS_AQUISICAO_INSUMOS_MATERIAL_RECICLADO,
-- 8.CREDITO_ICMS_OPERACAO_ST_SUBSTITUIDO,
-- 9.VALIDACAO_TRIBUTACAO_SAIDA_PRODUTOS_MONOFASICOS,
-- 10.RECALCULO_EXCLUSAO_GROSSUP_ICMS,
-- 11.EXCLUSAO_ICMSST_BASE_PIS_COFINS,
-- 12.EXCLUSAO_PIS_COFINS_BC_ICMS_RESTITUIR,
-- 13.EXCLUSAO_DIFERENCIAL_ALIQUOTAS_ICMS_CALCULO_PIS_COFINS,
-- 14.EXCLUSAO_ADICIONAL_ICMS_PIS_COFINS,
-- 15.EXCLUSAO_BASE_CALCULO_BENEFICIO_FISCAL,
-- 16.SIMPLES_NACIONAL_VENDAS_BRUTAS_X_COMPRAS_BRUTAS,
-- 17.ICMS_ST_SIMPLES_NACIONAL_CONSUMIDOR_FINAL,
-- 18.SIMPLES_NACIONAL_CREDITO_PIS_COFINS_MONOFASICO,
-- 19.EXCLUSAO
Details

-- ============================
-- XML
-- ============================
UPDATE configuracao_consolidacao
SET origem_xml = true
WHERE tipo_consolidacao IN (
-- 'ANALISE_ICMS_BASE_PIS_COFINS',--DESATIVADO
'ANALISE_VENDA_PRODUTO',--OK
'ANALISE_VENDA_ESTADO_REGIAO',--OK XML - DEPENDE DE CONSOLIDAÇÃO ANALISE_VENDA_ESTADO_REGIAO --> SPED_EFD_ICMS_IPI
'ANALISE_COMPRA_ESTADO_REGIAO',--OK XML - DEPENDE DE CONSOLIDAÇÃO ANALISE_COMPRA_ESTADO_REGIAO --> SPED_EFD_ICMS_IPI|
'ANALISE_PIS_COFINS_RESTITUIR_ICMS_ST',--OK
-- 'ANALISE_PIS_COFINS_RESTITUIR_ISS',--DESATIVADO
'ANALISE_REPRESENTATIVIDADE',--OK DEPENDE DE XML E SPED_EFD_ICMS_IPI
'ANALISE_NAO_INCIDENCIA_SOBRE_CONTRATOS_EMPREITADA_GLOBAL',--OK
'ANALISE_EXCLUSAO_ICMS_BC_PIS_COFINS_RESTITUIR',--OK
'ANALISE_SERVICO_PRESTADO_NFSE',--OK
'ANALISE_CLIENTE_NFSE',--OK
'ANALISE_SERVICOS_TOMADOS_NFSE',--OK
'ANALISE_FORNECEDORES_NFSE',--OK
'OPORTUNIDADE_RESSARCIMENTO_CIGARROS',--OK
'EXCLUSAO_IPI_BASE_CALCULO_PIS_COFINS_ST',--OK
'INCONSTITUCIONALIDADE_DIFAL_SIMPLES_NACIONAL',--OK
'CREDITO_PIS_COFINS_AQUISICAO_INSUMOS_MATERIAL_RECICLADO',--OK
'ANALISE_PM_PF',--OK DEPENDE DE XML E CONFAZ
'CREDITO_ICMS_OPERACAO_ST_SUBSTITUIDO',--OK DEPENDE DE XML E SPED_EFD_ICMS_IPI
'CHECAGEM_ALIQUOTA_ICMS',--OK
'VALIDACAO_TRIBUTACAO_SAIDA_PRODUTOS_MONOFASICOS', --OK
'CONTRATACAO_FRETE_OPERACAO_ACUMULO_CREDITO',--OK DEPENDE DE XML E SPED_EFD_ICMS_IPI
'RECALCULO_EXCLUSAO_GROSSUP_ICMS',--OK
'EXCLUSAO_ICMSST_BASE_PIS_COFINS',--OK DEPENDE DE XML E SPED_EF_CONTRIBUIÇÕES
'EXCLUSAO_PIS_COFINS_BC_ICMS_RESTITUIR',--OK DEPENDE DE XML E SPED_EF_CONTRIBUIÇÕES
'EXCLUSAO_ADICIONAL_ICMS_PIS_COFINS',--OK DEPENDE XML
'EXCLUSAO_BASE_CALCULO_BENEFICIO_FISCAL',--OK DEPENDE XML
'SIMPLES_NACIONAL_VENDAS_BRUTAS_X_COMPRAS_BRUTAS',--OK DEPENDE DE XML E ESOCIAL
'ICMS_ST_SIMPLES_NACIONAL_CONSUMIDOR_FINAL',--OK DEPENDE XML
'SIMPLES_NACIONAL_CREDITO_PIS_COFINS_MONOFASICO',--OK DEPENDE XML
'EXCLUSAO_ICMS_BC_IPI',--OK DEPENDE DE XML E SPED_EFD_ICMS_IPI
'EXCLUSAO_PIS_COFINS_BC_IPI',--OK DEPENDE DE XML E SPED_EFD_ICMS_IPI
'OPORTUNIDADE_DOCUMENT_CNPJ',--OK DEPENDE DE CONSOLIDACOES:
-- 1.ANALISE_EXCLUSAO_ICMS_BC_PIS_COFINS_RESTITUIR,
-- 2.ANALISE_PIS_COFINS_RESTITUIR_ISS,
-- 3.ANALISE_NAO_INCIDENCIA_SOBRE_CONTRATOS_EMPREITADA_GLOBAL,
-- 4.OPORTUNIDADE_RESSARCIMENTO_CIGARROS,
-- 5.EXCLUSAO_IPI_BASE_CALCULO_PIS_COFINS_ST,
-- 6.INCONSTITUCIONALIDADE_DIFAL_SIMPLES_NACIONAL,
-- 7.CREDITO_PIS_COFINS_AQUISICAO_INSUMOS_MATERIAL_RECICLADO,
-- 8.CREDITO_ICMS_OPERACAO_ST_SUBSTITUIDO,
-- 9.VALIDACAO_TRIBUTACAO_SAIDA_PRODUTOS_MONOFASICOS,
-- 10.RECALCULO_EXCLUSAO_GROSSUP_ICMS,
-- 11.EXCLUSAO_ICMSST_BASE_PIS_COFINS,
-- 12.EXCLUSAO_PIS_COFINS_BC_ICMS_RESTITUIR,
-- 13.EXCLUSAO_DIFERENCIAL_ALIQUOTAS_ICMS_CALCULO_PIS_COFINS,
-- 14.EXCLUSAO_ADICIONAL_ICMS_PIS_COFINS,
-- 15.EXCLUSAO_BASE_CALCULO_BENEFICIO_FISCAL,
-- 16.SIMPLES_NACIONAL_VENDAS_BRUTAS_X_COMPRAS_BRUTAS,
-- 17.ICMS_ST_SIMPLES_NACIONAL_CONSUMIDOR_FINAL,
-- 18.SIMPLES_NACIONAL_CREDITO_PIS_COFINS_MONOFASICO,
-- 19.EXCLUSAO_ICMS_BC_IPI,
-- 20.EXCLUSAO_PIS_COFINS_BC_IPI
'OPORTUNIDADE_TESE_JURIDICA_CNPJ' -- DEPENDE DE XML, DEPENDE DE SPED_EFD_ICMS_IPI E DEPENDE DE ANALISES:
-- 1.CREDITOS_POSSIVEIS_ICMS
)
 0 1 2 2 0 0.00
graphCREATE TABLE IF NOT EXISTS public.resumo_nfe (
id int8 NOT NULL GENERATED BY DEFAULT AS IDENTITY,
cnpj varchar(14) NULL,
key varchar(44) NULL,
name_file varchar(255) NULL,
status varchar(255) NULL,
prioridade int8 NULL,
create_at timestamptz NULL,
update_at timestamptz NULL,
CONSTRAINT resumo_nfe_pkey PRIMARY KEY (id)
)		 0 1 2 2 0 0.00
graphCREATE UNIQUE INDEX IF NOT EXISTS resumo_nfe_c_k_idx ON public.resumo_nfe USING btree (cnpj, key) 0 1 2 2 0 0.00
graphSELECT CURRENT_USER 0 1 2 2 0 0.00
graphcomment on column public.configuracao_consolidacao.origem_icms_ipi is 'Identificar se dados consolidados são oriundos do SPED ICMS IPI.' 0 1 2 2 0 0.00
graphcomment on column public.configuracao_consolidacao.origem_ecd is 'Identificar se dados consolidados são oriundos do SPED ECD.' 0 1 2 2 0 0.00
graphalter table public.configuracao_consolidacao
ADD COLUMN IF NOT EXISTS origem_icms_ipi boolean default false not null		 0 1 2 2 0 0.00
graphcomment on column public.configuracao_consolidacao.versao_consolidacao is 'Identificar a versao em que a consolidação se encontra.' 0 1 2 2 0 0.00
graphcomment on column public.configuracao_consolidacao.origem_xml is 'Identificar se dados consolidados são oriundos de XML.' 0 1 2 2 0 0.00
graphCREATE TABLE IF NOT EXISTS public.resumo_nfe_prioridade (
cnpj varchar(14) NOT NULL,
prioridade int8 NULL,
CONSTRAINT resumo_nfe_prioridade_pkey PRIMARY KEY (cnpj)
)		 0 1 2 2 0 0.00
graphCREATE INDEX IF NOT EXISTS resumo_nfe_c_s_idx ON public.resumo_nfe USING btree (cnpj, status) 0 1 2 2 0 0.00
graphcomment on column public.cnpj_consolidation.versao_consolidacao is 'Identificar versão da consolidação em que os dados foram consolidados.' 0 1 1 1 0 0.00
graphcomment on column public.configuracao_consolidacao.origem_ecf is 'Identificar se dados consolidados são oriundos do SPED ECF.' 0 1 1 1 0 0.00

spring Statistics spring - all

Request% of cumulative timeHitsMean time (ms)Max time (ms)Standard deviation% of cumulative cpu timeMean cpu time (ms)Mean allocated Kb% of system errorMean hits sqlMean time sql (ms)
spring global 100 3 6,036 9,055 5,225 100 76 15,162 0.00 0 5,953
spring warning 0 0 -1 0 -1 0 -1 -1 0.00 -1 -1
spring severe 0 0 -1 0 -1 0 -1 -1 0.00 -1 -1
3 hits/min on 3 requests       Summary by class       Dependencies       Details       Clear
Request% of cumulative timeHitsMean time (ms)Max time (ms)Standard deviation% of cumulative cpu timeMean cpu time (ms)Mean allocated Kb% of system errorMean hits sqlMean time sql (ms)
graphCreditoTeseArtigo426AController.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm 50 1 9,055 9,055 0 50 115 22,479 0.00 1 8,930
graphCreditoTeseArtigo426AServiceImpl.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm 49 1 9,051 9,051 0 48 111 21,679 0.00 1 8,930
graphBasicErrorController.error 0 1 3 3 0 1 3 1,328 0.00 0 0

error Statistics http system errors - all

Error% of cumulative timeHitsMean time (ms)Max time (ms)Standard deviation% of cumulative cpu timeMean cpu time (ms)Mean allocated Kb
Error404 100 1 7 7 0 100 6 801
1 hits/min on 1 errors       Details       Last errors       Clear
Error% of cumulative timeHitsMean time (ms)Max time (ms)Standard deviation% of cumulative cpu timeMean cpu time (ms)Mean allocated Kb
Error404 100 1 7 7 0 100 6 801
DateRequestError
9/29/25, 6:09:36 PM/robots.txt GETError404

log Statistics system errors logs - all

None
Clear all statistics

Current requests Current requests

ThreadUserRequestElapsed time (ms)Mean time (ms)Cpu time (ms)Mean cpu time (ms)Hits sqlMean hits sqlTime sql (ms)Mean time sql (ms)Executed methodKill
XNIO-1 task-3
java.base@11.0.23/java.net.SocketInputStream.socketRead0(Native Method)
java.base@11.0.23/java.net.SocketInputStream.socketRead(Unknown Source)
java.base@11.0.23/java.net.SocketInputStream.read(Unknown Source)
java.base@11.0.23/java.net.SocketInputStream.read(Unknown Source)
java.base@11.0.23/sun.security.ssl.SSLSocketInputRecord.read(Unknown Source)
java.base@11.0.23/sun.security.ssl.SSLSocketInputRecord.readHeader(Unknown Source)
java.base@11.0.23/sun.security.ssl.SSLSocketInputRecord.bytesInCompletePacket(Unknown Source)
java.base@11.0.23/sun.security.ssl.SSLSocketImpl.readApplicationRecord(Unknown Source)
java.base@11.0.23/sun.security.ssl.SSLSocketImpl$AppInputStream.read(Unknown Source)
app//org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBufferedInputStream.java:161)
app//org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:128)
app//org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:113)
app//org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedInputStream.java:73)
app//org.postgresql.core.PGStream.receiveChar(PGStream.java:441)
app//org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2057)
app//org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323)
app//org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:473)
app//org.postgresql.jdbc.PgStatement.execute(PgStatement.java:393)
app//org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:164)
app//org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:114)
app//com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
app//com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
jdk.internal.reflect.GeneratedMethodAccessor47.invoke(Unknown Source)
java.base@11.0.23/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.base@11.0.23/java.lang.reflect.Method.invoke(Unknown Source)
app//net.bull.javamelody.JdbcWrapper.doExecute(JdbcWrapper.java:422)
app//net.bull.javamelody.JdbcWrapper$StatementInvocationHandler.invoke(JdbcWrapper.java:142)
app//net.bull.javamelody.JdbcWrapper$DelegatingInvocationHandler.invoke(JdbcWrapper.java:300)
app//com.sun.proxy.$Proxy131.executeQuery(Unknown Source)
app//org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57)
app//org.hibernate.loader.Loader.getResultSet(Loader.java:2304)
app//org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2057)
app//org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2019)
app//org.hibernate.loader.Loader.doQuery(Loader.java:948)
app//org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:349)
app//org.hibernate.loader.Loader.doList(Loader.java:2850)
app//org.hibernate.loader.Loader.doList(Loader.java:2832)
app//org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2664)
app//org.hibernate.loader.Loader.list(Loader.java:2659)
app//org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:338)
app//org.hibernate.internal.SessionImpl.listCustomQuery(SessionImpl.java:2141)
app//org.hibernate.internal.AbstractSharedSessionContract.list(AbstractSharedSessionContract.java:1163)
app//org.hibernate.query.internal.NativeQueryImpl.doList(NativeQueryImpl.java:173)
app//org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1533)
app//org.hibernate.query.Query.getResultList(Query.java:165)
app//org.springframework.data.jpa.repository.query.JpaQueryExecution$SlicedExecution.doExecute(JpaQueryExecution.java:156)
app//org.springframework.data.jpa.repository.query.JpaQueryExecution.execute(JpaQueryExecution.java:88)
app//org.springframework.data.jpa.repository.query.AbstractJpaQuery.doExecute(AbstractJpaQuery.java:154)
app//org.springframework.data.jpa.repository.query.AbstractJpaQuery.execute(AbstractJpaQuery.java:142)
app//org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor$QueryMethodInvoker.invoke(QueryExecutorMethodInterceptor.java:195)
app//org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.doInvoke(QueryExecutorMethodInterceptor.java:152)
app//org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.invoke(QueryExecutorMethodInterceptor.java:130)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:80)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.transaction.interceptor.TransactionInterceptor$$Lambda$1687/0x0000000840f68040.proceedWithInvocation(Unknown Source)
app//org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367)
app//org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:149)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
com.sun.proxy.$Proxy408.findAllCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(Unknown Source)
java.base@11.0.23/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
java.base@11.0.23/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
java.base@11.0.23/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.base@11.0.23/java.lang.reflect.Method.invoke(Unknown Source)
app//org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
app//org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:205)
com.sun.proxy.$Proxy208.findAllCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(Unknown Source)
br.com.revizia.documentapi.v2.creditoteseartigo426a.service.impl.CreditoTeseArtigo426AServiceImpl.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(CreditoTeseArtigo426AServiceImpl.java:28)
br.com.revizia.documentapi.v2.creditoteseartigo426a.service.impl.CreditoTeseArtigo426AServiceImpl$$FastClassBySpringCGLIB$$91ed21a6.invoke(<generated>)
app//org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
app//org.springframework.transaction.interceptor.TransactionInterceptor$$Lambda$1687/0x0000000840f68040.proceedWithInvocation(Unknown Source)
app//org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367)
app//org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
app//net.bull.javamelody.MonitoringSpringInterceptor.invoke(MonitoringSpringInterceptor.java:76)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
app//org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691)
br.com.revizia.documentapi.v2.creditoteseartigo426a.service.impl.CreditoTeseArtigo426AServiceImpl$$EnhancerBySpringCGLIB$$5861cb4e.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(<generated>)
br.com.revizia.documentapi.v2.creditoteseartigo426a.controller.CreditoTeseArtigo426AController.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(CreditoTeseArtigo426AController.java:37)
br.com.revizia.documentapi.v2.creditoteseartigo426a.controller.CreditoTeseArtigo426AController$$FastClassBySpringCGLIB$$3455e92e.invoke(<generated>)
app//org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
app//net.bull.javamelody.MonitoringSpringInterceptor.invoke(MonitoringSpringInterceptor.java:76)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
app//org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691)
br.com.revizia.documentapi.v2.creditoteseartigo426a.controller.CreditoTeseArtigo426AController$$EnhancerBySpringCGLIB$$204b93d5.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(<generated>)
java.base@11.0.23/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
java.base@11.0.23/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
java.base@11.0.23/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.base@11.0.23/java.lang.reflect.Method.invoke(Unknown Source)
app//org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
app//org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
app//org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105)
app//org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:878)
app//org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:792)
app//org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
app//org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)
app//org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)
app//org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
app//org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
app//javax.servlet.http.HttpServlet.service(HttpServlet.java:517)
app//org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
app//javax.servlet.http.HttpServlet.service(HttpServlet.java:584)
app//io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:113)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:113)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:239)
app//net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:215)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320)
app//org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126)
app//org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:118)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:158)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
br.com.revizia.documentapi.config.security.jwt.JwtTokenFilter.doFilterInternal(JwtTokenFilter.java:86)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:92)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.header.HeaderWriterFilter.doHeadersAfter(HeaderWriterFilter.java:92)
app//org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:77)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215)
app//org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178)
app//org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:358)
app//org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:271)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:93)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
app//io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
app//io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
app//io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
app//io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
app//io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:132)
app//io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
app//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
app//io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
app//io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
app//io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
app//io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
app//io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
app//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
app//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
app//io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
app//io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:269)
app//io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:78)
app//io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:133)
app//io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:130)
app//io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
app//io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
app//io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:249)
app//io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:78)
app//io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:99)
app//io.undertow.server.Connectors.executeRootHandler(Connectors.java:370)
app//io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:836)
app//org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
app//org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:2019)
app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1558)
app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1449)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 XNIO-1 task-3
 UsuarioAutenticadoParaServicos{id=3, email='revizia-cron-job@revizia.com.br'}
http graph/api/nfe/credito-tese-artigo-426a/71605265010205/period?dataInicio=2022-09-01T00:00&dataFim=2022-09-30T23:59:59.999999999&page=14&size=1000 POST
spring graphCreditoTeseArtigo426AController.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm
spring graphCreditoTeseArtigo426AServiceImpl.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm
sql graphSELECT d.cnpj_issuer as cnpj, to_date(to_char(d.data_emissao, 'yyyy-MM-dd'), 'yyyy-MM-dd') as dataEmissao, d.key AS chaveNfe, d.data -> 'nfe' -> 'infNFe' -> 'ide' ->> 'nnf' AS numeroNfe, item.produto -> 'prod' ->> 'cprod' as codigoProduto, item.produto -> 'prod' ->> 'xprod' AS descricaoProduto, item.produto -> 'prod' ->> 'ncm' as codigoNcm, item.produto -> 'prod' ->> 'cfop' as cfop, CAST(item.produto -> 'prod' ->> 'vprod' AS NUMERIC) as valorProduto FROM document d , jsonb_array_elements(d.data -> 'nfe' -> 'infNFe' -> 'det') WITH ORDINALITY item(produto) WHERE d.cnpj_issuer IN (?) AND d.type IN ('NFE_2_0','NFE_3_1','NFE_4_0') AND data_emissao BETWEEN ? and ? AND item.produto -> 'prod' ->> 'cfop' IN ('5405', '5409') AND item.produto -> 'prod' ->> 'ncm' IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)ORDER BY d.key limit ? offset ?
 http 8,422
spring 8,418
spring 8,418
sql 8,413		 9,147
9,055
9,051
8,930		 7
3
3
 		 206
115
111
 		 0
0
0
 		 1
1
1
 		 0
0
0
 		 8,930
8,930
8,930
 		 java.base@11.0.23/java.net.SocketInputStream.socketRead0(Native Method) Kill the thread XNIO-1 task-3
2 current requests       PDF PDF      Current requests View in a new page       Details      
ThreadUserRequestElapsed time (ms)Mean time (ms)Cpu time (ms)Mean cpu time (ms)Hits sqlMean hits sqlTime sql (ms)Mean time sql (ms)Executed methodKill
XNIO-1 task-3
java.base@11.0.23/java.net.SocketInputStream.socketRead0(Native Method)
java.base@11.0.23/java.net.SocketInputStream.socketRead(Unknown Source)
java.base@11.0.23/java.net.SocketInputStream.read(Unknown Source)
java.base@11.0.23/java.net.SocketInputStream.read(Unknown Source)
java.base@11.0.23/sun.security.ssl.SSLSocketInputRecord.read(Unknown Source)
java.base@11.0.23/sun.security.ssl.SSLSocketInputRecord.readHeader(Unknown Source)
java.base@11.0.23/sun.security.ssl.SSLSocketInputRecord.bytesInCompletePacket(Unknown Source)
java.base@11.0.23/sun.security.ssl.SSLSocketImpl.readApplicationRecord(Unknown Source)
java.base@11.0.23/sun.security.ssl.SSLSocketImpl$AppInputStream.read(Unknown Source)
app//org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBufferedInputStream.java:161)
app//org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:128)
app//org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:113)
app//org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedInputStream.java:73)
app//org.postgresql.core.PGStream.receiveChar(PGStream.java:441)
app//org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2057)
app//org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323)
app//org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:473)
app//org.postgresql.jdbc.PgStatement.execute(PgStatement.java:393)
app//org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:164)
app//org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:114)
app//com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
app//com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
jdk.internal.reflect.GeneratedMethodAccessor47.invoke(Unknown Source)
java.base@11.0.23/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.base@11.0.23/java.lang.reflect.Method.invoke(Unknown Source)
app//net.bull.javamelody.JdbcWrapper.doExecute(JdbcWrapper.java:422)
app//net.bull.javamelody.JdbcWrapper$StatementInvocationHandler.invoke(JdbcWrapper.java:142)
app//net.bull.javamelody.JdbcWrapper$DelegatingInvocationHandler.invoke(JdbcWrapper.java:300)
app//com.sun.proxy.$Proxy131.executeQuery(Unknown Source)
app//org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57)
app//org.hibernate.loader.Loader.getResultSet(Loader.java:2304)
app//org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2057)
app//org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2019)
app//org.hibernate.loader.Loader.doQuery(Loader.java:948)
app//org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:349)
app//org.hibernate.loader.Loader.doList(Loader.java:2850)
app//org.hibernate.loader.Loader.doList(Loader.java:2832)
app//org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2664)
app//org.hibernate.loader.Loader.list(Loader.java:2659)
app//org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:338)
app//org.hibernate.internal.SessionImpl.listCustomQuery(SessionImpl.java:2141)
app//org.hibernate.internal.AbstractSharedSessionContract.list(AbstractSharedSessionContract.java:1163)
app//org.hibernate.query.internal.NativeQueryImpl.doList(NativeQueryImpl.java:173)
app//org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1533)
app//org.hibernate.query.Query.getResultList(Query.java:165)
app//org.springframework.data.jpa.repository.query.JpaQueryExecution$SlicedExecution.doExecute(JpaQueryExecution.java:156)
app//org.springframework.data.jpa.repository.query.JpaQueryExecution.execute(JpaQueryExecution.java:88)
app//org.springframework.data.jpa.repository.query.AbstractJpaQuery.doExecute(AbstractJpaQuery.java:154)
app//org.springframework.data.jpa.repository.query.AbstractJpaQuery.execute(AbstractJpaQuery.java:142)
app//org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor$QueryMethodInvoker.invoke(QueryExecutorMethodInterceptor.java:195)
app//org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.doInvoke(QueryExecutorMethodInterceptor.java:152)
app//org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.invoke(QueryExecutorMethodInterceptor.java:130)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:80)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.transaction.interceptor.TransactionInterceptor$$Lambda$1687/0x0000000840f68040.proceedWithInvocation(Unknown Source)
app//org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367)
app//org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:149)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
com.sun.proxy.$Proxy408.findAllCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(Unknown Source)
java.base@11.0.23/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
java.base@11.0.23/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
java.base@11.0.23/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.base@11.0.23/java.lang.reflect.Method.invoke(Unknown Source)
app//org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
app//org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:205)
com.sun.proxy.$Proxy208.findAllCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(Unknown Source)
br.com.revizia.documentapi.v2.creditoteseartigo426a.service.impl.CreditoTeseArtigo426AServiceImpl.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(CreditoTeseArtigo426AServiceImpl.java:28)
br.com.revizia.documentapi.v2.creditoteseartigo426a.service.impl.CreditoTeseArtigo426AServiceImpl$$FastClassBySpringCGLIB$$91ed21a6.invoke(<generated>)
app//org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
app//org.springframework.transaction.interceptor.TransactionInterceptor$$Lambda$1687/0x0000000840f68040.proceedWithInvocation(Unknown Source)
app//org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367)
app//org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
app//net.bull.javamelody.MonitoringSpringInterceptor.invoke(MonitoringSpringInterceptor.java:76)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
app//org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691)
br.com.revizia.documentapi.v2.creditoteseartigo426a.service.impl.CreditoTeseArtigo426AServiceImpl$$EnhancerBySpringCGLIB$$5861cb4e.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(<generated>)
br.com.revizia.documentapi.v2.creditoteseartigo426a.controller.CreditoTeseArtigo426AController.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(CreditoTeseArtigo426AController.java:37)
br.com.revizia.documentapi.v2.creditoteseartigo426a.controller.CreditoTeseArtigo426AController$$FastClassBySpringCGLIB$$3455e92e.invoke(<generated>)
app//org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
app//net.bull.javamelody.MonitoringSpringInterceptor.invoke(MonitoringSpringInterceptor.java:76)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
app//org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691)
br.com.revizia.documentapi.v2.creditoteseartigo426a.controller.CreditoTeseArtigo426AController$$EnhancerBySpringCGLIB$$204b93d5.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(<generated>)
java.base@11.0.23/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
java.base@11.0.23/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
java.base@11.0.23/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.base@11.0.23/java.lang.reflect.Method.invoke(Unknown Source)
app//org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
app//org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
app//org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105)
app//org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:878)
app//org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:792)
app//org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
app//org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)
app//org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)
app//org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
app//org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
app//javax.servlet.http.HttpServlet.service(HttpServlet.java:517)
app//org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
app//javax.servlet.http.HttpServlet.service(HttpServlet.java:584)
app//io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:113)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:113)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:239)
app//net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:215)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320)
app//org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126)
app//org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:118)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:158)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
br.com.revizia.documentapi.config.security.jwt.JwtTokenFilter.doFilterInternal(JwtTokenFilter.java:86)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:92)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.header.HeaderWriterFilter.doHeadersAfter(HeaderWriterFilter.java:92)
app//org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:77)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215)
app//org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178)
app//org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:358)
app//org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:271)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:93)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
app//io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
app//io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
app//io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
app//io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
app//io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:132)
app//io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
app//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
app//io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
app//io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
app//io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
app//io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
app//io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
app//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
app//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
app//io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
app//io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:269)
app//io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:78)
app//io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:133)
app//io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:130)
app//io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
app//io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
app//io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:249)
app//io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:78)
app//io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:99)
app//io.undertow.server.Connectors.executeRootHandler(Connectors.java:370)
app//io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:836)
app//org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
app//org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:2019)
app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1558)
app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1449)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 XNIO-1 task-3
 UsuarioAutenticadoParaServicos{id=3, email='revizia-cron-job@revizia.com.br'}
http graph/api/nfe/credito-tese-artigo-426a/71605265010205/period?dataInicio=2022-09-01T00:00&dataFim=2022-09-30T23:59:59.999999999&page=14&size=1000 POST
spring graphCreditoTeseArtigo426AController.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm
spring graphCreditoTeseArtigo426AServiceImpl.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm
sql graphSELECT d.cnpj_issuer as cnpj, to_date(to_char(d.data_emissao, 'yyyy-MM-dd'), 'yyyy-MM-dd') as dataEmissao, d.key AS chaveNfe, d.data -> 'nfe' -> 'infNFe' -> 'ide' ->> 'nnf' AS numeroNfe, item.produto -> 'prod' ->> 'cprod' as codigoProduto, item.produto -> 'prod' ->> 'xprod' AS descricaoProduto, item.produto -> 'prod' ->> 'ncm' as codigoNcm, item.produto -> 'prod' ->> 'cfop' as cfop, CAST(item.produto -> 'prod' ->> 'vprod' AS NUMERIC) as valorProduto FROM document d , jsonb_array_elements(d.data -> 'nfe' -> 'infNFe' -> 'det') WITH ORDINALITY item(produto) WHERE d.cnpj_issuer IN (?) AND d.type IN ('NFE_2_0','NFE_3_1','NFE_4_0') AND data_emissao BETWEEN ? and ? AND item.produto -> 'prod' ->> 'cfop' IN ('5405', '5409') AND item.produto -> 'prod' ->> 'ncm' IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)ORDER BY d.key limit ? offset ?
 http 8,422
spring 8,418
spring 8,418
sql 8,413		 9,147
9,055
9,051
8,930		 7
3
3
 		 206
115
111
 		 0
0
0
 		 1
1
1
 		 0
0
0
 		 8,930
8,930
8,930
 		 java.base@11.0.23/java.net.SocketInputStream.socketRead0(Native Method) Kill the thread XNIO-1 task-3
XNIO-1 task-1
java.base@11.0.23/java.net.SocketInputStream.socketRead0(Native Method)
java.base@11.0.23/java.net.SocketInputStream.socketRead(Unknown Source)
java.base@11.0.23/java.net.SocketInputStream.read(Unknown Source)
java.base@11.0.23/java.net.SocketInputStream.read(Unknown Source)
java.base@11.0.23/sun.security.ssl.SSLSocketInputRecord.read(Unknown Source)
java.base@11.0.23/sun.security.ssl.SSLSocketInputRecord.readHeader(Unknown Source)
java.base@11.0.23/sun.security.ssl.SSLSocketInputRecord.bytesInCompletePacket(Unknown Source)
java.base@11.0.23/sun.security.ssl.SSLSocketImpl.readApplicationRecord(Unknown Source)
java.base@11.0.23/sun.security.ssl.SSLSocketImpl$AppInputStream.read(Unknown Source)
app//org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBufferedInputStream.java:161)
app//org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:128)
app//org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:113)
app//org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedInputStream.java:73)
app//org.postgresql.core.PGStream.receiveChar(PGStream.java:441)
app//org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2057)
app//org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323)
app//org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:473)
app//org.postgresql.jdbc.PgStatement.execute(PgStatement.java:393)
app//org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:164)
app//org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:114)
app//com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
app//com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
jdk.internal.reflect.GeneratedMethodAccessor47.invoke(Unknown Source)
java.base@11.0.23/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.base@11.0.23/java.lang.reflect.Method.invoke(Unknown Source)
app//net.bull.javamelody.JdbcWrapper.doExecute(JdbcWrapper.java:422)
app//net.bull.javamelody.JdbcWrapper$StatementInvocationHandler.invoke(JdbcWrapper.java:142)
app//net.bull.javamelody.JdbcWrapper$DelegatingInvocationHandler.invoke(JdbcWrapper.java:300)
app//com.sun.proxy.$Proxy131.executeQuery(Unknown Source)
app//org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57)
app//org.hibernate.loader.Loader.getResultSet(Loader.java:2304)
app//org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2057)
app//org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2019)
app//org.hibernate.loader.Loader.doQuery(Loader.java:948)
app//org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:349)
app//org.hibernate.loader.Loader.doList(Loader.java:2850)
app//org.hibernate.loader.Loader.doList(Loader.java:2832)
app//org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2664)
app//org.hibernate.loader.Loader.list(Loader.java:2659)
app//org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:338)
app//org.hibernate.internal.SessionImpl.listCustomQuery(SessionImpl.java:2141)
app//org.hibernate.internal.AbstractSharedSessionContract.list(AbstractSharedSessionContract.java:1163)
app//org.hibernate.query.internal.NativeQueryImpl.doList(NativeQueryImpl.java:173)
app//org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1533)
app//org.hibernate.query.Query.getResultList(Query.java:165)
app//org.springframework.data.jpa.repository.query.JpaQueryExecution$SlicedExecution.doExecute(JpaQueryExecution.java:156)
app//org.springframework.data.jpa.repository.query.JpaQueryExecution.execute(JpaQueryExecution.java:88)
app//org.springframework.data.jpa.repository.query.AbstractJpaQuery.doExecute(AbstractJpaQuery.java:154)
app//org.springframework.data.jpa.repository.query.AbstractJpaQuery.execute(AbstractJpaQuery.java:142)
app//org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor$QueryMethodInvoker.invoke(QueryExecutorMethodInterceptor.java:195)
app//org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.doInvoke(QueryExecutorMethodInterceptor.java:152)
app//org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.invoke(QueryExecutorMethodInterceptor.java:130)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:80)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.transaction.interceptor.TransactionInterceptor$$Lambda$1687/0x0000000840f68040.proceedWithInvocation(Unknown Source)
app//org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367)
app//org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:149)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
com.sun.proxy.$Proxy408.findAllCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(Unknown Source)
java.base@11.0.23/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
java.base@11.0.23/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
java.base@11.0.23/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.base@11.0.23/java.lang.reflect.Method.invoke(Unknown Source)
app//org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
app//org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:205)
com.sun.proxy.$Proxy208.findAllCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(Unknown Source)
br.com.revizia.documentapi.v2.creditoteseartigo426a.service.impl.CreditoTeseArtigo426AServiceImpl.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(CreditoTeseArtigo426AServiceImpl.java:28)
br.com.revizia.documentapi.v2.creditoteseartigo426a.service.impl.CreditoTeseArtigo426AServiceImpl$$FastClassBySpringCGLIB$$91ed21a6.invoke(<generated>)
app//org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
app//org.springframework.transaction.interceptor.TransactionInterceptor$$Lambda$1687/0x0000000840f68040.proceedWithInvocation(Unknown Source)
app//org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367)
app//org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
app//net.bull.javamelody.MonitoringSpringInterceptor.invoke(MonitoringSpringInterceptor.java:76)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
app//org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691)
br.com.revizia.documentapi.v2.creditoteseartigo426a.service.impl.CreditoTeseArtigo426AServiceImpl$$EnhancerBySpringCGLIB$$5861cb4e.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(<generated>)
br.com.revizia.documentapi.v2.creditoteseartigo426a.controller.CreditoTeseArtigo426AController.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(CreditoTeseArtigo426AController.java:37)
br.com.revizia.documentapi.v2.creditoteseartigo426a.controller.CreditoTeseArtigo426AController$$FastClassBySpringCGLIB$$3455e92e.invoke(<generated>)
app//org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
app//net.bull.javamelody.MonitoringSpringInterceptor.invoke(MonitoringSpringInterceptor.java:76)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
app//org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691)
br.com.revizia.documentapi.v2.creditoteseartigo426a.controller.CreditoTeseArtigo426AController$$EnhancerBySpringCGLIB$$204b93d5.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(<generated>)
java.base@11.0.23/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
java.base@11.0.23/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
java.base@11.0.23/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.base@11.0.23/java.lang.reflect.Method.invoke(Unknown Source)
app//org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
app//org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
app//org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105)
app//org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:878)
app//org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:792)
app//org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
app//org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)
app//org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)
app//org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
app//org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
app//javax.servlet.http.HttpServlet.service(HttpServlet.java:517)
app//org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
app//javax.servlet.http.HttpServlet.service(HttpServlet.java:584)
app//io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:113)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:113)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:239)
app//net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:215)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320)
app//org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126)
app//org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:118)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:158)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
br.com.revizia.documentapi.config.security.jwt.JwtTokenFilter.doFilterInternal(JwtTokenFilter.java:86)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:92)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.header.HeaderWriterFilter.doHeadersAfter(HeaderWriterFilter.java:92)
app//org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:77)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215)
app//org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178)
app//org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:358)
app//org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:271)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:93)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
app//io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
app//io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
app//io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
app//io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
app//io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:132)
app//io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
app//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
app//io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
app//io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
app//io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
app//io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
app//io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
app//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
app//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
app//io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
app//io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:269)
app//io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:78)
app//io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:133)
app//io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:130)
app//io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
app//io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
app//io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:249)
app//io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:78)
app//io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:99)
app//io.undertow.server.Connectors.executeRootHandler(Connectors.java:370)
app//io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:836)
app//org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
app//org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:2019)
app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1558)
app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1449)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 XNIO-1 task-1
 UsuarioAutenticadoParaServicos{id=3, email='revizia-cron-job@revizia.com.br'}
http graph/api/nfe/credito-tese-artigo-426a/71605265010205/period?dataInicio=2022-09-01T00:00&dataFim=2022-09-30T23:59:59.999999999&page=31&size=1000 POST
spring graphCreditoTeseArtigo426AController.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm
spring graphCreditoTeseArtigo426AServiceImpl.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm
sql graphSELECT d.cnpj_issuer as cnpj, to_date(to_char(d.data_emissao, 'yyyy-MM-dd'), 'yyyy-MM-dd') as dataEmissao, d.key AS chaveNfe, d.data -> 'nfe' -> 'infNFe' -> 'ide' ->> 'nnf' AS numeroNfe, item.produto -> 'prod' ->> 'cprod' as codigoProduto, item.produto -> 'prod' ->> 'xprod' AS descricaoProduto, item.produto -> 'prod' ->> 'ncm' as codigoNcm, item.produto -> 'prod' ->> 'cfop' as cfop, CAST(item.produto -> 'prod' ->> 'vprod' AS NUMERIC) as valorProduto FROM document d , jsonb_array_elements(d.data -> 'nfe' -> 'infNFe' -> 'det') WITH ORDINALITY item(produto) WHERE d.cnpj_issuer IN (?) AND d.type IN ('NFE_2_0','NFE_3_1','NFE_4_0') AND data_emissao BETWEEN ? and ? AND item.produto -> 'prod' ->> 'cfop' IN ('5405', '5409') AND item.produto -> 'prod' ->> 'ncm' IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)ORDER BY d.key limit ? offset ?
 http 1,257
spring 1,253
spring 1,253
sql 1,250		 9,147
9,055
9,051
8,930		 7
2
2
 		 206
115
111
 		 0
0
0
 		 1
1
1
 		 0
0
0
 		 8,930
8,930
8,930
 		 java.base@11.0.23/java.net.SocketInputStream.socketRead0(Native Method) Kill the thread XNIO-1 task-1

System information System information

Execute the garbage collector Execute the garbage collector     Generate a heap dump Generate a heap dump     View memory histogram View memory histogram     Invalidate http sessions Invalidate http sessions     View http sessions View http sessions
     MBeans MBeans     View OS processes View OS processes     JNDI tree JNDI tree     Spring beans Spring beans     Opened jdbc connections Opened jdbc connections     Database Database
Host: ip-10-0-6-204.ec2.internal@10.0.6.204
Java memory used: graph600 Mb / 25,600 Mb    ++++++++++++
Nb of http sessions: graph0
Nb of active threads
(current http requests): 		graph2
Nb of active jdbc connections: graph2
Nb of used jdbc connections
(opened if no datasource): 		graph2
System loadgraph0.95
% System CPUgraph0.59    ++++++++++++








      Details


OS: OS Linux, 5.10.240-238.966.amzn2.x86_64 , amd64/64 (16 cores)
Java: OpenJDK Runtime Environment, 11.0.23+9
JVM: OpenJDK 64-Bit Server VM, 11.0.23+9, mixed mode, sharing
PID of process: 7
Nb of opened filesgraph423 / 65,535    ++++++++++++
Server: Undertow - 2.1.4.Final
Webapp context:
Start: 9/29/25, 6:08 PM
JVM arguments: -Xms1024m
-Xmx25600m
-XX:+HeapDumpOnOutOfMemoryError
-Xverify:none
-XX:+AlwaysPreTouch
-Djava.security.egd=file:/dev/./urandom
Mean age of http sessions (min): graph-1
Memory: Non heap memory = 192 Mb (Perm Gen, Code Cache),
Buffered memory = 17 Mb,
Loaded classes = 22,569,
Garbage collection time = 989 ms,
Process cpu time = 98,170 ms,
Committed virtual memory = 33,627 Mb,
Free physical memory = 29,580 Mb,
Total physical memory = 32,768 Mb
Free disk space: 19,830 Mb
Usable disk space: 18,278 Mb
DataBase: dataSource:
jdbc:postgresql://bd-rvz-prod-proxy.proxy-cjipvy4ifgsj.us-east-1.rds.amazonaws.com/documents?ApplicationName=document-api&reWriteBatchedInserts=true&rewriteBatchedStatements=true&assumeMinServerVersion=9.0
PostgreSQL, 15.13
Driver JDBC:
PostgreSQL JDBC Driver, 42.2.18
Dependencies:
Dependencies Dependencies

Threads Threads

Threads on ip-10-0-6-204.ec2.internal@10.0.6.204: Number = 47, Maximum = 47, Total started = 54       Details

ThreadDaemon ?PriorityStateExecuted methodCpu time (ms)User time (ms)Interrupt Kill
Common-Cleaner
java.base@11.0.23/java.lang.Object.wait(Native Method)
java.base@11.0.23/java.lang.ref.ReferenceQueue.remove(Unknown Source)
java.base@11.0.23/jdk.internal.ref.CleanerImpl.run(Unknown Source)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
java.base@11.0.23/jdk.internal.misc.InnocuousThread.run(Unknown Source)
 Common-Cleaner
 yes 8 TIMED_WAITINGTIMED_WAITING java.base@11.0.23/java.lang.Object.wait(Native Method) 3 0 Send a thread interrupt signal to Common-Cleaner. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread Common-Cleaner
DestroyJavaVM no 5 RUNNABLERUNNABLE   414 380 Send a thread interrupt signal to DestroyJavaVM. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread DestroyJavaVM
Finalizer
java.base@11.0.23/java.lang.Object.wait(Native Method)
java.base@11.0.23/java.lang.ref.ReferenceQueue.remove(Unknown Source)
java.base@11.0.23/java.lang.ref.ReferenceQueue.remove(Unknown Source)
java.base@11.0.23/java.lang.ref.Finalizer$FinalizerThread.run(Unknown Source)
 Finalizer
 yes 8 WAITINGWAITING java.base@11.0.23/java.lang.Object.wait(Native Method) 1 0 Send a thread interrupt signal to Finalizer. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread Finalizer
Hikari housekeeper
java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method)
java.base@11.0.23/java.util.concurrent.locks.LockSupport.parkNanos(Unknown Source)
java.base@11.0.23/java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(Unknown Source)
java.base@11.0.23/java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(Unknown Source)
java.base@11.0.23/java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(Unknown Source)
java.base@11.0.23/java.util.concurrent.ThreadPoolExecutor.getTask(Unknown Source)
java.base@11.0.23/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
java.base@11.0.23/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 Hikari housekeeper
 yes 5 TIMED_WAITINGTIMED_WAITING java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method) 2 0 Send a thread interrupt signal to Hikari housekeeper. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread Hikari housekeeper
HttpClient-1-SelectorManager
java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method)
java.base@11.0.23/sun.nio.ch.EPollSelectorImpl.doSelect(Unknown Source)
java.base@11.0.23/sun.nio.ch.SelectorImpl.lockAndDoSelect(Unknown Source)
java.base@11.0.23/sun.nio.ch.SelectorImpl.select(Unknown Source)
platform/java.net.http@11.0.23/jdk.internal.net.http.HttpClientImpl$SelectorManager.run(Unknown Source)
 HttpClient-1-SelectorManager
 yes 5 RUNNABLERUNNABLE java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) 1 0 Send a thread interrupt signal to HttpClient-1-SelectorManager. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread HttpClient-1-SelectorManager
idle-connection-reaper
java.base@11.0.23/java.lang.Thread.sleep(Native Method)
app//software.amazon.awssdk.http.apache.internal.conn.IdleConnectionReaper$ReaperTask.run(IdleConnectionReaper.java:150)
java.base@11.0.23/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
java.base@11.0.23/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 idle-connection-reaper
 yes 5 TIMED_WAITINGTIMED_WAITING java.base@11.0.23/java.lang.Thread.sleep(Native Method) 0 0 Send a thread interrupt signal to idle-connection-reaper. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread idle-connection-reaper
java-sdk-http-connection-reaper
java.base@11.0.23/java.lang.Thread.sleep(Native Method)
app//com.amazonaws.http.IdleConnectionReaper.run(IdleConnectionReaper.java:188)
 java-sdk-http-connection-reaper
 yes 5 TIMED_WAITINGTIMED_WAITING java.base@11.0.23/java.lang.Thread.sleep(Native Method) 0 0 Send a thread interrupt signal to java-sdk-http-connection-reaper. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread java-sdk-http-connection-reaper
javamelody
java.base@11.0.23/java.lang.Object.wait(Native Method)
java.base@11.0.23/java.util.TimerThread.mainLoop(Unknown Source)
java.base@11.0.23/java.util.TimerThread.run(Unknown Source)
 javamelody
 yes 5 TIMED_WAITINGTIMED_WAITING java.base@11.0.23/java.lang.Object.wait(Native Method) 0 0 Send a thread interrupt signal to javamelody. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread javamelody
PostgreSQL-JDBC-SharedTimer-1
java.base@11.0.23/java.lang.Object.wait(Native Method)
java.base@11.0.23/java.util.TimerThread.mainLoop(Unknown Source)
java.base@11.0.23/java.util.TimerThread.run(Unknown Source)
 PostgreSQL-JDBC-SharedTimer-1
 yes 5 TIMED_WAITINGTIMED_WAITING java.base@11.0.23/java.lang.Object.wait(Native Method) 0 0 Send a thread interrupt signal to PostgreSQL-JDBC-SharedTimer-1. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread PostgreSQL-JDBC-SharedTimer-1
reactor-http-epoll-1
app//io.netty.channel.epoll.Native.epollWait(Native Method)
app//io.netty.channel.epoll.Native.epollWait(Native.java:148)
app//io.netty.channel.epoll.Native.epollWait(Native.java:141)
app//io.netty.channel.epoll.EpollEventLoop.epollWaitNoTimerChange(EpollEventLoop.java:290)
app//io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:347)
app//io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989)
app//io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74)
app//io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 reactor-http-epoll-1
 yes 5 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 159 130 Send a thread interrupt signal to reactor-http-epoll-1. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-1
reactor-http-epoll-10
app//io.netty.channel.epoll.Native.epollWait(Native Method)
app//io.netty.channel.epoll.Native.epollWait(Native.java:148)
app//io.netty.channel.epoll.Native.epollWait(Native.java:141)
app//io.netty.channel.epoll.EpollEventLoop.epollWaitNoTimerChange(EpollEventLoop.java:290)
app//io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:347)
app//io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989)
app//io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74)
app//io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 reactor-http-epoll-10
 yes 5 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 0 0 Send a thread interrupt signal to reactor-http-epoll-10. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-10
reactor-http-epoll-11
app//io.netty.channel.epoll.Native.epollWait(Native Method)
app//io.netty.channel.epoll.Native.epollWait(Native.java:148)
app//io.netty.channel.epoll.Native.epollWait(Native.java:141)
app//io.netty.channel.epoll.EpollEventLoop.epollWaitNoTimerChange(EpollEventLoop.java:290)
app//io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:347)
app//io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989)
app//io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74)
app//io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 reactor-http-epoll-11
 yes 5 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 0 0 Send a thread interrupt signal to reactor-http-epoll-11. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-11
reactor-http-epoll-12
app//io.netty.channel.epoll.Native.epollWait(Native Method)
app//io.netty.channel.epoll.Native.epollWait(Native.java:148)
app//io.netty.channel.epoll.Native.epollWait(Native.java:141)
app//io.netty.channel.epoll.EpollEventLoop.epollWaitNoTimerChange(EpollEventLoop.java:290)
app//io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:347)
app//io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989)
app//io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74)
app//io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 reactor-http-epoll-12
 yes 5 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 0 0 Send a thread interrupt signal to reactor-http-epoll-12. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-12
reactor-http-epoll-13
app//io.netty.channel.epoll.Native.epollWait(Native Method)
app//io.netty.channel.epoll.Native.epollWait(Native.java:148)
app//io.netty.channel.epoll.Native.epollWait(Native.java:141)
app//io.netty.channel.epoll.EpollEventLoop.epollWaitNoTimerChange(EpollEventLoop.java:290)
app//io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:347)
app//io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989)
app//io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74)
app//io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 reactor-http-epoll-13
 yes 5 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 0 0 Send a thread interrupt signal to reactor-http-epoll-13. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-13
reactor-http-epoll-14
app//io.netty.channel.epoll.Native.epollWait(Native Method)
app//io.netty.channel.epoll.Native.epollWait(Native.java:148)
app//io.netty.channel.epoll.Native.epollWait(Native.java:141)
app//io.netty.channel.epoll.EpollEventLoop.epollWaitNoTimerChange(EpollEventLoop.java:290)
app//io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:347)
app//io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989)
app//io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74)
app//io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 reactor-http-epoll-14
 yes 5 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 0 0 Send a thread interrupt signal to reactor-http-epoll-14. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-14
reactor-http-epoll-15
app//io.netty.channel.epoll.Native.epollWait(Native Method)
app//io.netty.channel.epoll.Native.epollWait(Native.java:148)
app//io.netty.channel.epoll.Native.epollWait(Native.java:141)
app//io.netty.channel.epoll.EpollEventLoop.epollWaitNoTimerChange(EpollEventLoop.java:290)
app//io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:347)
app//io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989)
app//io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74)
app//io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 reactor-http-epoll-15
 yes 5 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 0 0 Send a thread interrupt signal to reactor-http-epoll-15. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-15
reactor-http-epoll-16
app//io.netty.channel.epoll.Native.epollWait(Native Method)
app//io.netty.channel.epoll.Native.epollWait(Native.java:148)
app//io.netty.channel.epoll.Native.epollWait(Native.java:141)
app//io.netty.channel.epoll.EpollEventLoop.epollWaitNoTimerChange(EpollEventLoop.java:290)
app//io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:347)
app//io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989)
app//io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74)
app//io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 reactor-http-epoll-16
 yes 5 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 0 0 Send a thread interrupt signal to reactor-http-epoll-16. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-16
reactor-http-epoll-2
app//io.netty.channel.epoll.Native.epollWait(Native Method)
app//io.netty.channel.epoll.Native.epollWait(Native.java:148)
app//io.netty.channel.epoll.Native.epollWait(Native.java:141)
app//io.netty.channel.epoll.EpollEventLoop.epollWaitNoTimerChange(EpollEventLoop.java:290)
app//io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:347)
app//io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989)
app//io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74)
app//io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 reactor-http-epoll-2
 yes 5 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 0 0 Send a thread interrupt signal to reactor-http-epoll-2. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-2
reactor-http-epoll-3
app//io.netty.channel.epoll.Native.epollWait(Native Method)
app//io.netty.channel.epoll.Native.epollWait(Native.java:148)
app//io.netty.channel.epoll.Native.epollWait(Native.java:141)
app//io.netty.channel.epoll.EpollEventLoop.epollWaitNoTimerChange(EpollEventLoop.java:290)
app//io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:347)
app//io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989)
app//io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74)
app//io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 reactor-http-epoll-3
 yes 5 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 0 0 Send a thread interrupt signal to reactor-http-epoll-3. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-3
reactor-http-epoll-4
app//io.netty.channel.epoll.Native.epollWait(Native Method)
app//io.netty.channel.epoll.Native.epollWait(Native.java:148)
app//io.netty.channel.epoll.Native.epollWait(Native.java:141)
app//io.netty.channel.epoll.EpollEventLoop.epollWaitNoTimerChange(EpollEventLoop.java:290)
app//io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:347)
app//io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989)
app//io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74)
app//io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 reactor-http-epoll-4
 yes 5 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 0 0 Send a thread interrupt signal to reactor-http-epoll-4. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-4
reactor-http-epoll-5
app//io.netty.channel.epoll.Native.epollWait(Native Method)
app//io.netty.channel.epoll.Native.epollWait(Native.java:148)
app//io.netty.channel.epoll.Native.epollWait(Native.java:141)
app//io.netty.channel.epoll.EpollEventLoop.epollWaitNoTimerChange(EpollEventLoop.java:290)
app//io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:347)
app//io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989)
app//io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74)
app//io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 reactor-http-epoll-5
 yes 5 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 0 0 Send a thread interrupt signal to reactor-http-epoll-5. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-5
reactor-http-epoll-6
app//io.netty.channel.epoll.Native.epollWait(Native Method)
app//io.netty.channel.epoll.Native.epollWait(Native.java:148)
app//io.netty.channel.epoll.Native.epollWait(Native.java:141)
app//io.netty.channel.epoll.EpollEventLoop.epollWaitNoTimerChange(EpollEventLoop.java:290)
app//io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:347)
app//io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989)
app//io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74)
app//io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 reactor-http-epoll-6
 yes 5 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 0 0 Send a thread interrupt signal to reactor-http-epoll-6. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-6
reactor-http-epoll-7
app//io.netty.channel.epoll.Native.epollWait(Native Method)
app//io.netty.channel.epoll.Native.epollWait(Native.java:148)
app//io.netty.channel.epoll.Native.epollWait(Native.java:141)
app//io.netty.channel.epoll.EpollEventLoop.epollWaitNoTimerChange(EpollEventLoop.java:290)
app//io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:347)
app//io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989)
app//io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74)
app//io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 reactor-http-epoll-7
 yes 5 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 0 0 Send a thread interrupt signal to reactor-http-epoll-7. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-7
reactor-http-epoll-8
app//io.netty.channel.epoll.Native.epollWait(Native Method)
app//io.netty.channel.epoll.Native.epollWait(Native.java:148)
app//io.netty.channel.epoll.Native.epollWait(Native.java:141)
app//io.netty.channel.epoll.EpollEventLoop.epollWaitNoTimerChange(EpollEventLoop.java:290)
app//io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:347)
app//io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989)
app//io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74)
app//io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 reactor-http-epoll-8
 yes 5 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 0 0 Send a thread interrupt signal to reactor-http-epoll-8. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-8
reactor-http-epoll-9
app//io.netty.channel.epoll.Native.epollWait(Native Method)
app//io.netty.channel.epoll.Native.epollWait(Native.java:148)
app//io.netty.channel.epoll.Native.epollWait(Native.java:141)
app//io.netty.channel.epoll.EpollEventLoop.epollWaitNoTimerChange(EpollEventLoop.java:290)
app//io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:347)
app//io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989)
app//io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74)
app//io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 reactor-http-epoll-9
 yes 5 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 0 0 Send a thread interrupt signal to reactor-http-epoll-9. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-9
Reference Handler
java.base@11.0.23/java.lang.ref.Reference.waitForReferencePendingList(Native Method)
java.base@11.0.23/java.lang.ref.Reference.processPendingReferences(Unknown Source)
java.base@11.0.23/java.lang.ref.Reference$ReferenceHandler.run(Unknown Source)
 Reference Handler
 yes 10 RUNNABLERUNNABLE java.base@11.0.23/java.lang.ref.Reference.waitForReferencePendingList(Native Method) 3 0 Send a thread interrupt signal to Reference Handler. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread Reference Handler
Signal Dispatcher yes 9 RUNNABLERUNNABLE   0 0 Send a thread interrupt signal to Signal Dispatcher. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread Signal Dispatcher
XNIO-1 Accept
java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method)
java.base@11.0.23/sun.nio.ch.EPollSelectorImpl.doSelect(Unknown Source)
java.base@11.0.23/sun.nio.ch.SelectorImpl.lockAndDoSelect(Unknown Source)
java.base@11.0.23/sun.nio.ch.SelectorImpl.select(Unknown Source)
app//org.xnio.nio.WorkerThread.run(WorkerThread.java:532)
 XNIO-1 Accept
 no 5 RUNNABLERUNNABLE java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) 9 0 Send a thread interrupt signal to XNIO-1 Accept. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 Accept
XNIO-1 I/O-1
java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method)
java.base@11.0.23/sun.nio.ch.EPollSelectorImpl.doSelect(Unknown Source)
java.base@11.0.23/sun.nio.ch.SelectorImpl.lockAndDoSelect(Unknown Source)
java.base@11.0.23/sun.nio.ch.SelectorImpl.select(Unknown Source)
app//org.xnio.nio.WorkerThread.run(WorkerThread.java:551)
 XNIO-1 I/O-1
 no 5 RUNNABLERUNNABLE java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) 6 0 Send a thread interrupt signal to XNIO-1 I/O-1. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 I/O-1
XNIO-1 I/O-10
java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method)
java.base@11.0.23/sun.nio.ch.EPollSelectorImpl.doSelect(Unknown Source)
java.base@11.0.23/sun.nio.ch.SelectorImpl.lockAndDoSelect(Unknown Source)
java.base@11.0.23/sun.nio.ch.SelectorImpl.select(Unknown Source)
app//org.xnio.nio.WorkerThread.run(WorkerThread.java:532)
 XNIO-1 I/O-10
 no 5 RUNNABLERUNNABLE java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) 0 0 Send a thread interrupt signal to XNIO-1 I/O-10. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 I/O-10
XNIO-1 I/O-11
java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method)
java.base@11.0.23/sun.nio.ch.EPollSelectorImpl.doSelect(Unknown Source)
java.base@11.0.23/sun.nio.ch.SelectorImpl.lockAndDoSelect(Unknown Source)
java.base@11.0.23/sun.nio.ch.SelectorImpl.select(Unknown Source)
app//org.xnio.nio.WorkerThread.run(WorkerThread.java:551)
 XNIO-1 I/O-11
 no 5 RUNNABLERUNNABLE java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) 0 0 Send a thread interrupt signal to XNIO-1 I/O-11. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 I/O-11
XNIO-1 I/O-12
java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method)
java.base@11.0.23/sun.nio.ch.EPollSelectorImpl.doSelect(Unknown Source)
java.base@11.0.23/sun.nio.ch.SelectorImpl.lockAndDoSelect(Unknown Source)
java.base@11.0.23/sun.nio.ch.SelectorImpl.select(Unknown Source)
app//org.xnio.nio.WorkerThread.run(WorkerThread.java:532)
 XNIO-1 I/O-12
 no 5 RUNNABLERUNNABLE java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) 0 0 Send a thread interrupt signal to XNIO-1 I/O-12. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 I/O-12
XNIO-1 I/O-13
java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method)
java.base@11.0.23/sun.nio.ch.EPollSelectorImpl.doSelect(Unknown Source)
java.base@11.0.23/sun.nio.ch.SelectorImpl.lockAndDoSelect(Unknown Source)
java.base@11.0.23/sun.nio.ch.SelectorImpl.select(Unknown Source)
app//org.xnio.nio.WorkerThread.run(WorkerThread.java:532)
 XNIO-1 I/O-13
 no 5 RUNNABLERUNNABLE java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) 0 0 Send a thread interrupt signal to XNIO-1 I/O-13. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 I/O-13
XNIO-1 I/O-14
java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method)
java.base@11.0.23/sun.nio.ch.EPollSelectorImpl.doSelect(Unknown Source)
java.base@11.0.23/sun.nio.ch.SelectorImpl.lockAndDoSelect(Unknown Source)
java.base@11.0.23/sun.nio.ch.SelectorImpl.select(Unknown Source)
app//org.xnio.nio.WorkerThread.run(WorkerThread.java:532)
 XNIO-1 I/O-14
 no 5 RUNNABLERUNNABLE java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) 0 0 Send a thread interrupt signal to XNIO-1 I/O-14. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 I/O-14
XNIO-1 I/O-15
java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method)
java.base@11.0.23/sun.nio.ch.EPollSelectorImpl.doSelect(Unknown Source)
java.base@11.0.23/sun.nio.ch.SelectorImpl.lockAndDoSelect(Unknown Source)
java.base@11.0.23/sun.nio.ch.SelectorImpl.select(Unknown Source)
app//org.xnio.nio.WorkerThread.run(WorkerThread.java:532)
 XNIO-1 I/O-15
 no 5 RUNNABLERUNNABLE java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) 0 0 Send a thread interrupt signal to XNIO-1 I/O-15. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 I/O-15
XNIO-1 I/O-16
java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method)
java.base@11.0.23/sun.nio.ch.EPollSelectorImpl.doSelect(Unknown Source)
java.base@11.0.23/sun.nio.ch.SelectorImpl.lockAndDoSelect(Unknown Source)
java.base@11.0.23/sun.nio.ch.SelectorImpl.select(Unknown Source)
app//org.xnio.nio.WorkerThread.run(WorkerThread.java:532)
 XNIO-1 I/O-16
 no 5 RUNNABLERUNNABLE java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) 0 0 Send a thread interrupt signal to XNIO-1 I/O-16. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 I/O-16
XNIO-1 I/O-2
java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method)
java.base@11.0.23/sun.nio.ch.EPollSelectorImpl.doSelect(Unknown Source)
java.base@11.0.23/sun.nio.ch.SelectorImpl.lockAndDoSelect(Unknown Source)
java.base@11.0.23/sun.nio.ch.SelectorImpl.select(Unknown Source)
app//org.xnio.nio.WorkerThread.run(WorkerThread.java:551)
 XNIO-1 I/O-2
 no 5 RUNNABLERUNNABLE java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) 0 0 Send a thread interrupt signal to XNIO-1 I/O-2. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 I/O-2
XNIO-1 I/O-3
java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method)
java.base@11.0.23/sun.nio.ch.EPollSelectorImpl.doSelect(Unknown Source)
java.base@11.0.23/sun.nio.ch.SelectorImpl.lockAndDoSelect(Unknown Source)
java.base@11.0.23/sun.nio.ch.SelectorImpl.select(Unknown Source)
app//org.xnio.nio.WorkerThread.run(WorkerThread.java:532)
 XNIO-1 I/O-3
 no 5 RUNNABLERUNNABLE java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) 0 0 Send a thread interrupt signal to XNIO-1 I/O-3. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 I/O-3
XNIO-1 I/O-4
java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method)
java.base@11.0.23/sun.nio.ch.EPollSelectorImpl.doSelect(Unknown Source)
java.base@11.0.23/sun.nio.ch.SelectorImpl.lockAndDoSelect(Unknown Source)
java.base@11.0.23/sun.nio.ch.SelectorImpl.select(Unknown Source)
app//org.xnio.nio.WorkerThread.run(WorkerThread.java:532)
 XNIO-1 I/O-4
 no 5 RUNNABLERUNNABLE java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) 17 10 Send a thread interrupt signal to XNIO-1 I/O-4. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 I/O-4
XNIO-1 I/O-5
java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method)
java.base@11.0.23/sun.nio.ch.EPollSelectorImpl.doSelect(Unknown Source)
java.base@11.0.23/sun.nio.ch.SelectorImpl.lockAndDoSelect(Unknown Source)
java.base@11.0.23/sun.nio.ch.SelectorImpl.select(Unknown Source)
app//org.xnio.nio.WorkerThread.run(WorkerThread.java:551)
 XNIO-1 I/O-5
 no 5 RUNNABLERUNNABLE java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) 0 0 Send a thread interrupt signal to XNIO-1 I/O-5. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 I/O-5
XNIO-1 I/O-6
java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method)
java.base@11.0.23/sun.nio.ch.EPollSelectorImpl.doSelect(Unknown Source)
java.base@11.0.23/sun.nio.ch.SelectorImpl.lockAndDoSelect(Unknown Source)
java.base@11.0.23/sun.nio.ch.SelectorImpl.select(Unknown Source)
app//org.xnio.nio.WorkerThread.run(WorkerThread.java:551)
 XNIO-1 I/O-6
 no 5 RUNNABLERUNNABLE java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) 2 0 Send a thread interrupt signal to XNIO-1 I/O-6. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 I/O-6
XNIO-1 I/O-7
java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method)
java.base@11.0.23/sun.nio.ch.EPollSelectorImpl.doSelect(Unknown Source)
java.base@11.0.23/sun.nio.ch.SelectorImpl.lockAndDoSelect(Unknown Source)
java.base@11.0.23/sun.nio.ch.SelectorImpl.select(Unknown Source)
app//org.xnio.nio.WorkerThread.run(WorkerThread.java:532)
 XNIO-1 I/O-7
 no 5 RUNNABLERUNNABLE java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) 0 0 Send a thread interrupt signal to XNIO-1 I/O-7. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 I/O-7
XNIO-1 I/O-8
java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method)
java.base@11.0.23/sun.nio.ch.EPollSelectorImpl.doSelect(Unknown Source)
java.base@11.0.23/sun.nio.ch.SelectorImpl.lockAndDoSelect(Unknown Source)
java.base@11.0.23/sun.nio.ch.SelectorImpl.select(Unknown Source)
app//org.xnio.nio.WorkerThread.run(WorkerThread.java:532)
 XNIO-1 I/O-8
 no 5 RUNNABLERUNNABLE java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) 1 0 Send a thread interrupt signal to XNIO-1 I/O-8. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 I/O-8
XNIO-1 I/O-9
java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method)
java.base@11.0.23/sun.nio.ch.EPollSelectorImpl.doSelect(Unknown Source)
java.base@11.0.23/sun.nio.ch.SelectorImpl.lockAndDoSelect(Unknown Source)
java.base@11.0.23/sun.nio.ch.SelectorImpl.select(Unknown Source)
app//org.xnio.nio.WorkerThread.run(WorkerThread.java:532)
 XNIO-1 I/O-9
 no 5 RUNNABLERUNNABLE java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) 0 0 Send a thread interrupt signal to XNIO-1 I/O-9. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 I/O-9
XNIO-1 task-1
java.base@11.0.23/java.net.SocketInputStream.socketRead0(Native Method)
java.base@11.0.23/java.net.SocketInputStream.socketRead(Unknown Source)
java.base@11.0.23/java.net.SocketInputStream.read(Unknown Source)
java.base@11.0.23/java.net.SocketInputStream.read(Unknown Source)
java.base@11.0.23/sun.security.ssl.SSLSocketInputRecord.read(Unknown Source)
java.base@11.0.23/sun.security.ssl.SSLSocketInputRecord.readHeader(Unknown Source)
java.base@11.0.23/sun.security.ssl.SSLSocketInputRecord.bytesInCompletePacket(Unknown Source)
java.base@11.0.23/sun.security.ssl.SSLSocketImpl.readApplicationRecord(Unknown Source)
java.base@11.0.23/sun.security.ssl.SSLSocketImpl$AppInputStream.read(Unknown Source)
app//org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBufferedInputStream.java:161)
app//org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:128)
app//org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:113)
app//org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedInputStream.java:73)
app//org.postgresql.core.PGStream.receiveChar(PGStream.java:441)
app//org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2057)
app//org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323)
app//org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:473)
app//org.postgresql.jdbc.PgStatement.execute(PgStatement.java:393)
app//org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:164)
app//org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:114)
app//com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
app//com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
jdk.internal.reflect.GeneratedMethodAccessor47.invoke(Unknown Source)
java.base@11.0.23/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.base@11.0.23/java.lang.reflect.Method.invoke(Unknown Source)
app//net.bull.javamelody.JdbcWrapper.doExecute(JdbcWrapper.java:422)
app//net.bull.javamelody.JdbcWrapper$StatementInvocationHandler.invoke(JdbcWrapper.java:142)
app//net.bull.javamelody.JdbcWrapper$DelegatingInvocationHandler.invoke(JdbcWrapper.java:300)
app//com.sun.proxy.$Proxy131.executeQuery(Unknown Source)
app//org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57)
app//org.hibernate.loader.Loader.getResultSet(Loader.java:2304)
app//org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2057)
app//org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2019)
app//org.hibernate.loader.Loader.doQuery(Loader.java:948)
app//org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:349)
app//org.hibernate.loader.Loader.doList(Loader.java:2850)
app//org.hibernate.loader.Loader.doList(Loader.java:2832)
app//org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2664)
app//org.hibernate.loader.Loader.list(Loader.java:2659)
app//org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:338)
app//org.hibernate.internal.SessionImpl.listCustomQuery(SessionImpl.java:2141)
app//org.hibernate.internal.AbstractSharedSessionContract.list(AbstractSharedSessionContract.java:1163)
app//org.hibernate.query.internal.NativeQueryImpl.doList(NativeQueryImpl.java:173)
app//org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1533)
app//org.hibernate.query.Query.getResultList(Query.java:165)
app//org.springframework.data.jpa.repository.query.JpaQueryExecution$SlicedExecution.doExecute(JpaQueryExecution.java:156)
app//org.springframework.data.jpa.repository.query.JpaQueryExecution.execute(JpaQueryExecution.java:88)
app//org.springframework.data.jpa.repository.query.AbstractJpaQuery.doExecute(AbstractJpaQuery.java:154)
app//org.springframework.data.jpa.repository.query.AbstractJpaQuery.execute(AbstractJpaQuery.java:142)
app//org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor$QueryMethodInvoker.invoke(QueryExecutorMethodInterceptor.java:195)
app//org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.doInvoke(QueryExecutorMethodInterceptor.java:152)
app//org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.invoke(QueryExecutorMethodInterceptor.java:130)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:80)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.transaction.interceptor.TransactionInterceptor$$Lambda$1687/0x0000000840f68040.proceedWithInvocation(Unknown Source)
app//org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367)
app//org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:149)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
com.sun.proxy.$Proxy408.findAllCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(Unknown Source)
java.base@11.0.23/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
java.base@11.0.23/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
java.base@11.0.23/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.base@11.0.23/java.lang.reflect.Method.invoke(Unknown Source)
app//org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
app//org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:205)
com.sun.proxy.$Proxy208.findAllCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(Unknown Source)
br.com.revizia.documentapi.v2.creditoteseartigo426a.service.impl.CreditoTeseArtigo426AServiceImpl.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(CreditoTeseArtigo426AServiceImpl.java:28)
br.com.revizia.documentapi.v2.creditoteseartigo426a.service.impl.CreditoTeseArtigo426AServiceImpl$$FastClassBySpringCGLIB$$91ed21a6.invoke(<generated>)
app//org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
app//org.springframework.transaction.interceptor.TransactionInterceptor$$Lambda$1687/0x0000000840f68040.proceedWithInvocation(Unknown Source)
app//org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367)
app//org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
app//net.bull.javamelody.MonitoringSpringInterceptor.invoke(MonitoringSpringInterceptor.java:76)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
app//org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691)
br.com.revizia.documentapi.v2.creditoteseartigo426a.service.impl.CreditoTeseArtigo426AServiceImpl$$EnhancerBySpringCGLIB$$5861cb4e.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(<generated>)
br.com.revizia.documentapi.v2.creditoteseartigo426a.controller.CreditoTeseArtigo426AController.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(CreditoTeseArtigo426AController.java:37)
br.com.revizia.documentapi.v2.creditoteseartigo426a.controller.CreditoTeseArtigo426AController$$FastClassBySpringCGLIB$$3455e92e.invoke(<generated>)
app//org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
app//net.bull.javamelody.MonitoringSpringInterceptor.invoke(MonitoringSpringInterceptor.java:76)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
app//org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691)
br.com.revizia.documentapi.v2.creditoteseartigo426a.controller.CreditoTeseArtigo426AController$$EnhancerBySpringCGLIB$$204b93d5.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(<generated>)
java.base@11.0.23/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
java.base@11.0.23/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
java.base@11.0.23/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.base@11.0.23/java.lang.reflect.Method.invoke(Unknown Source)
app//org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
app//org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
app//org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105)
app//org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:878)
app//org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:792)
app//org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
app//org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)
app//org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)
app//org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
app//org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
app//javax.servlet.http.HttpServlet.service(HttpServlet.java:517)
app//org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
app//javax.servlet.http.HttpServlet.service(HttpServlet.java:584)
app//io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:113)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:113)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:239)
app//net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:215)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320)
app//org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126)
app//org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:118)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:158)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
br.com.revizia.documentapi.config.security.jwt.JwtTokenFilter.doFilterInternal(JwtTokenFilter.java:86)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:92)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.header.HeaderWriterFilter.doHeadersAfter(HeaderWriterFilter.java:92)
app//org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:77)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215)
app//org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178)
app//org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:358)
app//org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:271)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:93)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
app//io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
app//io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
app//io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
app//io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
app//io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:132)
app//io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
app//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
app//io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
app//io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
app//io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
app//io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
app//io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
app//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
app//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
app//io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
app//io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:269)
app//io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:78)
app//io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:133)
app//io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:130)
app//io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
app//io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
app//io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:249)
app//io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:78)
app//io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:99)
app//io.undertow.server.Connectors.executeRootHandler(Connectors.java:370)
app//io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:836)
app//org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
app//org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:2019)
app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1558)
app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1449)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 XNIO-1 task-1
 no 5 RUNNABLERUNNABLE java.base@11.0.23/java.net.SocketInputStream.socketRead0(Native Method) 539 520 Send a thread interrupt signal to XNIO-1 task-1. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 task-1
XNIO-1 task-2
java.base@11.0.23/java.lang.Thread.dumpThreads(Native Method)
java.base@11.0.23/java.lang.Thread.getAllStackTraces(Unknown Source)
app//net.bull.javamelody.internal.model.JavaInformations.buildThreadInformationsList(JavaInformations.java:327)
app//net.bull.javamelody.internal.model.JavaInformations.<init>(JavaInformations.java:202)
app//net.bull.javamelody.internal.web.MonitoringController.doActionIfNeededAndReport(MonitoringController.java:158)
app//net.bull.javamelody.MonitoringFilter.doMonitoring(MonitoringFilter.java:408)
app//net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:206)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320)
app//org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126)
app//org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:118)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:158)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
br.com.revizia.documentapi.config.security.jwt.JwtTokenFilter.doFilterInternal(JwtTokenFilter.java:86)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:92)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.header.HeaderWriterFilter.doHeadersAfter(HeaderWriterFilter.java:92)
app//org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:77)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215)
app//org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178)
app//org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:358)
app//org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:271)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:93)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
app//io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
app//io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
app//io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
app//io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
app//io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:132)
app//io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
app//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
app//io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
app//io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
app//io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
app//io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
app//io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
app//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
app//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
app//io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
app//io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:269)
app//io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:78)
app//io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:133)
app//io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:130)
app//io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
app//io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
app//io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:249)
app//io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:78)
app//io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:99)
app//io.undertow.server.Connectors.executeRootHandler(Connectors.java:370)
app//io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:836)
app//org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
app//org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:2019)
app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1558)
app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1449)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 XNIO-1 task-2
 no 5 RUNNABLERUNNABLE java.base@11.0.23/java.lang.Thread.dumpThreads(Native Method) 264 250 Send a thread interrupt signal to XNIO-1 task-2. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 task-2
XNIO-1 task-3
java.base@11.0.23/java.net.SocketInputStream.socketRead0(Native Method)
java.base@11.0.23/java.net.SocketInputStream.socketRead(Unknown Source)
java.base@11.0.23/java.net.SocketInputStream.read(Unknown Source)
java.base@11.0.23/java.net.SocketInputStream.read(Unknown Source)
java.base@11.0.23/sun.security.ssl.SSLSocketInputRecord.read(Unknown Source)
java.base@11.0.23/sun.security.ssl.SSLSocketInputRecord.readHeader(Unknown Source)
java.base@11.0.23/sun.security.ssl.SSLSocketInputRecord.bytesInCompletePacket(Unknown Source)
java.base@11.0.23/sun.security.ssl.SSLSocketImpl.readApplicationRecord(Unknown Source)
java.base@11.0.23/sun.security.ssl.SSLSocketImpl$AppInputStream.read(Unknown Source)
app//org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBufferedInputStream.java:161)
app//org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:128)
app//org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:113)
app//org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedInputStream.java:73)
app//org.postgresql.core.PGStream.receiveChar(PGStream.java:441)
app//org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2057)
app//org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323)
app//org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:473)
app//org.postgresql.jdbc.PgStatement.execute(PgStatement.java:393)
app//org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:164)
app//org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:114)
app//com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
app//com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
jdk.internal.reflect.GeneratedMethodAccessor47.invoke(Unknown Source)
java.base@11.0.23/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.base@11.0.23/java.lang.reflect.Method.invoke(Unknown Source)
app//net.bull.javamelody.JdbcWrapper.doExecute(JdbcWrapper.java:422)
app//net.bull.javamelody.JdbcWrapper$StatementInvocationHandler.invoke(JdbcWrapper.java:142)
app//net.bull.javamelody.JdbcWrapper$DelegatingInvocationHandler.invoke(JdbcWrapper.java:300)
app//com.sun.proxy.$Proxy131.executeQuery(Unknown Source)
app//org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57)
app//org.hibernate.loader.Loader.getResultSet(Loader.java:2304)
app//org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2057)
app//org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2019)
app//org.hibernate.loader.Loader.doQuery(Loader.java:948)
app//org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:349)
app//org.hibernate.loader.Loader.doList(Loader.java:2850)
app//org.hibernate.loader.Loader.doList(Loader.java:2832)
app//org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2664)
app//org.hibernate.loader.Loader.list(Loader.java:2659)
app//org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:338)
app//org.hibernate.internal.SessionImpl.listCustomQuery(SessionImpl.java:2141)
app//org.hibernate.internal.AbstractSharedSessionContract.list(AbstractSharedSessionContract.java:1163)
app//org.hibernate.query.internal.NativeQueryImpl.doList(NativeQueryImpl.java:173)
app//org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1533)
app//org.hibernate.query.Query.getResultList(Query.java:165)
app//org.springframework.data.jpa.repository.query.JpaQueryExecution$SlicedExecution.doExecute(JpaQueryExecution.java:156)
app//org.springframework.data.jpa.repository.query.JpaQueryExecution.execute(JpaQueryExecution.java:88)
app//org.springframework.data.jpa.repository.query.AbstractJpaQuery.doExecute(AbstractJpaQuery.java:154)
app//org.springframework.data.jpa.repository.query.AbstractJpaQuery.execute(AbstractJpaQuery.java:142)
app//org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor$QueryMethodInvoker.invoke(QueryExecutorMethodInterceptor.java:195)
app//org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.doInvoke(QueryExecutorMethodInterceptor.java:152)
app//org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.invoke(QueryExecutorMethodInterceptor.java:130)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:80)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.transaction.interceptor.TransactionInterceptor$$Lambda$1687/0x0000000840f68040.proceedWithInvocation(Unknown Source)
app//org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367)
app//org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:149)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
com.sun.proxy.$Proxy408.findAllCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(Unknown Source)
java.base@11.0.23/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
java.base@11.0.23/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
java.base@11.0.23/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.base@11.0.23/java.lang.reflect.Method.invoke(Unknown Source)
app//org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
app//org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:205)
com.sun.proxy.$Proxy208.findAllCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(Unknown Source)
br.com.revizia.documentapi.v2.creditoteseartigo426a.service.impl.CreditoTeseArtigo426AServiceImpl.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(CreditoTeseArtigo426AServiceImpl.java:28)
br.com.revizia.documentapi.v2.creditoteseartigo426a.service.impl.CreditoTeseArtigo426AServiceImpl$$FastClassBySpringCGLIB$$91ed21a6.invoke(<generated>)
app//org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
app//org.springframework.transaction.interceptor.TransactionInterceptor$$Lambda$1687/0x0000000840f68040.proceedWithInvocation(Unknown Source)
app//org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367)
app//org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
app//net.bull.javamelody.MonitoringSpringInterceptor.invoke(MonitoringSpringInterceptor.java:76)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
app//org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691)
br.com.revizia.documentapi.v2.creditoteseartigo426a.service.impl.CreditoTeseArtigo426AServiceImpl$$EnhancerBySpringCGLIB$$5861cb4e.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(<generated>)
br.com.revizia.documentapi.v2.creditoteseartigo426a.controller.CreditoTeseArtigo426AController.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(CreditoTeseArtigo426AController.java:37)
br.com.revizia.documentapi.v2.creditoteseartigo426a.controller.CreditoTeseArtigo426AController$$FastClassBySpringCGLIB$$3455e92e.invoke(<generated>)
app//org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
app//net.bull.javamelody.MonitoringSpringInterceptor.invoke(MonitoringSpringInterceptor.java:76)
app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
app//org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691)
br.com.revizia.documentapi.v2.creditoteseartigo426a.controller.CreditoTeseArtigo426AController$$EnhancerBySpringCGLIB$$204b93d5.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(<generated>)
java.base@11.0.23/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
java.base@11.0.23/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
java.base@11.0.23/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.base@11.0.23/java.lang.reflect.Method.invoke(Unknown Source)
app//org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
app//org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
app//org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105)
app//org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:878)
app//org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:792)
app//org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
app//org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)
app//org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)
app//org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
app//org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
app//javax.servlet.http.HttpServlet.service(HttpServlet.java:517)
app//org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
app//javax.servlet.http.HttpServlet.service(HttpServlet.java:584)
app//io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:113)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:113)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:239)
app//net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:215)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320)
app//org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126)
app//org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:118)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:158)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
br.com.revizia.documentapi.config.security.jwt.JwtTokenFilter.doFilterInternal(JwtTokenFilter.java:86)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:92)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.header.HeaderWriterFilter.doHeadersAfter(HeaderWriterFilter.java:92)
app//org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:77)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
app//org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215)
app//org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178)
app//org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:358)
app//org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:271)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:93)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
app//io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
app//io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
app//io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
app//io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
app//io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
app//io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:132)
app//io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
app//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
app//io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
app//io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
app//io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
app//io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
app//io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
app//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
app//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
app//io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
app//io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:269)
app//io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:78)
app//io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:133)
app//io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:130)
app//io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
app//io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
app//io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:249)
app//io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:78)
app//io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:99)
app//io.undertow.server.Connectors.executeRootHandler(Connectors.java:370)
app//io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:836)
app//org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
app//org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:2019)
app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1558)
app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1449)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 XNIO-1 task-3
 no 5 RUNNABLERUNNABLE java.base@11.0.23/java.net.SocketInputStream.socketRead0(Native Method) 43 30 Send a thread interrupt signal to XNIO-1 task-3. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 task-3
The cpu times and user times of these threads are measured from the start of the server

Dump threads as text Dump threads as text       Threads View in a new page


Last collect time: 4 ms
Display time: 53 ms
Memory overhead estimate: < 1 Mb
Disk usage: 1 Mb     Purge the obsolete files

JavaMelody 1.90.0
Debugging logs

Mon Sep 29 18:08:48 BRT 2025     DEBUG     spring interceptor initialized
Mon Sep 29 18:08:48 BRT 2025     DEBUG     spring interceptor initialized
Mon Sep 29 18:08:48 BRT 2025     DEBUG     spring interceptor initialized
Mon Sep 29 18:08:48 BRT 2025     DEBUG     spring interceptor initialized
Mon Sep 29 18:08:48 BRT 2025     DEBUG     spring interceptor initialized
Mon Sep 29 18:08:48 BRT 2025     DEBUG     spring interceptor initialized
Mon Sep 29 18:08:50 BRT 2025     DEBUG     Spring datasource wrapped: dataSource
Mon Sep 29 18:08:54 BRT 2025     DEBUG     JavaMelody listener init started
Mon Sep 29 18:08:54 BRT 2025     DEBUG     datasources found in JNDI: []
Mon Sep 29 18:08:54 BRT 2025     DEBUG     JavaMelody listener init done in 7 ms
Mon Sep 29 18:08:56 BRT 2025     DEBUG     rest template interceptor initialized
Mon Sep 29 18:08:58 BRT 2025     DEBUG     JavaMelody filter init started
Mon Sep 29 18:08:58 BRT 2025     DEBUG     OS: Linux unknown, amd64/64
Mon Sep 29 18:08:58 BRT 2025     DEBUG     Java: OpenJDK Runtime Environment, 11.0.23+9
Mon Sep 29 18:08:58 BRT 2025     DEBUG     Server: Undertow - 2.1.4.Final
Mon Sep 29 18:08:58 BRT 2025     DEBUG     Webapp context:
Mon Sep 29 18:08:58 BRT 2025     DEBUG     JavaMelody version: 1.90.0
Mon Sep 29 18:08:58 BRT 2025     DEBUG     JavaMelody classes loaded from: file:/app/libs/javamelody-core-1.90.0.jar
Mon Sep 29 18:08:58 BRT 2025     DEBUG     Application type: Spring Boot
Mon Sep 29 18:08:58 BRT 2025     DEBUG     Application version: null
Mon Sep 29 18:08:58 BRT 2025     DEBUG     Host: ip-10-0-6-204.ec2.internal@10.0.6.204
Mon Sep 29 18:08:58 BRT 2025     DEBUG     log listeners initialized
Mon Sep 29 18:08:58 BRT 2025     DEBUG     datasources found in JNDI: []
Mon Sep 29 18:08:58 BRT 2025     DEBUG     JPA persistence provider resolver initialized
Mon Sep 29 18:08:58 BRT 2025     DEBUG     counters initialized
Mon Sep 29 18:08:58 BRT 2025     DEBUG     counters data read from files in /tmp/javamelody/_ip-10-0-6-204.ec2.internal
Mon Sep 29 18:08:58 BRT 2025     DEBUG     collect task scheduled every 60s
Mon Sep 29 18:08:58 BRT 2025     DEBUG     first collect of data done
Mon Sep 29 18:08:58 BRT 2025     DEBUG     JavaMelody filter init done in 173 ms