Re: BUG #16827: macOS interrupted syscall leads to a crash

Поиск
Список
Период
Сортировка
От Kimon Krenz
Тема Re: BUG #16827: macOS interrupted syscall leads to a crash
Дата
Msg-id AD89582F-39D0-4A52-96A7-82105B4DF4C3@part9.com
обсуждение исходный текст
Ответ на BUG #16827: macOS interrupted syscall leads to a crash  (PG Bug reporting form <noreply@postgresql.org>)
Список pgsql-bugs
Hi,

Normally I do have an antivirus installed (i.e. Sophos Home). 
However, I did run a couple of tests with deactivated antivirus software and still faced the same issues.

See attached the osx crash report as well as the postgres.log outputs after running a FULL VACUUM on the entire database (no active antivirus).
I should mention of three tries, one FULL VACUUM process on the entire database finished successfully, while two generated 'Interrupted system call' errors.

Best,
Kimon

Crash Report:

Process:               postgres [81020]
Path:                  /usr/local/Cellar/postgresql/13.1/bin/postgres
Identifier:            postgres
Version:               0
Code Type:             X86-64 (Native)
Parent Process:        postgres [81013]
Responsible:           postgres [81013]
User ID:               501

Date/Time:             2021-01-24 21:26:31.955 +0000
OS Version:            macOS 11.0.1 (20B29)
Report Version:        12
Bridge OS Version:     3.0 (14Y908)
Anonymous UUID:        42F4F685-5742-A8A3-E52E-72DBCB658827

Sleep/Wake UUID:       8137C352-AC5F-4AA1-9C76-E905E25C241A

Time Awake Since Boot: 270000 seconds
Time Since Wake:       12000 seconds

System Integrity Protection: enabled

Crashed Thread:        0  Dispatch queue: com.apple.main-thread

Exception Type:        EXC_CRASH (SIGABRT)
Exception Codes:       0x0000000000000000, 0x0000000000000000
Exception Note:        EXC_CORPSE_NOTIFY

Application Specific Information:
crashed on child side of fork pre-exec

Thread 0 Crashed:: Dispatch queue: com.apple.main-thread
0   libsystem_kernel.dylib         0x00007fff202df462 __pthread_kill + 10
1   libsystem_pthread.dylib       0x00007fff2030d610 pthread_kill + 263
2   libsystem_c.dylib             0x00007fff20260720 abort + 120
3   postgres                       0x000000010a54e3fc errfinish.cold.2 + 39
4   postgres                       0x000000010a4942a4 errfinish + 760
5   postgres                       0x000000010a4ddd2d XLogFileInit.cold.6 + 65
6   postgres                       0x000000010a1af9a1 XLogFileInit + 985
7   postgres                       0x000000010a1aeb11 XLogWrite + 263
8   postgres                       0x000000010a1af125 XLogBackgroundFlush + 493
9   postgres                       0x000000010a3567e5 WalWriterMain + 534
10  postgres                       0x000000010a1c2611 AuxiliaryProcessMain + 1257
11  postgres                       0x000000010a351fde StartChildProcess + 560
12  postgres                       0x000000010a35178d reaper + 754
13  libsystem_platform.dylib       0x00007fff20351d7d _sigtramp + 29
14  ???                           000000000000000000 0 + 0
15  postgres                       0x000000010a3509e0 PostmasterMain + 4492
16  postgres                       0x000000010a2d1e77 main + 611
17  libdyld.dylib                 0x00007fff20328631 start + 1

Thread 0 crashed with X86 Thread State (64-bit):
  rax: 0x0000000000000000  rbx: 0x00000001146ebe00  rcx: 0x00007ffee5ac5ca8  rdx: 0x0000000000000000
  rdi: 0x0000000000000303  rsi: 0x0000000000000006  rbp: 0x00007ffee5ac5cd0  rsp: 0x00007ffee5ac5ca8
   r8: 0x00000000000130a8   r9: 0x00007fff88a86e68  r10: 0x00000001146ebe00  r11: 0x0000000000000246
  r12: 0x0000000000000303  r13: 0x0000000000000000  r14: 0x0000000000000006  r15: 0x0000000000000016
  rip: 0x00007fff202df462  rfl: 0x0000000000000246  cr2: 0x000000010a54e3d5
  
Logical CPU:     0
Error Code:      0x02000148
Trap Number:     133

Thread 0 instruction stream not available.

Thread 0 last branch register state not available.


