select big table postgresql crash

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

select big table postgresql crash

Jack Tseng
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
Reply | Threaded
Open this post in threaded view
|

Re: select big table postgresql crash

Tom Lane-2
Jack Tseng <[hidden email]> 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@...

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

                        regards, tom lane


Reply | Threaded
Open this post in threaded view
|

Re: select big table postgresql crash

Jack Tseng
Thanks! 

Tom Lane <[hidden email]> 於 2020年3月10日 週二 上午12:25 寫道:
Jack Tseng <[hidden email]> 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@...

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

                        regards, tom lane