Re: BUG #16833: postgresql 13.1 process crash every hour

Alex F <phoedos16(at)gmail(dot)com> writes:
> Think I was able to get a gdb stack trace. Logs attached.

> Program terminated with signal SIGSEGV, Segmentation fault.
> #0 0x00007ffa43a2c94d in __memmove_avx_unaligned_erms () from
> /lib64/libc.so.6
> (gdb) bt
> #0 0x00007ffa43a2c94d in __memmove_avx_unaligned_erms () from
> /lib64/libc.so.6
> #1 0x00000000004d67f5 in _bt_swap_posting ()
> #2 0x00000000004d792e in _bt_insertonpg ()
> #3 0x00000000004d9113 in _bt_doinsert ()
> #4 0x00000000004dc1a1 in btinsert ()
> #5 0x000000000060fa7f in ExecInsertIndexTuples ()
> #6 0x0000000000637078 in ExecInsert ()
> #7 0x00000000006379c7 in ExecModifyTable ()
> #8 0x00000000006107dc in standard_ExecutorRun ()
> #9 0x0000000000645695 in _SPI_execute_plan ()
> #10 0x0000000000645a3c in SPI_execute ()
> #11 0x00000000005c39ff in ExecRefreshMatView ()
> #12 0x000000000075799d in ProcessUtilitySlow.isra.4 ()
> #13 0x00000000007567ce in standard_ProcessUtility ()
> #14 0x0000000000754382 in PortalRunUtility ()
> #15 0x0000000000754d4d in PortalRunMulti ()
> #16 0x0000000000755763 in PortalRun ()
> #17 0x000000000075330b in PostgresMain ()
> #18 0x00000000006e2d8a in ServerLoop ()
> #19 0x00000000006e3df7 in PostmasterMain ()
> #20 0x00000000004883c2 in main ()

Hmm, looks like it's time to rope Peter Geoghegan in on this discussion.

regards, tom lane