Binary Images:
       0x10a136000 -        0x10a6a5fff +postgres (0) <0E4FFB38-6465-3BE0-9889-2A84B1DD7BE9> /usr/local/opt/postgresql/bin/postgres
       0x10a81d000 -        0x10a86cfff +libssl.1.1.dylib (0) <378E1E35-93EE-34E0-83B3-B93A875BEFF3> /usr/local/opt/openssl@1.1/lib/libssl.1.1.dylib
       0x10a89f000 -        0x10aa5efff +libcrypto.1.1.dylib (0) <46792733-D3D4-3DBD-9347-8C0C7EC6D50C> /usr/local/opt/openssl@1.1/lib/libcrypto.1.1.dylib
       0x10aafb000 -        0x10ab2efff +libgssapi_krb5.2.2.dylib (0) <1E044F67-F9A4-3CEC-AD9C-E0D258EB1020> /usr/local/opt/krb5/lib/libgssapi_krb5.2.2.dylib
       0x10ab4d000 -        0x10acc4fff +libicui18n.67.dylib (0) <215D80D3-0332-3BDC-B087-65FE84268507> /usr/local/opt/icu4c/lib/libicui18n.67.dylib
       0x10add2000 -        0x10aee9fff +libicuuc.67.dylib (0) <F86F3059-FF3E-3152-B8C5-425D89603FD0> /usr/local/opt/icu4c/lib/libicuuc.67.dylib
       0x10af6d000 -        0x10afe8fff +libkrb5.3.3.dylib (0) <563139A1-5E95-3BFE-9957-851D8518A214> /usr/local/Cellar/krb5/1.18.3/lib/libkrb5.3.3.dylib
       0x10b027000 -        0x10b04afff +libk5crypto.3.1.dylib (0) <7FB6731A-6D99-324C-9066-AA4449B7FE4A> /usr/local/Cellar/krb5/1.18.3/lib/libk5crypto.3.1.dylib
       0x10b057000 -        0x10b05afff +libcom_err.3.0.dylib (0) <28EA0610-6533-3891-B66C-F42915C2C995> /usr/local/Cellar/krb5/1.18.3/lib/libcom_err.3.0.dylib
       0x10b06b000 -        0x10b072fff +libkrb5support.1.1.dylib (0) <26E40839-0B40-3DE4-A9BE-6F37EAEA89B5> /usr/local/Cellar/krb5/1.18.3/lib/libkrb5support.1.1.dylib
       0x10b082000 -        0x10cb99fff +libicudata.67.dylib (0) <8E0D9287-3CCA-360C-9262-97D45F872F46> /usr/local/opt/icu4c/lib/libicudata.67.dylib
       0x114614000 -        0x1146affff  dyld (832.7.1) <2705F0D8-C104-3DE9-BEB5-B1EF6E28656D> /usr/lib/dyld
    0x7fff20046000 -     0x7fff20047fff  libsystem_blocks.dylib (78) <83E2F888-F4C1-3181-B21B-136A0D7293DD> /usr/lib/system/libsystem_blocks.dylib
    0x7fff20048000 -     0x7fff2007dfff  libxpc.dylib (2038.40.38) <DC50F7DD-1C4B-3BD2-A54D-C5D7D97A3718> /usr/lib/system/libxpc.dylib
    0x7fff2007e000 -     0x7fff20095fff  libsystem_trace.dylib (1277.50.1) <94196441-5456-342D-84D1-C60A9249D273> /usr/lib/system/libsystem_trace.dylib
    0x7fff20096000 -     0x7fff20131fff  libcorecrypto.dylib (1000.40.21) <2FA5C1BD-F41C-3FCF-B1FA-7BED6E19ABEE> /usr/lib/system/libcorecrypto.dylib
    0x7fff20132000 -     0x7fff2015efff  libsystem_malloc.dylib (317.40.8) <3688DBCE-2FFD-3F98-B12B-69ABE231908D> /usr/lib/system/libsystem_malloc.dylib
    0x7fff2015f000 -     0x7fff201a3fff  libdispatch.dylib (1271.40.12) <C55547DC-A05B-34A1-BD41-D54948D8F57F> /usr/lib/system/libdispatch.dylib
    0x7fff201a4000 -     0x7fff201dcfff  libobjc.A.dylib (818.2) <DD09F187-80F1-308F-9395-912F27E9A390> /usr/lib/libobjc.A.dylib
    0x7fff201dd000 -     0x7fff201dffff  libsystem_featureflags.dylib (28.40.2) <3E1E8F98-E791-301D-909F-4CA205C94D1A> /usr/lib/system/libsystem_featureflags.dylib
    0x7fff201e0000 -     0x7fff20268fff  libsystem_c.dylib (1439.40.11) <8D791F3A-4848-302F-88CD-46D91DE73127> /usr/lib/system/libsystem_c.dylib
    0x7fff20269000 -     0x7fff202befff  libc++.1.dylib (904.4) <E7F465AC-C8FF-31DB-8EC4-7EBBA7468EB5> /usr/lib/libc++.1.dylib
    0x7fff202bf000 -     0x7fff202d7fff  libc++abi.dylib (904.4) <253848B5-ED35-3202-8593-5DCC763A8192> /usr/lib/libc++abi.dylib
    0x7fff202d8000 -     0x7fff20306fff  libsystem_kernel.dylib (7195.50.7) <41068F5C-74E3-3C98-9256-6A18364FB5BA> /usr/lib/system/libsystem_kernel.dylib
    0x7fff20307000 -     0x7fff20312fff  libsystem_pthread.dylib (454.40.3) <78072EC6-2257-361A-AAF5-4A3C1832B5EB> /usr/lib/system/libsystem_pthread.dylib
    0x7fff20313000 -     0x7fff2034dfff  libdyld.dylib (832.7.1) <0C66AB9F-E22C-3286-B76B-DA4008698CD2> /usr/lib/system/libdyld.dylib
    0x7fff2034e000 -     0x7fff20357fff  libsystem_platform.dylib (254.40.4) <6C05D209-129A-373A-A90D-CC27AB18C091> /usr/lib/system/libsystem_platform.dylib
    0x7fff20358000 -     0x7fff20383fff  libsystem_info.dylib (542.40.3) <90DDEF9D-9DBA-3599-A9DD-A7F730AE945F> /usr/lib/system/libsystem_info.dylib
    0x7fff20384000 -     0x7fff2081ffff  com.apple.CoreFoundation (6.9 - 1770.106) <7EBD4941-5978-33EF-98FB-724BB81E92C8> /System/Library/Frameworks/CoreFoundation.framework/Versions/A/CoreFoundation
    0x7fff20820000 -     0x7fff20a4efff  com.apple.LaunchServices (1122.5.1 - 1122.5.1) <E26F607E-C523-3753-95FC-7A75130632FE> /System/Library/Frameworks/CoreServices.framework/Versions/A/Frameworks/LaunchServices.framework/Versions/A/LaunchServices
    0x7fff20a4f000 -     0x7fff20b22fff  com.apple.gpusw.MetalTools (1.0 - 1) <0CC81516-4858-3463-A2D8-8FCA414B63FD> /System/Library/PrivateFrameworks/MetalTools.framework/Versions/A/MetalTools
    0x7fff20b23000 -     0x7fff20d86fff  libBLAS.dylib (1336.40.1) <903B0DDC-4B74-3305-B81D-8E66D6AFAD04> /System/Library/Frameworks/Accelerate.framework/Versions/A/Frameworks/vecLib.framework/Versions/A/libBLAS.dylib
    0x7fff20d87000 -     0x7fff20dd4fff  com.apple.Lexicon-framework (1.0 - 86.1) <A6282972-785B-3AC4-84A5-6780315011F1> /System/Library/PrivateFrameworks/Lexicon.framework/Versions/A/Lexicon
    0x7fff20dd5000 -     0x7fff20e43fff  libSparse.dylib (106) <D2BC7FE6-7801-3C3B-B8AC-A1F152F92D12> /System/Library/Frameworks/Accelerate.framework/Versions/A/Frameworks/vecLib.framework/Versions/A/libSparse.dylib
    0x7fff20e44000 -     0x7fff20ec0fff  com.apple.SystemConfiguration (1.20 - 1.20) <660AA1E5-A70A-3FC1-9462-570FBBC76125> /System/Library/Frameworks/SystemConfiguration.framework/Versions/A/SystemConfiguration
    0x7fff20ec1000 -     0x7fff20ef6fff  libCRFSuite.dylib (50) <6873F563-F0FB-32C5-A47A-D97A4931FEA8> /usr/lib/libCRFSuite.dylib
    0x7fff20ef7000 -     0x7fff2112dfff  libmecabra.dylib (929) <CF4538C2-3F4A-360C-B6D9-DEBBA67CD5F0> /usr/lib/libmecabra.dylib
    0x7fff2112e000 -     0x7fff21491fff  com.apple.Foundation (6.9 - 1770.106) <87138770-ED31-393C-B462-4DAF1A0A52D7> /System/Library/Frameworks/Foundation.framework/Versions/C/Foundation
    0x7fff21492000 -     0x7fff2157efff  com.apple.LanguageModeling (1.0 - 247) <83FC0636-F2C6-33F1-A873-E3D5A07A9BA4> /System/Library/PrivateFrameworks/LanguageModeling.framework/Versions/A/LanguageModeling
    0x7fff221ba000 -     0x7fff22509fff  com.apple.security (7.0 - 59754.41.1) <93F55E6B-0EB7-3E06-A742-CEBE33A01DCE> /System/Library/Frameworks/Security.framework/Versions/A/Security
    0x7fff2250a000 -     0x7fff2276bfff  libicucore.A.dylib (66108) <D5A29DA5-5693-38EA-B09B-5D7160B26339> /usr/lib/libicucore.A.dylib
    0x7fff2276c000 -     0x7fff22775fff  libsystem_darwin.dylib (1439.40.11) <3BD9046F-FAED-3FD9-8191-49A4618555A3> /usr/lib/system/libsystem_darwin.dylib
    0x7fff22776000 -     0x7fff22a5dfff  com.apple.CoreServices.CarbonCore (1307 - 1307) <F20CD75D-F81D-36F3-90AE-7C2F26E01DA4> /System/Library/Frameworks/CoreServices.framework/Versions/A/Frameworks/CarbonCore.framework/Versions/A/CarbonCore
    0x7fff22a9d000 -     0x7fff22ad7fff  com.apple.CSStore (1122.5.1 - 1122.5.1) <74069AC7-3AA9-3953-A036-425105377BFF> /System/Library/PrivateFrameworks/CoreServicesStore.framework/Versions/A/CoreServicesStore
    0x7fff22ad8000 -     0x7fff22b85fff  com.apple.framework.IOKit (2.0.2 - 1845.50.1) <18A1F263-4AE2-3F9B-A38F-50BEB00B43D1> /System/Library/Frameworks/IOKit.framework/Versions/A/IOKit
    0x7fff22b86000 -     0x7fff22b91fff  libsystem_notify.dylib (279.40.4) <73D358B2-6C2D-33DF-975C-BE9EE5F45A0F> /usr/lib/system/libsystem_notify.dylib
    0x7fff23ff9000 -     0x7fff2463cfff  libnetwork.dylib (2288.40.53) <CEC9E75A-51F6-3675-9EA5-007C3DB82A7B> /usr/lib/libnetwork.dylib
    0x7fff2463d000 -     0x7fff24adafff  com.apple.CFNetwork (1207.2 - 1207.2) <B3968D35-EAF0-3661-8F93-3255128411B6> /System/Library/Frameworks/CFNetwork.framework/Versions/A/CFNetwork
    0x7fff24adb000 -     0x7fff24ae9fff  libsystem_networkextension.dylib (1295.40.29) <84A5011E-1511-30C7-86D8-514CFA59EF42> /usr/lib/system/libsystem_networkextension.dylib
    0x7fff24aea000 -     0x7fff24aeafff  libenergytrace.dylib (22) <3646415C-FA89-30B2-84C4-3FDB868DF6F6> /usr/lib/libenergytrace.dylib
    0x7fff24aeb000 -     0x7fff24b46fff  libMobileGestalt.dylib (978.40.29) <BC657BA3-6A59-35EF-8E90-26D431477F74> /usr/lib/libMobileGestalt.dylib
    0x7fff24b47000 -     0x7fff24b5dfff  libsystem_asl.dylib (385) <EB8BA94D-1B45-322E-9D26-272872423807> /usr/lib/system/libsystem_asl.dylib
    0x7fff24b5e000 -     0x7fff24b75fff  com.apple.TCC (1.0 - 1) <A3F5F853-54FC-3E67-9F8B-3605B1063D6F> /System/Library/PrivateFrameworks/TCC.framework/Versions/A/TCC
    0x7fff25e9c000 -     0x7fff2605bfff  libsqlite3.dylib (321.1) <821CC6A3-785F-3EE7-ADFA-9231367F8E09> /usr/lib/libsqlite3.dylib
    0x7fff261c0000 -     0x7fff26235fff  com.apple.AE (918 - 918) <9A914CB1-A413-352B-95BA-D639D66DC591> /System/Library/Frameworks/CoreServices.framework/Versions/A/Frameworks/AE.framework/Versions/A/AE
    0x7fff26236000 -     0x7fff2623cfff  libdns_services.dylib (1310.40.42) <5D270035-0D34-3E64-9BA3-8F302E2D767C> /usr/lib/libdns_services.dylib
    0x7fff2623d000 -     0x7fff26244fff  libsystem_symptoms.dylib (1431.40.36) <81345ED1-342F-347F-B979-39846E607C8C> /usr/lib/system/libsystem_symptoms.dylib
    0x7fff263ca000 -     0x7fff263eefff  com.apple.analyticsd (1.0 - 1) <C34AD81D-9BD0-3295-BBC5-39D762835717> /System/Library/PrivateFrameworks/CoreAnalytics.framework/Versions/A/CoreAnalytics
    0x7fff263ef000 -     0x7fff263f1fff  libDiagnosticMessagesClient.dylib (112) <BA70052F-9547-368E-A643-ACF46CA53A3F> /usr/lib/libDiagnosticMessagesClient.dylib
    0x7fff263f2000 -     0x7fff2643efff  com.apple.spotlight.metadata.utilities (1.0 - 2149.9) <732E84A3-6D75-3C92-8C0A-028547EDDF4D> /System/Library/PrivateFrameworks/MetadataUtilities.framework/Versions/A/MetadataUtilities
    0x7fff2643f000 -     0x7fff264d9fff  com.apple.Metadata (10.7.0 - 2149.9) <19EA1487-2CDE-36C6-8EC1-537E33FB8874> /System/Library/Frameworks/CoreServices.framework/Versions/A/Frameworks/Metadata.framework/Versions/A/Metadata
    0x7fff264da000 -     0x7fff264e0fff  com.apple.DiskArbitration (2.7 - 2.7) <2E613BB2-B956-3668-9B33-1464DBC83611> /System/Library/Frameworks/DiskArbitration.framework/Versions/A/DiskArbitration
    0x7fff264e1000 -     0x7fff26b87fff  com.apple.vImage (8.1 - 543) <9CFD36A4-7508-31EB-8B78-E5572F5C5426> /System/Library/Frameworks/Accelerate.framework/Versions/A/Frameworks/vImage.framework/Versions/A/vImage
    0x7fff270c7000 -     0x7fff270d6fff  com.apple.OpenDirectory (11.0 - 230.40.1) <F1AC2921-D026-3048-909D-B623F6AAFC94> /System/Library/Frameworks/OpenDirectory.framework/Versions/A/OpenDirectory
    0x7fff270d7000 -     0x7fff270f6fff  com.apple.CFOpenDirectory (11.0 - 230.40.1) <030D197F-1B82-3E26-AD80-C7621EF6656C> /System/Library/Frameworks/OpenDirectory.framework/Versions/A/Frameworks/CFOpenDirectory.framework/Versions/A/CFOpenDirectory
    0x7fff270f7000 -     0x7fff270fffff  com.apple.CoreServices.FSEvents (1290.40.2 - 1290.40.2) <EE985F8A-608D-3A9E-8DDE-C8F635DC69CC> /System/Library/Frameworks/CoreServices.framework/Versions/A/Frameworks/FSEvents.framework/Versions/A/FSEvents
    0x7fff27100000 -     0x7fff27124fff  com.apple.coreservices.SharedFileList (143 - 143) <CCD817BF-99F0-34A3-A619-8F47A1F83CC8> /System/Library/Frameworks/CoreServices.framework/Versions/A/Frameworks/SharedFileList.framework/Versions/A/SharedFileList
    0x7fff27125000 -     0x7fff27127fff  libapp_launch_measurement.dylib (14.1) <7698D7E2-ECE9-3551-AD03-381DF65EE388> /usr/lib/libapp_launch_measurement.dylib
    0x7fff27128000 -     0x7fff27170fff  com.apple.CoreAutoLayout (1.0 - 21.10.1) <14614F40-5A4F-31C0-90DC-B1FB3D8ECE66> /System/Library/PrivateFrameworks/CoreAutoLayout.framework/Versions/A/CoreAutoLayout
    0x7fff27171000 -     0x7fff27253fff  libxml2.2.dylib (34.8) <667639AF-E0DB-3BFD-B641-5D0BFBCBF6A3> /usr/lib/libxml2.2.dylib
    0x7fff28284000 -     0x7fff28294fff  libsystem_containermanager.dylib (318.41.1) <BF178091-2151-3462-AB4F-A2E111650BA2> /usr/lib/system/libsystem_containermanager.dylib
    0x7fff28295000 -     0x7fff282a6fff  com.apple.IOSurface (289.3 - 289.3) <457DD2AD-E48D-3BD3-9549-9CD9CA6B4F51> /System/Library/Frameworks/IOSurface.framework/Versions/A/IOSurface
    0x7fff282a7000 -     0x7fff282b3fff  com.apple.IOAccelerator (439.35.4 - 439.35.4) <1FC8B98E-D5A3-3C7B-919B-D187D7A6F76B> /System/Library/PrivateFrameworks/IOAccelerator.framework/Versions/A/IOAccelerator
    0x7fff282b4000 -     0x7fff283d9fff  com.apple.Metal (244.32.6 - 244.32.6) <6BB79960-68EA-3CB9-89D9-E8A11B8C9491> /System/Library/Frameworks/Metal.framework/Versions/A/Metal
    0x7fff28f37000 -     0x7fff28f92fff  com.apple.MetalPerformanceShaders.MPSCore (1.0 - 1) <A929F704-8938-3F9F-8B35-9ABDA03F4D37> /System/Library/Frameworks/MetalPerformanceShaders.framework/Versions/A/Frameworks/MPSCore.framework/Versions/A/MPSCore
    0x7fff28f93000 -     0x7fff28f96fff  libsystem_configuration.dylib (1109.40.9) <EA408233-7EA5-33B5-B099-E9609DD3A0FF> /usr/lib/system/libsystem_configuration.dylib
    0x7fff28f97000 -     0x7fff28f9bfff  libsystem_sandbox.dylib (1441.40.38) <349F71A1-4C7C-3AE0-8A1B-B95CCBB2327F> /usr/lib/system/libsystem_sandbox.dylib
    0x7fff28f9c000 -     0x7fff28f9dfff  com.apple.AggregateDictionary (1.0 - 1) <59A5FE13-BE12-3393-BC0F-40007817F8D7> /System/Library/PrivateFrameworks/AggregateDictionary.framework/Versions/A/AggregateDictionary
    0x7fff28f9e000 -     0x7fff28fa1fff  com.apple.AppleSystemInfo (3.1.5 - 3.1.5) <4CE6C43E-92B6-3933-BEE1-079336A0D6A1> /System/Library/PrivateFrameworks/AppleSystemInfo.framework/Versions/A/AppleSystemInfo
    0x7fff28fa2000 -     0x7fff28fa3fff  liblangid.dylib (136) <EB65D90D-45E3-326D-9F1E-3E9E068E64C5> /usr/lib/liblangid.dylib
    0x7fff28fa4000 -     0x7fff29044fff  com.apple.CoreNLP (1.0 - 245) <AC95402C-105B-3830-8A5B-DA9BCE1AB68B> /System/Library/PrivateFrameworks/CoreNLP.framework/Versions/A/CoreNLP
    0x7fff29045000 -     0x7fff2904bfff  com.apple.LinguisticData (1.0 - 399) <5C2C56E5-6298-32D3-B374-362D7C7F4A85> /System/Library/PrivateFrameworks/LinguisticData.framework/Versions/A/LinguisticData
    0x7fff2904c000 -     0x7fff29708fff  libBNNS.dylib (288.40.19) <C5CF6455-A81A-3B09-94F2-C8F7307E5A58> /System/Library/Frameworks/Accelerate.framework/Versions/A/Frameworks/vecLib.framework/Versions/A/libBNNS.dylib
    0x7fff29709000 -     0x7fff298dcfff  libvDSP.dylib (760.40.6) <CA559095-DE79-3932-B718-7EFE7770CDF4> /System/Library/Frameworks/Accelerate.framework/Versions/A/Frameworks/vecLib.framework/Versions/A/libvDSP.dylib
    0x7fff298dd000 -     0x7fff298effff  com.apple.CoreEmoji (1.0 - 128) <7F9AAA77-3D73-3164-8961-F0BFE55D7AE8> /System/Library/PrivateFrameworks/CoreEmoji.framework/Versions/A/CoreEmoji
    0x7fff298f0000 -     0x7fff298fafff  com.apple.IOMobileFramebuffer (343.0.0 - 343.0.0) <94F7D4E1-88DF-3445-90EF-A0EBC9AF7961> /System/Library/PrivateFrameworks/IOMobileFramebuffer.framework/Versions/A/IOMobileFramebuffer
    0x7fff29c02000 -     0x7fff29c8efff  com.apple.securityfoundation (6.0 - 55240.40.4) <AC9A369B-6E9B-3267-B56E-2746853615A0> /System/Library/Frameworks/SecurityFoundation.framework/Versions/A/SecurityFoundation
    0x7fff29c8f000 -     0x7fff29c98fff  com.apple.coreservices.BackgroundTaskManagement (1.0 - 104) <A59DD866-92E0-3B0E-AE10-36E86878132C> /System/Library/PrivateFrameworks/BackgroundTaskManagement.framework/Versions/A/BackgroundTaskManagement
    0x7fff29c99000 -     0x7fff29c9dfff  com.apple.xpc.ServiceManagement (1.0 - 1) <D522DFA0-C2D9-31EC-BC6F-8B034DACA54D> /System/Library/Frameworks/ServiceManagement.framework/Versions/A/ServiceManagement
    0x7fff29c9e000 -     0x7fff29ca0fff  libquarantine.dylib (119.40.2) <3DD7F9EE-9B9A-3896-A8CC-4D5BE49385AE> /usr/lib/system/libquarantine.dylib
    0x7fff29ca1000 -     0x7fff29cacfff  libCheckFix.dylib (31) <E66C5541-5A04-3295-BE25-CC251EC627AE> /usr/lib/libCheckFix.dylib
    0x7fff29cad000 -     0x7fff29cc4fff  libcoretls.dylib (169) <32CA60AD-6EEF-335D-8FB0-A2695D455939> /usr/lib/libcoretls.dylib
    0x7fff29cc5000 -     0x7fff29cd5fff  libbsm.0.dylib (68.40.1) <7530532D-8655-34D7-8C1A-273E196A0DE4> /usr/lib/libbsm.0.dylib
    0x7fff29cd6000 -     0x7fff29d1ffff  libmecab.dylib (929) <533290ED-7500-37B4-9212-D9BA773228F8> /usr/lib/libmecab.dylib
    0x7fff29d20000 -     0x7fff29d25fff  libgermantok.dylib (24) <14D82EB1-0212-3E80-90F5-842233FFA740> /usr/lib/libgermantok.dylib
    0x7fff29d26000 -     0x7fff29d3bfff  libLinearAlgebra.dylib (1336.40.1) <CF200364-E4AF-36A8-AB57-1ADFB6BF28B5> /System/Library/Frameworks/Accelerate.framework/Versions/A/Frameworks/vecLib.framework/Versions/A/libLinearAlgebra.dylib
    0x7fff29d3c000 -     0x7fff29f63fff  com.apple.MetalPerformanceShaders.MPSNeuralNetwork (1.0 - 1) <C08BA44C-9764-363E-A35C-B21AEEFA424B> /System/Library/Frameworks/MetalPerformanceShaders.framework/Versions/A/Frameworks/MPSNeuralNetwork.framework/Versions/A/MPSNeuralNetwork
    0x7fff29f64000 -     0x7fff29fb3fff  com.apple.MetalPerformanceShaders.MPSRayIntersector (1.0 - 1) <E7D2B0C7-FAE3-398A-B949-70A0F6CDAD75> /System/Library/Frameworks/MetalPerformanceShaders.framework/Versions/A/Frameworks/MPSRayIntersector.framework/Versions/A/MPSRayIntersector
    0x7fff29fb4000 -     0x7fff2a0fafff  com.apple.MLCompute (1.0 - 1) <0621E469-4210-3C45-AC4E-023B25E0D1CE> /System/Library/Frameworks/MLCompute.framework/Versions/A/MLCompute
    0x7fff2a0fb000 -     0x7fff2a131fff  com.apple.MetalPerformanceShaders.MPSMatrix (1.0 - 1) <328CA407-7A75-3FE6-9AC1-0D6CE0FF2B0A> /System/Library/Frameworks/MetalPerformanceShaders.framework/Versions/A/Frameworks/MPSMatrix.framework/Versions/A/MPSMatrix
    0x7fff2a132000 -     0x7fff2a16ffff  com.apple.MetalPerformanceShaders.MPSNDArray (1.0 - 1) <0CE771E3-E262-3BFC-BF02-888D7EBB0FE3> /System/Library/Frameworks/MetalPerformanceShaders.framework/Versions/A/Frameworks/MPSNDArray.framework/Versions/A/MPSNDArray
    0x7fff2a170000 -     0x7fff2a200fff  com.apple.MetalPerformanceShaders.MPSImage (1.0 - 1) <4130FBE4-C36C-3E1D-BB0B-63D1A64B28E2> /System/Library/Frameworks/MetalPerformanceShaders.framework/Versions/A/Frameworks/MPSImage.framework/Versions/A/MPSImage
    0x7fff2a201000 -     0x7fff2a210fff  com.apple.AppleFSCompression (125 - 1.0) <5BE26EB2-6012-33E5-AF38-D8C5F4DF64CA> /System/Library/PrivateFrameworks/AppleFSCompression.framework/Versions/A/AppleFSCompression
    0x7fff2a211000 -     0x7fff2a21efff  libbz2.1.0.dylib (44) <F171593B-230C-390E-8EF7-D0659D2F6B54> /usr/lib/libbz2.1.0.dylib
    0x7fff2a21f000 -     0x7fff2a223fff  libsystem_coreservices.dylib (127) <670DDFEB-8100-3C51-BC96-76BD46A21DF6> /usr/lib/system/libsystem_coreservices.dylib
    0x7fff2a224000 -     0x7fff2a251fff  com.apple.CoreServices.OSServices (1122.5.1 - 1122.5.1) <4F03F324-1072-38B8-8BC5-837601C2DBA9> /System/Library/Frameworks/CoreServices.framework/Versions/A/Frameworks/OSServices.framework/Versions/A/OSServices
    0x7fff2a427000 -     0x7fff2a439fff  libz.1.dylib (76) <0AF4F195-1F20-3F59-B09F-31E7249890D5> /usr/lib/libz.1.dylib
    0x7fff2a43a000 -     0x7fff2a481fff  libsystem_m.dylib (3186.40.2) <0276200D-C6F2-3E79-AFDC-E4D7F60A7837> /usr/lib/system/libsystem_m.dylib
    0x7fff2a482000 -     0x7fff2a482fff  libcharset.1.dylib (59) <56962263-B7B8-3B84-9C2F-F493D9D2630A> /usr/lib/libcharset.1.dylib
    0x7fff2a483000 -     0x7fff2a488fff  libmacho.dylib (973.4) <F2E3F7A6-B15A-30ED-A6AD-4EFEC37CF3E7> /usr/lib/system/libmacho.dylib
    0x7fff2a489000 -     0x7fff2a4a4fff  libkxld.dylib (7195.50.7) <6FFE0801-7BDA-34EE-89E9-EAEC21A7394C> /usr/lib/system/libkxld.dylib
    0x7fff2a4a5000 -     0x7fff2a4b0fff  libcommonCrypto.dylib (60178.40.2) <66E10FDF-896D-35F4-B9A8-8EE9400AC23A> /usr/lib/system/libcommonCrypto.dylib
    0x7fff2a4b1000 -     0x7fff2a4bbfff  libunwind.dylib (200.10) <BD13DE19-15F8-3982-ACCB-CD8C036D5D2B> /usr/lib/system/libunwind.dylib
    0x7fff2a4bc000 -     0x7fff2a4c3fff  liboah.dylib (203.1.3) <5EC28751-3BE8-3BB7-9DBE-305225CBD41B> /usr/lib/liboah.dylib
    0x7fff2a4c4000 -     0x7fff2a4cefff  libcopyfile.dylib (173.40.2) <17A9CD2E-0527-3FF7-9CFA-57B30133DFB5> /usr/lib/system/libcopyfile.dylib
    0x7fff2a4cf000 -     0x7fff2a4d6fff  libcompiler_rt.dylib (102.2) <FE958653-7FEC-3ADD-9AC0-A386E47208CF> /usr/lib/system/libcompiler_rt.dylib
    0x7fff2a4d7000 -     0x7fff2a4d9fff  libsystem_collections.dylib (1439.40.11) <31C10DA5-F9B8-36E4-B859-8F6B845FF65D> /usr/lib/system/libsystem_collections.dylib
    0x7fff2a4da000 -     0x7fff2a4dcfff  libsystem_secinit.dylib (87.40.10) <BB2A70F5-BECC-34BD-90FE-14D31C5FD80D> /usr/lib/system/libsystem_secinit.dylib
    0x7fff2a4dd000 -     0x7fff2a4dffff  libremovefile.dylib (49.40.3) <24CE2291-AEB3-30C9-94E8-535AA6E9C6F2> /usr/lib/system/libremovefile.dylib
    0x7fff2a4e0000 -     0x7fff2a4e0fff  libkeymgr.dylib (31) <B47F66C0-27F4-3B77-BAA0-85E895A7421D> /usr/lib/system/libkeymgr.dylib
    0x7fff2a4e1000 -     0x7fff2a4e8fff  libsystem_dnssd.dylib (1310.40.42) <F54EC6FB-DEC3-3DA8-A749-4892F50D1F08> /usr/lib/system/libsystem_dnssd.dylib
    0x7fff2a4e9000 -     0x7fff2a4eefff  libcache.dylib (83) <C83C4423-D12A-32A0-875D-81450DF40F42> /usr/lib/system/libcache.dylib
    0x7fff2a4ef000 -     0x7fff2a4f0fff  libSystem.B.dylib (1292.50.1) <14E3BB7B-B95F-3700-8D12-B9B2012C0AF8> /usr/lib/libSystem.B.dylib
    0x7fff2a4f1000 -     0x7fff2a4f4fff  libfakelink.dylib (3) <6E8ABD0B-6BC7-3E2C-B36B-2A7DA4ED0804> /usr/lib/libfakelink.dylib
    0x7fff2a4f5000 -     0x7fff2a4f5fff  com.apple.SoftLinking (1.0 - 1) <23011830-946E-312B-A4BA-1725568F5E76> /System/Library/PrivateFrameworks/SoftLinking.framework/Versions/A/SoftLinking
    0x7fff2a4f6000 -     0x7fff2a52dfff  libpcap.A.dylib (98.40.1) <F2D9427C-C7D7-35F9-8A65-AE2C76D73E4B> /usr/lib/libpcap.A.dylib
    0x7fff2a52e000 -     0x7fff2a61efff  libiconv.2.dylib (59) <BFC929D5-6E2C-3A49-9760-870BC89FC558> /usr/lib/libiconv.2.dylib
    0x7fff2a61f000 -     0x7fff2a630fff  libcmph.dylib (8) <ABEA25CF-8895-31DA-B884-F4012007E7E9> /usr/lib/libcmph.dylib
    0x7fff2a631000 -     0x7fff2a6a2fff  libarchive.2.dylib (83.40.4) <54E0F2AE-C7F5-34A6-8B09-82FED0643886> /usr/lib/libarchive.2.dylib
    0x7fff2a6a3000 -     0x7fff2a70afff  com.apple.SearchKit (1.4.1 - 1.4.1) <E51D4AB5-0576-3392-B45F-E9CA02D22ED5> /System/Library/Frameworks/CoreServices.framework/Versions/A/Frameworks/SearchKit.framework/Versions/A/SearchKit
    0x7fff2a70b000 -     0x7fff2a70cfff  libThaiTokenizer.dylib (3) <41BFE684-D7B8-3DBB-A3F6-E25DB819E86A> /usr/lib/libThaiTokenizer.dylib
    0x7fff2a70d000 -     0x7fff2a734fff  com.apple.applesauce (1.0 - 16.26) <0AFF7A71-EE52-36E6-82B5-459459D99D68> /System/Library/PrivateFrameworks/AppleSauce.framework/Versions/A/AppleSauce
    0x7fff2a735000 -     0x7fff2a74cfff  libapple_nghttp2.dylib (1.41) <94E600F0-740B-308D-9475-8720FFB1923E> /usr/lib/libapple_nghttp2.dylib
    0x7fff2a74d000 -     0x7fff2a75ffff  libSparseBLAS.dylib (1336.40.1) <7A917514-DD2C-3A97-A29B-F41BDCA18852> /System/Library/Frameworks/Accelerate.framework/Versions/A/Frameworks/vecLib.framework/Versions/A/libSparseBLAS.dylib
    0x7fff2a760000 -     0x7fff2a761fff  com.apple.MetalPerformanceShaders.MetalPerformanceShaders (1.0 - 1) <CC090B4C-48B8-3DE1-84FA-807642C38DF9> /System/Library/Frameworks/MetalPerformanceShaders.framework/Versions/A/MetalPerformanceShaders
    0x7fff2a762000 -     0x7fff2a766fff  libpam.2.dylib (28.40.1) <4C7D4B94-5CBA-3480-9BA0-D52B5C675D2A> /usr/lib/libpam.2.dylib
    0x7fff2a767000 -     0x7fff2a77ffff  libcompression.dylib (96.40.6) <C84DBB3A-EDEB-3871-BB2F-AB682A0653F8> /usr/lib/libcompression.dylib
    0x7fff2a780000 -     0x7fff2a785fff  libQuadrature.dylib (7) <C13CA095-EE2D-3C50-98E5-A3570323776F> /System/Library/Frameworks/Accelerate.framework/Versions/A/Frameworks/vecLib.framework/Versions/A/libQuadrature.dylib
    0x7fff2a786000 -     0x7fff2ab22fff  libLAPACK.dylib (1336.40.1) <5A406319-C3A7-3D73-93C2-9968ACC81241> /System/Library/Frameworks/Accelerate.framework/Versions/A/Frameworks/vecLib.framework/Versions/A/libLAPACK.dylib
    0x7fff2ab23000 -     0x7fff2ab71fff  com.apple.DictionaryServices (1.2 - 341) <CBFBB0CC-093A-39AC-99E3-C032029AC7C3> /System/Library/Frameworks/CoreServices.framework/Versions/A/Frameworks/DictionaryServices.framework/Versions/A/DictionaryServices
    0x7fff2ab72000 -     0x7fff2ab8afff  liblzma.5.dylib (16) <7AEA0ACB-B03C-323B-AD4F-C5BD0584D780> /usr/lib/liblzma.5.dylib
    0x7fff2ab8b000 -     0x7fff2ab8cfff  libcoretls_cfhelpers.dylib (169) <86671710-F263-3ED2-8B7D-0052264682CF> /usr/lib/libcoretls_cfhelpers.dylib
    0x7fff2ab8d000 -     0x7fff2ac87fff  com.apple.APFS (1677.50.1 - 1677.50.1) <CBABD7ED-84C7-3F72-80EB-5F8AED435566> /System/Library/PrivateFrameworks/APFS.framework/Versions/A/APFS
    0x7fff2ac88000 -     0x7fff2ac95fff  libxar.1.dylib (452) <8999C952-D05A-3BFA-A673-1EB0B27EBB73> /usr/lib/libxar.1.dylib
    0x7fff2ac96000 -     0x7fff2ac99fff  libutil.dylib (58.40.2) <ECE0C079-2434-3B7E-89EE-B2E538E7BBAD> /usr/lib/libutil.dylib
    0x7fff2ac9a000 -     0x7fff2acc2fff  libxslt.1.dylib (17.2) <7C79FCBB-B6B4-33A4-BD4B-34D674C2866F> /usr/lib/libxslt.1.dylib
    0x7fff2acc3000 -     0x7fff2accdfff  libChineseTokenizer.dylib (37) <F2ECD480-D020-3141-A3B0-D32C8EDA159F> /usr/lib/libChineseTokenizer.dylib
    0x7fff2acce000 -     0x7fff2ad8cfff  libvMisc.dylib (760.40.6) <3CA6964F-742A-33C1-90BB-C8B2D1BF0A4D> /System/Library/Frameworks/Accelerate.framework/Versions/A/Frameworks/vecLib.framework/Versions/A/libvMisc.dylib
    0x7fff2cd92000 -     0x7fff2cdaafff  libresolv.9.dylib (68) <6C18FE1C-EB05-3E02-925D-DE09157C55F9> /usr/lib/libresolv.9.dylib
    0x7fff2cdab000 -     0x7fff2cdbefff  libsasl2.2.dylib (214) <C0EBD583-8C32-3BB2-9433-103A749C0DF8> /usr/lib/libsasl2.2.dylib
    0x7fff2d91a000 -     0x7fff2d91afff  liblaunch.dylib (2038.40.38) <D71781B5-4034-3349-BBE5-4B796CD3629A> /usr/lib/system/liblaunch.dylib
    0x7fff2fdb8000 -     0x7fff2fdb8fff  libsystem_product_info_filter.dylib (8.40.1) <FF59B842-1290-3C4A-9015-AC972563406E> /usr/lib/system/libsystem_product_info_filter.dylib
    0x7fff2fe93000 -     0x7fff2fe93fff  com.apple.Accelerate.vecLib (3.11 - vecLib 3.11) <BBCF1D0C-F727-3B9B-801E-FCEA6C9C1103> /System/Library/Frameworks/Accelerate.framework/Versions/A/Frameworks/vecLib.framework/Versions/A/vecLib
    0x7fff2feba000 -     0x7fff2febafff  com.apple.CoreServices (1122.5.1 - 1122.5.1) <070D2800-D014-34E3-AAA9-CB7199EFC728> /System/Library/Frameworks/CoreServices.framework/Versions/A/CoreServices
    0x7fff30188000 -     0x7fff30188fff  com.apple.Accelerate (1.11 - Accelerate 1.11) <5D5F6FDF-38E5-363A-A73C-3C21A2D11574> /System/Library/Frameworks/Accelerate.framework/Versions/A/Accelerate
    0x7fff301f5000 -     0x7fff301f9fff  com.apple.AppleSRP (5.0 - 1) <663CC9B2-670B-3F1C-9C42-E8242A040287> /System/Library/PrivateFrameworks/AppleSRP.framework/Versions/A/AppleSRP
    0x7fff301fa000 -     0x7fff30205fff  com.apple.frameworks.CoreDaemon (1.3 - 1.3) <73EEC846-DC76-30EB-9D43-7D311452D440> /System/Library/PrivateFrameworks/CoreDaemon.framework/Versions/B/CoreDaemon
    0x7fff32c4b000 -     0x7fff32c82fff  com.apple.LDAPFramework (2.4.28 - 194.5) <1D3EE3B4-47EA-3EA4-9D9B-8BE68438C97E> /System/Library/Frameworks/LDAP.framework/Versions/A/LDAP
    0x7fff6b396000 -     0x7fff6b39cfff  libCoreFSCache.dylib (177.22) <F2BD275B-0979-3426-BC9D-60C22E4FDE1C> /System/Library/Frameworks/OpenGL.framework/Versions/A/Libraries/libCoreFSCache.dylib

