pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
select 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