Fix new recovery test for log_error_verbosity=verbose case

adunstan · adunstan · commit 2eb3f167f991 · 2022-07-29T18:17:17.000-04:00
The new test is from commit 9e4f914. With this setting messages have SQL error numbers included, so that needs to be provided for in the pattern looked for. Backpatch to all live branches like the original.
diff --git a/src/test/recovery/t/033_replay_tsp_drops.pl b/src/test/recovery/t/033_replay_tsp_drops.pl
@@ -139,7 +139,7 @@ sub test_tablespace
 	last
 	  if (
 		find_in_log(
-			$node_standby, "WARNING:  creating missing directory: pg_tblspc/",
+			$node_standby, qr!WARNING: ( [A-Z0-9]+:)? creating missing directory: pg_tblspc/!,
 			$logstart));
 	sleep 1;
 }

Original file line number	Diff line number	Diff line change
`@@ -139,7 +139,7 @@ sub test_tablespace`
`139`	`139`	`last`
`140`	`140`	`if (`
`141`	`141`	`find_in_log(`
`142`		`- $node_standby, "WARNING: creating missing directory: pg_tblspc/",`
	`142`	`+ $node_standby, qr!WARNING: ( [A-Z0-9]+:)? creating missing directory: pg_tblspc/!,`
`143`	`143`	`$logstart));`
`144`	`144`	`sleep 1;`
`145`	`145`	`}`