# gdb --quiet -ex 'bt full' --batch /var/data1/pg_stuff/pg_installations/pgsql.REL_11_STABLE/bin/postgres /var/data1/pg_stuff/tmp/cascade/REL_11_STABLE/6516_gW1Cl/data/core &> gdb_bt_full.txt [New LWP 147484] [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". Core was generated by `postgres: walsender rijkers [local] idle in transaction '. Program terminated with signal SIGABRT, Aborted. #0 0x00007f0fd20e7067 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56 56 ../nptl/sysdeps/unix/sysv/linux/raise.c: No such file or directory. #0 0x00007f0fd20e7067 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56 resultvar = 0 pid = 147484 selftid = 147484 #1 0x00007f0fd20e8448 in __GI_abort () at abort.c:89 save_stage = 2 act = {__sigaction_handler = {sa_handler = 0x0, sa_sigaction = 0x0}, sa_mask = {__val = {0, 35419576, 139705945370615, 1, 0, 2, 139705925209384, 773155, 35419576, 36381032, 139705945396501, 0, 139705926081536, 0, 139705929013136, 139705929007200}}, sa_flags = -748812544, sa_restorer = 0x7f0fd20fd99a <_IO_vfprintf_internal+22490>} sigs = {__val = {32, 0 }} #2 0x00000000008880bf in ExceptionalCondition (conditionName=conditionName@entry=0xa417f8 "!(TransactionIdPrecedesOrEquals(safeXid, snap->xmin))", errorType=errorType@entry=0x8d365d "FailedAssertion", fileName=fileName@entry=0xa41223 "snapbuild.c", lineNumber=lineNumber@entry=580) at assert.c:54 No locals. #3 0x000000000072676e in SnapBuildInitialSnapshot () at snapbuild.c:580 safeXid = 773155 snap = 0x22b2168 xid = 0 newxip = newxcnt = 0 __func__ = "SnapBuildInitialSnapshot" #4 0x000000000072ed54 in CreateReplicationSlot (cmd=0x223bae0) at walsender.c:951 snap = ctx = 0x21c75b8 need_full_snapshot = true snapshot_name = 0x0 nulls = {false, false, false, false} xloc = "\001\231\034\002\000\000\000\000\030\347\031\002\002\000\000\000\000\000\000\000\002\000\000\000Q\000\000\000\000\000\000\000\370\034\032\002\000\000\000\000\030\347\031\002\000\000\000\000Ȼ\034\002", '\000' slot_name = tstate = tupdesc = values = {0, 103, 8192, 6683594} reserve_wal = snapshot_action = dest = __func__ = "CreateReplicationSlot" #5 exec_replication_command (cmd_string=cmd_string@entry=0x21a1cf8 "CREATE_REPLICATION_SLOT \"sub2_6517_6517_18748_sync_18728\" TEMPORARY LOGICAL pgoutput USE_SNAPSHOT") at walsender.c:1527 parse_rc = cmd_node = 0x223bae0 cmd_context = 0x223b410 old_context = 0x21a1be0 __func__ = "exec_replication_command" #6 0x000000000077e8ee in PostgresMain (argc=, argv=argv@entry=0x21cbbc8, dbname=, username=) at postgres.c:4155 query_string = 0x21a1cf8 "CREATE_REPLICATION_SLOT \"sub2_6517_6517_18748_sync_18728\" TEMPORARY LOGICAL pgoutput USE_SNAPSHOT" firstchar = input_message = {data = 0x21a1cf8 "CREATE_REPLICATION_SLOT \"sub2_6517_6517_18748_sync_18728\" TEMPORARY LOGICAL pgoutput USE_SNAPSHOT", len = 98, maxlen = 1024, cursor = 98} local_sigjmp_buf = {{__jmpbuf = {657920533, -5186006737813875216, 35251992, 35437512, 1535629124, 35251992, 5188120396153509360, -5186006335271315984}, __mask_was_saved = 1, __saved_mask = {__val = {0, 35437440, 10709497, 35251992, 35265504, 1024, 35437512, 35437512, 9122032, 0, 9094142, 14351168, 140721267739056, 35437512, 9011115, 35270984}}}} send_ready_for_query = false disable_idle_in_transaction_timeout = false __func__ = "PostgresMain" #7 0x0000000000704fde in BackendRun (port=0x21c4520) at postmaster.c:4361 ac = 1 secs = 588944346 usecs = 999759 i = 1 av = 0x21cbbc8 maxac = 2 __func__ = "BackendRun" #8 BackendStartup (port=0x21c4520) at postmaster.c:4033 bn = pid = __func__ = "BackendStartup" #9 ServerLoop () at postmaster.c:1706 port = 0x21c4520 rmask = {fds_bits = {32, 0 }} selres = now = readmask = {fds_bits = {56, 0 }} nSockets = 6 last_lockfile_recheck_time = last_touch_time = __func__ = "ServerLoop" #10 0x0000000000705e0f in PostmasterMain (argc=argc@entry=12, argv=argv@entry=0x219c470) at postmaster.c:1379 opt = status = userDoption = listen_addr_saved = i = output_config_variable = __func__ = "PostmasterMain" #11 0x0000000000478d80 in main (argc=12, argv=0x219c470) at main.c:228 No locals. #---------------- $ gdb --quiet /var/data1/pg_stuff/pg_installations/pgsql.REL_11_STABLE/bin/postgres /var/data1/pg_stuff/tmp/cascade/REL_11_STABLE/6516_gW1Cl/data/core Reading symbols from /var/data1/pg_stuff/pg_installations/pgsql.REL_11_STABLE/bin/postgres...done. [New LWP 147484] [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". Core was generated by `postgres: walsender rijkers [local] idle in transaction '. Program terminated with signal SIGABRT, Aborted. #0 0x00007f0fd20e7067 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56 56 ../nptl/sysdeps/unix/sysv/linux/raise.c: No such file or directory. (gdb) frame 3 #3 0x000000000072676e in SnapBuildInitialSnapshot () at snapbuild.c:580 580 Assert(TransactionIdPrecedesOrEquals(safeXid, snap->xmin)); (gdb) print *snap $1 = {satisfies = 0x8c4700 , xmin = 772089, xmax = 772089, xip = 0x22b21d0, xcnt = 0, subxip = 0x0, subxcnt = 0, suboverflowed = false, takenDuringRecovery = false, copied = false, curcid = 0, speculativeToken = 0, active_count = 0, regd_count = 0, ph_node = { first_child = 0x0, next_sibling = 0x0, prev_or_parent = 0x0}, whenTaken = 0, lsn = 0} (gdb)