pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: jesse@falkon.ai
Subject: BUG #16595: Reads fail with "lost saved point in index" error after writes
Date: Thu, 27 Aug 2020 03:40:47 +0000
Message-ID: <16595-633118be8eef9ce2@postgresql.org> (raw)

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.



view thread (5+ messages)  latest in thread

Message-ID: <16595-633118be8eef9ce2@postgresql.org>
Permalink:  ../16595-633118be8eef9ce2@postgresql.org/
Also on:    postgresql.org/message-id/16595-633118be8eef9ce2@postgresql.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, jesse@falkon.ai
  Subject: Re: BUG #16595: Reads fail with "lost saved point in index" error after writes
  In-Reply-To: <16595-633118be8eef9ce2@postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox