pg_mooncake conflicts with citus

[bpint]

What happens?

i tried to run citus and pg_mooncake extensions on the same postgres instance, postgres crashed.

To Reproduce

i built citus 12.1.4 and pg_mooncake latest git on postgresql 16.4, and enabled both of them. when i try to test pg_mooncake,

CREATE EXTENSION pg_mooncake;
CREATE TABLE pg_mooncake_test(id BIGINT, log TEXT, ts TIMESTAMP) USING columnstore;
INSERT INTO pg_mooncake_test VALUES  (1, 'test', '2024-01-01 08:00:00');
SELECT * FROM pg_mooncake_test;
DROP TABLE pg_mooncake_test;

postgres crashed by the SELECT statement.

2024-11-18 13:52:49.604 CST [80218] LOG:  server process (PID 80275) was terminated by signal 11: Segmentation fault
2024-11-18 13:52:49.604 CST [80218] DETAIL:  Failed process was running: SELECT * FROM pg_mooncake_test;
2024-11-18 13:52:49.604 CST [80218] LOG:  terminating any other active server processes
2024-11-18 13:52:49.606 CST [80218] LOG:  all server processes terminated; reinitializing
2024-11-18 13:52:49.651 CST [80287] LOG:  database system was interrupted; last known up at 2024-11-18 13:51:27 CST
2024-11-18 13:52:49.756 CST [80287] LOG:  database system was not properly shut down; automatic recovery in progress
2024-11-18 13:52:49.762 CST [80287] LOG:  redo starts at 0/1996648
2024-11-18 13:52:49.768 CST [80287] LOG:  invalid record length at 0/19AE348: expected at least 24, got 0
2024-11-18 13:52:49.768 CST [80287] LOG:  redo done at 0/19AE310 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s
2024-11-18 13:52:49.783 CST [80288] LOG:  checkpoint starting: end-of-recovery immediate wait
2024-11-18 13:52:49.879 CST [80288] LOG:  checkpoint complete: wrote 27 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.003 s, sync=0.074 s, total=0.106 s; sync files=22, longest=0.005 s, average=0.004 s; distance=95 kB, estimate=95 kB; lsn=0/19AE348, redo lsn=0/19AE348
2024-11-18 13:52:49.891 CST [80218] LOG:  database system is ready to accept connections

OS:

RHEL 8

pg_mooncake Version:

f1818d4

Postgres Version:

16.4

Are you using pg_mooncake Docker, Neon, or the extension standalone?

pg_mooncake extension standalone

[dpxcc]

Thanks for the bug report!
Filed a bug upstream at duckdb/pg_duckdb#444