BUG #16595: Reads fail with "lost saved point in index" error after writes

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: jesse(at)falkon(dot)ai
Subject: BUG #16595: Reads fail with "lost saved point in index" error after writes
Date: 2020-08-27 03:40:47
Message-ID: 16595-633118be8eef9ce2@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 16595
Logged by: Jesse Kinkead
Email address: jesse(at)falkon(dot)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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2020-08-27 04:10:25 BUG #16596: Windows
Previous Message Michael Paquier 2020-08-27 01:00:54 Re: BUG #16594: DROP INDEX CONCURRENTLY fails on partitioned table with a non helpful error message.