External Modification Summary:
  Calls made by other processes targeting this process:
    task_for_pid: 4797
    thread_create: 0
    thread_set_state: 0
  Calls made by this process:
    task_for_pid: 0
    thread_create: 0
    thread_set_state: 0
  Calls made by all processes on this machine:
    task_for_pid: 64783104
    thread_create: 0
    thread_set_state: 0

VM Region Summary:
ReadOnly portion of Libraries: Total=606.8M resident=0K(0%) swapped_out_or_unallocated=606.8M(100%)
Writable regions: Total=63.8M written=0K(0%) resident=0K(0%) swapped_out=0K(0%) unallocated=63.8M(100%)
 
                                VIRTUAL   REGION 
REGION TYPE                        SIZE    COUNT (non-coalesced) 
===========                     =======  ======= 
Kernel Alloc Once                    8K        1 
MALLOC                            40.2M       19 
MALLOC guard page                   16K        3 
STACK GUARD                       56.0M        1 
Stack                             8192K        1 
VM_ALLOCATE                       15.0M        2 
__DATA                            2916K      158 
__DATA_CONST                      6936K      106 
__DATA_DIRTY                       286K       59 
__LINKEDIT                       487.1M       23 
__OBJC_RO                         61.0M        1 
__OBJC_RW                         2468K        2 
__TEXT                           119.8M      159 
__UNICODE                          588K        1 
shared memory                        8K        2 
===========                     =======  ======= 
TOTAL                            800.1M      538 

