select big table postgresql crash

From: Jack Tseng <jacktsen(at)gmail(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: select big table postgresql crash
Date: 2020-03-09 07:54:01
Message-ID: CAPzy-cNeiuKjbDRja8m5LPfoiyOkW0x3u3Pf81pQ7j5piWkmrA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

postgresql 12.2
install in MAC OS Catalina 10.15.3
when table data big than 1G
select * from big_table

postgresql crash

OS message
=============================

Process: postgres [3385]
Path: /Users/USER/*/postgres
Identifier: postgres
Version: ???
Code Type: X86-64 (Native)
Parent Process: postgres [184]
Responsible: postgres [184]
User ID: 503

Date/Time: 2020-03-09 15:02:39.708 +0800
OS Version: Mac OS X 10.15.3 (19D76)
Report Version: 12
Anonymous UUID: 3B113E91-898E-F666-BB50-31D9251329AE

Time Awake Since Boot: 1600 seconds

System Integrity Protection: enabled

Crashed Thread: 0 Dispatch queue: com.apple.main-thread

Exception Type: EXC_BAD_ACCESS (Code Signature Invalid)
Exception Codes: 0x0000000000000032, 0x000000010b21ea10
Exception Note: EXC_CORPSE_NOTIFY

Termination Reason: Namespace CODESIGNING, Code 0x2

kernel messages:

VM Regions Near 0x10b21ea10:
__LINKEDIT 000000010b217000-000000010b21e000 [ 28K]
r--/rw- SM=COW /Users/USER/*/*.dylib
--> VM_ALLOCATE 000000010b21e000-000000010b220000 [ 8K]
r-x/rwx SM=COW
__TEXT 000000010b223000-000000010ca9f000 [ 24.5M]
r-x/rwx SM=COW /Users/USER/*/*.dylib

Application Specific Information:
crashed on child side of fork pre-exec

---
Jack Tseng

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2020-03-09 12:24:14 BUG #16288: application_name from client's primary_conninfo not set in pg_stat_replication on master
Previous Message Victor Yegorov 2020-03-08 07:47:20 Re: BUG #16285: bt_metap fails with value is out of range for type integer