Re: select big table postgresql crash - Mailing list pgsql-bugs

From Jack Tseng
Subject Re: select big table postgresql crash
Date
Msg-id CAPzy-cOUgYEw3WGgTA4jSr=md+qrx+i+yEsEnek21nNwm83Vyg@mail.gmail.com
Whole thread Raw
In response to Re: select big table postgresql crash  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: Re: BUG #16285: bt_metap fails with value is out of range for typeinteger
Next
From: Peter Geoghegan
Date:
Subject: Re: BUG #16285: bt_metap fails with value is out of range for type integer