Postgres.log:

2021-01-24 21:26:31.949 GMT [81020] PANIC:  XX000: could not open file "pg_wal/00000001000000F300000011": Interrupted system call
2021-01-24 21:26:31.949 GMT [81020] LOCATION:  XLogFileInit, xlog.c:3277
2021-01-24 21:26:31.951 GMT [81013] LOG:  00000: WAL writer process (PID 81020) was terminated by signal 6: Abort trap: 6
2021-01-24 21:26:31.951 GMT [81013] LOCATION:  LogChildExit, postmaster.c:3753
2021-01-24 21:26:31.951 GMT [81013] LOG:  00000: terminating any other active server processes
2021-01-24 21:26:31.951 GMT [81013] LOCATION:  HandleChildCrash, postmaster.c:3474
2021-01-24 21:26:31.951 GMT [81046] WARNING:  57P02: terminating connection because of crash of another server process
2021-01-24 21:26:31.951 GMT [81046] DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2021-01-24 21:26:31.951 GMT [81046] HINT:  In a moment you should be able to reconnect to the database and repeat your command.
2021-01-24 21:26:31.951 GMT [81046] LOCATION:  quickdie, postgres.c:2802
2021-01-24 21:26:31.951 GMT [81024] WARNING:  57P02: terminating connection because of crash of another server process
2021-01-24 21:26:31.951 GMT [81024] DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2021-01-24 21:26:31.951 GMT [81024] HINT:  In a moment you should be able to reconnect to the database and repeat your command.
2021-01-24 21:26:31.951 GMT [81024] LOCATION:  quickdie, postgres.c:2802
2021-01-24 21:26:31.951 GMT [81021] WARNING:  57P02: terminating connection because of crash of another server process
2021-01-24 21:26:31.951 GMT [81021] DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2021-01-24 21:26:31.951 GMT [81021] HINT:  In a moment you should be able to reconnect to the database and repeat your command.
2021-01-24 21:26:31.951 GMT [81021] LOCATION:  quickdie, postgres.c:2802
2021-01-24 21:26:31.951 GMT [81025] WARNING:  57P02: terminating connection because of crash of another server process
2021-01-24 21:26:31.951 GMT [81025] DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2021-01-24 21:26:31.951 GMT [81025] HINT:  In a moment you should be able to reconnect to the database and repeat your command.
2021-01-24 21:26:31.951 GMT [81025] LOCATION:  quickdie, postgres.c:2802
2021-01-24 21:26:31.961 GMT [81955] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:31.961 GMT [81955] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:31.962 GMT [81013] LOG:  00000: all server processes terminated; reinitializing
2021-01-24 21:26:31.962 GMT [81013] LOCATION:  PostmasterStateMachine, postmaster.c:4010
2021-01-24 21:26:31.970 GMT [81956] LOG:  00000: database system was interrupted; last known up at 2021-01-24 21:26:13 GMT
2021-01-24 21:26:31.970 GMT [81956] LOCATION:  StartupXLOG, xlog.c:6387
2021-01-24 21:26:32.519 GMT [81957] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:32.519 GMT [81957] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:32.520 GMT [81958] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:32.520 GMT [81958] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:33.509 GMT [81959] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:33.509 GMT [81959] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:33.515 GMT [81960] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:33.515 GMT [81960] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:33.524 GMT [81961] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:33.524 GMT [81961] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:33.533 GMT [81962] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:33.533 GMT [81962] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:34.517 GMT [81963] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:34.517 GMT [81963] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:34.522 GMT [81964] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:34.522 GMT [81964] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:34.531 GMT [81965] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:34.531 GMT [81965] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:34.539 GMT [81966] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:34.539 GMT [81966] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:35.254 GMT [81956] LOG:  00000: database system was not properly shut down; automatic recovery in progress
2021-01-24 21:26:35.254 GMT [81956] LOCATION:  StartupXLOG, xlog.c:6903
2021-01-24 21:26:35.261 GMT [81956] LOG:  00000: redo starts at F2/6C040368
2021-01-24 21:26:35.261 GMT [81956] LOCATION:  StartupXLOG, xlog.c:7179
2021-01-24 21:26:35.510 GMT [81967] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:35.510 GMT [81967] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:35.516 GMT [81968] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:35.516 GMT [81968] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:36.523 GMT [81969] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:36.523 GMT [81969] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:36.528 GMT [81970] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:36.528 GMT [81970] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:36.536 GMT [81971] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:36.536 GMT [81971] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:36.543 GMT [81972] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:36.543 GMT [81972] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:37.534 GMT [81974] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:37.534 GMT [81974] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:37.538 GMT [81975] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:37.538 GMT [81975] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:37.546 GMT [81976] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:37.546 GMT [81976] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:37.552 GMT [81977] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:37.552 GMT [81977] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:38.546 GMT [81978] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:38.546 GMT [81978] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:38.551 GMT [81979] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:38.551 GMT [81979] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:38.559 GMT [81980] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:38.559 GMT [81980] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:38.563 GMT [81981] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:38.563 GMT [81981] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:39.555 GMT [81982] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:39.555 GMT [81982] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:39.560 GMT [81983] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:39.560 GMT [81983] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:39.574 GMT [81984] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:39.574 GMT [81984] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:39.581 GMT [81985] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:39.581 GMT [81985] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:40.549 GMT [81986] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:40.549 GMT [81986] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:40.554 GMT [81987] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:40.554 GMT [81987] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:40.561 GMT [81988] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:40.561 GMT [81988] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:40.569 GMT [81989] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:40.569 GMT [81989] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:41.546 GMT [81990] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:41.546 GMT [81990] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:41.551 GMT [81991] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:41.551 GMT [81991] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:41.557 GMT [81992] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:41.557 GMT [81992] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:41.565 GMT [81993] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:41.565 GMT [81993] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:42.583 GMT [81995] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:42.583 GMT [81995] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:42.588 GMT [81996] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:42.588 GMT [81996] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:42.594 GMT [81997] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:42.594 GMT [81997] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:42.599 GMT [81998] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:42.599 GMT [81998] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:43.559 GMT [81999] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:43.559 GMT [81999] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:43.563 GMT [82000] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:43.563 GMT [82000] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:43.568 GMT [82001] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:43.568 GMT [82001] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:43.574 GMT [82002] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:43.574 GMT [82002] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:44.409 GMT [81956] LOG:  00000: redo done at F3/11957090
2021-01-24 21:26:44.409 GMT [81956] LOCATION:  StartupXLOG, xlog.c:7441
2021-01-24 21:26:44.581 GMT [82004] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:44.581 GMT [82004] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:44.587 GMT [82005] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:44.587 GMT [82005] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:44.595 GMT [82006] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:44.595 GMT [82006] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:44.606 GMT [82007] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:44.606 GMT [82007] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:45.558 GMT [82008] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:45.558 GMT [82008] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:45.561 GMT [82009] FATAL:  57P03: the database system is in recovery mode
2021-01-24 21:26:45.561 GMT [82009] LOCATION:  ProcessStartupPacket, postmaster.c:2328
2021-01-24 21:26:45.927 GMT [81013] LOG:  00000: database system is ready to accept connections
2021-01-24 21:26:45.927 GMT [81013] LOCATION:  reaper, postmaster.c:3061


