PANIC","XX000","Unexpected internal error: Master process received signal SIGSEGV"

Products

• VMware Tanzu Greenplum
• VMware Tanzu Data Suite
• VMware Tanzu Data Suite

Issue/Introduction

Master Panic after running a new query, Only fails with GPORCA. 

2024-03-29 23:02:40.860504 GMT,"gpadmin","gpadmin",p31783,th1263855744,"[local]",,2024-03-29 23:01:52 GMT,0,con5,cmd8,seg-1,,,,sx1,"LOG","00000","statement: select * from uniq_name ;",,,,,,"select * from uniq_name ;",0,,"postgres.c
",1667,
2024-03-29 23:02:41.279686 GMT,,,p31783,th0,,,2024-03-29 23:01:52 GMT,0,con5,cmd8,seg-1,,,,,"PANIC","XX000","Unexpected internal error: Master process received signal SIGSEGV",,,,,,,0,,,,"1    0x7fad48b4c630 libpthread.so.0 <symbol
 not found> + 0x48b4c630
2    0x1007468 postgres _ZN5gpdxl21CTranslatorQueryToDXL27TranslateRTEToDXLLogicalGetEPK13RangeTblEntryjj (CTranslatorQueryToDXL.cpp:3248)
3    0x100e6c6 postgres _ZN5gpdxl21CTranslatorQueryToDXL22TranslateFromExprToDXLEP8FromExpr (CTranslatorQueryToDXL.cpp:3026)
4    0x100ff4a postgres _ZN5gpdxl21CTranslatorQueryToDXL21TranslateGroupingSetsEP8FromExprP4ListS4_bPN4gpos8CHashMapIijXadL_ZNS5_9HashValueIiEEjPKT_EEXadL_ZNS5_6EqualsIiEEbSA_SA_EEXadL_ZNS5_13CleanupDeleteIiEEvPS8_EEXadL_ZNSC_IjEEv
SD_EEEESF_ (CTranslatorQueryToDXL.cpp:614)
5    0x101038d postgres _ZN5gpdxl21CTranslatorQueryToDXL25TranslateSelectQueryToDXLEv (CTranslatorQueryToDXL.cpp:558)
6    0x1011ae6 postgres _ZN5gpdxl21CTranslatorQueryToDXL19TranslateQueryToDXLEv (CTranslatorQueryToDXL.cpp:660)
7    0x1026cc4 postgres _ZN9COptTasks12OptimizeTaskEPv (discriminator 3)
8    0xd0c186 postgres _ZN4gpos5CTask7ExecuteEv (CTask.cpp:130)
9    0xd0d118 postgres _ZN4gpos7CWorker7ExecuteEPNS_5CTaskE (CWorker.cpp:82)
10   0xd0b64d postgres _ZN4gpos14CAutoTaskProxy7ExecuteEPNS_5CTaskE (CAutoTaskProxy.cpp:301)
11   0xd0dc71 postgres gpos_exec (_api.cpp:224)
12   0x1025fd2 postgres _ZN9COptTasks18GPOPTOptimizedPlanEP5QueryP11SOptContext (COptTasks.cpp:261)
13   0x1028361 postgres GPOPTOptimizedPlan (CGPOptimizer.cpp:60)
14   0x9deb68 postgres optimize_query (orca.c:46)
15   0x9cfc56 postgres standard_planner (planner.c:243)
16   0x9cffa5 postgres planner (planner.c:200)
17   0xa97bf1 postgres <symbol not found> (postgres.c:975)
18   0xa9aea6 postgres PostgresMain (postgres.c:5334)

Cause

Table was created with zero columns, this issue can be recreated by following the below procedure

create table test (a int, b varchar(20));

insert into test values (generate_series(0,99), 'test01');

create temp table uniq_name 
WITH (appendoptimized=true,compresstype=zstd) AS
select distinct on (b) 
from test
order by b;

select * from uniq_name ; -- Planner seems to panic.

Resolution

Workaround.

Avoid creating/using tables with no columns

 

Resolution.

upgrade to the latest GPDB code at a minimum 6.27.2