- Newest
- Most votes
- Most comments
We continue to see the identical segfault/restart pattern every 6 hours or so.
We're rebuilding the large indexes and trying to narrow to a reproducible case.
A similar case, but on a different stack: https://github.com/postgrespro/pg_pathman/issues/193
We copied the db to a test instance and can reproduce the segfault with a one-line SELECT statement.
Hi Northrock. I am a development manager for Aurora PostgreSQL. We are very sorry for the issue you have encountered on 9.6.12. Our engineers have identified the problem and we have prepared a patch release. This is being deployed to our production regions now and will appear as available maintenance for your cluster once it reaches your region.
If you would like to send me a pm with your region and cluster name we can provide some additional options in terms of patching.
That's great news! Once deployed, I'll recheck our reproducible case and report back quickly.
The issue appears to be fully resolved.
Thanks for the special support. Much appreciated.
Hello,
We just upgraded from 9.6.8 to 9.6.12 last night, and we immediately started seeing crashes with a frequency of about once/hour.
Is there another fix/upgrade available for the 9.6-compatible Aurora series?
Updating Aurora 1.5.0 to 1.5.1 resolved our issue.
SELECT AURORA_VERSION();
Hello AWS,
Check my thread,. We are on Aurora 10.7 and we are running into this all the time, at few times a week. It just bought down our live site again.
Roll out the AURORA update faster, AWS Support!
This same problem started randomly hitting our 9.6 clusters this week and we just can only watch them restart until things clear up.
Typically we start seeing random queries start taking longer than normal and some take 10 or more minutes. Normally the same query would average under 2 seconds.
I've had to delete and reindex some indices due to errors like: Attempting to read past EOF of relation "base/16402/24527244". blockno=6400 nblocks=3834
Aurora is on version 1.5.0 -- which is something only AWS can update.
Relevant content
- asked 6 months ago
- asked 3 months ago
- Accepted Answerasked 9 months ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated a year ago