On 23 Jan 2021, at 15:42, Ricardo Ungureanu <ricardoungureanu@gmail.com> wrote:

Hi,

@Kimon, do you have an antivirus installed or an EndpointSecurity
Daemon running? I managed to get this crash only when my
EndpointSecurity Daemon was up and running.
Perhaps the problem is more generic (maybe when the import is very
large. My database is only 10GB) if you can replicate without the
EndpointSecurity framework running.

În vin., 22 ian. 2021 la 19:35, Andres Freund <andres@anarazel.de> a scris:

Hi,

Tom, all, this seems like a serious problem likely to become more
widespread. I don't really know how we can reasonably address this
short-term, adding EINTR handling to all the places that don't yet have
it (and ensuring that it stays that way) seems like it's a lot to backport.

There's just been another report of this at
https://postgr.es/m/16832-943d33fd58eb26e4%40postgresql.org

On 2021-01-16 19:30:52 +0200, Ricardo Ungureanu wrote:
În vin., 15 ian. 2021 la 23:05, Andres Freund <andres@anarazel.de> a scris:

Hi,

On 2021-01-15 14:00:03 +0000, PG Bug reporting form wrote:
I am using macOS 11.0 and trying to import a large dump into postgresql.
Under some circumstances, it crashes while importing.
I inspected the logs and found out a system call is interrupted (" LOG:
could not open file "pg_wal": Interrupted system call"). Apple has added a
new feature in macOS 11.0 to audit security events. I noticed that the
kernel, while waiting on a condition variable, if it receives an interrupt,
will just pass EINTR (error code 4) back to the usermode program. Your
function XLogFileInit does not treat such cases (just ENOENT is checked) and
decides to exit with an abort(). I have attached below the crash file
generated.

Hm. It's fairly nasty to return EINTR from open() (except if open()ing a
FIFO or such) - it should normally only happen when blocked. But I'm not
sure it's *actually* violating any standards / promises made.

