BUG #14254: The postgres service goes down while working with the application
The following bug has been logged on the website:
Bug reference: 14254
Logged by: sajeev sahadevan
Email address: sajeevsahadev@gmail.com
PostgreSQL version: 9.6beta1
Operating system: Windows 8
Description:
Log File ==>
2016-07-17 12:33:10 GST LOG: worker process: parallel worker for PID 8088
(PID 5588) was terminated by exception 0xC0000005
2016-07-17 12:33:10 GST HINT: See C include file "ntstatus.h" for a
description of the hexadecimal value.
2016-07-17 12:33:10 GST LOG: terminating any other active server
processes
2016-07-17 12:33:10 GST WARNING: terminating connection because of crash of
another server process
2016-07-17 12:33:10 GST 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.
2016-07-17 12:33:10 GST HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2016-07-17 12:33:10 GST WARNING: terminating connection because of crash of
another server process
2016-07-17 12:33:10 GST 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.
2016-07-17 12:33:10 GST HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2016-07-17 12:33:10 GST WARNING: terminating connection because of crash of
another server process
2016-07-17 12:33:10 GST 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.
2016-07-17 12:33:10 GST HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2016-07-17 12:33:10 GST WARNING: terminating connection because of crash of
another server process
2016-07-17 12:33:10 GST 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.
2016-07-17 12:33:10 GST HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2016-07-17 12:33:10 GST WARNING: terminating connection because of crash of
another server process
2016-07-17 12:33:10 GST 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.
2016-07-17 12:33:10 GST HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2016-07-17 12:33:10 GST WARNING: terminating connection because of crash of
another server process
2016-07-17 12:33:10 GST 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.
2016-07-17 12:33:10 GST HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2016-07-17 12:33:10 GST WARNING: terminating connection because of crash of
another server process
2016-07-17 12:33:10 GST 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.
2016-07-17 12:33:10 GST HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2016-07-17 12:33:10 GST WARNING: terminating connection because of crash of
another server process
2016-07-17 12:33:10 GST 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.
2016-07-17 12:33:10 GST HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2016-07-17 12:33:10 GST WARNING: terminating connection because of crash of
another server process
2016-07-17 12:33:10 GST 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.
2016-07-17 12:33:10 GST HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2016-07-17 12:33:11 GST WARNING: terminating connection because of crash of
another server process
2016-07-17 12:33:11 GST 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.
2016-07-17 12:33:11 GST HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2016-07-17 12:33:11 GST WARNING: terminating connection because of crash of
another server process
2016-07-17 12:33:11 GST 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.
2016-07-17 12:33:11 GST HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2016-07-17 12:33:12 GST WARNING: terminating connection because of crash of
another server process
2016-07-17 12:33:12 GST 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.
2016-07-17 12:33:12 GST HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2016-07-17 12:33:13 GST WARNING: terminating connection because of crash of
another server process
2016-07-17 12:33:13 GST 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.
2016-07-17 12:33:13 GST HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2016-07-17 12:33:14 GST WARNING: terminating connection because of crash of
another server process
2016-07-17 12:33:14 GST 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.
2016-07-17 12:33:14 GST HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2016-07-17 12:33:14 GST WARNING: terminating connection because of crash of
another server process
2016-07-17 12:33:14 GST 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.
2016-07-17 12:33:14 GST HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2016-07-17 12:33:15 GST FATAL: the database system is in recovery mode
2016-07-17 12:33:15 GST FATAL: the database system is in recovery mode
2016-07-17 12:33:15 GST LOG: all server processes terminated;
reinitializing
2016-07-17 12:33:15 GST LOG: database system was interrupted; last known up
at 2016-07-17 11:56:00 GST
2016-07-17 12:33:16 GST FATAL: the database system is in recovery mode
2016-07-17 12:33:16 GST FATAL: the database system is in recovery mode
2016-07-17 12:33:18 GST FATAL: the database system is in recovery mode
2016-07-17 12:33:18 GST FATAL: the database system is in recovery mode
2016-07-17 12:33:18 GST FATAL: the database system is in recovery mode
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
On Sun, Jul 17, 2016 at 5:48 PM, <sajeevsahadev@gmail.com> wrote:
Bug reference: 14254
Logged by: sajeev sahadevan
Email address: sajeevsahadev@gmail.com
PostgreSQL version: 9.6beta1
Operating system: Windows 8Description:
2016-07-17 12:33:10 GST LOG: worker process: parallel worker for PID 8088
(PID 5588) was terminated by exception 0xC0000005
2016-07-17 12:33:10 GST HINT: See C include file "ntstatus.h" for a
description of the hexadecimal value.
Hard to say what's going bad here without more details like the query
involved, but that's a problem with parallel queries, and a new one.
Do you still see the problem if you use 9.6beta2?
--
Michael
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
On Sun, Jul 17, 2016 at 3:22 PM, Michael Paquier
<michael.paquier@gmail.com> wrote:
On Sun, Jul 17, 2016 at 5:48 PM, <sajeevsahadev@gmail.com> wrote:
Bug reference: 14254
Logged by: sajeev sahadevan
Email address: sajeevsahadev@gmail.com
PostgreSQL version: 9.6beta1
Operating system: Windows 8Description:
2016-07-17 12:33:10 GST LOG: worker process: parallel worker for PID 8088
(PID 5588) was terminated by exception 0xC0000005
2016-07-17 12:33:10 GST HINT: See C include file "ntstatus.h" for a
description of the hexadecimal value.Hard to say what's going bad here without more details like the query
involved, but that's a problem with parallel queries, and a new one.
I think it is important to check in 9.6beta2 especially because we
have fixed couple of crashes in parallel worker.
--
With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs