BUG #14594: postgres dies with fatal error

From: gnareshdba(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14594: postgres dies with fatal error
Date: 2017-03-20 22:26:03
Message-ID: 20170320222603.1416.38609@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14594
Logged by: naresh g
Email address: gnareshdba(at)gmail(dot)com
PostgreSQL version: 9.4.5
Operating system: RHEL 7.2
Description:

postgresql (9.4.5) instance restarts with below error during backup times
-

2017-03-19 19:00:21 EDT PANIC: semop(id=152698887) failed: Invalid
argument
2017-03-19 19:00:21 EDT PANIC: semop(id=152698887) failed: Invalid
argument
2017-03-19 19:00:26 EDT FATAL: semctl(152666118, 6, SETVAL, 0) failed:
Invalid argument
2017-03-19 19:00:26 EDT LOG: server process (PID 13090) exited with exit
code 1
2017-03-19 19:00:26 EDT LOG: terminating any other active server processes
2017-03-19 19:00:26 EDT WARNING: terminating connection because of crash of
another server process
2017-03-19 19:00:26 EDT 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.
2017-03-19 19:00:26 EDT HINT: In a moment you should be able to reconnect to
the database and repeat your command.
2017-03-19 19:00:26 EDT WARNING: terminating connection because of crash of
another server process
2017-03-19 19:00:26 EDT 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.
2017-03-19 19:00:26 EDT HINT: In a moment you should be able to reconnect to
the database and repeat your command.
2017-03-19 19:00:26 EDT WARNING: terminating connection because of crash of
another server process
2017-03-19 19:00:26 EDT 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.

Instance crashes and starts automatically.

on RHEL 7.2, and UID set to (id -u postgres)
2011

I have below backups configured -
pg_basebackup --xlog -R -P --gzip --format=t
pg_backup_rotated.sh

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message John R Pierce 2017-03-21 08:32:52 Re: BUG #14594: postgres dies with fatal error
Previous Message Wiler Coelho Jr. 2017-03-20 17:31:06 Re: Error floating-point exception on postgresql installer