Re: crash 11.5~ (and 11.4)

2019-08-07 Thread Justin Pryzby
On Wed, Aug 07, 2019 at 04:51:54PM -0700, Andres Freund wrote: > Hi, > > On 2019-08-07 14:29:28 -0500, Justin Pryzby wrote: > > Just found this, although I'm not sure what to do about it. If it's corrupt > > table data, I can restore from backup. In the meantime, I've renamed+uninherited the tab

Re: crash 11.5~ (and 11.4)

2019-08-07 Thread Andres Freund
Hi, On 2019-08-07 14:29:28 -0500, Justin Pryzby wrote: > Just found this, although I'm not sure what to do about it. If it's corrupt > table data, I can restore from backup. > > ts=# VACUUM FREEZE VERBOSE child.huawei_umts_ucell_201908; > INFO: 0: aggressively vacuuming "child.huawei_umts_u

Re: crash 11.5~ (and 11.4)

2019-08-07 Thread Justin Pryzby
Just found this, although I'm not sure what to do about it. If it's corrupt table data, I can restore from backup. ts=# VACUUM FREEZE VERBOSE child.huawei_umts_ucell_201908; INFO: 0: aggressively vacuuming "child.huawei_umts_ucell_201908" LOCATION: lazy_scan_heap, vacuumlazy.c:502 ERROR: X

Re: crash 11.5~ (and 11.4)

2019-08-07 Thread Justin Pryzby
I checked this still happens with max_parallel_workers_per_gather=0. Now, I just reproduced using SELECT * FROM that table: (gdb) p thisatt->attrelid $4 = 2015128626 ts=# SELECT 2015128626::regclass; regclass | child.huawei_umts_ucell_201908 (gdb) p thisatt->attnum $1 = 2 (gdb) p attnum # For e