select big table postgresql crash

Started by Jack Tsengabout 6 years ago3 messagesbugs
Jump to latest
#1Jack Tseng
jacktsen@gmail.com

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Jack Tseng (#1)
Re: select big table postgresql crash

Jack Tseng <jacktsen@gmail.com> writes:

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

OS message
=============================
Termination Reason: Namespace CODESIGNING, Code 0x2

Yeah, Apple moved the goalposts recently and EDB's build hasn't caught
up; see

/messages/by-id/CA+OCxoz0bWi+R2WpocfkD20Lgrg69z1jQ_SZd-zmdzHW0zt+bg@mail.gmail.com

Until there's a fix, I'd suggest "set jit = off".

regards, tom lane

#3Jack Tseng
jacktsen@gmail.com
In reply to: Tom Lane (#2)
Re: select big table postgresql crash

Thanks!

Tom Lane <tgl@sss.pgh.pa.us> 於 2020年3月10日 週二 上午12:25 寫道:

Show quoted text

Jack Tseng <jacktsen@gmail.com> writes:

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

OS message
=============================
Termination Reason: Namespace CODESIGNING, Code 0x2

Yeah, Apple moved the goalposts recently and EDB's build hasn't caught
up; see

/messages/by-id/CA+OCxoz0bWi+R2WpocfkD20Lgrg69z1jQ_SZd-zmdzHW0zt+bg@mail.gmail.com

Until there's a fix, I'd suggest "set jit = off".

regards, tom lane