There are two kinds of security events which Apple supports: AUTH and
NOTIFY. AUTH means that the system call is blocked (on that condition
variable I mentioned about), and the user mode daemon is asked about
the generated event: "postgres, pid 999, open() on file /path/file
with flags 0x400003" - something like that. The usermode can either
allow or deny the event by replying. If it decides to block this
system call, the return code seen by the target process (in this case,
postgres) is -1 (operation not permitted) .
On the other hand, NOTIFY events will only log the event, without
requesting a verdict (allow or deny).
In my scenario, usermode daemon responsible for auditing these events
is set to ALLOW everything. If I denied the system call I would see in
postgres log "operation not permitted (err 1)" insead of 'Interrupted
system call (err 4)").

Does this happens in the default configuration of OSX now? Or is this
something you have manually set up? If manual, why?

For me it happens in the default configuration when I start my
EndpointSecurity Daemon and just allow every action.
However, the bug might be more generic and could happen when the
system is overloaded. Let's see if Kimon has an antivirus installed or
any other software using EndpointSecurity Framework.

Isn't forcing a back-forth context switch for a syscall as common as
open(2) to that auth demon *terrible* for performance?
It is, but Apple does not seem to care at all. From my performance
testing, (without any event processing at all) I see an impact of
30-40%.

To sum up, the open() is blocked, waiting for a verdict from the
usermode, meanwhile an interrupt is triggered, msleep on the condition
variable returns EINTR and this is passed back to postgres as the
return code of open().

[1] https://developer.apple.com/documentation/endpointsecurity/es_event_type_t

I don't understand how Apple is expecting this to not cause breakage
left and right? Just about no software has EINTR handling for every
syscall (as SA_RESTART is enough), so this seems like it'll lead to a
long tail of bugs.


Apple has added a new feature in macOS 11.0 to audit security
events. I noticed that the kernel, while waiting on a condition
variable, if it receives an interrupt, will just pass EINTR (error
code 4) back to the usermode program.

Does that also happen for close()? Because that can't reasonably be
handled by userspace (userspace cannot retry because the fd could now
point to something else in a threaded environment).

Good point, however the close event is not supported as AUTH, only as
NOTIFY. Thus, this cannot happen on close().
Open() and other file system calls are both AUTH and NOTIFY (you can
choose which one to enable).
You can read more about this here[1]

Well, that's at least something.

Greetings,

Andres Freund

Regards,
Ricardo

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: BUG #16794: BEFORE UPDATE FOR EACH ROW triggers on partitioned tables can break tuple moving UPDATEs
Следующее
От: bchen90
Дата:
Сообщение: Re: BUG #16817: kill process cause postmaster hang