pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedterminating connection because of crash of another server process
25+ messages / 7 participants
[nested] [flat]
* terminating connection because of crash of another server process
@ 2008-02-13 20:48 Leticia Larrosa <leticia@tesla.cujae.edu.cu>
2008-02-13 21:41 ` Re: terminating connection because of crash of another server process Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 1 reply; 25+ messages in thread
From: Leticia Larrosa @ 2008-02-13 20:48 UTC (permalink / raw)
To: pgsql-admin
Hello
I have a postgres database version 8.1.11, in an Ubuntu Server 6.10.
Some days before, I have a hardware failure in my server, and after recover
the database I get some problems with tables and I had to REINDEX some of
its.
But now, doing any actions in the database server (for example: SELECT *
from my_table), I continue getting the follow error:
"""
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.
"""
Any help, to solve this or an idea about anything I must check, will be
appreciated.
The log of my server shows the follow messages over and over:
LOG: database system was interrupted at 2008-02-13 15:37:00 EST
LOG: checkpoint record is at 1C/837496A0
LOG: redo record is at 1C/837496A0; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 1596704648; next OID: 2939703
LOG: next MultiXactId: 1; next MultiXactOffset: 0
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: record with zero length at 1C/837496E4
LOG: redo is not required
LOG: database system is ready
LOG: transaction ID wrap limit is 2147484146, limited by database
"postgres"
LOG: server process (PID 9747) was terminated by signal 11
LOG: terminating any other active server processes
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
LOG: all server processes terminated; reinitializing
LOG: database system was interrupted at 2008-02-13 15:37:00 EST
LOG: checkpoint record is at 1C/837496E4
LOG: redo record is at 1C/837496E4; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 1596704648; next OID: 2939703
LOG: next MultiXactId: 1; next MultiXactOffset: 0
LOG: database system was not properly shut down; automatic recovery in
progress
FATAL: the database system is starting up
LOG: record with zero length at 1C/83749728
LOG: redo is not required
LOG: database system is ready
LOG: transaction ID wrap limit is 2147484146, limited by database
"postgres"
FATAL: the database system is starting up
FATAL: the database system is starting up
FATAL: the database system is starting up
FATAL: the database system is starting up
FATAL: the database system is starting up
LOG: server process (PID 9793) was terminated by signal 11
LOG: terminating any other active server processes
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
LOG: all server processes terminated; reinitializing
LOG: database system was interrupted at 2008-02-13 15:37:04 EST
LOG: checkpoint record is at 1C/83749728
LOG: redo record is at 1C/83749728; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 1596704648; next OID: 2939703
LOG: next MultiXactId: 1; next MultiXactOffset: 0
LOG: database system was not properly shut down; automatic recovery in
progress
FATAL: the database system is starting up
FATAL: the database system is starting up
FATAL: the database system is starting up
LOG: record with zero length at 1C/8374976C
LOG: redo is not required
LOG: database system is ready
LOG: transaction ID wrap limit is 2147484146, limited by database
"postgres"
Thanks in advanced.
Leticia Larrosa
__________________________________________
Participe en Universidad 2008.
11 al 15 de febrero del 2008.
Palacio de las Convenciones, Ciudad de la Habana, Cuba
http://www.universidad2008.cu
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: terminating connection because of crash of another server process
2008-02-13 20:48 terminating connection because of crash of another server process Leticia Larrosa <leticia@tesla.cujae.edu.cu>
@ 2008-02-13 21:41 ` Scott Marlowe <scott.marlowe@gmail.com>
2008-02-15 17:29 ` Re: terminating connection because of crash of another server process Fabricio <fabrixio1@hotmail.com>
2008-02-15 18:22 ` Re: terminating connection because of crash of another server process Leticia Larrosa <leticia@tesla.cujae.edu.cu>
0 siblings, 2 replies; 25+ messages in thread
From: Scott Marlowe @ 2008-02-13 21:41 UTC (permalink / raw)
To: Leticia Larrosa <leticia@tesla.cujae.edu.cu>; +Cc: pgsql-admin
On Feb 13, 2008 2:48 PM, Leticia Larrosa <leticia@tesla.cujae.edu.cu> wrote:
>
> Hello
>
> I have a postgres database version 8.1.11, in an Ubuntu Server 6.10.
>
> Some days before, I have a hardware failure in my server, and after recover
> the database I get some problems with tables and I had to REINDEX some of
> its.
> But now, doing any actions in the database server (for example: SELECT *
> from my_table), I continue getting the follow error:
>
> """
> WARNING: terminating connection because of crash of another server process
> DETAIL: The postmaster has commanded this server process to roll back the
> current transaction and exit, because another server process exited
> abnormally and possibly corrupted shared memory.
> HINT: In a moment you should be able to reconnect to the database and
> repeat your command.
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
> The connection to the server was lost. Attempting reset: Succeeded.
> """
>
> Any help, to solve this or an idea about anything I must check, will be
> appreciated.
>
> The log of my server shows the follow messages over and over:
>
> LOG: database system was interrupted at 2008-02-13 15:37:00 EST
> LOG: checkpoint record is at 1C/837496A0
> LOG: redo record is at 1C/837496A0; undo record is at 0/0; shutdown TRUE
> LOG: next transaction ID: 1596704648; next OID: 2939703
> LOG: next MultiXactId: 1; next MultiXactOffset: 0
> LOG: database system was not properly shut down; automatic recovery in
> progress
> LOG: record with zero length at 1C/837496E4
> LOG: redo is not required
> LOG: database system is ready
> LOG: transaction ID wrap limit is 2147484146, limited by database
> "postgres"
> LOG: server process (PID 9747) was terminated by signal 11
> LOG: terminating any other active server processes
Sig 11 is bad, mkay? basically it means the postgres process is
crashing. It could be crashing because of a corrupted / buggy
executable, or bad hardware. Do you have another machine you trust to
move your pgsql database to? Because I wouldn't trust the one it's
on right now until you can pull it from service, confirm the pg
binaries aren't corrupted, and test your hardware.
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: terminating connection because of crash of another server process
2008-02-13 20:48 terminating connection because of crash of another server process Leticia Larrosa <leticia@tesla.cujae.edu.cu>
2008-02-13 21:41 ` Re: terminating connection because of crash of another server process Scott Marlowe <scott.marlowe@gmail.com>
@ 2008-02-15 17:29 ` Fabricio <fabrixio1@hotmail.com>
1 sibling, 0 replies; 25+ messages in thread
From: Fabricio @ 2008-02-15 17:29 UTC (permalink / raw)
To: pgsql-admin
the command dmesg show some message about memory or hard disc?
Do you have vm.overcommit_memory=2 in sysctl.conf?
> Date: Wed, 13 Feb 2008 15:41:10 -0600> From: scott.marlowe@gmail.com> To: leticia@tesla.cujae.edu.cu> Subject: Re: [ADMIN] terminating connection because of crash of another server process> CC: pgsql-admin@postgresql.org> > On Feb 13, 2008 2:48 PM, Leticia Larrosa <leticia@tesla.cujae.edu.cu> wrote:> >> > Hello> >> > I have a postgres database version 8.1.11, in an Ubuntu Server 6.10.> >> > Some days before, I have a hardware failure in my server, and after recover> > the database I get some problems with tables and I had to REINDEX some of> > its.> > But now, doing any actions in the database server (for example: SELECT *> > from my_table), I continue getting the follow error:> >> > """> > WARNING: terminating connection because of crash of another server process> > DETAIL: The postmaster has commanded this server process to roll back the> > current transaction and exit, because another server process exited> > abnormally and possibly corrupted shared memory.> > HINT: In a moment you should be able to reconnect to the database and> > repeat your command.> > server closed the connection unexpectedly> > This probably means the server terminated abnormally> > before or while processing the request.> > The connection to the server was lost. Attempting reset: Succeeded.> > """> >> > Any help, to solve this or an idea about anything I must check, will be> > appreciated.> >> > The log of my server shows the follow messages over and over:> >> > LOG: database system was interrupted at 2008-02-13 15:37:00 EST> > LOG: checkpoint record is at 1C/837496A0> > LOG: redo record is at 1C/837496A0; undo record is at 0/0; shutdown TRUE> > LOG: next transaction ID: 1596704648; next OID: 2939703> > LOG: next MultiXactId: 1; next MultiXactOffset: 0> > LOG: database system was not properly shut down; automatic recovery in> > progress> > LOG: record with zero length at 1C/837496E4> > LOG: redo is not required> > LOG: database system is ready> > LOG: transaction ID wrap limit is 2147484146, limited by database> > "postgres"> > LOG: server process (PID 9747) was terminated by signal 11> > LOG: terminating any other active server processes> > Sig 11 is bad, mkay? basically it means the postgres process is> crashing. It could be crashing because of a corrupted / buggy> executable, or bad hardware. Do you have another machine you trust to> move your pgsql database to? Because I wouldn't trust the one it's> on right now until you can pull it from service, confirm the pg> binaries aren't corrupted, and test your hardware.> > ---------------------------(end of broadcast)---------------------------> TIP 7: You can help support the PostgreSQL project by donating at> > http://www.postgresql.org/about/donate
_________________________________________________________________
¡Súper premios en nanometrajes subiendo tu video!
http://cine.prodigymsn.com/nanometraje=
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: terminating connection because of crash of another server process
2008-02-13 20:48 terminating connection because of crash of another server process Leticia Larrosa <leticia@tesla.cujae.edu.cu>
2008-02-13 21:41 ` Re: terminating connection because of crash of another server process Scott Marlowe <scott.marlowe@gmail.com>
@ 2008-02-15 18:22 ` Leticia Larrosa <leticia@tesla.cujae.edu.cu>
1 sibling, 0 replies; 25+ messages in thread
From: Leticia Larrosa @ 2008-02-15 18:22 UTC (permalink / raw)
To: 'Scott Marlowe' <scott.marlowe@gmail.com>; +Cc: pgsql-admin
Hello,
Thanks Scott.
I dump my database, and move it to other machine, and all works fine now.
Regards
Leticia Larrosa
-----Original Message-----
From: Scott Marlowe [mailto:scott.marlowe@gmail.com]
Sent: Wednesday, February 13, 2008 4:41 PM
To: Leticia Larrosa
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] terminating connection because of crash of another
server process
On Feb 13, 2008 2:48 PM, Leticia Larrosa <leticia@tesla.cujae.edu.cu> wrote:
>
> Hello
>
> I have a postgres database version 8.1.11, in an Ubuntu Server 6.10.
>
> Some days before, I have a hardware failure in my server, and after
recover
> the database I get some problems with tables and I had to REINDEX some of
> its.
> But now, doing any actions in the database server (for example: SELECT *
> from my_table), I continue getting the follow error:
>
> """
> WARNING: terminating connection because of crash of another server
process
> DETAIL: The postmaster has commanded this server process to roll back the
> current transaction and exit, because another server process exited
> abnormally and possibly corrupted shared memory.
> HINT: In a moment you should be able to reconnect to the database and
> repeat your command.
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
> The connection to the server was lost. Attempting reset: Succeeded.
> """
>
> Any help, to solve this or an idea about anything I must check, will be
> appreciated.
>
> The log of my server shows the follow messages over and over:
>
> LOG: database system was interrupted at 2008-02-13 15:37:00 EST
> LOG: checkpoint record is at 1C/837496A0
> LOG: redo record is at 1C/837496A0; undo record is at 0/0; shutdown TRUE
> LOG: next transaction ID: 1596704648; next OID: 2939703
> LOG: next MultiXactId: 1; next MultiXactOffset: 0
> LOG: database system was not properly shut down; automatic recovery in
> progress
> LOG: record with zero length at 1C/837496E4
> LOG: redo is not required
> LOG: database system is ready
> LOG: transaction ID wrap limit is 2147484146, limited by database
> "postgres"
> LOG: server process (PID 9747) was terminated by signal 11
> LOG: terminating any other active server processes
Sig 11 is bad, mkay? basically it means the postgres process is
crashing. It could be crashing because of a corrupted / buggy
executable, or bad hardware. Do you have another machine you trust to
move your pgsql database to? Because I wouldn't trust the one it's
on right now until you can pull it from service, confirm the pg
binaries aren't corrupted, and test your hardware.
__________ NOD32 2872 (20080213) Information __________
This message was checked by NOD32 antivirus system.
http://www.eset.com
__________________________________________
Participe en Universidad 2008.
11 al 15 de febrero del 2008.
Palacio de las Convenciones, Ciudad de la Habana, Cuba
http://www.universidad2008.cu
^ permalink raw reply [nested|flat] 25+ messages in thread
* Terminating connection because of crash of another server process
@ 2023-09-27 13:25 Deo Felix <deofelix9@gmail.com>
2023-09-27 13:39 ` Re: Terminating connection because of crash of another server process Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 1 reply; 25+ messages in thread
From: Deo Felix @ 2023-09-27 13:25 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Hello,
Please assist Im getting the error below in Postgresql 13 database
WARNING: terminating connection because of crash of another server process
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: Terminating connection because of crash of another server process
2023-09-27 13:25 Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
@ 2023-09-27 13:39 ` Laurenz Albe <laurenz.albe@cybertec.at>
2023-09-27 13:50 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 13:57 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
0 siblings, 2 replies; 25+ messages in thread
From: Laurenz Albe @ 2023-09-27 13:39 UTC (permalink / raw)
To: Deo Felix <deofelix9@gmail.com>; pgsql-admin@lists.postgresql.org
On Wed, 2023-09-27 at 16:25 +0300, Deo Felix wrote:
> Please assist Im getting the error below in Postgresql 13 database
>
> WARNING: terminating connection because of crash of another server process
The trick is not to have any crashes.
Look at the PostgreSQL log to determine the cause of the crash and
see that it does not happen again. A well configured PostgreSQL
on good hardware should not crash.
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: Terminating connection because of crash of another server process
2023-09-27 13:25 Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 13:39 ` Re: Terminating connection because of crash of another server process Laurenz Albe <laurenz.albe@cybertec.at>
@ 2023-09-27 13:50 ` Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 13:58 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
1 sibling, 1 reply; 25+ messages in thread
From: Scott Ribe @ 2023-09-27 13:50 UTC (permalink / raw)
To: Deo Felix <deofelix9@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
I've had two rounds of that problem over the years. Both were caused by 3rd-party extensions to PostgreSQL.
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: Terminating connection because of crash of another server process
2023-09-27 13:25 Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 13:39 ` Re: Terminating connection because of crash of another server process Laurenz Albe <laurenz.albe@cybertec.at>
2023-09-27 13:50 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
@ 2023-09-27 13:58 ` Deo Felix <deofelix9@gmail.com>
2023-09-27 14:18 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 17:16 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
0 siblings, 2 replies; 25+ messages in thread
From: Deo Felix @ 2023-09-27 13:58 UTC (permalink / raw)
To: Scott Ribe <scott_ribe@elevated-dev.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
What extension please can you mention
Sent from Outlook for Android<https://aka.ms/AAb9ysg;
________________________________
From: Scott Ribe <scott_ribe@elevated-dev.com>
Sent: Wednesday, September 27, 2023 4:50:27 PM
To: Deo Felix <deofelix9@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Terminating connection because of crash of another server process
I've had two rounds of that problem over the years. Both were caused by 3rd-party extensions to PostgreSQL.
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: Terminating connection because of crash of another server process
2023-09-27 13:25 Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 13:39 ` Re: Terminating connection because of crash of another server process Laurenz Albe <laurenz.albe@cybertec.at>
2023-09-27 13:50 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 13:58 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
@ 2023-09-27 14:18 ` Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 19:07 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
1 sibling, 1 reply; 25+ messages in thread
From: Scott Ribe @ 2023-09-27 14:18 UTC (permalink / raw)
To: Deo Felix <deofelix9@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
> On Sep 27, 2023, at 7:58 AM, Deo Felix <deofelix9@gmail.com> wrote:
>
> What extension please can you mention
Both were years ago and may well have been fixed by now. You need to audit what (whether) 3rd-party extensions you have, and how necessary they are.
That said: POWA and TimescaleDB.
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: Terminating connection because of crash of another server process
2023-09-27 13:25 Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 13:39 ` Re: Terminating connection because of crash of another server process Laurenz Albe <laurenz.albe@cybertec.at>
2023-09-27 13:50 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 13:58 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 14:18 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
@ 2023-09-27 19:07 ` Deo Felix <deofelix9@gmail.com>
2023-09-27 19:13 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
0 siblings, 1 reply; 25+ messages in thread
From: Deo Felix @ 2023-09-27 19:07 UTC (permalink / raw)
To: Scott Ribe <scott_ribe@elevated-dev.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Okay thank you, I have not installed the mentioned extensions
On Wed, 27 Sept 2023 at 17:19, Scott Ribe <scott_ribe@elevated-dev.com>
wrote:
> > On Sep 27, 2023, at 7:58 AM, Deo Felix <deofelix9@gmail.com> wrote:
> >
> > What extension please can you mention
>
> Both were years ago and may well have been fixed by now. You need to audit
> what (whether) 3rd-party extensions you have, and how necessary they are.
>
> That said: POWA and TimescaleDB.
>
>
>
>
>
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: Terminating connection because of crash of another server process
2023-09-27 13:25 Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 13:39 ` Re: Terminating connection because of crash of another server process Laurenz Albe <laurenz.albe@cybertec.at>
2023-09-27 13:50 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 13:58 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 14:18 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 19:07 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
@ 2023-09-27 19:13 ` Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 19:15 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
0 siblings, 1 reply; 25+ messages in thread
From: Scott Ribe @ 2023-09-27 19:13 UTC (permalink / raw)
To: Deo Felix <deofelix9@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
> On Sep 27, 2023, at 1:07 PM, Deo Felix <deofelix9@gmail.com> wrote:
>
> Okay thank you, I have not installed the mentioned extensions
That's not the point. The point is that buggy extensions are one cause of this kind of instability, and you need to audit for *any* 3rd-party extensions in *YOUR* installation.
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: Terminating connection because of crash of another server process
2023-09-27 13:25 Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 13:39 ` Re: Terminating connection because of crash of another server process Laurenz Albe <laurenz.albe@cybertec.at>
2023-09-27 13:50 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 13:58 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 14:18 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 19:07 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 19:13 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
@ 2023-09-27 19:15 ` Deo Felix <deofelix9@gmail.com>
2023-09-28 05:51 ` Re: Terminating connection because of crash of another server process Deepak Goel <deicool@gmail.com>
0 siblings, 1 reply; 25+ messages in thread
From: Deo Felix @ 2023-09-27 19:15 UTC (permalink / raw)
To: Scott Ribe <scott_ribe@elevated-dev.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Okay, basically I have installed this extension
pgaudit, repmgr, pgagent And I will audit them as you have adviced
On Wed, 27 Sept 2023 at 22:13, Scott Ribe <scott_ribe@elevated-dev.com>
wrote:
> > On Sep 27, 2023, at 1:07 PM, Deo Felix <deofelix9@gmail.com> wrote:
> >
> > Okay thank you, I have not installed the mentioned extensions
>
> That's not the point. The point is that buggy extensions are one cause of
> this kind of instability, and you need to audit for *any* 3rd-party
> extensions in *YOUR* installation.
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: Terminating connection because of crash of another server process
2023-09-27 13:25 Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 13:39 ` Re: Terminating connection because of crash of another server process Laurenz Albe <laurenz.albe@cybertec.at>
2023-09-27 13:50 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 13:58 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 14:18 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 19:07 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 19:13 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 19:15 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
@ 2023-09-28 05:51 ` Deepak Goel <deicool@gmail.com>
2023-09-28 11:22 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
0 siblings, 1 reply; 25+ messages in thread
From: Deepak Goel @ 2023-09-28 05:51 UTC (permalink / raw)
To: Deo Felix <deofelix9@gmail.com>; +Cc: Scott Ribe <scott_ribe@elevated-dev.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
The error posted by you ( WARNING: terminating connection because of crash
of another server process) is at a very high level. Can you drill down for
a detailed error?
Deepak
"The greatness of a nation can be judged by the way its animals are treated
- Mahatma Gandhi"
+91 73500 12833
deicool@gmail.com
Facebook: https://www.facebook.com/deicool
LinkedIn: www.linkedin.com/in/deicool
"Plant a Tree, Go Green"
Make In India : http://www.makeinindia.com/home
On Thu, Sep 28, 2023 at 8:13 AM Deo Felix <deofelix9@gmail.com> wrote:
> Okay, basically I have installed this extension
> pgaudit, repmgr, pgagent And I will audit them as you have adviced
>
> On Wed, 27 Sept 2023 at 22:13, Scott Ribe <scott_ribe@elevated-dev.com>
> wrote:
>
>> > On Sep 27, 2023, at 1:07 PM, Deo Felix <deofelix9@gmail.com> wrote:
>> >
>> > Okay thank you, I have not installed the mentioned extensions
>>
>> That's not the point. The point is that buggy extensions are one cause of
>> this kind of instability, and you need to audit for *any* 3rd-party
>> extensions in *YOUR* installation.
>
>
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: Terminating connection because of crash of another server process
2023-09-27 13:25 Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 13:39 ` Re: Terminating connection because of crash of another server process Laurenz Albe <laurenz.albe@cybertec.at>
2023-09-27 13:50 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 13:58 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 14:18 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 19:07 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 19:13 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 19:15 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-28 05:51 ` Re: Terminating connection because of crash of another server process Deepak Goel <deicool@gmail.com>
@ 2023-09-28 11:22 ` Deo Felix <deofelix9@gmail.com>
2023-09-28 11:29 ` Re: Terminating connection because of crash of another server process Deepak Goel <deicool@gmail.com>
0 siblings, 1 reply; 25+ messages in thread
From: Deo Felix @ 2023-09-28 11:22 UTC (permalink / raw)
To: Deepak Goel <deicool@gmail.com>; +Cc: Scott Ribe <scott_ribe@elevated-dev.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
The problem occurred when refreshing materialized views, out of shared
memory error occur
On Thu, 28 Sept 2023 at 08:51, Deepak Goel <deicool@gmail.com> wrote:
> The error posted by you ( WARNING: terminating connection because of
> crash of another server process) is at a very high level. Can you
> drill down for a detailed error?
>
>
> Deepak
> "The greatness of a nation can be judged by the way its animals are
> treated - Mahatma Gandhi"
>
> +91 73500 12833
> deicool@gmail.com
>
> Facebook: https://www.facebook.com/deicool
> LinkedIn: www.linkedin.com/in/deicool
>
> "Plant a Tree, Go Green"
>
> Make In India : http://www.makeinindia.com/home
>
>
> On Thu, Sep 28, 2023 at 8:13 AM Deo Felix <deofelix9@gmail.com> wrote:
>
>> Okay, basically I have installed this extension
>> pgaudit, repmgr, pgagent And I will audit them as you have adviced
>>
>> On Wed, 27 Sept 2023 at 22:13, Scott Ribe <scott_ribe@elevated-dev.com>
>> wrote:
>>
>>> > On Sep 27, 2023, at 1:07 PM, Deo Felix <deofelix9@gmail.com> wrote:
>>> >
>>> > Okay thank you, I have not installed the mentioned extensions
>>>
>>> That's not the point. The point is that buggy extensions are one cause
>>> of this kind of instability, and you need to audit for *any* 3rd-party
>>> extensions in *YOUR* installation.
>>
>>
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: Terminating connection because of crash of another server process
2023-09-27 13:25 Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 13:39 ` Re: Terminating connection because of crash of another server process Laurenz Albe <laurenz.albe@cybertec.at>
2023-09-27 13:50 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 13:58 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 14:18 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 19:07 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 19:13 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 19:15 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-28 05:51 ` Re: Terminating connection because of crash of another server process Deepak Goel <deicool@gmail.com>
2023-09-28 11:22 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
@ 2023-09-28 11:29 ` Deepak Goel <deicool@gmail.com>
2023-09-29 08:21 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
0 siblings, 1 reply; 25+ messages in thread
From: Deepak Goel @ 2023-09-28 11:29 UTC (permalink / raw)
To: Deo Felix <deofelix9@gmail.com>; +Cc: Scott Ribe <scott_ribe@elevated-dev.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
Please print the "out of shared memory error" or you need to make a
provision for printing detailed error.
Deepak
"The greatness of a nation can be judged by the way its animals are treated
- Mahatma Gandhi"
+91 73500 12833
deicool@gmail.com
Facebook: https://www.facebook.com/deicool
LinkedIn: www.linkedin.com/in/deicool
"Plant a Tree, Go Green"
Make In India : http://www.makeinindia.com/home
On Thu, Sep 28, 2023 at 4:55 PM Deo Felix <deofelix9@gmail.com> wrote:
> The problem occurred when refreshing materialized views, out of shared
> memory error occur
>
> On Thu, 28 Sept 2023 at 08:51, Deepak Goel <deicool@gmail.com> wrote:
>
>> The error posted by you ( WARNING: terminating connection because of
>> crash of another server process) is at a very high level. Can you
>> drill down for a detailed error?
>>
>>
>> Deepak
>> "The greatness of a nation can be judged by the way its animals are
>> treated - Mahatma Gandhi"
>>
>> +91 73500 12833
>> deicool@gmail.com
>>
>> Facebook: https://www.facebook.com/deicool
>> LinkedIn: www.linkedin.com/in/deicool
>>
>> "Plant a Tree, Go Green"
>>
>> Make In India : http://www.makeinindia.com/home
>>
>>
>> On Thu, Sep 28, 2023 at 8:13 AM Deo Felix <deofelix9@gmail.com> wrote:
>>
>>> Okay, basically I have installed this extension
>>> pgaudit, repmgr, pgagent And I will audit them as you have adviced
>>>
>>> On Wed, 27 Sept 2023 at 22:13, Scott Ribe <scott_ribe@elevated-dev.com>
>>> wrote:
>>>
>>>> > On Sep 27, 2023, at 1:07 PM, Deo Felix <deofelix9@gmail.com> wrote:
>>>> >
>>>> > Okay thank you, I have not installed the mentioned extensions
>>>>
>>>> That's not the point. The point is that buggy extensions are one cause
>>>> of this kind of instability, and you need to audit for *any* 3rd-party
>>>> extensions in *YOUR* installation.
>>>
>>>
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: Terminating connection because of crash of another server process
2023-09-27 13:25 Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 13:39 ` Re: Terminating connection because of crash of another server process Laurenz Albe <laurenz.albe@cybertec.at>
2023-09-27 13:50 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 13:58 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 14:18 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 19:07 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 19:13 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 19:15 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-28 05:51 ` Re: Terminating connection because of crash of another server process Deepak Goel <deicool@gmail.com>
2023-09-28 11:22 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-28 11:29 ` Re: Terminating connection because of crash of another server process Deepak Goel <deicool@gmail.com>
@ 2023-09-29 08:21 ` Deo Felix <deofelix9@gmail.com>
2023-09-29 08:41 ` Re: Terminating connection because of crash of another server process Deepak Goel <deicool@gmail.com>
2023-09-29 09:27 ` Re: Terminating connection because of crash of another server process Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 2 replies; 25+ messages in thread
From: Deo Felix @ 2023-09-29 08:21 UTC (permalink / raw)
To: Deepak Goel <deicool@gmail.com>; +Cc: Scott Ribe <scott_ribe@elevated-dev.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
Please find the screenshot of error from the log file [image:
postgresqlerror.png]
On Thu, 28 Sept 2023 at 14:29, Deepak Goel <deicool@gmail.com> wrote:
> Please print the "out of shared memory error" or you need to make a
> provision for printing detailed error.
>
>
> Deepak
> "The greatness of a nation can be judged by the way its animals are
> treated - Mahatma Gandhi"
>
> +91 73500 12833
> deicool@gmail.com
>
> Facebook: https://www.facebook.com/deicool
> LinkedIn: www.linkedin.com/in/deicool
>
> "Plant a Tree, Go Green"
>
> Make In India : http://www.makeinindia.com/home
>
>
> On Thu, Sep 28, 2023 at 4:55 PM Deo Felix <deofelix9@gmail.com> wrote:
>
>> The problem occurred when refreshing materialized views, out of shared
>> memory error occur
>>
>> On Thu, 28 Sept 2023 at 08:51, Deepak Goel <deicool@gmail.com> wrote:
>>
>>> The error posted by you ( WARNING: terminating connection because of
>>> crash of another server process) is at a very high level. Can you
>>> drill down for a detailed error?
>>>
>>>
>>> Deepak
>>> "The greatness of a nation can be judged by the way its animals are
>>> treated - Mahatma Gandhi"
>>>
>>> +91 73500 12833
>>> deicool@gmail.com
>>>
>>> Facebook: https://www.facebook.com/deicool
>>> LinkedIn: www.linkedin.com/in/deicool
>>>
>>> "Plant a Tree, Go Green"
>>>
>>> Make In India : http://www.makeinindia.com/home
>>>
>>>
>>> On Thu, Sep 28, 2023 at 8:13 AM Deo Felix <deofelix9@gmail.com> wrote:
>>>
>>>> Okay, basically I have installed this extension
>>>> pgaudit, repmgr, pgagent And I will audit them as you have adviced
>>>>
>>>> On Wed, 27 Sept 2023 at 22:13, Scott Ribe <scott_ribe@elevated-dev.com>
>>>> wrote:
>>>>
>>>>> > On Sep 27, 2023, at 1:07 PM, Deo Felix <deofelix9@gmail.com> wrote:
>>>>> >
>>>>> > Okay thank you, I have not installed the mentioned extensions
>>>>>
>>>>> That's not the point. The point is that buggy extensions are one cause
>>>>> of this kind of instability, and you need to audit for *any* 3rd-party
>>>>> extensions in *YOUR* installation.
>>>>
>>>>
Attachments:
[image/png] postgresqlerror.png (81.6K, ../../CALW=F4MU2YL5mJTTwk7cfBAW7tUNrb+WvRKSvwHZCR=vu8kOyg@mail.gmail.com/3-postgresqlerror.png)
download | view image
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: Terminating connection because of crash of another server process
2023-09-27 13:25 Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 13:39 ` Re: Terminating connection because of crash of another server process Laurenz Albe <laurenz.albe@cybertec.at>
2023-09-27 13:50 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 13:58 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 14:18 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 19:07 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 19:13 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 19:15 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-28 05:51 ` Re: Terminating connection because of crash of another server process Deepak Goel <deicool@gmail.com>
2023-09-28 11:22 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-28 11:29 ` Re: Terminating connection because of crash of another server process Deepak Goel <deicool@gmail.com>
2023-09-29 08:21 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
@ 2023-09-29 08:41 ` Deepak Goel <deicool@gmail.com>
2023-10-02 05:54 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
1 sibling, 1 reply; 25+ messages in thread
From: Deepak Goel @ 2023-09-29 08:41 UTC (permalink / raw)
To: Deo Felix <deofelix9@gmail.com>; +Cc: Scott Ribe <scott_ribe@elevated-dev.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
The error says very little. You might want to put the 'Debug' on along with
"Detail".
Deepak
"The greatness of a nation can be judged by the way its animals are treated
- Mahatma Gandhi"
+91 73500 12833
deicool@gmail.com
Facebook: https://www.facebook.com/deicool
LinkedIn: www.linkedin.com/in/deicool
"Plant a Tree, Go Green"
Make In India : http://www.makeinindia.com/home
On Fri, Sep 29, 2023 at 1:54 PM Deo Felix <deofelix9@gmail.com> wrote:
> Please find the screenshot of error from the log file [image:
> postgresqlerror.png]
>
>
>
>
> On Thu, 28 Sept 2023 at 14:29, Deepak Goel <deicool@gmail.com> wrote:
>
>> Please print the "out of shared memory error" or you need to make a
>> provision for printing detailed error.
>>
>>
>> Deepak
>> "The greatness of a nation can be judged by the way its animals are
>> treated - Mahatma Gandhi"
>>
>> +91 73500 12833
>> deicool@gmail.com
>>
>> Facebook: https://www.facebook.com/deicool
>> LinkedIn: www.linkedin.com/in/deicool
>>
>> "Plant a Tree, Go Green"
>>
>> Make In India : http://www.makeinindia.com/home
>>
>>
>> On Thu, Sep 28, 2023 at 4:55 PM Deo Felix <deofelix9@gmail.com> wrote:
>>
>>> The problem occurred when refreshing materialized views, out of shared
>>> memory error occur
>>>
>>> On Thu, 28 Sept 2023 at 08:51, Deepak Goel <deicool@gmail.com> wrote:
>>>
>>>> The error posted by you ( WARNING: terminating connection because of
>>>> crash of another server process) is at a very high level. Can you
>>>> drill down for a detailed error?
>>>>
>>>>
>>>> Deepak
>>>> "The greatness of a nation can be judged by the way its animals are
>>>> treated - Mahatma Gandhi"
>>>>
>>>> +91 73500 12833
>>>> deicool@gmail.com
>>>>
>>>> Facebook: https://www.facebook.com/deicool
>>>> LinkedIn: www.linkedin.com/in/deicool
>>>>
>>>> "Plant a Tree, Go Green"
>>>>
>>>> Make In India : http://www.makeinindia.com/home
>>>>
>>>>
>>>> On Thu, Sep 28, 2023 at 8:13 AM Deo Felix <deofelix9@gmail.com> wrote:
>>>>
>>>>> Okay, basically I have installed this extension
>>>>> pgaudit, repmgr, pgagent And I will audit them as you have adviced
>>>>>
>>>>> On Wed, 27 Sept 2023 at 22:13, Scott Ribe <scott_ribe@elevated-dev.com>
>>>>> wrote:
>>>>>
>>>>>> > On Sep 27, 2023, at 1:07 PM, Deo Felix <deofelix9@gmail.com> wrote:
>>>>>> >
>>>>>> > Okay thank you, I have not installed the mentioned extensions
>>>>>>
>>>>>> That's not the point. The point is that buggy extensions are one
>>>>>> cause of this kind of instability, and you need to audit for *any*
>>>>>> 3rd-party extensions in *YOUR* installation.
>>>>>
>>>>>
Attachments:
[image/png] postgresqlerror.png (81.6K, ../../CA+b7NVUYbDtLq1Y0RRTipRp3n8uV6zPZMK+mJC2or-pp1rdfWw@mail.gmail.com/3-postgresqlerror.png)
download | view image
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: Terminating connection because of crash of another server process
2023-09-27 13:25 Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 13:39 ` Re: Terminating connection because of crash of another server process Laurenz Albe <laurenz.albe@cybertec.at>
2023-09-27 13:50 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 13:58 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 14:18 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 19:07 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 19:13 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 19:15 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-28 05:51 ` Re: Terminating connection because of crash of another server process Deepak Goel <deicool@gmail.com>
2023-09-28 11:22 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-28 11:29 ` Re: Terminating connection because of crash of another server process Deepak Goel <deicool@gmail.com>
2023-09-29 08:21 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-29 08:41 ` Re: Terminating connection because of crash of another server process Deepak Goel <deicool@gmail.com>
@ 2023-10-02 05:54 ` Deo Felix <deofelix9@gmail.com>
0 siblings, 0 replies; 25+ messages in thread
From: Deo Felix @ 2023-10-02 05:54 UTC (permalink / raw)
To: Deepak Goel <deicool@gmail.com>; +Cc: Scott Ribe <scott_ribe@elevated-dev.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
It is in production that is why the debug is off
On Fri, 29 Sept 2023 at 11:41, Deepak Goel <deicool@gmail.com> wrote:
> The error says very little. You might want to put the 'Debug' on along
> with "Detail".
>
> Deepak
> "The greatness of a nation can be judged by the way its animals are
> treated - Mahatma Gandhi"
>
> +91 73500 12833
> deicool@gmail.com
>
> Facebook: https://www.facebook.com/deicool
> LinkedIn: www.linkedin.com/in/deicool
>
> "Plant a Tree, Go Green"
>
> Make In India : http://www.makeinindia.com/home
>
>
> On Fri, Sep 29, 2023 at 1:54 PM Deo Felix <deofelix9@gmail.com> wrote:
>
>> Please find the screenshot of error from the log file [image:
>> postgresqlerror.png]
>>
>>
>>
>>
>> On Thu, 28 Sept 2023 at 14:29, Deepak Goel <deicool@gmail.com> wrote:
>>
>>> Please print the "out of shared memory error" or you need to make a
>>> provision for printing detailed error.
>>>
>>>
>>> Deepak
>>> "The greatness of a nation can be judged by the way its animals are
>>> treated - Mahatma Gandhi"
>>>
>>> +91 73500 12833
>>> deicool@gmail.com
>>>
>>> Facebook: https://www.facebook.com/deicool
>>> LinkedIn: www.linkedin.com/in/deicool
>>>
>>> "Plant a Tree, Go Green"
>>>
>>> Make In India : http://www.makeinindia.com/home
>>>
>>>
>>> On Thu, Sep 28, 2023 at 4:55 PM Deo Felix <deofelix9@gmail.com> wrote:
>>>
>>>> The problem occurred when refreshing materialized views, out of shared
>>>> memory error occur
>>>>
>>>> On Thu, 28 Sept 2023 at 08:51, Deepak Goel <deicool@gmail.com> wrote:
>>>>
>>>>> The error posted by you ( WARNING: terminating connection because of
>>>>> crash of another server process) is at a very high level. Can you
>>>>> drill down for a detailed error?
>>>>>
>>>>>
>>>>> Deepak
>>>>> "The greatness of a nation can be judged by the way its animals are
>>>>> treated - Mahatma Gandhi"
>>>>>
>>>>> +91 73500 12833
>>>>> deicool@gmail.com
>>>>>
>>>>> Facebook: https://www.facebook.com/deicool
>>>>> LinkedIn: www.linkedin.com/in/deicool
>>>>>
>>>>> "Plant a Tree, Go Green"
>>>>>
>>>>> Make In India : http://www.makeinindia.com/home
>>>>>
>>>>>
>>>>> On Thu, Sep 28, 2023 at 8:13 AM Deo Felix <deofelix9@gmail.com> wrote:
>>>>>
>>>>>> Okay, basically I have installed this extension
>>>>>> pgaudit, repmgr, pgagent And I will audit them as you have adviced
>>>>>>
>>>>>> On Wed, 27 Sept 2023 at 22:13, Scott Ribe <
>>>>>> scott_ribe@elevated-dev.com> wrote:
>>>>>>
>>>>>>> > On Sep 27, 2023, at 1:07 PM, Deo Felix <deofelix9@gmail.com>
>>>>>>> wrote:
>>>>>>> >
>>>>>>> > Okay thank you, I have not installed the mentioned extensions
>>>>>>>
>>>>>>> That's not the point. The point is that buggy extensions are one
>>>>>>> cause of this kind of instability, and you need to audit for *any*
>>>>>>> 3rd-party extensions in *YOUR* installation.
>>>>>>
>>>>>>
Attachments:
[image/png] postgresqlerror.png (81.6K, ../../CALW=F4O8u4riWnn93UmtfDwMBz=EYWdXPvhOWPWdxqEwOQ5tPA@mail.gmail.com/3-postgresqlerror.png)
download | view image
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: Terminating connection because of crash of another server process
2023-09-27 13:25 Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 13:39 ` Re: Terminating connection because of crash of another server process Laurenz Albe <laurenz.albe@cybertec.at>
2023-09-27 13:50 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 13:58 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 14:18 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 19:07 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 19:13 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 19:15 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-28 05:51 ` Re: Terminating connection because of crash of another server process Deepak Goel <deicool@gmail.com>
2023-09-28 11:22 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-28 11:29 ` Re: Terminating connection because of crash of another server process Deepak Goel <deicool@gmail.com>
2023-09-29 08:21 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
@ 2023-09-29 09:27 ` Laurenz Albe <laurenz.albe@cybertec.at>
2023-10-02 06:00 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
1 sibling, 1 reply; 25+ messages in thread
From: Laurenz Albe @ 2023-09-29 09:27 UTC (permalink / raw)
To: Deo Felix <deofelix9@gmail.com>; Deepak Goel <deicool@gmail.com>; +Cc: Scott Ribe <scott_ribe@elevated-dev.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
On Fri, 2023-09-29 at 11:21 +0300, Deo Felix wrote:
> Please find the screenshot of error from the log file postgresqlerror.png
It is really amazing how much effort you make *not* to share
any relevant information with us. But there is finally some
interesting message hidden in your image:
server process (PID 14257) was terminated by signal 9: Killed
Since I don't expect that random users on your server machine
go around "kill -9"-ing PostgreSQL processes, it is very likely
that PostgreSQL is crashed by the Linux out-of-memory killer.
You should disable memory overcommit, see
https://www.postgresql.org/docs/current/kernel-resources.html#LINUX-MEMORY-OVERCOMMIT
Then you will start getting "out of memory" errors instead of
crashes. To combat these, reduce the memory usage parameters,
mostly "work_mem", or reduce the number of active database sessions
by using a connection pool.
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: Terminating connection because of crash of another server process
2023-09-27 13:25 Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 13:39 ` Re: Terminating connection because of crash of another server process Laurenz Albe <laurenz.albe@cybertec.at>
2023-09-27 13:50 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 13:58 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 14:18 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 19:07 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 19:13 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 19:15 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-28 05:51 ` Re: Terminating connection because of crash of another server process Deepak Goel <deicool@gmail.com>
2023-09-28 11:22 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-28 11:29 ` Re: Terminating connection because of crash of another server process Deepak Goel <deicool@gmail.com>
2023-09-29 08:21 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-29 09:27 ` Re: Terminating connection because of crash of another server process Laurenz Albe <laurenz.albe@cybertec.at>
@ 2023-10-02 06:00 ` Deo Felix <deofelix9@gmail.com>
2023-10-03 06:15 ` Re: Terminating connection because of crash of another server process Deepak Goel <deicool@gmail.com>
0 siblings, 1 reply; 25+ messages in thread
From: Deo Felix @ 2023-10-02 06:00 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; +Cc: Deepak Goel <deicool@gmail.com>; Scott Ribe <scott_ribe@elevated-dev.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
Please note that the server is in production and debug is not enabled, that
is why there is not much information in the log file.
I'm starting working with your suggestion including reducing the work_mem
On Fri, 29 Sept 2023 at 12:27, Laurenz Albe <laurenz.albe@cybertec.at>
wrote:
> On Fri, 2023-09-29 at 11:21 +0300, Deo Felix wrote:
> > Please find the screenshot of error from the log
> file postgresqlerror.png
>
> It is really amazing how much effort you make *not* to share
> any relevant information with us. But there is finally some
> interesting message hidden in your image:
>
> server process (PID 14257) was terminated by signal 9: Killed
>
> Since I don't expect that random users on your server machine
> go around "kill -9"-ing PostgreSQL processes, it is very likely
> that PostgreSQL is crashed by the Linux out-of-memory killer.
>
> You should disable memory overcommit, see
>
> https://www.postgresql.org/docs/current/kernel-resources.html#LINUX-MEMORY-OVERCOMMIT
>
> Then you will start getting "out of memory" errors instead of
> crashes. To combat these, reduce the memory usage parameters,
> mostly "work_mem", or reduce the number of active database sessions
> by using a connection pool.
>
> Yours,
> Laurenz Albe
>
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: Terminating connection because of crash of another server process
2023-09-27 13:25 Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 13:39 ` Re: Terminating connection because of crash of another server process Laurenz Albe <laurenz.albe@cybertec.at>
2023-09-27 13:50 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 13:58 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 14:18 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 19:07 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 19:13 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 19:15 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-28 05:51 ` Re: Terminating connection because of crash of another server process Deepak Goel <deicool@gmail.com>
2023-09-28 11:22 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-28 11:29 ` Re: Terminating connection because of crash of another server process Deepak Goel <deicool@gmail.com>
2023-09-29 08:21 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-29 09:27 ` Re: Terminating connection because of crash of another server process Laurenz Albe <laurenz.albe@cybertec.at>
2023-10-02 06:00 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
@ 2023-10-03 06:15 ` Deepak Goel <deicool@gmail.com>
0 siblings, 0 replies; 25+ messages in thread
From: Deepak Goel @ 2023-10-03 06:15 UTC (permalink / raw)
To: Deo Felix <deofelix9@gmail.com>; +Cc: Laurenz Albe <laurenz.albe@cybertec.at>; Scott Ribe <scott_ribe@elevated-dev.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
On Mon, Oct 2, 2023 at 11:34 AM Deo Felix <deofelix9@gmail.com> wrote:
> Please note that the server is in production and debug is not enabled,
> that is why there is not much information in the log file.
>
We need the expanded error. Please enable (debug, detail) in production.
You can turn it off once the detailed error is found out.
> I'm starting working with your suggestion including reducing the work_mem
>
>
> On Fri, 29 Sept 2023 at 12:27, Laurenz Albe <laurenz.albe@cybertec.at>
> wrote:
>
>> On Fri, 2023-09-29 at 11:21 +0300, Deo Felix wrote:
>> > Please find the screenshot of error from the log
>> file postgresqlerror.png
>>
>> It is really amazing how much effort you make *not* to share
>> any relevant information with us. But there is finally some
>> interesting message hidden in your image:
>>
>> server process (PID 14257) was terminated by signal 9: Killed
>>
>> Since I don't expect that random users on your server machine
>> go around "kill -9"-ing PostgreSQL processes, it is very likely
>> that PostgreSQL is crashed by the Linux out-of-memory killer.
>>
>> You should disable memory overcommit, see
>>
>> https://www.postgresql.org/docs/current/kernel-resources.html#LINUX-MEMORY-OVERCOMMIT
>>
>> Then you will start getting "out of memory" errors instead of
>> crashes. To combat these, reduce the memory usage parameters,
>> mostly "work_mem", or reduce the number of active database sessions
>> by using a connection pool.
>>
>> Yours,
>> Laurenz Albe
>>
>
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: Terminating connection because of crash of another server process
2023-09-27 13:25 Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 13:39 ` Re: Terminating connection because of crash of another server process Laurenz Albe <laurenz.albe@cybertec.at>
2023-09-27 13:50 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 13:58 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
@ 2023-09-27 17:16 ` Scott Ribe <scott_ribe@elevated-dev.com>
1 sibling, 0 replies; 25+ messages in thread
From: Scott Ribe @ 2023-09-27 17:16 UTC (permalink / raw)
To: Deo Felix <deofelix9@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
> On Sep 27, 2023, at 7:58 AM, Deo Felix <deofelix9@gmail.com> wrote:
>
> What extension please can you mention
I did. But you need to see what extensions *you* have installed, if any.
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: Terminating connection because of crash of another server process
2023-09-27 13:25 Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 13:39 ` Re: Terminating connection because of crash of another server process Laurenz Albe <laurenz.albe@cybertec.at>
@ 2023-09-27 13:57 ` Deo Felix <deofelix9@gmail.com>
2023-09-27 14:05 ` Re: Terminating connection because of crash of another server process Laurenz Albe <laurenz.albe@cybertec.at>
1 sibling, 1 reply; 25+ messages in thread
From: Deo Felix @ 2023-09-27 13:57 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory
Please advice what configuration should I do
Sent from Outlook for Android<https://aka.ms/AAb9ysg;
________________________________
From: Laurenz Albe <laurenz.albe@cybertec.at>
Sent: Wednesday, September 27, 2023 4:39:18 PM
To: Deo Felix <deofelix9@gmail.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: Terminating connection because of crash of another server process
On Wed, 2023-09-27 at 16:25 +0300, Deo Felix wrote:
> Please assist Im getting the error below in Postgresql 13 database
>
> WARNING: terminating connection because of crash of another server process
The trick is not to have any crashes.
Look at the PostgreSQL log to determine the cause of the crash and
see that it does not happen again. A well configured PostgreSQL
on good hardware should not crash.
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: Terminating connection because of crash of another server process
2023-09-27 13:25 Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 13:39 ` Re: Terminating connection because of crash of another server process Laurenz Albe <laurenz.albe@cybertec.at>
2023-09-27 13:57 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
@ 2023-09-27 14:05 ` Laurenz Albe <laurenz.albe@cybertec.at>
2023-09-27 19:06 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
0 siblings, 1 reply; 25+ messages in thread
From: Laurenz Albe @ 2023-09-27 14:05 UTC (permalink / raw)
To: Deo Felix <deofelix9@gmail.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
On Wed, 2023-09-27 at 13:57 +0000, Deo Felix wrote:
> Please advice what configuration should I do
Read the PostgreSQL log. Not only the one line you keep repeating.
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: Terminating connection because of crash of another server process
2023-09-27 13:25 Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 13:39 ` Re: Terminating connection because of crash of another server process Laurenz Albe <laurenz.albe@cybertec.at>
2023-09-27 13:57 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 14:05 ` Re: Terminating connection because of crash of another server process Laurenz Albe <laurenz.albe@cybertec.at>
@ 2023-09-27 19:06 ` Deo Felix <deofelix9@gmail.com>
0 siblings, 0 replies; 25+ messages in thread
From: Deo Felix @ 2023-09-27 19:06 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
There is a view that is causing to fail
failed process was running refresh materialized view
On Wed, 27 Sept 2023 at 17:05, Laurenz Albe <laurenz.albe@cybertec.at>
wrote:
> On Wed, 2023-09-27 at 13:57 +0000, Deo Felix wrote:
> > Please advice what configuration should I do
>
> Read the PostgreSQL log. Not only the one line you keep repeating.
>
> Yours,
> Laurenz Albe
>
^ permalink raw reply [nested|flat] 25+ messages in thread
end of thread, other threads:[~2023-10-03 06:15 UTC | newest]
Thread overview: 25+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-02-13 20:48 terminating connection because of crash of another server process Leticia Larrosa <leticia@tesla.cujae.edu.cu>
2008-02-13 21:41 ` Scott Marlowe <scott.marlowe@gmail.com>
2008-02-15 17:29 ` Fabricio <fabrixio1@hotmail.com>
2008-02-15 18:22 ` Leticia Larrosa <leticia@tesla.cujae.edu.cu>
2023-09-27 13:25 Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 13:39 ` Re: Terminating connection because of crash of another server process Laurenz Albe <laurenz.albe@cybertec.at>
2023-09-27 13:50 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 13:58 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 14:18 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 19:07 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 19:13 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 19:15 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-28 05:51 ` Re: Terminating connection because of crash of another server process Deepak Goel <deicool@gmail.com>
2023-09-28 11:22 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-28 11:29 ` Re: Terminating connection because of crash of another server process Deepak Goel <deicool@gmail.com>
2023-09-29 08:21 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-29 08:41 ` Re: Terminating connection because of crash of another server process Deepak Goel <deicool@gmail.com>
2023-10-02 05:54 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-29 09:27 ` Re: Terminating connection because of crash of another server process Laurenz Albe <laurenz.albe@cybertec.at>
2023-10-02 06:00 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-10-03 06:15 ` Re: Terminating connection because of crash of another server process Deepak Goel <deicool@gmail.com>
2023-09-27 17:16 ` Re: Terminating connection because of crash of another server process Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 13:57 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
2023-09-27 14:05 ` Re: Terminating connection because of crash of another server process Laurenz Albe <laurenz.albe@cybertec.at>
2023-09-27 19:06 ` Re: Terminating connection because of crash of another server process Deo Felix <deofelix9@gmail.com>
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