Opened log file 'c:/cirrus/crashlog-postgres.exe_1ab4_2024-08-30_19-52-47-106.txt' . 0 Id: 17f8.19b4 Suspend: 1 Teb: 00000043`76f7a000 Unfrozen Child-SP RetAddr Call Site 00000043`773fc9d0 00007ff7`f6eba158 ucrtbased!abort(void)+0x5a [minkernel\crts\ucrt\src\appcrt\startup\abort.cpp @ 77] 00000043`773fca10 00007ff7`f67a366a postgres!ExceptionalCondition( char * conditionName = 0x00007ff7`f7223b68 "!BTScanPosIsPinned(so->currPos)", char * fileName = 0x00007ff7`f7223bf0 "../src/backend/access/nbtree/nbtsearch.c", int lineNumber = 0n2266)+0x78 [c:\cirrus\src\backend\utils\error\assert.c @ 67] 00000043`773fca50 00007ff7`f67a3248 postgres!_bt_readnextpage( struct IndexScanDescData * scan = 0x00000241`7d8c8f10, unsigned int blkno = 1, unsigned int expectNext = 2, ScanDirection dir = BackwardScanDirection (0n-1))+0x3ea [c:\cirrus\src\backend\access\nbtree\nbtsearch.c @ 2266] 00000043`773fcac0 00007ff7`f67a0f4b postgres!_bt_steppage( struct IndexScanDescData * scan = 0x00000241`7d8c8f10, ScanDirection dir = BackwardScanDirection (0n-1))+0x5e8 [c:\cirrus\src\backend\access\nbtree\nbtsearch.c @ 2163] 00000043`773fcb20 00007ff7`f679bfd9 postgres!_bt_first( struct IndexScanDescData * scan = 0x00000241`7d8c8f10, ScanDirection dir = BackwardScanDirection (0n-1))+0x10bb [c:\cirrus\src\backend\access\nbtree\nbtsearch.c @ 1461] 00000043`773fdfb0 00007ff7`f678961c postgres!btgettuple( struct IndexScanDescData * scan = 0x00000241`7d8c8f10, ScanDirection dir = BackwardScanDirection (0n-1))+0x89 [c:\cirrus\src\backend\access\nbtree\nbtree.c @ 225] 00000043`773fdff0 00007ff7`f6e32831 postgres!index_getnext_tid( struct IndexScanDescData * scan = 0x00000241`7d8c8f10, ScanDirection direction = BackwardScanDirection (0n-1))+0x15c [c:\cirrus\src\backend\access\index\indexam.c @ 590] 00000043`773fe040 00007ff7`f6e326fd postgres!get_actual_variable_endpoint( struct RelationData * heapRel = 0x00000241`7d06fa10, struct RelationData * indexRel = 0x00000241`7d0b0e70, ScanDirection indexscandir = BackwardScanDirection (0n-1), struct ScanKeyData * scankeys = 0x00000043`773fe330, short typLen = 0n4, bool typByVal = true, struct TupleTableSlot * tableslot = 0x00000241`7d8c8e00, struct MemoryContextData * outercontext = 0x00000241`7cddc560, unsigned int64 * endpointDatum = 0x00000241`7d9cc790)+0xd1 [c:\cirrus\src\backend\utils\adt\selfuncs.c @ 6349] 00000043`773fe270 00007ff7`f6e28f33 postgres!get_actual_variable_range( struct PlannerInfo * root = 0x00000241`7d9cae08, struct VariableStatData * vardata = 0x00000043`773fe6b0, unsigned int sortop = 0x61, unsigned int collation = 0, unsigned int64 * min = 0x00000000`00000000, unsigned int64 * max = 0x00000241`7d9cc790)+0x43d [c:\cirrus\src\backend\utils\adt\selfuncs.c @ 6228] 00000043`773fe390 00007ff7`f6e32f23 postgres!ineq_histogram_selectivity( struct PlannerInfo * root = 0x00000241`7d9cae08, struct VariableStatData * vardata = 0x00000043`773fe6b0, unsigned int opoid = 0x20b, struct FmgrInfo * opproc = 0x00000043`773fe600, bool isgt = false, bool iseq = true, unsigned int collation = 0, unsigned int64 constval = 0x5f5e10a, unsigned int consttype = 0x17)+0x253 [c:\cirrus\src\backend\utils\adt\selfuncs.c @ 1129] 00000043`773fe560 00007ff7`f6e33241 postgres!scalarineqsel( struct PlannerInfo * root = 0x00000241`7d9cae08, unsigned int operator = 0x20b, bool isgt = false, bool iseq = true, unsigned int collation = 0, struct VariableStatData * vardata = 0x00000043`773fe6b0, unsigned int64 constval = 0x5f5e10a, unsigned int consttype = 0x17)+0x393 [c:\cirrus\src\backend\utils\adt\selfuncs.c @ 688] 00000043`773fe640 00007ff7`f6e241e8 postgres!scalarineqsel_wrapper( struct FunctionCallInfoBaseData * fcinfo = 0x00000043`773fe780, bool isgt = false, bool iseq = true)+0x241 [c:\cirrus\src\backend\utils\adt\selfuncs.c @ 1459] 00000043`773fe710 00007ff7`f6ec5433 postgres!scalarlesel( struct FunctionCallInfoBaseData * fcinfo = 0x00000043`773fe780)+0x18 [c:\cirrus\src\backend\utils\adt\selfuncs.c @ 1483] 00000043`773fe740 00007ff7`f6ec629c postgres!FunctionCall4Coll( struct FmgrInfo * flinfo = 0x00000043`773fe830, unsigned int collation = 0, unsigned int64 arg1 = 0x00000241`7d9cae08, unsigned int64 arg2 = 0x20b, unsigned int64 arg3 = 0x00000241`7d9cb478, unsigned int64 arg4 = 0)+0x153 [c:\cirrus\src\backend\utils\fmgr\fmgr.c @ 1213] 00000043`773fe800 00007ff7`f6af9f32 postgres!OidFunctionCall4Coll( unsigned int functionId = 0x150, unsigned int collation = 0, unsigned int64 arg1 = 0x00000241`7d9cae08, unsigned int64 arg2 = 0x20b, unsigned int64 arg3 = 0x00000241`7d9cb478, unsigned int64 arg4 = 0)+0x5c [c:\cirrus\src\backend\utils\fmgr\fmgr.c @ 1450] 00000043`773fe870 00007ff7`f6a6bad2 postgres!restriction_selectivity( struct PlannerInfo * root = 0x00000241`7d9cae08, unsigned int operatorid = 0x20b, struct List * args = 0x00000241`7d9cb478, unsigned int inputcollid = 0, int varRelid = 0n0)+0xa2 [c:\cirrus\src\backend\optimizer\util\plancat.c @ 1963] 00000043`773fe8e0 00007ff7`f6a6c184 postgres!clause_selectivity_ext( struct PlannerInfo * root = 0x00000241`7d9cae08, struct Node * clause = 0x00000241`7d9cb518, int varRelid = 0n0, JoinType jointype = JOIN_INNER (0n0), struct SpecialJoinInfo * sjinfo = 0x00000000`00000000, bool use_extended_stats = true)+0x542 [c:\cirrus\src\backend\optimizer\path\clausesel.c @ 848] 00000043`773fe9b0 00007ff7`f6a6bf10 postgres!clauselist_selectivity_ext( struct PlannerInfo * root = 0x00000241`7d9cae08, struct List * clauses = 0x00000241`7d9cc0a0, int varRelid = 0n0, JoinType jointype = JOIN_INNER (0n0), struct SpecialJoinInfo * sjinfo = 0x00000000`00000000, bool use_extended_stats = true)+0x264 [c:\cirrus\src\backend\optimizer\path\clausesel.c @ 183] 00000043`773feaa0 00007ff7`f6a74bad postgres!clauselist_selectivity( struct PlannerInfo * root = 0x00000241`7d9cae08, struct List * clauses = 0x00000241`7d9cc0a0, int varRelid = 0n0, JoinType jointype = JOIN_INNER (0n0), struct SpecialJoinInfo * sjinfo = 0x00000000`00000000)+0x40 [c:\cirrus\src\backend\optimizer\path\clausesel.c @ 108] 00000043`773feae0 00007ff7`f6a666c1 postgres!set_baserel_size_estimates( struct PlannerInfo * root = 0x00000241`7d9cae08, struct RelOptInfo * rel = 0x00000241`7cdde270)+0x5d [c:\cirrus\src\backend\optimizer\path\costsize.c @ 5285] 00000043`773feb30 00007ff7`f6a662bb postgres!set_plain_rel_size( struct PlannerInfo * root = 0x00000241`7d9cae08, struct RelOptInfo * rel = 0x00000241`7cdde270, struct RangeTblEntry * rte = 0x00000241`7cddd728)+0x31 [c:\cirrus\src\backend\optimizer\path\allpaths.c @ 582] 00000043`773feb60 00007ff7`f6a660cd postgres!set_rel_size( struct PlannerInfo * root = 0x00000241`7d9cae08, struct RelOptInfo * rel = 0x00000241`7cdde270, unsigned int rti = 1, struct RangeTblEntry * rte = 0x00000241`7cddd728)+0x11b [c:\cirrus\src\backend\optimizer\path\allpaths.c @ 413] 00000043`773feba0 00007ff7`f6a64182 postgres!set_base_rel_sizes( struct PlannerInfo * root = 0x00000241`7d9cae08)+0xdd [c:\cirrus\src\backend\optimizer\path\allpaths.c @ 323] 00000043`773febf0 00007ff7`f6aafbdb postgres!make_one_rel( struct PlannerInfo * root = 0x00000241`7d9cae08, struct List * joinlist = 0x00000241`7d9cbea0)+0x22 [c:\cirrus\src\backend\optimizer\path\allpaths.c @ 199] 00000043`773fec40 00007ff7`f6ab3925 postgres!query_planner( struct PlannerInfo * root = 0x00000241`7d9cae08, * qp_callback = 0x00007ff7`f6ab7450, void * qp_extra = 0x00000043`773fef60)+0x36b [c:\cirrus\src\backend\optimizer\plan\planmain.c @ 280] 00000043`773feca0 00007ff7`f6ab2b77 postgres!grouping_planner( struct PlannerInfo * root = 0x00000241`7d9cae08, double tuple_fraction = 0, struct SetOperationStmt * setops = 0x00000000`00000000)+0x5f5 [c:\cirrus\src\backend\optimizer\plan\planner.c @ 1520] 00000043`773fefb0 00007ff7`f6ab0f49 postgres!subquery_planner( struct PlannerGlobal * glob = 0x00000241`7cddd408, struct Query * parse = 0x00000241`7cddd518, struct PlannerInfo * parent_root = 0x00000000`00000000, bool hasRecursion = false, double tuple_fraction = 0, struct SetOperationStmt * setops = 0x00000000`00000000)+0x11d7 [c:\cirrus\src\backend\optimizer\plan\planner.c @ 1095] 00000043`773ff140 00007ff7`f6ab020c postgres!standard_planner( struct Query * parse = 0x00000241`7cddd518, char * query_string = 0x00000241`7cddc660 "DELETE FROM transition_table_level1. WHERE level1_no BETWEEN 100000000 AND 100000010;", int cursorOptions = 0n2048, struct ParamListInfoData * boundParams = 0x00000000`00000000)+0x2b9 [c:\cirrus\src\backend\optimizer\plan\planner.c @ 415] 00000043`773ff280 00007ff7`f6c84454 postgres!planner( struct Query * parse = 0x00000241`7cddd518, char * query_string = 0x00000241`7cddc660 "DELETE FROM transition_table_level1. WHERE level1_no BETWEEN 100000000 AND 100000010;", int cursorOptions = 0n2048, struct ParamListInfoData * boundParams = 0x00000000`00000000)+0x5c [c:\cirrus\src\backend\optimizer\plan\planner.c @ 282] 00000043`773ff2c0 00007ff7`f6c8466a postgres!pg_plan_query( struct Query * querytree = 0x00000241`7cddd518, char * query_string = 0x00000241`7cddc660 "DELETE FROM transition_table_level1. WHERE level1_no BETWEEN 100000000 AND 100000010;", int cursorOptions = 0n2048, struct ParamListInfoData * boundParams = 0x00000000`00000000)+0x84 [c:\cirrus\src\backend\tcop\postgres.c @ 912] 00000043`773ff310 00007ff7`f6c8846e postgres!pg_plan_queries( struct List * querytrees = 0x00000241`7cdde220, char * query_string = 0x00000241`7cddc660 "DELETE FROM transition_table_level1. WHERE level1_no BETWEEN 100000000 AND 100000010;", int cursorOptions = 0n2048, struct ParamListInfoData * boundParams = 0x00000000`00000000)+0x15a [c:\cirrus\src\backend\tcop\postgres.c @ 1006] 00000043`773ff380 00007ff7`f6c85e69 postgres!exec_simple_query( char * query_string = 0x00000241`7cddc660 "DELETE FROM transition_table_level1. WHERE level1_no BETWEEN 100000000 AND 100000010;")+0x43e [c:\cirrus\src\backend\tcop\postgres.c @ 1203] 00000043`773ff4c0 00007ff7`f6c7fd9d postgres!PostgresMain( char * dbname = 0x00000241`7c3c58f8 "regression", char * username = 0x00000241`7c419740 "SYSTEM")+0x8e9 [c:\cirrus\src\backend\tcop\postgres.c @ 4770] 00000043`773ff6d0 00007ff7`f6b84947 postgres!BackendMain( char * startup_data = 0x00000241`7c3c58e0 "", unsigned int64 startup_data_len = 4)+0x11d [c:\cirrus\src\backend\tcop\backend_startup.c @ 108] 00000043`773ff710 00007ff7`f6a46674 postgres!SubPostmasterMain( int argc = 0n3, char ** argv = 0x00000241`7c3a2d00)+0x2a7 [c:\cirrus\src\backend\postmaster\launch_backend.c @ 677] 00000043`773ff780 00007ff7`f702d8e9 postgres!main( int argc = 0n3, char ** argv = 0x00000241`7c3a2d00)+0x2f4 [c:\cirrus\src\backend\main\main.c @ 189] 00000043`773ff7c0 00007ff7`f702d83e postgres!invoke_main(void)+0x39 [D:\a\_work\1\s\src\vctools\crt\vcstartup\src\startup\exe_common.inl @ 79] 00000043`773ff810 00007ff7`f702d6fe postgres!__scrt_common_main_seh(void)+0x12e [D:\a\_work\1\s\src\vctools\crt\vcstartup\src\startup\exe_common.inl @ 288] 00000043`773ff880 00007ff7`f702d95e postgres!__scrt_common_main(void)+0xe [D:\a\_work\1\s\src\vctools\crt\vcstartup\src\startup\exe_common.inl @ 331] 00000043`773ff8b0 00007ffe`400b4cb0 postgres!mainCRTStartup( void * __formal = 0x00000043`76f79000)+0xe [D:\a\_work\1\s\src\vctools\crt\vcstartup\src\startup\exe_main.cpp @ 17] 00000043`773ff8e0 00007ffe`411feceb KERNEL32!BaseThreadInitThunk+0x10 00000043`773ff910 00000000`00000000 ntdll!RtlUserThreadStart+0x2b 1 Id: 17f8.157c Suspend: 1 Teb: 00000043`76f7c000 Unfrozen Child-SP RetAddr Call Site 00000043`777ff888 00007ffe`4118b77f ntdll!NtWaitForWorkViaWorkerFactory+0x14 00000043`777ff890 00007ffe`400b4cb0 ntdll!TppWorkerThread+0x2df 00000043`777ffb80 00007ffe`411feceb KERNEL32!BaseThreadInitThunk+0x10 00000043`777ffbb0 00000000`00000000 ntdll!RtlUserThreadStart+0x2b 2 Id: 17f8.1954 Suspend: 1 Teb: 00000043`76f7e000 Unfrozen Child-SP RetAddr Call Site 00000043`77bffbd8 00007ffe`3e9545ca ntdll!NtFsControlFile+0x14 00000043`77bffbe0 00007ff7`f6b78dbb KERNELBASE!ConnectNamedPipe+0x6a 00000043`77bffc50 00007ffe`400b4cb0 postgres!pg_signal_thread( void * param = 0x00000000`00000000)+0xcb [c:\cirrus\src\backend\port\win32\signal.c @ 306] 00000043`77bffd50 00007ffe`411feceb KERNEL32!BaseThreadInitThunk+0x10 00000043`77bffd80 00000000`00000000 ntdll!RtlUserThreadStart+0x2b 3 Id: 17f8.f98 Suspend: 1 Teb: 00000043`76f80000 Unfrozen Child-SP RetAddr Call Site 00000043`77fffd58 00007ffe`3e90d71e ntdll!NtWaitForSingleObject+0x14 00000043`77fffd60 00007ff7`f6b7a85c KERNELBASE!WaitForSingleObjectEx+0x8e 00000043`77fffe00 00007ffe`400b4cb0 postgres!pg_timer_thread( void * param = 0x00000000`00000000)+0x4c [c:\cirrus\src\backend\port\win32\timer.c @ 48] 00000043`77fffe40 00007ffe`411feceb KERNEL32!BaseThreadInitThunk+0x10 00000043`77fffe70 00000000`00000000 ntdll!RtlUserThreadStart+0x2b 4 Id: 17f8.15bc Suspend: 1 Teb: 00000043`76f82000 Unfrozen Child-SP RetAddr Call Site 00000043`783ff468 00007ffe`4118b77f ntdll!NtWaitForWorkViaWorkerFactory+0x14 00000043`783ff470 00007ffe`400b4cb0 ntdll!TppWorkerThread+0x2df 00000043`783ff760 00007ffe`411feceb KERNEL32!BaseThreadInitThunk+0x10 00000043`783ff790 00000000`00000000 ntdll!RtlUserThreadStart+0x2b PEB at 0000004376f79000 InheritedAddressSpace: No ReadImageFileExecOptions: No BeingDebugged: Yes ImageBaseAddress: 00007ff7f66e0000 NtGlobalFlag: 0 NtGlobalFlag2: 0 Ldr 00007ffe412f4140 Ldr.Initialized: Yes Ldr.InInitializationOrderModuleList: 000002417c396f30 . 000002417c403d50 Ldr.InLoadOrderModuleList: 000002417c39b190 . 000002417c403d30 Ldr.InMemoryOrderModuleList: 000002417c39b1a0 . 000002417c403d40 Base TimeStamp Module 7ff7f66e0000 66d2228c Aug 30 19:50:36 2024 C:\cirrus\build\tmp_install\usr\local\pgsql\bin\postgres.exe 7ffe41180000 86a81be0 Aug 03 17:35:28 2041 C:\Windows\SYSTEM32\ntdll.dll 7ffe400a0000 681d822d May 09 04:18:53 2025 C:\Windows\System32\KERNEL32.DLL 7ffe3e8d0000 7f062417 Jul 13 14:41:27 2037 C:\Windows\System32\KERNELBASE.dll 7ffe3f240000 56e83747 Mar 15 16:24:39 2016 C:\Windows\System32\WS2_32.dll 7ffe407c0000 b05e085f Oct 07 03:15:43 2063 C:\Windows\System32\RPCRT4.dll 7ffe3f120000 dc811887 Mar 25 16:25:43 2087 C:\Windows\System32\WLDAP32.dll 7ffe3e700000 eb78ec60 Mar 10 04:43:12 2095 C:\Windows\System32\ucrtbase.dll 7ffe40700000 8b666989 Feb 10 19:18:33 2044 C:\Windows\System32\ADVAPI32.dll 7ffe3f190000 68e1e0af Oct 05 03:06:23 2025 C:\Windows\System32\msvcrt.dll 7ffe3f2d0000 00dbe574 Jun 16 19:05:24 1970 C:\Windows\System32\sechost.dll 7ffe3ef60000 3bdd8bbd Oct 29 17:02:53 2001 C:\Windows\System32\bcrypt.dll 7ffe2a6d0000 6514993f Sep 27 21:06:07 2023 C:\Windows\SYSTEM32\libssl-1_1-x64.dll 7ffe2a1c0000 6514991d Sep 27 21:05:33 2023 C:\Windows\SYSTEM32\libcrypto-1_1-x64.dll 7ffe40550000 fcfa269f Jun 30 06:58:39 2104 C:\Windows\System32\USER32.dll 7ffe3ef30000 2979174f Jan 19 06:14:39 1992 C:\Windows\System32\win32u.dll 7ffe40a30000 784b1edd Dec 14 16:03:41 2033 C:\Windows\System32\GDI32.dll 7ffe3ef90000 1e551d70 Feb 15 23:36:16 1986 C:\Windows\System32\gdi32full.dll 7ffe3ec40000 e46c287d Jun 10 05:58:21 2091 C:\Windows\System32\msvcp_win.dll 7ffe306b0000 c3642e5c Nov 17 05:36:28 2073 C:\Windows\SYSTEM32\Secur32.dll 7ffe2b450000 653aa20c Oct 26 17:29:48 2023 C:\Windows\SYSTEM32\VCRUNTIME140D.dll 7ffe2a780000 b6102be9 Oct 17 03:52:09 2066 C:\Windows\SYSTEM32\ucrtbased.dll 7ffe2b890000 653aa20c Oct 26 17:29:48 2023 C:\Windows\SYSTEM32\VCRUNTIME140.dll 7ffe3e0b0000 8199e7b5 Nov 26 01:19:49 2038 C:\Windows\SYSTEM32\SSPICLI.DLL 7ffe3dc00000 06d626ed Aug 20 12:32:45 1973 C:\Windows\system32\mswsock.dll 7ffe2b440000 7406c981 Sep 08 02:44:17 2031 C:\Windows\system32\wshunix.dll 7ffe3de50000 ab2bdb14 Jan 01 04:07:48 2061 C:\Windows\SYSTEM32\CRYPTSP.dll 7ffe3d740000 0ca66aee Sep 22 09:35:42 1976 C:\Windows\system32\rsaenh.dll 7ffe3de70000 889c9ae0 Aug 18 08:50:40 2042 C:\Windows\SYSTEM32\CRYPTBASE.dll 7ffe3eeb0000 d2c5908f Jan 20 19:29:19 2082 C:\Windows\System32\bcryptPrimitives.dll 7ffe2ba10000 66d22295 Aug 30 19:50:45 2024 C:\cirrus\build\tmp_install\usr\local\pgsql\lib\plpgsql.dll SubSystemData: 0000000000000000 ProcessHeap: 000002417c390000 ProcessParameters: 000002417c39d360 CurrentDirectory: 'C:\cirrus\build\testrun\pg_upgrade\002_pg_upgrade\data\t_002_pg_upgrade_old_node_data\pgdata\' WindowTitle: 'C:\cirrus\build\tmp_install\usr\local\pgsql\bin\postgres.exe' ImageFile: 'C:\cirrus\build\tmp_install\usr\local\pgsql\bin\postgres.exe' CommandLine: '"C:/cirrus/build/tmp_install/usr/local/pgsql/bin/postgres.exe" --forkchild="backend" 5044' DllPath: '< Name not readable >' Environment: 000002417c3911f0 =C:=C:\cirrus\build\testrun\pg_upgrade\002_pg_upgrade\data\t_002_pg_upgrade_old_node_data\pgdata ALLUSERSPROFILE=C:\ProgramData APPDATA=C:\Windows\system32\config\systemprofile\AppData\Roaming ASAN_OPTIONS=halt_on_error=1:abort_on_error=1:print_summary=1 BRANCH=cf/5222 CCACHE_MAXSIZE=250M CHECK=check-world PROVE_FLAGS=--timer CHECKFLAGS=-Otarget CHOCOLATEYINSTALL=C:\ProgramData\chocolatey CI=true CIRRUS_ARCH=amd64 CIRRUS_BRANCH=cf/5222 CIRRUS_BUILD_ID=6439730861047808 CIRRUS_BUILD_SOURCE=github CIRRUS_CHANGE_IN_REPO=7edb6221a305dd829e6fcd29b59e208c551653a5 CIRRUS_CHANGE_MESSAGE=[CF 49/5222] v2 - Avoiding superfluous buffer locking during nbtree backwards scans This commit was automatically generated by a robot at cfbot.cputube.org. It is based on patches submitted to the PostgreSQL mailing lists and registered in the PostgreSQL Commitfest application. This branch will be overwritten each time a new patch version is posted to the email thread, and also periodically to check for bitrot caused by changes on the master branch. Commitfest entry: https://commitfest.postgresql.org/49/5222 Patch(es): https://www.postgresql.org/message-id/CAEze2WiTkPgGfH+PgqFJS4inhH1-+XeTup6VxRMiy5zG5XZc1A@mail.gmail.com Author(s): Matthias van de Meent CIRRUS_CHANGE_TIMESTAMP=1725047246000 CIRRUS_CHANGE_TITLE=[CF 49/5222] v2 - Avoiding superfluous buffer locking during nbtree backwards scans CIRRUS_CI=true CIRRUS_CLONE_DEPTH=500 CIRRUS_COMMIT_MESSAGE=[CF 49/5222] v2 - Avoiding superfluous buffer locking during nbtree backwards scans This commit was automatically generated by a robot at cfbot.cputube.org. It is based on patches submitted to the PostgreSQL mailing lists and registered in the PostgreSQL Commitfest application. This branch will be overwritten each time a new patch version is posted to the email thread, and also periodically to check for bitrot caused by changes on the master branch. Commitfest entry: https://commitfest.postgresql.org/49/5222 Patch(es): https://www.postgresql.org/message-id/CAEze2WiTkPgGfH+PgqFJS4inhH1-+XeTup6VxRMiy5zG5XZc1A@mail.gmail.com Author(s): Matthias van de Meent CIRRUS_CPU=4 CIRRUS_DEFAULT_BRANCH=master CIRRUS_ENV=C:\Windows\SystemTemp\cirrus-env-task-5100826279018496-f945f3c9-db35-42a4-910e-71cd9e8f899a CIRRUS_HTTP_CACHE_HOST=127.0.0.1:12321 CIRRUS_LOG_TIMESTAMP=true CIRRUS_OIDC_TOKEN=eyJraWQiOiJBdjFqQVlqUE54a3g0YUpfVHloeVU0c3p6VXBQMVlXdE0yTEJIckF0ZWgwIiwidHlwIjoiSldUIiwiYWxnIjoiUlMyNTYifQ.eyJvd25lciI6InBvc3RncmVzcWwtY2Zib3QiLCJ0YXNrX25hbWUiOiJXaW5kb3dzIC0gU2VydmVyIDIwMTksIFZTIDIwMTkgLSBNZXNvbiAmIG5pbmphIiwic3ViIjoicmVwbzpnaXRodWI6cG9zdGdyZXNxbC1jZmJvdC9wb3N0Z3Jlc3FsIiwib3duZXJfaWQiOiIzMTE3MzEwNyIsInJlcG9zaXRvcnlfdmlzaWJpbGl0eSI6InB1YmxpYyIsImlzcyI6Imh0dHBzOi8vb2lkYy5jaXJydXMtY2kuY29tIiwidGFza19pZCI6IjUxMDA4MjYyNzkwMTg0OTYiLCJyZXBvc2l0b3J5IjoicG9zdGdyZXNxbCIsImJyYW5jaCI6ImNmLzUyMjIiLCJwbGF0Zm9ybSI6ImdpdGh1YiIsImF1ZCI6Imh0dHBzOi8vY2lycnVzLWNpLmNvbS9naXRodWIvcG9zdGdyZXNxbC1jZmJvdCIsIm5iZiI6MTcyNTA0NzM1MCwiYnVpbGRfaWQiOiI2NDM5NzMwODYxMDQ3ODA4IiwidXNlcl9wZXJtaXNzaW9uIjoiYWRtaW4iLCJyZXBvc2l0b3J5X2lkIjoiNTMwOTQyOTkxMjQzNjczNiIsImV4cCI6MTcyNTA1MTU1MCwiaWF0IjoxNzI1MDQ3MzUwLCJ1c2VyX2NvbGxhYm9yYXRvciI6InRydWUiLCJqdGkiOiI3NTc3YWI1Ni05ZjdmLTQ4ZmEtOWVmNC05MDUyNjcwMzYxYWIiLCJjaGFuZ2VfaW5fcmVwbyI6IjdlZGI2MjIxYTMwNWRkODI5ZTZmY2QyOWI1OWUyMDhjNTUxNjUzYTUifQ.D-WF-uP_wlZnoj6gNf1mJcJqOqX5kiFPlO2dsQ3jROAKjqZC6o6mms6Ljgo0O9hsbX-vIO0i3ABWeWo2zCBQzJnYKxAZCh9Xqp6s-4UA6mnVm3w15yQQRdyG2LSaBOucPJXjJreAMI4OwB1gconnFTa9Te9406Ef7Hq99K0Ful9UCxfDxVs8Pzu9BpVIywZZQyPeE-FSmiYfInEfJI5y8ar3tEku5UeZk8x7d_aP5tvkx92aab_7SHZeNM39dw26-rytxrsbkNIvH0d8zj5Asj-b2c2w7EAdZT8b75ykwB7I_KnLd1A78ylwI6a4sq7Q9yIvvzlpInizXD_SD1KK5w CIRRUS_OS=windows CIRRUS_REPO_CLONE_HOST=github.com CIRRUS_REPO_CLONE_TOKEN=ghs_6u1WGDuz3uOZdrLT0estVvHdlj0vfx2Lqnyt CIRRUS_REPO_CLONE_URL=https://github.com/postgresql-cfbot/postgresql.git CIRRUS_REPO_FULL_NAME=postgresql-cfbot/postgresql CIRRUS_REPO_ID=5309429912436736 CIRRUS_REPO_NAME=postgresql CIRRUS_REPO_OWNER=postgresql-cfbot CIRRUS_RESOLUTION_STRATEGY=SAME_SHA CIRRUS_TASK_ID=5100826279018496 CIRRUS_TASK_NAME=Windows - Server 2019, VS 2019 - Meson & ninja CIRRUS_USER_COLLABORATOR=true CIRRUS_USER_PERMISSION=admin CIRRUS_WINDOWS_ERROR_MODE=0x8001 CIRRUS_WORKING_DIR=c:/cirrus CI_NODE_INDEX=5 CI_NODE_TOTAL=8 COMMANDPROMPTTYPE=Native COMMONPROGRAMFILES=C:\Program Files\Common Files COMMONPROGRAMFILES(X86)=C:\Program Files (x86)\Common Files COMMONPROGRAMW6432=C:\Program Files\Common Files COMPUTERNAME=BUILD-PG-CI-WIN COMSPEC=C:\Windows\system32\cmd.exe CONTAINER_REPO=us-docker.pkg.dev/pg-ci-images/ci CONTINUOUS_INTEGRATION=true CPUS=4 DEFAULT_PERL_VERSION=5.26.3.1 DEVENVDIR=C:\BuildTools\Common7\IDE\ DISK_SIZE=50 DRIVERDATA=C:\Windows\System32\Drivers\DriverData EXTENSIONSDKDIR=C:\Program Files (x86)\Microsoft SDKs\Windows Kits\10\ExtensionSDKs FRAMEWORK40VERSION=v4.0 FRAMEWORKDIR=C:\Windows\Microsoft.NET\Framework64\ FRAMEWORKDIR64=C:\Windows\Microsoft.NET\Framework64\ FRAMEWORKVERSION=v4.0.30319 FRAMEWORKVERSION64=v4.0.30319 GCP_PROJECT=pg-ci-images GITHUB_CHECK_SUITE_ID=27814619119 GOOGETROOT=C:\ProgramData\GooGet IMAGE_FAMILY=pg-ci-windows-ci IMAGE_IDENTITY=pg-ci-windows-ci-2024-08-29t00-33-37 IMAGE_PROJECT=pg-ci-images INCLUDE=C:\BuildTools\VC\Tools\MSVC\14.29.30133\include;C:\Program Files (x86)\Windows Kits\10\include\10.0.20348.0\ucrt;C:\Program Files (x86)\Windows Kits\10\include\10.0.20348.0\shared;C:\Program Files (x86)\Windows Kits\10\include\10.0.20348.0\um;C:\Program Files (x86)\Windows Kits\10\include\10.0.20348.0\winrt;C:\Program Files (x86)\Windows Kits\10\include\10.0.20348.0\cppwinrt INITDB_TEMPLATE=C:/cirrus/build/tmp_install/initdb-template LANG=en_US.UTF-8 LC_COLLATE=C LC_CTYPE=C LC_MESSAGES=C LC_MONETARY=C LC_NUMERIC=C LC_TIME=C LIB=C:\BuildTools\VC\Tools\MSVC\14.29.30133\lib\x64;C:\Program Files (x86)\Windows Kits\10\lib\10.0.20348.0\ucrt\x64;C:\Program Files (x86)\Windows Kits\10\lib\10.0.20348.0\um\x64 LIBPATH=C:\BuildTools\VC\Tools\MSVC\14.29.30133\lib\x64;C:\BuildTools\VC\Tools\MSVC\14.29.30133\lib\x86\store\references;C:\Program Files (x86)\Windows Kits\10\UnionMetadata\10.0.20348.0;C:\Program Files (x86)\Windows Kits\10\References\10.0.20348.0;C:\Windows\Microsoft.NET\Framework64\v4.0.30319 LOCALAPPDATA=C:\Windows\system32\config\systemprofile\AppData\Local MALLOC_PERTURB_=126 MESON_TEST_ITERATION=1 MSAN_OPTIONS=halt_on_error=1:abort_on_error=1:print_summary=1:print_stacktrace=1 MSYSTEM=UCRT64 MTEST_ARGS=--print-errorlogs --no-rebuild -C build NUMBER_OF_PROCESSORS=4 OS=Windows_NT PATH=C:\cirrus\build\tmp_install\usr\local\pgsql\bin;C:\cirrus\build\src\bin\pg_upgrade;C:/cirrus/build/src/bin/pg_upgrade/test;C:\BuildTools\VC\Tools\MSVC\14.29.30133\bin\HostX64\x64;C:\BuildTools\MSBuild\Current\bin\Roslyn;C:\Program Files (x86)\Windows Kits\10\bin\10.0.20348.0\x64;C:\Program Files (x86)\Windows Kits\10\bin\x64;C:\BuildTools\\MSBuild\Current\Bin;C:\Windows\Microsoft.NET\Framework64\v4.0.30319;C:\BuildTools\Common7\IDE\;C:\BuildTools\Common7\Tools\;C:\BuildTools\VC\Auxiliary\Build;C:\zstd\zstd-v1.5.2-win64;C:\zlib;C:\lz4;C:\icu;C:\winflexbison;C:\strawberry\5.26.3.1\perl\bin;C:\python\Scripts\;C:\python\;C:\Windows Kits\10\Debuggers\x64;C:\Program Files\Git\usr\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\ProgramData\GooGet;C:\Program Files\Google\Compute Engine\metadata_scripts;C:\Program Files (x86)\Google\Cloud SDK\google-cloud-sdk\bin;C:\Program Files\PowerShell\7\;C:\Program Files\Google\Compute Engine\sysprep;C:\ProgramData\chocolatey\bin;C:\Program Files\Git\cmd;C:\Program Files\Git\mingw64\bin;C:\Program Files\Git\usr\bin;C:\Windows\system32\config\systemprofile\AppData\Local\Microsoft\WindowsApps PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC;.PY;.PYW;.CPL PGCTLTIMEOUT=120 PGDATA=C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata PGDATABASE=postgres PGHOST=C:/Windows/TEMP/sDelnOFYbk PGPORT=21356 PGSYSCONFDIR=C:/cirrus/build/tmp_install/usr/local/pgsql/etc PG_REGRESS=C:\cirrus\build\src/test\regress\pg_regress.exe PG_REGRESS_SOCK_DIR=c:/cirrus/ PG_TEST_EXTRA=kerberos ldap ssl libpq_encryption load_balance PG_TEST_USE_UNIX_SOCKETS=1 PLATFORM=x64 POWERSHELL_DISTRIBUTION_CHANNEL=MSI:Windows Server 2022 Datacenter PROCESSOR_ARCHITECTURE=AMD64 PROCESSOR_IDENTIFIER=AMD64 Family 25 Model 1 Stepping 0, AuthenticAMD PROCESSOR_LEVEL=25 PROCESSOR_REVISION=0100 PROGRAMDATA=C:\ProgramData PROGRAMFILES=C:\Program Files PROGRAMFILES(X86)=C:\Program Files (x86) PROGRAMW6432=C:\Program Files PROMPT=$P$G PROVE_FLAGS=--timer PSEXECUTIONPOLICYPREFERENCE=Unrestricted PSMODULEPATH=C:\Program Files\WindowsPowerShell\Modules;C:\Windows\system32\WindowsPowerShell\v1.0\Modules;C:\Program Files (x86)\Google\Cloud SDK\google-cloud-sdk\platform\PowerShell PUBLIC=C:\Users\Public REGRESS_SHLIB=C:\cirrus\build\src/test\regress\regress.dll REPO_CI_CONFIG_GIT_URL=github.com/postgresql-cfbot/ci-config/gcp_and_macos_workers.yml@main SYSTEMDRIVE=C: SYSTEMROOT=C:\Windows TAR=c:/windows/system32/tar.exe TEMP=C:\Windows\TEMP TEMP_CONFIG=c:/cirrus/src/tools/ci/pg_ci_base.conf TERM=xterm-256color TEST2_ACTIVE=1 TESTDATADIR=C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data TESTLOGDIR=C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\log TEST_ACTIVE=1 TEST_JOBS=8 TMP=C:\Windows\TEMP UBSAN_OPTIONS=halt_on_error=1:abort_on_error=1:print_summary=1:print_stacktrace=1 UCRTVERSION=10.0.20348.0 UNIVERSALCRTSDKDIR=C:\Program Files (x86)\Windows Kits\10\ USERDOMAIN=WORKGROUP USERNAME=BUILD-PG-CI-WIN$ USERPROFILE=C:\Windows\system32\config\systemprofile VCIDEINSTALLDIR=C:\BuildTools\Common7\IDE\VC\ VCINSTALLDIR=C:\BuildTools\VC\ VCTOOLSINSTALLDIR=C:\BuildTools\VC\Tools\MSVC\14.29.30133\ VCTOOLSREDISTDIR=C:\BuildTools\VC\Redist\MSVC\14.29.30133\ VCTOOLSVERSION=14.29.30133 VISUALSTUDIOVERSION=16.0 VS160COMNTOOLS=C:\BuildTools\Common7\Tools\ VSCMD_ARG_APP_PLAT=Desktop VSCMD_ARG_HOST_ARCH=x64 VSCMD_ARG_TGT_ARCH=x64 VSCMD_VER=16.11.39 VSINSTALLDIR=C:\BuildTools\ WINDIR=C:\Windows WINDOWSLIBPATH=C:\Program Files (x86)\Windows Kits\10\UnionMetadata\10.0.20348.0;C:\Program Files (x86)\Windows Kits\10\References\10.0.20348.0 WINDOWSSDKBINPATH=C:\Program Files (x86)\Windows Kits\10\bin\ WINDOWSSDKDIR=C:\Program Files (x86)\Windows Kits\10\ WINDOWSSDKLIBVERSION=10.0.20348.0\ WINDOWSSDKVERBINPATH=C:\Program Files (x86)\Windows Kits\10\bin\10.0.20348.0\ WINDOWSSDKVERSION=10.0.20348.0\ WITH_ICU=no __DOTNET_ADD_64BIT=1 __DOTNET_PREFERRED_BITNESS=64 __VSCMD_PREINIT_PATH=C:\BuildTools\VC\Auxiliary\Build;C:\zstd\zstd-v1.5.2-win64;C:\zlib;C:\lz4;C:\icu;C:\winflexbison;C:\strawberry\5.26.3.1\perl\bin;C:\python\Scripts\;C:\python\;C:\Windows Kits\10\Debuggers\x64;C:\Program Files\Git\usr\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\ProgramData\GooGet;C:\Program Files\Google\Compute Engine\metadata_scripts;C:\Program Files (x86)\Google\Cloud SDK\google-cloud-sdk\bin;C:\Program Files\PowerShell\7\;C:\Program Files\Google\Compute Engine\sysprep;C:\ProgramData\chocolatey\bin;C:\Program Files\Git\cmd;C:\Program Files\Git\mingw64\bin;C:\Program Files\Git\usr\bin;C:\Windows\system32\config\systemprofile\AppData\Local\Microsoft\WindowsApps; Closing open log file c:/cirrus/crashlog-postgres.exe_1ab4_2024-08-30_19-52-47-106.txt