pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
BUG #17831: server crash
2+ messages / 2 participants
[nested] [flat]

* BUG #17831: server crash
@ 2023-03-11 08:38  PG Bug reporting form <noreply@postgresql.org>
  0 siblings, 1 reply; 2+ messages in thread

From: PG Bug reporting form @ 2023-03-11 08:38 UTC (permalink / raw)
  To: pgsql-bugs@lists.postgresql.org; +Cc: 253540651@qq.com

The following bug has been logged on the website:

Bug reference:      17831
Logged by:          Zhiyong Wu
Email address:      253540651@qq.com
PostgreSQL version: 15.2
Operating system:   Linux
Description:        

PoC:
select
  pg_catalog.int8multirange() as c0, 
  pg_catalog.pg_export_snapshot() as c1, 
  ref_0.default_collate_schema as c2,
  ref_0.character_set_name as c3,
  ref_0.default_collate_catalog as c4,
  (select tablename from pg_catalog.pg_tables limit 1 offset 3)
     as c5,
  ref_0.default_collate_catalog as c6,
  ref_0.default_collate_catalog as c7,
  ref_0.character_set_name as c8,
  ref_0.default_collate_schema as c9,
  pg_catalog.pg_stat_get_bgwriter_requested_checkpoints() as c10,
  ref_0.default_collate_catalog as c11,
  pg_catalog.pg_stat_get_bgwriter_stat_reset_time() as c12,
  ref_0.default_collate_schema as c13
from
  information_schema.character_sets as ref_0
where pg_catalog.pg_terminate_backend(
    cast(pg_catalog.pg_backend_pid() as int4),
    cast((select off from pg_catalog.pg_shmem_allocations limit 1 offset
3)
       as int8)) is not NULL



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: BUG #17831: server crash
@ 2023-03-11 15:51  Tom Lane <tgl@sss.pgh.pa.us>
  parent: PG Bug reporting form <noreply@postgresql.org>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2023-03-11 15:51 UTC (permalink / raw)
  To: 253540651@qq.com; +Cc: pgsql-bugs@lists.postgresql.org

PG Bug reporting form <noreply@postgresql.org> writes:
> PoC:
> select
>   ...
> where pg_catalog.pg_terminate_backend(
>     cast(pg_catalog.pg_backend_pid() as int4),

You told the session to terminate itself, and it did.  I see
no bug here.

			regards, tom lane





^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2023-03-11 15:51 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-03-11 08:38 BUG #17831: server crash PG Bug reporting form <noreply@postgresql.org>
2023-03-11 15:51 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox