Segmentation Failure #2074

Hi Team,

After executing a simple analyze on a partitioned table the segmentation got failed.

version: -local Cloudberry Version: 'postgres (Apache Cloudberry) 2.1.0-incubating build bdf90c5'

PFB the error log:

2026-10-05 12:47:16.593620 CEST,,,p52667,th-454989632,,,,0,,,seg-1,,,,,"LOG","00000","server process (PID 776260) was terminated by signal 11: Segmentation fault","Failed process was running: analyze applied_ai_staging.enel_sales_sme_vaca_v6;",,,,,,0,,"postmaster.c",4285,

PFB the table DDL:

CREATE TABLE applied_ai_staging.enel_sales_sme_vaca_v6 (
conn_segment_id character varying(50),
call_category character varying(2),
call_type character varying(2),
call_key character varying(255),
conn_id character varying(50),
segment_id character varying(1),
btn character varying(255),
prefix_number character varying(50),
bpo_type character varying(34),
is_inscope_bpo_type bigint,
coda character varying(255),
coda_mis character varying(255),
partner character varying(255),
vag character varying(255),
dnis character varying(50),
last_stadio character varying(255),
is_ring_abandon bigint,
is_answered bigint,
call_agent character varying(255),
call_agent_type character varying(2),
call_start timestamp without time zone,
talk_start timestamp without time zone,
call_end timestamp without time zone,
call_date date,
next_talk_start timestamp without time zone,
call_window_start timestamp without time zone,
call_window_end timestamp without time zone,
original_conn_id character varying(50),
prev_coda character varying(255),
prev_coda_mis character varying(255),
prev_partner character varying(255),
prev_vag character varying(255),
prev_agent character varying(255),
next_coda character varying(255),
next_coda_mis character varying(255),
next_partner character varying(255),
next_vag character varying(255),
next_agent character varying(255),
is_unique_conn_id bigint,
ecl_callguid character varying(64),
ecl_callkey character varying(255),
ecl_connid character varying(50),
ecl_segmentid character varying(50),
ecl_calldate date,
ecl_calltime timestamp(3) without time zone,
ecl_answtime timestamp(3) without time zone,
ecl_agentid character varying(50),
ecl_vdn character varying(256),
ecl_btn character varying(140),
ecl_lastrouteresponse character varying(50),
ecl_onoff bigint,
is_portal bigint,
ivr_client_id bigint,
ivr_client_sap text,
ivr_client_type character varying(120),
ivr_client_status character varying(255),
ivr_client_dob character varying(5),
num_clients bigint,
num_outcome_clients bigint,
client_ids text,
outcome_client_ids text,
client_saps text,
outcome_client_saps text,
sap_id_1 text,
sap_id_2 text,
client_id_method text,
client_type text,
client_status text,
client_dob text,
outcome_keys text,
num_outcomes bigint,
offer_ids text,
num_offers bigint,
interaction_date timestamp without time zone,
case_date timestamp without time zone,
offer_date timestamp without time zone,
is_offer bigint,
is_offer_without_sale bigint,
num_offers_without_sale double precision,
is_ele_offer bigint,
is_gas_offer bigint,
num_ele_offers bigint,
num_gas_offers bigint,
sale_ids text,
num_sales double precision,
is_sale bigint,
is_bweb_sale double precision,
is_rid_sale double precision,
num_bweb_sales double precision,
num_rid_sales double precision,
is_bweb_without_offer_sale double precision,
is_rid_without_offer_sale double precision,
is_bwebrid_without_offer_sale bigint,
is_bweb_with_offer_sale double precision,
is_rid_with_offer_sale double precision,
is_bwebrid_with_offer_sale bigint,
is_bweb_with_swa_sale double precision,
is_rid_with_swa_sale double precision,
is_bwebrid_with_swa_sale bigint,
num_bweb_without_offer_sales double precision,
num_rid_without_offer_sales double precision,
num_bwebrid_without_offer_sales double precision,
num_bweb_with_offer_sales double precision,
num_rid_with_offer_sales double precision,
num_bwebrid_with_offer_sales double precision,
num_bweb_with_swa_sales double precision,
num_rid_with_swa_sales double precision,
num_bwebrid_with_swa_sales double precision,
is_swa_sale bigint,
num_swa_sales double precision,
is_ele_sale bigint,
is_gas_sale bigint,
is_ele_swa_sale bigint,
is_gas_swa_sale bigint,
is_ele_subentro_sale bigint,
is_gas_subentro_sale bigint,
num_ele_sales double precision,
num_gas_sales double precision,
num_ele_swa_sales bigint,
num_gas_swa_sales bigint,
num_ele_subentro_sales double precision,
num_gas_subentro_sales double precision,
ele_revenue double precision,
gas_revenue double precision,
total_revenue double precision,
sale_ids_raw text,
num_sales_raw double precision,
is_sale_raw bigint,
is_bweb_sale_raw bigint,
is_rid_sale_raw bigint,
num_bweb_sales_raw double precision,
num_rid_sales_raw double precision,
is_bweb_without_offer_sale_raw bigint,
is_rid_without_offer_sale_raw bigint,
is_bwebrid_without_offer_sale_raw bigint,
is_bweb_with_offer_sale_raw bigint,
is_rid_with_offer_sale_raw bigint,
is_bwebrid_with_offer_sale_raw bigint,
is_bweb_with_swa_sale_raw bigint,
is_rid_with_swa_sale_raw bigint,
is_bwebrid_with_swa_sale_raw bigint,
num_bweb_without_offer_sales_raw double precision,
num_rid_without_offer_sales_raw double precision,
num_bwebrid_without_offer_sales_raw double precision,
num_bweb_with_offer_sales_raw double precision,
num_rid_with_offer_sales_raw double precision,
num_bwebrid_with_offer_sales_raw double precision,
num_bweb_with_swa_sales_raw double precision,
num_rid_with_swa_sales_raw double precision,
num_bwebrid_with_swa_sales_raw double precision,
is_swa_sale_raw bigint,
num_swa_sales_raw double precision,
is_ele_sale_raw bigint,
is_gas_sale_raw bigint,
is_ele_swa_sale_raw bigint,
is_gas_swa_sale_raw bigint,
num_ele_sales_raw double precision,
num_gas_sales_raw double precision,
num_ele_swa_sales_raw bigint,
num_gas_swa_sales_raw bigint,
ele_revenue_raw double precision,
gas_revenue_raw double precision,
total_revenue_raw double precision,
offer_commodities text,
offer_types text,
offer_commodity text,
offer_type text,
offer_outcome_category text,
offer_outcome_type text,
offer_outcome_reason text,
offer_outcome_operation_type text,
outcome_categories text,
outcome_types text,
outcome_reasons text,
outcome_operation_types text,
outcome_category text,
outcome_type text,
outcome_reason text,
outcome_operation_type text,
is_meter_reading bigint,
is_debt_payment bigint,
is_outcome_agent_mismatch bigint,
is_original_agent_mismatch bigint,
is_sale_matured bigint,
num_sales_matured double precision,
is_bweb_sale_matured double precision,
is_rid_sale_matured double precision,
num_bweb_sales_matured double precision,
num_rid_sales_matured double precision,
is_swa_sale_matured bigint,
num_swa_sales_matured double precision,
is_ele_swa_sale_matured bigint,
is_gas_swa_sale_matured bigint,
num_ele_swa_sales_matured bigint,
num_gas_swa_sales_matured bigint,
is_swa_sale_fulfilled double precision,
num_swa_sales_fulfilled double precision,
is_ele_swa_sale_fulfilled bigint,
is_gas_swa_sale_fulfilled bigint,
num_ele_swa_sales_fulfilled bigint,
num_gas_swa_sales_fulfilled bigint,
num_outcomes_ob bigint,
num_sales_ob double precision,
is_sale_ob bigint,
is_bweb_sale_ob bigint,
is_rid_sale_ob bigint,
num_bweb_sales_ob double precision,
num_rid_sales_ob double precision,
is_swa_sale_ob double precision,
num_swa_sales_ob double precision,
is_ele_sale_ob bigint,
is_gas_sale_ob bigint,
is_ele_swa_sale_ob bigint,
is_gas_swa_sale_ob bigint,
is_ele_subentro_sale_ob bigint,
is_gas_subentro_sale_ob bigint,
num_ele_sales_ob double precision,
num_gas_sales_ob double precision,
num_ele_swa_sales_ob bigint,
num_gas_swa_sales_ob bigint,
num_ele_subentro_sales_ob double precision,
num_gas_subentro_sales_ob double precision,
ele_revenue_ob double precision,
gas_revenue_ob double precision,
total_revenue_ob double precision,
num_outcomes_ibob bigint,
num_sales_ibob double precision,
is_sale_ibob bigint,
is_bweb_sale_ibob bigint,
is_rid_sale_ibob bigint,
num_bweb_sales_ibob double precision,
num_rid_sales_ibob double precision,
is_swa_sale_ibob bigint,
num_swa_sales_ibob double precision,
is_ele_sale_ibob bigint,
is_gas_sale_ibob bigint,
is_ele_swa_sale_ibob bigint,
is_gas_swa_sale_ibob bigint,
is_ele_subentro_sale_ibob bigint,
is_gas_subentro_sale_ibob bigint,
num_ele_sales_ibob double precision,
num_gas_sales_ibob double precision,
num_ele_swa_sales_ibob bigint,
num_gas_swa_sales_ibob bigint,
num_ele_subentro_sales_ibob double precision,
num_gas_subentro_sales_ibob double precision,
ele_revenue_ibob double precision,
gas_revenue_ibob double precision,
total_revenue_ibob double precision,
total_revenue_with_subentro_ibob double precision,
vdn character varying(256),
answtime_ecl timestamp without time zone,
aht double precision,
isrelevant integer,
attacheddata character varying(8000),
total_revenue_adjusted double precision,
nagent bigint,
ncustomers bigint,
callid character varying(50),
ucid character varying(50),
wrapendtime timestamp without time zone,
afi_onoff character varying(50),
prev_afi_onoff character varying(50),
next_afi_onoff character varying(50),
ivr_cli_id character varying(50),
cli_ids text,
is_bweb_subentro_sale double precision,
is_bweb_rvc_voltura_sale double precision,
is_rid_subentro_sale double precision,
is_rid_rvc_voltura_sale double precision,
offer_statuses text,
offer_status text,
is_bweb_subentro_sale_matured double precision,
is_bweb_rvc_voltura_sale_matured double precision,
is_rid_subentro_sale_matured double precision,
is_rid_rvc_voltura_sale_matured double precision,
is_bweb_subentro_sale_ob bigint,
is_bweb_rvc_voltura_sale_ob bigint,
is_rid_subentro_sale_ob bigint,
is_rid_rvc_voltura_sale_ob bigint,
is_match_14 bigint,
is_bweb_subentro_sale_ibob bigint,
is_bweb_rvc_voltura_sale_ibob bigint,
is_rid_subentro_sale_ibob bigint,
is_rid_rvc_voltura_sale_ibob bigint,
is_sale_with_voltura_cf bigint,
is_sale_with_voltura_cf_subentro bigint,
is_bweb_voltura_cf_sale double precision,
is_rid_voltura_cf_sale double precision,
is_voltura_cf_sale bigint,
num_voltura_cf_sales double precision,
is_subentro_sale bigint,
num_subentro_sales double precision,
total_revenue_with_voltura_cf double precision,
total_revenue_with_voltura_cf_subentro double precision,
is_sale_with_voltura_cf_raw bigint,
is_sale_with_voltura_cf_subentro_raw bigint,
is_voltura_cf_sale_raw bigint,
num_voltura_cf_sales_raw double precision,
is_subentro_sale_raw bigint,
num_subentro_sales_raw double precision,
is_bweb_voltura_cf_sale_matured double precision,
is_rid_voltura_cf_sale_matured double precision,
is_voltura_cf_sale_matured bigint,
num_voltura_cf_sales_matured double precision,
is_subentro_sale_matured bigint,
num_subentro_sales_matured double precision,
is_sale_with_voltura_cf_ob bigint,
is_sale_with_voltura_cf_subentro_ob bigint,
is_bweb_voltura_cf_sale_ob bigint,
is_rid_voltura_cf_sale_ob bigint,
is_voltura_cf_sale_ob double precision,
num_voltura_cf_sales_ob double precision,
is_subentro_sale_ob double precision,
num_subentro_sales_ob double precision,
total_revenue_with_voltura_cf_ob double precision,
total_revenue_with_voltura_cf_subentro_ob double precision,
is_sale_with_voltura_cf_ibob bigint,
is_sale_with_voltura_cf_subentro_ibob bigint,
is_bweb_voltura_cf_sale_ibob bigint,
is_rid_voltura_cf_sale_ibob bigint,
is_voltura_cf_sale_ibob bigint,
num_voltura_cf_sales_ibob double precision,
is_subentro_sale_ibob bigint,
num_subentro_sales_ibob double precision,
total_revenue_with_voltura_cf_ibob double precision,
total_revenue_with_voltura_cf_subentro_ibob double precision,
revenue_subentro double precision,
ele_revenue_subentro double precision,
gas_revenue_subentro double precision,
ele_gas_revenue_subentro double precision,
switch character varying(2),
skill character varying(250),
queued_skill_list character varying(1000),
agent_group bigint DEFAULT 0 NOT NULL
)
PARTITION BY RANGE (call_date) DISTRIBUTED BY (conn_segment_id);