citusdata / citusdata/citus

Assertion failure when the columnar table is the subscriber

Open
#5,980 0 comments 0 reactions 0 assignees View on GitHub
bug columnar dev_reported
Dominant language
C
Stars
12.8k
Forks
794
Avg merge
2d 14h
Merged PRs (30d)
31

Description

```sql
-- on node 10700
create table pub (a int unique);
create publication my_pub for table pub;

-- on node 10701
create table pub (a int unique) using columnar;
create subscription my_sub CONNECTION 'host=localhost port=10700 dbname=onurctirtir' PUBLICATION my_pub;

-- on node 10700
insert into pub values (6);
```

And then on node 10701, we keep getting such coredumps:
```c
libc.so.6!__GI_raise(int sig) (\build\glibc-eX1tMB\glibc-2.31\sysdeps\unix\sysv\linux\raise.c:50)
libc.so.6!__GI_abort() (\build\glibc-eX1tMB\glibc-2.31\stdlib\abort.c:79)
ExceptionalCondition(const char * conditionName, const char * errorType, const char * fileName, int lineNumber) (\opt\pgenv\src\postgresql-14.2\src\backend\utils\error\assert.c:69)
ExecInsertIndexTuples(ResultRelInfo * resultRelInfo, TupleTableSlot * slot, EState * estate, _Bool update, _Bool noDupErr, _Bool * specConflict, List * arbiterIndexes) (\opt\pgenv\src\postgresql-14.2\src\backend\executor\execIndexing.c:309)
ExecSimpleRelationInsert(ResultRelInfo * resultRelInfo, EState * estate, TupleTableSlot * slot) (\opt\pgenv\src\postgresql-14.2\src\backend\executor\execReplication.c:446)
apply_handle_insert_internal(ApplyExecutionData * edata, ResultRelInfo * relinfo, TupleTableSlot * remoteslot) (\opt\pgenv\src\postgresql-14.2\src\backend\replication\logical\worker.c:1310)
apply_handle_insert(StringInfo s) (\opt\pgenv\src\postgresql-14.2\src\backend\replication\logical\worker.c:1284)
apply_dispatch(StringInfo s) (\opt\pgenv\src\postgresql-14.2\src\backend\replication\logical\worker.c:2014)
LogicalRepApplyLoop(XLogRecPtr last_received) (\opt\pgenv\src\postgresql-14.2\src\backend\replication\logical\worker.c:2262)
ApplyWorkerMain(Datum main_arg) (\opt\pgenv\src\postgresql-14.2\src\backend\replication\logical\worker.c:3224)
StartBackgroundWorker() (\opt\pgenv\src\postgresql-14.2\src\backend\postmaster\bgworker.c:875)
do_start_bgworker(RegisteredBgWorker * rw) (\opt\pgenv\src\postgresql-14.2\src\backend\postmaster\postmaster.c:5866)
maybe_start_bgworkers() (\opt\pgenv\src\postgresql-14.2\src\backend\postmaster\postmaster.c:6091)
sigusr1_handler(int postgres_signal_arg) (\opt\pgenv\src\postgresql-14.2\src\backend\postmaster\postmaster.c:5255)
libpthread.so.0! (Unknown Source:0)
libc.so.6!__GI___select(int nfds, fd_set * readfds, fd_set * writefds, fd_set * exceptfds, struct timeval * timeout) (\build\glibc-eX1tMB\glibc-2.31\sysdeps\unix\sysv\linux\select.c:41)
ServerLoop() (\opt\pgenv\src\postgresql-14.2\src\backend\postmaster\postmaster.c:1709)
PostmasterMain(int argc, char ** argv) (\opt\pgenv\src\postgresql-14.2\src\backend\postmaster\postmaster.c:1417)
main(int argc, char ** argv) (\opt\pgenv\src\postgresql-14.2\src\backend\main\main.c:209)
```

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.