Date: Mon, 4 Feb 2019 10:07:09 +0900
From: Michael Paquier <michael@paquier.xyz>
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: PegoraroF10 <marcos@f10.com.br>, pgsql-general@postgresql.org
Subject: Re: Server goes to Recovery Mode when run a SQL
Message-ID: <20190204010709.GC1881@paquier.xyz>
References: <1549209182255-0.post@n3.nabble.com>
 <37bc715f-12e2-84ac-6492-88d7b6306777@aklaver.com>
 <1549211574297-0.post@n3.nabble.com>
 <cfcb3858-d169-652c-71a7-5d77f295085a@aklaver.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="DIOMP1UsTsWJauNi"
Content-Disposition: inline
In-Reply-To: <cfcb3858-d169-652c-71a7-5d77f295085a@aklaver.com>
Precedence: bulk


--DIOMP1UsTsWJauNi
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Sun, Feb 03, 2019 at 10:05:46AM -0800, Adrian Klaver wrote:
> On 2/3/19 8:32 AM, PegoraroF10 wrote:
>> I have a complex query which puts my server in recovery mode every time I
>> run it.
>> I don=B4t need to say that recovery mode is a situation you don=B4t want=
 your
>> server goes to.

Do you mean that your server crashes after running a SQL query?  That
could be a bug.

> Well actually that is how standby_servers run:
>=20
> https://www.postgresql.org/docs/11/warm-standby.html
>=20
> "... while each standby server operates in continuous recovery mode, read=
ing
> the WAL files from the primary."
>=20
> Is this server a standby?

If you could post a self-contained test case, that would be really
helpful to see if there is an actual bug.  You can obfuscate the
schema if need be, as long as the problem can be reproduced that's
fine.
--
Michael

--DIOMP1UsTsWJauNi
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlxXkD0ACgkQnvQgOdby
QH0qhQ//f5PqWMBbnwd5ebCS9MobKiCZwc1vlBLloZV7+dV1cuMLsTflJgc/0ZWB
XGNFfeZTbVb2nHnqW6V+FCbxSovVZBZoTLrip1wsdll34ThNLEV43ixJdtkllfy1
E2U7fA6TnXzxcgodmk8u6RHZ95qHR7irGKPj5KXvmLubiNwDGX4RW3Q+3DPwbOrK
P5uIBy68uVPEPZdH0UYC8tG6pqZVAwigzhEV+iWp6ACANrfnVxjwS9fJhi0+rgDc
9/ASwr9vj+FpOdPq6FfH711yp0tjEr5sxWZHwqKd66OtAiIl/+z74hXlEh4UwDbH
5/K2qJ2ZexzuLaI9n9TJJFL+IJLSKVYetZe5AJy7mQRxSo7Z08Ymrdmfh0eYwqpu
ori8vKpnSetrIegBi/PGRuRvQtyGl4eQ92lBAurNbfaqXLdF1BGFKdahAsbPkyOW
tSSJrBJfiBkuLJ39A2pfZxWqwgmf9+S0YgO0IqykAWb/bQmfCMu/XoItrPaHWqU7
ZSSI6gLzTEQq2oyjkvBLVh9ydp45dxuTq8GYqJPa/J+042ViCGlXr97cLlcd2aHX
WNg0OkF2t+x/Hh0hPBofZUL1wbkTFJS2Il9cE8fwU+o1rDT4/Oe+Q454WpPKQrZl
3fTsjR6VFKgKVUAqknHTThpjLNxNJaIUEtquPXtdjIvltIWD7TM=
=xCQH
-----END PGP SIGNATURE-----

--DIOMP1UsTsWJauNi--