Re: Segfault leading to crash, recovery mode, and TOAST corruption

2018-06-05 Thread Jonathan Marks
Thank you so very much, Tom. Vacuuming fixed the TOAST corruption issue and we’ll upgrade our instances tonight (max RDS has is 10.3, but that’s a start). > On Jun 5, 2018, at 8:07 PM, Tom Lane wrote: > > Jonathan Marks writes: >> We had two issues today (once this morning and once a few min

Re: Segfault leading to crash, recovery mode, and TOAST corruption

2018-06-05 Thread Tom Lane
Jonathan Marks writes: > We had two issues today (once this morning and once a few minutes ago) > with our primary database (RDS running 10.1, 32 cores, 240 GB RAM, 5TB > total disk space, 20k PIOPS) where the database suddenly crashed and > went into recovery mode. I'd suggest updating to 10.4 .

Segfault leading to crash, recovery mode, and TOAST corruption

2018-06-05 Thread Jonathan Marks
Hello — We had two issues today (once this morning and once a few minutes ago) with our primary database (RDS running 10.1, 32 cores, 240 GB RAM, 5TB total disk space, 20k PIOPS) where the database suddenly crashed and went into recovery mode. The first time this happened, we restarted the serv