Opened log file 'c:/cirrus/crashlog-postgres.exe_0900_2024-09-01_17-27-00-744.txt' . 0 Id: 248.1b90 Suspend: 1 Teb: 00000092`7da34000 Unfrozen Child-SP RetAddr Call Site 00000092`7dffcfc0 00007ff7`9ae49f38 ucrtbased!abort(void)+0x5a [minkernel\crts\ucrt\src\appcrt\startup\abort.cpp @ 77] 00000092`7dffd000 00007ff7`9a73366a postgres!ExceptionalCondition( char * conditionName = 0x00007ff7`9b1b3b68 "!BTScanPosIsPinned(so->currPos)", char * fileName = 0x00007ff7`9b1b3bf0 "../src/backend/access/nbtree/nbtsearch.c", int lineNumber = 0n2266)+0x78 [c:\cirrus\src\backend\utils\error\assert.c @ 67] 00000092`7dffd040 00007ff7`9a733248 postgres!_bt_readnextpage( struct IndexScanDescData * scan = 0x00000204`4dcbfad0, unsigned int blkno = 1, unsigned int expectNext = 2, ScanDirection dir = BackwardScanDirection (0n-1))+0x3ea [c:\cirrus\src\backend\access\nbtree\nbtsearch.c @ 2266] 00000092`7dffd0b0 00007ff7`9a730f4b postgres!_bt_steppage( struct IndexScanDescData * scan = 0x00000204`4dcbfad0, ScanDirection dir = BackwardScanDirection (0n-1))+0x5e8 [c:\cirrus\src\backend\access\nbtree\nbtsearch.c @ 2163] 00000092`7dffd110 00007ff7`9a72bfd9 postgres!_bt_first( struct IndexScanDescData * scan = 0x00000204`4dcbfad0, ScanDirection dir = BackwardScanDirection (0n-1))+0x10bb [c:\cirrus\src\backend\access\nbtree\nbtsearch.c @ 1461] 00000092`7dffe5a0 00007ff7`9a71961c postgres!btgettuple( struct IndexScanDescData * scan = 0x00000204`4dcbfad0, ScanDirection dir = BackwardScanDirection (0n-1))+0x89 [c:\cirrus\src\backend\access\nbtree\nbtree.c @ 225] 00000092`7dffe5e0 00007ff7`9adc2611 postgres!index_getnext_tid( struct IndexScanDescData * scan = 0x00000204`4dcbfad0, ScanDirection direction = BackwardScanDirection (0n-1))+0x15c [c:\cirrus\src\backend\access\index\indexam.c @ 590] 00000092`7dffe630 00007ff7`9adc24dd postgres!get_actual_variable_endpoint( struct RelationData * heapRel = 0x00000204`4e3b77a8, struct RelationData * indexRel = 0x00000204`4e3b6e48, ScanDirection indexscandir = BackwardScanDirection (0n-1), struct ScanKeyData * scankeys = 0x00000092`7dffe920, short typLen = 0n4, bool typByVal = true, struct TupleTableSlot * tableslot = 0x00000204`4dcbf9c0, struct MemoryContextData * outercontext = 0x00000204`4d296730, unsigned int64 * endpointDatum = 0x00000204`4dec95b0)+0xd1 [c:\cirrus\src\backend\utils\adt\selfuncs.c @ 6349] 00000092`7dffe860 00007ff7`9adb8d13 postgres!get_actual_variable_range( struct PlannerInfo * root = 0x00000204`4dec7c28, struct VariableStatData * vardata = 0x00000092`7dffeca0, unsigned int sortop = 0x61, unsigned int collation = 0, unsigned int64 * min = 0x00000000`00000000, unsigned int64 * max = 0x00000204`4dec95b0)+0x43d [c:\cirrus\src\backend\utils\adt\selfuncs.c @ 6228] 00000092`7dffe980 00007ff7`9adc2d03 postgres!ineq_histogram_selectivity( struct PlannerInfo * root = 0x00000204`4dec7c28, struct VariableStatData * vardata = 0x00000092`7dffeca0, unsigned int opoid = 0x20b, struct FmgrInfo * opproc = 0x00000092`7dffebf0, 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] 00000092`7dffeb50 00007ff7`9adc3021 postgres!scalarineqsel( struct PlannerInfo * root = 0x00000204`4dec7c28, unsigned int operator = 0x20b, bool isgt = false, bool iseq = true, unsigned int collation = 0, struct VariableStatData * vardata = 0x00000092`7dffeca0, unsigned int64 constval = 0x5f5e10a, unsigned int consttype = 0x17)+0x393 [c:\cirrus\src\backend\utils\adt\selfuncs.c @ 688] 00000092`7dffec30 00007ff7`9adb3fc8 postgres!scalarineqsel_wrapper( struct FunctionCallInfoBaseData * fcinfo = 0x00000092`7dffed70, bool isgt = false, bool iseq = true)+0x241 [c:\cirrus\src\backend\utils\adt\selfuncs.c @ 1459] 00000092`7dffed00 00007ff7`9ae55213 postgres!scalarlesel( struct FunctionCallInfoBaseData * fcinfo = 0x00000092`7dffed70)+0x18 [c:\cirrus\src\backend\utils\adt\selfuncs.c @ 1483] 00000092`7dffed30 00007ff7`9ae5607c postgres!FunctionCall4Coll( struct FmgrInfo * flinfo = 0x00000092`7dffee20, unsigned int collation = 0, unsigned int64 arg1 = 0x00000204`4dec7c28, unsigned int64 arg2 = 0x20b, unsigned int64 arg3 = 0x00000204`4dec8298, unsigned int64 arg4 = 0)+0x153 [c:\cirrus\src\backend\utils\fmgr\fmgr.c @ 1213] 00000092`7dffedf0 00007ff7`9aa89f32 postgres!OidFunctionCall4Coll( unsigned int functionId = 0x150, unsigned int collation = 0, unsigned int64 arg1 = 0x00000204`4dec7c28, unsigned int64 arg2 = 0x20b, unsigned int64 arg3 = 0x00000204`4dec8298, unsigned int64 arg4 = 0)+0x5c [c:\cirrus\src\backend\utils\fmgr\fmgr.c @ 1450] 00000092`7dffee60 00007ff7`9a9fbad2 postgres!restriction_selectivity( struct PlannerInfo * root = 0x00000204`4dec7c28, unsigned int operatorid = 0x20b, struct List * args = 0x00000204`4dec8298, unsigned int inputcollid = 0, int varRelid = 0n0)+0xa2 [c:\cirrus\src\backend\optimizer\util\plancat.c @ 1963] 00000092`7dffeed0 00007ff7`9a9fc184 postgres!clause_selectivity_ext( struct PlannerInfo * root = 0x00000204`4dec7c28, struct Node * clause = 0x00000204`4dec8338, 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] 00000092`7dffefa0 00007ff7`9a9fbf10 postgres!clauselist_selectivity_ext( struct PlannerInfo * root = 0x00000204`4dec7c28, struct List * clauses = 0x00000204`4dec8ec0, 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] 00000092`7dfff090 00007ff7`9aa04bad postgres!clauselist_selectivity( struct PlannerInfo * root = 0x00000204`4dec7c28, struct List * clauses = 0x00000204`4dec8ec0, int varRelid = 0n0, JoinType jointype = JOIN_INNER (0n0), struct SpecialJoinInfo * sjinfo = 0x00000000`00000000)+0x40 [c:\cirrus\src\backend\optimizer\path\clausesel.c @ 108] 00000092`7dfff0d0 00007ff7`9a9f66c1 postgres!set_baserel_size_estimates( struct PlannerInfo * root = 0x00000204`4dec7c28, struct RelOptInfo * rel = 0x00000204`4d298440)+0x5d [c:\cirrus\src\backend\optimizer\path\costsize.c @ 5285] 00000092`7dfff120 00007ff7`9a9f62bb postgres!set_plain_rel_size( struct PlannerInfo * root = 0x00000204`4dec7c28, struct RelOptInfo * rel = 0x00000204`4d298440, struct RangeTblEntry * rte = 0x00000204`4d2978f8)+0x31 [c:\cirrus\src\backend\optimizer\path\allpaths.c @ 582] 00000092`7dfff150 00007ff7`9a9f60cd postgres!set_rel_size( struct PlannerInfo * root = 0x00000204`4dec7c28, struct RelOptInfo * rel = 0x00000204`4d298440, unsigned int rti = 1, struct RangeTblEntry * rte = 0x00000204`4d2978f8)+0x11b [c:\cirrus\src\backend\optimizer\path\allpaths.c @ 413] 00000092`7dfff190 00007ff7`9a9f4182 postgres!set_base_rel_sizes( struct PlannerInfo * root = 0x00000204`4dec7c28)+0xdd [c:\cirrus\src\backend\optimizer\path\allpaths.c @ 323] 00000092`7dfff1e0 00007ff7`9aa3fbdb postgres!make_one_rel( struct PlannerInfo * root = 0x00000204`4dec7c28, struct List * joinlist = 0x00000204`4dec8cc0)+0x22 [c:\cirrus\src\backend\optimizer\path\allpaths.c @ 199] 00000092`7dfff230 00007ff7`9aa43925 postgres!query_planner( struct PlannerInfo * root = 0x00000204`4dec7c28, * qp_callback = 0x00007ff7`9aa47450, void * qp_extra = 0x00000092`7dfff550)+0x36b [c:\cirrus\src\backend\optimizer\plan\planmain.c @ 280] 00000092`7dfff290 00007ff7`9aa42b77 postgres!grouping_planner( struct PlannerInfo * root = 0x00000204`4dec7c28, double tuple_fraction = 0, struct SetOperationStmt * setops = 0x00000000`00000000)+0x5f5 [c:\cirrus\src\backend\optimizer\plan\planner.c @ 1520] 00000092`7dfff5a0 00007ff7`9aa40f49 postgres!subquery_planner( struct PlannerGlobal * glob = 0x00000204`4d2975d8, struct Query * parse = 0x00000204`4d2976e8, 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] 00000092`7dfff730 00007ff7`9aa4020c postgres!standard_planner( struct Query * parse = 0x00000204`4d2976e8, char * query_string = 0x00000204`4d296830 "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] 00000092`7dfff870 00007ff7`9ac14234 postgres!planner( struct Query * parse = 0x00000204`4d2976e8, char * query_string = 0x00000204`4d296830 "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] 00000092`7dfff8b0 00007ff7`9ac1444a postgres!pg_plan_query( struct Query * querytree = 0x00000204`4d2976e8, char * query_string = 0x00000204`4d296830 "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] 00000092`7dfff900 00007ff7`9ac1824e postgres!pg_plan_queries( struct List * querytrees = 0x00000204`4d2983f0, char * query_string = 0x00000204`4d296830 "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] 00000092`7dfff970 00007ff7`9ac15c49 postgres!exec_simple_query( char * query_string = 0x00000204`4d296830 "DELETE FROM transition_table_level1. WHERE level1_no BETWEEN 100000000 AND 100000010;")+0x43e [c:\cirrus\src\backend\tcop\postgres.c @ 1203] 00000092`7dfffab0 00007ff7`9ac0fb7d postgres!PostgresMain( char * dbname = 0x00000204`4c983c18 "regression", char * username = 0x00000204`4c9d64b0 "SYSTEM")+0x8e9 [c:\cirrus\src\backend\tcop\postgres.c @ 4770] 00000092`7dfffcc0 00007ff7`9ab14947 postgres!BackendMain( char * startup_data = 0x00000204`4c983c00 "", unsigned int64 startup_data_len = 4)+0x11d [c:\cirrus\src\backend\tcop\backend_startup.c @ 108] 00000092`7dfffd00 00007ff7`9a9d6674 postgres!SubPostmasterMain( int argc = 0n3, char ** argv = 0x00000204`4c962d00)+0x2a7 [c:\cirrus\src\backend\postmaster\launch_backend.c @ 677] 00000092`7dfffd70 00007ff7`9afbd6c9 postgres!main( int argc = 0n3, char ** argv = 0x00000204`4c962d00)+0x2f4 [c:\cirrus\src\backend\main\main.c @ 189] 00000092`7dfffdb0 00007ff7`9afbd61e postgres!invoke_main(void)+0x39 [D:\a\_work\1\s\src\vctools\crt\vcstartup\src\startup\exe_common.inl @ 79] 00000092`7dfffe00 00007ff7`9afbd4de postgres!__scrt_common_main_seh(void)+0x12e [D:\a\_work\1\s\src\vctools\crt\vcstartup\src\startup\exe_common.inl @ 288] 00000092`7dfffe70 00007ff7`9afbd73e postgres!__scrt_common_main(void)+0xe [D:\a\_work\1\s\src\vctools\crt\vcstartup\src\startup\exe_common.inl @ 331] 00000092`7dfffea0 00007ffc`72e04cb0 postgres!mainCRTStartup( void * __formal = 0x00000092`7da33000)+0xe [D:\a\_work\1\s\src\vctools\crt\vcstartup\src\startup\exe_main.cpp @ 17] 00000092`7dfffed0 00007ffc`7459eceb KERNEL32!BaseThreadInitThunk+0x10 00000092`7dffff00 00000000`00000000 ntdll!RtlUserThreadStart+0x2b 1 Id: 248.504 Suspend: 1 Teb: 00000092`7da36000 Unfrozen Child-SP RetAddr Call Site 00000092`7e3ff9f8 00007ffc`7452b77f ntdll!NtWaitForWorkViaWorkerFactory+0x14 00000092`7e3ffa00 00007ffc`72e04cb0 ntdll!TppWorkerThread+0x2df 00000092`7e3ffcf0 00007ffc`7459eceb KERNEL32!BaseThreadInitThunk+0x10 00000092`7e3ffd20 00000000`00000000 ntdll!RtlUserThreadStart+0x2b 2 Id: 248.14e0 Suspend: 1 Teb: 00000092`7da38000 Unfrozen Child-SP RetAddr Call Site 00000092`7e7ffa08 00007ffc`7452b77f ntdll!NtWaitForWorkViaWorkerFactory+0x14 00000092`7e7ffa10 00007ffc`72e04cb0 ntdll!TppWorkerThread+0x2df 00000092`7e7ffd00 00007ffc`7459eceb KERNEL32!BaseThreadInitThunk+0x10 00000092`7e7ffd30 00000000`00000000 ntdll!RtlUserThreadStart+0x2b 3 Id: 248.554 Suspend: 1 Teb: 00000092`7da3a000 Unfrozen Child-SP RetAddr Call Site 00000092`7ebff7b8 00007ffc`720c45ca ntdll!NtFsControlFile+0x14 00000092`7ebff7c0 00007ff7`9ab08dbb KERNELBASE!ConnectNamedPipe+0x6a 00000092`7ebff830 00007ffc`72e04cb0 postgres!pg_signal_thread( void * param = 0x00000000`00000000)+0xcb [c:\cirrus\src\backend\port\win32\signal.c @ 306] 00000092`7ebff930 00007ffc`7459eceb KERNEL32!BaseThreadInitThunk+0x10 00000092`7ebff960 00000000`00000000 ntdll!RtlUserThreadStart+0x2b 4 Id: 248.1794 Suspend: 1 Teb: 00000092`7da3c000 Unfrozen Child-SP RetAddr Call Site 00000092`7efffce8 00007ffc`7207d71e ntdll!NtWaitForSingleObject+0x14 00000092`7efffcf0 00007ff7`9ab0a85c KERNELBASE!WaitForSingleObjectEx+0x8e 00000092`7efffd90 00007ffc`72e04cb0 postgres!pg_timer_thread( void * param = 0x00000000`00000000)+0x4c [c:\cirrus\src\backend\port\win32\timer.c @ 48] 00000092`7efffdd0 00007ffc`7459eceb KERNEL32!BaseThreadInitThunk+0x10 00000092`7efffe00 00000000`00000000 ntdll!RtlUserThreadStart+0x2b PEB at 000000927da33000 InheritedAddressSpace: No ReadImageFileExecOptions: No BeingDebugged: Yes ImageBaseAddress: 00007ff79a670000 NtGlobalFlag: 0 NtGlobalFlag2: 0 Ldr 00007ffc74694140 Ldr.Initialized: Yes Ldr.InInitializationOrderModuleList: 000002044c956f30 . 000002044c9c03b0 Ldr.InLoadOrderModuleList: 000002044c95b190 . 000002044c9c0390 Ldr.InMemoryOrderModuleList: 000002044c95b1a0 . 000002044c9c03a0 Base TimeStamp Module 7ff79a670000 66d4a351 Sep 01 17:24:33 2024 C:\cirrus\build\tmp_install\usr\local\pgsql\bin\postgres.exe 7ffc74520000 86a81be0 Aug 03 17:35:28 2041 C:\Windows\SYSTEM32\ntdll.dll 7ffc72df0000 681d822d May 09 04:18:53 2025 C:\Windows\System32\KERNEL32.DLL 7ffc72040000 7f062417 Jul 13 14:41:27 2037 C:\Windows\System32\KERNELBASE.dll 7ffc72d70000 56e83747 Mar 15 16:24:39 2016 C:\Windows\System32\WS2_32.dll 7ffc726a0000 b05e085f Oct 07 03:15:43 2063 C:\Windows\System32\RPCRT4.dll 7ffc73600000 dc811887 Mar 25 16:25:43 2087 C:\Windows\System32\WLDAP32.dll 7ffc71b10000 eb78ec60 Mar 10 04:43:12 2095 C:\Windows\System32\ucrtbase.dll 7ffc74270000 8b666989 Feb 10 19:18:33 2044 C:\Windows\System32\ADVAPI32.dll 7ffc73dd0000 68e1e0af Oct 05 03:06:23 2025 C:\Windows\System32\msvcrt.dll 7ffc72850000 00dbe574 Jun 16 19:05:24 1970 C:\Windows\System32\sechost.dll 7ffc71c20000 3bdd8bbd Oct 29 17:02:53 2001 C:\Windows\System32\bcrypt.dll 7ffc5df40000 6514993f Sep 27 21:06:07 2023 C:\Windows\SYSTEM32\libssl-1_1-x64.dll 7ffc5d3c0000 6514991d Sep 27 21:05:33 2023 C:\Windows\SYSTEM32\libcrypto-1_1-x64.dll 7ffc73360000 fcfa269f Jun 30 06:58:39 2104 C:\Windows\System32\USER32.dll 7ffc71e30000 2979174f Jan 19 06:14:39 1992 C:\Windows\System32\win32u.dll 7ffc727c0000 784b1edd Dec 14 16:03:41 2033 C:\Windows\System32\GDI32.dll 7ffc71c50000 1e551d70 Feb 15 23:36:16 1986 C:\Windows\System32\gdi32full.dll 7ffc723b0000 e46c287d Jun 10 05:58:21 2091 C:\Windows\System32\msvcp_win.dll 7ffc60740000 c3642e5c Nov 17 05:36:28 2073 C:\Windows\SYSTEM32\Secur32.dll 7ffc5ed90000 653aa20c Oct 26 17:29:48 2023 C:\Windows\SYSTEM32\VCRUNTIME140D.dll 7ffc5d710000 b6102be9 Oct 17 03:52:09 2066 C:\Windows\SYSTEM32\ucrtbased.dll 7ffc5edd0000 653aa20c Oct 26 17:29:48 2023 C:\Windows\SYSTEM32\VCRUNTIME140.dll 7ffc71450000 8199e7b5 Nov 26 01:19:49 2038 C:\Windows\SYSTEM32\SSPICLI.DLL 7ffc70fa0000 06d626ed Aug 20 12:32:45 1973 C:\Windows\system32\mswsock.dll 7ffc60890000 7406c981 Sep 08 02:44:17 2031 C:\Windows\system32\wshunix.dll 7ffc711f0000 ab2bdb14 Jan 01 04:07:48 2061 C:\Windows\SYSTEM32\CRYPTSP.dll 7ffc70ae0000 0ca66aee Sep 22 09:35:42 1976 C:\Windows\system32\rsaenh.dll 7ffc71210000 889c9ae0 Aug 18 08:50:40 2042 C:\Windows\SYSTEM32\CRYPTBASE.dll 7ffc71fc0000 d2c5908f Jan 20 19:29:19 2082 C:\Windows\System32\bcryptPrimitives.dll 7ffc5f430000 66d4a35b Sep 01 17:24:43 2024 C:\cirrus\build\tmp_install\usr\local\pgsql\lib\plpgsql.dll SubSystemData: 0000000000000000 ProcessHeap: 000002044c950000 ProcessParameters: 000002044c95d360 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" 4836' DllPath: '< Name not readable >' Environment: 000002044c9511f0 =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=5064906645438464 CIRRUS_BUILD_SOURCE=github CIRRUS_CHANGE_IN_REPO=d2ce477172e85620ea7728f1ecff0fe047fafe3f 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=1725211281000 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-6172810102439936-df6152e9-1f9c-41c7-a974-0046b600be88 CIRRUS_HTTP_CACHE_HOST=127.0.0.1:12321 CIRRUS_LOG_TIMESTAMP=true CIRRUS_OIDC_TOKEN=eyJraWQiOiJBdjFqQVlqUE54a3g0YUpfVHloeVU0c3p6VXBQMVlXdE0yTEJIckF0ZWgwIiwidHlwIjoiSldUIiwiYWxnIjoiUlMyNTYifQ.eyJvd25lciI6InBvc3RncmVzcWwtY2Zib3QiLCJ0YXNrX25hbWUiOiJXaW5kb3dzIC0gU2VydmVyIDIwMTksIFZTIDIwMTkgLSBNZXNvbiAmIG5pbmphIiwic3ViIjoicmVwbzpnaXRodWI6cG9zdGdyZXNxbC1jZmJvdC9wb3N0Z3Jlc3FsIiwib3duZXJfaWQiOiIzMTE3MzEwNyIsInJlcG9zaXRvcnlfdmlzaWJpbGl0eSI6InB1YmxpYyIsImlzcyI6Imh0dHBzOi8vb2lkYy5jaXJydXMtY2kuY29tIiwidGFza19pZCI6IjYxNzI4MTAxMDI0Mzk5MzYiLCJyZXBvc2l0b3J5IjoicG9zdGdyZXNxbCIsImJyYW5jaCI6ImNmLzUyMjIiLCJwbGF0Zm9ybSI6ImdpdGh1YiIsImF1ZCI6Imh0dHBzOi8vY2lycnVzLWNpLmNvbS9naXRodWIvcG9zdGdyZXNxbC1jZmJvdCIsIm5iZiI6MTcyNTIxMTM4NSwiYnVpbGRfaWQiOiI1MDY0OTA2NjQ1NDM4NDY0IiwidXNlcl9wZXJtaXNzaW9uIjoiYWRtaW4iLCJyZXBvc2l0b3J5X2lkIjoiNTMwOTQyOTkxMjQzNjczNiIsImV4cCI6MTcyNTIxNTU4NSwiaWF0IjoxNzI1MjExMzg1LCJ1c2VyX2NvbGxhYm9yYXRvciI6InRydWUiLCJqdGkiOiJjMDUwOThmMy1lMGNjLTQyNzYtYmE0YS03MmRhYzQ0ZWFkZjkiLCJjaGFuZ2VfaW5fcmVwbyI6ImQyY2U0NzcxNzJlODU2MjBlYTc3MjhmMWVjZmYwZmUwNDdmYWZlM2YifQ.iZTx3MPEvlawkC3zKXV_dGq-6Pb13jjWLQsuYwodsHDICfvLsNnhbJJr9ub--eIH1LIDBfBMvyvNFXFR4EvYwbMhQhRfsDPNl2TUteGpsTBM4OKQPSfKlh8tt4LQF0DIBpiGKJADfM2wgn9-yF401GNNYzQGj2ILZGajkyxzrEVnku60bvARO50TXkvReJyiJ9WYNlnc9LC08yddFfrj6F7QnVs65hgUlnYi3zD0OJIHCQxZxwid6fsWjfbKKiA3fofn_Pa0Gkr7w_A-4Fosq7vLMvV3FydxwO8Vnqqop2u3qSXqu1zrVdxrrLfDYcyTjtmjorJpqZQUhtRC0rkvTw CIRRUS_OS=windows CIRRUS_REPO_CLONE_HOST=github.com CIRRUS_REPO_CLONE_TOKEN=ghs_TFaVN8owahX4eAgkeAGHKNBvY04lah0VuVQ7 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=6172810102439936 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=27851822758 GOOGETROOT=C:\ProgramData\GooGet IMAGE_FAMILY=pg-ci-windows-ci IMAGE_IDENTITY=pg-ci-windows-ci-2024-09-01t00-32-40 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_=106 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/YLjuOLXnE1 PGPORT=17199 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_0900_2024-09-01_17-27-00-744.txt