citus
citus copied to clipboard
CREATE STATISTICS crash when input relation is not supported for PG16/PG17
I've detected the same issue as https://github.com/citusdata/citus/issues/8212, but for PG16(REL_16_STABLE rev b509d952c) with citus release-12.1(rev b509d952c).
make check-vanilla
...............................
Program terminated with signal SIGSEGV, Segmentation fault.
#0 __strlen_avx2 () at ../sysdeps/x86_64/multiarch/strlen-avx2.S:76
warning: 76 ../sysdeps/x86_64/multiarch/strlen-avx2.S: No such file or directory
(gdb) bt
#0 __strlen_avx2 () at ../sysdeps/x86_64/multiarch/strlen-avx2.S:76
#1 0x0000618fd8656132 in dopr (target=0x7ffe2ffe1660, format=0x618fd8690690 "\"", args=0x7ffe2ffe1780) at snprintf.c:441
#2 0x0000618fd865595c in pg_vsnprintf (str=0x618ff8447458 "cross-database references are not implemented: \"{.\002.", '\177' <repeats 148 times>..., count=1024, fmt=0x618fd8690658 "cross-database references are not implemented: \"%s.%s.%s\"",
args=0x7ffe2ffe1780) at snprintf.c:195
#3 0x0000618fd864acfa in pvsnprintf (buf=0x618ff8447458 "cross-database references are not implemented: \"{.\002.", '\177' <repeats 148 times>..., len=1024, fmt=0x618fd8690658 "cross-database references are not implemented: \"%s.%s.%s\"",
args=0x7ffe2ffe1780) at psprintf.c:110
#4 0x0000618fd864ccf3 in appendStringInfoVA (str=0x7ffe2ffe1760, fmt=0x618fd8690658 "cross-database references are not implemented: \"%s.%s.%s\"", args=0x7ffe2ffe1780) at stringinfo.c:149
#5 0x0000618fd85d706e in errmsg (fmt=0x618fd8690658 "cross-database references are not implemented: \"%s.%s.%s\"") at elog.c:1083
#6 0x0000618fd7f7dd6a in RangeVarGetRelidExtended (relation=0x618ff867f198, lockmode=4, flags=0, callback=0x0, callback_arg=0x0) at namespace.c:258
#7 0x000078dff245ddfa in PreprocessCreateStatisticsStmt (node=0x618ff8655fd8, queryString=0x618ff848cc58 "CREATE STATISTICS tst ON a FROM (VALUES (x)) AS foo;", processUtilityContext=PROCESS_UTILITY_TOPLEVEL) at commands/statistics.c:73
#8 0x000078dff246dae8 in ProcessUtilityInternal (pstmt=0x618ff8655ec8, queryString=0x618ff848cc58 "CREATE STATISTICS tst ON a FROM (VALUES (x)) AS foo;", context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x618ff848de20,
completionTag=0x7ffe2ffe24d0) at commands/utility_hook.c:635
#9 0x000078dff246d2f2 in multi_ProcessUtility (pstmt=0x618ff848db60, queryString=0x618ff848cc58 "CREATE STATISTICS tst ON a FROM (VALUES (x)) AS foo;", readOnlyTree=false, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0,
dest=0x618ff848de20, completionTag=0x7ffe2ffe24d0) at commands/utility_hook.c:334
#10 0x000078dff5f2196e in pgss_ProcessUtility (pstmt=0x618ff848db60, queryString=0x618ff848cc58 "CREATE STATISTICS tst ON a FROM (VALUES (x)) AS foo;", readOnlyTree=false, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0,
dest=0x618ff848de20, qc=0x7ffe2ffe24d0) at pg_stat_statements.c:1141
#11 0x0000618fd83ed757 in ProcessUtility (pstmt=0x618ff848db60, queryString=0x618ff848cc58 "CREATE STATISTICS tst ON a FROM (VALUES (x)) AS foo;", readOnlyTree=false, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0,
dest=0x618ff848de20, qc=0x7ffe2ffe24d0) at utility.c:526
#12 0x0000618fd83ec0b0 in PortalRunUtility (portal=0x618ff85add98, pstmt=0x618ff848db60, isTopLevel=true, setHoldSnapshot=false, dest=0x618ff848de20, qc=0x7ffe2ffe24d0) at pquery.c:1156
#13 0x0000618fd83ec327 in PortalRunMulti (portal=0x618ff85add98, isTopLevel=true, setHoldSnapshot=false, dest=0x618ff848de20, altdest=0x618ff848de20, qc=0x7ffe2ffe24d0) at pquery.c:1313
#14 0x0000618fd83eb783 in PortalRun (portal=0x618ff85add98, count=9223372036854775807, isTopLevel=true, run_once=true, dest=0x618ff848de20, altdest=0x618ff848de20, qc=0x7ffe2ffe24d0) at pquery.c:789
#15 0x0000618fd83e4173 in exec_simple_query (query_string=0x618ff848cc58 "CREATE STATISTICS tst ON a FROM (VALUES (x)) AS foo;") at postgres.c:1278
#16 0x0000618fd83e955f in PostgresMain (dbname=0x618ff854ad08 "regression", username=0x618ff854ace8 "postgres") at postgres.c:4725
#17 0x0000618fd830858e in BackendRun (port=0x618ff8546de0) at postmaster.c:4465
#18 0x0000618fd8307e1a in BackendStartup (port=0x618ff8546de0) at postmaster.c:4193
#19 0x0000618fd8304092 in ServerLoop () at postmaster.c:1784
#20 0x0000618fd830393c in PostmasterMain (argc=5, argv=0x618ff8445240) at postmaster.c:1468
#21 0x0000618fd81b5ca1 in main (argc=5, argv=0x618ff8445240) at main.c:200
I suggest to backport changes from https://github.com/citusdata/citus/pull/8213 to release-12.1 and release-13.0 branches