On Sat, Aug 25, 2018 at 1:15 AM Tom Lane wrote:
> Actually, I think the main point is given that we've somehow got into
> a situation like that, how do we get out again?
>
I and Alvaro discussed this off-list a bit and we came up with couple of
ideas.
1. Reserve some buffers in the shared buffe
Andres Freund writes:
> The point is not where you can cause trouble by explicitly deleting
> files - that'll always screw up things - but where you encountered this
> in the wild.
Actually, I think the main point is given that we've somehow got into
a situation like that, how do we get out again
Alvaro Herrera writes:
> On 2018-Aug-25, Pavan Deolasee wrote:
>> Now of course, the file is really missing. But the user was quite surprised
>> that they couldn't connect to any database, even though mishap happened to
>> a user table in one of their reporting databases.
> Hmm, that sounds like
Hi,
On 2018-08-25 00:56:17 +0530, Pavan Deolasee wrote:
> > Oh, and what PG version are we talking about?
> >
>
> I think this is reproducible on all versions I have tested so far,
> including master.
The point is not where you can cause trouble by explicitly deleting
files - that'll always scre
On 2018-Aug-25, Pavan Deolasee wrote:
> The errors were simply about about the missing file. See attached
> reproduction script that I created while studying this complaint. It will
> throw errors such as:
>
> psql: FATAL: could not open file "base/12669/16387": No such file or
> directory
> CON
On Sat, Aug 25, 2018 at 12:16 AM Tom Lane wrote:
> Pavan Deolasee writes:
> > 1. The user soon found out that they can no longer connect to any
> database
> > in the cluster. Not just the one to which the affected table belonged,
> but
> > no other database in the cluster. The affected table is
Pavan Deolasee writes:
> 1. The user soon found out that they can no longer connect to any database
> in the cluster. Not just the one to which the affected table belonged, but
> no other database in the cluster. The affected table is a regular user
> table (actually a toast table).
Please define
