From: Adrian Klaver <adrian.klaver@aklaver.com>
To: PegoraroF10 <marcos@f10.com.br>
To: pgsql-general@postgresql.org
Subject: Re: Server goes to Recovery Mode when run a SQL
Date: Mon, 4 Feb 2019 07:53:13 -0800
Message-ID: <d1b0c06b-1aba-5293-8893-70771682f292@aklaver.com> (raw)
In-Reply-To: <1549294429092-0.post@n3.nabble.com>
References: <1549209182255-0.post@n3.nabble.com>
<37bc715f-12e2-84ac-6492-88d7b6306777@aklaver.com>
<1549211574297-0.post@n3.nabble.com>
<0689b9bcac79f7f5e76ed69dd4baea012d6a3d33.camel@gmail.com>
<1549278827534-0.post@n3.nabble.com>
<7719c8bd-2e98-8a67-d01d-3b111e8d669c@aklaver.com>
<1549294429092-0.post@n3.nabble.com>
On 2/4/19 7:33 AM, PegoraroF10 wrote:
> About replication ... Logical Replication with CREATE
> PUBLICATION/SUBSCRIPTION.
>
> Yes, some DDL commands were ran on that server but none of them were related
> with that select.
> Let me explain better. We have a single server with a single database on it.
> Each customer has its own schema and connects to it to work exclusively on
> that schema. So, sometimes we add some customer or change something on an
> old one. But this DDL change we could ran is not related with that schema we
> are talking. Schemas can have different structures but that schema which
> puts my server on recovery mode was not changed.
>
> Maybe something related happened some days ago. When we start a new customer
> we add a schema, put all their tables on it and it´s ok. Our server has
> today 90 schemas and each schema has 100 tables, resulting in 9000 tables.
> Some days ago we added 5 new customers on same day, so we added 500 tables.
> Then, when we did that some selects on system tables were very very slow and
> that was only solved when we did a REINDEX DATABASE. Even REINDEX SYSTEM did
> not solve. Is this problem related with recovery mode of my server ?
Unsure at the moment as there is not enough information to come to any
conclusions.
Questions:
1) Do you still have the logs from when you added the 5 new schema and
do they show any warnings, errors, etc at or after that time?
2) Are you seeing any warnings, errors, etc in the logs currently?
3) Is the replication for all tables?
4) The exact same query works without a problem on the replicated
server, correct?
5) In the Postgres server that is being replicated to are there any log
entries that might be of concern?
6) Is it possible to get a stack trace of the crash?:
https://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Linux/BSD>
>
>
> --
> Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
>
>
--
Adrian Klaver
adrian.klaver@aklaver.com
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-general@postgresql.org
Cc: adrian.klaver@aklaver.com, marcos@f10.com.br
Subject: Re: Server goes to Recovery Mode when run a SQL
In-Reply-To: <d1b0c06b-1aba-5293-8893-70771682f292@aklaver.com>
* 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