BUG #16033: segmentation fault when runing update
От | PG Bug reporting form |
---|---|
Тема | BUG #16033: segmentation fault when runing update |
Дата | |
Msg-id | 16033-6c9a1ddbdad9f296@postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #16033: segmentation fault when runing update
|
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 16033 Logged by: Miha Vrhovnik Email address: miha.vrhovnik@naviter.com PostgreSQL version: 12rc1 Operating system: Ubuntu 18.04.3 Description: We are launching a ne service and decided to test the new 12rc1 It happens that from time to time the postgresql crashes with segmentation fault. When it crashes the query running is always of the following form: UPDATE calculation SET updated_xy = NOW(), xy = $1, types = array_distinct(array_cat(types, $2)), failed = array_distinct(array_cat(failed, $3)) Now the array_distinct is defined as following: CREATE OR REPLACE FUNCTION array_distinct(anyarray) RETURNS anyarray AS $$ SELECT ARRAY(SELECT DISTINCT unnest($1) ORDER BY 1) $$ LANGUAGE sql; everything of "importance" around the UPDATE sentence is 2019-10-02 12:03:03.137 UTC [1215] LOCATION: LogChildExit, postmaster.c:3680 2019-10-02 12:03:03.137 UTC [1215] LOG: 00000: terminating any other active server processes 2019-10-02 12:03:03.137 UTC [1215] LOCATION: HandleChildCrash, postmaster.c:3400
В списке pgsql-bugs по дате отправления: