pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedselect big table postgresql crash
3+ messages / 2 participants
[nested] [flat]
* select big table postgresql crash
@ 2020-03-09 07:54 Jack Tseng <jacktsen@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Jack Tseng @ 2020-03-09 07:54 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: select big table postgresql crash
@ 2020-03-09 16:25 Tom Lane <tgl@sss.pgh.pa.us>
parent: Jack Tseng <jacktsen@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 2020-03-09 16:25 UTC (permalink / raw)
To: Jack Tseng <jacktsen@gmail.com>; +Cc: pgsql-bugs@lists.postgresql.org
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...
Until there's a fix, I'd suggest "set jit = off".
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: select big table postgresql crash
@ 2020-03-09 22:25 Jack Tseng <jacktsen@gmail.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 3+ messages in thread
From: Jack Tseng @ 2020-03-09 22:25 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-bugs@lists.postgresql.org
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...
>
> Until there's a fix, I'd suggest "set jit = off".
>
> regards, tom lane
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2020-03-09 22:25 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-03-09 07:54 select big table postgresql crash Jack Tseng <jacktsen@gmail.com>
2020-03-09 16:25 ` Re: select big table postgresql crash Tom Lane <tgl@sss.pgh.pa.us>
2020-03-09 22:25 ` Re: select big table postgresql crash Jack Tseng <jacktsen@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox