terminated by signal 11: Segmentation fault

From: Gerrit Fouche <gerrit(dot)fouche(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: terminated by signal 11: Segmentation fault
Date: 2019-11-13 10:02:46
Message-ID: CAJGpXMiJ2K=wLi=V-egKB7=U2ntMugqd+XRiufhZ8kjMhj4yqw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

This is the second time I get this error since Postgresql 12 was officially
released. My version:
PostgreSQL 12.0 (Ubuntu 12.0-2.pgdg18.04+1) on x86_64-pc-linux-gnu,
compiled by gcc (Ubuntu 7.4.0-1ubuntu1~18.04.1) 7.4.0, 64-bit

I am running a Warehouse Management system in a Live environment.
Postgresql was installed from http://apt.postgresql.org/pub/repos/apt
bionic-pgdg InRelease

When this error occurs all other active processes are also terminated. Both
these statements are in production for years. The OS of the server is a new
implementation on VMWare. Can you please point me in the right direction to
solve it?

2019-11-13 11:18:31.296 SAST,,,5033,,5dc7a74d.13a9,75,,2019-11-10 07:59:41
SAST,,0,LOG,00000,"server process (PID 17257) was terminated by signal 11:
Segmentation fault","Failed process was running: UPDATE stock_items SET
""parties_role_id"" = NULL, ""inventory_transaction_stock_id"" = NULL,
""stock_type_id"" = 3, ""inventory_quantity"" = 1, ""previous_location_id""
= 7638, ""updated_at"" = '2019-11-13 11:18:30.377770', ""location_code"" =
'KROMCO', ""status_id"" = NULL, ""parties_role_name"" = NULL, ""destroyed""
= 't', ""inventory_transaction_id"" = 32504133, ""status_code"" =
'available', ""current_reference_id"" = NULL, ""inventory_reference"" =
'11460516', ""party_name"" = NULL, ""location_id"" = 5150,
""stock_type_code"" = 'BIN', ""created_on"" = '2019-05-21 14:11:12.793316'
WHERE ""id"" = 5197826",,,,,,,,""
2019-11-13 11:18:31.296 SAST,,,5033,,5dc7a74d.13a9,76,,2019-11-10 07:59:41
SAST,,0,LOG,00000,"terminating any other active server processes",,,,,,,,,""

/pglog/postgresql-2019-11-05_000000.csv:2019-11-05 09:20:58.291
SAST,,,19626,,5da40a0c.4caa,3,,2019-10-14 07:39:24
SAST,,0,LOG,00000,"server process (PID 12242) was terminated by signal 11:
Segmentation fault","Failed process was running: UPDATE bins SET
tipped_date_time='Tue Nov 05 07:29:17 UTC
2019',exit_reference_date_time='Tue Nov 05 07:29:17 UTC
2019',exit_ref='PRESORT_BIN_TIPPED',ps_tipped_lot_no='12755',updated_by =
'',affected_by_program = '',affected_by_env = '',affected_by_function
='',updated_at = '2019-11-05 09:10:05' WHERE (bin_number = '11375907')
",,,,,,,,""

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2019-11-13 14:41:08 Re: here does postgres take its timezone information from?
Previous Message Matthias Apitz 2019-11-13 06:26:44 Re: type SERIAL in C host-struct