Обсуждение: select big table postgresql crash
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
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
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 https://www.postgresql.org/message-id/CA+OCxoz0bWi+R2WpocfkD20Lgrg69z1jQ_SZd-zmdzHW0zt+bg@mail.gmail.com Until there's a fix, I'd suggest "set jit = off". regards, tom lane
Thanks!
Tom Lane <tgl@sss.pgh.pa.us> 於 2020年3月10日 週二 上午12:25 寫道:
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
https://www.postgresql.org/message-id/CA+OCxoz0bWi+R2WpocfkD20Lgrg69z1jQ_SZd-zmdzHW0zt+bg@mail.gmail.com
Until there's a fix, I'd suggest "set jit = off".
regards, tom lane