BUG #16595: Reads fail with "lost saved point in index" error after writes
The Post Office <noreply@postgresql.org>
From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: jesse@falkon.ai
Date: 2020-08-27T03:40:47Z
Lists: pgsql-bugs
The following bug has been logged on the website: Bug reference: 16595 Logged by: Jesse Kinkead Email address: jesse@falkon.ai PostgreSQL version: 11.6 Operating system: Linux Description: We've seen this on a few different servers running Postgres 11.6. The table in question has a JSONB column with a GIN index, defined as: "index_name_idx" gin (jsonb_column_name jsonb_path_ops, integer_column, timestamp_with_time_zone_column) Under load (especially writes followed immediately by reads), we occasionally see reads failing an internal exception (error code XX000) with the message "lost saved point in index". This seems to come from this source file: https://doxygen.postgresql.org/ginget_8c_source.html To further complicate matters, this server is using TimescaleDB (https://www.timescale.com/), and has this table configured as a hypertable (https://docs.timescale.com/latest/using-timescaledb/hypertables), which I believe means it's actually multiple tables masquerading as a single table. The errors are quite frequent when running with slow CPUs / disks, but more rare when running with more resources.
Commits
-
Fix code for re-finding scan position in a multicolumn GIN index.
- ff3c16d1e751 12.5 landed
- fabd2f9c9443 9.5.24 landed
- 1df14a566942 13.0 landed
- 11ecf4bd2882 11.10 landed
- 10564ee02ca3 14.0 landed
- 0dfec43c829a 9.6.20 landed
- 0d3ad65404c0 10.15 landed