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

From: Kimon Krenz <kimon(dot)krenz(at)part9(dot)com>
To: Ricardo Ungureanu <ricardoungureanu(at)gmail(dot)com>
Cc: Andres Freund <andres(at)anarazel(dot)de>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #16827: macOS interrupted syscall leads to a crash
Date: 2021-01-24 23:03:13
Message-ID: AD89582F-39D0-4A52-96A7-82105B4DF4C3@part9.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)1(dot)1/lib/libssl.1.1.dylib
0x10a89f000 - 0x10aa5efff +libcrypto.1.1.dylib (0) <46792733-D3D4-3DBD-9347-8C0C7EC6D50C> /usr/local/opt/openssl(at)1(dot)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(at)gmail(dot)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(at)anarazel(dot)de <mailto:andres(at)anarazel(dot)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(at)anarazel(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message bchen90 2021-01-25 01:01:04 Re: BUG #16817: kill process cause postmaster hang
Previous Message Noah Misch 2021-01-24 02:27:43 Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data