BUG #17655: crash postgres by query

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: kdavydenka(at)gmail(dot)ru
Subject: BUG #17655: crash postgres by query
Date: 2022-10-20 14:16:55
Message-ID: 17655-c56446e34b34eb86@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: 17655
Logged by: Kos Dav
Email address: kdavydenka(at)gmail(dot)ru
PostgreSQL version: 10.19
Operating system: Red Hat Enterprise Linux Server 7.8 (Maipo)
Description:

log from journalctl
Oct 20 14:52:21 server1 kernel: show_signal_msg: 537 callbacks suppressed
Oct 20 14:52:21 server1 kernel: postgres[9328]: segfault at 1e88ff3 ip
00007f55ad8414ff sp 00007fff0031e7f8 error 4 in
libc-2.17.so[7f55ad6eb000+1c3000]
Oct 20 14:52:21 server1 abrt-hook-ccpp[9329]: Process 35274(postgres) of
user 26 killed by SIGSEGV - dumping core

log from postgres
server process (PID 35274) was terminated by signal 11: Segmentation fault
Failed process was running:
select customer_id, birth_place from last_golden_record lgr where
birth_place like U&'%\000A%'

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Julien Rouhaud 2022-10-20 14:50:15 Re: BUG #17655: crash postgres by query
Previous Message hubert depesz lubaczewski 2022-10-20 11:55:16 Re: WAL segments removed from primary despite the fact that logical replication slot needs it.